ICLOT

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.
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILT-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
ILT-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
ILT-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
ILT-LOT
Element: Lot
Alpha 10
This field contains the identifier for a homogeneous quantity of material.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
ILT-EXPIRE-DATE
Element: Expire Date
Numeric 8 (yyyymmdd)
This field contains the expiration date for an entire lot.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
ILT-HOLD-FLAG
Element: Hold Flag
Alpha 1
This field allows an entire lot to be put on hold, not allowing any issues or transfers to be made for this lot.
Y = Lot Is On Hold
N = Lot Is Not On Hold.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
ILT-HOLD-FL-VALUE
Element: Hold Fl Value
Derived
This field is derived from the Hold Flag field.


ICLOT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILTSET1 COMPANY
LOCATION
ITEM
LOT
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


ICLOT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:49:38 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.