IADIMDLT – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
DMX
Primary key
DATA-MART-NAME, USER-DIM-NAME
Fields
4
Updated by
3 programs
Referenced by
1 program

IADIMDLT is a Lawson Analytic Architect table (prefix DMX); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME, USER-DIM-NAME (DMXSET1). It is updated by HC10.1, IA120 and IAAP.1 and referenced by IA150. The table has 4 fields, 1 index and 0 documented relations.

About IADIMDLT

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the DMX- 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
#DMX-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.HC10.1, IAAP.1
#DMX-USER-DIM-NAME PK
USER_DIM_NAME		Alpha 50 (Lower Case)The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.HC10.1, IAAP.1
#DMX-BASE-DIM-NAME
BASE_DIM_NAME		Alpha 50 (Lower Case)—IAAP.1
#DMX-NEW-DIM-NAME
NEW_DIM_NAME		Alpha 50 (Lower Case)—IAAP.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
DMXSET1
  1. DATA-MART-NAME
  2. USER-DIM-NAME
Primary, KeyChangeHC10.1, IA120, IA150, IAAP.1

Programs

Updated by (3)

Referenced by (1)