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.

Field / columnTypeDescription & valuesUpdated by
TRC-TRANSL-CODE PK
TRANSL_CODE		Alpha 2Code 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-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The code description.CU05.1, CU05.2, GL10.1
TRC-RATE-TYPE
RATE_TYPE		Alpha 1Assigned to translation codes to for determining the method of calculating the average account balances. Valid entries include "E" for ending, and "A" for average.
  • A Average
  • E Ending
CU05.1, CU05.2, GL10.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TRCSET1TRANSL-CODEPrimaryFB195, GL100, GL122, GL191, GL195, GL196, CU01.1, CU01.2 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
CutranslCUTRANSLTRC-TRANSL-CODE → CTR-TRANSL-CODE, → CTR-CURRENCY-TABLE, → CTR-COMPANY, → CTR-FR-CURR-CODE, → CTR-TO-CURR-CODE, → CTR-FISCAL-YEAR, → CTR-BUDGET-NBR

Programs

Updated by (3)

Referenced by (44)