[Home] [Help] [Dependency Information]
Object Name: | XTR_MARKET_PRICES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_MARKET_PRICES |
Subobject Name: | |
Status: | VALID |
XTR_MARKET_PRICES contains current rate information for foreign exchange and money market deal transactions. Each row corresponds to a rate for either foreign exchange spot/forward or money market deal transactions for given a time period. Modifying these rates to reflect current market rates triggers this table to archive old rates into the XTR_SPOT_RATES and XTR_INTEREST_PERIOD_RATES tables, respectively. It also triggers an update of the current spot/forward rates in the HCE_RATE column of the XTR_MASTER_CURRENCIES table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_MARKET_PRICES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SOURCE
RIC_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ARCHIVE_FREQ_TYPE | VARCHAR2 | (1) | Archive frequency type | |
ASK_PRICE | NUMBER | Asking price | ||
BID_PRICE | NUMBER | Bidding price | ||
CURRENCY_A | VARCHAR2 | (15) | Base currency | |
CURRENCY_B | VARCHAR2 | (15) | Contra currency | |
DDE_CONVERSATION_CODE | VARCHAR2 | (15) | Dynamic data exchange code from datafeed | |
DOWNLOAD_FREQ_TYPE | VARCHAR2 | (1) | Download frequency type | |
FREQ_ARCHIVE | NUMBER | Frequency of archiving | ||
FREQ_DOWNLOAD | NUMBER | Frequency of downloading | ||
LAST_ARCHIVE_TIME | DATE | Date of last archive | ||
LAST_DOWNLOAD_TIME | DATE | Date of last download | ||
MOVEMENT_INDICATOR | VARCHAR2 | (5) | Indicates if the bid price goes up, down or remains flat | |
NOS_OF_DAYS | NUMBER | Number of days for the chosen term length and term type | ||
ORAFIN_ARCHIVE_FREQ_TYPE | VARCHAR2 | (1) | Not currently used | |
ORAFIN_LAST_ARCHIVE_TIME | DATE | Not currently used | ||
PARTY_CODE | VARCHAR2 | (7) | Party code | |
PRICE_DESCRIPTION | VARCHAR2 | (50) | Yes | Price description |
REF_NUMBER | NUMBER | Yes | Number identifier for the market quote | |
RIC_CODE | VARCHAR2 | (20) | Yes | Code identifier for the market quote |
SOURCE | VARCHAR2 | (20) | Yes | Reconciliation import source |
SPREAD_BASIS | VARCHAR2 | (3) | Spread basis between bid and ask price | |
TERM_LENGTH | NUMBER | Term length | ||
TERM_TYPE | VARCHAR2 | (1) | Term type | |
TERM_YEAR | NUMBER | Term year | ||
UPDATE_RATE_YN | VARCHAR2 | (1) | Flag to indicate if rate is updated (Y), or not (N) | |
DAY_COUNT_BASIS | VARCHAR2 | (15) | ay count basis which defines the way interest accrues over time |
Cut, paste (and edit) the following text to query this object:
SELECT ARCHIVE_FREQ_TYPE
, ASK_PRICE
, BID_PRICE
, CURRENCY_A
, CURRENCY_B
, DDE_CONVERSATION_CODE
, DOWNLOAD_FREQ_TYPE
, FREQ_ARCHIVE
, FREQ_DOWNLOAD
, LAST_ARCHIVE_TIME
, LAST_DOWNLOAD_TIME
, MOVEMENT_INDICATOR
, NOS_OF_DAYS
, ORAFIN_ARCHIVE_FREQ_TYPE
, ORAFIN_LAST_ARCHIVE_TIME
, PARTY_CODE
, PRICE_DESCRIPTION
, REF_NUMBER
, RIC_CODE
, SOURCE
, SPREAD_BASIS
, TERM_LENGTH
, TERM_TYPE
, TERM_YEAR
, UPDATE_RATE_YN
, DAY_COUNT_BASIS
FROM XTR.XTR_MARKET_PRICES;
XTR.XTR_MARKET_PRICES does not reference any database object
XTR.XTR_MARKET_PRICES is referenced by following:
|
|
|