Monday, 25 January 2016

Oracle Treasury Tables in oracle apps

XTR_A_BANK_ACCOUNTS           

XTR_A_BANK_BALANCES             Created by ORACLE on 17-DEC-93

XTR_A_BANK_SETTLEMENT_CODES     Created on 21-SEP-94

XTR_A_BOND_ISSUES             

XTR_A_BUY_SELL_COMBINATIONS    

XTR_A_COMPANY_LIMITS            

XTR_A_COMPANY_PARAMETERS        This table is used to audit Xtr_Company_Parameters

XTR_A_COUNTERPARTY_LIMITS      

XTR_A_DEAL_DATE_AMOUNTS         

XTR_A_DEAL_ORDERS               Created from Entity XTR DEALS by ORACLE on 28-NOV-94

XTR_A_DEALER_CODES              Created by ORACLE on 06-MAY-95

XTR_A_DEALER_LIMITS             Created by ORACLE on 25-JUL-96

XTR_A_DEALS                     Created from Entity XTR DEAL by ORACLE on 06-MAY-93

XTR_A_EXPOSURE_TRANSACTIONS   


XTR_A_EXPOSURE_TYPES           
XTR_A_FUTURES                   Created from Entity XTR FUTURES by ORACLE on 16-JUN-95

XTR_A_FUTURES_FEES             

XTR_A_FUTURES_MARGIN_DETAILS    

XTR_A_GL_REFERENCES            

XTR_A_INTERGROUP_TRANSFERS      

XTR_A_JOURNAL_ENTRY_ACTIONS    

XTR_A_JOURNALS                 

XTR_A_MASTER_CURRENCIES        

XTR_A_PARTY_DEFAULTS            Created from Entity XTR PARTY by ORACLE

XTR_A_PARTY_INFO                Created from Entity XTR PARTY by ORACLE on 06-MAY-93

XTR_A_PORTFOLIOS               

XTR_A_PRO_PARAM                 Created by ORACLE on 20-FEB-95

XTR_A_PRODUCT_TYPES           

XTR_A_RATE_SETS                 Created on 01-FEB-95

XTR_A_REVALUATION_DETAILS       Created on 01-FEB-95

XTR_A_REVALUATION_RATES         Created on 01-FEB-95

XTR_A_ROLLOVER_TRANSACTIONS  

XTR_A_SETTLEMENT_CATEGORIES     Created on 27-JAN-95

XTR_A_STANDING_INSTRUCTIONS     Created on 27-JAN-95

XTR_A_TAX_BROKERAGE_RATES       Created by ORACLE on 13-MAR-95

XTR_A_TAX_BROKERAGE_SETUP       Created on 27-JAN-95

XTR_A_TAX_CATEGORIES            Created on 27-JAN-95

XTR_ACCEPTED_BIDS               Created by ORACLE on 13-SEP-95

XTR_ACCOUNT_DEBIT_AUTHS             Created by ORACLE on 14-FEB-97

XTR_ACCRLS_AMORT                    Accrual amounts for deal transactions

XTR_ACCRUAL_AMORTISE_SETUP         

XTR_AMOUNT_ACTIONS          Amount action information

XTR_AMOUNT_TYPES            Amount type information

XTR_ARCHIVE_DETAILS         Created by ORACLE on 02-JUN-95

XTR_ARCHIVE_ERROR_LOG       Created by ORACLE on 02-JUN-95

XTR_ARCHIVE_HISTORY         Created by ORACLE on 02-JUN-95

XTR_ARCHIVE_SETUP           Created by ORACLE on 02-JUN-95

XTR_AUDIT_COLUMNS           Created by ORACLE on 27-MAY-96

XTR_AUDIT_GROUPS     

XTR_AUDIT_MODULE_ACCESS             Created by ORACLE on 06-MAR-97

XTR_AUDIT_SUMMARY                 

XTR_AUTH_CCY_COMBINATIONS         

XTR_AUTH_TYPE_SUBTYPE_PROD        

XTR_AVG_RATES_RESULTS     

XTR_BANK_ACCOUNTS                   Bank account information

XTR_BANK_BAL_INTERFACE           

XTR_BANK_BALANCES                   Daily bank balance information

XTR_BATCH_EVENTS                   

XTR_BATCHES                        

XTR_BIDS_RECD                       Created on 23-NOV-94

XTR_BILL_BOND_ISSUES               

XTR_BOND_ALLOC_DETAILS              For realized gain/loss from bond resale

XTR_BOND_COUPON_DATES               Coupon dates for bond issues

XTR_BOND_ISSUES                     Bond issues information

XTR_BROKERAGE_CATEGORIES           

XTR_BUY_SELL_COMBINATIONS            Buy and sell currency combination information

XTR_CALL_DETAILS                    

XTR_CASHPOOL_ATTRIBUTES            

XTR_CFLOW_REQUEST_DETAILS            Update Settlement Accounts Request Details.

XTR_CFLOW_UPDATED_RECORDS          

XTR_COMPANY_AUTHORITIES             User access authorities of companies

XTR_COMPANY_LIMITS                 

XTR_COMPANY_PARAMETERS             

XTR_CONFIRMATION_ACTIONS           

XTR_CONFIRMATION_DETAILS            Confirmation letter details

XTR_CONFIRMATION_SETUP              Created by ORACLE on 06-JUL-96

XTR_COST_OF_FUNDS                  

XTR_COUNTERPARTY_LIMITS            

XTR_COUNTRY_COMPANY_LIMITS         

XTR_CUM_DIST_CALCS                  Created on 03-DEC-93

XTR_CURRENCY_CROSS_RATES           

XTR_DATA_FEED_CODES                 Created by ORACLE on 30-MAY-96

XTR_DATE_AMOUNT_TYPES             

XTR_DATE_TYPES                      Date types information

XTR_DDE_FEED_LOCKS                   Created by ORACLE on 20-NOV-96

XTR_DEAL_CONFO_TYPES               Deal confirmation types used in confirmation letter templates

XTR_DEAL_CONTACTS                  Created on 28-MAR-96

XTR_DEAL_DATE_AMOUNTS           

XTR_DEAL_LINKING     

XTR_DEAL_ORDERS                     Created from Entity XTR DEALS by ORACLE on 28-NOV-94

XTR_DEAL_OVERWRITE_TYPES           

XTR_DEAL_RETRO_TESTS               

XTR_DEAL_STATUSES                   Deal status information

XTR_DEAL_SUBTYPES                   Deal subtype information

XTR_DEAL_TYPES                      Deal type information

XTR_DEALER_CODES                    Treasury users information

XTR_DEALER_LIMITS                   Dealer limits information including limit amounts

XTR_DEALS                         

XTR_DEALS_INTERFACE              

XTR_DEDUCTION_CALCS             

XTR_EXPOSURE_SUMMARY                Created by ORACLE on 21-OCT-96

XTR_EXPOSURE_TRANSACTIONS          

XTR_EXPOSURE_TYPES                  Exposure type information

XTR_EXT_IMPORT_INTERFACE           

XTR_EXTERNAL_CASHFLOWS              Not currently used

XTR_FORECAST_PERIOD_TEMP     

XTR_FORECAST_PERIODS                Not currently used

XTR_FUTURES                         Created from Entity XTR FUTURES by ORACLE on 16-JUN-95

XTR_FUTURES_FEES                   

XTR_FUTURES_MARGIN_DETAILS         

XTR_FX_MULTIPLE_CONTRACTS          

XTR_FX_PERIOD_WEIGHTINGS            Limit weightings information

XTR_FX_ROLL_PRE_DETAILS             Created by ORACLE on 15-SEP-95

XTR_FX_ROLL_PRE_ITERATIONS          Created by ORACLE on 15-SEP-95

XTR_FX_WHAT_IFS                     Created by ORACLE on 01-MAY-97

XTR_GAIN_LOSS_DNM                  

XTR_GENERAL_LEDGER_SUMMARY          Created by ORACLE on 28-JUN-96

XTR_GL_BY_PARTY                     Created by ORACLE on 06-MAY-97


XTR_GL_REFERENCES                 

XTR_GROUP_LIMITS                   

XTR_HEDGE_ATTRIBUTES              

XTR_HEDGE_CRITERIA                 

XTR_HEDGE_ITEMS_TEMP               

