IAFILEDLT – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
DLT
Primary key
DATA-MART-NAME, USER-DIM-NAME, COLUMN-DESC
Fields
4
Updated by
52 programs
Referenced by
0 programs

IAFILEDLT is a Lawson Analytic Architect table (prefix DLT); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME, USER-DIM-NAME, COLUMN-DESC (DLTSET1); alternate indexes: DLTSET2. It is updated by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 and 44 more. The table has 4 fields, 2 indexes and 0 documented relations.

About IAFILEDLT

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
DLT-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +44 more
DLT-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.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +44 more
DLT-COLUMN-DESC PK
COLUMN_DESC		Alpha 50 (Lower Case)—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +44 more
DLT-LAW-COL-NAME
LAW_COL_NAME		Alpha 50 (Lower Case)—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +44 more

Indexes (2)

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

IndexKeysFlagsConditionUsed in
DLTSET1DATA-MART-NAME, USER-DIM-NAME, COLUMN-DESCPrimary, KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
DLTSET2DATA-MART-NAME, USER-DIM-NAME, LAW-COL-NAME—

Programs

Updated by (52)