IM_ItemWarehouse IM Item Warehouse Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ItemWarehouse_bus,IM_TransactionRegister_upd,PO_ReceiptRegister_upd,BM_ProductionRegister_u SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemWarehouse.m4t"
KPRIMARY: ItemCode+WarehouseCode KBINLOCATION: WarehouseCode+BinLocation+ItemCode
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {IM2$(1,15)} 2 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {IM2$(16,3)} 3 BinLocation . . . . . . . . . 10 SYN Bin Location. . . . . . . . . . Notes: {IM2$(19,10)} 4 ReorderMethod . . . . . . . . 1 SYN Reorder Method. . . . . . . . . DfltVal:E Valid:E,M,R Notes: E=Economic quantity, M=Maximum stock level, R=Reorder point {IM2$(29,1)} 5 EconomicOrderQty. . . . . . . 16.6 NNN Economic Order Quantity . . . .QUANTITY Mask:##,###,###.000000- Notes: {IM2[0]} 6 ReorderPointQty . . . . . . . 16.6 NNN Reorder Point Quantity. . . . .QUANTITY Mask:##,###,###.000000- Notes: {IM2[1]} 7 MinimumOrderQty . . . . . . . 16.6 NNN Minimum Order Quantity. . . . .QUANTITY Mask:##,###,###.000000- Notes: {IM2[2]} 8 MaximumOnHandQty. . . . . . . 16.6 NNN Maximum On Hand Quantity. . . .QUANTITY Mask:##,###,###.000000- Notes: {IM2[3]} 9 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM2[9]} 10 QuantityOnPurchaseOrder . . . 16.6 NNN Quantity On Purchase Order. . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM2[10]} 11 QuantityOnSalesOrder. . . . . 16.6 NNN Quantity On Sales Order . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM2[11]} 12 QuantityOnBackOrder . . . . . 16.6 NNN Quantity On Back Order. . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM2[12]} 13 AverageCost . . . . . . . . . 16.6 NNN Average Cost. . . . . . . . . .COST Read Only:Y Mask:##,###, ###.000000- Notes: {IM2[27]}P er warehouse 14 QuantityOnWorkOrder . . . . . 16.6 NNN Quantity On Work Order. . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM2[28]} 15 QuantityRequiredForWO . . . . 16.6 NNN Quantity Required for Work OrdeQUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum Notes: {IM2[29]} 16 QuantityInShipping. . . . . . 16.6 NNN Quantity In Shipping. . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum 17 TotalWarehouseValue . . . . . 12.2 NNN Total Warehouse Value . . . . . Read Only:Y ChngTag:Sum 18 CostCalcQtyCommitted. . . . . 16.6 NNN Cost Calculated Quantity CommitQUANTITY Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum 19 CostCalcCostCommitted . . . . 16.6 NNN Cost Calculated Cost Committed.COST Read Only:Y Mask:##,###, ###.000000- ChngTag:Sum 20 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 21 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 22 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 23 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 24 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . . Read Only:Y 25 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL