eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: XTR_BATCHES

Product:	XTR - Treasury
Description:	This table stores the fundamental information for each batch process.
Implementation/DBA Data:	XTR.XTR_BATCHES

Primary Key: XTR_BATCHES_PK

BATCH_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
XTR_BATCHES	XTR_PARTY_INFO	XTR_BATCHES.COMPANY_CODE
XTR_ACCRLS_AMORT	XTR_BATCHES	XTR_ACCRLS_AMORT.BATCH_ID
XTR_BANK_BALANCES	XTR_BATCHES	XTR_BANK_BALANCES.FIRST_BATCH_ID
XTR_BANK_BALANCES	XTR_BATCHES	XTR_BANK_BALANCES.LAST_BATCH_ID
XTR_BATCH_EVENTS	XTR_BATCHES	XTR_BATCH_EVENTS.BATCH_ID
XTR_DEALS	XTR_BATCHES	XTR_DEALS.FIRST_REVAL_BATCH_ID
XTR_DEALS	XTR_BATCHES	XTR_DEALS.LAST_REVAL_BATCH_ID
XTR_DEAL_DATE_AMOUNTS	XTR_BATCHES	XTR_DEAL_DATE_AMOUNTS.BATCH_ID
XTR_DEAL_RETRO_TESTS	XTR_BATCHES	XTR_DEAL_RETRO_TESTS.BATCH_ID
XTR_GAIN_LOSS_DNM	XTR_BATCHES	XTR_GAIN_LOSS_DNM.BATCH_ID
XTR_HEDGE_RETRO_TESTS	XTR_BATCHES	XTR_HEDGE_RETRO_TESTS.BATCH_ID
XTR_INTERGROUP_TRANSFERS	XTR_BATCHES	XTR_INTERGROUP_TRANSFERS.FIRST_BATCH_ID
XTR_INTERGROUP_TRANSFERS	XTR_BATCHES	XTR_INTERGROUP_TRANSFERS.LAST_BATCH_ID
XTR_JOURNALS	XTR_BATCHES	XTR_JOURNALS.BATCH_ID
XTR_RECLASS_DETAILS	XTR_BATCHES	XTR_RECLASS_DETAILS.LAST_REVAL_BATCH_ID
XTR_RECLASS_DETAILS	XTR_BATCHES	XTR_RECLASS_DETAILS.RETRO_BATCH_ID
XTR_REVALUATION_DETAILS	XTR_BATCHES	XTR_REVALUATION_DETAILS.BATCH_ID
XTR_REVALUATION_RATES	XTR_BATCHES	XTR_REVALUATION_RATES.BATCH_ID
XTR_ROLLOVER_TRANSACTIONS	XTR_BATCHES	XTR_ROLLOVER_TRANSACTIONS.FIRST_REVAL_BATCH_ID
XTR_ROLLOVER_TRANSACTIONS	XTR_BATCHES	XTR_ROLLOVER_TRANSACTIONS.LAST_REVAL_BATCH_ID