[Home] [Help] [Dependency Information]
Object Name: | XTR_QUICK_INPUT_DEALS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_QUICK_INPUT_DEALS |
Subobject Name: | |
Status: | VALID |
XTR_QUICK_INPUT_DEALS contains the information for short term money or foreign exchange deals, that was entered in the Quick Deals window. Each row corresponds to either a complete or an incomplete deal. The only valid values for the DEAL_TYPE column are FX (for foreign exchange) or ONC (short term money).
This table corresponds to the Quick Deals window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_TYPE | VARCHAR2 | (7) | Code that identifies the purpose of the amounts for a deal type | |
BASE_AMOUNT | NUMBER | Amount of deal | ||
CLIENT_CODE | VARCHAR2 | (7) | Client for which the deal is made | |
COMPANY_CODE | VARCHAR2 | (7) | Company code | |
CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
CREATED_BY | VARCHAR2 | (30) | User who created this record | |
CREATED_ON | DATE | Date this record was created | ||
CURRENCY1 | VARCHAR2 | (15) | Buy currency for foreign exchange deals | |
CURRENCY2 | VARCHAR2 | (15) | Sell currency for foreign exchange deals | |
DEALER_CODE | VARCHAR2 | (10) | Code for Treasury users | |
DEAL_DATE | DATE | Date the deal is made | ||
DEAL_NO | NUMBER | Unique number assigned to each deal | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
DEAL_TYPE | VARCHAR2 | (7) | Code for high level deals | |
FULL_INPUT_COMPLETED | VARCHAR2 | (1) | Flag to determine if all details have been entered in a quick input deal (Y), or not (N) | |
FX_SWAP_RATE | NUMBER | Foreign exchange swap rate | ||
ISSUE_CODE | VARCHAR2 | (7) | Not currently used | |
MATURITY_DATE | DATE | Date the deal matures or an action is required | ||
PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
PREMIUM_AMOUNT | NUMBER | Not currently used | ||
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
PUT_CALL | VARCHAR2 | (1) | Not currently used | |
QUOTE_NO | NUMBER | Yes | Number identifier of the quote received from a counterparty for the quick input deal | |
STATUS_CODE | VARCHAR2 | (10) | Code for the execution status of deals and transactions | |
TRANSACTION_NUMBER | NUMBER | Unique reference number assigned to a transaction | ||
TRANSACTION_RATE | NUMBER | Transaction rate for the quick deal | ||
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
VALUE_DATE | DATE | Date quick deal takes place | ||
YEAR_CALC_TYPE | VARCHAR2 | (15) | Not currently used | |
ROUNDING_TYPE | VARCHAR2 | (1) | Not currently used | |
DAY_COUNT_TYPE | VARCHAR2 | (1) | Not currently used | |
PREPAID_INTEREST | VARCHAR2 | (1) | Identify whether it is a prepaid interest deal |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_TYPE
, BASE_AMOUNT
, CLIENT_CODE
, COMPANY_CODE
, CPARTY_CODE
, CREATED_BY
, CREATED_ON
, CURRENCY1
, CURRENCY2
, DEALER_CODE
, DEAL_DATE
, DEAL_NO
, DEAL_SUBTYPE
, DEAL_TYPE
, FULL_INPUT_COMPLETED
, FX_SWAP_RATE
, ISSUE_CODE
, MATURITY_DATE
, PORTFOLIO_CODE
, PREMIUM_AMOUNT
, PRODUCT_TYPE
, PUT_CALL
, QUOTE_NO
, STATUS_CODE
, TRANSACTION_NUMBER
, TRANSACTION_RATE
, UPDATED_BY
, UPDATED_ON
, VALUE_DATE
, YEAR_CALC_TYPE
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PREPAID_INTEREST
FROM XTR.XTR_QUICK_INPUT_DEALS;
XTR.XTR_QUICK_INPUT_DEALS does not reference any database object
XTR.XTR_QUICK_INPUT_DEALS is referenced by following:
|
|
|