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_SUP_TAXES

Object Details

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

This table stores the Supplementary Transaction details of the individual taxes of the items along with the Original Invoice details. Information like the type of transaction CM / DM / Supplementary Invoice , old and new tax amount , old and new functional tax amount are stored.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_SUP_TAXES_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_LINE_NO	NUMBER	(15)	Yes	Indicates the line number of the current tax line.
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Yes	Indicates the customer transaction line identifier of the current tax line. It is sequence generated.
LINK_TO_CUST_TRX_LINE_ID	NUMBER	(15)	Yes	Indicates the customer transaction line identifier of the Line to which this tax line is linked.
SUP_INV_TYPE	VARCHAR2	(3)		Indicates the Supplementary Invoice Type ; Possible values are Supplement CM or Supplement INV.
OLD_TAX_ID	NUMBER	(15)	Yes	Indicates the Old tax Identifier.
OLD_RATE	NUMBER			Indicates the Old Tax rate.
OLD_UOM	VARCHAR2	(3)		Indicated the Old UOM.
OLD_QTY_RATE	NUMBER			Indicates the Old Quantity per rate.
NEW_TAX_ID	NUMBER	(15)		Indicates the New Tax Identifier.
NEW_RATE	NUMBER			Indicates the New Tax Rate.
NEW_UOM	VARCHAR2	(3)		Indicates the New Tax UOM.
NEW_QTY_RATE	NUMBER			Indicates the New Quantity per rate.
MAPPING_ID	NUMBER	(15)		Indicates the mapping identifier.
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.
EXIST_TAX_AMT	NUMBER			Indicates Existing Tax amount in transacting currency.
NEW_TAX_AMT	NUMBER			Indicates New Tax amount in transacting currency.
OLD_BASE_TAX_AMT	NUMBER			Indicates Existing Base Tax amount.
NEW_BASE_TAX_AMT	NUMBER			Indicates New Base Tax amount.
OLD_FUNC_TAX_AMT	NUMBER			Indicates Old Tax amount in functional currency.
NEW_FUNC_TAX_AMT	NUMBER			Indicates Old Tax amount in functional currency.
DIFF_AMT	NUMBER			Indicates the Difference between Old Tax amount and New Tax Amount.
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			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
,      SUP_INV_TYPE
,      OLD_TAX_ID
,      OLD_RATE
,      OLD_UOM
,      OLD_QTY_RATE
,      NEW_TAX_ID
,      NEW_RATE
,      NEW_UOM
,      NEW_QTY_RATE
,      MAPPING_ID
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      EXIST_TAX_AMT
,      NEW_TAX_AMT
,      OLD_BASE_TAX_AMT
,      NEW_BASE_TAX_AMT
,      OLD_FUNC_TAX_AMT
,      NEW_FUNC_TAX_AMT
,      DIFF_AMT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
FROM JA.JAI_AR_SUP_TAXES;

Dependencies

[top of page]

JA.JAI_AR_SUP_TAXES does not reference any database object

JA.JAI_AR_SUP_TAXES is referenced by following:

APPS: JAI_AR_SUP_TAXES