VIEW: JL.JL_BR_AR_OCCURRENCE_DOCS_ALL#

Source

View Text - Preformatted

select OCCURRENCE_ID OCCURRENCE_ID, DOCUMENT_ID DOCUMENT_ID, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE, BANK_NUMBER BANK_NUMBER, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE, OCCURRENCE_DATE OCCURRENCE_DATE, OCCURRENCE_STATUS OCCURRENCE_STATUS, ORIGINAL_REMITTANCE_MEDIA ORIGINAL_REMITTANCE_MEDIA, REMITTANCE_MEDIA REMITTANCE_MEDIA, SELECTION_DATE SELECTION_DATE, BORDERO_ID BORDERO_ID, PORTFOLIO_CODE PORTFOLIO_CODE, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER, DUE_DATE DUE_DATE, DOCUMENT_AMOUNT DOCUMENT_AMOUNT, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2, NUM_DAYS_INSTRUCTION NUM_DAYS_INSTRUCTION, INTEREST_PERCENT INTEREST_PERCENT, INTEREST_PERIOD INTEREST_PERIOD, INTEREST_AMOUNT INTEREST_AMOUNT, GRACE_DAYS GRACE_DAYS, DISCOUNT_LIMIT_DATE DISCOUNT_LIMIT_DATE, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, CUSTOMER_ID CUSTOMER_ID, SITE_USE_ID SITE_USE_ID, ABATEMENT_AMOUNT ABATEMENT_AMOUNT, FLAG_POST_GL FLAG_POST_GL, GL_DATE GL_DATE, GL_POSTED_DATE GL_POSTED_DATE, ENDORSEMENT_CREDIT_CCID ENDORSEMENT_CREDIT_CCID, ENDORSEMENT_DEBIT_CCID ENDORSEMENT_DEBIT_CCID, ENDORSEMENT_DEBIT_AMOUNT ENDORSEMENT_DEBIT_AMOUNT, ENDORSEMENT_CREDIT_AMOUNT ENDORSEMENT_CREDIT_AMOUNT, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT, BANK_CHARGES_CREDIT_CCID BANK_CHARGES_CREDIT_CCID, BANK_CHARGES_DEBIT_CCID BANK_CHARGES_DEBIT_CCID, BANK_CHARGES_CREDIT_AMOUNT BANK_CHARGES_CREDIT_AMOUNT, BANK_CHARGES_DEBIT_AMOUNT BANK_CHARGES_DEBIT_AMOUNT, DISCOUNT_CRED_ACCT_CCID DISCOUNT_CRED_ACCT_CCID, FACTORING_DEBIT_CCID FACTORING_DEBIT_CCID, FACTORING_CREDIT_CCID FACTORING_CREDIT_CCID, FACTORING_CREDIT_AMOUNT FACTORING_CREDIT_AMOUNT, FACTORING_DEBIT_AMOUNT FACTORING_DEBIT_AMOUNT, FACTOR_INTEREST_CREDIT_CCID FACTOR_INTEREST_CREDIT_CCID, FACTOR_INTEREST_DEBIT_CCID FACTOR_INTEREST_DEBIT_CCID, FACTOR_INTEREST_DEBIT_AMOUNT FACTOR_INTEREST_DEBIT_AMOUNT, FACTOR_INTEREST_CREDIT_AMOUNT FACTOR_INTEREST_CREDIT_AMOUNT, REVERSE_CHARGES_CRED_CCID REVERSE_CHARGES_CRED_CCID, REVERSE_CHARGES_DEB_CCID REVERSE_CHARGES_DEB_CCID, REVERSE_CHARGES_DEB_AMOUNT REVERSE_CHARGES_DEB_AMOUNT, REVERSE_CHARGES_CRED_AMOUNT REVERSE_CHARGES_CRED_AMOUNT, REQUEST_ID REQUEST_ID, RETURN_INFO RETURN_INFO, INTEREST_INDICATOR INTEREST_INDICATOR, RETURN_REQUEST_ID RETURN_REQUEST_ID, GL_CANCEL_DATE GL_CANCEL_DATE, ORG_ID ORG_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FACTORING_CHARGES_CREDIT_CCID FACTORING_CHARGES_CREDIT_CCID, FACTORING_CHARGES_DEBIT_CCID FACTORING_CHARGES_DEBIT_CCID, FACTORING_CHARGES_CRED_AMOUNT FACTORING_CHARGES_CRED_AMOUNT, FACTORING_CHARGES_DEB_AMOUNT FACTORING_CHARGES_DEB_AMOUNT, DISCOUNTED_BILLS_CREDIT_CCID DISCOUNTED_BILLS_CREDIT_CCID, DISCOUNTED_BILLS_DEBIT_CCID DISCOUNTED_BILLS_DEBIT_CCID, DISCOUNTED_BILLS_CRED_AMOUNT DISCOUNTED_BILLS_CRED_AMOUNT, DISCOUNTED_BILLS_DEB_AMOUNT DISCOUNTED_BILLS_DEB_AMOUNT, DISCOUNT_CREDIT_CCID DISCOUNT_CREDIT_CCID, DISCOUNT_DEBIT_CCID DISCOUNT_DEBIT_CCID, DISCOUNT_CRED_AMOUNT DISCOUNT_CRED_AMOUNT, DISCOUNT_DEB_AMOUNT DISCOUNT_DEB_AMOUNT, CASH_CREDIT_CCID CASH_CREDIT_CCID, CASH_DEBIT_CCID CASH_DEBIT_CCID, CASH_CRED_AMOUNT CASH_CRED_AMOUNT, CASH_DEB_AMOUNT CASH_DEB_AMOUNT, BANK_PARTY_ID BANK_PARTY_ID, CANCEL_EVENT_ID CANCEL_EVENT_ID, EVENT_ID EVENT_ID from "JL"."JL_BR_AR_OCCURRENCE_DOCS_ALL"

