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