View: Lot Number History

RotoID: IC0815
Table: ICXLHIS
Protocol: Flat
DLL:ICXLHIS

Keys: 7

Title Fields
Lot Number LOTNUM, ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM
Item Number ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM, LOTNUM
Customer/Vendor Lot APP, CUSTVEND, LOTNUM, ITEMNUM, TRANSDATE, TRANSTYPE
Customer/Vendor Item APP, CUSTVEND, ITEMNUM, LOTNUM, TRANSDATE, TRANSTYPE
Dayend Sequence DAYENDSEQ, ENTRYSEQ, LOTNUM, ITEMNUM, LOCATION, LINENO, COMPNUM
Document Number DOCNUM, DETAILNUM, LOTNUM, ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM
Transaction Date TRANSDATE, ITEMNUM, LOTNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM

Fields: 56

Field Index Type Title Attributes Presentation
LOTNUM 1 String*40 Unformatted Lot Number E A K R 
ITEMNUM 2 String*24 Unformatted Item Number E A K R  Mask: %-24C
LOCATION 3 String*6 Location E A K R  Mask: %-6N
DAYENDSEQ 4 Long Day End Number E A K R 
ENTRYSEQ 5 Long Transaction Sequence E A K R 
LINENO 6 Integer Line Number E A K R 
COMPNUM 7 Long Component Number E A K R 
APP 8 String*2 Source Application E A 
TRANSTYPE 9 Integer Transaction Type E A  List:28 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
100 = Lot Recall
111 = Lot Recall Release
112 = Lot Combine
113 = Lot Split
114 = Lot Receipt
115 = Lot Shipment
118 = Lot OE Invoice
119 = Lot PO Invoice
TRANSDATE 10 Date Transaction Date E A 
QTY 11 BCD*10.4 Transaction Quantity E A 
TRANSUOM 12 String*10 Transaction Unit Of Measure E A  Mask: %-10w
TRANSCONV 13 BCD*10.6 Transaction conversion Factor E A 
STKQTY 14 BCD*10.4 Stock Quantity E A 
COST 15 BCD*10.3 Extended Cost E A 
DOCNUM 16 String*22 Document Number E A  Mask: %-22C
DETAILNUM 17 Integer Detail Number E A 
FISCYEAR 18 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 19 Integer Fiscal Period E A 
WARRCODE 20 String*6 Warranty Code E A  Mask: %-6N
CUSTVEND 21 String*12 Customer/Vendor Number E A 
RECALLED 22 Boolean Recalled E A X  List:2 entries
0 = No
1 = Yes
RECALLDATE 23 Date Date Recalled E A X 
INUSE1 24 Boolean Warranty Period 1 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE1 25 Date Warranty Period 1 Expiry Date E A 
EFFDATE1 26 Date Warranty Period 1 Effective Date E A 
LIFEWARR1 27 Boolean Warranty Period 1 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE2 28 Boolean Warranty Period 2 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE2 29 Date Warranty Period 2 Expiry Date E A 
EFFDATE2 30 Date Warranty Period 2 Effective Date E A 
LIFEWARR2 31 Boolean Warranty Period 2 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE3 32 Boolean Warranty Period 3 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE3 33 Date Warranty Period 3 Expiry Date E A 
EFFDATE3 34 Date Warranty Period 3 Effective Date E A 
LIFEWARR3 35 Boolean Warranty Period 3 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE4 36 Boolean Warranty Period 4 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE4 37 Date Warranty Period 4 Expiry Date E A 
EFFDATE4 38 Date Warranty Period 4 Effective Date E A 
LIFEWARR4 39 Boolean Warranty Period 4 Lifetime E A  List:2 entries
0 = No
1 = Yes
INUSE5 40 Boolean Warranty Period 5 Is In Use E A  List:2 entries
0 = No
1 = Yes
DATE5 41 Date Warranty Period 5 Expiry Date E A 
EFFDATE5 42 Date Warranty Period 5 Effective Date E A 
LIFEWARR5 43 Boolean Warranty Period 5 Lifetime E A  List:2 entries
0 = No
1 = Yes
DRILSRCTY 44 Integer Drill Down Type E A 
DRILLDWNLK 45 BCD*10.0 Drill Down Link Number E A 
ENTEREDBY 46 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 2021-Nov-24

© 2021 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).