IM_TransactionTierDist IM Transaction Entry Tier DistributionRel: 4.40 Bld: 398 8/28/2009
Bus Obj: IM_TransactionTierDistribution_bus,BC_CommonImport
SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_TransactionTierDist.M4T"
KPRIMARY: TransactionType+EntryNo+LineKey+LotSerialNo+FifoLifoDate+FifoLifoReferenceNo
KFIFOLIFO: TransactionType+EntryNo+LineKey+FifoLifoDate+FifoLifoReferenceNo+LotSerialNo
KLOTSERIAL: LotSerialNo+TierType+TransactionType+EntryNo+LineKey+FifoLifoDate+FifoLifoReferenceNo
Fld Column Name M/L TUR Description/Notes Class
1 TransactionType . . . . . . . 1 SNY Transaction Type. . . . . . . .
Valid:1,2,4,6,8 Notes:
{IMI$(1,1)}1=Sales, 2=Issue,
4=Transfer, 6=Adjustment,
8=Receipt
2 EntryNo . . . . . . . . . . . 8 SYY Entry Number. . . . . . . . . .
Notes: {IMI$(2,10)}
3 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Mask:000000 Notes: {IMI$(12,
5)}
4 TierType. . . . . . . . . . . 1 SNY Tier Type . . . . . . . . . . .
Valid:1,2,3,4 Notes:
{IMI$(32,1)}.1=Fifo, 2=Lifo,
3=Lot, 4=Serial
5 LotSerialNo . . . . . . . . . 15 SYN Lot/Serial Number . . . . . . .
Notes: {IMI$(17,15)}
6 FifoLifoDate. . . . . . . . . 8 SNN Fifo Lifo Date. . . . . . . . .DATE
7 FifoLifoReferenceNo . . . . . 8 SNN Fifo Lifo Reference Number. . .
8 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
9 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM
10 TransactionQty. . . . . . . . 16.6 NNN Transaction Quantity. . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {IMI[0]}
11 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion Fact
Mask:#####0.0000