VIEW: CE.CE_BANK_ACCOUNTS#

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, BANK_ID BANK_ID, CURRENCY_CODE CURRENCY_CODE, DESCRIPTION DESCRIPTION, 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, CHECK_DIGITS CHECK_DIGITS, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT, ACCOUNT_HOLDER_ID ACCOUNT_HOLDER_ID, EFT_REQUESTER_IDENTIFIER EFT_REQUESTER_IDENTIFIER, SECONDARY_ACCOUNT_REFERENCE SECONDARY_ACCOUNT_REFERENCE, ACCOUNT_SUFFIX ACCOUNT_SUFFIX, DESCRIPTION_CODE1 DESCRIPTION_CODE1, DESCRIPTION_CODE2 DESCRIPTION_CODE2, IBAN_NUMBER IBAN_NUMBER, SHORT_ACCOUNT_NAME SHORT_ACCOUNT_NAME, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID, ACCOUNT_OWNER_ORG_ID ACCOUNT_OWNER_ORG_ID, ACCOUNT_CLASSIFICATION ACCOUNT_CLASSIFICATION, AP_USE_ALLOWED_FLAG AP_USE_ALLOWED_FLAG, AR_USE_ALLOWED_FLAG AR_USE_ALLOWED_FLAG, XTR_USE_ALLOWED_FLAG XTR_USE_ALLOWED_FLAG, PAY_USE_ALLOWED_FLAG PAY_USE_ALLOWED_FLAG, MULTI_CURRENCY_ALLOWED_FLAG MULTI_CURRENCY_ALLOWED_FLAG, PAYMENT_MULTI_CURRENCY_FLAG PAYMENT_MULTI_CURRENCY_FLAG, RECEIPT_MULTI_CURRENCY_FLAG RECEIPT_MULTI_CURRENCY_FLAG, ZERO_AMOUNT_ALLOWED ZERO_AMOUNT_ALLOWED, MAX_OUTLAY MAX_OUTLAY, MAX_CHECK_AMOUNT MAX_CHECK_AMOUNT, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT, AP_AMOUNT_TOLERANCE AP_AMOUNT_TOLERANCE, AR_AMOUNT_TOLERANCE AR_AMOUNT_TOLERANCE, XTR_AMOUNT_TOLERANCE XTR_AMOUNT_TOLERANCE, PAY_AMOUNT_TOLERANCE PAY_AMOUNT_TOLERANCE, AP_PERCENT_TOLERANCE AP_PERCENT_TOLERANCE, AR_PERCENT_TOLERANCE AR_PERCENT_TOLERANCE, XTR_PERCENT_TOLERANCE XTR_PERCENT_TOLERANCE, PAY_PERCENT_TOLERANCE PAY_PERCENT_TOLERANCE, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE, START_DATE START_DATE, END_DATE END_DATE, ACCOUNT_HOLDER_NAME_ALT ACCOUNT_HOLDER_NAME_ALT, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME, CASHFLOW_DISPLAY_ORDER CASHFLOW_DISPLAY_ORDER, POOLED_FLAG POOLED_FLAG, MIN_TARGET_BALANCE MIN_TARGET_BALANCE, MAX_TARGET_BALANCE MAX_TARGET_BALANCE, EFT_USER_NUM EFT_USER_NUM, MASKED_ACCOUNT_NUM MASKED_ACCOUNT_NUM, MASKED_IBAN MASKED_IBAN, INTEREST_SCHEDULE_ID INTEREST_SCHEDULE_ID, CASHPOOL_MIN_PAYMENT_AMT CASHPOOL_MIN_PAYMENT_AMT, CASHPOOL_MIN_RECEIPT_AMT CASHPOOL_MIN_RECEIPT_AMT, CASHPOOL_ROUND_FACTOR CASHPOOL_ROUND_FACTOR, CASHPOOL_ROUND_RULE CASHPOOL_ROUND_RULE, CE_AMOUNT_TOLERANCE CE_AMOUNT_TOLERANCE, CE_PERCENT_TOLERANCE CE_PERCENT_TOLERANCE, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID, CASH_CLEARING_CCID CASH_CLEARING_CCID, BANK_CHARGES_CCID BANK_CHARGES_CCID, BANK_ERRORS_CCID BANK_ERRORS_CCID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, NETTING_ACCT_FLAG NETTING_ACCT_FLAG, POOL_PAYMENT_METHOD_CODE POOL_PAYMENT_METHOD_CODE, POOL_BANK_CHARGE_BEARER_CODE POOL_BANK_CHARGE_BEARER_CODE, POOL_PAYMENT_REASON_CODE POOL_PAYMENT_REASON_CODE, POOL_PAYMENT_REASON_COMMENTS POOL_PAYMENT_REASON_COMMENTS, POOL_REMITTANCE_MESSAGE1 POOL_REMITTANCE_MESSAGE1, POOL_REMITTANCE_MESSAGE2 POOL_REMITTANCE_MESSAGE2, POOL_REMITTANCE_MESSAGE3 POOL_REMITTANCE_MESSAGE3, FX_CHARGE_CCID FX_CHARGE_CCID, BANK_ACCOUNT_NUM_ELECTRONIC BANK_ACCOUNT_NUM_ELECTRONIC, STMT_LINE_FLOAT_HANDLING_FLAG STMT_LINE_FLOAT_HANDLING_FLAG, AUTORECON_AP_MATCHING_ORDER AUTORECON_AP_MATCHING_ORDER, AUTORECON_AR_MATCHING_ORDER AUTORECON_AR_MATCHING_ORDER, RECON_FOREIGN_BANK_XRATE_TYPE RECON_FOREIGN_BANK_XRATE_TYPE, RECON_FOR_BANK_XRATE_DATE_TYPE RECON_FOR_BANK_XRATE_DATE_TYPE, RECON_ENABLE_OI_FLAG RECON_ENABLE_OI_FLAG, RECON_OI_FLOAT_STATUS RECON_OI_FLOAT_STATUS, RECON_OI_CLEARED_STATUS RECON_OI_CLEARED_STATUS, RECON_OI_MATCHING_CODE RECON_OI_MATCHING_CODE, RECON_OI_AMOUNT_TOLERANCE RECON_OI_AMOUNT_TOLERANCE, RECON_OI_PERCENT_TOLERANCE RECON_OI_PERCENT_TOLERANCE, MANUAL_RECON_AMOUNT_TOLERANCE MANUAL_RECON_AMOUNT_TOLERANCE, MANUAL_RECON_PERCENT_TOLERANCE MANUAL_RECON_PERCENT_TOLERANCE, RECON_AP_FOREIGN_DIFF_HANDLING RECON_AP_FOREIGN_DIFF_HANDLING, RECON_AR_FOREIGN_DIFF_HANDLING RECON_AR_FOREIGN_DIFF_HANDLING, RECON_CE_FOREIGN_DIFF_HANDLING RECON_CE_FOREIGN_DIFF_HANDLING, RECON_AP_TOLERANCE_DIFF_ACCT RECON_AP_TOLERANCE_DIFF_ACCT, RECON_CE_TOLERANCE_DIFF_ACCT RECON_CE_TOLERANCE_DIFF_ACCT, XTR_BANK_ACCOUNT_REFERENCE XTR_BANK_ACCOUNT_REFERENCE, AUTORECON_AP_MATCHING_ORDER2 AUTORECON_AP_MATCHING_ORDER2, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID, FED_DUNS_NUM FED_DUNS_NUM, FED_DO_SYMBOL FED_DO_SYMBOL from "CE"."CE_BANK_ACCOUNTS"

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
, BANK_ID BANK_ID
, CURRENCY_CODE CURRENCY_CODE
, DESCRIPTION DESCRIPTION
, 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
, CHECK_DIGITS CHECK_DIGITS
, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, ACCOUNT_HOLDER_ID ACCOUNT_HOLDER_ID
, EFT_REQUESTER_IDENTIFIER EFT_REQUESTER_IDENTIFIER
, SECONDARY_ACCOUNT_REFERENCE SECONDARY_ACCOUNT_REFERENCE
, ACCOUNT_SUFFIX ACCOUNT_SUFFIX
, DESCRIPTION_CODE1 DESCRIPTION_CODE1
, DESCRIPTION_CODE2 DESCRIPTION_CODE2
, IBAN_NUMBER IBAN_NUMBER
, SHORT_ACCOUNT_NAME SHORT_ACCOUNT_NAME
, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID
, ACCOUNT_OWNER_ORG_ID ACCOUNT_OWNER_ORG_ID
, ACCOUNT_CLASSIFICATION ACCOUNT_CLASSIFICATION
, AP_USE_ALLOWED_FLAG AP_USE_ALLOWED_FLAG
, AR_USE_ALLOWED_FLAG AR_USE_ALLOWED_FLAG
, XTR_USE_ALLOWED_FLAG XTR_USE_ALLOWED_FLAG
, PAY_USE_ALLOWED_FLAG PAY_USE_ALLOWED_FLAG
, MULTI_CURRENCY_ALLOWED_FLAG MULTI_CURRENCY_ALLOWED_FLAG
, PAYMENT_MULTI_CURRENCY_FLAG PAYMENT_MULTI_CURRENCY_FLAG
, RECEIPT_MULTI_CURRENCY_FLAG RECEIPT_MULTI_CURRENCY_FLAG
, ZERO_AMOUNT_ALLOWED ZERO_AMOUNT_ALLOWED
, MAX_OUTLAY MAX_OUTLAY
, MAX_CHECK_AMOUNT MAX_CHECK_AMOUNT
, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT
, AP_AMOUNT_TOLERANCE AP_AMOUNT_TOLERANCE
, AR_AMOUNT_TOLERANCE AR_AMOUNT_TOLERANCE
, XTR_AMOUNT_TOLERANCE XTR_AMOUNT_TOLERANCE
, PAY_AMOUNT_TOLERANCE PAY_AMOUNT_TOLERANCE
, AP_PERCENT_TOLERANCE AP_PERCENT_TOLERANCE
, AR_PERCENT_TOLERANCE AR_PERCENT_TOLERANCE
, XTR_PERCENT_TOLERANCE XTR_PERCENT_TOLERANCE
, PAY_PERCENT_TOLERANCE PAY_PERCENT_TOLERANCE
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, ACCOUNT_HOLDER_NAME_ALT ACCOUNT_HOLDER_NAME_ALT
, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME
, CASHFLOW_DISPLAY_ORDER CASHFLOW_DISPLAY_ORDER
, POOLED_FLAG POOLED_FLAG
, MIN_TARGET_BALANCE MIN_TARGET_BALANCE
, MAX_TARGET_BALANCE MAX_TARGET_BALANCE
, EFT_USER_NUM EFT_USER_NUM
, MASKED_ACCOUNT_NUM MASKED_ACCOUNT_NUM
, MASKED_IBAN MASKED_IBAN
, INTEREST_SCHEDULE_ID INTEREST_SCHEDULE_ID
, CASHPOOL_MIN_PAYMENT_AMT CASHPOOL_MIN_PAYMENT_AMT
, CASHPOOL_MIN_RECEIPT_AMT CASHPOOL_MIN_RECEIPT_AMT
, CASHPOOL_ROUND_FACTOR CASHPOOL_ROUND_FACTOR
, CASHPOOL_ROUND_RULE CASHPOOL_ROUND_RULE
, CE_AMOUNT_TOLERANCE CE_AMOUNT_TOLERANCE
, CE_PERCENT_TOLERANCE CE_PERCENT_TOLERANCE
, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID
, CASH_CLEARING_CCID CASH_CLEARING_CCID
, BANK_CHARGES_CCID BANK_CHARGES_CCID
, BANK_ERRORS_CCID BANK_ERRORS_CCID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NETTING_ACCT_FLAG NETTING_ACCT_FLAG
, POOL_PAYMENT_METHOD_CODE POOL_PAYMENT_METHOD_CODE
, POOL_BANK_CHARGE_BEARER_CODE POOL_BANK_CHARGE_BEARER_CODE
, POOL_PAYMENT_REASON_CODE POOL_PAYMENT_REASON_CODE
, POOL_PAYMENT_REASON_COMMENTS POOL_PAYMENT_REASON_COMMENTS
, POOL_REMITTANCE_MESSAGE1 POOL_REMITTANCE_MESSAGE1
, POOL_REMITTANCE_MESSAGE2 POOL_REMITTANCE_MESSAGE2
, POOL_REMITTANCE_MESSAGE3 POOL_REMITTANCE_MESSAGE3
, FX_CHARGE_CCID FX_CHARGE_CCID
, BANK_ACCOUNT_NUM_ELECTRONIC BANK_ACCOUNT_NUM_ELECTRONIC
, STMT_LINE_FLOAT_HANDLING_FLAG STMT_LINE_FLOAT_HANDLING_FLAG
, AUTORECON_AP_MATCHING_ORDER AUTORECON_AP_MATCHING_ORDER
, AUTORECON_AR_MATCHING_ORDER AUTORECON_AR_MATCHING_ORDER
, RECON_FOREIGN_BANK_XRATE_TYPE RECON_FOREIGN_BANK_XRATE_TYPE
, RECON_FOR_BANK_XRATE_DATE_TYPE RECON_FOR_BANK_XRATE_DATE_TYPE
, RECON_ENABLE_OI_FLAG RECON_ENABLE_OI_FLAG
, RECON_OI_FLOAT_STATUS RECON_OI_FLOAT_STATUS
, RECON_OI_CLEARED_STATUS RECON_OI_CLEARED_STATUS
, RECON_OI_MATCHING_CODE RECON_OI_MATCHING_CODE
, RECON_OI_AMOUNT_TOLERANCE RECON_OI_AMOUNT_TOLERANCE
, RECON_OI_PERCENT_TOLERANCE RECON_OI_PERCENT_TOLERANCE
, MANUAL_RECON_AMOUNT_TOLERANCE MANUAL_RECON_AMOUNT_TOLERANCE
, MANUAL_RECON_PERCENT_TOLERANCE MANUAL_RECON_PERCENT_TOLERANCE
, RECON_AP_FOREIGN_DIFF_HANDLING RECON_AP_FOREIGN_DIFF_HANDLING
, RECON_AR_FOREIGN_DIFF_HANDLING RECON_AR_FOREIGN_DIFF_HANDLING
, RECON_CE_FOREIGN_DIFF_HANDLING RECON_CE_FOREIGN_DIFF_HANDLING
, RECON_AP_TOLERANCE_DIFF_ACCT RECON_AP_TOLERANCE_DIFF_ACCT
, RECON_CE_TOLERANCE_DIFF_ACCT RECON_CE_TOLERANCE_DIFF_ACCT
, XTR_BANK_ACCOUNT_REFERENCE XTR_BANK_ACCOUNT_REFERENCE
, AUTORECON_AP_MATCHING_ORDER2 AUTORECON_AP_MATCHING_ORDER2
, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID
, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID
, FED_DUNS_NUM FED_DUNS_NUM
, FED_DO_SYMBOL FED_DO_SYMBOL
FROM "CE"."CE_BANK_ACCOUNTS"