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.

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

TABLE: XTR.XTR_PARTY_DEFAULTS

Object Details

Object Name:	XTR_PARTY_DEFAULTS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_PARTY_DEFAULTS
Subobject Name:
Status:	VALID

XTR_PARTY_DEFAULTS contains the default settlement actions for short term money deal transactions for a specific counterparty or client. Each row includes a system generated, unique transaction number, the party, deal type, deal subtype, product type, settlement actions (repaid or renegotiated), and the interest frequency for the deal.
This table corresponds to the Default Settlement Actions window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_PARTY_DEFAULT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_CATEGORY BROKERAGE_CATEGORY PARTY_CODE DEAL_TYPE DEAL_SUBTYPE PRODUCT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
AUDIT_DATE_STORED	DATE			Not currently used
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
BROKERAGE_CATEGORY	VARCHAR2	(7)		Counterparty brokerage category
BROKERAGE_REFERENCE	VARCHAR2	(7)		Counterparty brokerage reference
DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)		Code for high level deals
DEFAULT_TYPE	VARCHAR2	(1)		Flag to indicate whether the row contains brokerage details (B), tax details (T), or default settlement actions (S) (Treasury internal use only)
DFLT_INTEREST_ACTION	VARCHAR2	(1)		Default interest action for settlement (P for Repay or R for Renegociate)
DFLT_PRINCIPAL_ACTION	VARCHAR2	(1)		Default pricipal action for settlement (P for Repay or R for Renegotiate)
FREQ_INTEREST_SETTLED	VARCHAR2	(1)		Interest freqency which defines how often interest payments will be settled
INTEREST_SETTLED_BY	VARCHAR2	(1)		Client default settlement action for the interest (A for Account, or D for Direct)
PARTY_CODE	VARCHAR2	(7)		Party code
PRINCIPAL_SETTLED_BY	VARCHAR2	(1)		Client default settlement action for the principal (A for Account or D for Direct)
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
SETTLEMENT_DEFAULT_CATEGORY	VARCHAR2	(7)		Counterparty settlement category
TAX_CATEGORY	VARCHAR2	(7)		Counterparty tax category
TAX_REFERENCE	VARCHAR2	(7)		Counterparty tax reference
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
INCOME_TAX_REFERENCE	VARCHAR2	(7)		Not currently used

Query Text

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


SELECT TRANSACTION_NUMBER
,      AUDIT_DATE_STORED
,      AUDIT_INDICATOR
,      BROKERAGE_CATEGORY
,      BROKERAGE_REFERENCE
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      DEFAULT_TYPE
,      DFLT_INTEREST_ACTION
,      DFLT_PRINCIPAL_ACTION
,      FREQ_INTEREST_SETTLED
,      INTEREST_SETTLED_BY
,      PARTY_CODE
,      PRINCIPAL_SETTLED_BY
,      PRODUCT_TYPE
,      SETTLEMENT_DEFAULT_CATEGORY
,      TAX_CATEGORY
,      TAX_REFERENCE
,      UPDATED_BY
,      UPDATED_ON
,      CREATED_BY
,      CREATED_ON
,      INCOME_TAX_REFERENCE
FROM XTR.XTR_PARTY_DEFAULTS;

Dependencies

[top of page]

XTR.XTR_PARTY_DEFAULTS does not reference any database object

XTR.XTR_PARTY_DEFAULTS is referenced by following:

XTR: XTR_PARTY_DEFAULTS#