TRCODES

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 GL122 GL191 GL195 GL196
CU01.1 CU01.2 CU02.1 CU02.2 CU03.1 CU10.1
CU10.2 CU20.1 CU20.2 CU20.3 CU20.4 CU205
CU220 CU61.1 CU61.2 GL00.1 GL00.2 GL00.3
GL00.6 GL00.7 GL00.8 GL00.9 GL02.1 GL02.2
GL02.3 GL02.6 GL03.2 GL03.4 GL121 GL124
GL13.1 GL14.2 GL20.1 GL20.2 GL20.4 ML191
ML195 ML196


UPDATED BY
CU05.1 CU05.2 GL10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRC-TRANSL-CODE
Element: Translation 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-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
The code description.
CU05.1 CU05.2
GL10.1
TRC-RATE-TYPE
Element: Rate 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.
A = Average
E = Ending
CU05.1 CU05.2
GL10.1


TRCODES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRCSET1 TRANSL-CODE
...
FB195 GL100
GL122 GL191
GL195 GL196
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU05.1
CU05.2 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
CU20.4 CU205
CU220 CU61.1
CU61.2 GL00.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.8 GL00.9


TRCODES FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:21:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.