Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUCONVREL


                             CUCONVREL FILE

                      Curr Exchange Rate Interface

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
Element: Currency TableThe currency table stores interface
                       information. It is similar to a run
                       group.


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

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

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

CUR-SYSTEM             Alpha 2                                   CU60.1
Element: System        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
Element: Effect Date   The effective date identifies when the
                       exchange rate can be used.


CUR-SELL-RATE          Signed 14.7                               CU60.1
Element: Curr 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