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 AC200 AC210 CBD2.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 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 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 AC200
AC210 CBD2.1
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
SN40.1


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: Wed Jun 08 20:49:42 2016

Home
Contact Us



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