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

VIEW: XTR.XTR_A_JOURNALS#

Object Details
Object Name: XTR_A_JOURNALS#
Object Type: VIEW
Owner: XTR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AMOUNT_TYPE VARCHAR2 (7)
AUDIT_DATE_STORED DATE

AUDIT_INDICATOR VARCHAR2 (1)
CANCELLED_IN_GL VARCHAR2 (1)
COMMENTS VARCHAR2 (255)
COMPANY_CODE VARCHAR2 (7) Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
CREDIT_AMOUNT NUMBER

CURRENCY VARCHAR2 (15)
DEAL_NUMBER NUMBER
Yes
DEAL_SUBTYPE VARCHAR2 (7)
DEAL_TYPE VARCHAR2 (7)
DEBIT_AMOUNT NUMBER

CODE_COMBINATION_ID NUMBER (15) Yes
GL_TRANSFER_DATE DATE

JNL_REVERSAL_IND VARCHAR2 (1)
JOURNAL_DATE DATE
Yes
PORTFOLIO_CODE VARCHAR2 (7)
PRODUCT_TYPE VARCHAR2 (10)
TRANSACTION_NUMBER NUMBER
Yes
TRANSFER_TO_EXTERNAL_GL DATE

UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

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

ACCOUNTED_CR NUMBER

GL_SL_LINK_ID NUMBER (15)
SETTLEMENT_NUMBER NUMBER

Query Text

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


SELECT AMOUNT_TYPE
,      AUDIT_DATE_STORED
,      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
FROM XTR.XTR_A_JOURNALS#;

Dependencies

[top of page]

XTR.XTR_A_JOURNALS# references the following:

SchemaXTR
TableXTR_A_JOURNALS
XTR.XTR_A_JOURNALS# is referenced by following:

SchemaAPPS
SynonymXTR_A_JOURNALS