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