VIEW: JL.JL_BR_AP_INT_COLLECT_ALL#

Source

View Text - Preformatted

select FILE_CONTROL FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER, REGISTRY_CODE REGISTRY_CODE, RETURN_CODE RETURN_CODE, SERVICE_CODE SERVICE_CODE, RECORDING_DATE RECORDING_DATE, ISSUE_DATE ISSUE_DATE, DOCUMENT_NUMBER DOCUMENT_NUMBER, DRAWER_GUARANTOR DRAWER_GUARANTOR, INSTRUCTION_1 INSTRUCTION_1, INSTRUCTION_2 INSTRUCTION_2, CNAB_CODE CNAB_CODE, DUE_DATE DUE_DATE, AMOUNT AMOUNT, DISCOUNT_DATE DISCOUNT_DATE, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, ARREARS_DATE ARREARS_DATE, ARREARS_CODE ARREARS_CODE, ARREARS_INTEREST ARREARS_INTEREST, ABATE_AMOUNT ABATE_AMOUNT, PAID_AMOUNT PAID_AMOUNT, PAYMENT_LOCATION PAYMENT_LOCATION, DOCUMENT_TYPE DOCUMENT_TYPE, ACCEPTANCE ACCEPTANCE, PROCESSING_DATE PROCESSING_DATE, BANK_USE BANK_USE, PORTFOLIO PORTFOLIO, PENALTY_FEE_AMOUNT PENALTY_FEE_AMOUNT, PENALTY_FEE_DATE PENALTY_FEE_DATE, OTHER_ACCRETIONS OTHER_ACCRETIONS, OUR_NUMBER OUR_NUMBER, TRANSFEROR_CODE TRANSFEROR_CODE, OCCURRENCE OCCURRENCE, OCCURRENCE_DATE OCCURRENCE_DATE, DRAWEE_NAME DRAWEE_NAME, DRAWEE_BANK_CODE DRAWEE_BANK_CODE, DRAWEE_BANK_NAME DRAWEE_BANK_NAME, DRAWEE_BRANCH_CODE DRAWEE_BRANCH_CODE, DRAWEE_ACCOUNT_NUMBER DRAWEE_ACCOUNT_NUMBER, DRAWEE_INSCRIPTION_TYPE DRAWEE_INSCRIPTION_TYPE, DRAWEE_INSCRIPTION_NUMBER DRAWEE_INSCRIPTION_NUMBER, TRANSFEROR_NAME TRANSFEROR_NAME, TRANSFEROR_BANK_CODE TRANSFEROR_BANK_CODE, TRANSFEROR_BRANCH_CODE TRANSFEROR_BRANCH_CODE, TRANSFEROR_ACCOUNT_NUMBER TRANSFEROR_ACCOUNT_NUMBER, TRANSFEROR_INSCRIPTION_TYPE TRANSFEROR_INSCRIPTION_TYPE, TRANSFEROR_INSCRIPTION_NUMBER TRANSFEROR_INSCRIPTION_NUMBER, ACCOUNTING_BALANCING_SEGMENT ACCOUNTING_BALANCING_SEGMENT, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ERROR_CODE ERROR_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, 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, BARCODE BARCODE, ELECTRONIC_FORMAT_FLAG ELECTRONIC_FORMAT_FLAG from "JL"."JL_BR_AP_INT_COLLECT_ALL"

View Text - HTML Formatted

SELECT FILE_CONTROL FILE_CONTROL
, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER
, REGISTRY_CODE REGISTRY_CODE
, RETURN_CODE RETURN_CODE
, SERVICE_CODE SERVICE_CODE
, RECORDING_DATE RECORDING_DATE
, ISSUE_DATE ISSUE_DATE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, DRAWER_GUARANTOR DRAWER_GUARANTOR
, INSTRUCTION_1 INSTRUCTION_1
, INSTRUCTION_2 INSTRUCTION_2
, CNAB_CODE CNAB_CODE
, DUE_DATE DUE_DATE
, AMOUNT AMOUNT
, DISCOUNT_DATE DISCOUNT_DATE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, ARREARS_DATE ARREARS_DATE
, ARREARS_CODE ARREARS_CODE
, ARREARS_INTEREST ARREARS_INTEREST
, ABATE_AMOUNT ABATE_AMOUNT
, PAID_AMOUNT PAID_AMOUNT
, PAYMENT_LOCATION PAYMENT_LOCATION
, DOCUMENT_TYPE DOCUMENT_TYPE
, ACCEPTANCE ACCEPTANCE
, PROCESSING_DATE PROCESSING_DATE
, BANK_USE BANK_USE
, PORTFOLIO PORTFOLIO
, PENALTY_FEE_AMOUNT PENALTY_FEE_AMOUNT
, PENALTY_FEE_DATE PENALTY_FEE_DATE
, OTHER_ACCRETIONS OTHER_ACCRETIONS
, OUR_NUMBER OUR_NUMBER
, TRANSFEROR_CODE TRANSFEROR_CODE
, OCCURRENCE OCCURRENCE
, OCCURRENCE_DATE OCCURRENCE_DATE
, DRAWEE_NAME DRAWEE_NAME
, DRAWEE_BANK_CODE DRAWEE_BANK_CODE
, DRAWEE_BANK_NAME DRAWEE_BANK_NAME
, DRAWEE_BRANCH_CODE DRAWEE_BRANCH_CODE
, DRAWEE_ACCOUNT_NUMBER DRAWEE_ACCOUNT_NUMBER
, DRAWEE_INSCRIPTION_TYPE DRAWEE_INSCRIPTION_TYPE
, DRAWEE_INSCRIPTION_NUMBER DRAWEE_INSCRIPTION_NUMBER
, TRANSFEROR_NAME TRANSFEROR_NAME
, TRANSFEROR_BANK_CODE TRANSFEROR_BANK_CODE
, TRANSFEROR_BRANCH_CODE TRANSFEROR_BRANCH_CODE
, TRANSFEROR_ACCOUNT_NUMBER TRANSFEROR_ACCOUNT_NUMBER
, TRANSFEROR_INSCRIPTION_TYPE TRANSFEROR_INSCRIPTION_TYPE
, TRANSFEROR_INSCRIPTION_NUMBER TRANSFEROR_INSCRIPTION_NUMBER
, ACCOUNTING_BALANCING_SEGMENT ACCOUNTING_BALANCING_SEGMENT
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ERROR_CODE ERROR_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
, 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
, BARCODE BARCODE
, ELECTRONIC_FORMAT_FLAG ELECTRONIC_FORMAT_FLAG
FROM "JL"."JL_BR_AP_INT_COLLECT_ALL"