DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_ROLLOVER_TRANSACTIONS

Object Details
Object Name: XTR_ROLLOVER_TRANSACTIONS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_ROLLOVER_TRANSACTIONS
Subobject Name:
Status: VALID


XTR_ROLLOVER_TRANSACTIONS contains general information about transactions in bond, interest rate swap, negotiable instrument, short term money, retail term money, and wholesale term money deals. Each deal may consist of one or more transactions.
Each row in this table corresponds to a transaction and contains detailed information about the transaction such as the deal number, deal type, transaction number, transaction amount, interest rate, date, tax, lender, borrower, and brokerage. Only the DEAL_NUMBER, TRANSACTION_NUMBER, and DEAL_TYPE columns are required.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_ROLLOVER_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_NUMBER
ColumnTRANSACTION_NUMBER
XTR_ROLLOVER_TRANSACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_LINKING_CODE
XTR_ROLLOVER_TRANSACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE
ColumnCOMPANY_CODE
ColumnCPARTY_CODE
XTR_ROLLOVER_TRANSACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_CODE
XTR_ROLLOVER_TRANSACTIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANS_CLOSEOUT_NO
XTR_ROLLOVER_TRANSACTIONS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_TYPE
ColumnMATURITY_DATE
XTR_ROLLOVER_TRANSACTIONS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_NUMBER
ColumnSTATUS_CODE
ColumnCPARTY_CODE
ColumnMATURITY_DATE
Columns
Name Datatype Length Mandatory Comments
ACCEPTOR_CODE VARCHAR2 (7)
Acceptor code (party in a discounted securities deal who is responsible for the payment at maturity)
ACCEPTOR_NAME VARCHAR2 (20)
Acceptor name
ACCRUAL_FROM DATE

Not currently used
ACCRUAL_TO DATE

Not currently used
ACCUM_INTEREST NUMBER

Accumulated interest
ACCUM_INTEREST_BF NUMBER

Accumulated interest brought forward
ACCUM_INTEREST_BF_HCE NUMBER

Accumulated interest brought forward in reporting currency equivalent
ACCUM_INTEREST_HCE NUMBER

Accumulated interest in reporting currency equivalent
ACCUM_INT_ACCOUNT_NO VARCHAR2 (20)
Not currently used
ACCUM_INT_ACTION VARCHAR2 (7)
Not currently used
ACCUM_INT_AMOUNT_TYPE VARCHAR2 (7)
Not currently used
ACTION_STATUS VARCHAR2 (20)
Not currently used
ADJUSTED_BALANCE NUMBER

Balance brought forward plus principal adjustment (only applies to retail term money and wholesale money transactions)
ARCHIVE_BY VARCHAR2 (30)
Not currently used
ARCHIVE_DATE DATE

Not currently used
ATTACHMENT_EXISTS VARCHAR2 (1)
Not currently used
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
BALANCE_OUT NUMBER

Balance amount
BALANCE_OUT_BF NUMBER

Balance amount brought forward
BALANCE_OUT_BF_HCE NUMBER

Balance amount brought forward in reporting currency equivalent
BALANCE_OUT_HCE NUMBER

Balance amount in reporting currency equivalent
BAL_OS_ACCOUNT_NO VARCHAR2 (20)
Company account to which settlement funds are settled (only applies to retail term money and wholesale term money transactions)
BKGE_SETTLED_REFERENCE NUMBER

Brokerage settlement reference number (all transactions with the same reference number were settled together in one settle action)
BROKERAGE_AMOUNT NUMBER

Brokerage settlement reference number (all transactions with the same reference number were settled together in one settle action)
BROKERAGE_AMOUNT_HCE NUMBER

Brokerage amount in reporting currency equivalent
BROKERAGE_CODE VARCHAR2 (7)
Brokerage code
BROKERAGE_RATE NUMBER

Rate that a company charges a counterparty or that a counterparty pays to a company for brokered deals
CLIENT_ADVICE VARCHAR2 (1)
Not currently used
CLIENT_CODE VARCHAR2 (7)
Client for which the deal is made
COMMENTS VARCHAR2 (255)
Internal comments
COMPANY_CODE VARCHAR2 (7)
Company code
CPARTY_ADVICE VARCHAR2 (1)
Not currently used
CPARTY_CODE VARCHAR2 (7)
Counterparty code
CREATED_BY VARCHAR2 (30) Yes User who created this record
CREATED_ON DATE
Yes Date this record was created
CROSS_REF_TO_TRANS NUMBER

Transaction number of the transaction (within the same call cash deal) created as part of a renogotiation that caused the closing of this transaction
CURRENCY VARCHAR2 (15) Yes Currency code
DATE_RECEIVED DATE

