Previous  Next          Contents  Index  Navigation  Glossary  Library

Bank Statement Open Interface

Before you can reconcile transactions against a bank statement, you need to enter the bank statement information into Cash Management. If your bank provides account statements in a flat file, using a defined format like BAI or SWIFT940, you can use the Bank Statement Open Interface to load this information into Cash Management.

   To use Bank Statement Open Interface:

Note: Cash Management documentation refers to the import program as a SQL*Loader script.

Bank Statement Open Interface Tables

The Bank Statement Open Interface consists of two bank statement open interface tables:

Note: Once you run your SQL*Loader script to populate the open interface tables, you can use Cash Management's AutoReconciliation Import program to validate and transfer the bank statement information into the Cash Management bank statement tables for reconciliation. The bank statement tables are named CE_STATEMENT_HEADERS_ALL and CE_STATEMENT_LINES. Once the information in the interface tables has been successfully transferred to the bank statement tables, you can purge the interface tables.

See Also

Bank Statement Headers Interface Table

Bank Statement Lines Interface Table

Loading Bank Statement Open Interface

Bank Statement Validation

Importing Bank Statements

Correcting Bank Statement Interface Errors

Reconciling Bank Statements Automatically

System Parameters

Archiving and Purging Imported Bank Statements


         Previous  Next          Contents  Index  Navigation  Glossary  Library