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_CO_GL_TRX

Object Details

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

This table contains all of the transactions posted to a General Ledger account that requires Third Party information. The Third Party Balances program obtains the transaction information from the Journal Import references table if the source is 'Payables','Receivables', or 'Purchasing'. Other transaction information will come from the Journal Entry Lines table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_CO_GL_TRX_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NIT_ID CODE_COMBINATION_ID PERIOD_NAME SET_OF_BOOKS_ID
JL_CO_GL_TRX_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROCESS_ID
JL_CO_GL_TRX_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNT_CODE
JL_CO_GL_TRX_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)	Yes	Sequence Generated ID
PROCESS_ID	NUMBER	(15)	Yes	Concurrent request ID that created this transaction
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	GL Set of Books identifier
CODE_COMBINATION_ID	NUMBER	(15)	Yes	GL Code Combination
NIT_ID	NUMBER	(15)	Yes	ID of associated taxpayer ID
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
PERIOD_YEAR	NUMBER	(15)	Yes	Accounting period year
PERIOD_NUM	NUMBER	(15)	Yes	Accounting period number
JE_BATCH_ID	NUMBER	(15)	Yes	GL batch id
JE_HEADER_ID	NUMBER	(15)	Yes	GL journal entry header ID
JE_LINE_NUM	NUMBER	(15)	Yes	GL journal entry line number
ACCOUNT_CODE	VARCHAR2	(25)	Yes	Natural Account Segment Value
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period
CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency code
CATEGORY	VARCHAR2	(25)	Yes	GL journal entry category
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
ACCOUNTING_DATE	DATE		Yes	GL accounting date
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
SUBLEDGER_DOC_NUMBER	NUMBER			GL Sequential numbering sequence value
DOCUMENT_NUMBER	VARCHAR2	(240)		Transaction source document number (for example, Receivables invoice number, Payables check number)
ACCOUNTED_DR	NUMBER			Debit amount in functional currency
ACCOUNTED_CR	NUMBER			Credit amount in functional currency
ENTERED_DR	NUMBER			Debit amount in transaction currency
ENTERED_CR	NUMBER			Credit amount in transaction currency

Query Text

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


SELECT TRANSACTION_ID
,      PROCESS_ID
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      NIT_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      PERIOD_YEAR
,      PERIOD_NUM
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      ACCOUNT_CODE
,      PERIOD_NAME
,      CURRENCY_CODE
,      CATEGORY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      ACCOUNTING_DATE
,      LAST_UPDATE_LOGIN
,      SUBLEDGER_DOC_NUMBER
,      DOCUMENT_NUMBER
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ENTERED_DR
,      ENTERED_CR
FROM JL.JL_CO_GL_TRX;

Dependencies

[top of page]

JL.JL_CO_GL_TRX does not reference any database object

JL.JL_CO_GL_TRX is referenced by following:

APPS: JL_CO_GL_TRX