Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICLOT


                               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
IC44.1

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.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     MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.2
MA66.3    MA67.1    MA67.2    MA70.1    MA75.1    MA80.1
MAI1.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     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE81.1    OE810
OE830     OE90.1    OE90.2    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     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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ILT-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP25.1
                       resource type = V.  Identifies the HR     AP25.2  AP26.1
                       company if the resource type = E.  It is  AP27.1  AP30.4
                       blank for type A, P or Q resources.       BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.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
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...

ILT-LOCATION           Alpha 5                                   AP125   AP126
Element: Location Code This field contains a valid stocking      AP131   AP25.1
                       location within the company inventory.    AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.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
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...

ILT-ITEM               Alpha 32                                  AP125   AP126
Element: Item Number   This field contains the item              AP131   AP25.1
                       identifier.                               AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.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
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...

ILT-LOT                Alpha 10                                  AP125   AP126
Element: Lot Number    This field contains the identifier for    AP131   AP25.1
                       a homogeneous quantity of material.       AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.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
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...

ILT-EXPIRE-DATE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Expiration DatThis field contains the expiration date   AP131   AP25.1
                       for an entire lot.                        AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.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
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...

ILT-HOLD-FLAG          Alpha 1                                   AP125   AP126
Element: 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  AP30.4
                       Y = Lot Is On Hold                        BL120   BL122
                       N = Lot Is Not On Hold.                   BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.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
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...

ILT-HOLD-FL-VALUE      Derived
Element: 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  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC230
                                                                 ...

                         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