Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

ROUND(ADD($detail_BVAC.TK amount$1:$detail_BVAC.TK amount$$), 2)

=

$Total.TK amount$1

SUM CHECK PA

ROUND(ADD($detail_BVAC.PA amount$1:$detail_BVAC.PA amount$$), 2)

=

$Total.PA amount$1