Maturity date of the transaction (within the same call cash deal) created as part of a renogotiation that caused the closing of this transaction
DEALER_CODE VARCHAR2 (10)
Code for Treasury users
DEAL_DATE DATE

Date the deal is made
DEAL_LINKING_CODE VARCHAR2 (8)
Code to identify the group of linked deals
DEAL_NUMBER NUMBER
Yes Unique number assigned to each deal
DEAL_SUBTYPE VARCHAR2 (7)
Code for deal executions permissible within a deal type
DEAL_TYPE VARCHAR2 (7) Yes Code for high level deals
DRAWER_CODE VARCHAR2 (7)
Drawer code (party in a discounted securities deal who is responsible for paying if the acceptor and endorser defaults on the payment)
DRAWER_NAME VARCHAR2 (20)
Drawer name
DUAL_AUTHORISATION_BY VARCHAR2 (30)
Login name of user who created the deal (only applies if the Treasury system parameter, DUAL_AUTHORISE, is set to Y)
DUAL_AUTHORISATION_ON DATE

Date the user created the deal (only applies if the Treasury system parameter, DUAL_AUTHORISE, is set to Y)
ENDORSER_CODE VARCHAR2 (7)
Endorser code (party in a discounted securities deal who is responsible for paying the negotiable instruments if the acceptor defaults on the payment)
ENDORSER_NAME VARCHAR2 (20)
Endorser name
EXPECTED_BALANCE_BF NUMBER

Expected balance brought forward (retail term money transactions only)
EXPECTED_BALANCE_OUT NUMBER

Expected balance out (retail term money transactions only)
EXTERNAL_COMMENTS VARCHAR2 (255)
External comments
EXTERNAL_CPARTY_NO VARCHAR2 (15)
External reference
FID_TAX NUMBER

Not currently used
FID_TAX_HCE NUMBER

Not currently used
INTEREST NUMBER

Interest amount
INTEREST_FREQ VARCHAR2 (1)
Interest frequency
INTEREST_HCE NUMBER

Interest amount in reporting currency
INTEREST_RATE NUMBER

Agreed upon rate expressed as a percentage per annum
INTEREST_SETTLED NUMBER

Interest settlement
INTEREST_SETTLEMENT_TYPE VARCHAR2 (1)
Settlement type for interest (for example, Settle or Renegotiation)
INTERNAL_TICKET_NO VARCHAR2 (15)
Internal reference
ISSUER_ADVICE VARCHAR2 (1)
Not currently used
LIMIT_CODE VARCHAR2 (7)
Code for user-defined limits imposed on deals and transactions
MATURITY_DATE DATE

Date the deal matures or an action is required
NI_PROFIT_LOSS NUMBER

Profit or loss amount for discounted securities deals
NI_PROFIT_LOSS_HCE NUMBER

Profit or loss amount for discounted securities deals in reporting currency
NI_RENEG_DATE DATE

Renegotiation date for discounted securities deals
NO_OF_DAYS NUMBER

Number of days used to calculate interest
OLD_PRODUCT_TYPE VARCHAR2 (10)
Original product type code for call cash transactions
PARCEL_SPLIT_NO NUMBER

Identifier for the security that you bought, sold or issued in a parcel split for discounted securities deals
PARENT_PARTY VARCHAR2 (7)
Parent party for call cash transactions
PI_AMOUNT_DUE NUMBER

Total amount of principal and interest for retail term money deals
PI_AMOUNT_RECEIVED NUMBER

Total amount of principal and interest received for retail term money deals
PORTFOLIO_CODE VARCHAR2 (7)
Code for grouping deals under a single portfolio
PRINCIPAL_ACCOUNT_NO VARCHAR2 (20)
Bank account number for the principal amount
PRINCIPAL_ACTION VARCHAR2 (7)
Flag to indicate if a principal is increased (INCRSE) or decreased (DECRSE)
PRINCIPAL_ADJUST NUMBER

Principal adjustment amount
PRINCIPAL_ADJUST_HCE NUMBER

Principal adjustment amount in reporting currency equivalent
PRINCIPAL_AMOUNT_TYPE VARCHAR2 (12)
Principal amount type
PRINTED_CPARTY_ADVICE VARCHAR2 (1)
Not currently used
PRINTED_REDEMPTION_YN VARCHAR2 (1)
Not currently used
PRINTED_YN VARCHAR2 (1)
Flag to indicate if the confirmation letter is printed (Y), or not (N)
PRODUCT_TYPE VARCHAR2 (10)
Code for products used in a deal type
QUICK_INPUT VARCHAR2 (1)
Flag to indicate if the deal is generaged from a quick input deal (Y), or not (N)
RATE_EFFECTIVE_CREATED DATE

