VIEW: JL.JL_BR_AR_DISTRIBUTNS_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, DISTRIBUTION_ID DISTRIBUTION_ID, DOCUMENT_ID DOCUMENT_ID, DISTRIBUTION_LINK_TYPE DISTRIBUTION_LINK_TYPE, DISTRIBUTION_TYPE DISTRIBUTION_TYPE, GL_DATE GL_DATE, ENTERED_AMT ENTERED_AMT, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE, ACCTD_AMT ACCTD_AMT, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, CONVERSION_RATE_TYPE CONVERSION_RATE_TYPE, ACCOUNTING_REVERSAL_OPTION ACCOUNTING_REVERSAL_OPTION, REVERSED_DIST_ID REVERSED_DIST_ID, REVERSED_DIST_LINK_TYPE REVERSED_DIST_LINK_TYPE, PRIOR_DIST_ID PRIOR_DIST_ID, PRIOR_DIST_LINK_TYPE PRIOR_DIST_LINK_TYPE, EVENT_ID EVENT_ID, EVENT_DATE EVENT_DATE, OCCURRENCE_ID OCCURRENCE_ID, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE, STD_OCCURRENCE_CODE STD_OCCURRENCE_CODE, BORDERO_TYPE BORDERO_TYPE, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE, DIST_LINE_NUMBER DIST_LINE_NUMBER from "JL"."JL_BR_AR_DISTRIBUTNS_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, DOCUMENT_ID DOCUMENT_ID
, DISTRIBUTION_LINK_TYPE DISTRIBUTION_LINK_TYPE
, DISTRIBUTION_TYPE DISTRIBUTION_TYPE
, GL_DATE GL_DATE
, ENTERED_AMT ENTERED_AMT
, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE
, ACCTD_AMT ACCTD_AMT
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, CONVERSION_RATE_TYPE CONVERSION_RATE_TYPE
, ACCOUNTING_REVERSAL_OPTION ACCOUNTING_REVERSAL_OPTION
, REVERSED_DIST_ID REVERSED_DIST_ID
, REVERSED_DIST_LINK_TYPE REVERSED_DIST_LINK_TYPE
, PRIOR_DIST_ID PRIOR_DIST_ID
, PRIOR_DIST_LINK_TYPE PRIOR_DIST_LINK_TYPE
, EVENT_ID EVENT_ID
, EVENT_DATE EVENT_DATE
, OCCURRENCE_ID OCCURRENCE_ID
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, STD_OCCURRENCE_CODE STD_OCCURRENCE_CODE
, BORDERO_TYPE BORDERO_TYPE
, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE
, DIST_LINE_NUMBER DIST_LINE_NUMBER
FROM "JL"."JL_BR_AR_DISTRIBUTNS_ALL"