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 |
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. |
|
||
CTB-DESCRIPTION Currency Table Description | Alpha 30 (Lower Case) This is the description of the currency table. |
|
||
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. |
|
||
CTB-CURR-REL-FLAG Element: Curr Rel Flag | Derived |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CTBSET1 |
CURRENCY-TABLE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cuconv | CUCONV |
| |||||||||||||||||||||
Curelat | CURELAT |
| |||||||||||||||||||||
Cutransl | CUTRANSL |
| |||||||||||||||||||||
Glsystem | GLSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.