VIEW: JL.JL_BR_AP_COLLECTION_DOCS_ALL#

Source

View Text - Preformatted

select BANK_COLLECTION_ID BANK_COLLECTION_ID, INVOICE_ID INVOICE_ID, PAYMENT_NUM PAYMENT_NUM, HOLD_FLAG HOLD_FLAG, ISSUE_DATE ISSUE_DATE, DOCUMENT_NUMBER DOCUMENT_NUMBER, DRAWER_GUARANTOR DRAWER_GUARANTOR, INSTRUCTION_1 INSTRUCTION_1, INSTRUCTION_2 INSTRUCTION_2, CURRENCY_CODE CURRENCY_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, VENDOR_SITE_ID VENDOR_SITE_ID, FILE_CONTROL FILE_CONTROL, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE, 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, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, VENDOR_ID VENDOR_ID, BANK_BRANCH_ID BANK_BRANCH_ID, ORG_ID ORG_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BRANCH_PARTY_ID BRANCH_PARTY_ID, BANK_PARTY_ID BANK_PARTY_ID, BARCODE BARCODE, ELECTRONIC_FORMAT_FLAG ELECTRONIC_FORMAT_FLAG from "JL"."JL_BR_AP_COLLECTION_DOCS_ALL"

View Text - HTML Formatted

SELECT BANK_COLLECTION_ID BANK_COLLECTION_ID
, INVOICE_ID INVOICE_ID
, PAYMENT_NUM PAYMENT_NUM
, HOLD_FLAG HOLD_FLAG
, ISSUE_DATE ISSUE_DATE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, DRAWER_GUARANTOR DRAWER_GUARANTOR
, INSTRUCTION_1 INSTRUCTION_1
, INSTRUCTION_2 INSTRUCTION_2
, CURRENCY_CODE CURRENCY_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
, VENDOR_SITE_ID VENDOR_SITE_ID
, FILE_CONTROL FILE_CONTROL
, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE
, 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
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ENTRY_SEQUENTIAL_NUMBER ENTRY_SEQUENTIAL_NUMBER
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, VENDOR_ID VENDOR_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, ORG_ID ORG_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BRANCH_PARTY_ID BRANCH_PARTY_ID
, BANK_PARTY_ID BANK_PARTY_ID
, BARCODE BARCODE
, ELECTRONIC_FORMAT_FLAG ELECTRONIC_FORMAT_FLAG
FROM "JL"."JL_BR_AP_COLLECTION_DOCS_ALL"