GLACCTREL – GL Account Relationships
- System
- General Ledger Setup (IF)
- Prefix
GAR- Primary key
OLD-ACCT-NBR- Fields
- 4
- Updated by
- 2 programs
- Referenced by
- 23 programs
GLACCTREL is the GL Account Relationships table in Lawson General Ledger Setup (prefix GAR). It is indexed by OLD-ACCT-NBR (GARSET1). It is related 1:M to GLCHARTDTL and GLMASTER. It is updated by GL09.1 and GL09.2 and referenced by AC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL162 and 15 more. The table has 4 fields, 1 index and 2 documented relations.
About GLACCTREL
This file contains the information needed to create the Lawson accounts when converting from non-Lawson systems.
Fields (4)
Column = COBOL field name without the GAR- 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 |
|---|---|---|---|
#GAR-OLD-ACCT-NBR PKOLD_ACCT_NBR | Alpha 25 | This is the old account structure to be associated with the new account/subaccount within the Lawson system. | GL09.1, GL09.2 |
#GAR-ACCOUNTACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | GL09.1, GL09.2 |
#GAR-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored. | GL09.1, GL09.2 |
#GAR-OLD-ACCT-SHORTOLD_ACCT_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 |
|---|---|---|---|---|
GARSET1 |
| Primary | AC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL165 +17 more |
Relations
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Glchartdtl | GLCHARTDTL |
| |||||||||||||||||
| Glmaster | GLMASTER |
|
Programs
Updated by (2)
Referenced by (23)
- 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
- GL209 Account 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
- ML165 Ledger Transaction Interface
- ML167 Ledger Balance Interface
- ML195 Ledger Translation Calculation
- ML65.1 Ledger Transaction Interface Maintenance
- ML67.1 Ledger Balance Interface Maintenace