XTR Tables (214)
XTR - Treasury — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
XTR_ACCOUNT_DEBIT_AUTHS |
4 | Created by ORACLE on 14-FEB-97 |
XTR_ACCRLS_AMORT |
32 | Accrual amounts for deal transactions |
XTR_AMOUNT_ACTIONS |
8 | Amount action information |
XTR_AMOUNT_TYPES |
8 | Amount type information |
XTR_ARCHIVE_ERROR_LOG |
6 | Created by ORACLE on 02-JUN-95 |
XTR_ARCHIVE_HISTORY |
8 | Created by ORACLE on 02-JUN-95 |
XTR_ARCHIVE_SETUP |
4 | Created by ORACLE on 02-JUN-95 |
XTR_AUDIT_COLUMNS |
7 | Created by ORACLE on 27-MAY-96 |
XTR_AUDIT_GROUPS |
6 | |
XTR_AUDIT_SUMMARY |
15 | Created from Entity XTR AUDIT_SUMMARY by ORACLE on 06-MAY-95 |
XTR_AUTH_CCY_COMBINATIONS |
11 | Currency combination information including whether a combination is authorised for use |
XTR_AUTH_TYPE_SUBTYPE_PROD |
6 | Created from Entity XTR AUTH TYPE SUBTYPE PROD by ORACLE on 27-JAN-95 |
XTR_AVG_RATES_RESULTS |
19 | |
XTR_A_BANK_ACCOUNTS |
46 | Created from Entity XTR BANK ACCOUNT by ORACLE on 06-MAY-93 |
XTR_A_BANK_BALANCES |
22 | Created by ORACLE on 17-DEC-93 |
XTR_A_BOND_ISSUES |
52 | Created from Entity XTR BOND ISSUE by ORACLE on 06-MAY-93 |
XTR_A_BUY_SELL_COMBINATIONS |
13 | Created from Entity XTR BUY SELL COMBINATION by ORACLE on 27-MAY-93 |
XTR_A_COMPANY_LIMITS |
13 | Created from Entity XTR COMPANY LIMIT by ORACLE on 06-MAY-93 |
XTR_A_COMPANY_PARAMETERS |
11 | This table is used to audit Xtr_Company_Parameters |
XTR_A_COUNTERPARTY_LIMITS |
23 | Created from Entity XTR COUNTERPARTY LIMIT by ORACLE on 06-MAY-93 |
XTR_A_DEALER_CODES |
10 | Created by ORACLE on 06-MAY-95 |
XTR_A_DEALER_LIMITS |
13 | Created by ORACLE on 25-JUL-96 |
XTR_A_DEALS |
218 | Created from Entity XTR DEAL by ORACLE on 06-MAY-93 |
XTR_A_DEAL_DATE_AMOUNTS |
83 | Created from Entity XTR_DEAL_DATE_AMOUNT by ORACLE on 06-MAY-93 |
XTR_A_DEAL_ORDERS |
34 | Created from Entity XTR DEALS by ORACLE on 28-NOV-94 |
XTR_A_EXPOSURE_TRANSACTIONS |
47 | Created from Entity XTR EXPOSURE TRANSACTION by ORACLE on 06-MAY-93 |
XTR_A_EXPOSURE_TYPES |
15 | Created from Entity XTR EXPOSURE TYPE by ORACLE on 06-MAY-93 |
XTR_A_GL_REFERENCES |
8 | Created from Entity XTR GL REFERENCE by ORACLE on 06-MAY-93 |
XTR_A_INTERGROUP_TRANSFERS |
39 | Created from Entity XTR INTERGROUP FUNDING by ORACLE on 13-JUL-94 |
XTR_A_JOURNALS |
30 | Created from Entity XTR JOURNALS by ORACLE on 11-MAY-94 |
XTR_A_JOURNAL_ENTRY_ACTIONS |
21 | Created from Entity XTR JOURNAL ENTRY ACTION by ORACLE on 06-MAY-93 |
XTR_A_MASTER_CURRENCIES |
29 | Created from Entity XTR MASTER CURRENCY by ORACLE on 06-MAY-93 |
XTR_A_PARTY_DEFAULTS |
22 | Created from Entity XTR PARTY by ORACLE on 17-NOV-94 |
XTR_A_PARTY_INFO |
68 | Created from Entity XTR PARTY by ORACLE on 06-MAY-93 |
XTR_A_PORTFOLIOS |
20 | Created from Entity XTR PORTFOLIO by ORACLE on 06-MAY-93 |
XTR_A_PRODUCT_TYPES |
14 | Created from Entity XTR DEAL SUB-TYPE by ORACLE on 26-OCT-94 |
XTR_A_PRO_PARAM |
11 | Created by ORACLE on 20-FEB-95 |
XTR_A_RATE_SETS |
27 | Created on 01-FEB-95 |
XTR_A_REVALUATION_DETAILS |
61 | Created on 01-FEB-95 |
XTR_A_REVALUATION_RATES |
30 | Created on 01-FEB-95 |
XTR_A_ROLLOVER_TRANSACTIONS |
109 | Created from Entity XTR DEAL TRANSACTION by ORACLE on 06-MAY-93 |
XTR_A_SETTLEMENT_CATEGORIES |
4 | Created on 27-JAN-95 |
XTR_A_STANDING_INSTRUCTIONS |
16 | Created on 27-JAN-95 |
XTR_A_TAX_BROKERAGE_RATES |
14 | Created by ORACLE on 13-MAR-95 |
XTR_A_TAX_BROKERAGE_SETUP |
15 | Created on 27-JAN-95 |
XTR_A_TAX_CATEGORIES |
4 | Created on 27-JAN-95 |
XTR_BANK_ACCOUNTS |
79 | Bank account information |
XTR_BANK_BALANCES |
32 | Daily bank balance information |
XTR_BANK_BAL_INTERFACE |
10 | The XTR_BANK_BAL_INTERFACE table contains specific bank account balance information that will be uploaded into Oracle Treasury |
XTR_BATCHES |
13 | This table stores the fundamental information for each batch process. |
XTR_BATCH_EVENTS |
11 | This table will store the information for each event within a parent batch process. |
XTR_BILL_BOND_ISSUES |
12 | Bill and bond issue serial numbers and information about the deals to which they are assigned |
XTR_BOND_ALLOC_DETAILS |
22 | For realized gain/loss from bond resale |
XTR_BOND_COUPON_DATES |
7 | Coupon dates for bond issues |
XTR_BOND_ISSUES |
58 | Bond issues information |
XTR_BROKERAGE_CATEGORIES |
2 | Alpha-numeric reference to financial accounts of Treasury parties. |
XTR_BUY_SELL_COMBINATIONS |
12 | Buy and sell currency combination information |
XTR_CALL_DETAILS |
12 | This table is used for storing call informaion of callable bond issues |
XTR_CASHPOOL_ATTRIBUTES |
22 | This table stores information related to Treasury Cashpool Deal Attributes Setup. |
XTR_CFLOW_REQUEST_DETAILS |
16 | Update Settlement Accounts Request Details. |
XTR_CFLOW_UPDATED_RECORDS |
14 | This table stores details of the records that were updated by the Update Settlement Accounts program. |
XTR_COMPANY_AUTHORITIES |
3 | User access authorities of companies |
XTR_COMPANY_LIMITS |
28 | Company limits information including limit and utilization amounts |
XTR_COMPANY_PARAMETERS |
10 | This table will store transactional parameters specific to each company. |
XTR_CONFIRMATION_ACTIONS |
5 | Deal confirmation action information required for a deal type |
XTR_CONFIRMATION_DETAILS |
27 | Confirmation letter details |
XTR_COST_OF_FUNDS |
26 | Daily summarized amount and average rate information of Treasury deals |
XTR_COUNTERPARTY_LIMITS |
38 | Counterparty limits information including limit and utilization amounts |
XTR_COUNTRY_COMPANY_LIMITS |
10 | Sovereign limits information including limit and utilization amounts |
XTR_CUM_DIST_CALCS |
6 | Created on 03-DEC-93 |
XTR_CURRENCY_CROSS_RATES |
7 | Created from Entity XTR CURRENCY CROSS RATE by ORACLE on 06-MAY-93 |
XTR_DATA_FEED_CODES |
17 | Created by ORACLE on 30-MAY-96 |
XTR_DATE_AMOUNT_TYPES |
7 | Information on date, amount type combinations for deal types |
XTR_DATE_TYPES |
8 | Date types information |
XTR_DEALER_CODES |
9 | Treasury users information |
XTR_DEALER_LIMITS |
12 | Dealer limits information including limit amounts |
XTR_DEALS |
243 | Information for all financial instrument deals except exposure transactions |
XTR_DEALS_INTERFACE |
96 | The XTR_DEALS_INTERFACE table contains deal information that will be imported into Oracle Treasury |
XTR_DEAL_CONFO_TYPES |
4 | Deal confirmation types used in confirmation letter templates |
XTR_DEAL_CONTACTS |
11 | Created on 28-MAR-96 |
XTR_DEAL_DATE_AMOUNTS |
87 | Deal transaction information grouped by date type, amount type, and amount action |
XTR_DEAL_LINKING |
2 | |
XTR_DEAL_ORDERS |
33 | Created from Entity XTR DEALS by ORACLE on 28-NOV-94 |
XTR_DEAL_OVERWRITE_TYPES |
10 | This table will store overwrite types that are allowed for each deal type. |
XTR_DEAL_RETRO_TESTS |
23 | Stores deal level retrospective effectiveness test and measurement details. |
XTR_DEAL_STATUSES |
9 | Deal status information |
XTR_DEAL_SUBTYPES |
12 | Deal subtype information |
XTR_DEAL_TYPES |
13 | Deal type information |
XTR_DEDUCTION_CALCS |
6 | Pre-defined deduction calculation methods for setting up tax and brokerage schedules |
XTR_EXPOSURE_SUMMARY |
33 | Created by ORACLE on 21-OCT-96 |
XTR_EXPOSURE_TRANSACTIONS |
76 | Exposure transactions used for gap analysis of all Treasury cash flows |
XTR_EXPOSURE_TYPES |
14 | Exposure type information |
XTR_EXTERNAL_CASHFLOWS |
7 | Not currently used |
XTR_EXT_IMPORT_INTERFACE |
18 | The XTR_EXT_IMPORT_INTERFACE table contains information about bank statements that will be transferred into Oracle Treasury for reconciliati |
XTR_FORECAST_PERIODS |
11 | Not currently used |
XTR_FORECAST_PERIOD_TEMP |
4 | |
XTR_FUTURES |
41 | Created from Entity XTR FUTURES by ORACLE on 16-JUN-95 |
XTR_FX_MULTIPLE_CONTRACTS |
12 | Created from Entity XTR DEALS by ORACLE on 18-JUL-95 |
XTR_FX_PERIOD_WEIGHTINGS |
5 | Limit weightings information |
XTR_FX_ROLL_PRE_DETAILS |
24 | Created by ORACLE on 15-SEP-95 |
XTR_FX_ROLL_PRE_ITERATIONS |
4 | Created by ORACLE on 15-SEP-95 |
XTR_FX_WHAT_IFS |
8 | Created by ORACLE on 01-MAY-97 |
XTR_GAIN_LOSS_DNM |
17 | This table will store denormalization information for accounting purposes. |
XTR_GL_REFERENCES |
8 | Created from Entity XTR GL REFERENCE by ORACLE on 06-MAY-93 |
XTR_GROUP_LIMITS |
12 | Group limits information including limit and utilization amounts |
XTR_HEDGE_ATTRIBUTES |
52 | This table stores the start and end dates of the hedge, hedge status, and other information such as company, strategy and hedge type. |
XTR_HEDGE_CRITERIA |
14 | The XTR_HEDGE_CRITERIA table stores the find criteria used to select the hedge |
XTR_HEDGE_ITEMS_TEMP |
20 | The XTR_HEDGE_ITEMS_TEMP table is used to generate the Positions - Forecast Hedge Items Fulfillment report. |
XTR_HEDGE_JOURNAL_ACTIONS |
13 | Stores the hedge accounting structure information used to generate journals. |
XTR_HEDGE_POLICIES |
13 | This table stores stores hedge policies as per FAS regulations.The policies define which hedge types can be used by each source. |
XTR_HEDGE_PRO_TESTS |
29 | Stores the hedge prospective effectiveness test results. |
XTR_HEDGE_RELATIONSHIPS |
33 | This table stores hedge relationship information |
XTR_HEDGE_RETRO_TESTS |
47 | Stores hedge level retrospective effectiveness test and measurement details. |
XTR_HEDGE_STRATEGIES |
53 | This table stores key reporting, or financial disclosure, information that is common to all the Hedges designated within that Strategy. |
XTR_HOLIDAYS |
5 | Holidays defined for different currencies |
XTR_HOLIDAY_RULES |
12 | Holiday rules defined for different currencies |
XTR_IG_JOURNAL_STRUCTURES |
13 | This table will store the IG journal structures between a company and its subsidiaries and other Intercompany counterparties. |
XTR_IMPORT_TRAILER_DETAILS |
11 | Summary information of successful bank statement transfers |
XTR_IMPORT_TRANSFER_ERRORS |
10 | Error information associated with a failed bank statement transfer |
XTR_INTERACCT_TRANSFERS |
43 | This table stores information related to Inter-Account Transfers. |
XTR_INTEREST_PERIOD_RATES |
13 | Created from Entity XTR INTEREST PERIOD by ORACLE on 06-MAY-93 |
XTR_INTEREST_RATE_BANDS |
10 | Interest rate band details for different interest rate policies |
XTR_INTEREST_RATE_EXPOSURE |
21 | |
XTR_INTEREST_RATE_EXP_PER |
14 | Created by ORACLE |
XTR_INTEREST_RATE_POLICY |
6 | Interest rate policy for different currencies and investment categories |
XTR_INTEREST_RATE_RANGES |
8 | Interest rate information for your bank accounts, including intercompany funding |
XTR_INTEREST_TOLERANCES |
13 | This table is designed to store the tolerance setup for the override feature. |
XTR_INTERFACE_ERRORS |
10 | This table contains all the errors generated by the transfer from the Xtr_Deals_Interface to the Xtr_Deals table. |
XTR_INTERGROUP_TRANSFERS |
75 | Intercompany loans or deposits information |
XTR_INTRA_DAY_LIMITS |
9 | Created by ORACLE on 07-AUG-96 |
XTR_IRE_MATURITY_BY_POLICY |
24 | Created by ORACLE on 12-JUN-97 |
XTR_IRS_ACTUALS |
50 | Created by ORACLE on 22-MAY-97 |
XTR_JEA_DUPLICATE |
20 | Created from Entity XTR JOURNAL ENTRY ACTION by ORACLE on 06-MAY-93 |
XTR_JOURNALS |
34 | Detailed journal entry information |
XTR_JOURNAL_ENTRY_ACTIONS |
22 | Journal structure information that Treasury uses to create journals |
XTR_LAYOUT_RESULTS |
10 | Created from Entity XTR LAYOUT_RESULTS by ORACLE on 21-MAR-96 |
XTR_LAYOUT_TEMPLATE |
13 | Confirmation letter template information |
XTR_LAYOUT_TEMPLATE_LINE |
13 | Confirmation template lines |
XTR_LAYOUT_VALUES |
9 | Common variables for the confirmation templates |
XTR_LAYOUT_WHERE_CLAUSE |
13 | SQL select statement and where clause for each template type |
XTR_LIMIT_EXCESS_LOG |
18 | Limit exceptions caused by deal transactions |
XTR_LIMIT_TYPES |
7 | Information on defined limit types |
XTR_LIMIT_UTILIZATION_FEE |
7 | Created by ORACLE on 22-OCT-97 |
XTR_LOAN_SECURITIES |
10 | Created by ORACLE on 30 October 1995 |
XTR_MARKET_DATA_INTERFACE |
14 | The XTR_MARKET_DATA_INTERFACE table contains market data that will be transferred into Oracle Treasury |
XTR_MARKET_PRICES |
26 | Current rates for foreign exchange and money market deals |
XTR_MASTER_CURRENCIES |
31 | Currency information including its net maximum exposure, quotation basis, and year basis |
XTR_MIRROR_DDA_LIMIT_ROW |
29 | Cashflow information for all deal transactions with status of CURRENT |
XTR_MIRROR_DDA_LIM_ROW_TMP |
28 | Created by ORACLE on 17-JUL-96 |
XTR_MTS_RECORDS |
5 | Created from Entity XTR MTS RECORDS by ORACLE on 23-JUL-94 |
XTR_MTS_RECORDS_HISTORY |
5 | Created from Entity XTR MTS RECORDS by ORACLE on 23-JUL-94 |
XTR_ONE_STEP_SETTLE_CODES |
9 | This table contains company settlement codes to be used for the one-step settlement method. |
XTR_PARCEL_SPLITS |
19 | Parcel split detail information for discounted securities deals |
XTR_PARTY_DEFAULTS |
23 | Counterparty default settlement information |
XTR_PARTY_GROUPS |
2 | Party group information |
XTR_PARTY_INFO |
69 | Created from Entity XTR PARTY by ORACLE on 06-MAY-93 |
XTR_PAYMENT_SCHEDULE |
26 | Payment schedule information for retail term money deals |
XTR_PAY_REC_RECONCILIATION |
14 | Information on successfully transferred bank statements |
XTR_PORTFOLIOS |
19 | Company portfolio information |
XTR_PORTFOLIO_DEAL_AMOUNTS |
5 | Created from Entity XTR PORTFOLIO DEAL AMOUNT by ORACLE on 06-MAY-93 |
XTR_POSITION_HISTORY |
22 | Archive of daily balances and rates for all current deal transactions |
XTR_PRICE_MODELS |
11 | This table will store valid pricing models seeded by Oracle Treasury as well as those defined by the user. These pricing models will be used |
XTR_PRINTED_FILE_DETAILS |
16 | |
XTR_PRODUCT_TYPES |
17 | Product type information |
XTR_PRO_DUAL |
1 | Used within ORACLE for basing forms on without base tables |
XTR_PRO_PARAM |
11 | Treasury system parameter settings |
XTR_QUICK_INPUT_DEALS |
33 | Information for short term money or foreign exchange deals that was entered in the Quick Deals window |
XTR_QUICK_INPUT_QUOTES |
4 | Created by ORACLE on 28-APR-97 |
XTR_RATE_SETS |
26 | Interest rates for retail term money deals |
XTR_RECLASS_DETAILS |
35 | Stores reclassified effective unrealized gain/loss amounts. |
XTR_RECONCILIATION_PASSES |
4 | Reconciliation criteria for bank statement lines |
XTR_RECONCILIATION_PROCESS |
7 | Reconciliation method definitions |
XTR_REG_HEDGE_POLICIES |
9 | This table stores the defaults to the Instrument/Item Category and Hedge Type combination allowed by FAS 133. |
XTR_REVALUATION_DETAILS |
62 | Revaluation results of Treasury deals |
XTR_REVALUATION_RATES |
29 | Revaluation rates for a particular company in an end-of-period date |
XTR_REVIEW_CURRENCIES |
2 | |
XTR_RM_MD_CURVES |
29 | Market data curve attributes |
XTR_RM_MD_CURVE_RATES |
7 | Market data points of which market data curves are composed |
XTR_RM_MD_SETS |
27 | Market data set attributes |
XTR_RM_MD_SET_CURVES |
9 | The XTR_RM_MD_SET_CURVES table stores information regarding which curves, if any, are part of a market data set. |
XTR_ROLLOVER_TRANSACTIONS |
146 | Information about transactions in bond, interest rate swap, negotiable instrument, short term money, retail term money, and wholesale term m |
XTR_R_BANK_BALANCES |
18 | Created by ORACLE on 17-DEC-93 |
XTR_R_CURRENCY_CROSS_RATES |
7 | Created from Entity XTR CURRENCY CROSS RATE by ORACLE on 06-MAY-93 |
XTR_R_DEALS |
185 | Created from Entity XTR DEAL by ORACLE on 06-MAY-93 |
XTR_R_DEAL_DATE_AMOUNTS |
77 | Created from Entity XTR_DEAL_DATE_AMOUNT by ORACLE on 06-MAY-93 |
XTR_R_EXPOSURE_TRANSACTIONS |
46 | Created from Entity XTR EXPOSURE TRANSACTION by ORACLE on 06-MAY-93 |
XTR_R_INTEREST_PERIOD_RATES |
12 | Created from Entity XTR INTEREST PERIOD by ORACLE on 06-MAY-93 |
XTR_R_ROLLOVER_TRANSACTIONS |
108 | Created from Entity XTR ROLLOVER TRANSACTION by ORACLE on 06-MAY-93 |
XTR_R_SPOT_RATES |
12 | Created from Entity XTR SPOT RATE by ORACLE on 06-MAY-93 |
XTR_SETTLEMENT_CATEGORIES |
2 | Settlement categories used for organizing settlement actions |
XTR_SETTLEMENT_CONTACTS |
16 | Created on 28-MAR-96 |
XTR_SETTLEMENT_SCRIPTS |
15 | Created on 18-FEB-97 |
XTR_SETTLEMENT_SUMMARY |
19 | This table will store all the information associated with authorized settlements in the Treasury system. |
XTR_SETUP_AUDIT_REQMTS |
9 | Created on 28-JAN-96 |
XTR_SOURCE_OF_IMPORTS |
13 | Import source information used for reconciliation |
XTR_SOURCE_TYPES |
11 | This table stores information related to the internal Oracle e-business applications to use for derivative and hedge accounting. |
XTR_SPOT_RATES |
12 | History of foreign exchange rates |
XTR_STANDING_INSTRUCTIONS |
17 | |
XTR_STOCK_ALLOC_DETAILS |
20 | This table is to store realized gain/loss info for STOCK |
XTR_STOCK_CASH_DIVIDENDS |
13 | This table is to store the Stock Cash Dividend records |
XTR_STOCK_ISSUES |
35 | This table is to store the Stock Issues setup. |
XTR_SYS_LANGUAGES |
9 | |
XTR_SYS_LANGUAGES_TL |
11 | Created by ORACLE on 16-AUG-96 |
XTR_TAX_BROKERAGE_RATES |
13 | Rate group and rates applied to witholding tax and brokerage amounts |
XTR_TAX_BROKERAGE_SETUP |
17 | Tax and brokerage schedule information |
XTR_TAX_CATEGORIES |
3 | Tax categories used for grouping the calculation methods and rates |
XTR_TAX_DEDUCTION_CALCS |
13 | Maps tax calculation types to th ecorresponding amount types, calculation basis, calculation types, deal types, deal subtypes, and settlemen |
XTR_TERM_ACTIONS |
20 | Term adjustments for retail term money deals |
XTR_TIME_RESTRICTIONS |
8 | Term limits information |
XTR_TMP_FX_EXPOSURE |
27 | Created by ORACLE on 11-JUN-97 |
XTR_TRANSACTIONS_INTERFACE |
30 | The XTR_TRANSACTIONS_INTERFACE table is a details table to its master XTR_DEALS_INTERFACE table and extends the usage of the XTR_DEALS_INTER |
XTR_VOUCHER_REFERENCES |
4 | Created on 02-DEC-94 |
XTR_WF_USER_ROLES |
18 | Treasury Workflow Events |
XTR_YIELD_CURVE_DETAILS |
11 | Created on 29-OCT-96 |