[Home] [Help] [Dependency Information]
Object Name: | GL_FIXED_CONV_RATES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_FIXED_CONV_RATES |
Subobject Name: | |
Status: | VALID |
The GL_FIXED_CONV_RATES table stores 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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_FIXED_CONV_RATES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | OLD_CURRENCY |
GL_FIXED_CONV_RATES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REPLACEMENT_CURRENCY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OLD_CURRENCY | VARCHAR2 | (15) | Yes | Old currency |
REPLACEMENT_CURRENCY | VARCHAR2 | (15) | Yes | Replacement currency |
FIXED_CONVERSION_RATE | NUMBER | Yes | Fixed conversion rate from the old currency to the replacement currency | |
EFFECTIVE_START_DATE | DATE | Yes | The fixed rate relationship is valid from this date | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT OLD_CURRENCY
, REPLACEMENT_CURRENCY
, FIXED_CONVERSION_RATE
, EFFECTIVE_START_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM GL.GL_FIXED_CONV_RATES;
GL.GL_FIXED_CONV_RATES does not reference any database object
GL.GL_FIXED_CONV_RATES is referenced by following:
|
|
|