01Relates to the patient
not linked to a patient
Single-patient export: not included.
02Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | RPL_PK | integer | bigint | no | |
| 2 | ACCOUNT | string | varchar(12) | no | |
| 3 | APPT_ID | integer | int | no | |
| 4 | APPT_LINE_NO | integer | int | yes | |
| 5 | APPT_TRANSACTION_NO | integer | int | yes | |
| 6 | COLLECTED_DATE | datetime | datetime | yes | |
| 7 | ENTRY_USER_ID | string | varchar(20) | yes | |
| 8 | ENTRY_DATE | datetime | datetime | yes | |
| 9 | CASHRECEIPTPAYMENTTYPE | string | varchar(25) | yes | |
| 10 | AMOUNT | decimal | decimal(19,4) | yes | |
| 11 | NOTES | string | varchar(max) | yes | |
| 12 | TRANSMIT_DATE | datetime | datetime | yes | |
| 13 | RESPONSE_DATE | datetime | datetime | yes | |
| 14 | RESPONSE_MSG | string | varchar(4000) | yes |