|
|
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
|
