This function is used to set up the communication types.

  • In the CODA file, communications can be displayed.
    • When the communication is structured, a code of 3 positions indicates the type of communication followed by the communication.
    • The information transmitted in the communication, the number of positions and their meanings vary from one type of communication to the other and are defined at multiple positions in the file CODA.
  • In order to make these intelligible information to the user, it is necessary to set each type of communication.
  • The most common structured communications are delivered in standard mode.
  • When the communication is structured and set up it is possible after import to inquire by right-click the detail of the structured communication in table 2 of the Belgian bank statements function.

Example of structured communications

101: Transfer or payment with structured communication

101

Transfer or payment with structured communication

12 pos N: 10 + 2 (digit 97)

105: Initial amount for the operation

 105

Gross amount expressed in the account currency

15N:  12 positions + 3 decimals

 

Gross amount expressed in the initial currency

15N:  12 positions + 3 decimals

 

Exchange rate

12N: 4 positions + 8 decimals

 

Currency

3AN ISO Currency Code

 

Structured Communication

12AN 

 

Country code of the order giver

2AN ISO Country Code

 

Amount of the counter value in EURO

12N: 12 positions + 3 decimals

108: Closing

 108

Counter value expressed in the account currency

15 N: 12 positions + 3 decimals

 

Rate number, calculation basis

15N

 

Rate

12 N: 4 positions + 8 decimals

 

period from...to

12N: DDMMYYYY DDMMYYYY

Prerequisites

See also Refer to documentation Implementation

Screen management

Entry screen

Block number 1

Type (field COD)

Code of the communication type.
With each communication type the structure and content of the communication varies.
Description (field DES)

Long title of the communication type.

Short description (field DESSHO)

Short title of the communication type.

Grid Details

Title (field DESLIN)

The communication is broken down into several parts: this field corresponds to the title of each part of the communication.

Position (field POS)

The communication is broken down into several parts: this field corresponds to the starting position of each part of the communication.

Length (field LNG)

The communication is broken down into several parts: this field corresponds to the length of each part of the communication.

Formula (field FRM)

With each part of the structured communication, the data format can vary.
The formula field is used to define the format of each part of the communication.
For alphanumeric fields, it is not necessary that this formula field be entered.

Formula fields must be entered as follows:

 Example - 105: Initial amount of the Translation operation in the X3 format:

 105

Gross amount expressed in the account currency

15N:  12 positions + 3 decimals

 

Gross amount expressed in the initial currency

15N:  12 positions + 3 decimals

 

Exchange rate

12N: 4 positions + 8 decimals

 

Currency

3AN ISO Currency Code

 

Structured Communication

12AN 

 

Country code of the order giver

2AN ISO Country Code

 

Amount of the counter value in EURO

12N: 12 positions + 3 decimals

Translation in the X3 format:

Title 

Pos

Long

formula

Gross amount expressed in the account currency

1

15

 format$("N:12.3", val(mid$(TCOMDT,1,15))/1000)

Gross amount in the initial currency

16

15

 format$("N:12.3", val(mid$(TCOMDT,16,15))/1000)

Exchange rate

31

12

 format$("N:4.8", val(mid$(TCOMDT,31,12))/100000000)

Currency

43

3 

 

Structured Communication

46

12

 format$("N:12", mid$(TCOMDT,46,12))

Country code of the order giver

58 

2 

 

Amount of the counter value in EURO

60 

15

 format$("N:12.3", val(mid$(TCOMDT,60,15))/1000)

Example - 108: Closing
 

 108

Counter value expressed in the account currency

15 N: 12 positions + 3 decimals

 

Rate number, calculation basis

15N

 

Rate

12 N: 4 positions + 8 decimals

 

period from...to

12N: DDMMYYYY DDMMYYYY

Translation in the X3 format:

Title 

Pos

Long

formula

Counter value in the
account currency

1

15

 format$("N:12.3", val(mid$(TCOMDT,1,15))/1000)

Rate number, calculation basis

16

15

 format$("N:15", val(mid$(TCOMDT,16,15)))

Rate

31

12

 format$("N:4.8", val(mid$(TCOMDT,31,12))/100000000)

Period from

43

6 

 format$("D:DD[/]MM[/]YY[ ]", mid$(TCOMDT,43,6))

Period to

49

6

 format$("D:DD[/]MM[/]YY", mid$(TCOMDT,49,6))

 

Block number 3

Error messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation