...
Column | Description | Data type |
---|---|---|
Insured name | Full name of the person insured | string |
Insured NISZ | National insurance number of the person insured | string |
Insured Birthdate | Date of birth of the person insured | date |
Line items
We consider different types of lines
header lines → if header fields can be repeated, we also provide them as header lines so that they can be associated to the right note
total → this is the total for the document “there can be only one”
subtotal → this is the subtotal for a note. There can be multiple subtotals per document
detail lines → this is the most granular detail line, which includes a description etc.
Relation between detail_MUT, Item_With_Subtotal, and subtotal
a detail_MUT line does not have the column “TK amount” (amount actually paid)
a subtotal line only has amounts (no description, nomenclature code, …)
sometimes a line is both a detail line and a subtotal. This is done when the note consists of exactly one item
An Item_With_Subtotal therefore has the fields of a detail_MUT line (description, nomenclature code) and the fields of a subtotal line (notably TK amount)
An Item_With_Subtotal line cannot be summed up in another subtotal line
detail_MUT
Table name: detail_MUT
...