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:

Related Topics