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
PO32.2 PO39.1
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC141 IC142 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 IC83.1 IC90.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113
OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE810 OE830 OE90.1 OE920 OE950 PO30.1
PO31.1 PO33.1 PO34.1 PO35.1 PO530 RQ10.1
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1 RQ35.1
RQ500 RQ961 WH130 WH132 WH190 WH20.1
WH20.2 WH20.3 WH20.4 WH20.5 WH20.6 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 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 WO120 WO132 WO140 WO20.1
WO30.1 WO32.1 WO32.2 WO32.3 WO32.4 WO32.5
WO40.1 WO40.2 WO40.3 WO40.4 WO40.5 WO41.1
WO41.2 WO41.3 WO41.4 WO42.1 WO42.2 WO42.3
WO42.4 WO42.5 WO45.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILT-COMPANY Numeric 4 BL92.1 CX100
Company The company number represents an CX20.1 CX20.2
established company and is entered on CX20.4 CX20.5
all function codes. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ILT-LOCATION Alpha 5 BL92.1 CX100
Location Code This field contains a valid stock CX20.1 CX20.2
location within the company inventory. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ILT-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ILT-LOT Alpha 10 BL92.1 CX100
Lot Number This field contains the identifier for CX20.1 CX20.2
a homogeneous quantity of material. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ILT-EXPIRE-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Expiration Date This field contains the expiration date CX20.1 CX20.2
for an entire lot. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ILT-HOLD-FLAG Alpha 1 BL92.1 CX100
On Hold Flag This field allows an entire lot to be CX20.1 CX20.2
put on hold, not allowing any issues or CX20.4 CX20.5
transfers to be made for this lot. CX220 CX30.1
Y = Lot is on hold CX300 CX506
N = Lot is not on hold. CXCP.1 DR100
IC141 IC142
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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.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 BL92.1 CX100
LOCATION CX20.1 CX20.2
ITEM CX20.4 CX20.5
LOT CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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
...
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
|