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: XTR.XTR_JOURNALS

Object Details

Object Name:	XTR_JOURNALS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_JOURNALS
Subobject Name:
Status:	VALID

XTR_JOURNALS contains the detailed journal entries created in Treasury. Journals are adjusted to deals before they are downloaded to General Ledger.
This table corresponds to the Daily Journals window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_JOURNALS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOURNAL_DATE COMPANY_CODE CURRENCY DEAL_NUMBER TRANSACTION_NUMBER SETTLEMENT_NUMBER AMOUNT_TYPE CODE_COMBINATION_ID DEBIT_AMOUNT CREDIT_AMOUNT JNL_REVERSAL_IND
XTR_JOURNALS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
XTR_JOURNALS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY AMOUNT_TYPE
XTR_JOURNALS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEAL_NUMBER TRANSACTION_NUMBER
XTR_JOURNALS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPANY_CODE BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AMOUNT_TYPE	VARCHAR2	(7)		Code that identifies the purpose of the amounts for a deal type
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
CANCELLED_IN_GL	VARCHAR2	(1)		Flag to indicate if a reversing entry was created for the entry due to cancellation of a deal after the journal entry has been transferred to the GL interface table (Y), or not (null)
COMMENTS	VARCHAR2	(255)		Comments
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
CREDIT_AMOUNT	NUMBER			Credit amount
CURRENCY	VARCHAR2	(15)		Currency code
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
DEAL_SUBTYPE	VARCHAR2	(30)		Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)		Code for high level deals
DEBIT_AMOUNT	NUMBER			Debit amount
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Unique key for identifying GL account references
GL_TRANSFER_DATE	DATE			No longer used.
JNL_REVERSAL_IND	VARCHAR2	(1)		Flag to indicate the journal entry has been reversed due to either the cancellation of a deal (C) or the creation of a reversal entry (R)
JOURNAL_DATE	DATE		Yes	Effective date of the journal transaction
PORTFOLIO_CODE	VARCHAR2	(30)	Yes	Code for grouping deals under a single portfolio
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
TRANSFER_TO_EXTERNAL_GL	DATE			Date the journal entry was transferred to the GL interface table (null values indicate that the entry has not been transferred)
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting books defining column
SUSPENSE_GL	VARCHAR2	(1)		Flag to indicate if entry is booked to the company's default suspense account (Y), or not (null)
ACCOUNTED_DR	NUMBER			Debit amount in Set of Books currency
ACCOUNTED_CR	NUMBER			Credit amount in Set of Books currency
GL_SL_LINK_ID	NUMBER	(15)		Unique id which identifies the journal line for future GL drilldown function
SETTLEMENT_NUMBER	NUMBER			Unique reference number assigned to a settlement
ORIG_JOURNAL_DATE	DATE			Original journal date of entry at time of creation.
BATCH_ID	NUMBER	(15)	Yes	Identifier that groups events into one process flow.
ALT_JOURNAL_DATE	DATE			Not currently used
DATE_TYPE	VARCHAR2	(7)		Not currently used
ACTION_CODE	VARCHAR2	(7)		Not currently used

Query Text

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


SELECT AMOUNT_TYPE
,      AUDIT_INDICATOR
,      CANCELLED_IN_GL
,      COMMENTS
,      COMPANY_CODE
,      CREATED_BY
,      CREATED_ON
,      CREDIT_AMOUNT
,      CURRENCY
,      DEAL_NUMBER
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      DEBIT_AMOUNT
,      CODE_COMBINATION_ID
,      GL_TRANSFER_DATE
,      JNL_REVERSAL_IND
,      JOURNAL_DATE
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      TRANSACTION_NUMBER
,      TRANSFER_TO_EXTERNAL_GL
,      UPDATED_BY
,      UPDATED_ON
,      SET_OF_BOOKS_ID
,      SUSPENSE_GL
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      GL_SL_LINK_ID
,      SETTLEMENT_NUMBER
,      ORIG_JOURNAL_DATE
,      BATCH_ID
,      ALT_JOURNAL_DATE
,      DATE_TYPE
,      ACTION_CODE
FROM XTR.XTR_JOURNALS;

Dependencies

[top of page]

XTR.XTR_JOURNALS does not reference any database object

XTR.XTR_JOURNALS is referenced by following:

XTR: XTR_JOURNALS#