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