AR_CustomerSalesHistory                AR Customer Sales History      Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_CustomerSalesHistory_bus,AR_CashReceiptsJournal_upd,AR_SalesJournal_upd,SO_SalesJournal_upd
 SQL Def: Y  SysDB: N                               "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerSalesHistory.M4T"

 KPRIMARY: ARDivisionNo+CustomerNo+FiscalYear+FiscalPeriod
 KALTERNATE: FiscalYear+FiscalPeriod+ARDivisionNo+CustomerNo
 KYEARPERIOD: FiscalYear(d**)+FiscalPeriod+ARDivisionNo+CustomerNo  **=Case Sensitive

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 FmtType:ZEROFILL
   2  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                FmtType:MASTERNUMC ChngTag:Re
                                                place1/ARDivisionNo$
   3  FiscalYear. . . . . . . . . .     4 SNY  Fiscal Year . . . . . . . . . .YEAR
                                                Mask:0000
   4  FiscalPeriod. . . . . . . . .     2 SNY  Fiscal Period . . . . . . . . .FISCALPERIOD
                                                Mask:00 FmtType:ZEROFILL
   5  DollarsSold . . . . . . . . . 15.2  NNN  Dollars Sold. . . . . . . . . .
                                                Mask:##,###,###,###.00-
                                                ChngTag:Sum
   6  CostOfGoodsSold . . . . . . . 15.2  NNN  Cost of Goods Sold. . . . . . .
                                                Mask:##,###,###,###.00-
                                                ChngTag:Sum
   7  CashReceived. . . . . . . . . 15.2  NNN  Cash Received . . . . . . . . .
                                                Mask:##,###,###,###.00-
                                                ChngTag:Sum
   8  FinanceCharges. . . . . . . . 15.2  NNN  Finance Charges . . . . . . . .
                                                Mask:##,###,###,###.00-
                                                ChngTag:Sum
   9  NumberOfInvoices. . . . . . .  7.0  NNN  Number of Invoices. . . . . . .
                                                Mask:#,###,### ChngTag:Sum
  10  NumberOfFinanceChrgs. . . . .  7.0  NNN  Number of Finance Charges . . .
                                                Mask:#,###,### ChngTag:Sum
  11  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y ChngTag:Max
                                                Notes: YYYYMMDD
  12  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y ChngTag:CopyMax/D
                                                ateUpdated$
  13  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL ChngTag:Copy
                                                Max/DateUpdated$