     CI_ItemHistoryByPeriod                CI Item History By Period       Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: CI_ItemCodeHistory_bus,SO_SalesJournal_upd,AR_SalesJournal_upd,PO_ReceiptRegister_upd,PO_Retur
     SQL Def: Y  SysDB: N                                "MAS_"+%C$+"/CI"+%C$+"/CI_ItemHistoryByPeriod.M4T"

     KPRIMARY: ItemCode+FiscalCalYear+FiscalCalPeriod
     KALTERNATE: FiscalCalYear+FiscalCalPeriod+ItemCode

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0 Notes:
                                                    {IM_14$(1,15) } IMM and IM9
                                                    contain duplicate data for
                                                    (1,15)
       2  FiscalCalYear . . . . . . . .     4 SNY  Fiscal Calendar Year. . . . . .YEAR
                                                    Mask:0000 Notes: Notes: {
                                                    IM_14$ (16,3) } IMM and IM9
                                                    contain duplicate data for
                                                    (16,3)
       3  FiscalCalPeriod . . . . . . .     2 SNN  Fiscal Calendar Period. . . . .FISCALPERIOD
                                                    Mask:00
       4  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                    Valid:3,5 Notes: Note:
                                                    3=Charge Item, 5=Miscellaneou
                                                    s Item
       5  QuantitySold. . . . . . . . . 16.6  NNN  Quantity Sold . . . . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
                                                    Notes: {IM9[0-12] }
       6  DollarsSold . . . . . . . . . 15.2  NNN  Dollars Sold. . . . . . . . . .IMCOST
                                                    Read Only:Y ChngTag:Sum
                                                    Notes: {IM9[13-25] }
       7  CostOfGoodsSold . . . . . . . 15.2  NNN  Cost Of Goods Sold. . . . . . .IMCOST
                                                    Read Only:Y Mask:##,###,###,
                                                    ###.00- ChngTag:Sum Notes:
                                                    {IM9 [26-38] }
       8  QuantityReturnedCustomer. . . 16.6  NNN  Quantity Returned Customer. . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
                                                    Notes: {IM9 [39-51] }
       9  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
                                                    Notes: {IM_14[0-13] }
      10  ReceivedCost. . . . . . . . . 15.2  NNN  Received Cost . . . . . . . . .IMCOST
                                                    Read Only:Y ChngTag:Sum
                                                    Notes: {IM_14[13-25] }
      11  QuantityReturnedVendor. . . . 16.6  NNN  Quantity Returned Vendor. . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
                                                    Notes: {IM_14[39-51]}
      12  QuantityIssued. . . . . . . . 16.6  NNN  Quantity Issued . . . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000-
      13  IssuesCost. . . . . . . . . . 15.2  NNN  Issues Cost . . . . . . . . . .IMCOST
                                                    Read Only:Y
      14  DateUpdated . . . . . . . . .     8 SNY  Date Updated. . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      15  TimeUpdated . . . . . . . . .     8 SNY  Time Updated. . . . . . . . . .
                                                    Read Only:Y
      16  UserUpdatedKey. . . . . . . .    10 SYY  Last Updated User ID. . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL