# 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

This page was generated on 2009-Nov-19

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