Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUCONV


                              CUCONV FILE

                         Currency Exhange Rate

This file maintains rate tables for each defined currency relationship.
CU10.1 (Exchange Rates) is the primary program that updates this file. It
creates a single currency relationship with all of the rates sequenced by
effective date. Rates can be maintained as often as once a day.


REFERENCED BY

ET700     CU02.1    CU02.2    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
CA10.5    CA110     CA190     FB100     FB195     FB20.1
FB20.6    FB20.7    FB21.1    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
CU202     CU210     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    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

CU10.1    CU10.2    CU160     CU300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CCN-CURRENCY-TABLE     Alpha 12                                  CU10.1  CU10.2
Element: Currency TableThis is the currency table, a table of    CU160
                       currency relationships, currency
                       exchange rates, and translation rates
                       for one or more companies.


CCN-FR-CURR-CODE       Alpha 5                                   CU10.1  CU10.2
Element: From Currency This is the name of the currency code     CU160
                       you are converting from. It must be
                       defined in the Currency Codes file.


CCN-TO-CURR-CODE       Alpha 5                                   CU10.1  CU10.2
Element: To Currency CoThe name of the currency code you are     CU160
                       converting to. It must be defined in the
                       Currency Codes file.


CCN-SYSTEM             Alpha 2                                   CU10.1  CU10.2
Element: System        The system code is a two-character code   CU160
                       representing an application used within
                       the Lawson system. (For example, GL =
                       General Ledger, AP = Accounts Payable,
                       etc.)


CCN-EFFECT-DATE        Numeric 8  (yyyymmdd)                     CU10.1  CU10.2
Element: Effective DateThe effective date is the date the        CU160
                       exchange rate is effective. This date is
                       used until a new exchange rate is
                       defined with a later date.


CCN-SELL-RATE          Signed 14.7                               CU10.1  CU10.2
Element: Selling Rate  This field contains the rate the From     CU160
                       currency amount to the To currency
                       amount is converted at.


                         CUCONV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CCNSET1   CURRENCY-TABLE                                         ET700   CU02.1
          FR-CURR-CODE                                           CU02.2  CU10.1
          TO-CURR-CODE                                           CU10.2  CU160
          SYSTEM
          EFFECT-DATE

CCNSET2   CURRENCY-TABLE*                                        AC121   AC123
          FR-CURR-CODE                                           AC127   AC130
          TO-CURR-CODE                                           AC160   AC190
          SYSTEM                                                 AC197   AC198
          EFFECT-DATE*                                           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
                                                                 ...

CCNSET3   CURRENCY-TABLE                                         CU10.2  CU300
          EFFECT-DATE*
          FR-CURR-CODE
          TO-CURR-CODE
          SYSTEM

                         CUCONV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Curelat        CURELAT      Required

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

Fr Cucodes     CUCODES      Required

                            CCN-FR-CURR-CODE      -> CUC-CURRENCY-CODE

To Cucodes     CUCODES      Required

                            CCN-TO-CURR-CODE      -> CUC-CURRENCY-CODE

                         CUCONV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glsystem       GLSYSTEM

                            CCN-CURRENCY-TABLE    -> GLS-CURRENCY-TABLE
                                                     GLS-COMPANY