[Home] [Help] [Dependency Information]
Object Name: | XTR_A_ROLLOVER_TRANSACTIONS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_A_ROLLOVER_TRANSACTIONS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_A_ROLLOVER_TRANSACTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPDATED_ON |
XTR_A_ROLLOVER_TRANSACTIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DEAL_NUMBER
TRANSACTION_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCEPTOR_CODE | VARCHAR2 | (7) | Acceptor identifier. The counterparty or company accepting the deal. Foreign key to XTR_PARTIES_V. ??? | |
ACCEPTOR_NAME | VARCHAR2 | (20) | Name of the acceptor of the deal. The counterparty or company accepting the deal. ??? | |
ACCRUAL_FROM | DATE | Start date of accrual. | ||
ACCRUAL_TO | DATE | End date of accrual. | ||
ACCUM_INTEREST | NUMBER | Accumulated interest. ??? | ||
ACCUM_INTEREST_BF | NUMBER | Accumulated interest brought forward. ??? | ||
ACCUM_INTEREST_BF_HCE | NUMBER | Accumulated interest brought forward in home currency. ??? | ||
ACCUM_INTEREST_HCE | NUMBER | Accumulated interest in home currency. ??? | ||
ACCUM_INT_ACCOUNT_NO | VARCHAR2 | (20) | Settlement account number for accumulated interest. ??? | |
ACCUM_INT_ACTION | VARCHAR2 | (7) | ||
ACCUM_INT_AMOUNT_TYPE | VARCHAR2 | (7) | ||
ACTION_STATUS | VARCHAR2 | (20) | ||
ADJUSTED_BALANCE | NUMBER | |||
ARCHIVE_BY | VARCHAR2 | (30) | User who archived this record. | |
ARCHIVE_DATE | DATE | Date on which this record is archived. | ||
ATTACHMENT_EXISTS | VARCHAR2 | (1) | Indicates if any document is attached to this record. Valid values are: Y (document attached) or N (no document attached). | |
AUDIT_DATE_STORED | DATE | Date on which this record is audited. | ||
AUDIT_INDICATOR | VARCHAR2 | (1) | ||
BALANCE_OUT | NUMBER | |||
BALANCE_OUT_BF | NUMBER | |||
BALANCE_OUT_BF_HCE | NUMBER | |||
BALANCE_OUT_HCE | NUMBER | |||
BAL_OS_ACCOUNT_NO | VARCHAR2 | (20) | ||
BKGE_SETTLED_REFERENCE | NUMBER | |||
BROKERAGE_AMOUNT | NUMBER | |||
BROKERAGE_AMOUNT_HCE | NUMBER | |||
BROKERAGE_CODE | VARCHAR2 | (7) | ||
BROKERAGE_RATE | NUMBER | |||
CLIENT_ADVICE | VARCHAR2 | (1) | Indicates if confirmation advice letter is required for the client. Valid values are: Y (requried) or N (not requried). | |
CLIENT_CODE | VARCHAR2 | (7) | Client identifier. Foreign key to XTR_PARTIES_V. | |
COMMENTS | VARCHAR2 | (255) | Additional note. | |
COMPANY_CODE | VARCHAR2 | (7) | Company identifier. Foreign key to XTR_PARTIES_V. | |
CPARTY_ADVICE | VARCHAR2 | (1) | ||
CPARTY_CODE | VARCHAR2 | (7) | Counterparty identifier. Foreign key to XTR_PARTIES_V. | |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record. |
CREATED_ON | DATE | Yes | Date on which this record is created. | |
CROSS_REF_TO_TRANS | NUMBER | |||
CURRENCY | VARCHAR2 | (15) | ||
DATE_RECEIVED | DATE | |||
DEALER_CODE | VARCHAR2 | (10) | Dealer identifier. Foreign key to XTR_DEALER_CODES. | |
DEAL_DATE | DATE | |||
DEAL_LINKING_CODE | VARCHAR2 | (8) | ||
DEAL_NUMBER | NUMBER | Yes | Deal identifier. Foreign key to XTR_DEALS. | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES. | |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM. |
DRAWER_CODE | VARCHAR2 | (7) | ||
DRAWER_NAME | VARCHAR2 | (20) | ||
DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | User who dual authorised this record. | |
DUAL_AUTHORISATION_ON | DATE | Date on which this record is dual authorised. | ||
ENDORSER_CODE | VARCHAR2 | (7) | ||
ENDORSER_NAME | VARCHAR2 | (20) | ||
EXPECTED_BALANCE_BF | NUMBER | |||
EXPECTED_BALANCE_OUT | NUMBER | |||
EXTERNAL_COMMENTS | VARCHAR2 | (255) | ||
EXTERNAL_CPARTY_NO | VARCHAR2 | (15) | ||
FID_TAX | NUMBER | |||
FID_TAX_HCE | NUMBER | |||
INTEREST | NUMBER | |||
INTEREST_FREQ | VARCHAR2 | (1) | ||
INTEREST_HCE | NUMBER | |||
INTEREST_RATE | NUMBER | |||
INTEREST_SETTLED | NUMBER | |||
INTEREST_SETTLEMENT_TYPE | VARCHAR2 | (1) | ||
INTERNAL_TICKET_NO | VARCHAR2 | (15) | ||
ISSUER_ADVICE | VARCHAR2 | (1) | ||
LIMIT_CODE | VARCHAR2 | (7) | Limit code identifier. Composite key to XTR_COMPANY_LIMITS. | |
MATURITY_DATE | DATE | |||
NI_PROFIT_LOSS | NUMBER | |||
NI_PROFIT_LOSS_HCE | NUMBER | |||
NI_RENEG_DATE | DATE | |||
NO_OF_DAYS | NUMBER | |||
OLD_PRODUCT_TYPE | VARCHAR2 | (10) | ||
PARCEL_SPLIT_NO | NUMBER | |||
PARENT_PARTY | VARCHAR2 | (7) | ||
PI_AMOUNT_DUE | NUMBER | |||
PI_AMOUNT_RECEIVED | NUMBER | |||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PRINCIPAL_ACCOUNT_NO | VARCHAR2 | (20) | ||
PRINCIPAL_ACTION | VARCHAR2 | (7) | ||
PRINCIPAL_ADJUST_HCE | NUMBER | |||
PRINCIPAL_AMOUNT_TYPE | VARCHAR2 | (12) | ||
PRINTED_CPARTY_ADVICE | VARCHAR2 | (1) | ||
PRINTED_REDEMPTION_YN | VARCHAR2 | (1) | ||
PRINTED_YN | VARCHAR2 | (1) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | Deal product type identifier. Composite key to XTR_PRODUCT_TYPES. | |
QUICK_INPUT | VARCHAR2 | (1) | ||
RATE_EFFECTIVE_CREATED | DATE | |||
RENEG_ONLY_LETTER | VARCHAR2 | (1) | ||
REPAY_AMOUNT | NUMBER | |||
REPAY_AMOUNT_HCE | NUMBER | |||
SECURITY_TYPE | VARCHAR2 | (1) | ||
SETTLEMENT_TYPE | VARCHAR2 | (1) | ||
SETTLE_DATE | DATE | |||
SETTLE_TERM_INTEREST | VARCHAR2 | (1) | ||
START_DATE | DATE | |||
STATUS_CODE | VARCHAR2 | (10) | Deal status. For example, 'CURRENT', 'EXERCISED', 'EXPIRIED'. | |
TAX_AMOUNT | NUMBER | |||
TAX_AMOUNT_HCE | NUMBER | |||
TAX_CODE | VARCHAR2 | (7) | ||
TAX_RATE | NUMBER | |||
TAX_SETTLED_REFERENCE | NUMBER | |||
TRANSACTION_NUMBER | NUMBER | Yes | Rollover transaction identifier. Composite key to XTR_ROLLOVER_TRANSACTIONS. | |
TRANS_CLOSEOUT_NO | NUMBER | |||
UPDATED_BY | VARCHAR2 | (30) | Last updated user. | |
UPDATED_ON | DATE | Last updated date. | ||
YEAR_BASIS | NUMBER | |||
YEAR_CALC_TYPE | VARCHAR2 | (15) | ||
PRINCIPAL_ADJUST | NUMBER | |||
RATE_FIXING_DATE | DATE |
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_DATE_STORED
, 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_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
, PRINCIPAL_ADJUST
, RATE_FIXING_DATE
FROM XTR.XTR_A_ROLLOVER_TRANSACTIONS;
XTR.XTR_A_ROLLOVER_TRANSACTIONS does not reference any database object
XTR.XTR_A_ROLLOVER_TRANSACTIONS is referenced by following:
|
|
|