[Home] [Help] [Dependency Information]
Object Name: | XTR_BUY_SELL_COMBINATIONS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_BUY_SELL_COMBINATIONS |
Subobject Name: | |
Status: | VALID |
XTR_BUY_SELL_COMBINATIONS contains information about currency combinations that are purchased and sold. Each rowcurrency combination consists of two currencies: one for purchase (buy currency) and one for sale (sell currency). For each currency combination, this table contains two rows: one for the buy/sell combination and the other for the sell/buy combination. . This table is the source for the list of currency combinations that you can select when you create a foreign exchange deal.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_BUY_SELL_COMBINATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CURRENCY_BUY
CURRENCY_SELL |
XTR_BUY_SELL_COMBINATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CURRENCY_FIRST
CURRENCY_SECOND |
XTR_BUY_SELL_COMBINATIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENCY_SECOND |
XTR_BUY_SELL_COMBINATIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENCY_SELL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
AUTHORISED | VARCHAR2 | (1) | Flag to indicate if the buy, sell currency combination is authorized for use (Y), or not (N) | |
CURRENCY_BUY | VARCHAR2 | (15) | Yes | Currency code for buy amount |
CURRENCY_FIRST | VARCHAR2 | (15) | Yes | Base currency |
CURRENCY_SECOND | VARCHAR2 | (15) | Yes | Contra currency in a foreign exchange currency quote |
CURRENCY_SELL | VARCHAR2 | (15) | Yes | Currency code for sell amount |
LATEST_CROSS_DATE | DATE | Most recent currency combination cross date | ||
LATEST_CROSS_RATE | NUMBER | Most recent currency combination cross rate | ||
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, CURRENCY_BUY
, CURRENCY_FIRST
, CURRENCY_SECOND
, CURRENCY_SELL
, LATEST_CROSS_DATE
, LATEST_CROSS_RATE
, UPDATED_BY
, UPDATED_ON
, CREATED_BY
, CREATED_ON
FROM XTR.XTR_BUY_SELL_COMBINATIONS;
XTR.XTR_BUY_SELL_COMBINATIONS does not reference any database object
XTR.XTR_BUY_SELL_COMBINATIONS is referenced by following:
|
|
|