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     GL00.3
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
Translation Code     Code 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
Description          The code description.                       GL10.1

TRC-RATE-TYPE        Alpha 1                                     CU05.1  CU05.2
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   GL00.3
                                                                 GL10.1  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