# View: Serial Number History

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

## Compositions: 0

## 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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.