VIEW: AP.AP_BANK_ACCOUNTS_ALL#

Source

View Text - Preformatted

select BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_BRANCH_ID BANK_BRANCH_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CURRENCY_CODE CURRENCY_CODE, DESCRIPTION DESCRIPTION, CONTACT_FIRST_NAME CONTACT_FIRST_NAME, CONTACT_MIDDLE_NAME CONTACT_MIDDLE_NAME, CONTACT_LAST_NAME CONTACT_LAST_NAME, CONTACT_PREFIX CONTACT_PREFIX, CONTACT_TITLE CONTACT_TITLE, CONTACT_AREA_CODE CONTACT_AREA_CODE, CONTACT_PHONE CONTACT_PHONE, MAX_CHECK_AMOUNT MAX_CHECK_AMOUNT, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT, ONE_SIGNATURE_MAX_FLAG ONE_SIGNATURE_MAX_FLAG, INACTIVE_DATE INACTIVE_DATE, AVG_FLOAT_DAYS AVG_FLOAT_DAYS, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, VALIDATION_NUMBER VALIDATION_NUMBER, MAX_OUTLAY MAX_OUTLAY, MULTI_CURRENCY_FLAG MULTI_CURRENCY_FLAG, ACCOUNT_TYPE ACCOUNT_TYPE, 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, POOLED_FLAG POOLED_FLAG, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RECEIPT_MULTI_CURRENCY_FLAG RECEIPT_MULTI_CURRENCY_FLAG, CHECK_DIGITS CHECK_DIGITS, ORG_ID ORG_ID, CASH_CLEARING_CCID CASH_CLEARING_CCID, BANK_CHARGES_CCID BANK_CHARGES_CCID, BANK_ERRORS_CCID BANK_ERRORS_CCID, EARNED_CCID EARNED_CCID, UNEARNED_CCID UNEARNED_CCID, ON_ACCOUNT_CCID ON_ACCOUNT_CCID, UNAPPLIED_CCID UNAPPLIED_CCID, UNIDENTIFIED_CCID UNIDENTIFIED_CCID, FACTOR_CCID FACTOR_CCID, RECEIPT_CLEARING_CCID RECEIPT_CLEARING_CCID, REMITTANCE_CCID REMITTANCE_CCID, SHORT_TERM_DEPOSIT_CCID SHORT_TERM_DEPOSIT_CCID, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME, ACCOUNT_HOLDER_NAME_ALT ACCOUNT_HOLDER_NAME_ALT, EFT_REQUESTER_ID EFT_REQUESTER_ID, EFT_USER_NUMBER EFT_USER_NUMBER, PAYROLL_BANK_ACCOUNT_ID PAYROLL_BANK_ACCOUNT_ID, FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID, EDISC_RECEIVABLES_TRX_ID EDISC_RECEIVABLES_TRX_ID, UNEDISC_RECEIVABLES_TRX_ID UNEDISC_RECEIVABLES_TRX_ID, BR_REMITTANCE_CCID BR_REMITTANCE_CCID, BR_FACTOR_CCID BR_FACTOR_CCID, BR_STD_RECEIVABLES_TRX_ID BR_STD_RECEIVABLES_TRX_ID, ALLOW_MULTI_ASSIGNMENTS_FLAG ALLOW_MULTI_ASSIGNMENTS_FLAG, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE, IBAN_NUMBER IBAN_NUMBER from "AP"."AP_BANK_ACCOUNTS_ALL"

View Text - HTML Formatted

SELECT BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_BRANCH_ID BANK_BRANCH_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CURRENCY_CODE CURRENCY_CODE
, DESCRIPTION DESCRIPTION
, CONTACT_FIRST_NAME CONTACT_FIRST_NAME
, CONTACT_MIDDLE_NAME CONTACT_MIDDLE_NAME
, CONTACT_LAST_NAME CONTACT_LAST_NAME
, CONTACT_PREFIX CONTACT_PREFIX
, CONTACT_TITLE CONTACT_TITLE
, CONTACT_AREA_CODE CONTACT_AREA_CODE
, CONTACT_PHONE CONTACT_PHONE
, MAX_CHECK_AMOUNT MAX_CHECK_AMOUNT
, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT
, ONE_SIGNATURE_MAX_FLAG ONE_SIGNATURE_MAX_FLAG
, INACTIVE_DATE INACTIVE_DATE
, AVG_FLOAT_DAYS AVG_FLOAT_DAYS
, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID
, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID
, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, VALIDATION_NUMBER VALIDATION_NUMBER
, MAX_OUTLAY MAX_OUTLAY
, MULTI_CURRENCY_FLAG MULTI_CURRENCY_FLAG
, ACCOUNT_TYPE ACCOUNT_TYPE
, 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
, POOLED_FLAG POOLED_FLAG
, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RECEIPT_MULTI_CURRENCY_FLAG RECEIPT_MULTI_CURRENCY_FLAG
, CHECK_DIGITS CHECK_DIGITS
, ORG_ID ORG_ID
, CASH_CLEARING_CCID CASH_CLEARING_CCID
, BANK_CHARGES_CCID BANK_CHARGES_CCID
, BANK_ERRORS_CCID BANK_ERRORS_CCID
, EARNED_CCID EARNED_CCID
, UNEARNED_CCID UNEARNED_CCID
, ON_ACCOUNT_CCID ON_ACCOUNT_CCID
, UNAPPLIED_CCID UNAPPLIED_CCID
, UNIDENTIFIED_CCID UNIDENTIFIED_CCID
, FACTOR_CCID FACTOR_CCID
, RECEIPT_CLEARING_CCID RECEIPT_CLEARING_CCID
, REMITTANCE_CCID REMITTANCE_CCID
, SHORT_TERM_DEPOSIT_CCID SHORT_TERM_DEPOSIT_CCID
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME
, ACCOUNT_HOLDER_NAME_ALT ACCOUNT_HOLDER_NAME_ALT
, EFT_REQUESTER_ID EFT_REQUESTER_ID
, EFT_USER_NUMBER EFT_USER_NUMBER
, PAYROLL_BANK_ACCOUNT_ID PAYROLL_BANK_ACCOUNT_ID
, FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID
, EDISC_RECEIVABLES_TRX_ID EDISC_RECEIVABLES_TRX_ID
, UNEDISC_RECEIVABLES_TRX_ID UNEDISC_RECEIVABLES_TRX_ID
, BR_REMITTANCE_CCID BR_REMITTANCE_CCID
, BR_FACTOR_CCID BR_FACTOR_CCID
, BR_STD_RECEIVABLES_TRX_ID BR_STD_RECEIVABLES_TRX_ID
, ALLOW_MULTI_ASSIGNMENTS_FLAG ALLOW_MULTI_ASSIGNMENTS_FLAG
, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE
, IBAN_NUMBER IBAN_NUMBER
FROM "AP"."AP_BANK_ACCOUNTS_ALL"