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. |
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
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.
1 Responses to “TABLES INVOLVED IN BANK STATEMENT OPEN INTERFACE IN CASH MANAGEMENT”
May 16, 2013 at 6:53 AM
very nice collection it helped me alot thank you...
Post a Comment