 |
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 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 IC28.1 IC300
IC500 IC820 IC90.1 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 PO100 PO101
PO122 PO131 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POI3.1 POIE.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ35.1 WH130 WH132
WH190 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILT-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 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
IC28.1 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
...
ILT-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 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
IC28.1 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
...
ILT-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 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
IC28.1 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
...
ILT-LOT Alpha 10 AP125 AP126
Lot Number This field contains the identifier for AP131 AP25.1
a homogeneous quantity of material. AP25.2 AP26.1
AP27.1 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
IC28.1 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
...
ILT-EXPIRE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Expiration Date This field contains the expiration date AP131 AP25.1
for an entire lot. AP25.2 AP26.1
AP27.1 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
IC28.1 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
...
ILT-HOLD-FLAG Alpha 1 AP125 AP126
On Hold Flag This field allows an entire lot to be AP131 AP25.1
put on hold, not allowing any issues or AP25.2 AP26.1
transfers to be made for this lot. AP27.1 IC175
Y = Lot Is On Hold IC20.1 IC20.2
N = Lot Is Not On Hold. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC27.1
IC28.1 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
...
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 AP125 AP126
LOCATION AP131 AP25.1
ITEM AP25.2 AP26.1
LOT AP27.1 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC230 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC27.1 IC28.1
IC29.1 IC300
IC41.1 IC42.1
IC42.2 IC42.4
...
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
|