Table: Inventory Lot Numbers

Table: ICXLOT
View: IC0810
Record length: 285
Flags: A R 

Keys: 8

Title  Flags  Fields

Lot/Item/Location  LOTNUM, ITEMNUM, LOCATION
Item/Lot  D M  ITEMNUM, LOTNUM
Location/Item  D M  LOCATION, ITEMNUM
Location/Lot  D M  LOCATION, LOTNUM
Item/Location/Qty. Level/Lot  M  ITEMNUM, LOCATION, QTYLEVEL, LOTNUM
Item/Location/Qty. Level/Stock D  M  ITEMNUM, LOCATION, QTYLEVEL, STOCKDATE, LOTNUM
Item/Location/Qty. Level/Expiry  M  ITEMNUM, LOCATION, QTYLEVEL, EXPIRYDATE, LOTNUM
Stock Date/Qty Avail/Asset Qty/A  M  STOCKDATE, QTYAVAIL, ASSETQTY, ITEMNUM, LOCATION, LOTNUM

Fields: 42

Field  Type  Title  Presentation 

LOTNUM  String*40  Unformatted Lot Number   
ITEMNUM  String*24  Unformatted Item Number  Mask: %-24C
LOCATION  String*6  Location  Mask: %-6N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
QTYAVAIL  BCD*10.4  Quantity Available   
QTYORDED  BCD*10.4  Quantity On order   
STOCKDATE  Date  Stock Date   
EXPIRYDATE  Date  Expiry Date   
QUARTRELDT  Date  Quarantine Release Date   
LOTNUMF  String*40  Lot Number   
QTYLEVEL  Integer  Quantity Level  List: 3 entries
0=Quantity Zero
1=Quantity Above Zero
-1=Quantity Below Zero
ASSETQTY  BCD*10.4  Quantity For Costing   
ASSETCOST  BCD*10.3  Cost for Costing   
RECALLED  Boolean  Recalled  List: 2 entries
0=No
1=Yes
RECALLDATE  Date  Date Recalled   
CONTCODE  String*6  Contract Code  Mask: %-6N
VALUES  Long  Optional Fields   
INUSE1  Boolean  Contract Period 1 In Use  List: 2 entries
0=No
1=Yes
DATE1  Date  Contract Period 1 Expiry Date   
EFFDATE1  Date  Contract Period 1 Effective Date   
LIFECONT1  Boolean  Contract Period 1 Lifetime  List: 2 entries
0=No
1=Yes
INUSE2  Boolean  Contract Period 2 In Use  List: 2 entries
0=No
1=Yes
DATE2  Date  Contract Period 2 Expiry Date   
EFFDATE2  Date  Contract Period 2 Effective Date   
LIFECONT2  Boolean  Contract Period 2 Lifetime  List: 2 entries
0=No
1=Yes
INUSE3  Boolean  Contract Period 3 In Use  List: 2 entries
0=No
1=Yes
DATE3  Date  Contract Period 3 Expiry Date   
EFFDATE3  Date  Contract Period 3 Effective Date   
LIFECONT3  Boolean  Contract Period 3 Lifetime  List: 2 entries
0=No
1=Yes
INUSE4  Boolean  Contract Period 4 In Use  List: 2 entries
0=No
1=Yes
DATE4  Date  Contract Period 4 Expiry Date   
EFFDATE4  Date  Contract Period 4 Effective Date   
LIFECONT4  Boolean  Contract Period 4 Lifetime  List: 2 entries
0=No
1=Yes
INUSE5  Boolean  Contract Period 5 In Use  List: 2 entries
0=No
1=Yes
DATE5  Date  Contract Period 5 Expiry Date   
EFFDATE5  Date  Contract Period 5 Effective Date   
LIFECONT5  Boolean  Contract Period 5 Lifetime  List: 2 entries
0=No
1=Yes
ONQUART  Boolean  Lot On Quarantine  List: 2 entries
0=No
1=Yes
ONQUARTDT  Date  Date Quarantineed   

This page was generated on 2009-Nov-19

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