AP_Vendor AP Vendor Master Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_Vendor_bus,AP_ARClearingRegister_upd,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,AP_C
SQL Def: N SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_Vendor.M4T"
KPRIMARY: APDivisionNo+VendorNo
KNAME: VendorName+APDivisionNo+VendorNo
KSORT: Sort+APDivisionNo+VendorNo
KZIPCODE: ZipCode+APDivisionNo+VendorNo
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AP1$(1,2)}
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{AP1$(3,7)}
3 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME
Notes: {AP1$(10,30)}
4 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . .ADDRESSLINE
Notes: {AP1$(40,30)}
5 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . .ADDRESSLINE
Notes: {AP1$(70,30)}
6 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . .ADDRESSLINE
Notes: {AP1$(306,30)}
7 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .CITY
Notes: {AP1$(100,20)}
8 State . . . . . . . . . . . . 2 SYN State . . . . . . . . . . . . .STATE
Notes: {AP1$(120,2)}
9 ZipCode . . . . . . . . . . . 10 SYN Zip Code. . . . . . . . . . . .ZIPCODE
Notes: {AP1$(122,10)}
10 CountryCode . . . . . . . . . 3 SYN Country Code. . . . . . . . . .COUNTRY
Notes: {AP1$(172,3)}
11 PrimaryContact. . . . . . . . 10 SYN Primary Contact Code. . . . . .APCONTACT
Notes: {AP1$(162,10)}
12 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .TELEPHONENO
Notes: {AP1$(132,17)}
13 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . .TELEPHONEEXT
Notes: {AP1$(149,5)}
14 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
DepVal:REQUIRED Notes:
{AP1$(336,17)}
15 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
Notes: {AP1$(353,50)}
16 URLAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . .URLADDRESS
Notes: {AP1$(403,50)}
17 TermsCode . . . . . . . . . . 2 SYY Terms Code. . . . . . . . . . .APTERMS
DfltVal:00 Mask:00 FmtType:ZE
ROFILL Notes: {AP1$(217,2)}
18 Reference . . . . . . . . . . 15 SNN Vendor Reference Number . . . .
Notes: {AP1$(192,15)}
19 TemporaryVendor . . . . . . . 1 SYN Temporary Vendor. . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP1$(258,1)}
20 CreditCardVendor. . . . . . . 1 SYN Credit Card Vendor. . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP1$(453,1)}
21 HoldPayment . . . . . . . . . 1 SYN Hold Payment. . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP1$(259,1)}
22 ExemptionNoOnFile . . . . . . 1 SYN Exemption Number On File. . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP1$(154,1)}
23 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
Notes: {AP1$(175,9)}
24 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
DfltVal:NT Notes: {AP1$(184,
2)}
25 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . .ACCOUNT
Notes: {AP1$(219,9)}
26 SeparateCheck . . . . . . . . 1 SYN Separate Check. . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP1$(288,1)}
27 Comment . . . . . . . . . . . 30 SNN Vendor Comment. . . . . . . . .COMMENT30
Notes: {AP1$(228,30)}
28 Sort. . . . . . . . . . . . . 10 SYN Sort Field. . . . . . . . . . .
Notes: {AP1$(207,10)}
29 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP1$(188,1)}
30 UsePOReceiptOfInvForVendor. . 1 SNN Use PO Receipt Of Inv For VendoYESNO
DfltVal:N Valid:Y,N
31 PrimaryPurchaseAddressCode. . 4 SNN Purchase Address Code . . . . .PURCHASEADDRCODE
32 VendorType. . . . . . . . . . 1 SYN Vendor Type . . . . . . . . . .
DfltVal:N Valid:N,B,I
ValGroup:TEN99 Notes: N=None,
B=Business, I=Individual
{AP1$(260,1)}
33 Form1099. . . . . . . . . . . 1 SYN Default 1099 Form . . . . . . .FORM1099
DfltVal:N Valid:N,M,I,D
DepVal:REQUIRED ValGroup:TEN9
9 Notes: N=None, M=Miscellane
ous, I=Interest, D=Dividend
{AP1$(303,1)}
34 TaxpayerIDSocialSecurityNo. . 9 SNN Taxpayer ID/Social Security Num
ValGroup:TEN99 Notes:
{AP1$(261,9)}
35 Box1099 . . . . . . . . . . . 3 SNN Default 1099 Box. . . . . . . .BOX1099
ValGroup:TEN99 Notes:
{AP1$(304,2)}
36 MiscBox9. . . . . . . . . . . 1 SYN Mark Misc Box 9 . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:TEN99 Notes:
{AP1$(187,1)}
37 LastPurchaseDate. . . . . . . 8 SNN Last Purchase Date. . . . . . .DATE
ValGroup:EDITSTATS ChngTag:Ma
x Notes: {AP1$(270,6)}
38 LastPaymentDate . . . . . . . 8 SNN Last Payment Date . . . . . . .DATE
ValGroup:EDITSTATS ChngTag:Ma
x Notes: {AP1$(276,6)}
39 LastCheckNo . . . . . . . . . 10 SNN Last AP Check Number. . . . . .APCHECKNO
FmtType:ALPHANUM ValGroup:EDI
TSTATS ChngTag:CopyMax/LastPa
ymentDate$ Notes: {AP1$(282,
6)}
40 LastCheckAmt. . . . . . . . . 15.2 NNN Last Check Amount . . . . . . .
Mask:##,###,###,###.00-
ValGroup:EDITSTATS ChngTag:Co
pyMax/LastPaymentDate$
Notes: {AP1[13]}
41 RetentionRate . . . . . . . . 7.2 NNN Retention Rate. . . . . . . . .
Mask:###.00- Notes:
{AP1$(289,6)}
42 AverageDaysToPay. . . . . . . 3.0 NNN Average Days To Pay . . . . . .
Mask:000 ValGroup:EDITSTATS
Notes: {AP1$(295,3)}
43 AverageDaysOverDue. . . . . . 3.0 NNN Average Days Over Due . . . . .
Mask:000 ValGroup:EDITSTATS
Notes: {AP1$(298,3)}
44 BalanceDue. . . . . . . . . . 16.2 NNN Balance Due . . . . . . . . . .TRANSACTIONAMT
Mask:########0.00 ValGroup:ED
ITSTATS ChngTag:Sum Notes:
{AP1[0]}
45 NumberOfInvToUseInCalc. . . . 7.0 NNN Number Of Invoices To Use In Ca
Notes: Of Avg Days For Pymnt
& Overdue {AP1$(301,2)}
46 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y ChngTag:Min
Notes: YYYYMMDD
47 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y ChngTag:CopyMin/D
ateCreated$
48 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
ChngTag:CopyMin/DateCreated$
49 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y ChngTag:Max
Notes: YYYYMMDD
50 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y ChngTag:CopyMax/D
ateUpdated$
51 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
ChngTag:CopyMax/DateUpdated$