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_RGM_TRX_REFS

Object Details

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

Stores the tax information of AP and AR invoices for Service Tax

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RGM_TRX_REFS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REFERENCE_ID
JAI_RGM_TRX_REFS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE INVOICE_ID LINE_ID
JAI_RGM_TRX_REFS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE INVOICE_ID ITEM_LINE_ID TAX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REFERENCE_ID	NUMBER	(15)	Yes	RGM transaction reference identifier
ORGANIZATION_ID	NUMBER	(15)		Indicates the Organization reference
SOURCE	VARCHAR2	(30)		Indicates the Source of the record. Possible Values: AP, AR
INVOICE_ID	NUMBER	(15)		Indicates the invoice for which the record is created
LINE_ID	NUMBER	(15)		Indicates the invoice dtl for which the record is created
TAX_TYPE	VARCHAR2	(30)		Tax Type of the Tax
TAX_ID	NUMBER	(15)		Indicates the Tax Reference
TAX_RATE	NUMBER			Tax Rate of the tax
TRX_TAX_AMOUNT	NUMBER			Tax Amount in transaction Currency
TRX_CURRENCY	VARCHAR2	(15)		Currency of the transaction
CURR_CONV_DATE	DATE			Currency Conversion Date
CURR_CONV_RATE	NUMBER			Currency conversion rate
TAX_AMOUNT	NUMBER			Tax amount in functional currency (INR)
RECOVERED_AMOUNT	NUMBER			Amount recovered through Payment/Receipt that has hit regime repository
DISCOUNTED_AMOUNT	NUMBER			Amount discounted on the Payment/Receipt
TAXABLE_BASIS	NUMBER			Tax Base on which the tax amount is calculated
RECOVERABLE_AMOUNT	NUMBER			Amount that is recoverable from the tax
RECOVERABLE_PTG	NUMBER			Percentage of tax that can be recovered from transaction
PARTY_TYPE	VARCHAR2	(2)		Party Type of the transaction. Possible Values: C - Customer, V- Vendor
PARTY_ID	NUMBER	(15)		Indicates the Party reference
PARTY_SITE_ID	NUMBER	(15)		Indicates the Site reference of Party
ITEM_LINE_ID	NUMBER	(15)		Indicates the Invoice Item line to which the transaction is linked
ITEM_ID	NUMBER	(15)		Indicates the Item reference of Item Master
PARENT_REFERENCE_ID	NUMBER	(15)		Indicates the reference_id of this table itself incase this record is a child of another record of this table
REVERSAL_FLAG	VARCHAR2	(1)		Indicates whether the record is a normal or a reversed one
BATCH_ID	NUMBER	(15)		Indicates the Batch reference through which this record is created
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	(9)		Object Version Number.

Query Text

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


SELECT REFERENCE_ID
,      ORGANIZATION_ID
,      SOURCE
,      INVOICE_ID
,      LINE_ID
,      TAX_TYPE
,      TAX_ID
,      TAX_RATE
,      TRX_TAX_AMOUNT
,      TRX_CURRENCY
,      CURR_CONV_DATE
,      CURR_CONV_RATE
,      TAX_AMOUNT
,      RECOVERED_AMOUNT
,      DISCOUNTED_AMOUNT
,      TAXABLE_BASIS
,      RECOVERABLE_AMOUNT
,      RECOVERABLE_PTG
,      PARTY_TYPE
,      PARTY_ID
,      PARTY_SITE_ID
,      ITEM_LINE_ID
,      ITEM_ID
,      PARENT_REFERENCE_ID
,      REVERSAL_FLAG
,      BATCH_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RGM_TRX_REFS;

Dependencies

[top of page]

JA.JAI_RGM_TRX_REFS does not reference any database object

JA.JAI_RGM_TRX_REFS is referenced by following:

APPS: JAI_RGM_TRX_REFS