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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#IDR-DIM-OBJ-ID PKDIM_OBJ_ID | Numeric 12 | The 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 PKDATA_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 PKMBR_OBJ_ID | Numeric 12 | The 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 PKMETA_ID | Numeric 9 | — | ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more |
#IDR-DRILL-FILEDRILL_FILE | Alpha 10 | — | ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more |
#IDR-DRILL-INDEXDRILL_INDEX | Alpha 10 | — | ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more |
#IDR-DRILL-KEYSDRILL_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IDRSET1 |
| Primary, KeyChange | ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source) | |
IDRSET2 |
| KeyChange, Subset | Where DATA-TARGET = "1" And MBR-OBJ-ID != Zeroes | IA120, IA300 |
Programs
Updated by (52)
- ACBA.1 Olap Dimension Retrieval Format
- ACBC.1 Olap Dimension Retrieval Format
- ACBP.1 Olap Dimension Retrieval Format
- ACBR.1 Olap Dimension Retrieval Format
- ACBS.1 Olap Dimension Retrieval Format
- ACBU.1 Olap Dimension Retrieval Format
- ACBY.1 Olap Dimension Retrieval Format
- AMAS.1 OLAP Dimension Retrieval Format
- AMBK.1 OLAP Dimension Retrieval Format
- AMCV.1 OLAP Dimension Retrieval Format
- AMLF.1 OLAP Dimension Retrieval Format
- AMMD.1 OLAP Dimension Retrieval Format
- AMME.1 OLAP Dimension Retrieval Format
- AMPD.1 Olap Dimension Retrieval Format
- AMYR.1 Olap Dimension Retrieval Format
- CBBB.1 Build Bank Instrument Dimension
- CBBC.1 Olap Dimension Retrieval Format
- CBBD.1 Olap Dimension Retrieval Format
- CBBO.1 Olap Dimension Retrieval Format
- CBBR.1 Build Bank Instrument Dimension
- CBBT.1 Build Transaction Status Dimension
- GLBA.1 Olap Dimension Retrieval Format
- GLBD.1 Olap Dimension Retrieval Format
- GLBP.1 Olap Dimension Retrieval Format
- GLBT.1 Olap Dimension Retrieval Format
- GLBY.1 Olap Dimension Retrieval Format
- HCAG.1 Olap Dimension Retrieval Format
- HCCP.1 Olap Dimension Retrieval Format
- HCEM.1 Olap Dimension Retrieval Format
- HCHM.1 Olap Dimension Retrieval Format
- HCJC.1 Olap Dimension Retrieval Format
- HCMS.1 Olap Dimension Retrieval Format
- HCPO.1 Olap Dimension Retrieval Format
- HCRV.1 Olap Dimension Retrieval Format
- HCSC.1 Olap Dimension Retrieval Format
- HCSU.1 Olap Dimension Retrieval Format
- HCYR.1 Olap Dimension Retrieval Format
- IA120 Data Mart Load
- IA150 XML Data Mart Interface
- IA300 Delete Members
- IAMB.1 Lawson Member List Update
- IATM.1 Olap Dimension Retrieval Format
- IAVO.1 Olap Dimension Retrieval Format
- IAYR.1 Olap Dimension Retrieval Format
- IFBA.1 Olap Dimension Retrieval Format
- IFBC.1 Olap Dimension Retrieval Format
- IFBO.1 Olap Dimension Retrieval Format
- IFBS.1 Olap Dimension Retrieval Format
- POAB.1 Olap Dimension Retrieval Format
- POAM.1 Olap Dimension Retrieval Format
- POAO.1 Olap Dimension Retrieval Format
- POAP.1 Olap Dimension Retrieval Format
Referenced by (1)
- IASD.1 Simple Data Mart Drill Around