Thursday, April 26, 2012

TABLES INVOLVED IN BANK STATEMENT OPEN INTERFACE IN CASH MANAGEMENT



In this post, let us the see the tables related to Bank Statement Open Interface.  


TABLE
DESCRIPTION
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 pre-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 AutoReconciliation 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 AutoReconciliation 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 AutoReconciliation 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 AutoReconciliation program.
You can review the errors on the Bank Statements form or on the AutoReconciliation Execution report.

2 Responses to “TABLES INVOLVED IN BANK STATEMENT OPEN INTERFACE IN CASH MANAGEMENT”

http://buy-pva.com said...
June 14, 2012 at 4:21 AM

Nice post. Thank you
for taking the time to publish this information very useful! I’m still waiting
for some interesting thoughts from your side in your next post thanks!


Sridhar Reddy said...
May 16, 2013 at 6:53 AM

very nice collection it helped me alot thank you...


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.