ICITLUF

Item Location User Field

REFERENCED BY
IC524


UPDATED BY
IC12.1 IC320

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFL-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.
IC12.1 IC320
UFL-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC12.1 IC320
UFL-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
IC12.1
UFL-ITL-USR-FLD-01
Element: Itl Usr Fld 01
Alpha 20
IC12.1 IC320
UFL-ITL-USR-FLD-02
Element: Itl Usr Fld 02
Alpha 20
IC12.1 IC320
UFL-ITL-USR-FLD-03
Element: Itl Usr Fld 03
Alpha 20
IC12.1 IC320
UFL-ITL-USR-FLD-04
Element: Itl Usr Fld 04
Alpha 20
IC12.1 IC320
UFL-ITL-USR-FLD-05
Element: Itl Usr Fld 05
Alpha 20
IC12.1 IC320


ICITLUF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFLSET1 COMPANY
LOCATION
ITEM
IC12.1 IC320
IC524


ICITLUF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemloc ITEMLOC Required
UFL-COMPANY->ITL-COMPANY
UFL-LOCATION->ITL-LOCATION
UFL-ITEM->ITL-ITEM


File created: Thu Jun 09 02:18:42 2016

Home
Contact Us



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