View Text - HTML Formatted

SELECT OCCURRENCE_ID OCCURRENCE_ID
, DOCUMENT_ID DOCUMENT_ID
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, BANK_NUMBER BANK_NUMBER
, BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE
, OCCURRENCE_DATE OCCURRENCE_DATE
, OCCURRENCE_STATUS OCCURRENCE_STATUS
, ORIGINAL_REMITTANCE_MEDIA ORIGINAL_REMITTANCE_MEDIA
, REMITTANCE_MEDIA REMITTANCE_MEDIA
, SELECTION_DATE SELECTION_DATE
, BORDERO_ID BORDERO_ID
, PORTFOLIO_CODE PORTFOLIO_CODE
, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER
, DUE_DATE DUE_DATE
, DOCUMENT_AMOUNT DOCUMENT_AMOUNT
, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2
, NUM_DAYS_INSTRUCTION NUM_DAYS_INSTRUCTION
, INTEREST_PERCENT INTEREST_PERCENT
, INTEREST_PERIOD INTEREST_PERIOD
, INTEREST_AMOUNT INTEREST_AMOUNT
, GRACE_DAYS GRACE_DAYS
, DISCOUNT_LIMIT_DATE DISCOUNT_LIMIT_DATE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, CUSTOMER_ID CUSTOMER_ID
, SITE_USE_ID SITE_USE_ID
, ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, FLAG_POST_GL FLAG_POST_GL
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, ENDORSEMENT_CREDIT_CCID ENDORSEMENT_CREDIT_CCID
, ENDORSEMENT_DEBIT_CCID ENDORSEMENT_DEBIT_CCID
, ENDORSEMENT_DEBIT_AMOUNT ENDORSEMENT_DEBIT_AMOUNT
, ENDORSEMENT_CREDIT_AMOUNT ENDORSEMENT_CREDIT_AMOUNT
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, BANK_CHARGES_CREDIT_CCID BANK_CHARGES_CREDIT_CCID
, BANK_CHARGES_DEBIT_CCID BANK_CHARGES_DEBIT_CCID
, BANK_CHARGES_CREDIT_AMOUNT BANK_CHARGES_CREDIT_AMOUNT
, BANK_CHARGES_DEBIT_AMOUNT BANK_CHARGES_DEBIT_AMOUNT
, DISCOUNT_CRED_ACCT_CCID DISCOUNT_CRED_ACCT_CCID
, FACTORING_DEBIT_CCID FACTORING_DEBIT_CCID
, FACTORING_CREDIT_CCID FACTORING_CREDIT_CCID
, FACTORING_CREDIT_AMOUNT FACTORING_CREDIT_AMOUNT
, FACTORING_DEBIT_AMOUNT FACTORING_DEBIT_AMOUNT
, FACTOR_INTEREST_CREDIT_CCID FACTOR_INTEREST_CREDIT_CCID
, FACTOR_INTEREST_DEBIT_CCID FACTOR_INTEREST_DEBIT_CCID
, FACTOR_INTEREST_DEBIT_AMOUNT FACTOR_INTEREST_DEBIT_AMOUNT
, FACTOR_INTEREST_CREDIT_AMOUNT FACTOR_INTEREST_CREDIT_AMOUNT
, REVERSE_CHARGES_CRED_CCID REVERSE_CHARGES_CRED_CCID
, REVERSE_CHARGES_DEB_CCID REVERSE_CHARGES_DEB_CCID
, REVERSE_CHARGES_DEB_AMOUNT REVERSE_CHARGES_DEB_AMOUNT
, REVERSE_CHARGES_CRED_AMOUNT REVERSE_CHARGES_CRED_AMOUNT
, REQUEST_ID REQUEST_ID
, RETURN_INFO RETURN_INFO
, INTEREST_INDICATOR INTEREST_INDICATOR
, RETURN_REQUEST_ID RETURN_REQUEST_ID
, GL_CANCEL_DATE GL_CANCEL_DATE
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FACTORING_CHARGES_CREDIT_CCID FACTORING_CHARGES_CREDIT_CCID
, FACTORING_CHARGES_DEBIT_CCID FACTORING_CHARGES_DEBIT_CCID
, FACTORING_CHARGES_CRED_AMOUNT FACTORING_CHARGES_CRED_AMOUNT
, FACTORING_CHARGES_DEB_AMOUNT FACTORING_CHARGES_DEB_AMOUNT
, DISCOUNTED_BILLS_CREDIT_CCID DISCOUNTED_BILLS_CREDIT_CCID
, DISCOUNTED_BILLS_DEBIT_CCID DISCOUNTED_BILLS_DEBIT_CCID
, DISCOUNTED_BILLS_CRED_AMOUNT DISCOUNTED_BILLS_CRED_AMOUNT
, DISCOUNTED_BILLS_DEB_AMOUNT DISCOUNTED_BILLS_DEB_AMOUNT
, DISCOUNT_CREDIT_CCID DISCOUNT_CREDIT_CCID
, DISCOUNT_DEBIT_CCID DISCOUNT_DEBIT_CCID
, DISCOUNT_CRED_AMOUNT DISCOUNT_CRED_AMOUNT
, DISCOUNT_DEB_AMOUNT DISCOUNT_DEB_AMOUNT
, CASH_CREDIT_CCID CASH_CREDIT_CCID
, CASH_DEBIT_CCID CASH_DEBIT_CCID
, CASH_CRED_AMOUNT CASH_CRED_AMOUNT
, CASH_DEB_AMOUNT CASH_DEB_AMOUNT
, BANK_PARTY_ID BANK_PARTY_ID
, CANCEL_EVENT_ID CANCEL_EVENT_ID
, EVENT_ID EVENT_ID
FROM "JL"."JL_BR_AR_OCCURRENCE_DOCS_ALL"