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 2023-Aug-31

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