FND Design Data [Home] [Help]

Table: XTR_ROLLOVER_TRANSACTIONS

Product: XTR - Treasury
Description: Information about transactions in bond, interest rate swap, negotiable instrument, short term money, retail term money, and wholesale term money deals
Implementation/DBA Data: TableXTR.XTR_ROLLOVER_TRANSACTIONS
Primary Key: XTR_ROLLOVER_TRANSACTIONS_PK
  1. ColumnDEAL_NUMBER
  2. ColumnTRANSACTION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableXTR_DEALS XTR_ROLLOVER_TRANSACTIONS.DEAL_NUMBER
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableCE_BANK_ACCT_USES_ALL XTR_ROLLOVER_TRANSACTIONS.ACCUM_INT_ACCT_USE_ID
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableCE_BANK_ACCT_USES_ALL XTR_ROLLOVER_TRANSACTIONS.BAL_OS_ACCT_USE_ID
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableXTR_COUNTERPARTY_LIMITS XTR_ROLLOVER_TRANSACTIONS.COMPANY_CODE
XTR_ROLLOVER_TRANSACTIONS.CPARTY_CODE
XTR_ROLLOVER_TRANSACTIONS.LIMIT_CODE
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableXTR_PARCEL_SPLITS XTR_ROLLOVER_TRANSACTIONS.DEAL_NUMBER
XTR_ROLLOVER_TRANSACTIONS.PARCEL_SPLIT_NO
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableXTR_MASTER_CURRENCIES XTR_ROLLOVER_TRANSACTIONS.CURRENCY
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableXTR_BATCHES XTR_ROLLOVER_TRANSACTIONS.FIRST_REVAL_BATCH_ID
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableXTR_BATCHES XTR_ROLLOVER_TRANSACTIONS.LAST_REVAL_BATCH_ID
XTR_ROLLOVER_TRANSACTIONS FK Joins to TableCE_BANK_ACCT_USES_ALL XTR_ROLLOVER_TRANSACTIONS.PRINCIPAL_ACCT_USE_ID
TableXTR_ACCRLS_AMORT FK Joins to XTR_ROLLOVER_TRANSACTIONS XTR_ACCRLS_AMORT.DEAL_NO
XTR_ACCRLS_AMORT.TRANS_NO
TableXTR_CONFIRMATION_DETAILS FK Joins to XTR_ROLLOVER_TRANSACTIONS XTR_CONFIRMATION_DETAILS.DEAL_NO
XTR_CONFIRMATION_DETAILS.TRANSACTION_NO
TableXTR_DEAL_DATE_AMOUNTS FK Joins to XTR_ROLLOVER_TRANSACTIONS XTR_DEAL_DATE_AMOUNTS.DEAL_NUMBER
XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER
TableXTR_LIMIT_EXCESS_LOG FK Joins to XTR_ROLLOVER_TRANSACTIONS XTR_LIMIT_EXCESS_LOG.DEAL_NUMBER
XTR_LIMIT_EXCESS_LOG.TRANSACTION_NUMBER
TableXTR_REVALUATION_DETAILS FK Joins to XTR_ROLLOVER_TRANSACTIONS XTR_REVALUATION_DETAILS.DEAL_NO
XTR_REVALUATION_DETAILS.TRANSACTION_NO