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.

VIEW: XTR.XTR_FX_ROLL_PRE_DETAILS#

Source

View Text - Preformatted


select BASE_RATE BASE_RATE, BUY_AMOUNT BUY_AMOUNT, CLIENT_CODE CLIENT_CODE, COMPANY_CODE COMPANY_CODE, COMP_SETTLEMENT_ACCT COMP_SETTLEMENT_ACCT, CPARTY_CODE CPARTY_CODE, CURRENCY_BUY CURRENCY_BUY, CURRENCY_SELL CURRENCY_SELL, DEALER_CODE DEALER_CODE, DEAL_DATE DEAL_DATE, DEAL_NO DEAL_NO, LIMIT_CODE LIMIT_CODE, MULTIPLE_TRANS_YN MULTIPLE_TRANS_YN, PORTFOLIO_CODE PORTFOLIO_CODE, PREV_DEAL_NO PREV_DEAL_NO, REF_NUMBER REF_NUMBER, ROLL_PRE ROLL_PRE, ROLL_PRE_ON ROLL_PRE_ON, SELL_AMOUNT SELL_AMOUNT, SETTLED_CURRENT SETTLED_CURRENT, SETTLEMENT_PARTY SETTLEMENT_PARTY, SETTLEMENT_PARTY_ACCT SETTLEMENT_PARTY_ACCT, TRANS_RATE TRANS_RATE, VALUE_DATE VALUE_DATE from "XTR"."XTR_FX_ROLL_PRE_DETAILS"

View Text - HTML Formatted

SELECT BASE_RATE BASE_RATE
, BUY_AMOUNT BUY_AMOUNT
, CLIENT_CODE CLIENT_CODE
, COMPANY_CODE COMPANY_CODE
, COMP_SETTLEMENT_ACCT COMP_SETTLEMENT_ACCT
, CPARTY_CODE CPARTY_CODE
, CURRENCY_BUY CURRENCY_BUY
, CURRENCY_SELL CURRENCY_SELL
, DEALER_CODE DEALER_CODE
, DEAL_DATE DEAL_DATE
, DEAL_NO DEAL_NO
, LIMIT_CODE LIMIT_CODE
, MULTIPLE_TRANS_YN MULTIPLE_TRANS_YN
, PORTFOLIO_CODE PORTFOLIO_CODE
, PREV_DEAL_NO PREV_DEAL_NO
, REF_NUMBER REF_NUMBER
, ROLL_PRE ROLL_PRE
, ROLL_PRE_ON ROLL_PRE_ON
, SELL_AMOUNT SELL_AMOUNT
, SETTLED_CURRENT SETTLED_CURRENT
, SETTLEMENT_PARTY SETTLEMENT_PARTY
, SETTLEMENT_PARTY_ACCT SETTLEMENT_PARTY_ACCT
, TRANS_RATE TRANS_RATE
, VALUE_DATE VALUE_DATE
FROM "XTR"."XTR_FX_ROLL_PRE_DETAILS"