Oracle Apps Cash Mgmt Tables...Useful

 

TABLES in Cash Mgmt:

 

CE_BANK_ACCOUNTS:

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

CE_BANK_ACCT_USES_ALL:

CE_BANK_ACCT_USES_ALL stores Operating Unit level bank account use information.

CE_GL_ACCOUNTS_CCID: 

CE_GL_ACCOUNTS_CCID stores information about code combination ids per your bank account uses

 CE_INTEREST_RATES:

This table stores interest rate information  

CE_INTEREST_SCHEDULES:

This table stores interest schedule information

 CE_BANK_ACCT_BALANCES:

This table stores the internal bank account balances. 

CE_PROJECTED_BALANCES:

This table stores the projected balances of internal bank accounts.

CE_CASHFLOWS:

Table for storing Cashflows

CE_PAYMENT_TRANSACTIONS: 

Table for storing Bank Account Transfer 

CE_PAYMENT_TEMPLATES:

Table for storing payment templates 

CE_TRXNS_SUBTYPE_CODES:

Table for storing transaction subtype codes 

CE_CONTACT_ASSIGNMENTS:

This table contains the information about which level  (bank, branch, account) the contact is assigned to.

CE_AP_PM_DOC_CATEGORIES: 

This table stores payment document categories and payment methods for bank account uses

CE_PAYMENT_DOCUMENTS: 

This table stores payment document information.

CE_SECURITY_PROFILES_GT:

CE.CE_SECURITY_PROFILES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

CE_AVAILABLE_TRANSACTIONS_TMP: 

CE.CE_AVAILABLE_TRANSACTIONS_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

CE_CHECKBOOKS: 

This table stores payment check book information.

CE_STATEMENT_RECONCILS_ALL: 

The CE_STATEMENT_RECONCILS_ALL table stores information about reconciliation history or audit trail. Each row represents an action performed against a statement line.

CE_ARCH_RECONCILIATIONS_ALL:

The CE_ARCH_RECONCILIATIONS_ALL table stores information about archived statement reconciliation details. A row in this table corresponds to an archived CE_STATEMENT_RECONCILES_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive.

CE_ARCH_HEADERS:

The CE_ARCH_HEADERS_ALL table stores archived statement header information. Each row in this table corresponds to an archived CE_STATEMENT_HEADERS_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive.

CE_ARCH_INTRA_HEADERS: 

The CE_ARCH_INTRA_HEADERS_ALL table stores archived intra-day statement header 
information. Each row in this table corresponds to an archived CE_INTRA_STMT_HEADERS_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive.

CE_ARCH_INTERFACE_HEADERS: 

The CE_ARCH_INTERFACE_HEADERS_ALL table stores archived statement interface information. Each row in this table corresponds to an archived CE_STATEMENT_HEADERS_INT_ALL record. This table is populated when you run the Archive/Purge Bank Statements program and choose to archive, or by the AutoReconciliation program once you enable your system options to automatically purge and archive statement interface tables.

CE_INTRA_STMT_HEADERS:

The CE_INTRA_STMT_HEADERS_ALL table stores intra-day bank statement header information. Each row in this table contains the statement date, statement number, bank account identifier, and other information about the intra-day statement.

CE_STATEMENT_HEADERS: 

The CE_STATEMENT_HEADERS_ALL table stores bank statements. Each row in this table contains the statement name, statement date, GL date, bank account identifier, and other information about the statement. This table corresponds to the Bank Statement window of the Bank Statements form.
Once you have marked your statement as complete, the STATEMENT_COMPLETE_FLAG is set to Y, and you can no longer modify or update the statement.
AUTO_LOADED_FLAG is set to Y when your statement is uploaded from the interface table using the Bank Statement Import program.

CE_CASHPOOLS:

This table stores header information about the cash pool 

CE_STATEMENT_LINES:

The CE_STATEMENT_LINES table stores information about bank statement lines. Each row in this table stores the statement header identifier, statement line number, associated transaction type, and transaction amount associated with the statement line. 
This table corresponds to the Bank Statement Lines window of the Bank Statements form.
 

 

 

