# 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.