Lawson Insight Technical Documentation

                              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
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   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