CUTABLE

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 AC191 AC200 AC210 AC56.1 AC560
AC70.1 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
CB222 CBD2.1 FB45.1 GL100 GL110 GL111
GL120 GL122 GL135 GL146 GL148 GL167
GL190 GL195 GL196 GL197 GL199 GL330
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL500 DR100 IC141 IC142 IC222
IC83.1 CU01.1 CU01.2 CU02.1 CU02.2 CU03.1
CU10.1 CU10.2 CU160 CU161 CU162 CU20.1
CU20.2 CU20.3 CU202 CU210 CU220 CU260
CU261 CU262 CU278 CU300 CU60.1 CU61.1
CU62.1 EX12.1 GL00.2 GL00.3 GL00.6 GL00.7
GL00.9 GL02.1 GL02.2 GL02.3 GL02.6 GL03.6
GL10.1 GL10.2 GL121 GL124 GL125 GL160
GL161 GL20.1 GL20.2 GL20.4 IFAC.1 IFCU.1
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 MA61.1 MAI1.1 ML146 ML167
ML190 ML195 ML196 ML199 ML330 ML40.1
ML40.2 ML40.3 ML40.7 ML40.8 ML44.1 ML45.1
TR00.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1
RQ500 RQIB.1 RQIF.1 RQIJ.1 SN40.1


UPDATED BY
CU00.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTB-CURRENCY-TABLE
Element: Currency Table		Alpha 12
This is the currency table, a table of currency relationships, currency exchange rates, and translation rates for one or more companies.
CU00.1
CTB-DESCRIPTION
Currency Table
Description		Alpha 30 (Lower Case)
This is the description of the currency table.
AC00.1 AC70.1
CU00.1
CTB-ACTIVE-FLAG
Element: Active Flag		Alpha 1
This field indicates whether the currency table is active or inactive.
A = Active
I = Inactive
CTB-AUTOGEN
Element: Autogen		Alpha 1
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.
CU00.1
CTB-CURR-REL-FLAG
Element: Curr Rel Flag		Derived


CUTABLE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTBSET1 CURRENCY-TABLE
...
AC00.1 AC191
AC200 AC210
AC56.1 AC560
AC70.1 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 CBD2.1
FB45.1 GL100
GL110 GL111


CUTABLE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:20:28 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.