Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Predictions are activated when the table xxx is present

Header fields

Field

Description

Insured name

Insured Birthdate

Insured NISZ

Addressee House number

Addressee Zip code

Invoice Type

Credit Note

Invoice id

Invoice date

Hospital id

Date in

Date out

Gross amount

Tax amount

Line items

Frais du Séjour / Verblijfskosten

Column

Description

Bedroom type

Date from

Date to

Number of units

nomenclature code

MUT amount

PA amount

SUP amount

Montants forfaitaires / Forfaitaire kosten

Column

Description

description

MUT amount

PA amount

SUP amount

Pharmacie / Apotheek

Column

Description

description

CNK code

Number of units

nomenclature code

Notification Code

MUT amount

PA amount

SUP amount

Honoraires / Honoraria

Column

Description

description

Date from

nomenclature code

Number of units

MUT amount

PA amount

SUP amount

Autres fournitures / Andere leveringen

Column

description

nomenclature code

description

Number of units

MUT amount

PA amount

Transport / Ziekenvervoer

Column

description

Date from

nomenclature code

Number of units

description

MUT amount

PA amount

Frais Divers / Diverse kosten

Column

description

nomenclature code

description

Number of units

PA amount

Payment Details

Column

description

payment_amount

payment_iban

payment_reference

Totals

Column

description

Section

=rubriek

MUT amount

PA amount

SUP amount

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$$)

)

  • No labels