     IM_ItemCustomerHistoryByPeriod        IM Item Customer History By PeriRel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_ItemCustomerHistoryByPeriod_bus,SO_SalesJournal_upd,CI_CostRecalc_upd
     SQL Def: Y  SysDB: N                        "MAS_"+%C$+"/IM"+%C$+"/IM_ItemCustomerHistoryByPeriod.M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+ShipToCode+ItemCode+FiscalCalYear+FiscalCalPeriod
     KITEMCUSTOMER: ItemCode+ARDivisionNo+CustomerNo+ShipToCode+FiscalCalYear+FiscalCalPeriod(**)  **=Case S
                    ensitive
     KITEMYEAR: ItemCode+FiscalCalYear+FiscalCalPeriod+ARDivisionNo+CustomerNo+ShipToCode
     KCUSTOMERSHIPTO: ARDivisionNo+CustomerNo+ShipToCode+FiscalCalYear+FiscalCalPeriod+ItemCode
     KCUSTOMERYEAR: ARDivisionNo+CustomerNo+FiscalCalYear+FiscalCalPeriod+ShipToCode+ItemCode
     KCUSTOMERITEM: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode
     KITEMBROWSE: ItemCode+FiscalCalYear+ARDivisionNo+CustomerNo+ShipToCode+FiscalCalPeriod
     KCUSTOMERBROWSE: ARDivisionNo+CustomerNo+FiscalCalYear+ItemCode+ShipToCode+FiscalCalPeriod

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 Notes: {IM_13$(1,2)}
       2  CustomerNo. . . . . . . . . .    20 SNY  Customer Number . . . . . . . .CUSTOMERNO
                                                    ChngTag:Replace1/ARDivisionNo
                                                    $ Notes: {IM_13$(3,7)}
       3  ShipToCode. . . . . . . . . .     4 SYN  Ship To Code. . . . . . . . . .SHIPTO
                                                    Notes: {IM_13$(10,4)}
       4  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0 Notes:
                                                    {IM_13$(14,15)}
       5  FiscalCalYear . . . . . . . .     4 SNY  Fiscal Calendar Year. . . . . .YEAR
                                                    Mask:0000 Notes: {IM_13$(29,
                                                    4)}
       6  FiscalCalPeriod . . . . . . .     2 SNY  Fiscal Calendar Period. . . . .FISCALPERIOD
                                                    Mask:00
       7  QuantitySold. . . . . . . . . 16.6  NNN  Quantity Sold . . . . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
                                                    Notes: {IM_13[0]}
       8  DollarsSold . . . . . . . . . 15.2  NNN  Dollars Sold. . . . . . . . . .
                                                    Read Only:Y Mask:##,###,###,
                                                    ###.00- ChngTag:Sum Notes:
                                                    {IM_13[13]}
       9  CostOfGoodsSold . . . . . . . 15.2  NNN  Cost Of Goods Sold. . . . . . .
                                                    Read Only:Y Mask:##,###,###,
                                                    ###.00- ChngTag:Sum Notes:
                                                    {IM_13[26]}
      10  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
                                                    Notes: {IM_13[39]}
      11  DateUpdated . . . . . . . . .     8 SNY  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      12  TimeUpdated . . . . . . . . .     8 SNY  Last Update Time. . . . . . . .
                                                    Read Only:Y
      13  UserUpdatedKey. . . . . . . .    10 SYY  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL