View: Serial Number History

RotoID: IC0835
Table: ICXSHIS
Protocol: Flat
DLL:ICXSHIS

Keys: 8

Title Fields
Serial Number SERIALNUM, ITEMNUM, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM
Item Number ITEMNUM, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM, SERIALNUM
Customer/Vendor Serial APP, CUSTVEND, SERIALNUM, ITEMNUM, TRANSDATE, TRANSTYPE
Customer/Vendor Item 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: 53

Field Index Type Title Attributes Presentation
SERIALNUM 1 String*40 Unformatted Serial Number E A K R 
ITEMNUM 2 String*24 Unformatted Item Number E A K R  Mask: %-24C
DAYENDSEQ 3 Long Day End Number E A K R 
ENTRYSEQ 4 Long Transaction Sequence E A K R 
LINENO 5 Integer Line Number E A K R 
COMPNUM 6 Long Component Number E A K R 
LOCATION 7 String*6 Location E A  Mask: %-6N
APP 8 String*2 Source Application E A 
TRANSTYPE 9 Integer Transaction Type E A  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 10 Date Transaction Date E A 
STOCKED 11 Integer Stocked E A 
COST 12 BCD*10.3 Extended Cost E A 
DOCNUM 13 String*22 Document Number E A  Mask: %-22C
DETAILNUM 14 Integer Detail Number E A 
FISCYEAR 15 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 16 Integer Fiscal Period E A 
WARRCODE 17 String*6 Warranty Code E A  Mask: %-6N
REGISTERED 18 Boolean Registered E A  List:2 entries
0 = No
1 = Yes
REGISTDATE 19 Date Date Registered A C 
CUSTVEND 20 String*12 Customer/Vendor Number E A  Mask: %-12C
INUSE1 21 Boolean Warranty Period 1 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE1 22 Date Warranty Period 1 Expiry Date E A 
EFFDATE1 23 Date Warranty Period 1 Effective Date E A 
LIFEWARR1 24 Boolean Warranty Period 1 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE2 25 Boolean Warranty Period 2 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE2 26 Date Warranty Period 2 Expiry Date E A 
EFFDATE2 27 Date Warranty Period 2 Effective Date E A 
LIFEWARR2 28 Boolean Warranty Period 2 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE3 29 Boolean Warranty Period 3 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE3 30 Date Warranty Period 3 Expiry Date E A 
EFFDATE3 31 Date Warranty Period 3 Effective Date E A 
LIFEWARR3 32 Boolean Warranty Period 3 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE4 33 Boolean Warranty Period 4 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE4 34 Date Warranty Period 4 Expiry Date E A 
EFFDATE4 35 Date Warranty Period 4 Effective Date E A 
LIFEWARR4 36 Boolean Warranty Period 4 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE5 37 Boolean Warranty Period 5 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE5 38 Date Warranty Period 5 Expiry Date E A 
EFFDATE5 39 Date Warranty Period 5 Effective Date E A 
LIFEWARR5 40 Boolean Warranty Period 5 Lifetime E A  List:2 entries
0 = No
1 = Yes
DRILSRCTY 41 Integer Drill Down Type E A 
DRILLDWNLK 42 BCD*10.0 Drill Down Link Number E A 
ENTEREDBY 43 String*8 Entered By E A  Mask: %-8N
WARRDESC 75 String*60 Warranty Description A C 
DESC1 76 String*60 Warranty Period 1 Description A C 
DESC2 77 String*60 Warranty Period 2 Description A C 
DESC3 78 String*60 Warranty Period 3 Description A C 
DESC4 79 String*60 Warranty Period 4 Description A C 
DESC5 80 String*60 Warranty Period 5 Description A C 
STATUS 81 Integer Status A C  List:3 entries
0 = Adjusted
-1 = Removed
1 = Added
OEINVNUM 82 String*22 O/E Invoice Number A C 
POINVNUM 83 String*22 P/O Invoice Number A C 
POCRNNUM 84 String*22 P/O Credit Note Number A C 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).