IM_LotSerialTransactionHistory IM Lot Serial Transaction HistorRel: 4.40 Bld: 398 8/28/2009
Bus Obj: IM_LotSerialTransactionHistory_bus,IM_TransactionRegister_upd,PO_ReceiptRegister_upd,PO_Return
SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_LotSerialTransactionHistory.M4T"
KPRIMARY: ItemCode+WarehouseCode+TransactionDate+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo
KLOTSERIAL: ItemCode+LotSerialNo+TransactionDate+WarehouseCode+TransactionCode+EntryNo+SequenceNo
KTRANSDATE: TransactionDate+ItemCode+WarehouseCode+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo
KVENDOR: APDivisionNo+VendorNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+WarehouseCode+Transact
ionDate+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo
KCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+FiscalCalYear+FiscalCalPeriod+ShipToCode+WarehouseCode+Tran
sactionDate+TransactionCode+EntryNo+SequenceNo+LotSerialSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{IM5$(1,15)}
2 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{IM5$(16,3)}
3 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE
Notes: {IM5$(19,6)}
4 TransactionCode . . . . . . . 2 SYY Transaction Code. . . . . . . .
Valid:IC,BC,WC,BI,BR,BZ,IA,
II,IN,IP,IR,IS,IT,IX,IZ,PM,
PO,SI,SO,SK,WI,WR,PS,SP,SR,
SS,PA,PZ,SZ,WZ Notes:
{IM5$(25,2)}
5 EntryNo . . . . . . . . . . . 10 SYY Entry Number. . . . . . . . . .
Notes: {IM5$(27,10)}
6 SequenceNo. . . . . . . . . . 6 SNY Sequence Number from IM Transac
Mask:000000 FmtType:ZEROFILL
Notes: {IM5$(37,3)}
7 LotSerialSeqNo. . . . . . . . 6 SNY Lot Serial Sequence Number. . .
Mask:000000 FmtType:ZEROFILL
8 LotSerialNo . . . . . . . . . 15 SYY Lot Serial Number . . . . . . .
Notes: {IM5$(40,15)}
9 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 Notes: {IM5$(55,2)}
10 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
Notes: {IM5$(57,7)}
11 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 Notes: {IM5$(55,2)}
12 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
ChngTag:Replace1/ARDivisionNo
$ Notes: {IM5$(57,7)}
13 ReferenceDate . . . . . . . . 8 SNN Reference Date. . . . . . . . .DATE
Notes: {IM5$(64,6)}
14 FiscalCalYear . . . . . . . . 4 SNN Fiscal or Calendar Year . . . .YEAR
Mask:0000 Notes: {IM5$(70,4)}
15 FiscalCalPeriod . . . . . . . 2 SNN Fiscal or Calendar Period . . .FISCALPERIOD
Mask:00 Notes: {IM5$(74,2)}
16 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . .SHIPTO
Notes: {IM5$(76,4)}
17 TransactionQty. . . . . . . . 16.6 NNN Transaction Quantity. . . . . .QUANTITY
Read Only:Y Mask:##,###,
###.000000- ChngTag:Sum
Notes: {IM5[0]}
18 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Read Only:Y Mask:##,###,
###.000000- Notes: {IM5[1]}
19 AllocatedCost . . . . . . . . 16.6 NNN Allocated Cost. . . . . . . . .IMCOST
Read Only:Y Notes: {IM5[2]}
20 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE
Read Only:Y Mask:##,###,
###.000000- Notes: {IM5[3]}
21 ExtendedPrice . . . . . . . . 15.2 NNN Extended Price. . . . . . . . .
Read Only:Y Mask:##,###,###,
###.00- ChngTag:Sum
22 ExtendedCost. . . . . . . . . 15.2 NNN Extended Cost . . . . . . . . .IMCOST
Read Only:Y ChngTag:Sum
23 DateUpdated . . . . . . . . . 8 SNY Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
24 TimeUpdated . . . . . . . . . 8 SNY Last Update Time. . . . . . . .
Read Only:Y
25 UserUpdatedKey. . . . . . . . 10 SYY Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL