[Home] [Help] [Dependency Information]

TABLE: GL.GL_DAILY_RATES

Object Details

Object Name:	GL_DAILY_RATES
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_DAILY_RATES
Subobject Name:
Status:	VALID

GL_DAILY_RATES stores the daily conversion rates for foreign currency transactions. It replaces the GL_DAILY_CONVERSION_RATES table. It stores the rate to use when converting between two currencies for a given conversion date and conversion type.
Each row in this table has a corresponding inverse row in which the from and to currencies are switched. For example, if this table contains a row with a from_currency of YEN, a to_currency of CND, a conversion_type of Spot, and a conversion_date of January 1, 1997, it will also contain a row with a from_currency of CND, a to_currency of YEN, a conversion_type of Spot, and a conversion_date of January 1, 1997. In general, this row will contain a rate that is the inverse of the matching row.
Customers should never insert directly into this table. They should instead insert into the GL_DAILY_RATES_INTERFACE table. Data inserted into the GL_DAILY_RATES_INTERFACE table will be automatically copied into this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_DAILY_RATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FROM_CURRENCY TO_CURRENCY CONVERSION_DATE CONVERSION_TYPE

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT FROM_CURRENCY
,      TO_CURRENCY
,      CONVERSION_DATE
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      STATUS_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RATE_SOURCE_CODE
FROM GL.GL_DAILY_RATES;

Dependencies

[top of page]

GL.GL_DAILY_RATES does not reference any database object

GL.GL_DAILY_RATES is referenced by following:

APPS

GL_DAILY_RATES