Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUTABLE


                              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     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
Element: Currency TableThis 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
Element: 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
                                                                 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