IAYEARYR – No description in the Lawson data dictionary
- System
- Analytic Architect (IA)
- Prefix
IYY- Primary key
USER-DIM-NAME,YEAR- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 2 programs
IAYEARYR is a Lawson Analytic Architect table (prefix IYY); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME, YEAR (IYYSET1); alternate indexes: IYYSET2. It is updated by IA85.1 and IA85.2 and referenced by IATS.1 and IAYR.1. The table has 3 fields, 2 indexes and 0 documented relations.
About IAYEARYR
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the IYY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IYY-USER-DIM-NAME PKUSER_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. | IA85.1 |
IYY-YEAR PKYEAR | Numeric 4 | Contains the fiscal year for the data stored on this record. | IA85.1 |
IYY-MEMBER-NAMEMEMBER_NAME | Alpha 50 (Lower Case) | This is an override member name for Data Mart dimensions with no association to a Budget dimension. | IA85.1, IA85.2 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IYYSET1 | USER-DIM-NAME, YEAR | Primary | IA85.1, IA85.2, IA85.3, IATS.1, IAYR.1 | |
IYYSET2 | USER-DIM-NAME, MEMBER-NAME | KeyChange | — |