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_RCV_JOURNAL_ENTRIES

Object Details

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

Stores journal Entry information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RCV_JOURNAL_ENTRIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOURNAL_ENTRY_ID
JAI_RCV_JOURNAL_ENTRIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
JAI_RCV_JOURNAL_ENTRIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number
TRANSACTION_ID	NUMBER	(15)		Transaction Identifier
CREATION_DATE	DATE		Yes	Standard Who column
TRANSACTION_DATE	DATE			Date Of Transaction
SHIPMENT_LINE_ID	NUMBER	(15)		Shipment Line Identifier
ACCT_TYPE	VARCHAR2	(10)		Account Type
ACCT_NATURE	VARCHAR2	(30)		Account Nature
SOURCE_NAME	VARCHAR2	(25)		Source Name
CATEGORY_NAME	VARCHAR2	(25)		Category Name
CODE_COMBINATION_ID	NUMBER			Code Combination Identifier
ENTERED_DR	NUMBER			Debit entered Amount
ENTERED_CR	NUMBER			Credit Amount
TRANSACTION_TYPE	VARCHAR2	(30)		Transaction_Type
PERIOD_NAME	VARCHAR2	(15)		Period Name
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency Conversion type
CURRENCY_CONVERSION_DATE	DATE			Currency Conversion Date
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate
REFERENCE_NAME	VARCHAR2	(30)		References name
REFERENCE_ID	NUMBER	(15)		Reference Identifier
JOURNAL_ENTRY_ID	NUMBER	(15)	Yes	Journal Entry identifier
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER			Object version number

Query Text

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


SELECT ORGANIZATION_CODE
,      RECEIPT_NUM
,      TRANSACTION_ID
,      CREATION_DATE
,      TRANSACTION_DATE
,      SHIPMENT_LINE_ID
,      ACCT_TYPE
,      ACCT_NATURE
,      SOURCE_NAME
,      CATEGORY_NAME
,      CODE_COMBINATION_ID
,      ENTERED_DR
,      ENTERED_CR
,      TRANSACTION_TYPE
,      PERIOD_NAME
,      CREATED_BY
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      REFERENCE_NAME
,      REFERENCE_ID
,      JOURNAL_ENTRY_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_JOURNAL_ENTRIES;

Dependencies

[top of page]

JA.JAI_RCV_JOURNAL_ENTRIES does not reference any database object

JA.JAI_RCV_JOURNAL_ENTRIES is referenced by following:

JA: JAI_RCV_JOURNAL_ENTRIES#