ICITSUF – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
UFS
Primary key
ITEM-GROUP, ITEM, SUB-TYPE, SUB-ITEM
Fields
9
Updated by
1 program
Referenced by
0 programs

ICITSUF is a Lawson Inventory Control table (prefix UFS); no description in the lawson data dictionary. It is indexed by ITEM-GROUP, ITEM, SUB-TYPE, SUB-ITEM (UFSSET1). It is updated by IC13.1. The table has 9 fields, 1 index and 0 documented relations.

About ICITSUF

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the UFS- 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
#UFS-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.IC13.1
#UFS-ITEM PK
ITEM		Alpha 32This field contains the item identifier.IC13.1
#UFS-SUB-TYPE PK
SUB_TYPE		Alpha 10An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. Subtypes must be unique within an asset type.IC13.1
#UFS-SUB-ITEM PK
SUB_ITEM		Alpha 32This field contains the item identifier.IC13.1
#UFS-ITS-USR-FLD-01
ITS_USR_FLD_01		Alpha 20—IC13.1
#UFS-ITS-USR-FLD-02
ITS_USR_FLD_02		Alpha 20—IC13.1
#UFS-ITS-USR-FLD-03
ITS_USR_FLD_03		Alpha 20—IC13.1
#UFS-ITS-USR-FLD-04
ITS_USR_FLD_04		Alpha 20—IC13.1
#UFS-ITS-USR-FLD-05
ITS_USR_FLD_05		Alpha 20—IC13.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
UFSSET1
  1. ITEM-GROUP
  2. ITEM
  3. SUB-TYPE
  4. SUB-ITEM
PrimaryIC13.1

Programs

Updated by (1)