Tables Involved CM Reconciliation Process

1) Run the program- Bank Statement Loader to load data in following Open Interface tables

CE_STATEMENT_HEADERS_INT_ALL (Stores Information about bank statement Header details)

CE_STATEMENT_LINES_INTERFACE (Stores Information about bank statement Line details)

 

2) Run the program- Bank Statement Import to load data in following Base tables from Interface tables.

CE_STATEMENT_HEADERS

CE_STATEMENT_LINES

 

3) Error information is stored in following tables while running Bank Statement Import

 

CE_HEADER_INTERFACE_ERRORS

CE_LINE_INTERFACE_ERRORS

 

4) Run the program – AutoReconciliation which in turn calls AutoReconciliation Execution Report (CEXINERR)

(AutoReconciliation –> CE_AUTO_BANK_REC.statement –> CE_AUTO_BANK_MATCH.match_process)

 

5) Error information is stored in following table while running AutoReconciliation Program

 

CE_RECONCILIATION_ERRORS

 

6) Reconciliation history or audit trail is stored in table– CE_STATEMENT_RECONCILS_ALL. Each row represents an action performed against a statement line.

 

7) Transactions from all the views below are consolidated into CE_AVAILABLE_TRANSACTIONS_V for bank statement reconcillation

 

CE_101_TRANSACTIONS_V — GL journal entry lines

 

CE_185_TRANSACTIONS_V — Treasury Transactions

 

CE_200_TRANSACTIONS_V — AP payments

 

CE_222_TRANSACTIONS_V — AR cash receipts

 

CE_260_TRANSACTIONS_V — Bank statement lines available for reconciling bank errors

 

CE_801_TRANSACTIONS_V — Payroll payments