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