IATIMEYR – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IYR
Primary key
USER-DIM-NAME, YEAR
Fields
5
Updated by
2 programs
Referenced by
4 programs

IATIMEYR is a Lawson Analytic Architect table (prefix IYR); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME, YEAR (IYRSET1). It is updated by IA80.1 and IA80.9 and referenced by IART.1, IATB.1, IATM.1 and POA1.1. The table has 5 fields, 1 index and 0 documented relations.

About IATIMEYR

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
IYR-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.IA80.1
IYR-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.IA80.1
IYR-MEMBER-NAME
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.IA80.1, IA80.9
IYR-FYR-FR-DATE
FYR_FR_DATE		Numeric 8 (yyyymmdd)The From Fiscal Year field contains the beginning fiscal year for a range of fiscal years. This field can contain up to four numeric characters.IA80.1, IA80.9
IYR-FYR-TH-DATE
FYR_TH_DATE		Numeric 8 (yyyymmdd)The Through Fiscal Year field contains the ending fiscal year for a range of fiscal years. This field can contain up to four numeric characters.IA80.1, IA80.9

Indexes (1)

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

IndexKeysFlagsConditionUsed in
IYRSET1USER-DIM-NAME, YEARPrimaryIA80.1, IA80.9, IART.1, IATB.1, IATM.1, POA1.1

Programs

Updated by (2)

Referenced by (4)