XTR_HEDGE_JOURNAL_ACTIONS          

XTR_HEDGE_POLICIES                 

XTR_HEDGE_PRO_TESTS                 Stores the hedge prospective effectiveness test results.

XTR_HEDGE_RELATIONSHIPS             This table stores hedge relationship information

XTR_HEDGE_RETRO_TESTS               Stores hedge level retrospective effectiveness test and measurement details.

XTR_HEDGE_STRATEGIES                This table stores key reporting, or financial disclosure, information that is common to all the
                                    Hedges designated within that Strategy.

XTR_HOLIDAY_RULES                   Holiday rules defined for different currencies

XTR_HOLIDAYS                        Holidays defined for different currencies

XTR_IG_JOURNAL_STRUCTURES          

XTR_IMPORT_TRAILER_DETAILS        

XTR_IMPORT_TRANSFER_ERRORS        

XTR_INTERACCT_TRANSFERS            

XTR_INTEREST_PERIOD_RATES          

XTR_INTEREST_RATE_AVERAGES          Created by ORACLE on 05-DEC-94

XTR_INTEREST_RATE_BANDS             Interest rate band details for different interest rate policies

XTR_INTEREST_RATE_EXP_PER           Created by ORACLE

XTR_INTEREST_RATE_EXPOSURE     

XTR_INTEREST_RATE_POLICY      

XTR_INTEREST_RATE_RANGES       

XTR_INTEREST_TOLERANCES        

XTR_INTERFACE_ERRORS           

XTR_INTERGROUP_TRANSFERS        Intercompany loans or deposits information

XTR_INTRA_DAY_LIMITS            Created by ORACLE on 07-AUG-96

XTR_IRE_MATURITY_BY_POLICY      Created by ORACLE on 12-JUN-97

XTR_IRS_ACTUALS                 Created by ORACLE on 22-MAY-97

XTR_ITEM_RELEASE_DETAILS     

XTR_JEA_DUPLICATE              

XTR_JOURNAL_ENTRY_ACTIONS      

XTR_JOURNALS                    Detailed journal entry information

XTR_LAYOUT_RESULTS            

XTR_LAYOUT_TEMPLATE             Confirmation letter template information

XTR_LAYOUT_TEMPLATE_LINE        Confirmation template lines

XTR_LAYOUT_VALUES               Common variables for the confirmation templates

XTR_LAYOUT_VIEW_FX_CONFO         Created by ORACLE on 6 JUL 96

XTR_LAYOUT_WHERE_CLAUSE    
    
XTR_LIMIT_EXCESS_LOG            Limit exceptions caused by deal transactions

XTR_LIMIT_TYPES                 Information on defined limit types

XTR_LIMIT_UTILIZATION_FEE       Created by ORACLE on 22-OCT-97

XTR_LOAN_SECURITIES             Created by ORACLE on 30 October 1995

XTR_MARKET_DATA_INTERFACE      

XTR_MARKET_PRICES               Current rates for foreign exchange and money market deals

XTR_MASTER_CURRENCIES         

XTR_MIRROR_DDA_LIM_ROW_TMP     Created by ORACLE on 17-JUL-96

XTR_MIRROR_DDA_LIMIT_ROW      

XTR_MTS_RECORDS               

XTR_MTS_RECORDS_HISTORY       

XTR_ONE_STEP_SETTLE_CODES     

XTR_PARCEL_SPLITS               Parcel split detail information for discounted securities deals

XTR_PARTY_DEFAULTS              Counterparty default settlement information

XTR_PARTY_GROUPS                Party group information

XTR_PARTY_INFO                  Created from Entity XTR PARTY by ORACLE on 06-MAY-93

XTR_PAY_REC_RECONCILIATION      Information on successfully transferred bank statements

XTR_PAYMENT_SCHEDULE            Payment schedule information for retail term money deals

XTR_PORTFOLIO_DEAL_AMOUNTS     

XTR_PORTFOLIOS                  Company portfolio information

XTR_POSITION_HISTORY           

XTR_PRICE_MODELS             

XTR_PRINTED_FILE_DETAILS     

XTR_PRO_DUAL                     Used within ORACLE for basing forms on without base tables

XTR_PRO_PARAM                   Treasury system parameter settings

