AP_VendorPurchHistoryByPdWrk AP Vendor Purchase History By Period Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_VendorPurchHistByPeriod_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_VendorPurchHistoryByPdWrk"+%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 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 5 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 6 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 7 PurchasesPeriod1. . . . . . . 15.2 NNN Purchases Period 1. . . . . . . 8 PurchasesPeriod2. . . . . . . 15.2 NNN Purchases Period 2. . . . . . . 9 PurchasesPeriod3. . . . . . . 15.2 NNN Purchases Period 3. . . . . . . 10 PurchasesPeriod4. . . . . . . 15.2 NNN Purchases Period 4. . . . . . . 11 PurchasesPeriod5. . . . . . . 15.2 NNN Purchases Period 5. . . . . . . 12 PurchasesPeriod6. . . . . . . 15.2 NNN Purchases Period 6. . . . . . . 13 PurchasesPeriod7. . . . . . . 15.2 NNN Purchases Period 7. . . . . . . 14 PurchasesPeriod8. . . . . . . 15.2 NNN Purchases Period 8. . . . . . . 15 PurchasesPeriod9. . . . . . . 15.2 NNN Purchases Period 9. . . . . . . 16 PurchasesPeriod10 . . . . . . 15.2 NNN Purchases Period 10 . . . . . . 17 PurchasesPeriod11 . . . . . . 15.2 NNN Purchases Period 11 . . . . . . 18 PurchasesPeriod12 . . . . . . 15.2 NNN Purchases Period 12 . . . . . . 19 PurchasesPeriod13 . . . . . . 15.2 NNN Purchases Period 13 . . . . . . 20 PurchasesPeriod1PY. . . . . . 15.2 NNN Purchases Period 1 Prior Year . 21 PurchasesPeriod2PY. . . . . . 15.2 NNN Purchases Period 2 Prior Year . 22 PurchasesPeriod3PY. . . . . . 15.2 NNN Purchases Period 3 Prior Year . 23 PurchasesPeriod4PY. . . . . . 15.2 NNN Purchases Period 4 Prior Year . 24 PurchasesPeriod5PY. . . . . . 15.2 NNN Purchases Period 5 Prior Year . 25 PurchasesPeriod6PY. . . . . . 15.2 NNN Purchases Period 6 Prior Year . 26 PurchasesPeriod7PY. . . . . . 15.2 NNN Purchases Period 7 Prior Year . 27 PurchasesPeriod8PY. . . . . . 15.2 NNN Purchases Period 8 Prior Year . 28 PurchasesPeriod9PY. . . . . . 15.2 NNN Purchases Period 9 Prior Year . 29 PurchasesPeriod10PY . . . . . 15.2 NNN Purchases Period 10 Prior Year. 30 PurchasesPeriod11PY . . . . . 15.2 NNN Purchases Period 11 Prior Year. 31 PurchasesPeriod12PY . . . . . 15.2 NNN Purchases Period 12 Prior Year. 32 PurchasesPeriod13PY . . . . . 15.2 NNN Purchases Period 13 Prior Year. 33 PaymentsPeriod1 . . . . . . . 15.2 NNN Payments Period 1 . . . . . . . 34 PaymentsPeriod2 . . . . . . . 15.2 NNN Payments Period 2 . . . . . . . 35 PaymentsPeriod3 . . . . . . . 15.2 NNN Payments Period 3 . . . . . . . 36 PaymentsPeriod4 . . . . . . . 15.2 NNN Payments Period 4 . . . . . . . 37 PaymentsPeriod5 . . . . . . . 15.2 NNN Payments Period 5 . . . . . . . 38 PaymentsPeriod6 . . . . . . . 15.2 NNN Payments Period 6 . . . . . . . 39 PaymentsPeriod7 . . . . . . . 15.2 NNN Payments Period 7 . . . . . . . 40 PaymentsPeriod8 . . . . . . . 15.2 NNN Payments Period 8 . . . . . . . 41 PaymentsPeriod9 . . . . . . . 15.2 NNN Payments Period 9 . . . . . . . 42 PaymentsPeriod10. . . . . . . 15.2 NNN Payments Period 10. . . . . . . 43 PaymentsPeriod11. . . . . . . 15.2 NNN Payments Period 11. . . . . . . 44 PaymentsPeriod12. . . . . . . 15.2 NNN Payments Period 12. . . . . . . 45 PaymentsPeriod13. . . . . . . 15.2 NNN Payments Period 13. . . . . . . 46 PaymentsPeriod1PY . . . . . . 15.2 NNN Payments Period 1 Prior Year. . 47 PaymentsPeriod2PY . . . . . . 15.2 NNN Payments Period 2 Prior Year. . 48 PaymentsPeriod3PY . . . . . . 15.2 NNN Payments Period 3 Prior Year. . 49 PaymentsPeriod4PY . . . . . . 15.2 NNN Payments Period 4 Prior Year. . 50 PaymentsPeriod5PY . . . . . . 15.2 NNN Payments Period 5 Prior Year. . 51 PaymentsPeriod6PY . . . . . . 15.2 NNN Payments Period 6 Prior Year. . 52 PaymentsPeriod7PY . . . . . . 15.2 NNN Payments Period 7 Prior Year. . 53 PaymentsPeriod8PY . . . . . . 15.2 NNN Payments Period 8 Prior Year. . 54 PaymentsPeriod9PY . . . . . . 15.2 NNN Payments Period 9 Prior Year. . 55 PaymentsPeriod10PY. . . . . . 15.2 NNN Payments Period 10 Prior Year . 56 PaymentsPeriod11PY. . . . . . 15.2 NNN Payments Period 11 Prior Year . 57 PaymentsPeriod12PY. . . . . . 15.2 NNN Payments Period 12 Prior Year . 58 PaymentsPeriod13PY. . . . . . 15.2 NNN Payments Period 13 Prior Year . 59 DiscountsTakenPeriod1 . . . . 15.2 NNN Discounts Taken Period 1. . . . 60 DiscountsTakenPeriod2 . . . . 15.2 NNN Discounts Taken Period 2. . . . 61 DiscountsTakenPeriod3 . . . . 15.2 NNN Discounts Taken Period 3. . . . 62 DiscountsTakenPeriod4 . . . . 15.2 NNN Discounts Taken Period 4. . . . 63 DiscountsTakenPeriod5 . . . . 15.2 NNN Discounts Taken Period 5. . . . 64 DiscountsTakenPeriod6 . . . . 15.2 NNN Discounts Taken Period 6. . . . 65 DiscountsTakenPeriod7 . . . . 15.2 NNN Discounts Taken Period 7. . . . 66 DiscountsTakenPeriod8 . . . . 15.2 NNN Discounts Taken Period 8. . . . 67 DiscountsTakenPeriod9 . . . . 15.2 NNN Discounts Taken Period 9. . . . 68 DiscountsTakenPeriod10. . . . 15.2 NNN Discounts Taken Period 10 . . . 69 DiscountsTakenPeriod11. . . . 15.2 NNN Discounts Taken Period 11 . . . 70 DiscountsTakenPeriod12. . . . 15.2 NNN Discounts Taken Period 12 . . . 71 DiscountsTakenPeriod13. . . . 15.2 NNN Discounts Taken Period 13 . . . 72 DiscountsTakenPeriod1PY . . . 15.2 NNN Discounts Taken Period 1 Prior 73 DiscountsTakenPeriod2PY . . . 15.2 NNN Discounts Taken Period 2 Prior 74 DiscountsTakenPeriod3PY . . . 15.2 NNN Discounts Taken Period 3 Prior 75 DiscountsTakenPeriod4PY . . . 15.2 NNN Discounts Taken Period 4 Prior 76 DiscountsTakenPeriod5PY . . . 15.2 NNN Discounts Taken Period 5 Prior 77 DiscountsTakenPeriod6PY . . . 15.2 NNN Discounts Taken Period 6 Prior 78 DiscountsTakenPeriod7PY . . . 15.2 NNN Discounts Taken Period 7 Prior 79 DiscountsTakenPeriod8PY . . . 15.2 NNN Discounts Taken Period 8 Prior 80 DiscountsTakenPeriod9PY . . . 15.2 NNN Discounts Taken Period 9 Prior 81 DiscountsTakenPeriod10PY. . . 15.2 NNN Discounts Taken Period 10 Prior 82 DiscountsTakenPeriod11PY. . . 15.2 NNN Discounts Taken Period 11 Prior 83 DiscountsTakenPeriod12PY. . . 15.2 NNN Discounts Taken Period 12 Prior 84 DiscountsTakenPeriod13PY. . . 15.2 NNN Discounts Taken Period 13 Prior 85 DiscountsLostPeriod1. . . . . 15.2 NNN Discounts Lost Period 1 . . . . 86 DiscountsLostPeriod2. . . . . 15.2 NNN Discounts Lost Period 2 . . . . 87 DiscountsLostPeriod3. . . . . 15.2 NNN Discounts Lost Period 3 . . . . 88 DiscountsLostPeriod4. . . . . 15.2 NNN Discounts Lost Period 4 . . . . 89 DiscountsLostPeriod5. . . . . 15.2 NNN Discounts Lost Period 5 . . . . 90 DiscountsLostPeriod6. . . . . 15.2 NNN Discounts Lost Period 6 . . . . 91 DiscountsLostPeriod7. . . . . 15.2 NNN Discounts Lost Period 7 . . . . 92 DiscountsLostPeriod8. . . . . 15.2 NNN Discounts Lost Period 8 . . . . 93 DiscountsLostPeriod9. . . . . 15.2 NNN Discounts Lost Period 9 . . . . 94 DiscountsLostPeriod10 . . . . 15.2 NNN Discounts Lost Period 10. . . . 95 DiscountsLostPeriod11 . . . . 15.2 NNN Discounts Lost Period 11. . . . 96 DiscountsLostPeriod12 . . . . 15.2 NNN Discounts Lost Period 12. . . . 97 DiscountsLostPeriod13 . . . . 15.2 NNN Discounts Lost Period 13. . . . 98 DiscountsLostPeriod1PY. . . . 15.2 NNN Discounts Lost Period 1 Prior Y 99 DiscountsLostPeriod2PY. . . . 15.2 NNN Discounts Lost Period 2 Prior Y 100 DiscountsLostPeriod3PY. . . . 15.2 NNN Discounts Lost Period 3 Prior Y 101 DiscountsLostPeriod4PY. . . . 15.2 NNN Discounts Lost Period 4 Prior Y 102 DiscountsLostPeriod5PY. . . . 15.2 NNN Discounts Lost Period 5 Prior Y 103 DiscountsLostPeriod6PY. . . . 15.2 NNN Discounts Lost Period 6 Prior Y 104 DiscountsLostPeriod7PY. . . . 15.2 NNN Discounts Lost Period 7 Prior Y 105 DiscountsLostPeriod8PY. . . . 15.2 NNN Discounts Lost Period 8 Prior Y 106 DiscountsLostPeriod9PY. . . . 15.2 NNN Discounts Lost Period 9 Prior Y 107 DiscountsLostPeriod10PY . . . 15.2 NNN Discounts Lost Period 10 Prior 108 DiscountsLostPeriod11PY . . . 15.2 NNN Discounts Lost Period 11 Prior 109 DiscountsLostPeriod12PY . . . 15.2 NNN Discounts Lost Period 12 Prior 110 DiscountsLostPeriod13PY . . . 15.2 NNN Discounts Lost Period 13 Prior 111 TotalPurchases. . . . . . . . 15.2 NNN Total Purchases . . . . . . . . 112 TotalPurchasesPY. . . . . . . 15.2 NNN Total Purchases Prior Year. . . 113 TotalPayments . . . . . . . . 15.2 NNN Total Payments. . . . . . . . . 114 TotalPaymentsPY . . . . . . . 15.2 NNN Total Payments Prior Year . . . 115 TotalDiscountsTaken . . . . . 15.2 NNN Total Discounts Taken . . . . . 116 TotalDiscountsTakenPY . . . . 15.2 NNN Total Discounts Taken Prior Yea 117 TotalDiscountsLost. . . . . . 15.2 NNN Total Discounts Lost. . . . . . 118 TotalDiscountsLostPY. . . . . 15.2 NNN Total Discounts Lost Prior Year