Lawson Insight Technical Documentation

                              CUTABLE FILE

                             Currency Table

This file defines currency tables, which include currency relationships,
currency exchange rates, and translation rates. CU20.1 (Currency Table
Translation Rates) is the primary program that updates this file.


REFERENCED BY

AC00.1    AC200     AC210     AC550     AC750     CU02.1
CU02.2    CU03.1    CU10.1    CU10.2    CU160     CU161
CU202     CU210     CU220     CU260     CU261     CU300
CU60.1    CU61.1    GL10.1    IFCU.1    TR00.1

UPDATED BY

CU00.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CTB-CURRENCY-TABLE   Alpha 12                                    CU00.1
Currency Table       This is the currency table, a table of
                     currency relationships, currency
                     exchange rates, and translation rates
                     for one or more companies.


CTB-DESCRIPTION      Alpha 30  (Lower Case)                      AC00.1  CU00.1
Currency Table       This is the description of the currency
Description          table.



CTB-ACTIVE-FLAG      Alpha 1
Active Flag          This field indicates whether the
                     currency table is active or inactive.

                     A = Active
                     I = Inactive

                         CUTABLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTBSET1   CURRENCY-TABLE                                         AC00.1  AC200
                                                                 AC210   AC550
                                                                 AC750   CU00.1
                                                                 CU02.1  CU02.2
                                                                 CU03.1  CU10.1
                                                                 CU10.2  CU160
                                                                 CU161   CU202
                                                                 CU210   CU220
                                                                 CU260   CU261
                                                                 CU300   CU60.1
                                                                 CU61.1  GL10.1
                                                                 IFCU.1  TR00.1

                         CUTABLE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cuconv         CUCONV

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

Curelat        CURELAT

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

Cutransl       CUTRANSL

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

Glsystem       GLSYSTEM     Required

                            CTB-CURRENCY-TABLE    -> GLS-CURRENCY-TABLE
                                                     GLS-COMPANY