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