ICITEUF – Item User Field

System
Inventory Control (IC)
Prefix
UFM
Primary key
ITEM-GROUP, ITEM
Fields
7
Updated by
1 program
Referenced by
4 programs

ICITEUF is the Item User Field table in Lawson Inventory Control (prefix UFM). It is indexed by ITEM-GROUP, ITEM (UFMSET1). It is related 1:1 to ITEMMAST. It is updated by IC11.1 and referenced by IC46.1, IC524, IC800 and POAP.1. The table has 7 fields, 1 index and 1 documented relation.

About ICITEUF

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the UFM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#UFM-ITEM-GROUP PK
ITEM_GROUP		Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC11.1
#UFM-ITEM PK
ITEM		Alpha 32This field contains the item identifier.IC11.1
#UFM-ITE-USR-FLD-01
ITE_USR_FLD_01		Alpha 20—IC11.1
#UFM-ITE-USR-FLD-02
ITE_USR_FLD_02		Alpha 20—IC11.1
#UFM-ITE-USR-FLD-03
ITE_USR_FLD_03		Alpha 20—IC11.1
#UFM-ITE-USR-FLD-04
ITE_USR_FLD_04		Alpha 20—IC11.1
#UFM-ITE-USR-FLD-05
ITE_USR_FLD_05		Alpha 20—IC11.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
UFMSET1
  1. ITEM-GROUP
  2. ITEM
PrimaryIC11.1, IC46.1, IC524, IC800, POAP.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ITEMMASTICITEUF

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemmastITEMMASTRequired
UFM-ITEM-GROUP→ITE-ITEM-GROUP
UFM-ITEM→ITE-ITEM

Programs

Updated by (1)

Referenced by (4)