IADRILL – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IDR
Primary key
DIM-OBJ-ID, DATA-TARGET, MBR-OBJ-ID, META-ID
Fields
7
Updated by
52 programs
Referenced by
1 program

IADRILL is a Lawson Analytic Architect table (prefix IDR); no description in the lawson data dictionary. It is indexed by DIM-OBJ-ID, DATA-TARGET, MBR-OBJ-ID, META-ID (IDRSET1); alternate indexes: IDRSET2. It is updated by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 and 44 more and referenced by IASD.1. The table has 7 fields, 2 indexes and 0 documented relations.

About IADRILL

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
IDR-DIM-OBJ-ID PK
DIM_OBJ_ID		Numeric 12The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
IDR-DATA-TARGET PK
DATA_TARGET		Alpha 1—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
IDR-MBR-OBJ-ID PK
MBR_OBJ_ID		Numeric 12The Member Object Identifier field contains a unique numeric identifier assigned to a member, which associates this record to the appropriate MEMBER file record.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
IDR-META-ID PK
META_ID		Numeric 9—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
IDR-DRILL-FILE
DRILL_FILE		Alpha 10—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
IDR-DRILL-INDEX
DRILL_INDEX		Alpha 10—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
IDR-DRILL-KEYS
DRILL_KEYS		Alpha 120 (Lower Case)—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more

Indexes (2)

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

IndexKeysFlagsConditionUsed in
IDRSET1DIM-OBJ-ID, DATA-TARGET, MBR-OBJ-ID, META-IDPrimary, KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
IDRSET2MBR-OBJ-ID, DIM-OBJ-IDKeyChange, SubsetWhere DATA-TARGET = "1" And MBR-OBJ-ID != ZeroesIA120, IA300

Programs

Updated by (52)

Referenced by (1)