CODA Statement Line Table

Specifies the coded bank account statement that is generated from an imported CODA file.

Each coded bank account statement is composed of a header and several detailed lines. The header contains information such as the statement number, bank account number, and ending balance of the statement. The lines contain all the transactions that have been imported.

In order to identify a transaction unambiguously, a code has been assigned to each transaction. This code consists of 8 numeric positions.

Position	Description
Position 2 + 3	= Transaction Family
Position 4 + 5	= Transaction
Position 6 + 7 + 8	= Transaction Category

The imported CODA file uses data from the Transaction Coding table. The data in this table is initialized, but you can modify it manually.

When you post a coded bank account statement in a financial journal, the data in this table is deleted. In that case you can only make modifications in the financial journal.

List of Fields in the Table

The following table lists the fields in this table.

Field	Location
System-Created Entry Field, CODA Statement Line Table	Belgium Local Functionality
Posting Date Field, CODA Statement Line Table	Belgium Local Functionality
Bank Account No. Other Party Field, CODA Statement Line Table	Belgium Local Functionality
Statement Amount Field, CODA Statement Line Table	Belgium Local Functionality
Line No. Field, CODA Statement Line Table	Belgium Local Functionality
Account Name Field, CODA Statement Line Table	Belgium Local Functionality
Application Status Field, CODA Statement Line Table	Belgium Local Functionality
Original Transaction Currency Field, CODA Statement Line Table	Belgium Local Functionality
Account No. Field, CODA Statement Line Table	Belgium Local Functionality
Statement No. Field, CODA Statement Line Table	Belgium Local Functionality
Information Field, CODA Statement Line Table	Belgium Local Functionality
Internal Codes Other Party Field, CODA Statement Line Table	Belgium Local Functionality
Transaction Family Field, CODA Statement Line Table	Belgium Local Functionality
ID Field, CODA Statement Line Table	Belgium Local Functionality
Currency Factor Field, CODA Statement Line Table	Belgium Local Functionality
Document No. Field, CODA Statement Line Table	Belgium Local Functionality
Journal Batch Name Field, CODA Statement Line Table	Belgium Local Functionality
Transaction Type Field, CODA Statement Line Table	Belgium Local Functionality
Journal Template Name Field, CODA Statement Line Table	Belgium Local Functionality
SWIFT Address Field, CODA Statement Line Table	Belgium Local Functionality
Original Transaction Amount Field, CODA Statement Line Table	Belgium Local Functionality
Bank Reference No. Field, CODA Statement Line Table	Belgium Local Functionality
Transaction Category Field, CODA Statement Line Table	Belgium Local Functionality
Amount Field, CODA Statement Line Table	Belgium Local Functionality
Amount (LCY) Field, CODA Statement Line Table	Belgium Local Functionality
Message Type Field, CODA Statement Line Table	Belgium Local Functionality
Type Field, CODA Statement Line Table	Belgium Local Functionality
Statement Line No. Field, CODA Statement Line Table	Belgium Local Functionality
Address Other Party Field, CODA Statement Line Table	Belgium Local Functionality
Statement Message (cont.) Field, CODA Statement Line Table	Belgium Local Functionality
Globalisation Code Field, CODA Statement Line Table	Belgium Local Functionality
Transaction Field, CODA Statement Line Table	Belgium Local Functionality
Unapplied Amount Field, CODA Statement Line Table	Belgium Local Functionality
Name Other Party Field, CODA Statement Line Table	Belgium Local Functionality
Attached to Line No. Field, CODA Statement Line Table	Belgium Local Functionality
Currency Code Field, CODA Statement Line Table	Belgium Local Functionality
Ext. Reference No. Field, CODA Statement Line Table	Belgium Local Functionality
Ext. Acc. No. Other Party Field, CODA Statement Line Table	Belgium Local Functionality
Statement Message Field, CODA Statement Line Table	Belgium Local Functionality
Application Information Field, CODA Statement Line Table	Belgium Local Functionality
City Other Party Field, CODA Statement Line Table	Belgium Local Functionality
Bank Account No. Field, CODA Statement Line Table	Belgium Local Functionality
Transaction Date Field, CODA Statement Line Table	Belgium Local Functionality
Description Field, CODA Statement Line Table	Belgium Local Functionality
Applies-to ID Field, CODA Statement Line Table	Belgium Local Functionality
Type Standard Format Message Field, CODA Statement Line Table	Belgium Local Functionality
Account Type Field, CODA Statement Line Table	Belgium Local Functionality
Document Type Field, CODA Statement Line Table	Belgium Local Functionality
Customer Reference Field, CODA Statement Line Table	Belgium Local Functionality

See Also

Tasks

How to: Import CODA Statements

Reference

Import CODA Statement
CODA Statement - Test