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_IM_TAX_MAPPING

Object Details

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

This is a mapping table to store the mapping relation between the external customer tax code and system tax code supported in Oracle Financials for India.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_IM_TAX_MAPPING_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MAPPING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MAPPING_ID	NUMBER		Yes	Mapping ID
ORG_ID	NUMBER		Yes	Operating Unit ID
TAXABLE_EVENT	VARCHAR2	(20)	Yes	EXTERNAL or STANDARD
USE_EBS_TAX	VARCHAR2	(1)	Yes	Identifier of using EBS tax Y or N
EXTERNAL_TAX_CODE	VARCHAR2	(150)		External tax code
TAX_ID	NUMBER			Tax id of EBS
INCLUSIVE_FLAG	VARCHAR2	(1)		Indication of inclusive tax flag
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 MAPPING_ID
,      ORG_ID
,      TAXABLE_EVENT
,      USE_EBS_TAX
,      EXTERNAL_TAX_CODE
,      TAX_ID
,      INCLUSIVE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM JA.JAI_IM_TAX_MAPPING;

Dependencies

[top of page]

JA.JAI_IM_TAX_MAPPING does not reference any database object

JA.JAI_IM_TAX_MAPPING is referenced by following:

JA: JAI_IM_TAX_MAPPING#