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$