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_TAX_BROKERAGE_RATES

Object Details

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

XTR_TAX_BROKERAGE_RATES contains the rate group and rates that are applied to withholding tax and brokerage amounts. Brokerage firms charge for their services based on a brokerage rate. A rate group defines a brokerage rate to be applied to a minimum and maximum brokerage amount range. A flat rate is applied to withholding tax amounts.
This table corresponds to the Rate Group tabbed region on the Brokerage Schedule and Details window, and the Rate Schedule tabbed region on the Tax Schedule and Details window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
CMF_BROKERAGE_RATE	NUMBER			Not currently used
EFFECTIVE_FROM	DATE		Yes	Effective date
FLAT_AMOUNT	NUMBER			Not currently used
INTEREST_RATE	NUMBER			Interest rate at which a deal or transaction is executed
MAX_AMT	NUMBER			Maximum amount for brokerage fee
MIN_AMT	NUMBER			Minimum amount for brokerage fee
RATE_GROUP	VARCHAR2	(7)	Yes	Rate group code identifying group of tax or brokerage rates
REF_TYPE	VARCHAR2	(1)	Yes	Flag to indicate if the rate is a tax (T) rate or a brokerage (B) rate
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

Query Text

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


SELECT AUDIT_INDICATOR
,      CMF_BROKERAGE_RATE
,      EFFECTIVE_FROM
,      FLAT_AMOUNT
,      INTEREST_RATE
,      MAX_AMT
,      MIN_AMT
,      RATE_GROUP
,      REF_TYPE
,      UPDATED_BY
,      UPDATED_ON
,      CREATED_BY
,      CREATED_ON
FROM XTR.XTR_TAX_BROKERAGE_RATES;

Dependencies

[top of page]

XTR.XTR_TAX_BROKERAGE_RATES does not reference any database object

XTR.XTR_TAX_BROKERAGE_RATES is referenced by following:

APPS: XTR_AU_TAX_BROKERAGE_RATES_T; XTR_TAX_BROKERAGE_RATES