CE Tables (113)
CE - Cash Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
CE_AP_PM_DOC_CATEGORIES |
10 | This table stores payment document categories and payment methods for bank account uses |
CE_ARCH_HEADERS |
43 | Archived CE_STATEMENT_HEADERS_ALL records |
CE_ARCH_INTERFACE_HEADERS |
45 | Archived CE_STATEMENT_HEADERS_INT_ALL records |
CE_ARCH_INTERFACE_LINES |
38 | Archived CE_STATEMENT_LINES_INTERFACE records |
CE_ARCH_INTRA_HEADERS |
43 | Bank statements |
CE_ARCH_INTRA_LINES |
42 | Bank Statement lines |
CE_ARCH_LINES |
42 | Archived CE_STATEMENT_LINES records |
CE_ARCH_RECONCILIATIONS_ALL |
20 | Archived CE_STATEMENT_RECONCILS_ALL records |
CE_ARCH_RECON_ERRORS |
6 | Archived CE_RECONCILIATION_ERRORS records |
CE_AVAILABLE_TRANSACTIONS_TMP |
75 | |
CE_BANK_ACCOUNTS |
123 | This table contains bank account information. Each bank account must be affiliated with one bank branch. |
CE_BANK_ACCT_BALANCES |
18 | This table stores the internal bank account balances |
CE_BANK_ACCT_USES_ALL |
54 | This table stores information about your bank account uses. |
CE_BANK_STMT_INT_MAP |
31 | Bank Statement Mapping |
CE_BANK_STMT_MAP_HDR |
30 | Bank Statement Mapping |
CE_BANK_STMT_MAP_LINE |
30 | Bank Statement Mapping |
CE_BANK_UPGRADE_ERRORS |
10 | This table stores errors that occurred when upgrading a bank, a bank branch, or a bank account. |
CE_BANK_UPGRADE_MODES |
12 | This table stores the bank upgrade mode of each bank entity for source products that current bank tables reside in. |
CE_BA_SIGNATORIES |
34 | This table stores the Bank Account Signatory information for a bank account |
CE_BA_SIGNATORY_HIST_H |
26 | This table stores the history information bank account signatory for a bank account |
CE_CASHFLOWS |
40 | This table stores the cashflows |
CE_CASHFLOW_ACCT_H |
22 | This table stores the history of cashflows |
CE_CASHPOOLS |
21 | This table stores header information about the cash pool |
CE_CASHPOOL_SUB_ACCTS |
16 | This table stores cash pool sub account information |
CE_CE_ARCH_HEADERS |
8 | This table is a backup of the ce_arch_headers table before the bank_account_id foreign key upgrade. |
CE_CE_ARCH_INTRA_HEADERS |
8 | This table is a backup of the ce_arch_intra_headers table before the bank account foreign key upgrade. |
CE_CE_BA_SIGNATORIES |
8 | This table is a backup of the ce_ba_signatories table before the bank account foreign key upgrade. |
CE_CE_CASHPOOLS |
10 | This table is a backup of the ce_cashpools table before the bank account foreign key upgrade. |
CE_CE_CASHPOOL_SUB_ACCTS |
12 | This table is a backup of the ce_cashpool_sub_accts table before the bank account foreign key upgrade. |
CE_CE_CP_PD_BALANCES |
12 | This table is a backup of the ce_cp_priorday_balances table before the bank account foreign key upgrade. |
CE_CE_CP_WORKSHEET_LINES |
8 | This table is a backup of the ce_cp_worksheet_lines table before the bank account foreign key upgrade. |
CE_CE_FC_OPENING_BAL |
8 | This table is a backup of the ce_fc_opening_bal table before the bank account foreign key upgrade. |
CE_CE_FORECAST_ROWS |
8 | This table is a backup of the ce_forecast_rows table before the bank account foreign key upgrade. |
CE_CE_FORECAST_TRX_CELLS |
8 | This table is a backup of the ce_forecast_trx_cells table before the bank account foreign key upgrade. |
CE_CE_INTRA_STMT_HEADERS |
8 | This table is a backup of the ce_intra_stmt_headers table before the bank account foreign key upgrade. |
CE_CE_JE_MAPPINGS |
8 | This table is a backup of the ce_je_mappings table before the bank account foreign key upgrade. |
CE_CE_STATEMENT_HEADERS |
8 | This table is a backup of the ce_statement_headers table before the bank_account_id foreign key upgrade. |
CE_CE_TRANSACTION_CODES |
8 | This table is a backup of the ce_transaction_codes table before the bank account foreign key upgrade. |
CE_CHECKBOOKS |
13 | This table stores payment check book information |
CE_CONTACT_ASSIGNMENTS |
11 | This table contains the information about which level (bank, branch, account) the contact is assigned to. |
CE_CP_PRIORDAY_BALANCES |
11 | This table stores the summarized data for transaction sources |
CE_CP_TRX_EXCLUDED |
12 | This table temporarily stores the transactions being excluded in a cash position result |
CE_CP_WORKSHEET_HEADERS |
9 | This table stores the Cash Position worksheet header definitions |
CE_CP_WORKSHEET_LINES |
43 | This table stores the Cash Position worksheet details |
CE_CURRENCY_RATES_TEMP |
4 | Forecast currency amount staging table |
CE_DOC_SEQUENCE_AUDIT |
5 | Document sequencing audit table |
CE_FORECASTS |
44 | Forecasts |
CE_FORECAST_CELLS |
11 | Forecast amounts |
CE_FORECAST_COLUMNS |
27 | Forecast template columns - forecast periods |
CE_FORECAST_ERRORS |
10 | Forecast run errors |
CE_FORECAST_EXT_TEMP |
7 | |
CE_FORECAST_EXT_VIEWS |
8 | External sources for forecasting |
CE_FORECAST_HEADERS |
32 | Forecast template headers |
CE_FORECAST_OPENING_BAL |
14 | This table stores the opening bank balance or GL cash account balance for a particular Start Date pertaining to a set of forecast results |
CE_FORECAST_PERIODS |
11 | This table stores new column setup information defined by the Automatic Column Setup |
CE_FORECAST_ROWS |
87 | Forecast template rows - forecast sources |
CE_FORECAST_TRX_CELLS |
19 | This table stores transaction level forecast data |
CE_GL_ACCOUNTS_CCID |
30 | This table stores information about code combination ids per your bank account uses. |
CE_HEADER_INTERFACE_ERRORS |
6 | CE_STATEMENT_HEADERS_INT_ALL validation errors |
CE_INTEREST_BAL_RANGES |
10 | This table stores interest balance range information. |
CE_INTEREST_RATES |
10 | This table stores interest rate information. |
CE_INTEREST_SCHEDULES |
13 | This table stores interest rate schedule information. |
CE_INTRA_STMT_HEADERS |
43 | Bank statements |
CE_INTRA_STMT_LINES |
42 | Bank Statement lines |
CE_JE_MAPPINGS |
12 | The CE_JE_MAPPINGS table stores the journal entry mappings information for a bank account. |
CE_JE_MESSAGES |
10 | Table to store the errors occurred during the Journal Entry Creation program execution. |
CE_LEVELING_MESSAGES |
19 | This tables stores the errors generated as a result of the cash leveling process as well as the information about the deals generated as a r |
CE_LINE_INTERFACE_ERRORS |
7 | CE_STATEMENT_LINES_INTERFACE validation errors |
CE_PAYMENT_DOCUMENTS |
37 | This table stores payment document information |
CE_PAYMENT_TEMPLATES |
49 | This table stores payment template information. |
CE_PAYMENT_TRANSACTIONS |
60 | This table stores the bank account transfers |
CE_PROJECTED_BALANCES |
10 | This table stores the projected balances of internal bank accounts. |
CE_PROPOSED_TRANSFERS |
12 | This table stores information about proposed cash leveling transfers. This table will be purged after all Cash Leveling fund transfers (from |
CE_RECONCILIATION_ERRORS |
6 | CE_STATEMENT_LINES validation and reconciliation errors |
CE_SQLLDR_ERRORS |
10 | Bank Statement Loader |
CE_STATEMENT_HEADERS |
64 | Bank statements |
CE_STATEMENT_HEADERS_INT |
46 | Open interface for bank statements |
CE_STATEMENT_LINES |
70 | Bank statement lines |
CE_STATEMENT_LINES_INTERFACE |
38 | Open interface for bank statement lines |
CE_STATEMENT_RECONCILS_ALL |
20 | Statement reconciliation details |
CE_STMT_INT_TMP |
43 | Bank Statement Loader |
CE_SYSTEM_PARAMETERS |
53 | System options |
CE_TRANSACTION_CODES |
38 | Bank transaction codes |
CE_TRXNS_SUBTYPE_CODES |
15 | Transaction Subtype Codes |
CE_TRX_CODES_UTIL_GT |
9 | |
CE_UK_VALIDATIONS_INTERFACE |
19 | The CE_UK_VALIDATIONS_INTERFACE table is the loader target for data from text files provided by Vocalink for UK Domestic Account Validations |
CE_UK_VAL_MODULUS_WEIGHTS |
25 | The CE_UK_VAL_MODULUS_WEIGHTS table stores the modulus weights used for UK Domestic Account Number validations. |
CE_UK_VAL_SUBS_CODES |
9 | The CE_UK_VAL_SUBS_CODES table stores the substitute sorting codes used for UK Domestic Account Number validations. |
CE_UPGA_BANK_ACCOUNTS |
86 | This table is an audit table of CE_UPG_BANK_ACCOUNTS |
CE_UPGA_BANK_REC |
46 | This table is an audit table of CE_UPG_BANK_REC |
CE_UPGA_BA_USES_ALL |
46 | This table is an audit table of CE_UPG_BA_USES_ALL |
CE_UPGA_CONT_POINT_REC |
24 | This table is an audit table of CE_UPG_CONT_POINT_REC |
CE_UPGA_GL_ACCTS_CCID |
30 | This table is an audit table of CE_UPG_GL_ACCOUNTS_CCID |
CE_UPGA_LOC_REC |
23 | This table is an audit table of CE_UPG_LOC_REC |
CE_UPGA_PERSON_REC |
13 | This table is an audit table of CE_UPG_PERSON_REC |
CE_UPGA_RELATION_REC |
22 | This table is an audit table of CE_UPG_RELATIONSHIP_REC |
CE_UPG_AP_ACCTS_TMP |
105 | This table stores AP purged bank account details |
CE_UPG_AP_BANKS_TMP |
88 | This table stores AP purged bank branch details |
CE_UPG_BANK_ACCOUNTS |
94 | This table stores new CE bank account information for bank upgrade purpose |
CE_UPG_BANK_DEPENDS |
11 | This table stores a list of bank dependent product list and product impact information for bank upgrade purpose. |
CE_UPG_BANK_REC |
50 | This table stores organization party information for banks, clearinghouses, bank branches, and clearinghouse branches |
CE_UPG_BA_USES_ALL |
53 | This table stores new CE bank account uses information for bank upgrade purpose |
CE_UPG_CONT_POINT_REC |
25 | This table stores contact points information for bank EDI, email, bank branch EFT, contact phone and fax |
CE_UPG_GL_ACCOUNTS_CCID |
30 | This table stores CCID information of bank account uses for bank upgrade purpose |
CE_UPG_LOC_REC |
23 | This table stores addresses for bank branches including primary address flag |
CE_UPG_PAY_ACCTS_TMP |
44 | This table stores PAY purged bank account details |
CE_UPG_PERSON_REC |
13 | This table stores person party information for bank branch contact or bank account contact |
CE_UPG_PURGE_AP_ACCTS |
17 | This table records all processed AP bank account results for Bank Upgrade Purging program |
CE_UPG_PURGE_AP_BANKS |
13 | This table records all processed AP bank branch results for Bank Upgrade Purging program |
CE_UPG_PURGE_PAY_ACCTS |
13 | This table records all processed PAY external account results for Bank Upgrade Purging program |
CE_UPG_RELATIONSHIP_REC |
22 | This table stores relationship information for bank, bank branch, and bank account contact including job title |
CE_XML_STATEMENT_LIST |
4 | Internal table to store the XML Bank Statements received via the XML Gateway Interface |
CE_ZBA_DEAL_MESSAGES |
16 | This table stores the error or warning messages from ZBA deal creation process |