GL_FIXED_CONV_RATES
GL_FIXED_CONV_RATES contains the fixed conversion rate between an old currency that is being phased out and its replacement currency. Each row in the table includes columns for the old currency, the replacement currency, the fixed conversion rate from the old currency to the replacement currency, and the date on which this relationship becomes effective. Each currency can only have a single replacement currency. Also, if a currency appears as a replacement currency in this table, it should not also appear as an old currency.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_FIXED_CONV_RATES_PK |
OLD_CURRENCY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OLD_CURRENCY | VARCHAR2 | 15 | Yes | Fixed conversion type of old currency. | |
| REPLACEMENT_CURRENCY | VARCHAR2 | 15 | Yes | Fixed conversion type of replacement currency. | |
| FIXED_CONVERSION_RATE | NUMBER | Yes | Fixed conversion rate from the old currency to the replacement currency. | ||
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ENTERPRISE_ID | NUMBER | 18 | Enterprise or business group identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_FIXED_CONV_RATES_N1 | Non Unique | REPLACEMENT_CURRENCY |
| GL_FIXED_CONV_RATES_U1 | Unique | OLD_CURRENCY |