| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| void_id | BIGINT | 19 | √ | null |
|
|
|||||
| patient_id | BIGINT | 19 | null |
|
|
The internal patient identifier |
|||||
| encounter_id | BIGINT | 19 | 0 |
|
|
references form_encounter.encounter |
|||||
| what_voided | VARCHAR | 31 | null |
|
|
checkout,receipt and maybe other options later |
|||||
| date_original | DATETIME | 19 | √ | NULL |
|
|
time of original action that is now voided |
||||
| date_voided | DATETIME | 19 | null |
|
|
time of void action |
|||||
| user_id | BIGINT | 19 | null |
|
|
references users.id |
|||||
| amount1 | DECIMAL | 12,2 | 0.00 |
|
|
for checkout,receipt total voided adjustments |
|||||
| amount2 | DECIMAL | 12,2 | 0.00 |
|
|
for checkout,receipt total voided payments |
|||||
| other_info | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
for checkout,receipt the old invoice refno |
||||
| reason | VARCHAR | 31 | √ | '' |
|
|
|||||
| notes | VARCHAR | 255 | √ | '' |
|
|
Showing 1 to 12 of 12 entries