Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IAYEARVAR


                             IAYEARVAR FILE

REFERENCED BY

IAYR.1

UPDATED BY

IA85.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IYV-USER-DIM-NAME      Alpha 50  (Lower Case)                    IA85.3
Element: User Dim Name 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.


IYV-MEMBER-NAME        Alpha 50  (Lower Case)                    IA85.3
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

IYV-VAR-TYPE           Alpha 1                                   IA85.3
Element: Var Type      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



IYV-VAR-SUBTYPE        Alpha 1
Element: Var Subtype   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       Numeric 4                                 IA85.3
Element: Var Element1  The Variance Element One field contains
                       the first item (fiscal year or budget
                       member) that is used in the variance
                       calculation.


IYV-VAR-ELEMENT2       Numeric 4                                 IA85.3
Element: Var Element1  The Variance Element Two field contains
                       the second item (fiscal year or budget
                       member) that is used in the variance
                       calculation.


                         IAYEARVAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IYVSET1   USER-DIM-NAME                                          IA85.3  IAYR.1
          MEMBER-NAME