V_OutstandingCreditBalance
The V_OutstandingCreditBalance view displays the balances of customer credit. Each balance is the dollar amount that an office owes a patient. The view contains the following data:
| Column Heading | Unique to SQL Database | Description |
|---|---|---|
|
PatientID |
|
The Patient ID number displayed on the patient profile. |
|
Amount |
|
The dollar amount that the office owes the patient. |
|
LastName |
|
The last name of the patient. |
|
FirstName |
|
The first name of the patient. |
|
OfficeNum |
|
The office number of the office that owes the patient. |
You can filter the data by the office number of the office that owes the patient.
Here is an example of the V_NetSalesByDoctor view imported into a spreadsheet:
