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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
UFM-ITEM-GROUP PKITEM_GROUP | Alpha 5 | This field contains the identifier for a group of items that can be shared by one or more companies. | IC11.1 |
UFM-ITEM PKITEM | Alpha 32 | This field contains the item identifier. | IC11.1 |
UFM-ITE-USR-FLD-01ITE_USR_FLD_01 | Alpha 20 | — | IC11.1 |
UFM-ITE-USR-FLD-02ITE_USR_FLD_02 | Alpha 20 | — | IC11.1 |
UFM-ITE-USR-FLD-03ITE_USR_FLD_03 | Alpha 20 | — | IC11.1 |
UFM-ITE-USR-FLD-04ITE_USR_FLD_04 | Alpha 20 | — | IC11.1 |
UFM-ITE-USR-FLD-05ITE_USR_FLD_05 | Alpha 20 | — | IC11.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
UFMSET1 | ITEM-GROUP, ITEM | Primary | IC11.1, IC46.1, IC524, IC800, POAP.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Itemmast | ITEMMAST | Required | UFM-ITEM-GROUP → ITE-ITEM-GROUP, UFM-ITEM → ITE-ITEM |
Programs
Updated by (1)
- IC11.1 Item Master