Importing Vendors Check Address
Multicurrency Users
The VENDOR_CURRENCYTYPE field is only available if this module is installed and added to the organization by the Administrator (Organization>Add a Module).
The following table defines the field references to be used in the Vendor Information section of the MasterAP.DEF file:
| Table: tblAddressCodes | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,VENDADDR_CODES,HEADER,HVENDCHCKADDR | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
AC_PARN_ID |
Y |
User Defined |
|
Same as Vendor ID. |
|
AC_ADDRESS_ID |
Y |
User Defined |
|
Check Address Code |
|
AC_STATUS |
Y |
1 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
AC_SAME_AS |
Y |
Interger |
Main |
None = 0; Main = 1, or PO = 2 |
|
AC_PREFERRED |
Y |
3 |
Yes |
|
|
AC_DESCRIPTION |
Y |
User Defined |
Check Address Code Description |
|
|
AC_ADDRESS |
N |
80 |
Check Address. Use "^" to separate address lines. |
|
|
AC_CITY |
N |
30 |
Check Address City |
|
|
AC_STATE |
N |
6 |
Check Address State or Province |
|
|
AC_ZIP |
N |
10 |
Check Address Postal Code |
|
|
AC_COUNTRY |
N |
35 |
Check Address Country |
|
|
AC_CONTACT_PHONE |
N |
25 |
Check Address Phone |
|
|
AC_CONTACT_FAX |
N |
25 |
Check Address Fax |
|
|
AC_CONTACT_TITLE |
N |
10 |
Check Address Contact Title |
|
|
AC_CONTACT_ |
N |
30 |
Check Address Contact First Name |
|
|
AC_CONTACT_ |
N |
1 |
Check Address Contact Middle Initial |
|
|
AC_CONTACT_ |
N |
30 |
Check Address Contact Last Name |
|
|
AC_CONTACT_POSITION |
N |
30 |
Check Address Contact Job Position |
|
|
AC_CONTACT_EMAIL |
N |
50 |
Check Contact Email Address |
|
Vendor Check Address can only be imported with a full vendor record.