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.