Once a year the IRAP form (formerly the ISI form) must be submitted to the DNB by trustoffices.
The IRAP form can partly be filled automatically by Mill7.
Mill7 only supports the last year of the form.
Since may 2022 that is the IRAP form 2022 with reference date December 31, 2021.
The IRAP functionality is started from the custom menu.
To enable the IRAP form function the following line must be added to the custom menu: IRAP form, maatwerk.exe /ISIFORM.
The text before the comma is free. The text after the comma is obliged like given here.
If you have any questions about the function or if you want support in setting up the database, please contact our helpdesk.
In this chapter the following topics are described:
1.New in IRAP 2022
2.General explanation filling in IRAP form
6.IRAP form explanation per question
1.Start screen
a.At the start screen separate book years can be chosen for answering questions concerning the actual situation and questions concerning the situation at reference date.
b.The trust office where for the IRAP is filled in can be chosen from a list of offices, as well entered manually.
2.New questions
a.1.1.1.4
This question is not supported and must be entered manually.
b.3.2.3
This question is filled automatically like question 3.2.2.
3.Changed questions
a.2.1.4.4, 2.1.4.5 and 2.1.8 UBO's and PEP's
The nationality is determined by the persons fields Nationality and Nationality2.
b.1.2.2.x and 1.3.1.x
When filling in the Name and Land code, the persons encrypted data is taken in account.
c.2.1.5.1
For this questions the file, field and code list to be used can be set in the parameter file.
General explanation filling in IRAP form
The IRAP form is filled in with data from the Mill7 database: Firms, Persons and relation management in the main service company.
In this documentation the data used from the relation management database are described with a file number and a field number.
For example F111-36 means field 36 in file 111.
The default report General> Relation management fields gives an overview of all available files and fields.
Which files and fields are used can be set up with the Supervisor functions Relation management settings Files and Fields.
The following questions are not (yet) supported. These questions must be answered manually.
1.1.1.4
1.4.1 to 1.4.2
1.5.1 to 1.5.8
1.6.1 to 1.6.3
2.1.5.3, 2.1.5.7, 2.1.5.8.a, 2.1.5.10 and 2.1.5.11
2.1.6.2 to 2.1.6.4
2.1.7.31 and 2.1.7.32
3.2.1
Part 4
Part 5
The IRAP form is filled in with data from the Mill7 database and shown in an temporary excel file.
The excel file can be adjust manually and saved for later use.
Do not save this file in the Mill7\Reports folder.
A saved IRAP form can be selected at the start screen to be filled in again.
Only supported fields will be overwritten.
This way it is possible to fill in the form in stages.
For each question the answer is based on one or more selection criteria.
Some of these criteria can be manually manipulated by changing the parameter file.
General criteria
1.For the chosen service company on the start screen applies the following rules:
a.the service company must exist as a Company with Type = SRV
b.the setting Relation management on the Companies screen must be active
c.the relation management file F111 must exist
2.A relation is only included when
a.the setting Relation management on the Companies screen is active
b.the relation management file F111 exist
c.the field 111-36 matches the service company on the start screen
d.the field F111-15 is within the range set in menu Maintenance> Settings> Invoicing> Miscel. invoicing.
3.Land codes must be entered in the two characters ISO 3166-1 country code.
Current bookyear
Select the bookyear to be used for questions concerning the actual situation.
Past bookyear
Select the bookyear to be used for questions concerning the situation at the reference date.
Contact Person
This is the contact person for DNB. Name, function, telephone numbers and e-mail address of this person will be placed in the form.
Service company
Select the service company where for the form is filled in.
Trust Office
This is automatically filled when the name of the service company exist in the DNB table.
The field can also be filled by selecting a value from the table.
When the correct name is not in the table the field can manually entered in the form at question 1.1.1.1.
IRAP form
Select the Excel file that serves as a template for storing the data.
This could be
•the default IRAP form IRAP_form_2022.xlsx in the Mill7\reports folder
•the IRAP form downloaded from the DNB website
•an already filled and saved IRAP form
<Start>
The form will be filled and opened in an excel file.
<Edit Parameter file>
The parameter file will be opened in excel.
When a file is found in the Mill7\reports\custom folder, that file will be opened.
Otherwise the default file from the Mill7\reports folder will be opened.
For some questions it is possible to change the database settings used to answer the question.
These settings are saved in the parameter file.
This file, IRAP_form_parameters_2022.xls is provided in the Mill7\reports folder.
The file can be opened for viewing or editing by using the <Edit parameter file> button.
After changing the parameters the file can be saved to be used instead the default file.
The changed file must be saved in the Mill7\reports\custom folder with the same name, IRAP_form_parameters_2022.xls.
NOTE: Do not add or delete lines or columns.
There are 3 kinds of parameters, recognizable by their name:
1.Ending with _FILE
At this parameter a relation management file can be set in column C
2.Ending with _FIELD
At this parameter a relation management field can be set in column C.
The field must exist for the default file to be used for the question.
When there is also a _FILE parameter the field must exist for the that file.
3.Ending with _LIST
At this field selection values can be entered in the columns C and further.
The values must appear in the table belonging to the File-Field to be used for the relevant question.
Format Parameter file
Column A
This is the question number as used in the IRAP form.
This column may not be changed.
Column B
This is the parameter name.
This column may not be changed.
Column C and further
These columns are the only ones which can be changed.
Which column is used depends on the type of the parameter.
1.Ending with _FILE: only column C
2.Ending with _FIELD: only column C
3.Ending with _LIST: column C to V
Example 1.
Question 2.1.5.02. Relations qualifying as BFI
A |
B |
C |
D |
E |
F |
G |
2.1.5.2 |
BFI_FILE |
125 |
||||
2.1.5.2 |
BFI_FIELD |
19 |
||||
2.1.5.2 |
BFI_CODE_LIST |
1 |
Based on these parameters only relations with a value '1' in field 19 of relation management file F125 are taken in account.
Example 2:
Question 3.1.1. services offered by the trust office: being a director/partner
A |
B |
C |
D |
E |
F |
G |
3.1.1 |
MAN_SERVICES_CODE_LIST |
MAN |
DIR |
For this question there are no FILE and _FIELD parameter available.
The questions is always answered using field 7 from file 117. (see topic IRAP form per question)
Based on the _LIST parameter only relations with the value MAN or DIR in field 7 of relation management file F117 are taken in account.
This list of files and fields corresponds with the default used files/fields and with the files/fields used in the default parameter file.
Companies
•Search name
Persons
•Search name
•Function
•Tel mobile
•Tel. work direct
•Country
•Nationality
•2e nationality
Relation management files and fields
TIP: Use the default report General> Relation management fields to check the name of files and fields.
When there is no value in one of the columns Tabpage, Column or Line the field is not in use.
F110 Management
F110-5
F110-7
F110-10
F110-11
F110-16
F111 General
F111-15
F111-22
F111-24
F111-36
F111-42
F111-48
F113 Bank Qualifications
F113-6
F113-7
F113-13
F114 Advisors
F114-8
F114-9
F114-10
F115 Other relations
F115-8
F115-11
F115-12
F116 Trust employees
F116-7
F117 Services and fees
F117-7
F121 Shares
F121-5
F121-9
F121-19
F121-34
F124 Activities
F124-6
F124-8
F124-16
F124-17
F125 Administrative
F125-19
F131 Charges
F131-6
F132 Market info
F132-8
F136 UBOS
F136-8
F136-10
F136-27
F136-28
F144 Compliance documents
F144-8
F144-10
F144-12