AR_CustomerSalesAnalysisWrk AR Customer Sales Analysis Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CustomerSalesAnalysis_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerSalesAnalysisWrk"+%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 GroupField2 . . . . . . . . . 30 SNN Group Field 2 . . . . . . . . . 5 GroupFieldDesc2 . . . . . . . 30 SNN Group Field Description 2 . . . 6 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 7 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 8 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 9 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . . 10 ZipCode . . . . . . . . . . . 10 SNN ZipCode . . . . . . . . . . . . 11 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 12 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 13 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 14 CustomerSortField . . . . . . 10 SNN Customer Sort Field . . . . . . 15 CustomerType. . . . . . . . . 4 SNN Customer Type . . . . . . . . . 16 CreditHold. . . . . . . . . . 1 SNN Credit Hold . . . . . . . . . . 17 CreditLimitExceeded . . . . . 1 SNN Credit Limit Exceeded . . . . . 18 NumberOfInvToUseInCalc. . . . 2.0 NNN Number of Invoices to Use in Ca 19 AvgDaysPaymentInvoice . . . . 3.0 NNN Average Days Payment Invoice. . 20 AvgDaysOverDue. . . . . . . . 3.0 NNN Average Days Over Due . . . . . 21 DollarsSoldPTD. . . . . . . . 15.2 NNN Dollars Sold Period to Date . . 22 DollarsSoldYTD. . . . . . . . 16.2 NNN Dollars Sold Year to Date . . . 23 DollarsSoldPY . . . . . . . . 16.2 NNN Dollars Sold Prior Year . . . . 24 CostOfGoodsSoldPTD. . . . . . 15.2 NNN Cost of Goods Sold Period to Da 25 CostOfGoodsSoldYTD. . . . . . 16.2 NNN Cost of Goods Sold Year to Date 26 CostOfGoodsSoldPY . . . . . . 16.2 NNN Cost of Goods Sold Prior Year . 27 ProfitPercentPTD. . . . . . . 8.3 NNN Profit Percent Period to Date . 28 ProfitPercentYTD. . . . . . . 8.3 NNN Profit Percent Year to Date . . 29 ProfitPercentPY . . . . . . . 8.3 NNN Profit Percent Prior Year . . . 30 CashReceivedPTD . . . . . . . 15.2 NNN Cash Received Period to Date. . 31 CashReceivedYTD . . . . . . . 16.2 NNN Cash Received Year to Date. . . 32 CashReceivedPY. . . . . . . . 16.2 NNN Cash Received Prior Year. . . . 33 FinanceChargesPTD . . . . . . 15.2 NNN Finance Charges Period to Date. 34 FinanceChargesYTD . . . . . . 16.2 NNN Finance Charges Year to Date. . 35 FinanceChargesPY. . . . . . . 16.2 NNN Finance Charges Prior Year. . . 36 NumberOfInvoicesPTD . . . . . 7.0 NNN Number of Invoices Period to Da 37 NumberOfInvoicesYTD . . . . . 8.0 NNN Number of Invoices Year to Date 38 NumberOfInvoicesPY. . . . . . 8.0 NNN Number of Invoices Prior Year . 39 NumberOfFinanceChrgsPTD . . . 7.0 NNN Number of Finance Charges Perio 40 NumberOfFinanceChrgsYTD . . . 8.0 NNN Number of Finance Charges Year 41 NumberOfFinanceChrgsPY. . . . 8.0 NNN Number of Finance Charges Prior