     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