VIEW: JL.JL_CO_GL_TRX#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, PROCESS_ID PROCESS_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, NIT_ID NIT_ID, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, JE_BATCH_ID JE_BATCH_ID, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, ACCOUNT_CODE ACCOUNT_CODE, PERIOD_NAME PERIOD_NAME, CURRENCY_CODE CURRENCY_CODE, CATEGORY CATEGORY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, ACCOUNTING_DATE ACCOUNTING_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SUBLEDGER_DOC_NUMBER SUBLEDGER_DOC_NUMBER, DOCUMENT_NUMBER DOCUMENT_NUMBER, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR from "JL"."JL_CO_GL_TRX"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, PROCESS_ID PROCESS_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, NIT_ID NIT_ID
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, JE_BATCH_ID JE_BATCH_ID
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, ACCOUNT_CODE ACCOUNT_CODE
, PERIOD_NAME PERIOD_NAME
, CURRENCY_CODE CURRENCY_CODE
, CATEGORY CATEGORY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, ACCOUNTING_DATE ACCOUNTING_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUBLEDGER_DOC_NUMBER SUBLEDGER_DOC_NUMBER
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
FROM "JL"."JL_CO_GL_TRX"