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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IYVSET1
  1. USER-DIM-NAME
  2. MEMBER-NAME
PrimaryIA85.3, IAYR.1

Programs

Updated by (1)

Referenced by (1)