GLIATCDIM – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
ICW
Primary key
TC-DIMENSION
Fields
4
Updated by
1 program
Referenced by
3 programs

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

About GLIATCDIM

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the ICW- 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
#ICW-TC-DIMENSION PK
TC_DIMENSION		Alpha 50 (Lower Case)—IFTC.1
#ICW-TC-PREFIX
TC_PREFIX		Alpha 5 (Lower Case)—IFTC.1
#ICW-TC-ALIAS-OPT
TC_ALIAS_OPT		Alpha 1——
#ICW-ALL-CURR-MBR
ALL_CURR_MBR		Alpha 50 (Lower Case)—IFTC.1

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
ICWSET1
  1. TC-DIMENSION
PrimaryGLDM.1, GLOP.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)
GLIATCMBRGLIATCDIM

One to many (1) — child tables

RelationTableRulesConditionField map
Dim DetailGLIATCMBRDelete Cascades
ICW-TC-DIMENSION→ICX-TC-DIMENSION
—→ICX-CURRENCY-CODE

Programs

Updated by (1)

Referenced by (3)