Reporting Views of the AcuityLogic SQL Database
This section describes the different views of the AcuityLogic SQL database available to AcuityLogic On-Premises users. You can use reporting software, such as Microsoft Excel and Crystal Reports, to extract information from the SQL database and create custom reports for your company.
Most of the data included in the views is in AcuityLogic Admin or AcuityLogic POS. Other data, such as Item IDs and Discount Type IDs, is generated by the SQL database and is not visible in AcuityLogic. All data located only in the SQL database is identified in the “Unique to SQL Database” columns in the view description tables.
Topics include the following:
- V_PatientInformation
- V_OrdersRXDetail
- V_InvoiceDetailwithInsurance
- V_TransactionDetail
- RP_FlashSalesNew
- V_PatientPayment
- V_MiscPaymentReport
- V_NetSalesByDoctor
- V_OutstandingCreditBalance