AR_CustomerSlsHistByPerWrk AR Customer Sales History By Period WRel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CustomerSlsHistByPer_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerSlsHistByPerWrk"+%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 GroupField2 . . . . . . . . . 4 SNN Group Field2. . . . . . . . . . 4 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 5 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 6 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 7 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 8 DollarsSoldPer1 . . . . . . . 15.2 NNN Dollars Sold Period 1 . . . . . 9 DollarsSoldPer2 . . . . . . . 15.2 NNN Dollars Sold Period 2 . . . . . 10 DollarsSoldPer3 . . . . . . . 15.2 NNN Dollars Sold Period 3 . . . . . 11 DollarsSoldPer4 . . . . . . . 15.2 NNN Dollars Sold Period 4 . . . . . 12 DollarsSoldPer5 . . . . . . . 15.2 NNN Dollars Sold Period 5 . . . . . 13 DollarsSoldPer6 . . . . . . . 15.2 NNN Dollars Sold Period 6 . . . . . 14 DollarsSoldPer7 . . . . . . . 15.2 NNN Dollars Sold Period 7 . . . . . 15 DollarsSoldPer8 . . . . . . . 15.2 NNN Dollars Sold Period 8 . . . . . 16 DollarsSoldPer9 . . . . . . . 15.2 NNN Dollars Sold Period 9 . . . . . 17 DollarsSoldPer10. . . . . . . 15.2 NNN Dollars Sold Period 10. . . . . 18 DollarsSoldPer11. . . . . . . 15.2 NNN Dollars Sold Period 11. . . . . 19 DollarsSoldPer12. . . . . . . 15.2 NNN Dollars Sold Period 12. . . . . 20 DollarsSoldPer13. . . . . . . 15.2 NNN Dollars Sold Period 13. . . . . 21 DollarsSoldPer1PY . . . . . . 15.2 NNN Dollars Sold Period 1 Prior Yea 22 DollarsSoldPer2PY . . . . . . 15.2 NNN Dollars Sold Period 2 Prior Yea 23 DollarsSoldPer3PY . . . . . . 15.2 NNN Dollars Sold Period 3 Prior Yea 24 DollarsSoldPer4PY . . . . . . 15.2 NNN Dollars Sold Period 4 Prior Yea 25 DollarsSoldPer5PY . . . . . . 15.2 NNN Dollars Sold Period 5 Prior Yea 26 DollarsSoldPer6PY . . . . . . 15.2 NNN Dollars Sold Period 6 Prior Yea 27 DollarsSoldPer7PY . . . . . . 15.2 NNN Dollars Sold Period 7 Prior Yea 28 DollarsSoldPer8PY . . . . . . 15.2 NNN Dollars Sold Period 8 Prior Yea 29 DollarsSoldPer9PY . . . . . . 15.2 NNN Dollars Sold Period 9 Prior Yea 30 DollarsSoldPer10PY. . . . . . 15.2 NNN Dollars Sold Period 10 Prior Ye 31 DollarsSoldPer11PY. . . . . . 15.2 NNN Dollars Sold Period 11 Prior Ye 32 DollarsSoldPer12PY. . . . . . 15.2 NNN Dollars Sold Period 12 Prior Ye 33 DollarsSoldPer13PY. . . . . . 15.2 NNN Dollars Sold Period 13 Prior Ye 34 CostOfGoodsSoldPer1 . . . . . 15.2 NNN Cost of Goods Sold Period 1 . . 35 CostOfGoodsSoldPer2 . . . . . 15.2 NNN Cost of Goods Sold Period 2 . . 36 CostOfGoodsSoldPer3 . . . . . 15.2 NNN Cost of Goods Sold Period 3 . . 37 CostOfGoodsSoldPer4 . . . . . 15.2 NNN Cost of Goods Sold Period 4 . . 38 CostOfGoodsSoldPer5 . . . . . 15.2 NNN Cost of Goods Sold Period 5 . . 39 CostOfGoodsSoldPer6 . . . . . 15.2 NNN Cost of Goods Sold Period 6 . . 40 CostOfGoodsSoldPer7 . . . . . 15.2 NNN Cost of Goods Sold Period 7 . . 41 CostOfGoodsSoldPer8 . . . . . 15.2 NNN Cost of Goods Sold Period 8 . . 42 CostOfGoodsSoldPer9 . . . . . 15.2 NNN Cost of Goods Sold Period 9 . . 43 CostOfGoodsSoldPer10. . . . . 15.2 NNN Cost of Goods Sold Period 10. . 44 CostOfGoodsSoldPer11. . . . . 15.2 NNN Cost of Goods Sold Period 11. . 45 CostOfGoodsSoldPer12. . . . . 15.2 NNN Cost of Goods Sold Period 12. . 46 CostOfGoodsSoldPer13. . . . . 15.2 NNN Cost of Goods Sold Period 13. . 47 CostOfGoodsSoldPer1PY . . . . 15.2 NNN Cost of Goods Sold Period 1 Pri 48 CostOfGoodsSoldPer2PY . . . . 15.2 NNN Cost of Goods Sold Period 2 Pri 49 CostOfGoodsSoldPer3PY . . . . 15.2 NNN Cost of Goods Sold Period 3 Pri 50 CostOfGoodsSoldPer4PY . . . . 15.2 NNN Cost of Goods Sold Period 4 Pri 51 CostOfGoodsSoldPer5PY . . . . 15.2 NNN Cost of Goods Sold Period 5 Pri 52 CostOfGoodsSoldPer6PY . . . . 15.2 NNN Cost of Goods Sold Period 6 Pri 53 CostOfGoodsSoldPer7PY . . . . 15.2 NNN Cost of Goods Sold Period 7 Pri 54 CostOfGoodsSoldPer8PY . . . . 15.2 NNN Cost of Goods Sold Period 8 Pri 55 CostOfGoodsSoldPer9PY . . . . 15.2 NNN Cost of Goods Sold Period 9 Pri 56 CostOfGoodsSoldPer10PY. . . . 15.2 NNN Cost of Goods Sold Period 10 Pr 57 CostOfGoodsSoldPer11PY. . . . 15.2 NNN Cost of Goods Sold Period 11 Pr 58 CostOfGoodsSoldPer12PY. . . . 15.2 NNN Cost of Goods Sold Period 12 Pr 59 CostOfGoodsSoldPer13PY. . . . 15.2 NNN Cost of Goods Sold Period 13 Pr 60 CashReceivedPer1. . . . . . . 15.2 NNN Cash Received Period 1. . . . . 61 CashReceivedPer2. . . . . . . 15.2 NNN Cash Received Period 2. . . . . 62 CashReceivedPer3. . . . . . . 15.2 NNN Cash Received Period 3. . . . . 63 CashReceivedPer4. . . . . . . 15.2 NNN Cash Received Period 4. . . . . 64 CashReceivedPer5. . . . . . . 15.2 NNN Cash Received Period 5. . . . . 65 CashReceivedPer6. . . . . . . 15.2 NNN Cash Received Period 6. . . . . 66 CashReceivedPer7. . . . . . . 15.2 NNN Cash Received Period 7. . . . . 67 CashReceivedPer8. . . . . . . 15.2 NNN Cash Received Period 8. . . . . 68 CashReceivedPer9. . . . . . . 15.2 NNN Cash Received Period 9. . . . . 69 CashReceivedPer10 . . . . . . 15.2 NNN Cash Received Period 10 . . . . 70 CashReceivedPer11 . . . . . . 15.2 NNN Cash Received Period 11 . . . . 71 CashReceivedPer12 . . . . . . 15.2 NNN Cash Received Period 12 . . . . 72 CashReceivedPer13 . . . . . . 15.2 NNN Cash Received Period 13 . . . . 73 CashReceivedPer1PY. . . . . . 15.2 NNN Cash Received Period 1 Prior Ye 74 CashReceivedPer2PY. . . . . . 15.2 NNN Cash Received Period 2 Prior Ye 75 CashReceivedPer3PY. . . . . . 15.2 NNN Cash Received Period 3 Prior Ye 76 CashReceivedPer4PY. . . . . . 15.2 NNN Cash Received Period 4 Prior Ye 77 CashReceivedPer5PY. . . . . . 15.2 NNN Cash Received Period 5 Prior Ye 78 CashReceivedPer6PY. . . . . . 15.2 NNN Cash Received Period 6 Prior Ye 79 CashReceivedPer7PY. . . . . . 15.2 NNN Cash Received Period 7 Prior Ye 80 CashReceivedPer8PY. . . . . . 15.2 NNN Cash Received Period 8 Prior Ye 81 CashReceivedPer9PY. . . . . . 15.2 NNN Cash Received Period 9 Prior Ye 82 CashReceivedPer10PY . . . . . 15.2 NNN Cash Received Period 10 Prior Y 83 CashReceivedPer11PY . . . . . 15.2 NNN Cash Received Period 11 Prior Y 84 CashReceivedPer12PY . . . . . 15.2 NNN Cash Received Period 12 Prior Y 85 CashReceivedPer13PY . . . . . 15.2 NNN Cash Received Period 13 Prior Y 86 FinanceChargesPer1. . . . . . 15.2 NNN Finance Charges Period 1. . . . 87 FinanceChargesPer2. . . . . . 15.2 NNN Finance Charges Period 2. . . . 88 FinanceChargesPer3. . . . . . 15.2 NNN Finance Charges Period 3. . . . 89 FinanceChargesPer4. . . . . . 15.2 NNN Finance Charges Period 4. . . . 90 FinanceChargesPer5. . . . . . 15.2 NNN Finance Charges Period 5. . . . 91 FinanceChargesPer6. . . . . . 15.2 NNN Finance Charges Period 6. . . . 92 FinanceChargesPer7. . . . . . 15.2 NNN Finance Charges Period 7. . . . 93 FinanceChargesPer8. . . . . . 15.2 NNN Finance Charges Period 8. . . . 94 FinanceChargesPer9. . . . . . 15.2 NNN Finance Charges Period 9. . . . 95 FinanceChargesPer10 . . . . . 15.2 NNN Finance Charges Period 10 . . . 96 FinanceChargesPer11 . . . . . 15.2 NNN Finance Charges Period 11 . . . 97 FinanceChargesPer12 . . . . . 15.2 NNN Finance Charges Period 12 . . . 98 FinanceChargesPer13 . . . . . 15.2 NNN Finance Charges Period 13 . . . 99 FinanceChargesPer1PY. . . . . 15.2 NNN Finance Charges Period 1 Prior 100 FinanceChargesPer2PY. . . . . 15.2 NNN Finance Charges Period 2 Prior 101 FinanceChargesPer3PY. . . . . 15.2 NNN Finance Charges Period 3 Prior 102 FinanceChargesPer4PY. . . . . 15.2 NNN Finance Charges Period 4 Prior 103 FinanceChargesPer5PY. . . . . 15.2 NNN Finance Charges Period 5 Prior 104 FinanceChargesPer6PY. . . . . 15.2 NNN Finance Charges Period 6 Prior 105 FinanceChargesPer7PY. . . . . 15.2 NNN Finance Charges Period 7 Prior 106 FinanceChargesPer8PY. . . . . 15.2 NNN Finance Charges Period 8 Prior 107 FinanceChargesPer9PY. . . . . 15.2 NNN Finance Charges Period 9 Prior 108 FinanceChargesPer10PY . . . . 15.2 NNN Finance Charges Period 10 Prior 109 FinanceChargesPer11PY . . . . 15.2 NNN Finance Charges Period 11 Prior 110 FinanceChargesPer12PY . . . . 15.2 NNN Finance Charges Period 12 Prior 111 FinanceChargesPer13PY . . . . 15.2 NNN Finance Charges Period 13 Prior 112 NumberOfInvoicesPer1. . . . . 15.2 NNN Number Of Invoices Period 1 . . 113 NumberOfInvoicesPer2. . . . . 15.2 NNN Number Of Invoices Period 2 . . 114 NumberOfInvoicesPer3. . . . . 15.2 NNN Number Of Invoices Period 3 . . 115 NumberOfInvoicesPer4. . . . . 15.2 NNN Number Of Invoices Period 4 . . 116 NumberOfInvoicesPer5. . . . . 15.2 NNN Number Of Invoices Period 5 . . 117 NumberOfInvoicesPer6. . . . . 15.2 NNN Number Of Invoices Period 6 . . 118 NumberOfInvoicesPer7. . . . . 15.2 NNN Number Of Invoices Period 7 . . 119 NumberOfInvoicesPer8. . . . . 15.2 NNN Number Of Invoices Period 8 . . 120 NumberOfInvoicesPer9. . . . . 15.2 NNN Number Of Invoices Period 9 . . 121 NumberOfInvoicesPer10 . . . . 15.2 NNN Number Of Invoices Period 10. . 122 NumberOfInvoicesPer11 . . . . 15.2 NNN Number Of Invoices Period 11. . 123 NumberOfInvoicesPer12 . . . . 15.2 NNN Number Of Invoices Period 12. . 124 NumberOfInvoicesPer13 . . . . 15.2 NNN Number Of Invoices Period 13. . 125 NumberOfInvoicesPer1PY. . . . 15.2 NNN Number Of Invoices Period 1 Pri 126 NumberOfInvoicesPer2PY. . . . 15.2 NNN Number Of Invoices Period 2 Pri 127 NumberOfInvoicesPer3PY. . . . 15.2 NNN Number Of Invoices Period 3 Pri 128 NumberOfInvoicesPer4PY. . . . 15.2 NNN Number Of Invoices Period 4 Pri 129 NumberOfInvoicesPer5PY. . . . 15.2 NNN Number Of Invoices Period 5 Pri 130 NumberOfInvoicesPer6PY. . . . 15.2 NNN Number Of Invoices Period 6 Pri 131 NumberOfInvoicesPer7PY. . . . 15.2 NNN Number Of Invoices Period 7 Pri 132 NumberOfInvoicesPer8PY. . . . 15.2 NNN Number Of Invoices Period 8 Pri 133 NumberOfInvoicesPer9PY. . . . 15.2 NNN Number Of Invoices Period 9 Pri 134 NumberOfInvoicesPer10PY . . . 15.2 NNN Number Of Invoices Period 10 Pr 135 NumberOfInvoicesPer11PY . . . 15.2 NNN Number Of Invoices Period 11 Pr 136 NumberOfInvoicesPer12PY . . . 15.2 NNN Number Of Invoices Period 12 Pr 137 NumberOfInvoicesPer13PY . . . 15.2 NNN Number Of Invoices Period 13 Pr 138 NumberOfFinanceChgsPer1 . . . 15.2 NNN Number Of Finance Charges Perio 139 NumberOfFinanceChgsPer2 . . . 15.2 NNN Number Of Finance Charges Perio 140 NumberOfFinanceChgsPer3 . . . 15.2 NNN Number Of Finance Charges Perio 141 NumberOfFinanceChgsPer4 . . . 15.2 NNN Number Of Finance Charges Perio 142 NumberOfFinanceChgsPer5 . . . 15.2 NNN Number Of Finance Charges Perio 143 NumberOfFinanceChgsPer6 . . . 15.2 NNN Number Of Finance Charges Perio 144 NumberOfFinanceChgsPer7 . . . 15.2 NNN Number Of Finance Charges Perio 145 NumberOfFinanceChgsPer8 . . . 15.2 NNN Number Of Finance Charges Perio 146 NumberOfFinanceChgsPer9 . . . 15.2 NNN Number Of Finance Charges Perio 147 NumberOfFinanceChgsPer10. . . 15.2 NNN Number Of Finance Charges Perio 148 NumberOfFinanceChgsPer11. . . 15.2 NNN Number Of Finance Charges Perio 149 NumberOfFinanceChgsPer12. . . 15.2 NNN Number Of Finance Charges Perio 150 NumberOfFinanceChgsPer13. . . 15.2 NNN Number Of Finance Charges Perio 151 NumberOfFinanceChgsPer1PY . . 15.2 NNN Number Of Finance Charges Perio 152 NumberOfFinanceChgsPer2PY . . 15.2 NNN Number Of Finance Charges Perio 153 NumberOfFinanceChgsPer3PY . . 15.2 NNN Number Of Finance Charges Perio 154 NumberOfFinanceChgsPer4PY . . 15.2 NNN Number Of Finance Charges Perio 155 NumberOfFinanceChgsPer5PY . . 15.2 NNN Number Of Finance Charges Perio 156 NumberOfFinanceChgsPer6PY . . 15.2 NNN Number Of Finance Charges Perio 157 NumberOfFinanceChgsPer7PY . . 15.2 NNN Number Of Finance Charges Perio 158 NumberOfFinanceChgsPer8PY . . 15.2 NNN Number Of Finance Charges Perio 159 NumberOfFinanceChgsPer9PY . . 15.2 NNN Number Of Finance Charges Perio 160 NumberOfFinanceChgsPer10PY. . 15.2 NNN Number Of Finance Charges Perio 161 NumberOfFinanceChgsPer11PY. . 15.2 NNN Number Of Finance Charges Perio 162 NumberOfFinanceChgsPer12PY. . 15.2 NNN Number Of Finance Charges Perio 163 NumberOfFinanceChgsPer13PY. . 15.2 NNN Number Of Finance Charges Perio 164 TotalDollarsSold. . . . . . . 15.2 NNN Total Dollars Sold. . . . . . . 165 TotalDollarsSoldPY. . . . . . 15.2 NNN Total Dollar Sold Prior Year. . 166 TotalCostOfGoodsSold. . . . . 15.2 NNN Total Cost of Goods Sold. . . . 167 TotalCostOfGoodsSoldPY. . . . 15.2 NNN Total Cost of Goods Sold Prior 168 TotalGrossProfitAmt . . . . . 15.2 NNN Total Gross Profit Amount . . . 169 TotalGrossProfitAmtPY . . . . 15.2 NNN Total Gross Profit Amount Prior 170 TotalGrossProfitPct . . . . . 15.2 NNN Total Gross Profit Percent. . . 171 TotalGrossProfitPctPY . . . . 15.2 NNN Total Gross Profit Percent Prio 172 TotalCashReceived . . . . . . 15.2 NNN Total Cash Received . . . . . . 173 TotalCashReceivedPY . . . . . 15.2 NNN Total Cash Received Prior Year. 174 TotalFinanceCharges . . . . . 15.2 NNN Total Finance Charges . . . . . 175 TotalFinanceChargesPY . . . . 15.2 NNN Total Finance Charges Prior Yea 176 TotalNumberOfInvoices . . . . 15.2 NNN Total Number Of Invoices. . . . 177 TotalNumberOfInvoicesPY . . . 15.2 NNN Total Number Of Invoices Prior 178 TotalNumberOfFinanceChgs. . . 15.2 NNN Total Number Of Finance Charges 179 TotalNumberOfFinanceChgsPY. . 15.2 NNN Total Number Of Finance Charges