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_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