Table: Inventory Lot Numbers

Table: ICXLOT
View: IC0810
Record Length: 285

Flags: A R 

Keys: 8

Title Flags Fields

Lot/Item/Location LOTNUMITEMNUMLOCATION
Item/Lot D M  ITEMNUMLOTNUM
Location/Item D M  LOCATIONITEMNUM
Location/Lot D M  LOCATIONLOTNUM
Item/Location/Qty. Level/Lot M  ITEMNUMLOCATIONQTYLEVELLOTNUM
Item/Location/Qty. Level/Stock D M  ITEMNUMLOCATIONQTYLEVELSTOCKDATELOTNUM
Item/Location/Qty. Level/Expiry M  ITEMNUMLOCATIONQTYLEVELEXPIRYDATELOTNUM
Stock Date/Qty Avail/Asset Qty/A M  STOCKDATEQTYAVAILASSETQTYITEMNUMLOCATIONLOTNUM

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