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_INTERFACE_TAX_LINES_ALL

Object Details

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

This is a tax table to store taxes attached to transactions, and these taxes are populated by the customers program or manual input.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_INTERFACE_TAX_LINES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTERFACE_TAX_LINE_ID
JAI_INTERFACE_TAX_LINES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID PARTY_SITE_ID IMPORT_MODULE TRANSACTION_NUM TRANSACTION_LINE_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_TAX_LINE_ID	NUMBER			Interface Tax Line ID
INTERFACE_LINE_ID	NUMBER			Interface Line ID
PARTY_ID	NUMBER		Yes	Party id
PARTY_SITE_ID	NUMBER		Yes	Party site id
IMPORT_MODULE	VARCHAR2	(10)	Yes	AR or AP
TRANSACTION_NUM	VARCHAR2	(240)	Yes	External Transaction Number.
TRANSACTION_LINE_NUM	NUMBER		Yes	External Transaction Line Number.
TAX_LINE_NO	NUMBER	(15)	Yes	Tax Line No.
EXTERNAL_TAX_CODE	VARCHAR2	(150)		Tax code for user entry
QTY_RATE	NUMBER			Quantity rate
PRECEDENCE_1	NUMBER			Tax Precedence 1
PRECEDENCE_2	NUMBER			Tax Precedence 2
PRECEDENCE_3	NUMBER			Tax Precedence 3
PRECEDENCE_4	NUMBER			Tax Precedence 4
PRECEDENCE_5	NUMBER			Tax Precedence 5
PRECEDENCE_6	NUMBER			Tax Precedence 6
PRECEDENCE_7	NUMBER			Tax Precedence 7
PRECEDENCE_8	NUMBER			Tax Precedence 8
PRECEDENCE_9	NUMBER			Tax Precedence 9
PRECEDENCE_10	NUMBER			Tax Precedence 10
TAX_ID	NUMBER	(15)		Tax id in EBS
TAX_RATE	NUMBER			Tax Rate
UOM	VARCHAR2	(3)		Unit of Measure
TAX_AMOUNT	NUMBER			Tax Amount
FUNC_TAX_AMOUNT	NUMBER			Functional tax amount
BASE_TAX_AMOUNT	NUMBER			Base tax amount
INCLUSIVE_TAX_FLAG	VARCHAR2	(1)		Inclusive tax flag
CODE_COMBINATION_ID	NUMBER	(15)		Code combination id
CREATION_DATE	DATE		Yes	Creation date
CREATED_BY	NUMBER		Yes	Created By
LAST_UPDATE_DATE	DATE		Yes	Last update date
LAST_UPDATE_LOGIN	NUMBER		Yes	Last update login
LAST_UPDATED_BY	NUMBER		Yes	Last updated by

Query Text

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


SELECT INTERFACE_TAX_LINE_ID
,      INTERFACE_LINE_ID
,      PARTY_ID
,      PARTY_SITE_ID
,      IMPORT_MODULE
,      TRANSACTION_NUM
,      TRANSACTION_LINE_NUM
,      TAX_LINE_NO
,      EXTERNAL_TAX_CODE
,      QTY_RATE
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      TAX_ID
,      TAX_RATE
,      UOM
,      TAX_AMOUNT
,      FUNC_TAX_AMOUNT
,      BASE_TAX_AMOUNT
,      INCLUSIVE_TAX_FLAG
,      CODE_COMBINATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM JA.JAI_INTERFACE_TAX_LINES_ALL;

Dependencies

[top of page]

JA.JAI_INTERFACE_TAX_LINES_ALL does not reference any database object

JA.JAI_INTERFACE_TAX_LINES_ALL is referenced by following:

JA: JAI_INTERFACE_TAX_LINES_ALL#