Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TRCODES


                              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
Element: Translation CoCode 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
Element: Description   The code description.                     GL10.1

TRC-RATE-TYPE          Alpha 1                                   CU05.1  CU05.2
Element: 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