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:

Related Topics