XTR — Treasury
214 documented tables · 308 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
XTR_DEAL_TYPES |
Deal type information | hub |
XTR_PARTY_INFO |
Created from Entity XTR PARTY by ORACLE on 06-MAY-93 | hub-leaning |
XTR_MASTER_CURRENCIES |
Currency information including its net maximum exposure, quotation basis, and year basis | hub |
XTR_BATCHES |
This table stores the fundamental information for each batch process. | hub |
XTR_DEAL_CONFO_TYPES |
Deal confirmation types used in confirmation letter templates | hub-leaning |
XTR_DEALS |
Information for all financial instrument deals except exposure transactions | satellite-leaning |
XTR_DEALER_CODES |
Treasury users information | hub |
XTR_BROKERAGE_CATEGORIES |
Alpha-numeric reference to financial accounts of Treasury parties. | hub-leaning |
XTR_SETTLEMENT_CATEGORIES |
Settlement categories used for organizing settlement actions | hub-leaning |
XTR_TAX_CATEGORIES |
Tax categories used for grouping the calculation methods and rates | hub-leaning |
XTR_LAYOUT_WHERE_CLAUSE |
SQL select statement and where clause for each template type | hub-leaning |
XTR_MARKET_PRICES |
Current rates for foreign exchange and money market deals | hub-leaning |
XTR_BOND_ISSUES |
Bond issues information | hub-leaning |
XTR_BANK_ACCOUNTS |
Bank account information | hub |
XTR_AMOUNT_TYPES |
Amount type information | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.