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_JOURNAL_ENTRIES

Object Details

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

Records the GL Entries that are made by Localization into GL Interface. Except for Receiving accounting and old accounting functioanlities of other localization modules, GL entries of localization should be recorded into this table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_JOURNAL_ENTRIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOURNAL_ENTRY_ID
JAI_CMN_JOURNAL_ENTRIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID SOURCE_TABLE_NAME SOURCE_TRX_ID TAX_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
REGIME_CODE	VARCHAR2	(30)		Indiacates the Regime to which this record is linked
ORGANIZATION_ID	NUMBER	(15)		Indicates the Organization identifier
SET_OF_BOOKS_ID	NUMBER	(15)		Indicates the Ledger identifier
TAX_TYPE	VARCHAR2	(30)		Indicates the tax type
PERIOD_NAME	VARCHAR2	(15)		Indicates the period to which this transaction is linked
CODE_COMBINATION_ID	NUMBER	(15)		Account to which the General Ledger Entry is made
ACCOUNTED_DR	NUMBER			Amount Debited to General Ledger
ACCOUNTED_CR	NUMBER			Amount Credited to General Ledger
TRANSACTION_DATE	DATE			Date on which the transaction happened
SOURCE	VARCHAR2	(30)		Source Module of the transaction
SOURCE_TABLE_NAME	VARCHAR2	(30)		Table name to which the General Ledger Entry is linked with
SOURCE_TRX_ID	NUMBER	(15)		Key to Source Table in which this entry is made
REFERENCE_NAME	VARCHAR2	(30)		Indicates the Reference to the transaction
REFERENCE_ID	NUMBER	(15)		Indicates the identifier of the reference
CURRENCY_CODE	VARCHAR2	(15)		Indicates the Currency of transaction
CURR_CONV_RATE	NUMBER			Currency Conversion Rate
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.
JOURNAL_ENTRY_ID	NUMBER	(15)	Yes	Journal Entry identifier
REPOSITORY_ID	NUMBER			Repository Identifier

Query Text

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


SELECT REGIME_CODE
,      ORGANIZATION_ID
,      SET_OF_BOOKS_ID
,      TAX_TYPE
,      PERIOD_NAME
,      CODE_COMBINATION_ID
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      TRANSACTION_DATE
,      SOURCE
,      SOURCE_TABLE_NAME
,      SOURCE_TRX_ID
,      REFERENCE_NAME
,      REFERENCE_ID
,      CURRENCY_CODE
,      CURR_CONV_RATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      JOURNAL_ENTRY_ID
,      REPOSITORY_ID
FROM JA.JAI_CMN_JOURNAL_ENTRIES;

Dependencies

[top of page]

JA.JAI_CMN_JOURNAL_ENTRIES does not reference any database object

JA.JAI_CMN_JOURNAL_ENTRIES is referenced by following:

JA: JAI_CMN_JOURNAL_ENTRIES#