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_DEAL_DATE_AMOUNTS

Product:	XTR - Treasury
Description:	Deal transaction information grouped by date type, amount type, and amount action
Implementation/DBA Data:	XTR.XTR_DEAL_DATE_AMOUNTS

Primary Key: XTR_DEAL_DATE_AMOUNT_PK1

DEAL_DATE_AMOUNT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
XTR_DEAL_DATE_AMOUNTS	XTR_DATE_TYPES	XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE XTR_DEAL_DATE_AMOUNTS.DATE_TYPE
XTR_DEAL_DATE_AMOUNTS	CE_BANK_ACCT_USES_ALL	XTR_DEAL_DATE_AMOUNTS.COMPANY_ACCT_USE_ID
XTR_DEAL_DATE_AMOUNTS	CE_BANK_ACCT_USES_ALL	XTR_DEAL_DATE_AMOUNTS.CPARTY_ACCT_USE_ID
XTR_DEAL_DATE_AMOUNTS	CE_BANK_ACCT_USES_ALL	XTR_DEAL_DATE_AMOUNTS.BENEFECIARY_ACCT_USE_ID
XTR_DEAL_DATE_AMOUNTS	XTR_BANK_ACCOUNTS	XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO XTR_DEAL_DATE_AMOUNTS.CPARTY_CODE
XTR_DEAL_DATE_AMOUNTS	XTR_DEALS	XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER
XTR_DEAL_DATE_AMOUNTS	XTR_ROLLOVER_TRANSACTIONS	XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER
XTR_DEAL_DATE_AMOUNTS	XTR_EXPOSURE_TRANSACTIONS	XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER
XTR_DEAL_DATE_AMOUNTS	XTR_AMOUNT_ACTIONS	XTR_DEAL_DATE_AMOUNTS.DATE_TYPE XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE XTR_DEAL_DATE_AMOUNTS.ACTION_CODE
XTR_DEAL_DATE_AMOUNTS	XTR_INTERGROUP_TRANSFERS	XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER
XTR_DEAL_DATE_AMOUNTS	XTR_AMOUNT_TYPES	XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE
XTR_DEAL_DATE_AMOUNTS	XTR_BATCHES	XTR_DEAL_DATE_AMOUNTS.BATCH_ID