Product: | XTR - Treasury |
---|---|
Description: | Information for all financial instrument deals except exposure transactions |
Implementation/DBA Data: | XTR.XTR_DEALS |
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 |
|
|
|