VIEW: JA.JAI_CMN_JOURNAL_ENTRIES#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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