eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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