This CE Bank Account Details query lists detailed internal bank account information excluding netting accounts, helping users manage and audit bank account configurations.
#sqlquery
SELECT
-- SQL4Fusion (An Orbit Analytics Project)
-- Lists internal bank account details excluding netting accounts
CBA.BANK_ACCOUNT_NAME,
CBA.LAST_UPDATE_DATE,
CBA.LAST_UPDATED_BY,
CBA.LAST_UPDATE_LOGIN,
CBA.CREATION_DATE,
CBA.CREATED_BY,
CBA.BANK_ACCOUNT_NUM,
CBA.CURRENCY_CODE,
CBA.DESCRIPTION,
CBA.ATTRIBUTE_CATEGORY,
CBA.ATTRIBUTE1,
CBA.ATTRIBUTE2,
CBA.ATTRIBUTE3,
CBA.ATTRIBUTE4,
CBA.ATTRIBUTE5,
CBA.ATTRIBUTE6,
CBA.ATTRIBUTE7,
CBA.ATTRIBUTE8,
CBA.ATTRIBUTE9,
CBA.ATTRIBUTE10,
CBA.ATTRIBUTE11,
CBA.ATTRIBUTE12,
CBA.ATTRIBUTE13,
CBA.ATTRIBUTE14,
CBA.ATTRIBUTE15,
CBA.PROGRAM_UPDATE_DATE,
CBA.CHECK_DIGITS, --Holds any check digits that result from bank account number validation in FBS
CBA.BANK_ACCOUNT_NAME_ALT, --Alternate Bank Account Name
CBA.EFT_REQUESTER_IDENTIFIER, --EFT Requester Identifier identifies who initiates an electronic funds transfer
CBA.SECONDARY_ACCOUNT_REFERENCE, --Account Number Reference, Such As Building Society Roll Number
CBA.ACCOUNT_SUFFIX, --Account suffix identifies a sub-account under the main bank account.
CBA.DESCRIPTION_CODE1, --Description Code 1 categorizes a record.
CBA.DESCRIPTION_CODE2, --Description Code 2 classifies a record.
CBA.IBAN_NUMBER, --IBAN is an international bank account ID.
CBA.SHORT_ACCOUNT_NAME,
CBA.ACCOUNT_CLASSIFICATION, --Account Classification (INTERNAL, EXTERNAL)
CBA.AP_USE_ALLOWED_FLAG, --Flag to indicate if the account use for AP is allowed
CBA.AR_USE_ALLOWED_FLAG, --Flag to indicate if the account use for AR is allowed
CBA.XTR_USE_ALLOWED_FLAG, --Flag to indicate if the account use for XTR(Treasury) is allowed
CBA.PAY_USE_ALLOWED_FLAG, --Flag to indicate if the account use for Payroll is allowed
CBA.MULTI_CURRENCY_ALLOWED_FLAG, --Flag to indicate if the multiple currency is allowed
CBA.ZERO_AMOUNT_ALLOWED, --Indicator for allowing or disallowing zero amount
CBA.MAX_OUTLAY, --Maximum payment batch
NVL (CBA.MAX_CHECK_AMOUNT, 0) AS MAX_CHECK_AMOUNT, --Default maximum payment amount allowed for bank account in a payment batch
NVL (CBA.MIN_CHECK_AMOUNT, 0) AS MIN_CHECK_AMOUNT, --Default minimum payment amount allowed for bank account in a payment batch
CBA.BANK_ACCOUNT_TYPE, --Bank account type code (sub account type)
CBA.AGENCY_LOCATION_CODE, --Agency Location Code used by federal agencies
CBA.START_DATE,
CBA.END_DATE,
CBA.ACCOUNT_HOLDER_NAME_ALT, --Account holder alternate name
CBA.CASHFLOW_DISPLAY_ORDER,
CBA.ACCOUNT_HOLDER_NAME,
CBA.MASKED_ACCOUNT_NUM,
CBA.MASKED_IBAN,
CBA.POOLED_FLAG,
CBA.MIN_TARGET_BALANCE,
CBA.MAX_TARGET_BALANCE,
CBA.EFT_USER_NUM
FROM
CE_BANK_ACCOUNTS CBA
WHERE
1 = 1
AND NVL (CBA.NETTING_ACCT_FLAG, 'N') = 'N'
AND END_DATE IS NULL OR END_DATE > SYSDATE