V_NetSalesByDoctor

The V_NetSalesByDoctor view displays the net sales of eyeglasses by doctor. You can filter the data by the transaction date and employee ID.

The view contains the following data:

Column Heading Unique to SQL Database Description

OrderID

 

Unique ID number for the lab order; displayed on the patient’s Orders and Transactions pages.

TransactionDate

 

The date of the transaction.

NetSale

 

The amount the customer pays, plus the insurance receivable, minus any tax.

EmployeeName

 

The name of the doctor who recorded the Rx for the eyeglasses.

CompanyID

 

The ID of the company that created the transaction.

Retail

 

The retail amount of the eyeglasses; does not include tax or discounts.

EmployeeID

 

The employee ID number of the doctor who recorded the Rx for the eyeglasses. The ID is automatically assigned to the employee when he or she is added in AcuityLogic Admin.

Here is an example of the V_NetSalesByDoctor view imported into a spreadsheet:

Related Topics