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: JA.JAI_CMN_DOCUMENT_TAXES

Object Details

Object Name:	JAI_CMN_DOCUMENT_TAXES
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_CMN_DOCUMENT_TAXES
Subobject Name:
Status:	VALID

This table stores the taxes for various India Localization transactions

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_DOCUMENT_TAXES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_TAX_ID
JAI_CMN_DOCUMENT_TAXES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_DOC_ID SOURCE_TABLE_NAME SOURCE_DOC_TYPE
JAI_CMN_DOCUMENT_TAXES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_DOC_LINE_ID SOURCE_TABLE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
DOC_TAX_ID	NUMBER	(15)	Yes	Indicates Unique Identifier for the table
TAX_LINE_NO	NUMBER	(15)	Yes	Indicates Unique line number for each document line.
TAX_ID	NUMBER	(15)	Yes	Indicates tax Identifier for this tax record.
TAX_TYPE	VARCHAR2	(30)	Yes	Indicates Tax type for this tax.
CURRENCY_CODE	VARCHAR2	(15)	Yes	Indicates Currency code of the source documents
TAX_RATE	NUMBER			Indicates Tax rate of the tax.
QTY_RATE	NUMBER			Indicates quantity rate of the tax for tax calculation.
UOM	VARCHAR2	(15)		Indicates Unit of Measure of the source document line
TAX_AMT	NUMBER			Indicates Tax amount in the document currency
FUNC_TAX_AMT	NUMBER			Indicates tax amount in the Set of Books currency
MODVAT_FLAG	VARCHAR2	(1)		Indicates whether the tax is recoverable. This can have 'N' and 'Y' as value
TAX_CATEGORY_ID	NUMBER	(15)		Indicates Tax category based on which taxes are defaulted to the receipt.
SOURCE_DOC_TYPE	VARCHAR2	(40)		Indicates type of source document.
SOURCE_DOC_ID	NUMBER	(15)		Indicates Header identifier of the source document
SOURCE_DOC_LINE_ID	NUMBER	(15)		Indicates Line identifier of the source document which has these taxes
SOURCE_TABLE_NAME	VARCHAR2	(40)		Indicates name of the source table that created these taxes
TAX_MODIFIED_BY	VARCHAR2	(10)		Not currently used
ADHOC_FLAG	VARCHAR2	(1)		Indicates whether the tax is an adhoc type of tax. This can have 'N' and 'Y' as value.
PRECEDENCE_1	NUMBER	(15)		Indicates Tax Precedence 1
PRECEDENCE_2	NUMBER	(15)		Indicates Tax Precedence 2
PRECEDENCE_3	NUMBER	(15)		Indicates Tax Precedence 3
PRECEDENCE_4	NUMBER	(15)		Indicates Tax Precedence 4
PRECEDENCE_5	NUMBER	(15)		Indicates Tax Precedence 5
PRECEDENCE_6	NUMBER	(15)		Indicates Tax Precedence 6
PRECEDENCE_7	NUMBER	(15)		Indicates Tax Precedence 7
PRECEDENCE_8	NUMBER	(15)		Indicates Tax Precedence 8
PRECEDENCE_9	NUMBER	(15)		Indicates Tax Precedence 9
PRECEDENCE_10	NUMBER	(15)		Indicates Tax Precedence 10
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER			Standard Who column
VENDOR_ID	NUMBER	(15)		Supplier Identifier
SOURCE_DOC_PARENT_LINE_NO	NUMBER	(15)		Indicates the item line number of the AP invoice line for which this tax is created

Query Text

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


SELECT DOC_TAX_ID
,      TAX_LINE_NO
,      TAX_ID
,      TAX_TYPE
,      CURRENCY_CODE
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMT
,      FUNC_TAX_AMT
,      MODVAT_FLAG
,      TAX_CATEGORY_ID
,      SOURCE_DOC_TYPE
,      SOURCE_DOC_ID
,      SOURCE_DOC_LINE_ID
,      SOURCE_TABLE_NAME
,      TAX_MODIFIED_BY
,      ADHOC_FLAG
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      VENDOR_ID
,      SOURCE_DOC_PARENT_LINE_NO
FROM JA.JAI_CMN_DOCUMENT_TAXES;

Dependencies

[top of page]

JA.JAI_CMN_DOCUMENT_TAXES does not reference any database object

JA.JAI_CMN_DOCUMENT_TAXES is referenced by following:

APPS: JAI_CMN_DOCUMENT_TAXES