[Home] [Help]
[Dependency Information]
[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:
APPS
XTR_BIU_MARKET_PRICES_T
XTR_MARKET_PRICES
|
|
|
|