[Home] [Help]
View: XTR_QUICK_INPUT_DEALS_V
| Product: | XTR - Treasury |
| Description: | This table is designed to store the tolerance setup for the override feature |
| Implementation/DBA Data: |
APPS.XTR_QUICK_INPUT_DEALS_V
|
View Text
SELECT QUOTE_NO
, DEAL_NO
, TRANSACTION_NUMBER
, COMPANY_CODE
, CPARTY_CODE
, CLIENT_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, PRODUCT_TYPE
, ISSUE_CODE
, CURRENCY1
, CURRENCY2
, TRANSACTION_RATE
, FX_SWAP_RATE
, AMOUNT_TYPE
, BASE_AMOUNT
, DEAL_DATE
, VALUE_DATE
, MATURITY_DATE
, DEALER_CODE
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, FULL_INPUT_COMPLETED
, STATUS_CODE
, PORTFOLIO_CODE
, PUT_CALL
, PREMIUM_AMOUNT
, YEAR_CALC_TYPE
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PREPAID_INTEREST
FROM XTR_QUICK_INPUT_DEALS
Columns
| Name |
| QUOTE_NO |
| DEAL_NO |
| TRANSACTION_NUMBER |
| COMPANY_CODE |
| CPARTY_CODE |
| CLIENT_CODE |
| DEAL_TYPE |
| DEAL_SUBTYPE |
| PRODUCT_TYPE |
| ISSUE_CODE |
| CURRENCY1 |
| CURRENCY2 |
| TRANSACTION_RATE |
| FX_SWAP_RATE |
| AMOUNT_TYPE |
| BASE_AMOUNT |
| DEAL_DATE |
| VALUE_DATE |
| MATURITY_DATE |
| DEALER_CODE |
| CREATED_BY |
| CREATED_ON |
| UPDATED_BY |
| UPDATED_ON |
| FULL_INPUT_COMPLETED |
| STATUS_CODE |
| PORTFOLIO_CODE |
| PUT_CALL |
| PREMIUM_AMOUNT |
| YEAR_CALC_TYPE |
| ROUNDING_TYPE |
| DAY_COUNT_TYPE |
| PREPAID_INTEREST |