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 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
|