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
GL100 GL196 GL00.3 GL02.1 GL02.2 GL02.3
GL124 GL20.2 FB195 GL191 GL195 CU20.1
CU20.2 CU20.3 CU20.4 CU205 CU220 CU61.1
CU61.2 GL13.1 GL14.2 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
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
ML191 ML195
ML196


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 11:18:54 2016

Home
Contact Us



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