Bank Statement Lines Interface Table
The CE_STATEMENT_LINES_INTERFACE table contains the transactions from the bank statement. It contains the following columns:
Column Name
| Null?
| Type
|
BANK_ACCOUNT_NUM
| N
| CHAR
|
STATEMENT_NUMBER
| N
| CHAR
|
LINE_NUMBER
| N
| NUMBER
|
TRX_DATE
| N
| DATE
|
TRX_CODE
| Y
| CHAR
|
EFFECTIVE_DATE
| Y
| DATE
|
TRX_TEXT
| Y
| CHAR
|
INVOICE_TEXT
| Y
| CHAR
|
AMOUNT
| Y
| NUMBER
|
CURRENCY_CODE
| Y
| CHAR
|
EXCHANGE_RATE
| Y
| NUMBER
|
EXCHANGE_RATE_DATE
| Y
| DATE
|
USER_EXCHANGE_RATE_TYPE
| Y
| CHAR
|
ORIGINAL_AMOUNT
| Y
| NUMBER
|
BANK_TRX_NUMBER
| Y
| CHAR
|
CUSTOMER_TEXT
| Y
| CHAR
|
BANK_ACCT_TEXT
| Y
| CHAR
|
Required Columns
You must provide values for all of the not-null columns in the CE_STATEMENT_LINES_INTERFACE table. Enter values in the following required columns:
BANK_ACCOUNT_NUM: For each statement line, enter the bank account number, as defined in the header record in CE_STATEMENT_HEADERS_INT_ALL.
STATEMENT_NUMBER: For each statement line, enter the bank statement number, as defined in the header record in CE_STATEMENT_HEADERS_INT_ALL
LINE_NUMBER: For each statement line, enter the line number, as provided by the bank. If the bank does not provide line numbers, you may use a sequence to assign line numbers. The line numbers must be unique within the bank statement.
TRX_DATE: The date of the bank transaction.
Optional Columns
You may enter values in the following optional columns of the CE_STATEMENT_LINES_INTERFACE table:
TRX_CODE: The Bank Transaction Code that the bank uses to identify the type of banking transaction. If you do not enter a bank transaction code, AutoReconciliation may import the record, but cannot reconcile it.
EFFECTIVE_DATE: The Effective Date for the transaction.
TRX_TEXT: Any transaction-related text provided by the bank.
INVOICE_TEXT: This is the statement line invoice number, which is used to match statement lines to invoice numbers for payments in Payables and receipts in Receivables.
AMOUNT: The amount of the transaction, in the bank account currency.
CURRENCY_CODE: The currency code for the transaction.
EXCHANGE_RATE: The exchange rate specified by the bank for the transaction.
EXCHANGE_RATE_DATE: The date associated with the exchange rate used.
USER_EXCHANGE_RATE_TYPE: The exchange rate type (defined in Oracle General Ledger) used for this transaction.
ORIGINAL_AMOUNT: The amount of the transaction, expressed in its original currency.
BANK_TRX_NUMBER: The Bank Transaction Number. This is the payment document number or deposit number, which AutoReconciliation uses to match the bank transaction with a transaction or batch. If you do not provide a transaction number AutoReconciliation may import the record, but cannot reconcile it.
CUSTOMER_TEXT: Any customer-related text provided by the bank. AutoReconciliation does not use this information; it is for reference use only.
BANK_ACCT_TEXT: Agent's bank account. AutoReconciliation uses this information to match transactions along with INVOICE_TEXT.
See Also
Bank Statement Open Interface
Bank Statement Headers 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
Defining Conversion Rate Types