[Home] [Help]
View: XTR_A_REVALUATION_DETAILS_V
View Text
SELECT UNIQUE_REF_NUM
, COMPANY_CODE
, PERIOD_FROM
, 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
, REVAL_VALUE
, REALISED_PL
, UNREALISED_PL
, RATE_ERROR
, FX_REVAL_PRINCIPAL_BAL
, FXO_SELL_REF_AMOUNT
, UPDATED_BY
, UPDATED_ON
, YEAR_BASIS
, REVAL_CCY
, CROSS_REF_TO_POSTING
, ACTION_CODE
, REVAL_HCE_AMOUNT
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, CREATED_BY
, CREATED_ON
, AUTHORIZE_JOURNAL_CREATION
, JOURNAL_CREATED
FROM XTR_A_REVALUATION_DETAILS
Columns
Name |
UNIQUE_REF_NUM |
COMPANY_CODE |
PERIOD_FROM |
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 |
REVAL_VALUE |
REALISED_PL |
UNREALISED_PL |
RATE_ERROR |
FX_REVAL_PRINCIPAL_BAL |
FXO_SELL_REF_AMOUNT |
UPDATED_BY |
UPDATED_ON |
YEAR_BASIS |
REVAL_CCY |
CROSS_REF_TO_POSTING |
ACTION_CODE |
REVAL_HCE_AMOUNT |
AUDIT_INDICATOR |
AUDIT_DATE_STORED |
CREATED_BY |
CREATED_ON |
AUTHORIZE_JOURNAL_CREATION |
JOURNAL_CREATED |