 |
Lawson Insight Technical Documentation |
|
ICLOT FILE
Lots with Expire Date/On Hold
The Lots with Expire Date/On Hold file stores the expiration dates and/or the
hold flag for lots. These records are created only if a lot has an expiration
date or if it has been put on hold.
REFERENCED BY
IC230 IC29.1 IC41.1 IC42.1 IC42.2 IC42.4
UPDATED BY
IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1
IC22.2 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1
IC26.1 IC26.2 IC27.1 IC300 IC500 IC820
IC90.1 ICI2.1 POIJ.1 WH130 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILT-COMPANY Numeric 4 IC175 IC20.1
Company The company number represents an IC20.2 IC21.1
established company and is entered on IC21.2 IC22.1
all function codes. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC27.1 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ILT-LOCATION Alpha 5 IC175 IC20.1
Location Code This field contains a valid stocking IC20.2 IC21.1
location within the company inventory. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC27.1 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ILT-ITEM Alpha 32 IC175 IC20.1
Item Number This field contains the item IC20.2 IC21.1
identifier. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC27.1 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ILT-LOT Alpha 10 IC175 IC20.1
Lot Number This field contains the identifier for IC20.2 IC21.1
a homogeneous quantity of material. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC27.1 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ILT-EXPIRE-DATE Numeric 8 (yyyymmdd) IC175 IC20.1
Expiration Date This field contains the expiration date IC20.2 IC21.1
for an entire lot. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC27.1 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ILT-HOLD-FLAG Alpha 1 IC175 IC20.1
On Hold Flag This field allows an entire lot to be IC20.2 IC21.1
put on hold, not allowing any issues or IC21.2 IC22.1
transfers to be made for this lot. IC22.2 IC23.1
Y = Lot Is On Hold IC23.2 IC24.1
N = Lot Is Not On Hold. IC24.2 IC25.1
IC26.1 IC26.2
IC27.1 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ILT-HOLD-FL-VALUE Derived
Hold Fl Value This field is derived from the Hold
Flag field.
ICLOT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILTSET1 COMPANY IC175 IC20.1
LOCATION IC20.2 IC21.1
ITEM IC21.2 IC22.1
LOT IC22.2 IC23.1
IC23.2 IC230
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC27.1
IC29.1 IC300
IC41.1 IC42.1
IC42.2 IC42.4
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
...
ICLOT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
ILT-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
ILT-COMPANY -> ICL-COMPANY
ILT-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
ILT-COMPANY -> ITL-COMPANY
ILT-LOCATION -> ITL-LOCATION
ILT-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ILT-ITEM -> ITE-ITEM
ICLOT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sohdetail SOHDETAIL
ILT-COMPANY -> SDT-COMPANY
ILT-LOCATION -> SDT-LOCATION
ILT-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
|