Predictions are activated when the corresponding tables are present

Header fields

Field	Description	Data type
Insured name	Full name of the person insured	string
Insured Birthdate	Date of birth of the person insured	date
Insured NISZ	National insurance number of the person insured	string
Addressee House number	House number of the person insured	string
Addressee Zip code	Postal code of the person insured	integer
Invoice Type	Type of the invoice: `invoice`/`ambulant`/`other`	tag
Credit Note	Credit note: `yes`/`no`	tag
Invoice id	Unique identification of the invoice	string
Invoice date	The date when the invoice was issued	date
Hospital id	Unique identification of the hospital invoice	string
Date in	The date when the treatment period of the person insured starts	date
Date out	The date when the treatment period of the person insured ends	date
Gross amount	Gross amount of the hospital invoice	float
Tax amount	Tax amount of the hospital invoice	float

Line items

Frais du Séjour / Verblijfskosten

Table name: Frais du Séjour / Verblijfskosten

Column	Description	Data type
Bedroom type	Description of the bedroom the patient occupied	string
Date from	Date when the patient started occupying the room	date
Date to	Date when the patient left the room	date
Number of units	Quantity of service units given	integer
nomenclature code	Unique code of the service given	alphanumeric
MUT amount	Amount refunded by the mutuality	float
PA amount	Amount to be paid by the patient	float
SUP amount		float

Montants forfaitaires / Forfaitaire kosten

Table name: Montants forfaitaires / Forfaitaire kosten

Column	Description	Data type
description	Description of the service given	string
MUT amount	Amount refunded by the mutuality	float
PA amount	Amount to be paid by the patient	float
SUP amount		float

Pharmacie / Apotheek

Table name: Pharmacie / Apotheek

Column	Description	Data type
description	Description of the service given	string
CNK code	National Code Number assigned to all the pharmaceutical products used for the treatment	alphanumeric
Number of units	Quantity of service units given	integer
nomenclature code	Unique code of the service given	alphanumeric
Notification Code		alphanumeric
MUT amount	Amount refunded by the mutuality	float
PA amount	Amount to be paid by the patient	float
SUP amount		float

Honoraires / Honoraria

Table name: Honoraires / Honoraria

Column	Description	Data type
description	Description of the service given	string
Date from	Date when the patient was treated	date
nomenclature code	Unique code of the service given	alphanumeric
Number of units	Quantity of service units given	integer
MUT amount	Amount refunded by the mutuality	float
PA amount	Amount to be paid by the patient	float
SUP amount		float

Autres fournitures / Andere leveringen

Table name: Autres fournitures / Andere leveringen

Column	Description	Data type
nomenclature code	Unique code of the service given	alphanumeric
description	Description of the service given	string
Number of units	Quantity of service units given	integer
MUT amount	Amount refunded by the mutuality	float
PA amount	Amount to be paid by the patient	float

Transport / Ziekenvervoer

Table name: Transport / Ziekenvervoer

Column	description	Data type
Date from	Date when the patient was offered the transportation service	date
nomenclature code	Unique code of the service given	alphanumeric
Number of units	Description of the service given	string
description	Quantity of service units given	integer
MUT amount	Amount refunded by the mutuality	float
PA amount	Amount to be paid by the patient	float

Frais Divers / Diverse kosten

Table name: Frais Divers / Diverse kosten

Column	Description	Data type
nomenclature code	Unique code of the service given	alphanumeric
description	Description of the service given	string
Number of units	Quantity of service units given	integer
PA amount	Amount to be paid by the patient	float

Payment Details

Table name: Payment Details

Column	Description	Data type
payment_amount	Amount to be paid	float
payment_iban	IBAN account to send the payment to	alphanumeric
payment_reference	Reference linked to the payment	string

Totals

Table name: Totals

Column	Description	Data type
Section	=rubriek
MUT amount	Total amount refunded by the mutuality	float
PA amount	Total amount to be paid by the patient	float
SUP amount		float

Example computed fields

Field	Formula
SUM CHECK SUP	EQUAL( ADD($Frais du Séjour / Verblijfskosten.SUP amount$1:$Frais du Séjour / Verblijfskosten.SUP amount$$, $Montants forfaitaires / Forfaitaire kosten.SUP amount$1:$Montants forfaitaires / Forfaitaire kosten.SUP amount$$, $Pharmacie / Apotheek.SUP amount$1:$Pharmacie / Apotheek.SUP amount$$, $Honoraires / Honoraria.SUP amount$1:$Honoraires / Honoraria.SUP amount$$), ADD($Totals.SUP amount$1:$Totals.SUP amount$$) )
SUM CHECK MUT	EQUAL( ADD($Frais du Séjour / Verblijfskosten.MUT amount$1:$Frais du Séjour / Verblijfskosten.MUT amount$$, $Montants forfaitaires / Forfaitaire kosten.MUT amount$1:$Montants forfaitaires / Forfaitaire kosten.MUT amount$$, $Pharmacie / Apotheek.MUT amount$1:$Pharmacie / Apotheek.MUT amount$$, $Honoraires / Honoraria.MUT amount$1:$Honoraires / Honoraria.MUT amount$$, $Autres fournitures / Andere leveringen.MUT amount$1:$Autres fournitures / Andere leveringen.MUT amount$$, $Transport / Ziekenvervoer.MUT amount$1:$Transport / Ziekenvervoer.MUT amount$$), ADD($Totals.MUT amount$1:$Totals.MUT amount$$) )
SUM CHECK PA	EQUAL( ADD($Frais du Séjour / Verblijfskosten.PA amount$1:$Frais du Séjour / Verblijfskosten.PA amount$$, $Montants forfaitaires / Forfaitaire kosten.PA amount$1:$Montants forfaitaires / Forfaitaire kosten.PA amount$$, $Pharmacie / Apotheek.PA amount$1:$Pharmacie / Apotheek.PA amount$$, $Honoraires / Honoraria.PA amount$1:$Honoraires / Honoraria.PA amount$$, $Autres fournitures / Andere leveringen.PA amount$1:$Autres fournitures / Andere leveringen.PA amount$$, $Transport / Ziekenvervoer.PA amount$1:$Transport / Ziekenvervoer.PA amount$$, $Frais Divers / Diverse kosten.PA amount$1:$Frais Divers / Diverse kosten.PA amount$$), ADD($Totals.PA amount$1:$Totals.PA amount$$) )

Hospital invoice