     IM_ItemCost                            IM Item Cost                   Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_ItemCost_bus,IM_TransactionRegister_upd,PO_ReceiptRegister_upd,BM_ProductionRegister_upd,BM
     SQL Def: Y  SysDB: N                                           "MAS_"+%C$+"/IM"+%C$+"/IM_ItemCost.M4T"

     KPRIMARY: ItemCode+WarehouseCode+TierType+GroupSort
     KINVERSEDATE: ItemCode+WarehouseCode+TierType+ReceiptDate(d)+ReceiptNo+LotSerialNo+GroupSort
     KNEGATIVETIER: NegativeQty+TierGroup+ItemCode+WarehouseCode+TierType+GroupSort

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0
       2  WarehouseCode . . . . . . . .     3 SYY  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
       3  TierType. . . . . . . . . . .     1 SYY  Tier Type . . . . . . . . . . .
                                                    Valid:1,2,3,4 Notes: 1=fifo,
                                                    2=lifo, 3=lot, 4=serial
       4  GroupSort . . . . . . . . . .    16 SNY  Group Sort. . . . . . . . . . .
                                                    FmtType:CHARNUM Notes: (For
                                                    TierType 1/2:ReceiptDate+Rece
                                                    iptNo or For TierType 3/4:
                                                    LotSerialNo)
       5  TransactionDate . . . . . . .     8 SYY  Transaction Date. . . . . . . .DATE
       6  ReceiptDate . . . . . . . . .     8 SYN  Receipt Date. . . . . . . . . .DATE
       7  ReceiptNo . . . . . . . . . .     8 SYN  Receipt Number. . . . . . . . .
       8  LotSerialNo . . . . . . . . .    15 SYN  Lot Serial Number . . . . . . .LOTSERIALNO
                                                    DepVal:REQUIRED Notes: This
                                                    should be required when
                                                    TierType = 3 or 4
       9  NegativeQty . . . . . . . . .     1 SYN  Negative Quantity . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      10  TierGroup . . . . . . . . . .     1 SNN  Tier Group. . . . . . . . . . .
                                                    Valid:1,2 Notes: 1 =
                                                    Lifo/Fifo, 2 = Lot/Serial
      11  QuantityOnHand. . . . . . . . 16.6  NNN  Quantity On Hand. . . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
      12  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- Valid:>=0
      13  AllocatedCost . . . . . . . . 16.6  NNN  Allocated Cost. . . . . . . . .COST
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
      14  ExtendedCost. . . . . . . . . 12.2  NNN  Extended Cost of Quantity On HaCOST
                                                    Read Only:Y Mask:##,###,
                                                    ###.00- ChngTag:Sum
      15  QuantityCommitted . . . . . . 16.6  NNN  Quantity Committed. . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ChngTag:Sum
      16  CostCalcQtyCommitted. . . . . 16.6  NNN  Quantity Committed During Cost QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000-
      17  CostCalcCostCommitted . . . . 12.2  NNN  Total Cost of Qty Committed . .COST
                                                    Read Only:Y Mask:##,###,
                                                    ###.00- Notes: Tot Cost of
                                                    Qty Committed during Cost
                                                    Calc
      18  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      19  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      20  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      21  DateUpdated . . . . . . . . .     8 SNY  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      22  TimeUpdated . . . . . . . . .     8 SNY  Last Update Time. . . . . . . .
                                                    Read Only:Y
      23  UserUpdatedKey. . . . . . . .    10 SYY  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL