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_SETUP

Object Details

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

XTR_TAX_BROKERAGE_SETUP contains tax and brokerage schedule information. A schedule corresponds to a rate group, payee, deal type, and subtype. Rows with a deduction type of ?B? correspond to a brokerage schedule; rows with a deduction type of ?T? correspond to a tax schedule.
This table corresponds to the Schedule tabbed region on the Brokerage Schedule and Details window, and the Schedule tabbed region on the Tax Schedule and Details window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_TAX_BROKERAGE_SETUP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REFERENCE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
CALC_TYPE	VARCHAR2	(30)	Yes	Amount type on which to calculate tax or brokerage fees
DEDUCTION_TYPE	VARCHAR2	(1)	Yes	Indicates tax (T) reference code or brokerage (B) reference code
DESCRIPTION	VARCHAR2	(30)		Tax or brokerage schedule calculation description
NOMINAL_ANNUAL_TAX_BREAK	NUMBER			Not currently used
PAYEE	VARCHAR2	(7)	Yes	Party to be paid tax or brokerage amount
RATE_GROUP	VARCHAR2	(7)	Yes	Selected rate group assigned to tax or brokerage schedule
REFERENCE_CODE	VARCHAR2	(7)	Yes	Refernece code for tax or brokerage schedule
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
AUTHORISED	VARCHAR2	(1)	Yes	Flag to indicate if the tax or brokerage schedule is authorized for use (Y), or not (N)
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
TAX_ROUNDING_RULE	VARCHAR2	(1)		Not currently used
TAX_ROUNDING_PRECISION	VARCHAR2	(20)		Not currently used
TAX_SETTLE_METHOD	VARCHAR2	(15)		Not currently used

Query Text

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


SELECT AUDIT_INDICATOR
,      CALC_TYPE
,      DEDUCTION_TYPE
,      DESCRIPTION
,      NOMINAL_ANNUAL_TAX_BREAK
,      PAYEE
,      RATE_GROUP
,      REFERENCE_CODE
,      UPDATED_BY
,      UPDATED_ON
,      DEAL_TYPE
,      AUTHORISED
,      CREATED_BY
,      CREATED_ON
,      TAX_ROUNDING_RULE
,      TAX_ROUNDING_PRECISION
,      TAX_SETTLE_METHOD
FROM XTR.XTR_TAX_BROKERAGE_SETUP;

Dependencies

[top of page]

XTR.XTR_TAX_BROKERAGE_SETUP does not reference any database object

XTR.XTR_TAX_BROKERAGE_SETUP is referenced by following:

XTR: XTR_TAX_BROKERAGE_SETUP#