[Home] [Help]
View: XTR_WHATIF_DETAILS_V
| Product: | XTR - Treasury |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SCENARIO_CODE
, USER_ID
, COMPANY_CODE
, PERIOD_TO
, DEAL_TYPE
, DEAL_SUBTYPE
, PRODUCT_TYPE
, CURRENCYA
, TRANSACTION_PERIOD
, FACE_VALUE
, ENTERED_ON
, ENTERED_BY
, DEAL_NO
, TRANSACTION_NO
, TRANSACTION_RATE
, EFFECTIVE_DATE
, EFFECTIVE_DAYS
, CURRENCY_INDICATOR
, CURRENCYB
, PORTFOLIO_CODE
, CONTRACT_CODE
, REVAL_RATE
, SCENARIO1_RATE
, SCENARIO2_RATE
, SCENARIO3_RATE
, REVAL_VALUE
, UNREALISED_PL
, RATE_ERROR
, FX_REVAL_PRINCIPAL_BAL
, FXO_SELL_REF_AMOUNT
, SCENARIO1_PL
, SCENARIO2_PL
, SCENARIO3_PL
, DUMMY_TRANSACTION
FROM XTR_WHATIF_DETAILS
Columns
| Name |
| SCENARIO_CODE |
| USER_ID |
| COMPANY_CODE |
| PERIOD_TO |
| DEAL_TYPE |
| DEAL_SUBTYPE |
| PRODUCT_TYPE |
| CURRENCYA |
| TRANSACTION_PERIOD |
| FACE_VALUE |
| ENTERED_ON |
| ENTERED_BY |
| DEAL_NO |
| TRANSACTION_NO |
| TRANSACTION_RATE |
| EFFECTIVE_DATE |
| EFFECTIVE_DAYS |
| CURRENCY_INDICATOR |
| CURRENCYB |
| PORTFOLIO_CODE |
| CONTRACT_CODE |
| REVAL_RATE |
| SCENARIO1_RATE |
| SCENARIO2_RATE |
| SCENARIO3_RATE |
| REVAL_VALUE |
| UNREALISED_PL |
| RATE_ERROR |
| FX_REVAL_PRINCIPAL_BAL |
| FXO_SELL_REF_AMOUNT |
| SCENARIO1_PL |
| SCENARIO2_PL |
| SCENARIO3_PL |
| DUMMY_TRANSACTION |