IAYEARVAR

UPDATED BY
IA85.3 IAYR.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IYV-USER-DIM-NAME
Element: 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
Element: 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
Element: Var Type
Alpha 1
The 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
Element: Var Subtype
Alpha 1
The 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
Element: Var Element1
Numeric 4
The 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
Element: Var Element1
Numeric 4
The Variance Element One field contains the first item (fiscal year or budget member) that is used in the variance calculation.
IA85.3


IAYEARVAR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IYVSET1 USER-DIM-NAME
MEMBER-NAME
IA85.3 IAYR.1


File created: Wed Jun 08 20:49:33 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.