Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             IAYEARYR FILE

REFERENCED BY

IATS.1    IAYR.1

UPDATED BY

IA85.1    IA85.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IYY-USER-DIM-NAME    Alpha 50  (Lower Case)                      IA85.1
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.


IYY-YEAR             Numeric 4                                   IA85.1
Last Closed Year     Contains the fiscal year for the data
                     stored on this record.

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

                         IAYEARYR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IYYSET1   USER-DIM-NAME                                          IA85.1  IA85.2
          YEAR                                                   IA85.3  IATS.1
                                                                 IAYR.1

IYYSET2   USER-DIM-NAME KeyChange
          MEMBER-NAME