GLCOMPREL – GL Organization Relationships
- System
- General Ledger Setup (IF)
- Prefix
GCR- Primary key
OLD-COMPANY- Fields
- 4
- Updated by
- 2 programs
- Referenced by
- 24 programs
GLCOMPREL is the GL Organization Relationships table in Lawson General Ledger Setup (prefix GCR). It is indexed by OLD-COMPANY (GCRSET1). It is related 1:1 to GLNAMES and GLSYSTEM. It is updated by GL08.1 and GL08.2 and referenced by AC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL162 and 16 more. The table has 4 fields, 1 index and 2 documented relations.
About GLCOMPREL
This file contains information needed to create the Lawson Company structure when converting from a non-Lawson system as defined in GL08.1 (Organization Relationship).
Fields (4)
Column = COBOL field name without the GCR- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#GCR-OLD-COMPANY PKOLD_COMPANY | Alpha 35 | The organization code defined for the old company number. | GL08.1, GL08.2 |
#GCR-COMPANYCOMPANY | Numeric 4 | The company number as defined in GL10.1 (Company). | GL08.1, GL08.2 |
#GCR-ACCT-UNITACCT_UNIT | Alpha 15 | The alphanumeric name that represents the 30-digit variable level number. The name is a unique location within the company. Once defined, the accounting unit's name cannot be changed. | GL08.1, GL08.2 |
#GCR-OLD-CPY-SHORTOLD_CPY_SHORT | Derived | The short description. | — |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GCRSET1 |
| Primary | AC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL165 +18 more |
Relations
One to one (2) — lookups and parents
Programs
Updated by (2)
Referenced by (24)
- AC527 AC to GL Budget Interface
- CA160 Allocation Code Interface
- CA60.1 Allocation Code Interface Maintenance
- FB165 Budget Interface
- FB195 Translation Calculation
- FB265 Budget Interface Listing
- FB65.1 Budget Interface Maintenance
- GL162 Accounting Unit Attribute Interface
- GL165 Transaction Interface
- GL167 Balance Interface
- GL194 Update IncomeStatement Beg Bal
- GL195 Translation Calculation
- GL208 Organization Relationship Listing
- GL265 Transaction Interface Listing
- GL62.1 Accounting Unit Attribute Interface Maintenance
- GL65.1 Transaction Interface Maintenance
- GL65.4 Transaction Maintenance
- GL67.1 Balance Interface Maintenance
- GLDT.1 Calculate posting date from year period
- ML165 Ledger Transaction Interface
- ML167 Ledger Balance Interface
- ML195 Ledger Translation Calculation
- ML65.1 Ledger Transaction Interface Maintenance
- ML67.1 Ledger Balance Interface Maintenace