Date the rate becomes effective for retail term money transactions
RENEG_ONLY_LETTER VARCHAR2 (1)
Not currently used
REPAY_AMOUNT NUMBER

Principal settlement amount for call cash or short term money transactions
REPAY_AMOUNT_HCE NUMBER

Principal settlement amount in reporting currency equivalent
SECURITY_TYPE VARCHAR2 (1)
Flag to indicate if a call cash transaction is secured (S) or unsecured (U)
SETTLEMENT_TYPE VARCHAR2 (1)
Type of principal or interest amount settlement at the time of renegotiation for call cash transactions
SETTLE_DATE DATE

Settlement date
SETTLE_TERM_INTEREST VARCHAR2 (1)
Flag to indicate if the interest amount is calculated for wholesale term money transactions (Y), or not (N)
START_DATE DATE

Transaction start date
STATUS_CODE VARCHAR2 (10)
Code for the execution status of deals and transactions
TAX_AMOUNT NUMBER

Tax amount
TAX_AMOUNT_HCE NUMBER

Tax amount in reporting currency equivalent
TAX_CODE VARCHAR2 (7)
Tax code
TAX_RATE NUMBER

Tax rate
TAX_SETTLED_REFERENCE NUMBER

Reference number of the tax settlement of the transaction
TRANSACTION_NUMBER NUMBER
Yes Unique reference number assigned to a transaction
TRANS_CLOSEOUT_NO NUMBER

Reference number of the short sell transaction matching the discounted securities transaction
UPDATED_BY VARCHAR2 (30)
User who last updated this record
UPDATED_ON DATE

Date this record was last updated
YEAR_BASIS NUMBER

Number of days in a year used in calculations (for example, 360 and 365)
YEAR_CALC_TYPE VARCHAR2 (15)
Day count basis which defines the way in which interest accrues over time
RATE_FIXING_DATE DATE

Date the deal rate changes from fixed to floating
FIRST_REVAL_BATCH_ID NUMBER (15)
Denotes the number of the first revaluation batch that this rollover transaction belongs to.
LAST_REVAL_BATCH_ID NUMBER (15)
The batch id in which the realized gain/loss of the deal/transaction was calculated.
CURRENCY_EXCHANGE_RATE NUMBER

The currency exchange rate used for this rollover transaction.
INITIAL_FAIR_VALUE NUMBER

Stores the calculated initial fair value.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
For Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
ALL_IN_RATE NUMBER

Stores NI deal all-in rate.
AVERAGE_EXCHANGE_RATE NUMBER

Average Exchange rate.
BACK_END_BROKERAGE_AMOUNT NUMBER

'Stores back end brokerage amount.
ORIG_COUPON_AMOUNT NUMBER

Original coupon amount for Bond. This column is not changed even Bond deal has resale.
QUANTITY NUMBER

Not currently used
ORIGINAL_AMOUNT NUMBER

Not currently used
FIRST_TRANSACTION_FLAG VARCHAR2 (1)
Not currently used
PRINCIPAL_TAX_CODE VARCHAR2 (7)
Not currently used
PRINCIPAL_TAX_RATE NUMBER

Not currently used
PRINCIPAL_TAX_AMOUNT NUMBER

Not currently used
PRINCIPAL_TAX_SETTLED_REF NUMBER

Not currently used
PREPAID_INTEREST VARCHAR2 (1)
Identify whether it is a prepaid interest deal
INTEREST_REFUND NUMBER

Refund or prepaid interest
ORG_TRANS_NO NUMBER

The original transaction number for TMM transactions
COUPON_DUE_DATE DATE

