TRCODES – Translation Codes
- System
- General Ledger Setup (IF)
- Prefix
TRC- Primary key
TRANSL-CODE- Fields
- 3
- Updated by
- 3 programs
- Referenced by
- 44 programs
TRCODES is the Translation Codes table in Lawson General Ledger Setup (prefix TRC). It is indexed by TRANSL-CODE (TRCSET1). It is related 1:M to CUTRANSL. It is updated by CU05.1, CU05.2 and GL10.1 and referenced by CU01.1, CU01.2, CU02.1, CU02.2, CU03.1, CU10.1, CU10.2, CU20.1 and 36 more. The table has 3 fields, 1 index and 1 documented relation.
About TRCODES
This field assigns rate type codes to account types. Income statement and balance sheet are examples of the account types assigned a rate type.
Fields (3)
Column = COBOL field name without the TRC- 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 |
|---|---|---|---|
#TRC-TRANSL-CODE PKTRANSL_CODE | Alpha 2 | Code assigned to account categories. Included would be "IS" for income statement accounts or "BS" for balance sheet accounts. | CU05.1, CU05.2, GL10.1 |
#TRC-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The code description. | CU05.1, CU05.2, GL10.1 |
#TRC-RATE-TYPERATE_TYPE | Alpha 1 | Assigned to translation codes to for determining the method of calculating the average account balances. Valid entries include "E" for ending, and "A" for average.
| CU05.1, CU05.2, GL10.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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TRCSET1 |
| Primary | FB195, GL100, GL122, GL191, GL195, GL196, CU01.1, CU01.2 +22 more (list truncated in source) |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cutransl | CUTRANSL |
|
Programs
Updated by (3)
Referenced by (44)
- CU01.1 Currency Code
- CU01.2 Currency Codes
- CU02.1 Currency Relationship
- CU02.2 Relationship Summary
- CU03.1 Currency Gain Loss Accounts
- CU10.1 Exchange Rates
- CU10.2 Daily Rate Entry
- CU20.1 Currency Table Translation Rates
- CU20.2 Currency Table Period Rate Entry
- CU20.3 Company Translation Rates
- CU20.4 Company Period Rate Entry
- CU205 Translation Code Listing
- CU220 Translation Rate Listing
- CU61.1 Maintain Translation Rates
- CU61.2 Maintain Company Translation Rates
- FB195 Translation Calculation
- GL00.1 Chart of Accounts
- GL00.2 Define Chart
- GL00.3 Detail Accounts
- GL00.6 Move Detail Account
- GL00.7 System Accounts
- GL00.8 Rename Summary Account
- GL00.9 Chart Copy
- GL02.1 Detail Subaccount Definition
- GL02.2 Multiple Detail Subaccount Definition
- GL02.3 Template Subaccount Definition
- GL02.6 Move Detail Account
- GL03.2 Move Summary Account
- GL03.4 Summary Account System Restriction
- GL100 Mass Chart Account Change Delete
- GL121 Mass Account Addition
- GL122 Mass Account Change Delete
- GL124 Mass Accounting Unit Addition
- GL13.1 Subaccount Template
- GL14.2 Posting Accounts
- GL191 Currency Revaluation
- GL195 Translation Calculation
- GL196 Report Currency Translation
- GL20.1 Accounting Units - Accounts
- GL20.2 Posting Accounts
- GL20.4 Mass Add Accounts
- ML191 Ledger Currency Revaluation
- ML195 Ledger Translation Calculation
- ML196 Ledger Report Currency Translation