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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, BANK_ACCOUNT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
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 | 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 | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | 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 | 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. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
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 | Bank account owner party identifier in the trading community architecture. | ||
ACCOUNT_OWNER_ORG_ID | NUMBER | 18 | Bank account owner organization identifier in HR. | ||
ACCOUNT_CLASSIFICATION | VARCHAR2 | 30 | 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 | 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 | ||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CE_BANK_ACCOUNTSN1_ | Non Unique | Default | BANK_ACCOUNT_ID, LAST_UPDATE_DATE |
CE_BANK_ACCOUNTS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, BANK_ACCOUNT_ID |