GLIAMBR – Financial Analyzer Members

System
General Ledger Setup (IF)
Prefix
GIM
Primary key
MBR-DIMENSION, MBR-TYPE, SEQUENCE, BUDGET-NBR, MBR-NAME
Fields
16
Updated by
6 programs
Referenced by
6 programs

GLIAMBR is the Financial Analyzer Members table in Lawson General Ledger Setup (prefix GIM). It is indexed by MBR-DIMENSION, MBR-TYPE, SEQUENCE, BUDGET-NBR, MBR-NAME (GIMSET1); alternate indexes: GIMSET2. It is updated by GLDM.3, GLDM.4, GLDM.7, GLDM.8, GLDM.9 and GLDX.2 and referenced by GLBA.1, GLBD.1, GLBP.1, GLBY.1, GLOP.1 and IFBA.1. The table has 16 fields, 2 indexes and 0 documented relations.

About GLIAMBR

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

Fields (16)

Column = COBOL field name without the GIM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GIM-MBR-DIMENSION PK
MBR_DIMENSION		Alpha 50 (Lower Case)—GLDM.3, GLDM.4, GLDM.7, GLDM.8, GLDM.9, GLDX.2
#GIM-MBR-TYPE PK
MBR_TYPE		Alpha 2The 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 PK
SEQUENCE		Numeric 6The 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 PK
BUDGET_NBR		Numeric 3The Budget Number field contains the budget number.GLDM.8, GLDM.9
#GIM-MBR-NAME PK
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 SET2
ALIAS_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
MATRIX_VIEW		Alpha 12The 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
FISCAL_YEAR		Numeric 4The Fiscal Year field contains numeric fiscal year. This field can contain up to four numeric characters.GLDM.7, GLDX.2
#GIM-FYR-FR-DATE
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
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
VAR_TYPE		Alpha 1The 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
VAR_SUBTYPE		Alpha 1The 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
VAR_ELEMENT1		Numeric 4The 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
VAR_ELEMENT2		Numeric 4The 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
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
VAR_ELEMENT4		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.—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GIMSET1
  1. MBR-DIMENSION
  2. MBR-TYPE
  3. SEQUENCE
  4. BUDGET-NBR
  5. MBR-NAME
PrimaryGLBA.1, GLBD.1, GLBP.1, GLBY.1, GLDM.3, GLDM.4, GLDM.7, GLDM.8 +4 more
GIMSET2
  1. MBR-DIMENSION
  2. ALIAS-MBR-NAME
KeyChange, SubsetWhere ALIAS-MBR-NAME != SpacesGLDM.8, GLDM.9

Programs

Updated by (6)

Referenced by (6)