GLIASACDIM – Fin Analyzer Subaccount Dim

System
General Ledger Setup (IF)
Prefix
IGA
Primary key
SAC-DIMENSION
Fields
11
Updated by
1 program
Referenced by
3 programs

GLIASACDIM is the Fin Analyzer Subaccount Dim table in Lawson General Ledger Setup (prefix IGA). It is indexed by SAC-DIMENSION (IGASET1); alternate indexes: IGASET2. It is updated by GLDM.3 and referenced by GLBA.1, GLDX.1 and GLOP.1. The table has 11 fields, 2 indexes and 0 documented relations.

About GLIASACDIM

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the IGA- 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
#IGA-ACT-DIMENSION SET2
ACT_DIMENSION
Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.3
#IGA-SAC-DIMENSION PK
SAC_DIMENSION
Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.3
#IGA-SAC-PREFIX
SAC_PREFIX
Alpha 5 (Lower Case)The Type Prefix field contains a unique prefix name that differentiates the members in the Type dimension with similar members in other dimensions. This prefix can contain up to five characters of any kind.GLDM.3
#IGA-SAC-ALIAS-OPT
SAC_ALIAS_OPT
Alpha 1The Products Alias Option field contains the value that represents the alias name for the members of this dimension. Valid values are:
  • 1 Prefix and Alias Name
  • 2 Alias Name
GLDM.3
#IGA-SAC-MBR-OPT
SAC_MBR_OPT
Alpha 1The Member Name Option field determines whether an alias name is used as a member name, thus replacing the subaccount number. Valid values are:
  • 1 Subaccount Number
  • 2 Alias Name
GLDM.3
#IGA-NULL-VALUE-MBR
NULL_VALUE_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.3
#IGA-FR-SUB-ACCT
FR_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.GLDM.3
#IGA-TH-SUB-ACCT
TH_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.GLDM.3
#IGA-ACCOUNT-GROUP
ACCOUNT_GROUP
Alpha 12A group of account ranges that need not be in sequential order.GLDM.3
#IGA-CHART-NAME
CHART_NAME
Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.—
#IGA-CHART-SECTION
CHART_SECTION
Alpha 1The chart section.—

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
IGASET1
  1. SAC-DIMENSION
PrimaryGLBA.1, GLDM.1, GLDM.3, GLDM.9, GLDX.1, GLOP.1
IGASET2
  1. ACT-DIMENSION
  2. SAC-DIMENSION
KeyChange—

Programs

Updated by (1)

Referenced by (3)