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: