Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CURELATREL


                            CURELATREL FILE

                      Currency Relation Interface

REFERENCED BY

CU262

UPDATED BY

CU162     CU62.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRI-CURRENCY-TABLE     Alpha 12                                  CU62.1
Element: Currency TableThis field contains the name of the
                       currency table for which the relations
                       are interfaced.

CRI-SEQ-NUMBER         Numeric 6                                 CU62.1
Element: Seq Number    A unique number assigned to each
                       transaction to be interfaced into the
                       Lawson system.

CRI-FR-CURR-CODE       Alpha 5                                   CU62.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

CRI-TO-CURR-CODE       Alpha 5                                   CU62.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

CRI-MULT-DIV           Alpha 1                                   CU162   CU62.1
Element: Mult Div      This indicates whether the rate will be
                       multiplied or divided.

CRI-OVD-TOLERANCE      Numeric 3                                 CU62.1
Element: Ovd Tolerance This field indicates by what percentage
                       you can override the exchange rate. The
                       default is blank which indicates that no
                       tolerance editing takes place.
                       This field is ignored if Overrride
                       Protection is set to Yes.

CRI-TRNGLT-IND         Alpha 1                                   CU62.1
Element: Trnglt Ind    This field indicates whether the
                       currency  relationship is triangulated,
                       that is  whether the currencies in the
                       relationship must use a third currency
                       to convert.
                       Y = Yes
                       N = No

CRI-TRNGLT-CURR-CD     Alpha 5                                   CU62.1
Element: Currency Code If you selected Y (Yes) in the
                       Triangulate field, select the currency
                       used to triangulate the conversion. For
                       members of the European Union, this
                       should  be the Euro.

CRI-OVD-PROT-IND       Alpha 1                                   CU62.1
Element: Ovd Prot Ind  This field determines if the
                       translation rate should be protected
                       from being overridden in a journal
                       entry.  The default is N (No).

                         CURELATREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRISET1   CURRENCY-TABLE                                         CU162   CU262
          SEQ-NUMBER                                             CU62.1

CRISET2   CURRENCY-TABLE                                         CU162   CU62.1
          FR-CURR-CODE
          TO-CURR-CODE
          SEQ-NUMBER