AP_VendorMailingLabelsWrk AP Vendor Mailing Labels Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_VendorMailingLabels_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_VendorMailingLabelsWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 4 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 5 LabelNumber . . . . . . . . . 3 SNN Label Number. . . . . . . . . . 6 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 7 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . . 8 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . . 9 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . . 10 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . . 11 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . . 12 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . . 13 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . . 14 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . . 15 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 16 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . . 17 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 18 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 19 VendorSortField . . . . . . . 10 SNN Vendor Sort Field . . . . . . . 20 Comment . . . . . . . . . . . 30 SNN Customer Comment. . . . . . . . 21 VendorReferenceNo . . . . . . 15 SNN Vendor Reference Number . . . . 22 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 23 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 24 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 25 TaxpayerIDSocialSecurityNo. . 9 SNN Taxpayer ID/Social Security Num 26 BalanceDue. . . . . . . . . . 16.2 NNN Balance Due . . . . . . . . . . 27 PurchasesMTD. . . . . . . . . 16.2 NNN Purchases Month To Date . . . . 28 PurchasesYTD. . . . . . . . . 16.2 NNN Purchases Year To Date. . . . . 29 PurchasesPY . . . . . . . . . 16.2 NNN Purchases Prior Year. . . . . .