Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CURELAT


                              CURELAT FILE

                         Currency Relationships

This file contains the valid currency relationships used for a specific
currency table. CU02.1 (Currency Relationship) is the primary program that
updates this file.


REFERENCED BY

AC121     AC123     AC127     AC130     AC160     AC190
AC197     AC198     AC20.1    AC20.2    AC20.3    AC20.4
AC20.5    AC20.6    AC20.7    AC27.1    AC298     AC32.1
AC37.1    AC40.1    AC40.4    AC41.1    AC41.4    AC42.1
AC42.2    AC45.1    AC490     AC54.1    AC540     AC56.1
AC560     AC581     AC81.1    AC98.2    ACAC.1    ACVW.1
ATVW.1    AM115     AM117     AM125     AM135     AM15.1
AM15.2    AM15.3    AM15.4    AM180     AM19.1    AM19.2
AM20.1    AM20.2    AM20.3    AM20.4    AM21.1    AM21.2
AM21.3    AM21.4    AM30.1    AM500     AM502     AM51.1
AM551     AM92.1    AM97.1    AM98.1    AP00.3    AP00.4
AP03.3    AP10.1    AP10.2    AP10.5    AP10.6    AP110
AP115     AP125     AP126     AP131     AP150     AP151
AP170     AP175     AP180     AP181     AP190     AP191
AP193     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.6    AP20.7    AP20.8    AP21.1    AP210     AP220
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.3    AP30.4    AP305     AP510     AP520     AP80.1
AP90.1    AP91.1    AP95.1    API1.1    API2.1    API3.1
API4.1    API5.1    AR08.1    AR09.1    AR10.1    AR100
AR115     AR12.1    AR12.2    AR120     AR124     AR129
AR130     AR131     AR135     AR137     AR15.4    AR150
AR160     AR161     AR170     AR190     AR191     AR196
AR20.1    AR21.1    AR21.2    AR21.3    AR21.4    AR230
AR232     AR237     AR239     AR24.1    AR250     AR251
AR255     AR258     AR271     AR275     AR29.2    AR296
AR30.1    AR30.2    AR30.3    AR30.6    AR30.7    AR30.8
AR301     AR32.1    AR32.3    AR33.1    AR33.3    AR33.5
AR33.6    AR34.1    AR34.2    AR34.3    AR34.4    AR35.1
AR35.2    AR36.1    AR38.1    AR39.1    AR39.2    AR42.1
AR42.2    AR42.6    AR42.7    AR42.8    AR43.1    AR44.3
AR45.1    AR48.3    AR50.1    AR501     AR502     AR503
AR504     AR507     AR53.1    AR550     AR560     AR570
AR575     AR580     AR70.1    AR70.2    AR72.1    AR75.1
AR82.1    AR90.1    ARLL.1    BL01.1    BL02.1    BL09.1
BL120     BL122     BL123     BL125     BL130     BL140
BL20.1    BL20.3    BL20.5    BL20.6    BL202     BL21.2
BL21.5    BL29.1    BL29.2    BL30.1    BL30.2    BL30.3
BL30.5    BL31.1    BL31.2    BL31.3    BL31.5    BL31.7
BL32.1    BL32.2    BL32.3    BL32.4    BL520     BL80.1
BL802     BL820     BL85.1    BL85.2    BL90.1    BL91.1
BL92.1    BN190     BR00.1    BR00.2    BR02.3    BR10.1
BR10.2    BR11.1    BR120     BR121     BR122     BR123
BR124     BR130     BR140     BR151     BR152     BR153
BR154     BR156     BR16.1    BR165     BR190     BR20.1
BR20.2    BR20.3    BR20.4    BR20.5    BR20.6    BR40.3
BR41.1    BR41.4    BR420     BR43.1    BR44.1    BR46.1
BR46.2    BR46.4    BR48.1    BR51.1    BR51.2    BR515
BR516     BR52.1    BR52.5    BR521     BR530     BR570
BR65.1    BR65.2    BR70.1    BR70.2    BRIP.1    CB03.2
CB06.1    CB06.2    CB10.1    CB10.3    CB145     CB15.1
CB15.2    CB150     CB180     CB185     CB191     CB20.1
CB30.1    CB43.1    CB44.1    CB45.1    CB46.1    CB50.1
CB500     CB54.1    CB543     CB544     CB55.1    CB554
CB90.2    CBOP.1    CXCP.1    DT150     DT155     DT160
DT161     DT165     DT166     DT170     DT180     DT181
DT185     DT30.1    DT30.2    DT40.1    DT45.1    DT520
DT60.1    DT60.2    DT70.1    DT70.3    DT80.1    DT80.4
DT85.1    DT85.2    DT90.1    DT90.3    DT92.1    EE05.1
EE135     EE20.3    EE35.1    EE35.2    EE520     ET175
ET530     ET540     ET542     ET700     CA10.5    CA110
CA190     FB100     FB145     FB190     FB195     FB20.1
FB20.6    FB20.7    FB21.1    FB40.1    FB40.2    FB40.3
FB45.1    GL135     GL146     GL165     GL167     GL170
GL190     GL191     GL195     GL196     GL197     GL270
GL40.1    GL40.2    GL40.3    GL40.6    GL40.7    GL40.8
GL44.1    GL45.1    GL65.1    GL70.1    GL70.2    GL70.3
GL70.5    GL70.6    GL75.1    RW100     IC02.1    IC11.1
IC12.1    IC130     IC330     IC811     IC812     CU00.1
CU01.1    CU01.2    CU10.1    CU10.2    CU160     CU161
CU20.1    CU20.2    CU20.3    CU20.4    CU202     CU210
CU220     CU261     CU60.1    CU61.1    CU61.2    GL10.1
GLAV.1    GLCV.1    GLVW.1    IFCU.1    IFGT.1    MX123
MX500     LP198     MA08.1    MA180     MA208     MA279
MA310     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.4    MA43.6    MA43.7    MA530
MA531     MA540     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA65.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PD21.1    PD22.1    PD235     PO10.1    PO100
PO101     PO120     PO122     PO130     PO131     PO132
PO135     PO136     PO190     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO220     PO223
PO229     PO23.1    PO233     PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO253     PO254     PO26.1    PO27.2
PO278     PO29.1    PO295     PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.1    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO53.4    PO536     PO54.1    PO54.2    PO54.3    PO54.4
POED.1    POI3.1    POI7.1    POID.1    POIF.1    POIG.1
POII.1    POIJ.1    POIM.1    POIT.1    PR05.1    PR05.3
PR195     PR197     PR198     PR226     PR247     PR26.1
PR47.1    PR514     PR82.1    PR85.1    UK47.1    PW110
PW550     RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1
RQ13.1    RQ13.2    RQ35.1    RQ500     RQIB.1    RQIC.1
RQID.1    RQIF.1    RQIG.1    RQIJ.1    SB15.1    SB515
SL40.1    SLVW.1    SN40.1    SNOP.1    SNRP.1    SNSP.1
TE01.3    IN20.1    TX04.1    TX140     TX804     WH130
WH132     WH190     WH20.2    WH20.7    WH222     WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830