Bond coupon due date
PRINCIPAL_ACCT_USE_ID NUMBER (15)
Bank account ID for the principal amount
ACCUM_INT_ACCT_USE_ID NUMBER (15)
Not currently used
BAL_OS_ACCT_USE_ID NUMBER (15)
Company account that settlement funds are settled to for retail term money and wholesale term money transactions
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCEPTOR_CODE
,      ACCEPTOR_NAME
,      ACCRUAL_FROM
,      ACCRUAL_TO
,      ACCUM_INTEREST
,      ACCUM_INTEREST_BF
,      ACCUM_INTEREST_BF_HCE
,      ACCUM_INTEREST_HCE
,      ACCUM_INT_ACCOUNT_NO
,      ACCUM_INT_ACTION
,      ACCUM_INT_AMOUNT_TYPE
,      ACTION_STATUS
,      ADJUSTED_BALANCE
,      ARCHIVE_BY
,      ARCHIVE_DATE
,      ATTACHMENT_EXISTS
,      AUDIT_INDICATOR
,      BALANCE_OUT
,      BALANCE_OUT_BF
,      BALANCE_OUT_BF_HCE
,      BALANCE_OUT_HCE
,      BAL_OS_ACCOUNT_NO
,      BKGE_SETTLED_REFERENCE
,      BROKERAGE_AMOUNT
,      BROKERAGE_AMOUNT_HCE
,      BROKERAGE_CODE
,      BROKERAGE_RATE
,      CLIENT_ADVICE
,      CLIENT_CODE
,      COMMENTS
,      COMPANY_CODE
,      CPARTY_ADVICE
,      CPARTY_CODE
,      CREATED_BY
,      CREATED_ON
,      CROSS_REF_TO_TRANS
,      CURRENCY
,      DATE_RECEIVED
,      DEALER_CODE
,      DEAL_DATE
,      DEAL_LINKING_CODE
,      DEAL_NUMBER
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      DRAWER_CODE
,      DRAWER_NAME
,      DUAL_AUTHORISATION_BY
,      DUAL_AUTHORISATION_ON
,      ENDORSER_CODE
,      ENDORSER_NAME
,      EXPECTED_BALANCE_BF
,      EXPECTED_BALANCE_OUT
,      EXTERNAL_COMMENTS
,      EXTERNAL_CPARTY_NO
,      FID_TAX
,      FID_TAX_HCE
,      INTEREST
,      INTEREST_FREQ
,      INTEREST_HCE
,      INTEREST_RATE
,      INTEREST_SETTLED
,      INTEREST_SETTLEMENT_TYPE
,      INTERNAL_TICKET_NO
,      ISSUER_ADVICE
,      LIMIT_CODE
,      MATURITY_DATE
,      NI_PROFIT_LOSS
,      NI_PROFIT_LOSS_HCE
,      NI_RENEG_DATE
,      NO_OF_DAYS
,      OLD_PRODUCT_TYPE
,      PARCEL_SPLIT_NO
,      PARENT_PARTY
,      PI_AMOUNT_DUE
,      PI_AMOUNT_RECEIVED
,      PORTFOLIO_CODE
,      PRINCIPAL_ACCOUNT_NO
,      PRINCIPAL_ACTION
,      PRINCIPAL_ADJUST
,      PRINCIPAL_ADJUST_HCE
,      PRINCIPAL_AMOUNT_TYPE
,      PRINTED_CPARTY_ADVICE
,      PRINTED_REDEMPTION_YN
,      PRINTED_YN
,      PRODUCT_TYPE
,      QUICK_INPUT
,      RATE_EFFECTIVE_CREATED
,      RENEG_ONLY_LETTER
,      REPAY_AMOUNT
,      REPAY_AMOUNT_HCE
,      SECURITY_TYPE
,      SETTLEMENT_TYPE
,      SETTLE_DATE
,      SETTLE_TERM_INTEREST
,      START_DATE
,      STATUS_CODE
,      TAX_AMOUNT
,      TAX_AMOUNT_HCE
,      TAX_CODE
,      TAX_RATE
,      TAX_SETTLED_REFERENCE
,      TRANSACTION_NUMBER
,      TRANS_CLOSEOUT_NO
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
,      YEAR_CALC_TYPE
,      RATE_FIXING_DATE
,      FIRST_REVAL_BATCH_ID
,      LAST_REVAL_BATCH_ID
,      CURRENCY_EXCHANGE_RATE
,      INITIAL_FAIR_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ALL_IN_RATE
,      AVERAGE_EXCHANGE_RATE
,      BACK_END_BROKERAGE_AMOUNT
,      ORIG_COUPON_AMOUNT
,      QUANTITY
,      ORIGINAL_AMOUNT
,      FIRST_TRANSACTION_FLAG
,      PRINCIPAL_TAX_CODE
,      PRINCIPAL_TAX_RATE
,      PRINCIPAL_TAX_AMOUNT
,      PRINCIPAL_TAX_SETTLED_REF
,      PREPAID_INTEREST
,      INTEREST_REFUND
,      ORG_TRANS_NO
,      COUPON_DUE_DATE
,      PRINCIPAL_ACCT_USE_ID
,      ACCUM_INT_ACCT_USE_ID
,      BAL_OS_ACCT_USE_ID
FROM XTR.XTR_ROLLOVER_TRANSACTIONS;

Dependencies

[top of page]

XTR.XTR_ROLLOVER_TRANSACTIONS does not reference any database object

XTR.XTR_ROLLOVER_TRANSACTIONS is referenced by following:

SchemaAPPS
TriggerXTR_AID_ROLLOVER_TRANS_T
TriggerXTR_AU_ROLLOVER_TRANSACTIONS_T
TriggerXTR_BI_ROLLOVER_TRANSACTIONS_T
TriggerXTR_BU_ROLLOVER_TRANSACTIONS_T
SynonymXTR_ROLLOVER_TRANSACTIONS