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 AC41.1 AC42.1 HR700 DR100
IC141 IC142 IC83.1 CU02.1 CU02.2 CU03.1
CU10.1 CU10.2 CU160 CU202 CU210 CU220
CU260 CU300 CU60.1 GL10.1 IFCR.1 TR00.1
RQ10.1 RQ10.3 RQ11.1 RQ20.1 RQ35.1 RQ500
WH20.7
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
AC41.1 AC42.1
HR700 DR100
IC141 IC142
IC83.1 CU00.1
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU160
CU202 CU210
CU220 CU260
CU300 CU60.1
GL10.1 IFCR.1
TR00.1 RQ10.1
RQ10.3 RQ11.1
RQ20.1 RQ35.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
|