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_JOURNAL_ENTRY_ACTIONS

Object Details

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

XTR_JOURNAL_ENTRY_ACTIONS contains the journal structure used to create journals in Treasury. Each row corresponds to a combination of company, deal type, deal subtype, product type and portfolio.
This table corresponds to the multi-row block of the Journal Structures tabbed region on the Journal Entry Actions window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_JOURNAL_ENTRY_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTION_CODE AMOUNT_TYPE DEAL_TYPE
XTR_JOURNAL_ENTRY_ACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEAL_TYPE DEAL_SUBTYPE
XTR_JOURNAL_ENTRY_ACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPANY_CODE
XTR_JOURNAL_ENTRY_ACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AMOUNT_TYPE DEAL_TYPE
XTR_JOURNAL_ENTRY_ACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_TYPE DEAL_TYPE
XTR_JOURNAL_ENTRY_ACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID COMPANY_CODE
XTR_JOURNAL_ENTRY_ACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRODUCT_TYPE PORTFOLIO_CODE AMOUNT_TYPE DATE_TYPE DEAL_TYPE DEAL_SUBTYPE CREDIT_OR_DEBIT ACTION_CODE GET_GL_FROM_DEAL CODE_COMBINATION_ID COMPANY_CODE GET_PRIN_CCID_FROM_DEAL GET_INT_CCID_FROM_DEAL

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_CODE	VARCHAR2	(7)		Code for actions involved in executing deals
AMOUNT_TYPE	VARCHAR2	(7)	Yes	Code that identifies the purpose of the amounts for a deal type
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
COMMENTS	VARCHAR2	(255)		Comments for the journal entry details
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_OR_DEBIT	VARCHAR2	(2)	Yes	Flag to indicate if a GL account is to be debited (DR) or credited (CR)
DATE_TYPE	VARCHAR2	(7)	Yes	Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates)
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
GET_PRIN_CCID_FROM_DEAL	VARCHAR2	(1)	Yes	Flag indicating GL account used should be the principal GL account associated with the intercompany counterparty for the deal (Y), or not (N)
GET_INT_CCID_FROM_DEAL	VARCHAR2	(1)	Yes	Flag indicating GL account used should be the interest GL account associated with the intercompany counterparty for the deal (Y), or not (N)
CODE_COMBINATION_ID	NUMBER	(15)		Comments for the journal entry details
GET_GL_FROM_DEAL	VARCHAR2	(1)	Yes	Flag indicating GL account used should be the one associated with the company's bank account for the deal (Y), or not (N)
PARTY_GL	VARCHAR2	(1)		Not currently used
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
EFFECTIVE_FROM	DATE			Not currently used
EFFECTIVE_TO	DATE			Not currently used

Query Text

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


SELECT ACTION_CODE
,      AMOUNT_TYPE
,      AUDIT_INDICATOR
,      COMMENTS
,      COMPANY_CODE
,      CREATED_BY
,      CREATED_ON
,      CREDIT_OR_DEBIT
,      DATE_TYPE
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      GET_PRIN_CCID_FROM_DEAL
,      GET_INT_CCID_FROM_DEAL
,      CODE_COMBINATION_ID
,      GET_GL_FROM_DEAL
,      PARTY_GL
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      UPDATED_BY
,      UPDATED_ON
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
FROM XTR.XTR_JOURNAL_ENTRY_ACTIONS;

Dependencies

[top of page]

XTR.XTR_JOURNAL_ENTRY_ACTIONS does not reference any database object

XTR.XTR_JOURNAL_ENTRY_ACTIONS is referenced by following:

XTR: XTR_JOURNAL_ENTRY_ACTIONS#