CUCONVREL FILE

                        Currency Rate Conversion

The Currency Rate Conversion (CUCONVREL) file stores currency exchange rate
information you are converting from a non-Lawson system to the Lawson Currency
system using CU60, CU160, and CU260.


REFERENCED BY

CU260

UPDATED BY

CU160     CU60.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CUR-CURRENCY-TABLE   Alpha 12                                    CU60.1
Currency Table       The currency table stores interface
                     information. It is similar to a run
                     group.


CUR-SEQ-NUMBER       Numeric 6                                   CU60.1
Sequence Number      A unique number assigned to each
                     transaction to be transferred into the
                     Lawson system.

CUR-FR-CURR-CODE     Alpha 5                                     CU60.1
From Currency Code   This is the company base currency code,
                     established in GL10.1 (Company).


CUR-TO-CURR-CODE     Alpha 5                                     CU60.1
To Currency Code     This is the company base currency code,
                     established in GL10.1 (Company).


CUR-SYSTEM           Alpha 2                                     CU60.1
System Code          A two-character code representing an
                     application used within the Lawson
                     system. (i.e.: GL = General Ledger, AP =
                     Accounts Payable, etc.)

CUR-EFFECT-DATE      Numeric 8  (yyyymmdd)                       CU60.1
Effective Date       The effective date identifies when the
                     exchange rate can be used.


CUR-SELL-RATE        Signed 12.6                                 CU60.1
Exchange Rate        This is the exchange rate you converted
                     to the Lawson system from your
                     non-Lawson system.


                         CUCONVREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CURSET1   CURRENCY-TABLE                                         CU160   CU60.1
          SEQ-NUMBER

CURSET2   CURRENCY-TABLEKeyChange                                CU260   CU60.1
          FR-CURR-CODE
          TO-CURR-CODE
          SYSTEM
          EFFECT-DATE
          SEQ-NUMBER