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: AR.AR_JOURNAL_INTERIM_ALL

Object Details

Object Name:	AR_JOURNAL_INTERIM_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_JOURNAL_INTERIM_ALL
Subobject Name:
Status:	VALID

The AR_JOURNAL_INTERIM_ALL table is a temporary table that stores accounting information for the General Ledger Journal report. Use this report to review the details of the transaction records that were transferred to Oracle General Ledger. General Ledger uses these records to prepare and generate the General Ledger reconciliation reports.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_JOURNAL_INTERIM_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	REFERENCE22 REQUEST_ID
AR_JOURNAL_INTERIM_N2	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	REFERENCE1 REQUEST_ID
AR_JOURNAL_INTERIM_N3	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	REFERENCE29 REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STATUS	VARCHAR2	(50)	Yes	Journal entry status
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	General Ledger Set of Books that is used, only one supported currently
JE_SOURCE_NAME	VARCHAR2	(25)	Yes	Journal entry source
JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	Journal entry category
ACCOUNTING_DATE	DATE		Yes	Date within the accounting period
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
DATE_CREATED	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Balance type, actual, budget, or encumbrance
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ENCUMBRANCE_TYPE_ID	NUMBER			Purchasing encumbrance column
BUDGET_VERSION_ID	NUMBER	(15)		Budget version defining column
CURRENCY_CONVERSION_DATE	DATE			Date of exchange rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(10)		Type of exchange rate
CURRENCY_CONVERSION_RATE	NUMBER			Foreign currency exchange rate
SEGMENT1	VARCHAR2	(25)		Key flexfield segment
SEGMENT2	VARCHAR2	(25)		Key flexfield segment
SEGMENT3	VARCHAR2	(25)		Key flexfield segment
SEGMENT4	VARCHAR2	(25)		Key flexfield segment
SEGMENT5	VARCHAR2	(25)		Key flexfield segment
SEGMENT6	VARCHAR2	(25)		Key flexfield segment
SEGMENT7	VARCHAR2	(25)		Key flexfield segment
SEGMENT8	VARCHAR2	(25)		Key flexfield segment
SEGMENT9	VARCHAR2	(25)		Key flexfield segment
SEGMENT10	VARCHAR2	(25)		Key flexfield segment
SEGMENT11	VARCHAR2	(25)		Key flexfield segment
SEGMENT12	VARCHAR2	(25)		Key flexfield segment
SEGMENT13	VARCHAR2	(25)		Key flexfield segment
SEGMENT14	VARCHAR2	(25)		Key flexfield segment
SEGMENT15	VARCHAR2	(25)		Key flexfield segment
SEGMENT16	VARCHAR2	(25)		Key flexfield segment
SEGMENT17	VARCHAR2	(25)		Key flexfield segment
SEGMENT18	VARCHAR2	(25)		Key flexfield segment
SEGMENT19	VARCHAR2	(25)		Key flexfield segment
SEGMENT20	VARCHAR2	(25)		Key flexfield segment
SEGMENT21	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT22	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT23	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT24	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT25	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT26	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT27	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT28	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT29	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT30	VARCHAR2	(25)		Accounting Flexfield segment column
ENTERED_DR	NUMBER			Transaction debit amount in the entered currency
ENTERED_CR	NUMBER			Transaction credit amount in the entered currency
ACCOUNTED_DR	NUMBER			Transaction debit amount in base currency
ACCOUNTED_CR	NUMBER			Transaction credit amount in base currency
TRANSACTION_DATE	DATE			Date of the transaction
REFERENCE1	VARCHAR2	(100)		Inserted into GL_JE_BATCHES.NAME. Journal Import uses this to distinguish between batches. Derived from REFERENCE1 + JE_SOURCE_NAME + FND_REQUEST_ID + ACTUAL_FLAG.
REFERENCE2	VARCHAR2	(100)		Inserted into GL_JE_BATCHES.DESCRIPTION. If not entered, value for this column is Journal Import JE_SOURCE_NAME FND_REQUEST_ID.
REFERENCE3	VARCHAR2	(100)		Standard reference column
REFERENCE4	VARCHAR2	(100)		Inserted into GL_JE_HEADERS.NAME. Derived from REFERENCE4 + CURRENCY_CODE + JE_CATEGORY_NAME + SET_OF_BOOKS_ID.
REFERENCE5	VARCHAR2	(100)		Inserted into GL_JE_HEADERS.DESCRIPTION. If not entered, value for this column is Journal Import FND_REQUEST_ID.
REFERENCE6	VARCHAR2	(100)		Inserted into GL_JE_HEADERS.EXTERNAL_REFERENCE.
REFERENCE7	VARCHAR2	(100)		Standard reference column
REFERENCE8	VARCHAR2	(100)		Standard reference column
REFERENCE9	VARCHAR2	(100)		Standard reference column
REFERENCE10	VARCHAR2	(100)		Inserted into GL_JE_LINES.DESCRIPTION. If not entered, value for this column is Journal Import created.
REFERENCE11	VARCHAR2	(100)		Standard reference column
REFERENCE12	VARCHAR2	(100)		Standard reference column
REFERENCE13	VARCHAR2	(100)		Standard reference column
REFERENCE14	VARCHAR2	(100)		Standard reference column
REFERENCE15	VARCHAR2	(100)		Standard reference column
REFERENCE16	VARCHAR2	(100)		Standard reference column
REFERENCE17	VARCHAR2	(100)		Standard reference column
REFERENCE18	VARCHAR2	(100)		Standard reference column
REFERENCE19	VARCHAR2	(100)		Standard reference column
REFERENCE20	VARCHAR2	(100)		Standard reference column
REFERENCE21	VARCHAR2	(100)		Corresponds to GL_JE_LINES.REFERENCE1, for General Ledger reporting
REFERENCE22	VARCHAR2	(100)		Corresponds to GL_JE_LINES.REFERENCE2, for General Ledger reporting
REFERENCE23	VARCHAR2	(100)		Corresponds to GL_JE_LINES.REFERENCE3, for General Ledger reporting
REFERENCE24	VARCHAR2	(100)		Corresponds to GL_JE_LINES.REFERENCE4, for General Ledger reporting
REFERENCE25	VARCHAR2	(100)		Corresponds to GL_JE_LINES.REFERENCE5, for General Ledger reporting
REFERENCE26	VARCHAR2	(100)		Receivables uses this column for reporting purposes. After Journal Import process completes, column is no longer used and value is overwritten.
REFERENCE27	VARCHAR2	(100)		Receivables uses this column for reporting purposes. After Journal Import process completes, column is no longer used and value is overwritten.
REFERENCE28	VARCHAR2	(100)		Receivables uses this column for reporting purposes. After Journal Import process completes, column is no longer used and value is overwritten.
REFERENCE29	VARCHAR2	(100)		Receivables uses this column for reporting purposes. After Journal Import process completes, column is no longer used and value is overwritten.
REFERENCE30	VARCHAR2	(100)		Receivables uses this column for reporting purposes. After Journal Import process completes, column is no longer used and value is overwritten.
INTERFACE_RUN_ID	NUMBER	(15)		Identifier for this General Ledger Interface submission
JE_BATCH_ID	NUMBER	(15)		Journal entry batch defining column
PERIOD_NAME	VARCHAR2	(15)		Accounting period
JE_HEADER_ID	NUMBER	(15)		Journal entry header defining column
JE_LINE_NUM	NUMBER	(15)		Journal entry line number
CHART_OF_ACCOUNTS_ID	NUMBER	(15)		Accounting Flexfield structure defining column
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Accounting books base currency
CODE_COMBINATION_ID	NUMBER	(15)		General Ledger code combination account
DATE_CREATED_IN_GL	DATE			Date when batch was created in General Ledger
WARNING_CODE	VARCHAR2	(4)		Not currently used
STATUS_DESCRIPTION	VARCHAR2	(240)		Status description
STAT_AMOUNT	NUMBER			Statistical amount column
ORG_ID	NUMBER	(15)		Organization identifier

