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 GL191 GL195 GL196 CU20.1
CU20.2 CU20.3 CU20.4 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 CU205

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


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: Wed Jun 08 20:49:47 2016

Home
Contact Us



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