|
|
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
|