Query Text

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


SELECT STATUS
,      SET_OF_BOOKS_ID
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      ACCOUNTING_DATE
,      CURRENCY_CODE
,      DATE_CREATED
,      CREATED_BY
,      ACTUAL_FLAG
,      REQUEST_ID
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      TRANSACTION_DATE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      REFERENCE16
,      REFERENCE17
,      REFERENCE18
,      REFERENCE19
,      REFERENCE20
,      REFERENCE21
,      REFERENCE22
,      REFERENCE23
,      REFERENCE24
,      REFERENCE25
,      REFERENCE26
,      REFERENCE27
,      REFERENCE28
,      REFERENCE29
,      REFERENCE30
,      INTERFACE_RUN_ID
,      JE_BATCH_ID
,      PERIOD_NAME
,      JE_HEADER_ID
,      JE_LINE_NUM
,      CHART_OF_ACCOUNTS_ID
,      FUNCTIONAL_CURRENCY_CODE
,      CODE_COMBINATION_ID
,      DATE_CREATED_IN_GL
,      WARNING_CODE
,      STATUS_DESCRIPTION
,      STAT_AMOUNT
,      ORG_ID
FROM AR.AR_JOURNAL_INTERIM_ALL;

Dependencies

[top of page]

AR.AR_JOURNAL_INTERIM_ALL does not reference any database object

AR.AR_JOURNAL_INTERIM_ALL is referenced by following:

APPS: AR_JOURNAL_INTERIM; AR_JOURNAL_INTERIM_ALL