# View: Inventory Lot Numbers

RotoID: IC0810
Table: ICXLOT
Protocol: Header
DLL: ICXLOT

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
IC0812 | ICXLOTO | Lot Optional Fields | ICXLOTO

## Keys: 8

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

## Fields: 46

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
LOTNUM | 1 | String*40 | Unformatted Lot Number | E A K R |
ITEMNUM | 2 | String*24 | Unformatted Item Number | E A K R | Mask: %-24C
LOCATION | 3 | String*6 | Location | E A K R | Mask: %-6N
QTYAVAIL | 4 | BCD*10.4 | Quantity Available | E A |
QTYORDED | 5 | BCD*10.4 | Quantity On order | E A |
STOCKDATE | 6 | Date | Stock Date | E A |
EXPIRYDATE | 7 | Date | Expiry Date | E A |
QUARTRELDT | 8 | Date | Quarantine Release Date | A X |
LOTNUMF | 9 | String*40 | Lot Number | E A |
QTYLEVEL | 10 | Integer | Quantity Level | A C | List: 3 entries
0 | = | Quantity Zero
1 | = | Quantity Above Zero
-1 | = | Quantity Below Zero
ASSETQTY | 11 | BCD*10.4 | Quantity For Costing | E A |
ASSETCOST | 12 | BCD*10.3 | Cost for Costing | E A |
RECALLED | 13 | Boolean | Recalled | E A X | List: 2 entries
0 | = | No
1 | = | Yes
RECALLDATE | 14 | Date | Date Recalled | E A X |
CONTCODE | 15 | String*6 | Contract Code | E A | Mask: %-6N
VALUES | 16 | Long | Optional Fields | E A C |
INUSE1 | 17 | Boolean | Contract Period 1 In Use | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATE1 | 18 | Date | Contract Period 1 Expiry Date | E A |
EFFDATE1 | 19 | Date | Contract Period 1 Effective Date | E A |
LIFECONT1 | 20 | Boolean | Contract Period 1 Lifetime | E A | List: 2 entries
0 | = | No
1 | = | Yes
INUSE2 | 21 | Boolean | Contract Period 2 In Use | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATE2 | 22 | Date | Contract Period 2 Expiry Date | E A |
EFFDATE2 | 23 | Date | Contract Period 2 Effective Date | E A |
LIFECONT2 | 24 | Boolean | Contract Period 2 Lifetime | E A | List: 2 entries
0 | = | No
1 | = | Yes
INUSE3 | 25 | Boolean | Contract Period 3 In Use | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATE3 | 26 | Date | Contract Period 3 Expiry Date | E A |
EFFDATE3 | 27 | Date | Contract Period 3 Effective Date | E A |
LIFECONT3 | 28 | Boolean | Contract Period 3 Lifetime | E A | List: 2 entries
0 | = | No
1 | = | Yes
INUSE4 | 29 | Boolean | Contract Period 4 In Use | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATE4 | 30 | Date | Contract Period 4 Expiry Date | E A |
EFFDATE4 | 31 | Date | Contract Period 4 Effective Date | E A |
LIFECONT4 | 32 | Boolean | Contract Period 4 Lifetime | E A | List: 2 entries
0 | = | No
1 | = | Yes
INUSE5 | 33 | Boolean | Contract Period 5 In Use | E A | List: 2 entries
0 | = | No
1 | = | Yes
DATE5 | 34 | Date | Contract Period 5 Expiry Date | E A |
EFFDATE5 | 35 | Date | Contract Period 5 Effective Date | E A |
LIFECONT5 | 36 | Boolean | Contract Period 5 Lifetime | E A | List: 2 entries
0 | = | No
1 | = | Yes
ONQUART | 37 | Boolean | Lot On Quarantine | E A | List: 2 entries
0 | = | No
1 | = | Yes
ONQUARTDT | 38 | Date | Date Quarantineed | A C |
STATUS | 50 | Integer | Status | E A | List: 2 entries
0 | = | Not Available
1 | = | Available
CONTDESC | 51 | String*60 | Description | A C |
DESC1 | 52 | String*60 | Contract Period 1 Description | A C |
DESC2 | 53 | String*60 | Contract Period 2 Description | A C |
DESC3 | 54 | String*60 | Contract Period 3 Description | A C |
DESC4 | 55 | String*60 | Contract Period 4 Description | A C |
DESC5 | 56 | String*60 | Contract Period 5 Description | A C |
QTYSHPABLE | 57 | BCD*10.4 | Quantity Shippable | A C |

This page was generated on 2009-Nov-19

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