XTR_ACCEPTED_BIDS_V |
|
XTR_ACCEPTOR_CODES_V |
|
XTR_ACCOUNT_DEBIT_AUTHS_V |
|
XTR_ACCOUNT_MANAGERS_V |
|
XTR_ACCRLS_AMORT_V |
|
XTR_ACCRUAL_AMORTISE_SETUP_V |
|
XTR_ADVICE_METHODS_V |
|
XTR_AMOUNT_ACTIONS_V |
|
XTR_AMOUNT_TYPES_V |
|
XTR_AP_OPEN_APLD_TRX_V |
|
XTR_AP_OPEN_TRX_V |
This view is used for Hedge Positions form. |
XTR_AP_ORIG_TRX_V |
The XTR_AP_ORIG_TRX_V view is used in the Current Hedge Items window of the Hedge Relationship - Forecast (XTRINHRF) form when the Source is |
XTR_ARCHIVE_DETAILS_V |
|
XTR_ARCHIVE_ERROR_LOG_V |
|
XTR_ARCHIVE_HISTORY_V |
|
XTR_ARCHIVE_SETUP_V |
|
XTR_AR_OPEN_APLD_TRX_V |
|
XTR_AR_OPEN_TRX_V |
This view is used for Hedge Positions form. |
XTR_AR_ORIG_TRX_V |
The XTR_AR_ORIG_TRX_V view is used in the Current Hedge Items window of the Hedge Relationship - Forecast (XTRINHRF) form when the Source is |
XTR_AUDIT_COLUMNS_V |
|
XTR_AUDIT_GROUPS_V |
|
XTR_AUDIT_MODULE_ACCESS_V |
|
XTR_AUDIT_SUMMARY_V |
|
XTR_AUTH_CCY_COMBINATIONS_V |
|
XTR_AUTH_DEAL_SUBTYPES_V |
|
XTR_AUTH_PRODUCT_TYPES_V |
|
XTR_AUTH_TYPE_SUBTYPE_PROD_V |
|
XTR_AVAILABLE_FOR_RECON_V |
|
XTR_A_ALL_CONTRACTS_V |
|
XTR_A_BANK_ACCOUNTS_V |
|
XTR_A_BANK_BALANCES_V |
|
XTR_A_BANK_SETTLEMENT_CODES_V |
|
XTR_A_BOND_ISSUES_V |
|
XTR_A_BUY_SELL_COMBINATIONS_V |
|
XTR_A_COMPANY_LIMITS_V |
|
XTR_A_COUNTERPARTY_LIMITS_V |
|
XTR_A_DEALER_CODES_V |
|
XTR_A_DEALER_LIMITS_V |
|
XTR_A_DEALS_V |
- Retrofitted |
XTR_A_DEAL_DATE_AMOUNTS_V |
|
XTR_A_DEAL_ORDERS_V |
|
XTR_A_EXPOSURE_TRANSACTIONS_V |
|
XTR_A_EXPOSURE_TYPES_V |
|
XTR_A_FUTURES_FEES_V |
|
XTR_A_FUTURES_MARGIN_DETAILS_V |
|
XTR_A_FUTURES_V |
|
XTR_A_GL_REFERENCES_V |
|
XTR_A_INTERGROUP_TRANSFERS_V |
|
XTR_A_JOURNALS_V |
|
XTR_A_JOURNAL_ENTRY_ACTIONS_V |
|
XTR_A_MASTER_CURRENCIES_V |
|
XTR_A_PARTY_DEFAULTS_V |
|
XTR_A_PARTY_INFO_V |
|
XTR_A_PORTFOLIOS_V |
|
XTR_A_PRODUCT_TYPES_V |
|
XTR_A_PRO_PARAM_V |
|
XTR_A_RATE_SETS_V |
|
XTR_A_REVALUATION_DETAILS_V |
|
XTR_A_REVALUATION_RATES_V |
|
XTR_A_ROLLOVER_TRANSACTIONS_V |
- Retrofitted |
XTR_A_SETTLEMENT_CATEGORIES_V |
|
XTR_A_STANDING_INSTRUCTIONS_V |
|
XTR_A_TAX_BROKERAGE_RATES_V |
|
XTR_A_TAX_BROKERAGE_SETUP_V |
|
XTR_A_TAX_CATEGORIES_V |
|
XTR_BANK_ACCOUNTS_V |
|
XTR_BANK_BALANCES_V |
|
XTR_BANK_BAL_INTERFACE_V |
|
XTR_BANK_SETTLEMENT_CODES_V |
|
XTR_BDO_ELIGIBLE_DEALS_V |
|
XTR_BIDS_RECD_V |
|
XTR_BILL_BOND_ISSUES_V |
|
XTR_BIS_CASHFLOWS_V |
This view shows the cashflows generated by deals with CURRENT status. You can use this view to see the net cashflow and cash book summaries |
XTR_BIS_LIMIT_OVERVIEW_V |
This view shows the limit and utilization amount information for counterparty, sovereign, global, currency, group, and settlement limits. |
XTR_BIS_MIRROR_DDA_LIMIT_ROW_V |
|
XTR_BIS_NET_POSITIONS_V |
|
XTR_BOND_ALLOC_DETAILS_V |
Based on table xtr_bond_alloc_details. |
XTR_BOND_COUPON_DATES_V |
|
XTR_BOND_ELIGIBLE_DEALS_V |
|
XTR_BOND_ISSUES_V |
|
XTR_BROKERAGE_CATEGORIES_V |
|
XTR_BUY_SELL_COMBINATIONS_V |
|
XTR_CALL_DETAILS_V |
Base table view of XTR_CALL_DETAILS table |
XTR_CANCELLED_TRANSACTIONS_V |
|
XTR_CASHFLOWS_V |
Internal Treasury and external cashflows |
XTR_CASH_STATEMENTS_V |
- Retrofitted |
XTR_CASH_TRANSACTIONS_V |
|
XTR_CA_ELIGIBLE_DEALS_V |
|
XTR_CE_DEAL_DATE_AMOUNTS_V |
To find available treasury transactions for reconciliation. |
XTR_COMPANY_ACCT_LOV_V |
View that gives bank account short name,
account number and bank name for company |
XTR_COMPANY_AUTHORITIES_V |
|
XTR_COMPANY_LIMITS_EXCL_FX_V |
|
XTR_COMPANY_LIMITS_V |
|
XTR_COMPANY_PARAMETERS_V |
|
XTR_CONFIRMATION_ACTIONS_V |
|
XTR_CONFIRMATION_DETAILS_V |
|
XTR_CONFIRMATION_SETUP_V |
|
XTR_COST_OF_FUNDS_V |
|
XTR_COUNTERPARTY_LIMITS_V |
|
XTR_COUNTRY_COMPANY_LIMITS_V |
|
XTR_CPARTY_ACCT_LOV_V |
View that gives bank account short name,
account number and bank name for counter party |
XTR_CUM_DIST_CALCS_V |
|
XTR_CURRENCY_CROSS_RATES_V |
|
XTR_DATA_FEED_CODES_V |
|
XTR_DATE_AMOUNT_TYPES_V |
|
XTR_DATE_TYPES_V |
|
XTR_DDA_EXPOSURES_V |
|
XTR_DDE_FEED_LOCKS_V |
|
XTR_DEALER_CODES_V |
|
XTR_DEALER_LIMITS_V |
|
XTR_DEALS_INTERFACE_V |
This view is created in association with the base table Xtr_Deals_Interface. The table is designed to hold as much common deal information |
XTR_DEALS_V |
|
XTR_DEAL_CONFO_TYPES_V |
|
XTR_DEAL_CONTACTS_V |
|
XTR_DEAL_DATE_AMOUNTS_V |
|
XTR_DEAL_LINKING_V |
|
XTR_DEAL_ORDERS_V |
|
XTR_DEAL_OVERWRITE_TYPES_V |
|
XTR_DEAL_STATUSES_V |
|
XTR_DEAL_SUBTYPES_V |
|
XTR_DEAL_TYPES_V |
|
XTR_DEDUCTION_CALCS_V |
|
XTR_DISC_ACCRLS_AMORT_V |
Accruals amounts for deals and transactions, where user access to company information is enforced. |
XTR_DISC_CASHFLOWS_V |
Internal Treasury and external cash flows, where useraccess to company information is enforced. |
XTR_DISC_HEDGE_PRO_TESTS_V |
View definition for the hedge prospective effectiveness test results. |
XTR_DISC_HEDGE_RETRO_TESTS_V |
View definition for the retrospective effectiveness test results and measurement details at the hedge level. |
XTR_DISC_JOURNALS_V |
Detailed journal entry information, where user access to company information is enforced. |
XTR_DISC_LIMIT_OVERVIEW_V |
Limit amount versus limit utilization amounts for all limit areas, where user access to company information is enforced. |
XTR_DISC_NET_POSITIONS_V |
Net Position Information, where user access to company information is enforced. |
XTR_DISC_REVALUATION_DETAILS_V |
Revaluation results of Treasury deals, where user access to company information is enforced. |
XTR_EFT_CREDITS_V |
|
XTR_EFT_DEBITS_V |
|
XTR_ELIGIBLE_HEDGES_V |
View definition for eligible hedges to be included in Revaluations process. |
XTR_EXPOSURE_SUMMARY_V |
|
XTR_EXPOSURE_TRANSACTIONS_V |
|
XTR_EXPOSURE_TYPES_V |
|
XTR_EXTERNAL_IMPORTS_V |
|
XTR_EXT_IMPORT_INTERFACE_V |
|
XTR_FORECAST_PERIODS_V |
Not currently used |
XTR_FRA_ELIGIBLE_DEALS_V |
|
XTR_FUTURES_FEES_V |
|
XTR_FUTURES_MARGIN_DETAILS_V |
|
XTR_FUTURES_V |
|
XTR_FXO_ELIGIBLE_DEALS_V |
|
XTR_FX_ELIGIBLE_DEALS_V |
|
XTR_FX_EXPOSURES_VIEW_V |
|
XTR_FX_MULTIPLE_CONTRACTS_V |
|
XTR_FX_PERIOD_WEIGHTINGS_V |
|
XTR_FX_POSI_V |
|
XTR_FX_ROLL_PRE_DETAILS_V |
|
XTR_FX_ROLL_PRE_ITERATIONS_V |
|
XTR_FX_WHAT_IFS_V |
|
XTR_GAIN_LOSS_DNM_V |
|
XTR_GENERAL_LEDGER_SUMMARY_V |
|
XTR_GL_BY_PARTY_V |
|
XTR_GL_REFERENCES_V |
|
XTR_GROUP_LIMITS_V |
|
XTR_HEDGE_DEAL_TYPES_V |
|
XTR_HEDGE_POLICIES_V |
|
XTR_HEDGE_PRODUCT_TYPES_V |
|
XTR_HOLIDAYS_V |
|
XTR_HOLIDAY_RULES_V |
|
XTR_IG_BANK_ACCOUNTS_V |
No longer used. Intercompany account information |
XTR_IG_ELIGIBLE_DEALS_V |
|
XTR_IG_JOURNAL_STRUCTURES_V |
View for XTR_IG_JOURNAL_STRUCTURES table. |
XTR_IMPORT_TRAILER_DETAILS_V |
|
XTR_IMPORT_TRANSFER_ERRORS_V |
|
XTR_INTEREST_PERIOD_RATES_V |
|
XTR_INTEREST_RATE_AVERAGES_V |
|
XTR_INTEREST_RATE_BANDS_V |
|
XTR_INTEREST_RATE_EXPOSURE_V |
|
XTR_INTEREST_RATE_EXP_PER_V |
|
XTR_INTEREST_RATE_POLICY_V |
|
XTR_INTEREST_RATE_RANGES_V |
|
XTR_INTEREST_TOLERANCES_V |
|
XTR_INTERGROUP_TRANSFERS_V |
|
XTR_INTRADAY_STATEMENTS_V |
view joins the cash management view CE_INTRA_STMT_HDRS_LINES_V with treasury table XTR_BANK_ACCOUNTS and thus provides CE, XTR details |
XTR_INTRA_DAY_LIMITS_V |
|
XTR_IRE_MATURITY_BY_POLICY_V |
|
XTR_IRO_ELIGIBLE_DEALS_V |
|
XTR_IRS_ACTUALS_V |
|
XTR_IRS_ELIGIBLE_DEALS_V |
|
XTR_ITEM_RELEASE_DETAILS_V |
|
XTR_JEA_DUPLICATE_V |
|
XTR_JOURNALS_V |
|
XTR_JOURNAL_COMBINATIONS_V |
All journal entry actions, deal type, and deal subtype combinations |
XTR_JOURNAL_ENTRY_ACTIONS_V |
|
XTR_LAYOUT_M_RESULTS_V |
|
XTR_LAYOUT_RESULTS_V |
|
XTR_LAYOUT_TEMPLATE_LINE_V |
|
XTR_LAYOUT_TEMPLATE_V |
|
XTR_LAYOUT_VALUES_V |
|
XTR_LAYOUT_VIEW_FX_CONFO_V |
|
XTR_LAYOUT_VIEW_V |
|
XTR_LAYOUT_WHERE_CLAUSE_V |
|
XTR_LIMIT_CODES_V |
|
XTR_LIMIT_EXCESS_LOG_DETAILS_V |
|
XTR_LIMIT_EXCESS_LOG_V |
|
XTR_LIMIT_OVERVIEW_V |
XTR_LIMIT_OVERVIEW_V shows a subset of columns from counterparty, sovereign, global, currency, group and settlement limits. |
XTR_LIMIT_TYPES_V |
|
XTR_LIMIT_UTILIZATION_FEE_V |
|
XTR_LINKED_TRANSACTIONS_V |
|
XTR_LOAN_SECURITIES_V |
|
XTR_MARKET_PRICES_V |
|
XTR_MASTER_CURRENCIES_V |
|
XTR_MATURITIES_V |
Cashflows belonging to only those date amount types relevant to the Tresaury maturity reports |
XTR_MIRROR_DDA_LIMIT_ROW_V |
|
XTR_MIRROR_DDA_LIM_ROW_TMP_V |
|
XTR_MOST_EFFICIENT_LIMIT_USE_V |
|
XTR_MTS_RECORDS_HISTORY_V |
|
XTR_MTS_RECORDS_V |
|
XTR_NET_POSITIONS_V |
Current net position information |
XTR_NI_ELIGIBLE_DEALS_V |
Based on table three tables xtr_rollover_transactions, xtr_deals, xtr_company_parameters. |
XTR_ONC_ELIGIBLE_DEALS_V |
|
XTR_ONE_STEP_SETTLE_CODES_V |
|
XTR_PARCEL_SPLITS_V |
|
XTR_PARTIES_HR_V |
|
XTR_PARTIES_V |
General information of Treasury parties, where user access to company information is enforced |
XTR_PARTY_DEFAULTS_V |
|
XTR_PARTY_GROUPS_V |
|
XTR_PARTY_INFO_V |
|
XTR_PAYMENT_INSTRUCTIONS_V |
|
XTR_PAYMENT_SCHEDULE_V |
|
XTR_PAY_REC_RECONCILIATION_V |
|
XTR_PORTFOLIOS_V |
|
XTR_PORTFOLIO_DEAL_AMOUNTS_V |
|
XTR_POSITION_HISTORY_V |
|
XTR_PRICE_MODELS_V |
|
XTR_PRINTED_FILE_DETAILS_V |
|
XTR_PRODUCT_TYPES_V |
|
XTR_PRO_DUAL_V |
|
XTR_PRO_PARAM_V |
|
XTR_PRT_BODY_V |
|
XTR_PRT_HEAD_V |
|
XTR_P_SPLIT_V |
|
XTR_QUICK_INPUT_DEALS_V |
This table is designed to store the tolerance setup for the override feature |
XTR_QUICK_INPUT_QUOTES_V |
|
XTR_RATE_GROUPS_V |
|
XTR_RATE_PREFERENCES_V |
|
XTR_RATE_SETS_V |
|
XTR_RECONCILIATION_HEADERS_V |
|
XTR_RECONCILIATION_MATRIX_V |
|
XTR_RECONCILIATION_PASSES_V |
|
XTR_RECONCILIATION_PROCESS_V |
|
XTR_REVALUATION_DETAILS_SUM_V |
|
XTR_REVALUATION_DETAILS_V |
|
XTR_REVALUATION_MARGINS_V |
|
XTR_REVALUATION_RATES_V |
|
XTR_REVIEW_ALL_CONTRACTS_V |
This view contains full deal information for all instruments with the exception of exposure transactions. Its main purpose is to inquire on |
XTR_REVIEW_CASH_CONSOL_V |
|
XTR_REVIEW_CURRENCIES_V |
|
XTR_REVIEW_JOURNALS_V |
|
XTR_REVIEW_TRANSACTIONS_V |
|
XTR_RM_MD_CRVRATES_V |
All market data points (and their attributes) that help compose market data curves |
XTR_RM_MD_SET_CURVES_V |
All market data curves (and their attributes) that are part of market data sets |
XTR_RM_MD_SHOW_CURVES_V |
Historic rate information for those rates that belong to a market data curve |
XTR_ROLLOVER_TRANSACTIONS_V |
|
XTR_RTMM_ELIGIBLE_DEALS_V |
|
XTR_R_BANK_BALANCES_V |
|
XTR_R_CURRENCY_CROSS_RATES_V |
|
XTR_R_DEALS_V |
- Retrofitted |
XTR_R_DEAL_DATE_AMOUNTS_V |
|
XTR_R_EXPOSURE_TRANSACTIONS_V |
|
XTR_R_INTEREST_PERIOD_RATES_V |
|
XTR_R_ROLLOVER_TRANSACTIONS_V |
- Retrofitted |
XTR_R_SPOT_RATES_V |
|
XTR_SETTLEMENTS_V |
Settlement transactions of Treasury deals |
XTR_SETTLEMENT_CATEGORIES_V |
|
XTR_SETTLEMENT_CONTACTS_V |
|
XTR_SETTLEMENT_LETTERS_V |
|
XTR_SETTLEMENT_SCRIPTS_V |
|
XTR_SETTLE_ROW_UTILISED_V |
|
XTR_SETUP_AUDIT_REQMTS_V |
|
XTR_SOURCE_OF_IMPORTS_V |
|
XTR_SPOT_RATES_V |
|
XTR_STANDING_INSTRUCTIONS_V |
|
XTR_STMT_TXNS_V |
|
XTR_STOCK_CASH_DIVIDENDS_V |
This view is used for Stock input form to view stock cash dividends information. |
XTR_STOCK_ELIGIBLE_DEALS_V |
This view is to collect eligible STOCK deals for Revaluations process |
XTR_SUMMARY_COST_OF_FUNDS_V |
|
XTR_SUMMARY_NET_POSITIONS_V |
|
XTR_SWIFT_EFT_V |
A public view for Treasury payments. |
XTR_SWPTN_ELIGIBLE_DEALS_V |
|
XTR_SYS_LANGUAGES_VL |
|
XTR_TAX_BROKERAGE_DETAILS_V |
Witholding tax and
brokerage fee settlement amount due information |
XTR_TAX_BROKERAGE_RATES_V |
|
XTR_TAX_BROKERAGE_SETUP_V |
|
XTR_TAX_CATEGORIES_V |
|
XTR_TAX_DEDUCTION_CALCS_V |
|
XTR_TEMP_AUDIT_VIEW_V |
|
XTR_TERM_ACTIONS_V |
|
XTR_TERM_ACTION_REQUESTS_V |
|
XTR_TIME_RESTRICTIONS_V |
|
XTR_TMM_ELIGIBLE_DEALS_V |
|
XTR_TMM_SUMMARY_V |
|
XTR_TMP_FX_EXPOSURE_V |
|
XTR_TRANS_VALIDATIONS_V |
This view is used in the Transaction Validation form. |
XTR_TRIAL_BALANCE_V |
|
XTR_TY_SUB_PRD_COMBIN_V |
|
XTR_TY_SUB_PRD_PORT_COMBIN_V |
All authorized deal type, deal subtype, product type, and portfolio combinations |
XTR_VALIDATE_TRANSACTIONS_V |
|
XTR_VIEW_TABLE_NAME_V |
|
XTR_VOUCHER_REFERENCES_V |
|
XTR_WF_USERS_V |
|
XTR_WHATIF_DETAILS_V |
|
XTR_WHATIF_RATES_V |
|
XTR_YIELD_CURVES_V |
|
XTR_YIELD_CURVE_DETAILS_V |
|