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_RECORDS

Object Details

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

This is the repository to store recovery and liabilities arising out of localization taxes that belong to different regimes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RGM_TRX_RECORDS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPOSITORY_ID
JAI_RGM_TRX_RECORDS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE SOURCE_TRX_TYPE ORGANIZATION_ID LOCATION_ID TAX_TYPE SOURCE_TABLE_NAME SOURCE_DOCUMENT_ID REFERENCE_ID SERVICE_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
REPOSITORY_ID	NUMBER	(15)	Yes	RGM transaction unique identifier
REGIME_CODE	VARCHAR2	(30)	Yes	Indicates the Regime to which the record belongs
TAX_TYPE	VARCHAR2	(30)		Indicates the Tax Type
SOURCE	VARCHAR2	(30)		Indicates the Source module of the record
SOURCE_TABLE_NAME	VARCHAR2	(30)		Indicates the Table Name of the Source
SOURCE_DOCUMENT_ID	NUMBER	(15)		Indicates the Identifier of the Source Table
SOURCE_TRX_TYPE	VARCHAR2	(30)		Indicates the transaction type of the source
TRANSACTION_DATE	DATE		Yes	Date on which the transaction is done
TRX_CURRENCY	VARCHAR2	(15)		Currency of the transaction
CURR_CONV_DATE	DATE			Currency Conversion Date of transaction
CURR_CONV_RATE	NUMBER			Currency Conversion Rate of transaction
TRX_DEBIT_AMOUNT	NUMBER			Debit Amount in Transaction Currency
TRX_CREDIT_AMOUNT	NUMBER			Credit Amount in Transaction Currency
DEBIT_AMOUNT	NUMBER			Debit Amount in functional Currency (INR)
CREDIT_AMOUNT	NUMBER			Credit Amount in functional Currency (INR)
SETTLED_AMOUNT	NUMBER			Amount that is settled against this record by paying it to corresponding authorities
SETTLED_FLAG	VARCHAR2	(1)		Indicates the record is settled either setting off with another record or by payment to Authorities
SETTLEMENT_ID	NUMBER	(15)		Indicates the settlement reference through which the record is settled
ORGANIZATION_TYPE	VARCHAR2	(2)		Type of the Organization for which the record is created. Possible Value: OU or IO
ORGANIZATION_ID	NUMBER	(15)		Indicates the Organization reference of transaction
LOCATION_ID	NUMBER	(15)		Indicates the location reference of transaction
ACCOUNT_NAME	VARCHAR2	(30)		Indicates the account name from where the account is fetched from setup
CHARGE_ACCOUNT_ID	NUMBER	(15)		Indiacates the Charge account to which amount is Cr./Dr.
BALANCING_ACCOUNT_ID	NUMBER	(15)		Indicates the Balancing account of the GL Entry for this transaction
INV_ORGANIZATION_ID	NUMBER	(15)		Inventory Organization linked to the transaction
REFERENCE_ID	NUMBER	(15)		Indicates the reference key to the record
TAX_RATE	NUMBER			Tax Rate
ASSESSABLE_VALUE	NUMBER			Assessable Value of the items
BATCH_ID	NUMBER	(15)		Indicates the Batch from where the 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
ATTRIBUTE_CONTEXT	VARCHAR2	(80)		Not currently used
ATTRIBUTE1	VARCHAR2	(80)		Not currently used
ATTRIBUTE2	VARCHAR2	(80)		Not currently used
ATTRIBUTE3	VARCHAR2	(80)		Not currently used
ATTRIBUTE4	VARCHAR2	(80)		Not currently used
ATTRIBUTE5	VARCHAR2	(80)		Not currently used
REGIME_PRIMARY_REGNO	VARCHAR2	(240)		Registration Number attached to regime, Orgn. and location of the record
INVOICE_NO	VARCHAR2	(100)		Generated / Supplier issued invoice number corresponding to the regime. eg. VAT Invoice Number
INVOICE_DATE	DATE			Date corresponding to invoice no
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
SERVICE_TYPE_CODE	VARCHAR2	(30)		Indicates the service type in the repository

Query Text

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


SELECT REPOSITORY_ID
,      REGIME_CODE
,      TAX_TYPE
,      SOURCE
,      SOURCE_TABLE_NAME
,      SOURCE_DOCUMENT_ID
,      SOURCE_TRX_TYPE
,      TRANSACTION_DATE
,      TRX_CURRENCY
,      CURR_CONV_DATE
,      CURR_CONV_RATE
,      TRX_DEBIT_AMOUNT
,      TRX_CREDIT_AMOUNT
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
,      SETTLED_AMOUNT
,      SETTLED_FLAG
,      SETTLEMENT_ID
,      ORGANIZATION_TYPE
,      ORGANIZATION_ID
,      LOCATION_ID
,      ACCOUNT_NAME
,      CHARGE_ACCOUNT_ID
,      BALANCING_ACCOUNT_ID
,      INV_ORGANIZATION_ID
,      REFERENCE_ID
,      TAX_RATE
,      ASSESSABLE_VALUE
,      BATCH_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      REGIME_PRIMARY_REGNO
,      INVOICE_NO
,      INVOICE_DATE
,      OBJECT_VERSION_NUMBER
,      SERVICE_TYPE_CODE
FROM JA.JAI_RGM_TRX_RECORDS;

Dependencies

[top of page]

JA.JAI_RGM_TRX_RECORDS does not reference any database object

JA.JAI_RGM_TRX_RECORDS is referenced by following:

APPS: JAI_RGM_TRX_RECORDS