GLIACALDIM – Financial Analyzer Calendar Di

System
General Ledger Setup (IF)
Prefix
IGC
Primary key
CAL-DIMENSION
Fields
7
Updated by
3 programs
Referenced by
4 programs

GLIACALDIM is the Financial Analyzer Calendar Di table in Lawson General Ledger Setup (prefix IGC). It is indexed by CAL-DIMENSION (IGCSET1); alternate indexes: IGCSET2. It is updated by GLDM.4, GLDM.7 and GLDX.2 and referenced by GLBD.1, GLBP.1, GLBY.1 and GLOP.1. The table has 7 fields, 2 indexes and 0 documented relations.

About GLIACALDIM

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the IGC- 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
#IGC-CAL-DIMENSION PK
CAL_DIMENSION		Alpha 50 (Lower Case)—GLDM.4, GLDM.7, GLDX.2
#IGC-MBR-TYPE SET2
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.4, GLDM.7, GLDX.2
#IGC-MEMBER-PREFIX
MEMBER_PREFIX		Alpha 5 (Lower Case)The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind.GLDM.4, GLDM.7, GLDX.2
#IGC-ALIAS-OPTION
ALIAS_OPTION		Alpha 1—GLDM.4, GLDM.7, GLDX.2
#IGC-NBR-PERIODS
NBR_PERIODS		Numeric 2The Number of Periods field contains the number of periods that are included when the outline is built. This field can contain up to two numeric values.GLDM.4
#IGC-ADJUST-PERIOD
ADJUST_PERIOD		Alpha 1The Adjustment Period field determines whether or not the last period is used as an adjustment period. If Y is selected, the adjustment period is not rolled up into any Quarter member. Instead, the adjustment period is rolled up into the Period member. Valid values are:
  • Y Yes
  • N No; Default value.
GLDM.4
#IGC-BEG-BAL-MBR
BEG_BAL_MBR		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

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
IGCSET1
  1. CAL-DIMENSION
PrimaryGLBD.1, GLBP.1, GLBY.1, GLDM.1, GLDM.4, GLDM.7, GLDM.8, GLDX.1 +2 more
IGCSET2
  1. MBR-TYPE
  2. CAL-DIMENSION
GLDM.4, GLDM.7, GLDX.2

Programs

Updated by (3)

Referenced by (4)