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: 49

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 
ASSETUCST 58 BCD*10.6 Asset Unit Cost A C 
EDITFROMUI 59 Boolean Updated by UI? E A  List:2 entries
0 = No
1 = Yes
HOMECURDEC 60 Integer Home Currency Decimals E A C 

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