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