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: JL.JL_BR_JOURNALS_ALL

Object Details

Object Name:	JL_BR_JOURNALS_ALL
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_BR_JOURNALS_ALL
Subobject Name:
Status:	VALID

JL_BR_JOURNALS_ALL stores accounting entries that have been successfully transferred from the subledgers (Oracle Payables/Oracle Receivables) to Oracle General Ledger. Each row corresponds to a single accounting entry line from the subledger. These rows will be automatically populated during the transfer to GL process in both Oracle Payables and Oracle Receivables and the user cannot update these records. The records stored in this table will be the basis for the auxiliary daily book reports and the source of the subledger account balances calculation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_JOURNALS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID CODE_COMBINATION_ID PERSONNEL_ID ACCOUNTING_DATE TRANS_DESCRIPTION TRANS_ID INSTALLMENT PERIOD_SET_NAME PERIOD_NAME TRANS_VALUE_SIGN
JL_BR_JOURNALS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID PERSONNEL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANS_ID	NUMBER	(15)	Yes	Transaction identifier used as a foreign key to identify where the transaction came from. In AP, the content may be INVOICE_ID (for invoices - from AP_INVOICES) or INVOICE_PAYMENT_ID (for payments - from AP_INVOICE_PAYMENTS)
BATCH_ID	NUMBER	(15)		Batch identifier used as a foreign key to identify (when applicable) where the batches came from. In AP, the content may be BATCH_ID (for invoices - from AP_BATCHES) or 0 (zero, for payments).
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Accounting Calendar Name
INSTALLMENT	NUMBER	(15)	Yes	Document installment. In AP, the content may be DISTRIBUTION_LINE_NUMBER (for invoices - from AP_INVOICE_DISTRIBUTIONS ) or PAYMENT_LINE_NUMBER (for payments - from AP_PAYMENT_DISTRIBUTIONS). In AR, it may contain CUST_TRX_LINE_GL_DIST_I.
APPLICATION_ID	NUMBER	(15)	Yes	Application Identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting Books defining column
ORG_ID	NUMBER	(15)		Organization Identifier
PERIOD_NAME	VARCHAR2	(15)	Yes	System generated accounting period name
CODE_COMBINATION_ID	NUMBER	(15)	Yes	AP/AR code combination
PERSONNEL_ID	NUMBER	(15)	Yes	Supplier/Customer identifier
TRANS_CURRENCY_CODE	VARCHAR2	(15)	Yes	Invoice currency code
BATCH_NAME	VARCHAR2	(50)		Journal Entry Batch name
ACCOUNTING_DATE	DATE		Yes	Accounting date of Invoice
TRANS_NUM	VARCHAR2	(50)	Yes	Invoice Number
TRANS_DATE	DATE		Yes	Invoice Date
TRANS_DESCRIPTION	VARCHAR2	(80)	Yes	Transaction Description
TRANS_VALUE_SIGN	VARCHAR2	(1)		(D) Debit/(C) Credit
TRANS_VALUE	NUMBER			Invoice Amount
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
JOURNAL_BALANCE_FLAG	VARCHAR2	(1)		Flag that indicates whether the journal entry has been considered for the subledger balance or not (Y/N)
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT TRANS_ID
,      BATCH_ID
,      PERIOD_SET_NAME
,      INSTALLMENT
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      PERIOD_NAME
,      CODE_COMBINATION_ID
,      PERSONNEL_ID
,      TRANS_CURRENCY_CODE
,      BATCH_NAME
,      ACCOUNTING_DATE
,      TRANS_NUM
,      TRANS_DATE
,      TRANS_DESCRIPTION
,      TRANS_VALUE_SIGN
,      TRANS_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      JOURNAL_BALANCE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM JL.JL_BR_JOURNALS_ALL;

Dependencies

[top of page]

JL.JL_BR_JOURNALS_ALL does not reference any database object

JL.JL_BR_JOURNALS_ALL is referenced by following:

APPS: JL_BR_JOURNALS; JL_BR_JOURNALS_ALL