UPDATED BY

CU02.1    CU02.2    CU03.1    CU162

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRL-CURRENCY-TABLE     Alpha 12                                  CU02.1  CU02.2
Element: Currency TableThis is a table of currency               CU162
                       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.


CRL-FR-CURR-CODE       Alpha 5                                   CU02.1  CU02.2
Element: From Currency This is the name of the currency code     CU162
                       you are converting from. It must be a
                       valid code in the Currency Codes file.


CRL-TO-CURR-CODE       Alpha 5                                   CU02.1  CU02.2
Element: To Currency CoThis is the name of the currency code     CU162
                       you are converting to. It must be a
                       valid code in the Currency Codes file.


CRL-MULT-DIV           Alpha 1                                   CU02.1  CU02.2
Element: Mult Div      The Multiply/Divide field determines      CU162
                       how rates are applied during conversion
                       and translation.

                       Use Multiply, the default value, to
                       multiply the From currency amount by the
                       rate to calculate the To currency
                       amount.

                       Use Divide to divide the From currency
                       amount by the rate to calculate the To
                       currency amount.
                       M = Multiply
                       D = Divide

CRL-OVD-TOLERANCE      Numeric 3                                 CU02.1  CU02.2
Element: Override TolerThis field determines the override        CU162
                       tolerance of an exchange rate. Values
                       from 0 to 100 are acceptable. A value of
                       0 is the default and means any override
                       rate is acceptable. Any other value
                       indicates the percentage (tolerance) the
                       override rate can be over the table
                       rate.

                       000
                       100

