VIEW: IBY.IBY_EXT_BANK_ACCOUNTS#

Source

View Text - Preformatted

select EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID, COUNTRY_CODE COUNTRY_CODE, BRANCH_ID BRANCH_ID, BANK_ID BANK_ID, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_ACCOUNT_NUM_HASH1 BANK_ACCOUNT_NUM_HASH1, BANK_ACCOUNT_NUM_HASH2 BANK_ACCOUNT_NUM_HASH2, MASKED_BANK_ACCOUNT_NUM MASKED_BANK_ACCOUNT_NUM, BA_MASK_SETTING BA_MASK_SETTING, BA_UNMASK_LENGTH BA_UNMASK_LENGTH, CURRENCY_CODE CURRENCY_CODE, IBAN IBAN, IBAN_HASH1 IBAN_HASH1, IBAN_HASH2 IBAN_HASH2, MASKED_IBAN MASKED_IBAN, CHECK_DIGITS CHECK_DIGITS, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, ACCOUNT_CLASSIFICATION ACCOUNT_CLASSIFICATION, ACCOUNT_SUFFIX ACCOUNT_SUFFIX, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE, PAYMENT_FACTOR_FLAG PAYMENT_FACTOR_FLAG, FOREIGN_PAYMENT_USE_FLAG FOREIGN_PAYMENT_USE_FLAG, EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_NUM, EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE_AGREEMENT_TYPE, EXCHANGE_RATE EXCHANGE_RATE, HEDGING_CONTRACT_REFERENCE HEDGING_CONTRACT_REFERENCE, SECONDARY_ACCOUNT_REFERENCE SECONDARY_ACCOUNT_REFERENCE, BA_NUM_SEC_SEGMENT_ID BA_NUM_SEC_SEGMENT_ID, ENCRYPTED ENCRYPTED, IBAN_SEC_SEGMENT_ID IBAN_SEC_SEGMENT_ID, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, START_DATE START_DATE, END_DATE END_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT, SHORT_ACCT_NAME SHORT_ACCT_NAME, DESCRIPTION DESCRIPTION, BANK_ACCOUNT_NUM_ELECTRONIC BANK_ACCOUNT_NUM_ELECTRONIC, BA_NUM_ELEC_SEC_SEGMENT_ID BA_NUM_ELEC_SEC_SEGMENT_ID, SALT_VERSION SALT_VERSION, CONTACT_NAME CONTACT_NAME, CONTACT_PHONE CONTACT_PHONE, CONTACT_FAX CONTACT_FAX, CONTACT_EMAIL CONTACT_EMAIL from "IBY"."IBY_EXT_BANK_ACCOUNTS"

View Text - HTML Formatted

SELECT EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID
, COUNTRY_CODE COUNTRY_CODE
, BRANCH_ID BRANCH_ID
, BANK_ID BANK_ID
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_ACCOUNT_NUM_HASH1 BANK_ACCOUNT_NUM_HASH1
, BANK_ACCOUNT_NUM_HASH2 BANK_ACCOUNT_NUM_HASH2
, MASKED_BANK_ACCOUNT_NUM MASKED_BANK_ACCOUNT_NUM
, BA_MASK_SETTING BA_MASK_SETTING
, BA_UNMASK_LENGTH BA_UNMASK_LENGTH
, CURRENCY_CODE CURRENCY_CODE
, IBAN IBAN
, IBAN_HASH1 IBAN_HASH1
, IBAN_HASH2 IBAN_HASH2
, MASKED_IBAN MASKED_IBAN
, CHECK_DIGITS CHECK_DIGITS
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, ACCOUNT_CLASSIFICATION ACCOUNT_CLASSIFICATION
, ACCOUNT_SUFFIX ACCOUNT_SUFFIX
, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE
, PAYMENT_FACTOR_FLAG PAYMENT_FACTOR_FLAG
, FOREIGN_PAYMENT_USE_FLAG FOREIGN_PAYMENT_USE_FLAG
, EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_NUM
, EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE_AGREEMENT_TYPE
, EXCHANGE_RATE EXCHANGE_RATE
, HEDGING_CONTRACT_REFERENCE HEDGING_CONTRACT_REFERENCE
, SECONDARY_ACCOUNT_REFERENCE SECONDARY_ACCOUNT_REFERENCE
, BA_NUM_SEC_SEGMENT_ID BA_NUM_SEC_SEGMENT_ID
, ENCRYPTED ENCRYPTED
, IBAN_SEC_SEGMENT_ID IBAN_SEC_SEGMENT_ID
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, START_DATE START_DATE
, END_DATE END_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, SHORT_ACCT_NAME SHORT_ACCT_NAME
, DESCRIPTION DESCRIPTION
, BANK_ACCOUNT_NUM_ELECTRONIC BANK_ACCOUNT_NUM_ELECTRONIC
, BA_NUM_ELEC_SEC_SEGMENT_ID BA_NUM_ELEC_SEC_SEGMENT_ID
, SALT_VERSION SALT_VERSION
, CONTACT_NAME CONTACT_NAME
, CONTACT_PHONE CONTACT_PHONE
, CONTACT_FAX CONTACT_FAX
, CONTACT_EMAIL CONTACT_EMAIL
FROM "IBY"."IBY_EXT_BANK_ACCOUNTS"