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:
