FND Design Data [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: ViewAPPS.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