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

VIEW: JA.JAI_CMN_JOURNAL_ENTRIES#

Object Details
Object Name: JAI_CMN_JOURNAL_ENTRIES#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REGIME_CODE VARCHAR2 (30)
ORGANIZATION_ID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15)
TAX_TYPE VARCHAR2 (30)
PERIOD_NAME VARCHAR2 (15)
CODE_COMBINATION_ID NUMBER (15)
ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

TRANSACTION_DATE DATE

SOURCE VARCHAR2 (30)
SOURCE_TABLE_NAME VARCHAR2 (30)
SOURCE_TRX_ID NUMBER (15)
REFERENCE_NAME VARCHAR2 (30)
REFERENCE_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15)
CURR_CONV_RATE NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
JOURNAL_ENTRY_ID NUMBER (15) Yes
REPOSITORY_ID NUMBER

Query Text

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


SELECT REGIME_CODE
,      ORGANIZATION_ID
,      SET_OF_BOOKS_ID
,      TAX_TYPE
,      PERIOD_NAME
,      CODE_COMBINATION_ID
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      TRANSACTION_DATE
,      SOURCE
,      SOURCE_TABLE_NAME
,      SOURCE_TRX_ID
,      REFERENCE_NAME
,      REFERENCE_ID
,      CURRENCY_CODE
,      CURR_CONV_RATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      JOURNAL_ENTRY_ID
,      REPOSITORY_ID
FROM JA.JAI_CMN_JOURNAL_ENTRIES#;

Dependencies

[top of page]

JA.JAI_CMN_JOURNAL_ENTRIES# references the following:

SchemaJA
TableJAI_CMN_JOURNAL_ENTRIES
JA.JAI_CMN_JOURNAL_ENTRIES# is referenced by following:

SchemaAPPS
SynonymJAI_CMN_JOURNAL_ENTRIES