AP_VendorListingBalWrk AP Vendor Listing Balance Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_VendorListingBal_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_VendorListingBalWrk"+%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 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 6 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . . 7 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . . 8 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . . 9 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . . 10 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . . 11 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . . 12 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . . 13 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . . 14 PrimaryContact. . . . . . . . 10 SNN Primary Contact Code. . . . . . 15 PrimaryContactName. . . . . . 30 SNN Primary Contact Name. . . . . . 16 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 17 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . . 18 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 19 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . . 20 URLAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . . 21 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 22 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 23 Reference . . . . . . . . . . 15 SNN Reference . . . . . . . . . . . 24 TemporaryVendor . . . . . . . 1 SNN Temporary Vendor. . . . . . . . 25 CreditCardVendor. . . . . . . 1 SNN Credit Card Vendor. . . . . . . 26 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . . 27 ExemptionNoOnFile . . . . . . 1 SNN Exemption Number on File. . . . 28 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 29 TaxScheduleDesc . . . . . . . 30 SNN Tax Schedule Description. . . . 30 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 31 TaxClassDesc. . . . . . . . . 30 SNN Tax Class Description . . . . . 32 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 33 Account . . . . . . . . . . . 41 SNN Fully Formatted Account . . . . 34 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 35 SeparateCheck . . . . . . . . 1 SNN Separate Check. . . . . . . . . 36 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 37 Sort. . . . . . . . . . . . . 10 SNN Vendor Sort Field . . . . . . . 38 BatchFax. . . . . . . . . . . 1 SNN Batch Fax . . . . . . . . . . . 39 UsePOReceiptOfInvForVendor. . 1 SNN Use PO Receipt Of Inv For Vendo 40 PrimaryPurchaseAddressCode. . 4 SNN Purchase Address Code . . . . . 41 VendorType. . . . . . . . . . 1 SNN Vendor Type . . . . . . . . . . 42 Form1099. . . . . . . . . . . 1 SNN Default 1099 Form . . . . . . . 43 TaxpayerIDSocialSecurityNo. . 9 SNN Taxpayer ID/Social Security Num 44 Box1099 . . . . . . . . . . . 3 SNN Default 1099 Box. . . . . . . . 45 MiscBox9. . . . . . . . . . . 1 SNN Mark Misc Box 9 . . . . . . . . 46 RemitToVendorName . . . . . . 30 SNN Remit To Vendor Name. . . . . . 47 RemitToAddressLine1 . . . . . 30 SNN Remit To Address Line 1 . . . . 48 RemitToAddressLine2 . . . . . 30 SNN Remit To Address Line 2 . . . . 49 RemitToAddressLine3 . . . . . 30 SNN Remit To Address Line 3 . . . . 50 RemitToCity . . . . . . . . . 20 SNN Remit To City . . . . . . . . . 51 RemitToState. . . . . . . . . 2 SNN Remit To State. . . . . . . . . 52 RemitToZipCode. . . . . . . . 10 SNN Remit To Zip Code . . . . . . . 53 RemitToCountryCode. . . . . . 3 SNN Remit To Country Code . . . . . 54 RemitToCountryName. . . . . . 30 SNN Remit To Country Name . . . . . 55 RemitToContactCode. . . . . . 10 SNN Remit To Contact Code . . . . . 56 RemitToContactName. . . . . . 30 SNN Remit To Contact Name . . . . . 57 RemitToTelephoneNo. . . . . . 17 SNN Remit To Telephone Number . . . 58 RemitToTelephoneExt . . . . . 5 SNN Remit To Telephone Extension. . 59 LastPurchaseDate. . . . . . . 8 SNN Last Purchase Date. . . . . . .DATE 60 LastPaymentDate . . . . . . . 8 SNN Last Payment Date . . . . . . .DATE 61 LastCheckNo . . . . . . . . . 10 SNN Last AP Check Number. . . . . . 62 FiscalPeriod. . . . . . . . . 2 SNN Fiscal Period . . . . . . . . . 63 LastCheckAmt. . . . . . . . . 15.2 NNN Last Check Amount . . . . . . . 64 RetentionRate . . . . . . . . 7.2 NNN Retention Rate. . . . . . . . . 65 AverageDaysToPay. . . . . . . 3.0 NNN Average Days To Pay . . . . . . 66 AverageDaysOverDue. . . . . . 3.0 NNN Average Days Over Due . . . . . 67 BalanceDue. . . . . . . . . . 16.2 NNN Balance Due . . . . . . . . . . 68 PurchasesPTD. . . . . . . . . 15.2 NNN Purchases Period To Date. . . . 69 PurchasesYTD. . . . . . . . . 16.2 NNN Purchases Year To Date. . . . . 70 PurchasesPY . . . . . . . . . 16.2 NNN Purchases Prior Year. . . . . . 71 PaymentsPTD . . . . . . . . . 15.2 NNN Payments Period To Date . . . . 72 PaymentsYTD . . . . . . . . . 16.2 NNN Payments Year To Date . . . . . 73 PaymentsPY. . . . . . . . . . 16.2 NNN Payments Prior Year . . . . . . 74 DiscountsTakenPTD . . . . . . 15.2 NNN Discounts Taken Period To Date. 75 DiscountsTakenYTD . . . . . . 16.2 NNN Discounts Taken Year To Date. . 76 DiscountsTakenPY. . . . . . . 16.2 NNN Discounts Taken Prior Year. . . 77 DiscountsLostPTD. . . . . . . 15.2 NNN Discounts Lost Period To Date . 78 DiscountsLostYTD. . . . . . . 16.2 NNN Discounts Lost Year To Date . . 79 DiscountsLostPY . . . . . . . 16.2 NNN Discounts Lost Prior Year . . .