XTR_PRODUCT_TYPES               Product type information

XTR_PRT_BODY                    Created by ORACLE on 07-MAR-96

XTR_PRT_HEAD                    Created by ORACLE on 07-MAR-96

XTR_QUICK_INPUT_DEALS          

XTR_QUICK_INPUT_QUOTES          Created by ORACLE on 28-APR-97

XTR_R_BANK_BALANCES             Created by ORACLE on 17-DEC-93

XTR_R_CURRENCY_CROSS_RATES     

XTR_R_DEAL_DATE_AMOUNTS        

XTR_R_DEALS                     Created from Entity XTR DEAL by ORACLE on 06-MAY-93

XTR_R_EXPOSURE_TRANSACTIONS   

XTR_R_INTEREST_PERIOD_RATES    

XTR_R_ROLLOVER_TRANSACTIONS    

XTR_R_SPOT_RATES               

XTR_RATE_GROUPS                 Created from by ORACLE on 07-JUL-96

XTR_RATE_PREFERENCES            Created by ORACLE on 09-JUL-96

XTR_RATE_SETS                   Interest rates for retail term money deals

XTR_RECLASS_DETAILS             Stores reclassified effective unrealized gain/loss amounts.

XTR_RECONCILIATION_PASSES       Reconciliation criteria for bank statement lines
   
XTR_RECONCILIATION_PROCESS      Reconciliation method definitions

XTR_REG_HEDGE_POLICIES         

XTR_REVALUATION_DETAILS        Revaluation results of Treasury deals

XTR_REVALUATION_MARGINS     

XTR_REVALUATION_RATES         

XTR_REVIEW_CURRENCIES     

XTR_REVIEW_TRANSACTIONS         Created on 08-FEB-95

XTR_RM_MD_CURVE_RATES          

XTR_RM_MD_CURVES                Market data curve attributes

XTR_RM_MD_SET_CURVES           

XTR_RM_MD_SETS                  Market data set attributes

XTR_ROLLOVER_TRANSACTIONS   

XTR_SETTLEMENT_CATEGORIES    

XTR_SETTLEMENT_CONTACTS      Created on 28-MAR-96

XTR_SETTLEMENT_SCRIPTS       Created on 18-FEB-97

XTR_SETTLEMENT_SUMMARY      .

XTR_SETUP_AUDIT_REQMTS      Created on 28-JAN-96

XTR_SOURCE_OF_IMPORTS       Import source information used for reconciliation

XTR_SOURCE_TYPES                                      

XTR_SPOT_RATES              History of foreign exchange rates

XTR_STANDING_INSTRUCTIONS     

XTR_STMT_TXNS     

XTR_STOCK_ALLOC_DETAILS         This table is to store realized gain/loss info for STOCK

XTR_STOCK_CASH_DIVIDENDS        This table is to store the Stock Cash Dividend records

XTR_STOCK_ISSUES                This table is to store the Stock Issues setup.

XTR_SYS_LANGUAGES     

XTR_SYS_LANGUAGES_TL        Created by ORACLE on 16-AUG-96

XTR_TAX_BROKERAGE_RATES    

XTR_TAX_BROKERAGE_SETUP     Tax and brokerage schedule information

XTR_TAX_CATEGORIES          Tax categories used for grouping the calculation methods and rates

XTR_TAX_DEDUCTION_CALCS    

XTR_TEMP_AUDIT_VIEW     

XTR_TERM_ACTIONS            Term adjustments for retail term money deals

XTR_TIME_RESTRICTIONS       Term limits information

XTR_TMP_FX_EXPOSURE         Created by ORACLE on 11-JUN-97

XTR_TRANSACTIONS_INTERFACE    

XTR_VOUCHER_REFERENCES      Created on 02-DEC-94

XTR_WF_USER_ROLES           Treasury Workflow Events

XTR_WHATIF_DETAILS          Created on 02-DEC-94

XTR_WHATIF_RATES            Created on 02-DEC-94

XTR_YIELD_CURVE_DETAILS     Created on 29-OCT-96

XTR_YIELD_CURVES            Created on 29-OCT-96

1 comment:

  1. US Treasury Market Conference I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much.

    ReplyDelete