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_RG_OTHERS

Object Details

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

This is an extension to existing excise recovery/liability tables to store information by tax type. Created for Education Cess functionality

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_OTHERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RG_OTHER_ID
JAI_CMN_RG_OTHERS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_TYPE SOURCE_REGISTER_ID TAX_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
RG_OTHER_ID	NUMBER	(15)	Yes	RG other unique identifier
SOURCE_TYPE	NUMBER	(9)	Yes	Indicates the table with which the record is linked. Possible value:1(JA_IN_RG23_PART_II), 2(JA_IN_PLA), 3(JA_IN_RG23_D), 4(JA_IN_RECEIPT_CENVAT)
SOURCE_REGISTER	VARCHAR2	(30)		Indicates the register for which transaction happened. Possible values: "RG23A_P2", "RG23C_P2", "PLA", "RG23D", "RECEIPT_CENVAT"
SOURCE_REGISTER_ID	NUMBER	(15)	Yes	Indicates the PK for source_Type and register to which this record can be linked
TAX_TYPE	VARCHAR2	(30)	Yes	Indicates the type of tax
CREDIT	NUMBER			Amount that is recovered
DEBIT	NUMBER			Amount that is setoff against the recovered amount
OPENING_BALANCE	NUMBER			Opening balance for this tax type before record is created
CLOSING_BALANCE	NUMBER			Closing balance for this tax type after record is created
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.

Query Text

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


SELECT RG_OTHER_ID
,      SOURCE_TYPE
,      SOURCE_REGISTER
,      SOURCE_REGISTER_ID
,      TAX_TYPE
,      CREDIT
,      DEBIT
,      OPENING_BALANCE
,      CLOSING_BALANCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_RG_OTHERS;

Dependencies

[top of page]

JA.JAI_CMN_RG_OTHERS does not reference any database object

JA.JAI_CMN_RG_OTHERS is referenced by following:

JA: JAI_CMN_RG_OTHERS#