AP_VendorPurchaseAnalysisWrk AP Vendor Purchase Analysis WorkRel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_VendorPurchaseAnalysis_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_VendorPurchaseAnalysisWrk"+%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 GroupFieldDesc. . . . . . . . 30 SNN Group Field Description . . . . 4 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 5 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 6 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 7 AverageDaysToPay. . . . . . . 3.0 NNN Average Days To Pay . . . . . . 8 AverageDaysOverDue. . . . . . 3.0 NNN Average Days Over Due . . . . . 9 PurchasesPTD. . . . . . . . . 15.2 NNN Purchases Period to Date. . . . 10 PurchasesYTD. . . . . . . . . 16.2 NNN Purchases Year to Date. . . . . 11 PurchasesPY . . . . . . . . . 16.2 NNN Purchases Prior Year. . . . . . 12 PaymentsPTD . . . . . . . . . 15.2 NNN Payments Period to Date . . . . 13 PaymentsYTD . . . . . . . . . 16.2 NNN Payments Year to Date . . . . . 14 PaymentsPY. . . . . . . . . . 16.2 NNN Payments Prior Year . . . . . . 15 DiscountsTakenPTD . . . . . . 15.2 NNN Discounts Taken Period to Date. 16 DiscountsTakenYTD . . . . . . 16.2 NNN Discounts Taken Year to Date. . 17 DiscountsTakenPY. . . . . . . 16.2 NNN Discounts Taken Prior Year. . . 18 DiscountsLostPTD. . . . . . . 15.2 NNN Discounts Lost Period to Date . 19 DiscountsLostYTD. . . . . . . 16.2 NNN Discounts Lost Year to Date . . 20 DiscountsLostPY . . . . . . . 16.2 NNN Discounts Lost Prior Year . . .