View: Lot Number History

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

Compositions: 0

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
Lot Number  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  String*40  Unformatted Lot Number  E A K R   
ITEMNUM  String*24  Unformatted Item Number  E A K R  Mask: %-24C
LOCATION  String*6  Location  E A K R  Mask: %-6N
DAYENDSEQ  Long  Day End Number  E A K R   
ENTRYSEQ  Long  Transaction Sequence  E A K R   
LINENO  Integer  Line Number  E A K R   
COMPNUM  Long  Component Number  E A K R   
APP  String*2  Source Application  E A   
TRANSTYPE  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 2009-Nov-19

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