     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$