CM (Cash Managment) Key Tables in APPS R12

CE_BANK_STMT_INT_MAP:

         Stores the definitions of the mapping templates.

CE_BANK_STMT_MAP_HDR:

         This table maps the columns the Bank Statement Headers Interface table (CE_STATEMENT_HEADERS_INT_ALL) to the columns in the intermediate table (CE_STMT_INT_TMP).

CE_BANK_STMT_MAP_LINE:

     Maps the columns in the Bank Statement Lines Interface table (CE_STATEMENT_LINES_INTERFACE) to the columns in the intermediate table (CE_STMT_INT_TMP).

CE_TRANSACTION_CODES:

      This table stores per-determined codes between you and your bank to identify the types of transactions for matching statement lines. For automatically created statement lines, a transaction code defines the rules for creating these statement lines. Each transaction code is associated with a bank account.
CREATE_MISC_TRX_FLAG specifies whether a miscellaneous transaction, such as charges, should be created for statement lines during the automatic reconciliation process.
This table corresponds to the Bank Transaction Codes form.  

CE_STMT_INT_TMP:

      Intermediate table, which stores the information loaded from a bank statement file. This table is populated by the SQL*Loader script.

CE_SQLLDR_ERRORS:

          Records the errors encountered by the Bank Statement Loader program when loading data from the bank statement file into the intermediate table.

CE_STATEMENT_HEADERS_INT_ALL:

         The CE_STATEMENT_HEADERS_INT_ALL table stores information about bank statement details for importing. Each row contains the bank statement number, bank account number, control balances, and other statement- related information. After populating this table, you can run the Bank Statement Import program to transfer the statement information into the CE_STATEMENT_HEADERS_ALL table.
The Bank Statement Interface form allows you to modify the statement interface information or to correct any errors encountered while uploading the data.

CE_STATEMENT_LINES_INTERFACE:

       This table stores information about bank statement line details for open interface. Each row contains the bank statement number, bank account number, statement line amount, and others. After populating this table, you can run the Bank Statement Import program to transfer the statement line information into the CE_STATEMENT_LINES table.
The Bank Statement Interface form allows you to modify the statement line interface information or correct any errors encountered while uploading the data.

CE_HEADER_INTERFACE_ERRORS:

          This table stores information about errors that occurred while importing bank statements. Each row includes the statement number, bank account number, and error message name for retrieving the actual error messages. A record is written to this table for each error while running the Bank Statement Import program.
You can review the errors on the Bank Statement Interface form or on the Auto Reconciliation Execution report .

CE_LINE_INTERFACE_ERRORS:

         This table stores information about errors that occurred while importing bank statement lines. Each row includes statement number, statement line number, bank account number, and error message name for retrieving the actual error messages. A record is written to this table for each error while running the Bank Statement Import program.
You can review the errors on the Bank Statement Interface form or on the Auto Reconciliation Execution report.

CE_ARCH_INTERFACE_HEADERS:

        This 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 Auto Reconciliation program once you enable your system options to automatically purge and archive statement interface tables.  

CE_STATEMENT_HEADERS_ALL:

          This 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_STATEMENT_LINES:

      This 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.

CE_STATEMENT_RECONCILS_ALL:

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

CE_RECONCILIATION_ERRORS:

       This table stores information about errors that occurred while reconciling a bank statement. Each row includes the statement line identifier and error message name for retrieving the actual error messages. A record is written to this table for each error while running the Auto Reconciliation program.
You can review the errors on the Bank Statements form or on the Auto Reconciliation Execution report.