GLIAMBR

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
Element: Mbr Dimension
Alpha 50 (Lower Case)
GLDM.3 GLDM.4
GLDM.7 GLDM.8
GLDM.9 GLDX.2
GIM-MBR-TYPE
Element: Mbr Type
Alpha 2
The Member Type field specifies the member type. 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
GLDM.3 GLDM.4
GLDM.7 GLDM.8
GLDM.9 GLDX.2
GIM-SEQUENCE
Element: Sequence
Numeric 6
The Sequence field show the sequence of a member as it is entered in either the Budget Member Names or Fiscal Year Variances subforms in AC87.1 (Financial OLAP Dimensions).
GLDM.3 GLDM.4
GLDM.7 GLDM.8
GLDM.9 GLDX.2
GIM-BUDGET-NBR
Element: Budget Nbr
Numeric 3
The Budget Number field contains the budget number.
GLDM.8 GLDM.9
GIM-MBR-NAME
Element: Mbr Name
Alpha 30 (Lower Case)
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.
GLDM.8 GLDM.9
GIM-ALIAS-MBR-NAME
Element: Mbr Name
Alpha 30 (Lower Case)
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.
GLDM.4 GLDM.7
GLDM.8 GLDM.9
GLDX.2
GIM-MATRIX-VIEW
Element: Matrix View
Alpha 12
The 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
Element: Year
Numeric 4
The Fiscal Year field contains numeric fiscal year. This field can contain up to four numeric characters.
GLDM.7 GLDX.2
GIM-FYR-FR-DATE
Element: Fyr Fr Date
Numeric 8 (yyyymmdd)
The From Fiscal Year field contains the beginning fiscal year for a range of fiscal years. This field can contain up to four numeric characters.
GLDX.2
GIM-FYR-TH-DATE
Element: Fyr Th Date
Numeric 8 (yyyymmdd)
The Through Fiscal Year field contains the ending fiscal year for a range of fiscal years. This field can contain up to four numeric characters.
GLDX.2
GIM-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
GLDM.8
GIM-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
GIM-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.
GLDM.8
GIM-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.
GLDM.8
GIM-VAR-ELEMENT3
Element: Var Element3
Alpha 30 (Lower Case)
The Variance Element Three field contains the third item (fiscal year or budget member) that is used in the variance calculation.
GIM-VAR-ELEMENT4
Element: Var Element3
Alpha 30 (Lower Case)
The Variance Element Three field contains the third item (fiscal year or budget member) that is used in the variance calculation.


GLIAMBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GIMSET1 MBR-DIMENSION
MBR-TYPE
SEQUENCE
BUDGET-NBR
MBR-NAME
GLBA.1 GLBD.1
GLBP.1 GLBY.1
GLDM.3 GLDM.4
GLDM.7 GLDM.8
GLDM.9 GLDX.2
GLOP.1 IFBA.1
GIMSET2 MBR-DIMENSION
ALIAS-MBR-NAME
KeyChange, Subset
WhereALIAS-MBR-NAME !=Spaces
GLDM.8 GLDM.9


File created: Thu Jun 09 11:18:35 2016

Home
Contact Us



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