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: