FND Design Data [Home] [Help]

View: XTR_R_ROLLOVER_TRANSACTIONS_V

Product: XTR - Treasury
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.XTR_R_ROLLOVER_TRANSACTIONS_V
View Text

SELECT 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
, 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
, RATE_FIXING_DATE
FROM XTR_R_ROLLOVER_TRANSACTIONS

Columns

Name
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
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
RATE_FIXING_DATE