Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLIAMBR


                              GLIAMBR FILE

                       Financial Analyzer Members

The Financial OLAP Members data file stores information about each member
that has been defined by GL87.1 (Financial OLAP Dimensions).


REFERENCED BY

GLBA.1    GLBD.1    GLBP.1    GLBY.1    GLOP.1    IFBA.1

UPDATED BY

GLDM.3    GLDM.4    GLDM.7    GLDM.8    GLDM.9    GLDX.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GIM-MBR-DIMENSION      Alpha 50  (Lower Case)                    GLDM.3  GLDM.4
Element: Mbr Dimension                                           GLDM.7  GLDM.8
                                                                 GLDM.9  GLDX.2

GIM-MBR-TYPE           Alpha 2                                   GLDM.3  GLDM.4
Element: Member Type   The Member Type field specifies the       GLDM.7  GLDM.8
                       member type.                              GLDM.9  GLDX.2

                       Valid values are:
                       BD = Budget
                       BV = Budget Variance
                       CH = Alternate Chart
                       FY = Fiscal Year
                       PD = Period
                       PY = Period Year-to-Date
                       QR = Quarter
                       QY = Quarter Year-to-Date
                       SA = Subaccount
                       VW = View
                       YV = Year Variance

GIM-SEQUENCE           Numeric 6                                 GLDM.3  GLDM.4
Element: Sequence      The Sequence field show the sequence of   GLDM.7  GLDM.8
                       a member as it is entered in either the   GLDM.9  GLDX.2
                       Budget Member Names or Fiscal Year
                       Variances subforms in AC87.1 (Financial
                       OLAP Dimensions).

GIM-BUDGET-NBR         Numeric 3                                 GLDM.8  GLDM.9
Element: Budget Number The Budget Number field contains the
                       budget number.

GIM-MBR-NAME           Alpha 30  (Lower Case)                    GLDM.8  GLDM.9
Element: Member Name   The Member Name field contains the
                       user-defined member name for the income
                       statement member. This name can contain
                       up to 30 characters of any kind.

GIM-ALIAS-MBR-NAME     Alpha 30  (Lower Case)                    GLDM.4  GLDM.7
Element: Member Name                                             GLDM.8  GLDM.9
                                                                 GLDX.2

GIM-MATRIX-VIEW        Alpha 12
Element: Attribute ListThe Attribute View field contains the
                       accounting unit view being used for
                       alternate roll-ups. Any posting
                       accounting units listed in a view that
                       is used for alternate roll-ups must also
                       be included in one of the company,
                       accounting, or company groups.


GIM-FISCAL-YEAR        Numeric 4                                 GLDM.7  GLDX.2
Element: Last Closed YeThe Fiscal Year field contains numeric
                       fiscal year. This field can contain up
                       to four numeric characters.


GIM-FYR-FR-DATE        Numeric 8  (yyyymmdd)                     GLDX.2
Element: Date

GIM-FYR-TH-DATE        Numeric 8  (yyyymmdd)                     GLDX.2
Element: Date

GIM-VAR-TYPE           Alpha 1                                   GLDM.8
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



GIM-VAR-SUBTYPE        Alpha 1
Element: Bin Usage Type

GIM-VAR-ELEMENT1       Numeric 4                                 GLDM.8
Element: Var Element1  The Variance Element One field contains
                       the first item (fiscal year or budget
                       member) that is used in the variance
                       calculation.


GIM-VAR-ELEMENT2       Numeric 4                                 GLDM.8
Element: Var Element1

GIM-VAR-ELEMENT3       Alpha 30  (Lower Case)
Element: Var Element3  The Variance Element Three field
                       contains the third item (fiscal year or
                       budget member) that is used in the
                       variance calculation.


GIM-VAR-ELEMENT4       Alpha 30  (Lower Case)
Element: Var Element3

                         GLIAMBR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GIMSET1   MBR-DIMENSION                                          GLBA.1  GLBD.1
          MBR-TYPE                                               GLBP.1  GLBY.1
          SEQUENCE                                               GLDM.3  GLDM.4
          BUDGET-NBR                                             GLDM.7  GLDM.8
          MBR-NAME                                               GLDM.9  GLDX.2
                                                                 GLOP.1  IFBA.1

GIMSET2   MBR-DIMENSION KeyChange, Subset                        GLDM.8  GLDM.9
          ALIAS-MBR-NAMEWhere ALIAS-MBR-NAME != Spaces