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