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.