     IM_Physical                        IM Physical Inventory              Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_Physical_bus
     SQL Def: Y  SysDB: N                                           "MAS_"+%C$+"/IM"+%C$+"/IM_Physical.M4T"

     KPRIMARY: WarehouseCode+ItemCode+LotSerialNo
     kBINLOCATION: WarehouseCode+BinLocation+ItemCode+LotSerialNo
     kDESCRIPTION: WarehouseCode+ItemCodeDesc+ItemCode+LotSerialNo
     kITEM: ItemCode+WarehouseCode+LotSerialNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  WarehouseCode . . . . . . . .     3 SYY  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {IME$(1,3)}
       2  BinLocation . . . . . . . . .    10 SYN  Bin Location. . . . . . . . . .
       3  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
       4  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
                                                    Read Only:Y
       5  ProductType . . . . . . . . .     1 SNN  Product Type. . . . . . . . . .
                                                    Read Only:Y
       6  ProcurementType . . . . . . .     1 SNN  Procurement Type. . . . . . . .
                                                    Read Only:Y
       7  InventoryCycle. . . . . . . .     1 SNN  Inventory Cycle . . . . . . . .
                                                    Read Only:Y
       8  LotSerialNo . . . . . . . . .    15 SYN  Lot Serial Number . . . . . . .LOTSERIALNO
                                                    Notes: {IME$(19,15)}
       9  ReceiptDate . . . . . . . . .     8 SNN  Receipt Date. . . . . . . . . .DATE
                                                    Read Only:Y Notes: {IME$(34,
                                                    8)}
      10  QuantityOnHand. . . . . . . . 16.6  NNN  Quantity On Hand. . . . . . . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- Notes: {IME[0]}
      11  QuantityCounted . . . . . . . 16.6  NNN  Quantity Counted. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {IME[1]}
      12  ChangeQuantity. . . . . . . . 16.6  NNN  Change Quantity . . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      13  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    Read Only:Y Notes: {IME$(57,
                                                    4)}
      14  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit Of Measure. . . .
                                                    Read Only:Y
      15  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
                                                    Read Only:Y Valid:1,2,3,4,5,
                                                    6 Notes: 1=Standard,
                                                    2=Average, 3=Fifo, 4=Lifo,
                                                    5=Lot, 6=Serial {IM1$(51,1)}
      16  ChangeExtendedCost. . . . . . 12.2  NNN  Change Extended Cost. . . . . .
      17  ChangeExtendedNegQtyAdj . . . 12.2  NNN  Change Extended Negative Quanti
      18  ChangeUnitCost. . . . . . . . 16.6  NNN  Change Unit Cost. . . . . . . .COST
                                                    Mask:##,###,###.000000-
      19  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      20  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      21  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      22  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      23  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      24  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL