Table: Serial Number History

Table: ICXSHIS
View: IC0835
Record Length: 274

Flags: A R 

Keys: 8

Title Flags Fields

Serial Number SERIALNUMITEMNUMDAYENDSEQENTRYSEQLINENOCOMPNUM
Item Number ITEMNUMDAYENDSEQENTRYSEQLINENOCOMPNUMSERIALNUM
Customer/Vendor Serial D M  APPCUSTVENDSERIALNUMITEMNUMTRANSDATETRANSTYPE
Customer/Vendor Item D M  APPCUSTVENDITEMNUMSERIALNUMTRANSDATETRANSTYPE
Dayend Sequence DAYENDSEQENTRYSEQSERIALNUMITEMNUMLINENOCOMPNUM
Document Number DOCNUMDETAILNUMSERIALNUMITEMNUMDAYENDSEQENTRYSEQLINENOCOMPNUM
Document Type APPTRANSTYPEDOCNUMITEMNUMSERIALNUMDAYENDSEQENTRYSEQLINENOCOMPNUM
Transaction Date TRANSDATEITEMNUMSERIALNUMDAYENDSEQENTRYSEQLINENOCOMPNUM

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