Table: Lot Number History

Table: ICXLHIS
View: IC0815
Record length: 312
Flags: A R 

Keys: 7

Title  Flags  Fields
Lot Number  LOTNUM, ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM
Item Number  ITEMNUM, LOCATION, DAYENDSEQ, ENTRYSEQ, LINENO, COMPNUM, LOTNUM
Customer/Vendor Lot  D M  APP, CUSTVEND, LOTNUM, ITEMNUM, TRANSDATE, TRANSTYPE
Customer/Vendor Item  D M  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: 50

Field  Type  Title  Presentation 
LOTNUM  String*40  Unformatted Lot Number   
ITEMNUM  String*24  Unformatted Item Number  Mask: %-24C
LOCATION  String*6  Location  Mask: %-6N
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     
APP  String*2  Source Application   
TRANSTYPE  Integer  Transaction Type  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  Date  Transaction Date   
QTY  BCD*10.4  Transaction Quantity   
TRANSUOM  String*10  Transaction Unit Of Measure  Mask: %-10w
TRANSCONV  BCD*10.6  Transaction conversion Factor   
STKQTY  BCD*10.4  Stock Quantity   
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
CUSTVEND  String*12  Customer/Vendor Number   
RECALLED  Boolean  Recalled  List: 2 entries
0=No
1=Yes
RECALLDATE  Date  Date Recalled   
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.