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_AR_TRX_TAX_CALC_T

Object Details

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

This is a temporary table and is used for tax calculation for the new price as well as the new ass
essable price . This is used with supplementary invoices.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_TRX_TAX_CALC_T_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_LINE_NO	NUMBER	(15)	Yes	Indicates the Sequence number of the current tax line in the invoice line.
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Yes	Customer transaction line identifier of the tax line.
LINK_TO_CUST_TRX_LINE_ID	NUMBER	(15)	Yes	Customer transaction line identifier of the line to which this tax line is attached.
PRECEDENCE_1	NUMBER			Indicates Precedence 1.
PRECEDENCE_2	NUMBER			Indicates Precedence 2.
PRECEDENCE_3	NUMBER			Indicates Precedence 3.
PRECEDENCE_4	NUMBER			Indicates Precedence 4.
PRECEDENCE_5	NUMBER			Indicates Precedence 5.
TAX_ID	NUMBER	(15)	Yes	Indicates the Tax identifier of the current tax.
TAX_RATE	NUMBER			Indicates the Tax Rate of the current tax.
QTY_RATE	NUMBER			Indicates Qty rate for the tax.
UOM	VARCHAR2	(3)		Indicates the Uom of the Current tax line.
TAX_AMOUNT	NUMBER			Indicates the Tax Amount in transacting currency.
INVOICE_CLASS	VARCHAR2	(3)		Indicates the Invoice Class.
FUNC_TAX_AMOUNT	NUMBER			Indicates the Tax Amount in functional currency.
BASE_TAX_AMOUNT	NUMBER			Indicates the amount on the basis of which the tax amount is calculated.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
PRECEDENCE_6	NUMBER			Sixth precedence on which this tax is dependent.
PRECEDENCE_7	NUMBER			Seventh precedence on which this tax is dependent.
PRECEDENCE_8	NUMBER			Eighth precedence on which this tax is dependent.
PRECEDENCE_9	NUMBER			Nineth precedence on which this tax is dependent.
PRECEDENCE_10	NUMBER			Tenth precedence on which this tax is dependent.

Query Text

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


SELECT TAX_LINE_NO
,      CUSTOMER_TRX_LINE_ID
,      LINK_TO_CUST_TRX_LINE_ID
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      TAX_ID
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMOUNT
,      INVOICE_CLASS
,      FUNC_TAX_AMOUNT
,      BASE_TAX_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
FROM JA.JAI_AR_TRX_TAX_CALC_T;

Dependencies

[top of page]

JA.JAI_AR_TRX_TAX_CALC_T does not reference any database object

JA.JAI_AR_TRX_TAX_CALC_T is referenced by following:

JA: JAI_AR_TRX_TAX_CALC_T#