1. Tables and Views for Financials
  2. CE_BANK_ACCOUNTS

CE_BANK_ACCOUNTS

CE_BANK_ACCOUNTS contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch.

Details

  • Schema: FUSION

  • Object owner: CE

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

CE_BANK_ACCOUNTS_PK

BANK_ACCOUNT_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
BANK_ACCOUNT_ID NUMBER 18 Yes Uniquely identifies the bank account.
REAL_TIME_BAL_PROCESSING_FLAG VARCHAR2 1 Indicates whether the bank account is enabled for real time balance processing.
CREATION_SOURCE_CODE VARCHAR2 30 This column identifies the source of bank account creation. valid values are from the lookup ORA_CE_ACCOUNT_CREATION_SOURCE
TARGET_BALANCE NUMBER Target balance set for the bank account.
TRANSACTION_CALENDAR_ID NUMBER 18 General Ledger transaction calendar identifier.
BANK_ACCOUNT_NAME VARCHAR2 360 Yes Name of the bank account.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
BANK_ACCOUNT_NUM VARCHAR2 30 Bank account number of the bank account.
BANK_BRANCH_ID NUMBER 18 Yes Uniquely identifies the bank branch.
BANK_ID NUMBER 18 Bank identifier that uniquely identifies the bank.
CURRENCY_CODE VARCHAR2 15 Currency code used for the bank account.
DESCRIPTION VARCHAR2 240 Detail description for the bank account.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Bank Accounts (CE_BANK_ACCOUNTS)
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APPLICATION_ID NUMBER 18 No longer used.
PROGRAM_ID NUMBER 18 No longer used.
PROGRAM_UPDATE_DATE DATE No longer used.
CHECK_DIGITS VARCHAR2 30 Holds any check digits that result from bank account number validation.
BANK_ACCOUNT_NAME_ALT VARCHAR2 320 Alternate name of the bank account holder.
ACCOUNT_HOLDER_ID NUMBER 18 Uniquely identifies the account holder.
EFT_REQUESTER_IDENTIFIER VARCHAR2 25 No longer used.
SECONDARY_ACCOUNT_REFERENCE VARCHAR2 30 Account number reference, such as Building Society Roll Number.
ACCOUNT_SUFFIX VARCHAR2 30 Account suffix for the bank account.
DESCRIPTION_CODE1 VARCHAR2 60 No longer used.
DESCRIPTION_CODE2 VARCHAR2 60 No longer used.
IBAN_NUMBER VARCHAR2 50 International bank account number.
SHORT_ACCOUNT_NAME VARCHAR2 30 Short name of the bank account.
ACCOUNT_OWNER_PARTY_ID NUMBER 18 Yes Bank account owner party identifier in the trading community architecture.
ACCOUNT_OWNER_ORG_ID NUMBER 18 Yes Bank account owner organization identifier in HR.
ACCOUNT_CLASSIFICATION VARCHAR2 30 Yes Account classification, such as INTERNAL or EXTERNAL.
AP_USE_ALLOWED_FLAG VARCHAR2 1 Flag that indicates whether the account use for payables is enabled.
AR_USE_ALLOWED_FLAG VARCHAR2 1 Flag that indicates whether the account use for receivables is enabled.
XTR_USE_ALLOWED_FLAG VARCHAR2 1 Flag to indicate if the account use for treasury is allowed.
PAY_USE_ALLOWED_FLAG VARCHAR2 1 Flag to indicate if the account use for payroll is allowed.
MULTI_CURRENCY_ALLOWED_FLAG VARCHAR2 1 Flag to indicate if the multiple currency is allowed.
ZERO_AMOUNT_ALLOWED VARCHAR2 1 Indicator for allowing or disallowing zero amount.
MAX_OUTLAY NUMBER Maximum payment batch allowed for the bank account.
MAX_CHECK_AMOUNT NUMBER Default maximum payment amount allowed for bank account in a payment batch.
MIN_CHECK_AMOUNT NUMBER Default minimum payment amount allowed for bank account in a payment batch.
BANK_ACCOUNT_TYPE VARCHAR2 25 Bank account type code (subaccount type).
AGENCY_LOCATION_CODE VARCHAR2 30 Agency location code used by federal agencies.
START_DATE DATE First date in the date range in which the row is active.
END_DATE DATE Last date in the date range in which the row is active.
ACCOUNT_HOLDER_NAME_ALT VARCHAR2 150 Alternate name of the bank account holder.
ACCOUNT_HOLDER_NAME VARCHAR2 240 Name of the bank account holder.
CASHFLOW_DISPLAY_ORDER NUMBER 18 Obsolete
POOLED_FLAG VARCHAR2 1 Pooled or nonpooled account indicator.
MIN_TARGET_BALANCE NUMBER No longer used.
MAX_TARGET_BALANCE NUMBER No longer used.
EFT_USER_NUM VARCHAR2 30 Electronic file transfer user number for the bank account.
MASKED_ACCOUNT_NUM VARCHAR2 100 Masked number of the bank account.
MASKED_IBAN VARCHAR2 50 Masked international bank account number.
INTEREST_SCHEDULE_ID NUMBER 18 No longer used.
CASHPOOL_MIN_PAYMENT_AMT NUMBER Cash pool minimum payment amount.
CASHPOOL_MIN_RECEIPT_AMT NUMBER Cash pool minimum receipt amount.
CASHPOOL_ROUND_FACTOR NUMBER No longer used.
CASHPOOL_ROUND_RULE VARCHAR2 4 No longer used.
ASSET_CODE_COMBINATION_ID NUMBER 18 Accounting flexfield identifier for the cash account.
CASH_CLEARING_CCID NUMBER 18 Cash clearing general ledger account identifier.
BANK_CHARGES_CCID NUMBER 18 Bank charges general ledger account identifier.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
NETTING_ACCT_FLAG VARCHAR2 1 Flag to indicate if the bank account is a netting account.
POOL_PAYMENT_METHOD_CODE VARCHAR2 30 No longer used.
POOL_BANK_CHARGE_BEARER_CODE VARCHAR2 30 Cash pool bank charge bearer code.
POOL_PAYMENT_REASON_CODE VARCHAR2 30 No longer used.
POOL_PAYMENT_REASON_COMMENTS VARCHAR2 255 Comments on cash pool payment reason.
POOL_REMITTANCE_MESSAGE1 VARCHAR2 255 No longer used.
POOL_REMITTANCE_MESSAGE2 VARCHAR2 255 No longer used.
POOL_REMITTANCE_MESSAGE3 VARCHAR2 255 No longer used.
FX_CHARGE_CCID NUMBER 18 Foreign exchange charge general ledger account identifier.
BANK_ACCOUNT_NUM_ELECTRONIC VARCHAR2 100 Bank account number in electronic transmission format.
RECON_FOREIGN_BANK_XRATE_TYPE VARCHAR2 30 No longer used.
RECON_FOR_BANK_XRATE_DATE_TYPE VARCHAR2 10 No longer used.
XTR_BANK_ACCOUNT_REFERENCE VARCHAR2 20 Treasury bank account reference.
RECON_RULESET_ID NUMBER 18 Uniquely identifies the reconciliation rule set
MANUAL_TOLERANCE_RULE_ID NUMBER 18 Manual tolerance rule identifier.
RECON_START_DATE DATE Beginning date of the bank account that is used for reconciliation.
BANK_EXCHANGE_RATE_TYPE VARCHAR2 30 Bank exchange rate type used for bank statement reconciliation.
RECON_DIFFERENCE_CCID NUMBER 18 Reconciliation difference general ledger account identifier.
PARSING_RULE_SET_ID NUMBER 18 Uniquely identifies the parsing rule set.
DATA_SECURITY_FLAG VARCHAR2 1 Flag to indicate if bank account will be secured by user or role.
GL_CUR_EXC_RATE_TYPE VARCHAR2 30 Accounting exchange rate type used to convert external cash transaction amount from bank account currency to ledger currency.
REVERSAL_PROCESS_CODE VARCHAR2 30 Specifies the method used to process receipt reversal bank statement lines during automatic reconciliation.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
MULTI_CASH_RECON_ENABLED_FLAG VARCHAR2 1 Indicates whether multiple cash account combinations can be considered for journal reconciliation.
CASH_CCID_FIXED_SEGMENTS VARCHAR2 300 List of segments that represent the general ledger cash account and are used to retrieve multiple cash account combinations for journal reconciliation.
GL_RECON_START_DATE DATE Date when journal entries start being available for reconciliation.
VOID_REJECTED_PAYMENTS_FLAG VARCHAR2 1 Indicates whether the rejected payment can be automatically voided through auto-reconciliation process.
LOCKBOX_NUMBER VARCHAR2 30 Number of the lockbox within the bank

