Table: Serial Number History

Table: ICXSHIS
View: IC0835
Record Length: 274

Flags: A R 

Keys: 8

Title Flags Fields

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

Fields: 47

Field Type Title Presentation

SERIALNUM String*40 Unformatted Serial Number
ITEMNUM String*24 Unformatted Item Number Mask: %-24C
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
LOCATION String*6 Location Mask: %-6N
APP String*2 Source Application
TRANSTYPE Integer Transaction Type List:24 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
116 = Serial Receipt
117 = Serial Shipment
120 = Serial OE Invoice
121 = Serial PO Invoice
TRANSDATE Date Transaction Date
STOCKED Integer Stocked
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
REGISTERED Boolean Registered List:2 entries
0 = No
1 = Yes
REGISTDATE Date Date Registered
CUSTVEND String*12 Customer/Vendor Number Mask: %-12C
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