V_MiscPaymentReport
The V_MiscPaymentReport view displays miscellaneous patient payments by transaction date. You can filter the data by the transaction date.
The view contains the following data:
| Column Heading | Unique to SQL Database | Description |
|---|---|---|
|
TransactionID |
|
The transaction ID, as displayed on the patient’s Transactions page. |
|
OfficeNum |
|
Office number of the office where the invoice was generated. |
|
TransactionDate |
|
The date of the transaction. |
|
TransactionAmount |
|
The total amount, in dollars, that the patient is expected to pay. The amount includes the copay, if any. |
|
PaymentAmount |
|
The total amount, in dollars, that the patient has paid so far. |
|
PatientName |
|
The name of the patient. |
|
EmployeeName |
|
The name of the employee who generated the transaction. |
|
OriginalOrderNumber |
|
The lab order number of the original order. |
|
OriginalStoreNumber |
|
Name of the office where the transaction was originally processed. |
|
Value |
|
The miscellaneous payment reason. |
|
OfficeName |
|
Office name of the office where the invoice was generated. |
|
PaymentReason |
Y |
Unique ID for the miscellaneous payment reason. |
|
CreditPayment |
|
The dollar amount the patient paid with credit card. |
|
CashPayment |
|
The dollar amount the patient paid with cash or check. |
Here is an example of the V_MiscPaymentReport view imported into a spreadsheet:
