...
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
detail lines → there are two types of detail lines
Those which do not include a subtotal: Detail_MUT
Often included date, nomeclature number, description, …
But never a TK amount (actual paid amount)
Those which do include a subtotal: Item_With_Subtotal
Include a TK amount
subtotal → this is the subtotal for a note. There can be multiple subtotals per document
total → this is the total for the document “there can be only one”
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 contains information both on the detail line and on the 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 (it can be summed up into the document total)
detail_MUT
Table name: detail_MUT
...