[Home] [Help]
View: XTR_POSITION_HISTORY_V
Product: | XTR - Treasury |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ACCOUNT_NO
, AS_AT_DATE
, BASE_REF_AMOUNT
, BASE_RATE
, COMPANY_CODE
, CONTRA_CCY
, CURRENCY
, CURRENCY_COMBINATION
, DEAL_NUMBER
, DEAL_SUBTYPE
, DEAL_TYPE
, HCE_BASE_REF_AMOUNT
, CPARTY_CODE
, PORTFOLIO_CODE
, PRODUCT_TYPE
, STATUS_CODE
, TRANSACTION_NUMBER
, TRANSACTION_RATE
, YEAR_CALC_TYPE
FROM XTR_POSITION_HISTORY
Columns
Name |
ACCOUNT_NO |
AS_AT_DATE |
BASE_REF_AMOUNT |
BASE_RATE |
COMPANY_CODE |
CONTRA_CCY |
CURRENCY |
CURRENCY_COMBINATION |
DEAL_NUMBER |
DEAL_SUBTYPE |
DEAL_TYPE |
HCE_BASE_REF_AMOUNT |
CPARTY_CODE |
PORTFOLIO_CODE |
PRODUCT_TYPE |
STATUS_CODE |
TRANSACTION_NUMBER |
TRANSACTION_RATE |
YEAR_CALC_TYPE |