A receipt that is provided by the pharmacy for people who have additional health care insurance, also known as a BVAC.
...
Field | Description | Data type |
---|---|---|
Insured name | Full name of the person insured | string |
Insured NISZ | National insurance number of the person insured | string |
Prescriber name | Full name of prescribing doctor | string |
Prescriber id | ID of prescribing doctor | stringalphanumeric |
Date from | Date of issue | stringdate |
Line items
Table name: BVAC_detail
Column | Description | Data type |
---|---|---|
CNK code | Article code | string |
Number of units | Quantity of the articles | string |
Description | Description of the articles | string |
TK amountTK | amount Total cost of the article | stringfloat |
PA amountPA amount | Personal share of the article string(total cost amount minus the amount covered by the mutuality) | float |
Table name: Total
Column | Description | Data type | |
---|---|---|---|
TK amount | Total TK cost amount | stringfloat | |
PA amount | Total PA amount | stringPersonal share amount (total cost amount minus the amount covered by the mutuality) | float |
Useful computed fields
Field | Formula |
---|---|
SUM CHECK TK |
|
SUM CHECK PA |
|