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 |
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) |
|
||||||
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 |
|
||||||
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). |
|
||||||
GIM-BUDGET-NBR Element: Budget Nbr | Numeric 3 The Budget Number field contains the budget number. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GIMSET1 |
MBR-DIMENSION MBR-TYPE SEQUENCE BUDGET-NBR MBR-NAME |
|
| ||||||||||||||||||
GIMSET2 |
MBR-DIMENSION ALIAS-MBR-NAME |
|
|
All trademarks and registered trademarks are the property of their
respective owners.