Bank Statement Headers Interface Table
The CE_STATEMENT_HEADERS_INT_ALL table must contain exactly one record for each bank account within a bank statement. If a bank statement contains more than one account, define a header record for each of the accounts on the statement.
The CE_STATEMENT_HEADERS_INT_ALL table contains the following columns:
Column Name
| Null?
| Type
|
STATEMENT_NUMBER
| N
| CHAR
|
BANK_NAME
| Y
| CHAR
|
BANK_BRANCH_NAME
| Y
| CHAR
|
BANK_ACCOUNT_NUM
| N
| CHAR
|
STATEMENT_DATE
| N
| DATE
|
CONTROL_BEGIN_BALANCE
| Y
| NUM
|
CONTROL_END_BALANCE
| Y
| NUM
|
CONTROL_TOTAL_DR
| Y
| NUM
|
CONTROL_TOTAL_CR
| Y
| NUM
|
CONTROL_DR_LINE_COUNT
| Y
| NUM
|
CONTROL_CR_LINE_COUNT
| Y
| NUM
|
CONTROL_LINE_COUNT
| Y
| NUM
|
RECORD_STATUS_FLAG
| Y
| CHAR
|
CURRENCY_CODE
| Y
| CHAR
|
ORG_ID
| Y
| NUM
|
Required Columns
You must provide values for all of the not-null columns in the CE_STATEMENT_HEADERS_INT_ALL table. Enter values in the following required columns:
STATEMENT_NUMBER: The identifier for the statement, as provided by the bank. If the bank does not assign a statement number, you may use the statement date, or any value that will be unique within the bank account.
BANK_ACCOUNT_NUM: The bank account number, as defined in Oracle Receivables and/or Oracle Payables.
STATEMENT_DATE: The closing date for the statement.
ORG_ID: The organization ID, required only for multiple organization environments.
Optional Columns
You may enter values in the following optional columns of the CE_STATEMENT_HEADERS_INT_ALL table:
BANK_NAME: The name of the bank, as defined in Oracle Receivables and/or Oracle Payables.
BANK_BRANCH_NAME: The name of the bank branch, as defined in Oracle Receivables and/or Oracle Payables.
CONTROL_BEGIN_BALANCE: The beginning balance for the statement, as provided by the bank.
CONTROL_END_BALANCE: The ending balance for the statement, as provided by the bank.
CONTROL_TOTAL_DR: Total Debits for the statement.
CONTROL_TOTAL_CR: Total Credits for the statement.
CONTROL_DR_LINE_COUNT: Number of debit lines for the statement.
CONTROL_CR_LINE_COUNT: Number of credit lines for the statement.
CONTROL_LINE_COUNT: Total number of lines for the statement.
RECORD_STATUS_FLAG: Set to E if there is an error in the record. Set to N if the record is new.
CURRENCY_CODE: The currency code for the bank account.
See Also
Bank Statement Open Interface
Bank Statement Lines Interface Table
Bank Statement Validation
Loading Bank Statement Open Interface
Importing Bank Statements
Correcting Bank Statement Interface Errors
Reconciling Bank Statements Automatically
System Parameters
Archiving and Purging Imported Bank Statements