DBA Data[Home] [Help] [Dependency Information]

TABLE: GL.GL_DAILY_RATES

Object Details
Object Name: GL_DAILY_RATES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_DAILY_RATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_CURRENCY
ColumnTO_CURRENCY
ColumnCONVERSION_DATE
ColumnCONVERSION_TYPE
Columns
Name Datatype Length Mandatory Comments
FROM_CURRENCY VARCHAR2 (15) Yes From currency
TO_CURRENCY VARCHAR2 (15) Yes To currency
CONVERSION_DATE DATE
Yes Currency conversion date
CONVERSION_TYPE VARCHAR2 (30) Yes Currency conversion type
CONVERSION_RATE NUMBER
Yes Currency conversion rate
STATUS_CODE VARCHAR2 (1) Yes Daily balances up to date flag
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
CONTEXT VARCHAR2 (150)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
RATE_SOURCE_CODE VARCHAR2 (15)
Identify daily rates source
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:

SchemaGL
ViewGL_DAILY_RATES#