Foreign Keys

Table Foreign Table Foreign Key Column
CE_BANK_ACCOUNTS hz_parties BANK_BRANCH_ID
CE_BANK_ACCOUNTS hz_parties BANK_ID
CE_BANK_ACCOUNTS hz_parties ACCOUNT_HOLDER_ID
CE_BANK_ACCOUNTS hz_parties ACCOUNT_OWNER_PARTY_ID
CE_BANK_ACCOUNTS xle_entity_profiles ACCOUNT_OWNER_ORG_ID
ra_customer_trx_all ce_bank_accounts REMITTANCE_BANK_ACCOUNT_ID
jl_br_ar_select_accounts_all ce_bank_accounts BANK_ACCOUNT_ID
ce_contact_assignments ce_bank_accounts BANK_ACCOUNT_ID
iby_payments_all ce_bank_accounts EXTERNAL_BANK_ACCOUNT_ID
iby_payments_all ce_bank_accounts INTERNAL_BANK_ACCOUNT_ID
jl_br_ar_coll_batches_all ce_bank_accounts BANK_ACCOUNT_ID
ce_stmt_balances ce_bank_accounts BANK_ACCOUNT_ID
ap_payment_templates ce_bank_accounts BANK_ACCOUNT_ID
ce_acct_trx_creat_rules ce_bank_accounts BANK_ACCOUNT_ID
ce_bank_account_grants ce_bank_accounts BANK_ACCOUNT_ID
ce_bank_account_cash_ccids ce_bank_accounts BANK_ACCOUNT_ID
iby_intermediary_accts ce_bank_accounts INTERNAL_BANK_ACCOUNT_ID
iby_docs_payable_all ce_bank_accounts INTERNAL_BANK_ACCOUNT_ID
jl_br_ar_pay_sched_aux ce_bank_accounts BANK_ACCOUNT_ID
jl_br_ar_borderos_all ce_bank_accounts BANK_ACCOUNT_ID
iby_pay_service_requests ce_bank_accounts INTERNAL_BANK_ACCOUNT_ID
ce_bank_acct_uses_all ce_bank_accounts BANK_ACCOUNT_ID
ce_statement_headers ce_bank_accounts BANK_ACCOUNT_ID
ce_external_transactions ce_bank_accounts BANK_ACCOUNT_ID
ce_payment_documents ce_bank_accounts INTERNAL_BANK_ACCOUNT_ID
iby_pay_instructions_all ce_bank_accounts INTERNAL_BANK_ACCOUNT_ID
iby_gen_docs_payable ce_bank_accounts INTERNAL_BANK_ACCOUNT_ID

