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]

Table: XTR_DEALS

Product:	XTR - Treasury
Description:	Information for all financial instrument deals except exposure transactions
Implementation/DBA Data:	XTR.XTR_DEALS

Primary Key: XTR_DEALS_PK

DEAL_NO

Foreign Keys

Table	Foreign Table	Foreign Key Column
XTR_DEALS	XTR_COUNTERPARTY_LIMITS	XTR_DEALS.COMPANY_CODE XTR_DEALS.CPARTY_CODE XTR_DEALS.LIMIT_CODE
XTR_DEALS	XTR_DEAL_STATUSES	XTR_DEALS.DEAL_TYPE XTR_DEALS.STATUS_CODE
XTR_DEALS	XTR_DEAL_TYPES	XTR_DEALS.DEAL_TYPE
XTR_DEALS	XTR_MASTER_CURRENCIES	XTR_DEALS.CURRENCY
XTR_DEALS	XTR_BUY_SELL_COMBINATIONS	XTR_DEALS.CURRENCY_BUY XTR_DEALS.CURRENCY_SELL
XTR_DEALS	XTR_DEALER_CODES	XTR_DEALS.DEALER_CODE
XTR_DEALS	XTR_PRODUCT_TYPES	XTR_DEALS.DEAL_TYPE XTR_DEALS.PRODUCT_TYPE
XTR_DEALS	XTR_DEAL_SUBTYPES	XTR_DEALS.DEAL_TYPE XTR_DEALS.DEAL_SUBTYPE
XTR_DEALS	XTR_BOND_ISSUES	XTR_DEALS.BOND_ISSUE
XTR_DEALS	XTR_PAYMENT_SCHEDULE	XTR_DEALS.DEAL_SUBTYPE XTR_DEALS.PRODUCT_TYPE XTR_DEALS.PAYMENT_SCHEDULE_CODE
XTR_DEALS	XTR_COUNTERPARTY_LIMITS	XTR_DEALS.COMPANY_CODE XTR_DEALS.RISKPARTY_CODE XTR_DEALS.RISKPARTY_LIMIT_CODE
XTR_DEALS	XTR_BUY_SELL_COMBINATIONS	XTR_DEALS.REF_CCY XTR_DEALS.CTY_CCY
XTR_DEALS	XTR_BATCHES	XTR_DEALS.FIRST_REVAL_BATCH_ID
XTR_DEALS	XTR_BATCHES	XTR_DEALS.LAST_REVAL_BATCH_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.BUY_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.SELL_ACCT_USE_ID
XTR_DEALS	XTR_PORTFOLIOS	XTR_DEALS.COMPANY_CODE XTR_DEALS.PORTFOLIO_CODE
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.MATURITY_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.PREMIUM_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.SELL_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.START_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.CPARTY_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.CLIENT_ACCT_USE_ID
XTR_DEALS	XTR_BANK_ACCOUNTS	XTR_DEALS.BUY_ACCOUNT_NO XTR_DEALS.COMPANY_CODE
XTR_DEALS	XTR_BANK_ACCOUNTS	XTR_DEALS.SELL_ACCOUNT_NO XTR_DEALS.COMPANY_CODE
XTR_DEALS	XTR_BANK_ACCOUNTS	XTR_DEALS.MATURITY_ACCOUNT_NO XTR_DEALS.COMPANY_CODE
XTR_DEALS	XTR_BANK_ACCOUNTS	XTR_DEALS.PREMIUM_ACCOUNT_NO XTR_DEALS.COMPANY_CODE
XTR_DEALS	XTR_BANK_ACCOUNTS	XTR_DEALS.SETTLE_ACCOUNT_NO XTR_DEALS.COMPANY_CODE
XTR_DEALS	XTR_BANK_ACCOUNTS	XTR_DEALS.START_ACCOUNT_NO XTR_DEALS.COMPANY_CODE
XTR_ACCRLS_AMORT	XTR_DEALS	XTR_ACCRLS_AMORT.DEAL_NO
XTR_BILL_BOND_ISSUES	XTR_DEALS	XTR_BILL_BOND_ISSUES.DEAL_NUMBER
XTR_CONFIRMATION_DETAILS	XTR_DEALS	XTR_CONFIRMATION_DETAILS.DEAL_NO
XTR_DEAL_DATE_AMOUNTS	XTR_DEALS	XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER
XTR_DEAL_RETRO_TESTS	XTR_DEALS	XTR_DEAL_RETRO_TESTS.DEAL_NUMBER
XTR_LIMIT_EXCESS_LOG	XTR_DEALS	XTR_LIMIT_EXCESS_LOG.DEAL_NUMBER
XTR_PARCEL_SPLITS	XTR_DEALS	XTR_PARCEL_SPLITS.DEAL_NO
XTR_REVALUATION_DETAILS	XTR_DEALS	XTR_REVALUATION_DETAILS.DEAL_NO
XTR_ROLLOVER_TRANSACTIONS	XTR_DEALS	XTR_ROLLOVER_TRANSACTIONS.DEAL_NUMBER