ICUSRFLDEF – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
ICU
Primary key
USER-FLD-TYPE, COMPANY, ITEM-GROUP
Fields
8
Updated by
2 programs
Referenced by
38 programs

ICUSRFLDEF is a Lawson Inventory Control table (prefix ICU); no description in the lawson data dictionary. It is indexed by USER-FLD-TYPE, COMPANY, ITEM-GROUP (ICUSET1); alternate indexes: ICUSET2 and ICUSET3. It is updated by IC00.1 and IC01.1 and referenced by DR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 and 30 more. The table has 8 fields, 3 indexes and 0 documented relations.

About ICUSRFLDEF

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the ICU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ICU-COMPANY PK
COMPANY		Numeric 4Identifies 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.IC00.1, IC01.1
ICU-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.IC00.1, IC01.1
ICU-USER-FLD-TYPE PK
USER_FLD_TYPE		Alpha 1—
  • T ICTRANS
  • D ICTRANSDTL
  • L ITEMLOC
  • M ITEMMAST
  • S ITEMSUB
IC00.1, IC01.1
ICU-DATA-TYPE-01
DATA_TYPE_01		Alpha 1—IC00.1, IC01.1
ICU-DATA-TYPE-02
DATA_TYPE_02		Alpha 1—IC00.1, IC01.1
ICU-DATA-TYPE-03
DATA_TYPE_03		Alpha 1—IC00.1, IC01.1
ICU-DATA-TYPE-04
DATA_TYPE_04		Alpha 1—IC00.1, IC01.1
ICU-DATA-TYPE-05
DATA_TYPE_05		Alpha 1—IC00.1, IC01.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ICUSET1USER-FLD-TYPE, COMPANY, ITEM-GROUPPrimaryIC00.1, IC01.1
ICUSET2COMPANY, USER-FLD-TYPE, ITEM-GROUPDR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 +22 more (list truncated in source)
ICUSET3ITEM-GROUP, USER-FLD-TYPE, COMPANYDR100, IC11.1, IC12.1, IC13.1, IC141, IC142, IC20.1, IC20.2 +22 more (list truncated in source)

Programs

Updated by (2)

Referenced by (38)