VIEW: JL.JL_BR_AR_RET_INTERFACE_EXT_AL#

Source

View Text - Preformatted

select FILE_CONTROL FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER, COMPANY_CODE COMPANY_CODE, COMPANY_NAME COMPANY_NAME, GENERATION_DATE GENERATION_DATE, REMITTANCE_CODE REMITTANCE_CODE, BANK_NUMBER BANK_NUMBER, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE, OCCURRENCE_DATE OCCURRENCE_DATE, PROCESSING_DATE PROCESSING_DATE, LAST_VALIDATION_DATE LAST_VALIDATION_DATE, INSCRIPTION_NUMBER INSCRIPTION_NUMBER, COMPANY_USE COMPANY_USE, OUR_NUMBER OUR_NUMBER, PORTFOLIO_CODE PORTFOLIO_CODE, YOUR_NUMBER YOUR_NUMBER, DUE_DATE DUE_DATE, TRADE_NOTE_AMOUNT TRADE_NOTE_AMOUNT, COLLECTOR_BANK_NUMBER COLLECTOR_BANK_NUMBER, COLLECTOR_BRANCH_NUMBER COLLECTOR_BRANCH_NUMBER, TRADE_NOTE_TYPE TRADE_NOTE_TYPE, 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, ERROR_CODE ERROR_CODE, CANCELLATION_CODE CANCELLATION_CODE, 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, 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_RET_INTERFACE_EXT_ALL"

View Text - HTML Formatted

SELECT FILE_CONTROL FILE_CONTROL
, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER
, COMPANY_CODE COMPANY_CODE
, COMPANY_NAME COMPANY_NAME
, GENERATION_DATE GENERATION_DATE
, REMITTANCE_CODE REMITTANCE_CODE
, BANK_NUMBER BANK_NUMBER
, BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, OCCURRENCE_DATE OCCURRENCE_DATE
, PROCESSING_DATE PROCESSING_DATE
, LAST_VALIDATION_DATE LAST_VALIDATION_DATE
, INSCRIPTION_NUMBER INSCRIPTION_NUMBER
, COMPANY_USE COMPANY_USE
, OUR_NUMBER OUR_NUMBER
, PORTFOLIO_CODE PORTFOLIO_CODE
, YOUR_NUMBER YOUR_NUMBER
, DUE_DATE DUE_DATE
, TRADE_NOTE_AMOUNT TRADE_NOTE_AMOUNT
, COLLECTOR_BANK_NUMBER COLLECTOR_BANK_NUMBER
, COLLECTOR_BRANCH_NUMBER COLLECTOR_BRANCH_NUMBER
, TRADE_NOTE_TYPE TRADE_NOTE_TYPE
, 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
, ERROR_CODE ERROR_CODE
, CANCELLATION_CODE CANCELLATION_CODE
, 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
, 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_RET_INTERFACE_EXT_ALL"