Table: Lot Number History

Table: ICXLHIS
View: IC0815
Record Length: 312

Flags: A R 

Keys: 7

Title Flags Fields

Lot Number LOTNUM, ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM
Item Number ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM, LOTNUM
Customer/Vendor Lot D M  APP, CUSTVEND, LOTNUM, ITEMNUM, TRANSDATE, TRANSTYPE
Customer/Vendor Item D M  APP, CUSTVEND, ITEMNUM, LOTNUM, TRANSDATE, TRANSTYPE
Dayend Sequence DAYENDSEQ, ENTRYSEQ, LOTNUM, ITEMNUM, LOCATION, LINENO, COMPNUM
Document Number DOCNUM, DETAILNUM, LOTNUM, ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM
Transaction Date TRANSDATE, ITEMNUM, LOTNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM

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