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:

Related Topics