Financial Analyzer Members

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

GLDM.3	GLDM.4	GLDM.7	GLDM.8	GLDM.9	GLDX.2
GLBA.1	GLBD.1	GLBP.1	GLBY.1	GLOP.1	IFBA.1

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

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