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