CRL-CONV-STATUS        Alpha 1                                   CU02.1  CU02.2
Element: Conversion StaThis field indicates currency exchange    CU03.1  CU162
                       relationship status.

                       Use Active, the default value, to let
                       conversion activity take place for the
                       relationship.

                       Use Inactive to prevent conversion
                       activity.



                       A = Active
                       I = Inactive

CRL-TRANSL-STATUS      Alpha 1                                   CU02.1  CU02.2
Element: Translation StThis field indicates currency             CU162
                       translation status.

                       Use Active, the default value, to let
                       translation activity take place for the
                       relationship.

                       Use Inactive to prevent translation
                       activity.



                       A = Active
                       I = Inactive

CRL-FR-CURR-ND         Numeric 1                                 CU02.1  CU02.2
From Currency Nbr      This is the currency number of decimal    CU162
of Decimals            positions for the From currency.


CRL-TO-CURR-ND         Numeric 1                                 CU02.1  CU02.2
To Currency Nbr of     This is the currency number of decimal    CU162
Decimals               positions for the To currency.


CRL-TRNGLT-IND         Alpha 1                                   CU02.1  CU02.2
Element: Trnglt Ind    Indicates whether the currencies in a     CU162
                       conversion need to be converted by way
                       of a third  currency. Required for
                       member currencies of the European Union.


CRL-TRNGLT-CURR-CD     Alpha 5                                   CU02.1  CU02.2
Element: Currency Code The currency code of the language used    CU162
                       to triangulate a conversion. For
                       European Union (EU) currencies, the
                       triangulation currency  must be the
                       Euro.

CRL-OVD-PROT-IND       Alpha 1                                   CU02.1  CU02.2
Element: Ovd Prot Ind  Yes indicates that the conversion rates   CU162
                       cannot be overridden. The default is No.
                       Yes is required when the Triangulate
                       indicator is set to Yes.

                         CURELAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRLSET1   CURRENCY-TABLE                                         AC121   AC123
          FR-CURR-CODE                                           AC127   AC130
          TO-CURR-CODE                                           AC160   AC190
                                                                 AC197   AC198
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC27.1
                                                                 AC298   AC32.1
                                                                 AC37.1  AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC42.2  AC45.1
                                                                 AC490   AC54.1
                                                                 AC540   AC56.1
                                                                 ...

                         CURELAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Fr Cucodes     CUCODES      Required

                            CRL-FR-CURR-CODE      -> CUC-CURRENCY-CODE

To Cucodes     CUCODES      Required

                            CRL-TO-CURR-CODE      -> CUC-CURRENCY-CODE

Via Cucodes    CUCODES      Not Required

                            CRL-TRNGLT-CURR-CD    -> CUC-CURRENCY-CODE

                         CURELAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cuacct         CUACCT

                            CRL-CURRENCY-TABLE    -> CUA-CURRENCY-TABLE
                            CRL-FR-CURR-CODE      -> CUA-FR-CURR-CODE
                            CRL-TO-CURR-CODE      -> CUA-TO-CURR-CODE
                                                     CUA-COMPANY
                                                     CUA-SYSTEM

Cuconv         CUCONV       Delete Restricted

                            CRL-CURRENCY-TABLE    -> CCN-CURRENCY-TABLE
                            CRL-FR-CURR-CODE      -> CCN-FR-CURR-CODE
                            CRL-TO-CURR-CODE      -> CCN-TO-CURR-CODE
                                                     CCN-SYSTEM
                                                     CCN-EFFECT-DATE

Cuconv Dec     CUCONV

                            CRL-CURRENCY-TABLE    -> CCN-CURRENCY-TABLE
                            CRL-FR-CURR-CODE      -> CCN-FR-CURR-CODE
                            CRL-TO-CURR-CODE      -> CCN-TO-CURR-CODE
                                                     CCN-SYSTEM
                                                     CCN-EFFECT-DATE

Cutransl       CUTRANSL

                            CRL-CURRENCY-TABLE    -> CTR-CURRENCY-TABLE
                            CRL-FR-CURR-CODE      -> CTR-FR-CURR-CODE
                            CRL-TO-CURR-CODE      -> CTR-TO-CURR-CODE
                                                     CTR-FISCAL-YEAR
                                                     CTR-COMPANY
                                                     CTR-BUDGET-NBR
                                                     CTR-TRANSL-CODE

Glsystem       GLSYSTEM

                            CRL-CURRENCY-TABLE    -> GLS-CURRENCY-TABLE
                                                     GLS-COMPANY