VIEW: JL.JL_BR_AR_BANK_RETURNS_ALL#

Source

View Text - Preformatted

select RETURN_ID RETURN_ID, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE, OCCURRENCE_DATE OCCURRENCE_DATE, FILE_CONTROL FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER, GENERATION_DATE GENERATION_DATE, PROCESSING_DATE PROCESSING_DATE, DOCUMENT_ID DOCUMENT_ID, BANK_NUMBER BANK_NUMBER, BATCH_SOURCE_ID BATCH_SOURCE_ID, OUR_NUMBER OUR_NUMBER, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER, DUE_DATE DUE_DATE, TRADE_NOTE_AMOUNT TRADE_NOTE_AMOUNT, COLLECTOR_BANK_NUMBER COLLECTOR_BANK_NUMBER, COLLECTOR_BRANCH_NUMBER COLLECTOR_BRANCH_NUMBER, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT, ABATEMENT_AMOUNT ABATEMENT_AMOUNT, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, CREDIT_AMOUNT CREDIT_AMOUNT, INTEREST_AMOUNT_RECEIVED INTEREST_AMOUNT_RECEIVED, CUSTOMER_NAME CUSTOMER_NAME, RETURN_INFO RETURN_INFO, BANK_USE BANK_USE, COMPANY_USE COMPANY_USE, ORG_ID ORG_ID, 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, CUSTOMER_ID CUSTOMER_ID, BANK_PARTY_ID BANK_PARTY_ID, COLLECTOR_BANK_PARTY_ID COLLECTOR_BANK_PARTY_ID, COLLECTOR_BRANCH_PARTY_ID COLLECTOR_BRANCH_PARTY_ID from "JL"."JL_BR_AR_BANK_RETURNS_ALL"

View Text - HTML Formatted

SELECT RETURN_ID RETURN_ID
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, OCCURRENCE_DATE OCCURRENCE_DATE
, FILE_CONTROL FILE_CONTROL
, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER
, GENERATION_DATE GENERATION_DATE
, PROCESSING_DATE PROCESSING_DATE
, DOCUMENT_ID DOCUMENT_ID
, BANK_NUMBER BANK_NUMBER
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, OUR_NUMBER OUR_NUMBER
, TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER
, DUE_DATE DUE_DATE
, TRADE_NOTE_AMOUNT TRADE_NOTE_AMOUNT
, COLLECTOR_BANK_NUMBER COLLECTOR_BANK_NUMBER
, COLLECTOR_BRANCH_NUMBER COLLECTOR_BRANCH_NUMBER
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, CREDIT_AMOUNT CREDIT_AMOUNT
, INTEREST_AMOUNT_RECEIVED INTEREST_AMOUNT_RECEIVED
, CUSTOMER_NAME CUSTOMER_NAME
, RETURN_INFO RETURN_INFO
, BANK_USE BANK_USE
, COMPANY_USE COMPANY_USE
, ORG_ID ORG_ID
, 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
, CUSTOMER_ID CUSTOMER_ID
, BANK_PARTY_ID BANK_PARTY_ID
, COLLECTOR_BANK_PARTY_ID COLLECTOR_BANK_PARTY_ID
, COLLECTOR_BRANCH_PARTY_ID COLLECTOR_BRANCH_PARTY_ID
FROM "JL"."JL_BR_AR_BANK_RETURNS_ALL"