Lawson Insight Technical Documentation |
|
TRCODES
TRCODES FILE
Translation Codes
This field assigns rate type codes to account types. Income statement and
balance sheet are examples of the account types assigned a rate type.
REFERENCED BY
FB195 GL100 GL191 GL195 GL196 CU20.1
CU20.2 CU20.3 CU20.4 CU205 CU220 CU61.1
CU61.2 GL00.3 GL02.1 GL02.2 GL02.3 GL124
GL13.1 GL14.2 GL20.2
UPDATED BY
CU05.1 CU05.2 GL10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRC-TRANSL-CODE Alpha 2 CU05.1 CU05.2
Element: Translation CoCode assigned to account categories. GL10.1
Included would be "IS" for income
statement accounts or "BS" for balance
sheet accounts.
TRC-DESCRIPTION Alpha 30 (Lower Case) CU05.1 CU05.2
Element: Description The code description. GL10.1
TRC-RATE-TYPE Alpha 1 CU05.1 CU05.2
Element: Rate Type Assigned to translation codes to for GL10.1
determining the method of calculating
the average account balances. Valid
entries include "E" for ending, and "A"
for average.
A = Average
E = Ending
TRCODES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRCSET1 TRANSL-CODE FB195 GL100
GL191 GL195
GL196 CU05.1
CU05.2 CU20.1
CU20.2 CU20.3
CU20.4 CU205
CU220 CU61.1
CU61.2 GL00.3
GL02.1 GL02.2
GL02.3 GL10.1
GL124 GL13.1
GL14.2 GL20.2
TRCODES FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cutransl CUTRANSL
TRC-TRANSL-CODE -> CTR-TRANSL-CODE
CTR-CURRENCY-TABLE
CTR-COMPANY
CTR-FR-CURR-CODE
CTR-TO-CURR-CODE
CTR-FISCAL-YEAR
CTR-BUDGET-NBR
|