RP_FlashSalesNew
The RP_FlashSalesNew view displays information for all transactions by product type and transaction date. You can filter the data by the transaction date, office number, associate, and item type ID.
The view contains the following data:
Column Heading | Unique to SQL Database | Description |
---|---|---|
TransactionTypeID |
Y |
Unique ID for each transaction type. |
TransactionDate |
|
Date of the transaction, as displayed on the patient’s Transactions page. |
Officenum |
|
Office number of the office where the invoice was generated. |
OfficeName |
|
Office name of the office where the invoice was generated. |
Associate |
Y |
Employee number of the employee who generated the invoice. |
ItemTypeId |
Y |
The ID for each item type. |
ProductType |
|
The product type of the item in the transaction. |
Retail |
|
The retail amount of the line item; does not include tax or discounts. |
Tax |
|
The total tax for the item on the invoice. |
Discount |
|
The total discount, in dollars, applied to the line item. |
CustomerAmount |
|
The amount the patient is expected to pay. |
Allowance |
|
Patient’s allowance applied to the transaction, as determined by his or her insurance plan. |
InsReceivable |
|
The expected insurance receivable. |
Copay |
|
Patient’s copay applied to the transaction, as determined by his or her insurance plan. |
ItemGroup |
|
The item group of the item. This column only populates if the item was set up as part of an item group in AcuityLogic Admin. |
InvoiceCnt |
|
The invoice count. If there are multiple line items on one invoice, the invoice count only populates for the first line item on the invoice. 0 = The line item is not the first line item on the invoice. To locate the invoice count for the invoice, search for all other line items with the same InvoiceID. 1 = Sale, or any transaction in which the patient pays the office. -1 = Remake, refund, void, or any transaction in which the office pays the patient. |
DayCloseId |
Y |
Unique ID for the date of the transaction. |
OfficeType |
|
The type of office where the invoice was generated. The office type is assigned in AcuityLogic Admin. |
Region |
|
The region of the office where the invoice was generated. The office region is assigned in AcuityLogic Admin. |
Use the following equation to calculate the net sale for a transaction:
- CustomerAmount + InsReceivable – Tax
Here is an example of the RP_FlashSalesNew view imported into a spreadsheet: