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