Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUTRANSL


                             CUTRANSL FILE

                          Currency Translation

This file maintains translation rates for each currency relationship by
company or currency table. CU20.1 (Company Translation Rates) and CU20.3
(Currency Table Translation Rates) are the primary programs that update this
file.


REFERENCED BY

FB145     FB190     FB195     FB40.1    FB40.2    FB40.3
FB45.1    GL135     GL191     GL195     GL196     GL197
CU02.1    CU02.2    CU202     CU220     SNCU.1    SNOP.1
SNRP.1    SNSP.1    CU05.1    CU05.2

UPDATED BY

GL110     GL500     CU161     CU20.1    CU20.2    CU20.3
CU20.4    CU300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CTR-CURRENCY-TABLE     Alpha 12                                  CU161   CU20.1
Element: Currency TableThis is a table of currency               CU20.2  GL500
                       relationships, exchange rates, and
                       translation rates used by one or more
                       companies. If multiple companies share
                       rates, each company can be linked to the
                       same currency table, eliminating the
                       need to set up rates for each company
                       individually.


CTR-FR-CURR-CODE       Alpha 5                                   CU161   CU20.1
Element: From Currency Type or select the company base           CU20.2  CU20.3
                       currency code you are translating         CU20.4  GL500
                       balances from. A currency relationship
                       must exist between the From and To
                       Currency in CU02.1 (Currency
                       Relationship).


CTR-TO-CURR-CODE       Alpha 5                                   CU161   CU20.1
Element: To Currency CoType or select the company base           CU20.2  CU20.3
                       currency code you are translating         CU20.4  GL500
                       balances from. A currency relationship
                       must exist between the From and To
                       Currency in CU02.1 (Currency
                       Relationship).


CTR-FISCAL-YEAR        Numeric 4                                 CU161   CU20.1
Element: Fiscal Year   Rates are entered in this year, the       CU20.2  CU20.3
                       current fiscal year. The year must be     CU20.4  GL500
                       greater than 1900.

                       1901
                       9999

CTR-COMPANY            Numeric 4                                 CU161   CU20.1
Element: Company       This is the From company the              CU20.3  CU20.4
                       translation rates apply to. If the        GL110   GL500
                       record is for a currency table, this
                       field is zero.


CTR-BUDGET-NBR         Numeric 3                                 CU161   CU20.1
Element: Budget        This is the budget number the currency    CU20.2  CU20.3
                       rates apply to.                           CU20.4  GL500


CTR-TRANSL-CODE        Alpha 2                                   CU161   CU20.1
Element: Translation CoThis field determines how the currency    CU20.2  CU20.3
                       code is translated. This translation      CU20.4  GL500
                       code must be a valid code in the
                       Translation Codes file.


CTR-RATE-VALUE         Signed 14.7 Occurs 13 Times               CU161   CU20.1
Element: Rate Value    The rates in this field are applied to    CU20.2  CU20.3
                       actual and budget amounts.                CU20.4  FB195
                                                                 GL195   GL500

CTR-RATE-BEG-BAL       Signed 14.7                               CU161   CU20.1
Rate Beginning         This is the beginning balance rate,       CU20.3  FB195
Balance                which applies to the beginning balance    GL500
                       of any budgets to be translated.


                         CUTRANSL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTRSET1   CURRENCY-TABLE                                         FB145   FB190
          FR-CURR-CODE                                           FB195   FB40.1
          TO-CURR-CODE                                           FB40.2  FB40.3
          FISCAL-YEAR                                            FB45.1  GL110
          COMPANY                                                GL135   GL191
          BUDGET-NBR                                             GL195   GL196
          TRANSL-CODE                                            GL197   CU02.1
                                                                 CU02.2  CU161
                                                                 CU20.1  CU20.2
                                                                 CU202   CU220
                                                                 SNCU.1  SNOP.1
                                                                 SNRP.1  SNSP.1

CTRSET2   CURRENCY-TABLE                                         CU20.2  CU300
          COMPANY
          FISCAL-YEAR
          BUDGET-NBR
          TRANSL-CODE
          FR-CURR-CODE
          TO-CURR-CODE

CTRSET3   TRANSL-CODE                                            CU05.1  CU05.2
          CURRENCY-TABLE
          COMPANY
          FR-CURR-CODE
          TO-CURR-CODE
          FISCAL-YEAR
          BUDGET-NBR

CTRSET4   COMPANY       Subset                                   FB145   FB190
          FR-CURR-CODE  Where COMPANY != Zeroes                  FB195   FB40.1
          TO-CURR-CODE                                           FB40.2  FB40.3
          FISCAL-YEAR                                            FB45.1  GL135
          BUDGET-NBR                                             GL191   GL195
          TRANSL-CODE                                            GL196   GL197
                                                                 GL500   CU161
                                                                 CU20.3  CU20.4
                                                                 CU220   SNOP.1
                                                                 SNRP.1  SNSP.1

CTRSET5   COMPANY       Subset                                   CU20.4
          FISCAL-YEAR   Where COMPANY != Zeroes
          BUDGET-NBR
          TRANSL-CODE
          FR-CURR-CODE
          TO-CURR-CODE

                         CUTRANSL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Curelat        CURELAT      Required

                            CTR-CURRENCY-TABLE    -> CRL-CURRENCY-TABLE
                            CTR-FR-CURR-CODE      -> CRL-FR-CURR-CODE
                            CTR-TO-CURR-CODE      -> CRL-TO-CURR-CODE

Fr Cucodes     CUCODES      Required

                            CTR-FR-CURR-CODE      -> CUC-CURRENCY-CODE

Glsystem       GLSYSTEM     Required

                            CTR-COMPANY           -> GLS-COMPANY

To Cucodes     CUCODES      Required

                            CTR-TO-CURR-CODE      -> CUC-CURRENCY-CODE

Trcodes        TRCODES      Required

                            CTR-TRANSL-CODE       -> TRC-TRANSL-CODE