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

FB195     GL135     GL191     GL195     GL196     CU02.1
CU02.2    CU202     CU220     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 12.6 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 12.6                               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-TABLEThis path is used to retrieve a          FB195   GL110
          FR-CURR-CODE  translation in company "From/To"         GL135   GL191
          TO-CURR-CODE  currency code order.                     GL195   GL196
          FISCAL-YEAR                                            CU02.1  CU02.2
          COMPANY                                                CU161   CU20.1
          BUDGET-NBR                                             CU20.2  CU202
          TRANSL-CODE                                            CU220

CTRSET2   CURRENCY-TABLEThis path is used to retrieve a          CU20.2  CU300
          COMPANY       translation in company, fiscal year,
          FISCAL-YEAR   etc. order.
          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                                   FB195   GL135
          FR-CURR-CODE  Where COMPANY != Zeroes                  GL191   GL195
          TO-CURR-CODE                                           GL196   GL500
          FISCAL-YEAR                                            CU161   CU20.3
          BUDGET-NBR                                             CU20.4  CU220
          TRANSL-CODE

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