DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_JOURNALS_EFC

Object Details
Object Name: XTR_JOURNALS_EFC
Object Type: TABLE
Owner: XTR
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AMOUNT_TYPE VARCHAR2 (7)
AUDIT_INDICATOR VARCHAR2 (1)
CANCELLED_IN_GL VARCHAR2 (1)
COMMENTS VARCHAR2 (255)
COMPANY_CODE VARCHAR2 (7)
CREATED_BY VARCHAR2 (30)
CREATED_ON DATE

CREDIT_AMOUNT NUMBER

CURRENCY VARCHAR2 (15)
DEAL_NUMBER NUMBER

DEAL_SUBTYPE VARCHAR2 (7)
DEAL_TYPE VARCHAR2 (7)
DEBIT_AMOUNT NUMBER

CODE_COMBINATION_ID NUMBER (15)
GL_TRANSFER_DATE DATE

JNL_REVERSAL_IND VARCHAR2 (1)
JOURNAL_DATE DATE

PORTFOLIO_CODE VARCHAR2 (7)
PRODUCT_TYPE VARCHAR2 (10)
TRANSACTION_NUMBER NUMBER

TRANSFER_TO_EXTERNAL_GL DATE

UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

SET_OF_BOOKS_ID NUMBER (15)
SUSPENSE_GL VARCHAR2 (1)
ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

GL_SL_LINK_ID NUMBER (15)
SETTLEMENT_NUMBER NUMBER

XJROWID ROWID (10)
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
,      XJROWID
FROM XTR.XTR_JOURNALS_EFC;

Dependencies

[top of page]

XTR.XTR_JOURNALS_EFC does not reference any database object

XTR.XTR_JOURNALS_EFC is referenced by following:

SchemaXTR
ViewXTR_JOURNALS_EFC#