Setup > A/P-A/R accounting > Files > Communication types 

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

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Fields

    The following fields are present on this tab :

    Block number 1

    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

    Close

     

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation