IAYEARVAR – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IYV
Primary key
USER-DIM-NAME, MEMBER-NAME
Fields
6
Updated by
1 program
Referenced by
1 program

IAYEARVAR is a Lawson Analytic Architect table (prefix IYV); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME, MEMBER-NAME (IYVSET1). It is updated by IA85.3 and referenced by IAYR.1. The table has 6 fields, 1 index and 0 documented relations.

About IAYEARVAR

No description in the Lawson data dictionary.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
IYV-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.IA85.3
IYV-MEMBER-NAME PK
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.IA85.3
IYV-VAR-TYPE
VAR_TYPE		Alpha 1The Variance Type field contains the value that represents the variance type for fiscal year variances. Valid values are:
  • A Variance Amount
  • P Variance Percent
IA85.3
IYV-VAR-SUBTYPE
VAR_SUBTYPE		Alpha 1The Variance Subtype field contains the value that represents the variance subtype for budget variances. Value values are:
  • A Budget to Actuals
  • B Budget to Budget
—
IYV-VAR-ELEMENT1
VAR_ELEMENT1		Numeric 4The Variance Element One field contains the first item (fiscal year or budget member) that is used in the variance calculation.IA85.3
IYV-VAR-ELEMENT2
VAR_ELEMENT2		Numeric 4The Variance Element One field contains the first item (fiscal year or budget member) that is used in the variance calculation.IA85.3

Indexes (1)

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

IndexKeysFlagsConditionUsed in
IYVSET1USER-DIM-NAME, MEMBER-NAMEPrimaryIA85.3, IAYR.1

Programs

Updated by (1)

Referenced by (1)