     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