Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICITLUF


                              ICITLUF FILE

UPDATED BY

IC12.1    IC320

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

UFL-COMPANY            Numeric 4                                 IC12.1  IC320
Element: Company       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.

UFL-LOCATION           Alpha 5                                   IC12.1  IC320
Element: Location      This field contains a valid stocking
                       location within the company inventory.

UFL-ITEM               Alpha 32                                  IC12.1
Element: Item          This field contains the item
                       identifier.

UFL-ITL-USR-FLD-01     Alpha 20                                  IC12.1  IC320
Element: Itl Usr Fld 01

UFL-ITL-USR-FLD-02     Alpha 20                                  IC12.1  IC320
Element: Itl Usr Fld 02

UFL-ITL-USR-FLD-03     Alpha 20                                  IC12.1  IC320
Element: Itl Usr Fld 03

UFL-ITL-USR-FLD-04     Alpha 20                                  IC12.1  IC320
Element: Itl Usr Fld 04

UFL-ITL-USR-FLD-05     Alpha 20                                  IC12.1  IC320
Element: Itl Usr Fld 05

                         ICITLUF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UFLSET1   COMPANY                                                IC12.1  IC320
          LOCATION
          ITEM

                         ICITLUF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemloc        ITEMLOC      Required

                            UFL-COMPANY     -> ITL-COMPANY
                            UFL-LOCATION    -> ITL-LOCATION
                            UFL-ITEM        -> ITL-ITEM