Lawson Insight Technical Documentation |
|
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 AC56.1 AC560 AC70.1
CBD2.1 ET700 CU02.1 CU02.2 CU03.1 CU10.1
CU10.2 CU160 CU161 CU162 CU202 CU210
CU220 CU260 CU261 CU262 CU300 CU60.1
CU61.1 CU62.1 GL10.1 IFCU.1 TR00.1 SN40.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 AC70.1
Currency Table This is the description of the currency CU00.1
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
CTB-AUTOGEN Alpha 1 CU00.1
Element: Autogen This field indicates whether the
opposite currency relationship should be
added when a new relationship is added.
It also indicates whether exchange rates
should be added if the opposite currency
relationship exists and if that opposite
relationship has the reverse operator.
CTB-CURR-REL-FLAG Derived
Element: Curr Rel Flag
CUTABLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTBSET1 CURRENCY-TABLE AC00.1 AC200
AC210 AC56.1
AC560 AC70.1
CBD2.1 ET700
CU00.1 CU02.1
CU02.2 CU03.1
CU10.1 CU10.2
CU160 CU161
CU162 CU202
CU210 CU220
CU260 CU261
CU262 CU300
CU60.1 CU61.1
CU62.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
|