| Name |
Type |
Length |
Decimal |
Relation |
Description |
| VENDNUM |
String |
10 |
|
|
AP VENDOR MASTER VENDNUM - Vendor vumber |
| NAME |
String |
30 |
|
|
AP VENDOR MASTER NAME - Vendor name |
| ADDRESS1 |
String |
30 |
|
|
AP VENDOR MASTER ADDRESS1 - Vendor address 1 |
| ADDRESS2 |
String |
30 |
|
|
AP VENDOR MASTER ADDRESS2 - Vendor address 2 |
| CITY |
String |
20 |
|
|
AP VENDOR MASTER CITY - Vendor city |
| STATE |
String |
10 |
|
|
AP VENDOR MASTER STATE - Vendor state |
| ZIP |
String |
10 |
|
|
AP VENDOR MASTER ZIP - Vendor zip |
| COUNTRY |
String |
20 |
|
|
AP VENDOR MASTER COUNTRY - Vendor country |
| EMAIL |
String |
4 |
|
|
AP VENDOR MASTER EMAIL - Vendor's email adress |
| PHONE |
String |
10 |
|
|
AP VENDOR MASTER PHONE - Vendor phone number |
| EXT |
String |
5 |
|
|
AP VENDOR MASTER EXT - Extension number |
| FAX |
String |
15 |
|
|
AP VENDOR MASTER FAX - Vendor fax number |
| CONTACT |
String |
30 |
|
|
AP VENDOR MASTER CONTACT - Vendor contact |
| REFERENCE |
String |
20 |
|
|
AP VENDOR MASTER REFERENCE - Vendor's reference number (companies' account number with the vendor) |
| TERMCODE |
String |
2 |
|
|
AP VENDOR MASTER TERMCODE - Vendor term code |
| DEFEXP |
String |
12 |
|
|
AP VENDOR MASTER DEFEXP - Default accounts payable general ledger expense account number |
| DEFAP |
String |
12 |
|
|
AP VENDOR MASTER DEFAP - Default accounts payable general ledger account number |
| DEFDISC |
String |
12 |
|
|
AP VENDOR MASTER DEFDISC - Default general ledger discount account number |
| VEN_T1099 |
String |
1 |
|
|
AP VENDOR MASTER VEN_T1099 - The 1099 status (I=individual,B=Business,N=none) |
| SPEC_1099 |
String |
1 |
|
|
AP VENDOR MASTER SPEC_1099 - **** not used *** |
| IDSSN |
String |
11 |
|
|
AP VENDOR MASTER IDSSN - Taxpayer ID / Social Security Number |
| BOX1099 |
String |
2 |
|
|
AP VENDOR MASTER BOX1099 - The form 1099 box number to record payments |
| FORM1099 |
String |
1 |
|
|
AP VENDOR MASTER FORM1099 - The 1099 form type to use for the vendor (I=individual,B=business,N=None) |
| CURCODE |
String |
3 |
|
|
AP VENDOR MASTER CURCODE - Currency code if using foreign currency |
| LPAYDATE |
DateTime |
8 |
|
|
AP VENDOR MASTER LPAYDATE - The date of the last payment |
| LINVDATE |
DateTime |
8 |
|
|
AP VENDOR MASTER LINVDATE - The date of the last invoice entered. |
| MEMO |
String |
4 |
|
|
AP VENDOR MASTER MEMO - Vendor notes |
| TAKEDISC |
Boolean |
1 |
|
|
AP VENDOR MASTER TAKEDISC - Always Take Discount (Y/N) |
| HOLD |
Boolean |
1 |
|
|
AP VENDOR MASTER HOLD - Hold payments flag (Y/N) |
| ISINACTIVE |
Boolean |
1 |
|
|
AP VENDOR MASTER ISINACTIVE - True=vendor is inactive |
| AREACODE |
String |
10 |
|
|
AP VENDOR MASTER AREACODE - Area Code |
| AREAFAX |
String |
10 |
|
|
AP VENDOR MASTER AREAFAX - Area code of fox |
| AUTOPOS |
Boolean |
1 |
|
|
AP VENDOR MASTER AUTOPOS - Automatically create purchase orders |
| USERID |
String |
4 |
|
|
AP USERID |
| PAYTYPE |
Int32 |
4 |
|
|
AP PAYTYPE |
| TAXABLE |
Boolean |
1 |
|
|
AP TAXABLE |
| DEPPERC |
Decimal |
6 |
2 |
|
AP DEPPERC |
| TPVENDNUM |
String |
30 |
|
|
AP TPVENDNUM |
| TPCODE |
String |
10 |
|
|
AP TPCODE |
| NONINVENT |
Boolean |
1 |
|
|
AP NONINVENT |