[Home] [Help] [Dependency Information]
Object Name: | XTR_MARKET_DATA_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_MARKET_DATA_INTERFACE |
Subobject Name: | |
Status: | VALID |
XTR_MARKET_DATA_INTERFACE contains market data for transfer into the Treasury system. The market data transfer process stores the status of each row that is transferred in this table.
Scope: public
Product: XTR
Lifecycle: active
Display Name: Treasury Market Data Interface
Category: BUSINESS_ENTITY XTR_MARKET_DATA
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE | VARCHAR2 | (20) | Yes | Feed source name |
EXTERNAL_REF_CODE | VARCHAR2 | (20) | Yes | Feed source name |
DATETIME | DATE | Date of market data | ||
BID | NUMBER | Bid quote | ||
ASK | NUMBER | Ask quote | ||
MID | NUMBER | Mid quote | ||
SPREAD | NUMBER | Spread quote (the difference between ask and bid quotes) | ||
RETURN_CODE | NUMBER | Return code recorded by the market data transfer process | ||
REF_CODE | VARCHAR2 | (20) | User-defined market data code in Treasury (set by the transfer process) | |
CREATED_BY | NUMBER | (15) | Standard Who Column; ID of user who loaded the data into this table | |
CREATION_DATE | DATE | Standard Who Column; Date when the data was loaded into this table | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column; ID of user who ran the transfer process | |
LAST_UPDATED_DATE | DATE | Standard Who Column; Date when the transfer process was run | ||
LAST_UPDATED_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE
, EXTERNAL_REF_CODE
, DATETIME
, BID
, ASK
, MID
, SPREAD
, RETURN_CODE
, REF_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_LOGIN
FROM XTR.XTR_MARKET_DATA_INTERFACE;
XTR.XTR_MARKET_DATA_INTERFACE does not reference any database object
XTR.XTR_MARKET_DATA_INTERFACE is referenced by following:
|
|
|