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


TABLE: XTR.XTR_TAX_CATEGORIES

Object Details
Object Name: XTR_TAX_CATEGORIES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_TAX_CATEGORIES
Subobject Name:
Status: VALID


XTR_TAX_CATEGORIES contains tax category information. Each row corresponds to one tax category and contains a description of that category. Tax categories are used for grouping tax calculation methods and rates. A category can be assigned to many counterparties and is used as a default tax calculation method during deal input.
This table corresponds to the Categories region of the Categories tabbed region of the Tax Schedule and Details window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_TAX_CATEGORIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_CATEGORY
Columns
Name Datatype Length Mandatory Comments
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
DESCRIPTION VARCHAR2 (25) Yes Tax category description
TAX_CATEGORY VARCHAR2 (7) Yes Tax category code
Query Text

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


SELECT AUDIT_INDICATOR
,      DESCRIPTION
,      TAX_CATEGORY
FROM XTR.XTR_TAX_CATEGORIES;

Dependencies

[top of page]

XTR.XTR_TAX_CATEGORIES does not reference any database object

XTR.XTR_TAX_CATEGORIES is referenced by following:

SchemaXTR
ViewXTR_TAX_CATEGORIES#