Indexes

Index Uniqueness Tablespace Columns
CE_BANK_ACCOUNTS_N1 Non Unique Default BANK_BRANCH_ID
CE_BANK_ACCOUNTS_N10 Non Unique Default UPPER("BANK_ACCOUNT_NAME")
CE_BANK_ACCOUNTS_N11 Non Unique Default LAST_UPDATE_DATE
CE_BANK_ACCOUNTS_N12 Non Unique Default UPPER("BANK_ACCOUNT_NUM")
CE_BANK_ACCOUNTS_N2 Non Unique Default BANK_ACCOUNT_NAME
CE_BANK_ACCOUNTS_N3 Non Unique Default BANK_ACCOUNT_NUM, BANK_ACCOUNT_TYPE
CE_BANK_ACCOUNTS_N4 Non Unique Default SHORT_ACCOUNT_NAME
CE_BANK_ACCOUNTS_N5 Non Unique Default ACCOUNT_OWNER_PARTY_ID
CE_BANK_ACCOUNTS_N6 Non Unique Default IBAN_NUMBER
CE_BANK_ACCOUNTS_N7 Non Unique Default EFT_REQUESTER_IDENTIFIER
CE_BANK_ACCOUNTS_N8 Non Unique Default BANK_ID
CE_BANK_ACCOUNTS_N9 Non Unique Default ACCOUNT_HOLDER_ID
CE_BANK_ACCOUNTS_U1 Unique Default BANK_ACCOUNT_ID