Cash Mgmt (CE) Tables List
CE_UPG_BANK_ACCOUNTS
CE_UPGA_BA_USES_ALL
CE_UPG_BANKS_GT
CE_UPG_GL_ACCOUNTS_CCID
CE_UPGA_BANK_REC
CE_UPGA_CONT_POINT_REC
CE_UPG_BA_USES_ALL
CE_UPGA_LOC_REC
CE_UPGA_RELATION_REC
CE_UPGA_BANK_ACCOUNTS
CE_UPGA_PERSON_REC
CE_UPGA_GL_ACCTS_CCID
CE_UPG_AP_ACCTS_TMP
CE_UPG_AP_BANKS_TMP
CE_UPG_PAY_ACCTS_TMP
CE_XML_STATEMENT_LIST
CE_AVAILABLE_TRANSACTIONS_TMP
CE_LINE_INTERFACE_ERRORS
CE_LOOKUPS_OLD
CE_RECONCILIATION_ERRORS
CE_SQLLDR_ERRORS
CE_STATEMENT_HEADERS
CE_STATEMENT_HEADERS_ALL_EFC
CE_STATEMENT_HEADERS_INT
CE_STATEMENT_LINES
CE_STATEMENT_LINES_EFC
CE_STATEMENT_LINES_INTERFACE
CE_STATEMENT_RECONCILS_ALL
CE_STMT_BANK_ACCNT_EFC
CE_STMT_INT_TMP
CE_SYSTEM_PARAMETERS
CE_TRANSACTION_CODES
CE_ARCH_HEADERS
CE_ARCH_INTERFACE_HEADERS
CE_ARCH_INTERFACE_LINES
CE_ARCH_INTRA_HEADERS
CE_ARCH_INTRA_LINES
CE_ARCH_LINES
CE_ARCH_RECONCILIATIONS_ALL
CE_ARCH_RECON_ERRORS
CE_BANK_ACCOUNTS
CE_BANK_ACCT_USES_ALL
CE_BANK_STMT_INT_MAP
CE_BANK_STMT_MAP_HDR
CE_BANK_STMT_MAP_LINE
CE_CURRENCY_RATES_TEMP
CE_DOC_SEQUENCE_AUDIT
CE_FORECASTS
CE_FORECAST_CELLS
CE_FORECAST_COLUMNS
CE_FORECAST_ERRORS
CE_FORECAST_ERRORS_OLD
CE_FORECAST_EXT_TEMP
CE_FORECAST_EXT_VIEWS
CE_FORECAST_HEADERS
CE_FORECAST_ROWS
CE_GL_ACCOUNTS_CCID
CE_HEADER_INTERFACE_ERRORS
CE_INTRA_STMT_HEADERS
CE_INTRA_STMT_LINES
CE_SYSTEM_PARAMETERS_A
CE_CP_WORKSHEET_USER_LINES
CE_TRX_CODES_UTIL_GT
CE_INTEREST_BAL_RANGES
CE_INTEREST_RATES
CE_INTEREST_SCHEDULES
CE_CHECKBOOKS
CE_PAYMENT_DOCUMENTS
CE_CONTACT_ASSIGNMENTS
CE_INT_CALC_DETAILS_GT
CE_SECURITY_PROFILES_GT
CE_JE_MAPPINGS
CE_JE_MESSAGES
CE_ZBA_DEAL_MESSAGES
CE_PROPOSED_TRANSFERS
CE_LEVELING_MESSAGES
CE_CE_TRANSACTION_CODES
CE_CE_STATEMENT_HEADERS
CE_CE_ARCH_HEADERS
CE_CE_ARCH_INTRA_HEADERS
CE_CE_INTRA_STMT_HEADERS
CE_CE_FORECAST_ROWS
CE_CE_FC_OPENING_BAL
CE_CE_FORECAST_TRX_CELLS
CE_CE_CP_WORKSHEET_LINES
CE_CE_CASHPOOLS
CE_CE_CASHPOOL_SUB_ACCTS
CE_BANK_ACCT_BALANCES
CE_CASHFLOWS
CE_PROJECTED_BALANCES
CE_CASHFLOW_ACCT_H
CE_PAYMENT_TRANSACTIONS
CE_PAYMENT_TEMPLATES
CE_TRXNS_SUBTYPE_CODES
CE_AP_PM_DOC_CATEGORIES
CE_CE_BA_SIGNATORIES
CE_CE_CP_PD_BALANCES
CE_CE_JE_MAPPINGS
CE_SYSTEM_PARAMETERS_ALL_A
CE_BA_SIGNATORIES
CE_CASHPOOLS
CE_BA_SIGNATORY_HIST_H
CE_CASHPOOL_SUB_ACCTS
CE_FORECAST_PERIODS
CE_FORECAST_OPENING_BAL
CE_CP_TRX_EXCLUDED
CE_CP_WORKSHEET_HEADERS
CE_CP_WORKSHEET_LINES
CE_UPG_PAY_ACCTS_GT
CE_CP_PRIORDAY_BALANCES
CE_BANK_UPGRADE_MODES
CE_FORECAST_TRX_CELLS
CE_BANK_UPGRADE_ERRORS
CE_UPG_BANK_DEPENDS
CE_UPG_PURGE_AP_ACCTS
CE_UPG_PURGE_AP_BANKS
CE_UPG_PURGE_PAY_ACCTS
CE_UPG_BANK_REC
CE_UPG_CONT_POINT_REC
CE_UPG_PERSON_REC
CE_UPG_LOC_REC
CE_UPG_RELATIONSHIP_REC
CE_UPG_BANK_ACCTS_GT