Table: Lot Number History

Table: ICXLHIS
View: IC0815
Record Length: 312

Flags: A R 

Keys: 7

Title Flags Fields

Lot Number LOTNUMITEMNUMLOCATIONDAYENDSEQENTRYSEQLINENOCOMPNUM
Item Number ITEMNUMLOCATIONDAYENDSEQENTRYSEQLINENOCOMPNUMLOTNUM
Customer/Vendor Lot D M  APPCUSTVENDLOTNUMITEMNUMTRANSDATETRANSTYPE
Customer/Vendor Item D M  APPCUSTVENDITEMNUMLOTNUMTRANSDATETRANSTYPE
Dayend Sequence DAYENDSEQENTRYSEQLOTNUMITEMNUMLOCATIONLINENOCOMPNUM
Document Number DOCNUMDETAILNUMLOTNUMITEMNUMLOCATIONDAYENDSEQENTRYSEQLINENOCOMPNUM
Transaction Date TRANSDATEITEMNUMLOTNUMLOCATIONDAYENDSEQENTRYSEQLINENOCOMPNUM

Fields: 50

Field Type Title Presentation

LOTNUM String*40 Unformatted Lot Number
ITEMNUM String*24 Unformatted Item Number Mask: %-24C
LOCATION String*6 Location Mask: %-6N
DAYENDSEQ Long Day End Number
ENTRYSEQ Long Transaction Sequence
LINENO Integer Line Number
COMPNUM Long Component Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
APP String*2 Source Application
TRANSTYPE Integer Transaction Type List:28 entries
1 = Receipt
2 = Receipt Adjustment
3 = Receipt Return
4 = Shipment
5 = Shipment Return
6 = Adjustment Quantity Increase
7 = Adjustment Quantity Decrease
8 = Adjustment Cost Increase
9 = Adjustment Cost Decrease
10 = Adjustment Both Increase
11 = Adjustment Both Decrease
12 = Stock Transfer From
13 = Stock Transfer To
14 = Master Item Assembly
15 = Component Item Assembly
16 = Invoice
17 = Credit Note
18 = Debit Note
19 = Shipment Adjustment
20 = Internal Usage
100 = Lot Recall
111 = Lot Recall Release
112 = Lot Combine
113 = Lot Split
114 = Lot Receipt
115 = Lot Shipment
118 = Lot OE Invoice
119 = Lot PO Invoice
TRANSDATE Date Transaction Date
QTY BCD*10.4 Transaction Quantity
TRANSUOM String*10 Transaction Unit Of Measure Mask: %-10w
TRANSCONV BCD*10.6 Transaction conversion Factor
STKQTY BCD*10.4 Stock Quantity
COST BCD*10.3 Extended Cost
DOCNUM String*22 Document Number Mask: %-22C
DETAILNUM Integer Detail Number
FISCYEAR String*4 Fiscal Year Mask: %4D
FISCPERIOD Integer Fiscal Period
WARRCODE String*6 Warranty Code Mask: %-6N
CUSTVEND String*12 Customer/Vendor Number
RECALLED Boolean Recalled List:2 entries
0 = No
1 = Yes
RECALLDATE Date Date Recalled
INUSE1 Boolean Warranty Period 1 Is In Use List:2 entries
0 = No
1 = Yes
DATE1 Date Warranty Period 1 Expiry Date
EFFDATE1 Date Warranty Period 1 Effective Date
LIFEWARR1 Boolean Warranty Period 1 Lifetime List:2 entries
0 = No
1 = Yes
INUSE2 Boolean Warranty Period 2 Is In Use List:2 entries
0 = No
1 = Yes
DATE2 Date Warranty Period 2 Expiry Date
EFFDATE2 Date Warranty Period 2 Effective Date
LIFEWARR2 Boolean Warranty Period 2 Lifetime List:2 entries
0 = No
1 = Yes
INUSE3 Boolean Warranty Period 3 Is In Use List:2 entries
0 = No
1 = Yes
DATE3 Date Warranty Period 3 Expiry Date
EFFDATE3 Date Warranty Period 3 Effective Date
LIFEWARR3 Boolean Warranty Period 3 Lifetime List:2 entries
0 = No
1 = Yes
INUSE4 Boolean Warranty Period 4 Is In Use List:2 entries
0 = No
1 = Yes
DATE4 Date Warranty Period 4 Expiry Date
EFFDATE4 Date Warranty Period 4 Effective Date
LIFEWARR4 Boolean Warranty Period 4 Lifetime List:2 entries
0 = No
1 = Yes
INUSE5 Boolean Warranty Period 5 Is In Use List:2 entries
0 = No
1 = Yes
DATE5 Date Warranty Period 5 Expiry Date
EFFDATE5 Date Warranty Period 5 Effective Date
LIFEWARR5 Boolean Warranty Period 5 Lifetime List:2 entries
0 = No
1 = Yes
DRILSRCTY Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
ENTEREDBY String*8 Entered By Mask: %-8N