Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUTRATEREL


                            CUTRATEREL FILE

The Currency Translation Interface file contains translation rates for a
currency table or company.  The records are imported from a non-Lawson file
into this file to be interfaced to the Lawson Currency system, using CU61 and
CU161. Once records in this file are interfaced to the Currency system, they
are deleted from this file.

REFERENCED BY

CU261

UPDATED BY

CU161     CU61.1    CU61.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CUL-CURRENCY-TABLE     Alpha 12                                  CU161   CU61.1
Element: Currency TableThis field contains the name of the       CU61.2
                       currency table for which the rates are
                       interfaced.

CUL-SEQ-NUMBER         Numeric 6                                 CU161   CU61.1
Record Sequence        This unique number is assigned by the     CU61.2
Number                 system to keep the records unique.

CUL-FR-CURR-CODE       Alpha 5                                   CU161   CU261
Element: Currency Code This is the currency code from which the  CU61.1  CU61.2
                       company balances are translated..

CUL-TO-CURR-CODE       Alpha 5                                   CU161   CU61.1
Element: Currency Code This is the currency code to which the    CU61.2
                       company balances are translated.

CUL-FISCAL-YEAR        Numeric 4                                 CU61.1  CU61.2
Element: Last Closed YeThis is the fiscal year for which the
                       rates are valid.

CUL-BUDGET-NBR         Numeric 3                                 CU161   CU61.1
Element: Budget Number This is the budget to which the rates     CU61.2
                       apply.

CUL-COMPANY            Numeric 4                                 CU161   CU61.2
Element: Company       This is the company to which the rates
                       apply. Where applicable, company rates
                       override currency table rates.

CUL-TRANS-CODE         Alpha 2                                   CU161   CU61.1
Element: Trans Code    This is the translation code for the      CU61.2
                       currency translation.

CUL-RATE-VALUE         Signed 12.6 Occurs 13 Times               CU61.1  CU61.2
Element: Account Rate  This is the translation rate used - one
                       for each period in the fiscal year.

CUL-RATE-BEG-BAL       Signed 12.6                               CU61.1  CU61.2
Element: Account Rate  This is the beginning translation rate
                       used for the fiscal year.

                         CUTRATEREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CULSET1   CURRENCY-TABLE                                         CU161   CU61.1
          SEQ-NUMBER
          COMPANY

CULSET2   COMPANY                                                CU161   CU61.2
          SEQ-NUMBER
          CURRENCY-TABLE

CULSET3   CURRENCY-TABLEKeyChange                                CU161   CU261
          FR-CURR-CODE                                           CU61.1
          TO-CURR-CODE
          FISCAL-YEAR
          BUDGET-NBR
          TRANS-CODE
          SEQ-NUMBER
          COMPANY

CULSET4   COMPANY       KeyChange                                CU161   CU261
          FR-CURR-CODE                                           CU61.2
          TO-CURR-CODE
          FISCAL-YEAR
          BUDGET-NBR
          TRANS-CODE
          SEQ-NUMBER
          CURRENCY-TABLE

                         CUTRATEREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Current        CURELAT      Required

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

Fr Cucodes     CUCODES      Required

                            CUL-FR-CURR-CODE      -> CUC-CURRENCY-CODE

To Cucodes     CUCODES      Required

                            CUL-TO-CURR-CODE      -> CUC-CURRENCY-CODE