GLIATCMBR – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
ICX
Primary key
TC-DIMENSION, CURRENCY-CODE
Fields
3
Updated by
1 program
Referenced by
2 programs

GLIATCMBR is a Lawson General Ledger Setup table (prefix ICX); no description in the lawson data dictionary. It is indexed by TC-DIMENSION, CURRENCY-CODE (ICXSET1). It is related 1:1 to GLIATCDIM. It is updated by IFTC.2 and referenced by GLOP.1 and IFBC.1. The table has 3 fields, 1 index and 1 documented relation.

About GLIATCMBR

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the ICX- 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
#ICX-TC-DIMENSION PK
TC_DIMENSION
Alpha 50 (Lower Case)IFTC.2
#ICX-CURRENCY-CODE PK
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).IFTC.2
#ICX-MBR-NAME
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.IFTC.2

Indexes (1)

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
ICXSET1
  1. TC-DIMENSION
  2. CURRENCY-CODE
PrimaryGLOP.1, IFBC.1, IFTC.1, IFTC.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLIATCDIMGLIATCMBR

One to one (1) — lookups and parents

RelationTableRulesConditionField map
DimensionGLIATCDIMRequired
ICX-TC-DIMENSIONICW-TC-DIMENSION

Programs

Updated by (1)

Referenced by (2)