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