VIEW: JA.JAI_RCV_JOURNAL_ENTRIES#

Source

View Text - Preformatted

select ORGANIZATION_CODE ORGANIZATION_CODE, RECEIPT_NUM RECEIPT_NUM, TRANSACTION_ID TRANSACTION_ID, CREATION_DATE CREATION_DATE, TRANSACTION_DATE TRANSACTION_DATE, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, ACCT_TYPE ACCT_TYPE, ACCT_NATURE ACCT_NATURE, SOURCE_NAME SOURCE_NAME, CATEGORY_NAME CATEGORY_NAME, CODE_COMBINATION_ID CODE_COMBINATION_ID, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, TRANSACTION_TYPE TRANSACTION_TYPE, PERIOD_NAME PERIOD_NAME, CREATED_BY CREATED_BY, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, REFERENCE_NAME REFERENCE_NAME, REFERENCE_ID REFERENCE_ID, JOURNAL_ENTRY_ID JOURNAL_ENTRY_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_RCV_JOURNAL_ENTRIES"

View Text - HTML Formatted

SELECT ORGANIZATION_CODE ORGANIZATION_CODE
, RECEIPT_NUM RECEIPT_NUM
, TRANSACTION_ID TRANSACTION_ID
, CREATION_DATE CREATION_DATE
, TRANSACTION_DATE TRANSACTION_DATE
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, ACCT_TYPE ACCT_TYPE
, ACCT_NATURE ACCT_NATURE
, SOURCE_NAME SOURCE_NAME
, CATEGORY_NAME CATEGORY_NAME
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, TRANSACTION_TYPE TRANSACTION_TYPE
, PERIOD_NAME PERIOD_NAME
, CREATED_BY CREATED_BY
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, REFERENCE_NAME REFERENCE_NAME
, REFERENCE_ID REFERENCE_ID
, JOURNAL_ENTRY_ID JOURNAL_ENTRY_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_RCV_JOURNAL_ENTRIES"