Daily Aggregated Sales and Operations Subject Areas
The daily aggregated sales and operations subject areas contain data for operations, menu item sales, discounts, tender, service charge, taxes, job codes, order channels, and employees. The availability of some data points within the subject areas depends on features being used or configured within the POS system.
These subject areas are recommended if the data on your report does not need to be broken down by day part, hour, quarter hour, or check. The subject areas include:
- Discount Daily Total
- Employee Daily Total
- Employee Discount Total
- Employee Job Code Daily Total
- Employee Menu Item Sales
- Employee Order Channel Daily Total
- Employee Service Charge Total
- Employee Tender Media Total
- Job Code Daily Total
- Labor Category Daily Total
- Menu Item Daily Total
- Operations Daily Total
- Order Channel Daily Total
- Service Charge Daily Total
- Tax Daily Total
- Tender Daily Total
Discount Daily Total
Data Permission: Sales and Operations.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Category Group 1 Name | catGrpName1 | Yes, for iQuery only | N/A | String | Text |
Category Group 2 Name | catGrpName2 | Yes, for iQuery only | N/A | String | Text |
Category Group 3 Name | catGrpName3 | Yes, for iQuery only | N/A | String | Text |
Category Group 4 Name | catGrpName4 | Yes, for iQuery only | N/A | String | Text |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Discount Amount | discAmt | N/A | Measure | Decimal2 | Currency |
Discount Count | discCnt | N/A | Measure | Integer | Integer |
Discount Name | discName | N/A | N/A | String | Text |
Discount Number | discNum | N/A | N/A | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | Integer | Integer |
Financial Year | financialYear | N/A | N/A | String | Text |
Inclusive Tax Forgiven | inclTaxForgiven | N/A | Measure | Decimal2 | Currency |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Revenue Center | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Employee Daily Total
Data Permissions: General Labor, Sales and Operations, and Employee Performance.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Average Check | avgCheck | N/A | Measure | Decimal2 | Currency |
Business Date | busDate | Business Date | N/A | Date | Date |
Carry Over Amount | carryOvrAmt | N/A | Measure | Decimal2 | Currency |
Carry Over Count | carryOverCnt | N/A | Measure | Integer | Integer |
Change in Grand Total | changeInGrandTotal | N/A | Measure | Decimal2 | Currency |
Charged Receipts Total | chrgdRcptTtl | N/A | Measure | Decimal2 | Currency |
Charged Tips Total | chargedTipsTtl | N/A | Measure | Decimal2 | Currency |
Check Count | chksCnt | N/A | Measure | Integer | Integer |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Credit Total | creditTotal | N/A | Measure | Decimal2 | Currency |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Day Part Name | dayPart | N/A | N/A | String | Text |
Day Part Number | dayPartNumber | N/A | N/A | Integer | Integer |
Dining Time | dineTime | N/A | Measure | Integer | Integer |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | empNum | N/A | N/A | Integer | Integer |
Employee Pay ID | empPayId | N/A | N/A | Integer | Integer |
Error Correct Amount | errCorAmt | N/A | Measure | Decimal2 | Currency |
Error Correct Count | errCorCnt | N/A | Measure | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | Integer | Integer |
Financial Year | financialYear | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Gross Receipts Amount | grossRcptAmt | N/A | Measure | Decimal2 | Currency |
Gross Sales | grossSales | N/A | Measure | Decimal2 | Currency |
Guest Count | guestCnt | N/A | Measure | Integer | Integer |
Indirect Tips Paid Amount | indirectTipAmt | N/A | Measure | Decimal2 | Currency |
Item Discount Amount | itemDiscAmt | N/A | Measure | Decimal2 | Currency |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Manager Void Amount | mgrVdAmt | N/A | Measure | Decimal2 | Currency |
Manager Void Count | mgrVdCnt | N/A | Measure | Integer | Integer |
Net Sales | netSls | N/A | Measure | Decimal2 | Currency |
Non-Revenue Total | nonRevTotal | N/A | Measure | Decimal2 | Currency |
No Sale Count | noSaleCnt | N/A | Measure | Integer | Integer |
Return Amount | retAmt | N/A | Measure | Decimal2 | Currency |
Return Count | retCnt | N/A | Measure | Integer | Integer |
Revenue Center | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Rounding Total | roundTtl | N/A | Measure | Decimal2 | Currency |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
Spend per Guest | spendPerGuest | N/A | Measure | Decimal2 | Currency |
Subtotal Discount Amount | subTtlDiscAmt | N/A | Measure | Decimal2 | Currency |
Table Turns Count | tblTurnCnt | N/A | Measure | Integer | Integer |
Tax Collected | taxCollected | N/A | Measure | Decimal2 | Currency |
Tips Declared Amount | tipDeclAmt | N/A | Measure | Decimal2 | Currency |
Tips Paid Amount | tipPaidAmt | N/A | Measure | Decimal2 | Currency |
Total Tip Amount | tipAmt | N/A | Measure | Decimal2 | Currency |
Transaction Cancelled Amount | xferCnclAmt | N/A | Measure | Decimal2 | Currency |
Transaction Cancelled Count | xferCnclCnt | N/A | Measure | Integer | Integer |
Void Amount | vdAmt | N/A | Measure | Decimal2 | Currency |
Void Count | vdCnt | N/A | Measure | Integer | Integer |
Employee Discount Total
Data Permissions: Sales and Operations and Employee Performance.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Day Part Name | dayPart | N/A | N/A | String | Text |
Day Part Number | dayPartNum | N/A | N/A | Integer | Integer |
Discount Amount | discAmt | N/A | Measure | Decimal2 | Currency |
Discount Count | discCnt | N/A | N/A | Integer | Integer |
Discount Name | discName | N/A | N/A | String | Text |
Discount Number | discNum | N/A | N/A | Integer | Integer |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | empNum | N/A | N/A | String | Text |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | Integer | Integer |
Financial Year | financialYear | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Last Name | surname | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Revenue Center | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Employee Job Code Daily Total
Data Permissions: General Labor, Employee Performance, Hourly Pay Rates, and Salaried Pay Rates.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Employee Name | empName | N/A | N/A | String | Text |
Employee Number | empNumber | N/A | N/A | Integer | Integer |
First Name | forename | N/A | N/A | String | Text |
Job Code Name | jobName | N/A | N/A | String | Text |
Job Code Number | jobNum | N/A | N/A | Integer | Integer |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Overtime 1 Hours | otHrs1 | N/A | Measure | Decimal2 | Currency |
Overtime 1 Pay | otPay1 | N/A | Measure | Decimal2 | Currency |
Overtime 2 Hours | otHrs2 | N/A | Measure | Decimal2 | Currency |
Overtime 2 Pay | otPay2 | N/A | Measure | Decimal2 | Currency |
Overtime 3 Hours | otHrs3 | N/A | Measure | Decimal2 | Currency |
Overtime 3 Pay | otPay3 | N/A | Measure | Decimal2 | Currency |
Overtime 4 Hours | otHrs4 | N/A | Measure | Decimal2 | Currency |
Overtime 4 Pay | otPay4 | N/A | Measure | Decimal2 | Currency |
Overtime Pay | otPayTtl | N/A | Measure | Decimal2 | Currency |
Regular Hours | regHrs | N/A | Measure | Decimal2 | Currency |
Regular Pay | regPay | N/A | Measure | Decimal2 | Currency |
Total Overtime Hours | otHrsTtl | N/A | Measure | Decimal2 | Currency |
Employee Menu Item Sales
Data Permissions: Sales and Operations and Employee Performance.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Cost of Goods Sold Amount | cogs | N/A | Measure | Decimal2 | Currency |
Cost of Goods Sold Percent | prepCostPercent | N/A | Measure | Decimal2 | Currency |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Day Part | dayPart | N/A | N/A | String | Text |
Day Part Number | dayPartNum | N/A | N/A | Integer | Integer |
Discount Amount | discAmt | N/A | Measure | Decimal2 | Currency |
Employee Name | employeeName | N/A | N/A | String | String |
Employee Number | empNum | N/A | N/A | Integer | Integer |
Family Group Name | familyGrp | Yes, for iQuery only | N/A | String | Text |
Family Group Number | familyGroupNum | N/A | N/A | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
First Name | firstName | N/A | N/A | String | Text |
Last Name | lastName | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Major Group Name | majorGrp | N/A | N/A | String | Text |
Major Group Number | majorGroupNum | Yes, for iQuery only | N/A | Integer | Integer |
Menu Item Name | itemName | N/A | N/A | String | Text |
Menu Item Number | itemNum | N/A | N/A | Integer | Integer |
Order Channel Name | orderChannelName | N/A | N/A | String | Text |
Order Channel Number | orderChannelNum | N/A | N/A | Integer | Integer |
Order Type Name | orderName | Order Type | N/A | String | Text |
Order Type Number | orderTypeNum | N/A | N/A | Integer | Integer |
Return Count | retCnt | N/A | Measure | Integer | Integer |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Sales Count | slsCnt | N/A | Measure | Integer | Integer |
Sales Total | slsTtl | N/A | Measure | Decimal2 | Currency |
Employee Order Channel Daily Total
Data Permission: Sales and Operations.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Average Check | avgCheck | N/A | Measure | Decimal2 | Currency |
Business Date | busDate | Business Date | N/A | Date | Date |
Charged Receipts Total | chrgdRcptTtl | N/A | Measure | Decimal2 | Currency |
Charged Tips Total | chargedTipsTtl | N/A | Measure | Decimal2 | Currency |
Check Count | chksCnt | N/A | Measure | Integer | Integer |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Credit Total | creditTotal | N/A | Measure | Decimal2 | Currency |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Day Part Name | dayPart | N/A | N/A | String | Text |
Day Part Number | dayPartNumber | N/A | N/A | Integer | Integer |
Dining Time | dineTime | N/A | Measure | Integer | Integer |
Discount Amount | discAmt | N/A | Measure | Decimal2 | Currency |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | empNum | N/A | N/A | Integer | Integer |
Error Correct Amount | errCorAmt | N/A | Measure | Decimal2 | Currency |
Error Correct Count | errCorCnt | N/A | Measure | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | Integer | Integer |
Financial Year | financialYear | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Gross Receipts Amount | grossRcptAmt | N/A | Measure | Decimal2 | Currency |
Gross Sales | grossSales | N/A | Measure | Decimal2 | Currency |
Guest Count | guestCnt | N/A | Measure | Integer | Integer |
Indirect Tips Paid Amount | indirectTipAmt | N/A | Measure | Decimal2 | Currency |
Last Name | surname | N/A | N/A | String | Text |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Manager Void Amount | mgrVdAmt | N/A | Measure | Decimal2 | Currency |
Manager Void Count | mgrVdCnt | N/A | Measure | Integer | Integer |
Net Sales | netSls | N/A | Measure | Decimal2 | Currency |
Non-Revenue Total | nonRevTotal | N/A | Measure | Decimal2 | Currency |
No Sale Count | noSaleCnt | N/A | Measure | Integer | Integer |
Order Channel Name | orderChannelName | Order Channel | N/A | String | Text |
Order Channel Number | orderChannelNum | N/A | N/A | Integer | Integer |
Order Type Name | orderName | Order Type | N/A | String | Text |
Order Type Number | orderTypeNum | N/A | N/A | Integer | Integer |
Return Amount | retAmt | N/A | Measure | Decimal2 | Currency |
Return Count | retCnt | N/A | Measure | Integer | Integer |
Revenue Center | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
Spend per Guest | spendPerGuest | N/A | Measure | Decimal2 | Currency |
Table Turns Count | tblTurnCnt | N/A | Measure | Integer | Integer |
Tax Collected | taxCollected | N/A | Measure | Decimal2 | Currency |
Tips Declared Amount | tipDeclAmt | N/A | Measure | Decimal2 | Currency |
Tips Paid Amount | tipPaidAmt | N/A | Measure | Decimal2 | Currency |
Total Tip Amount | tipAmt | N/A | Measure | Decimal2 | Currency |
Transaction Cancelled Amount | xferCnclAmt | N/A | Measure | Decimal2 | Currency |
Transaction Cancelled Count | xferCnclCnt | N/A | Measure | Integer | Integer |
Void Amount | vdAmt | N/A | Measure | Decimal2 | Currency |
Void Count | vdCnt | N/A | Measure | Integer | Integer |
Employee Service Charge Total
Data Permissions: Sales and Operations and Employee Performance.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Day Part | dayPart | N/A | N/A | String | Text |
Day Part Number | dayPartNum | N/A | N/A | Integer | Integer |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | empNum | N/A | N/A | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
First Name | firstName | N/A | N/A | String | Text |
Last Name | lastName | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
Service Charge Count | srvcCnt | N/A | Measure | Integer | Integer |
Service Charge Name | srvcName | N/A | N/A | String | Text |
Service Charge Number | srvcNum | N/A | N/A | Integer | Integer |
Employee Tender Media Total
Data Permissions: Sales and Operations and Employee Performance.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Day Part | dayPart | N/A | N/A | String | Text |
Day Part Number | dayPartNum | N/A | N/A | Integer | Integer |
Employee Name | employeeName | N/A | N/A | String | Text |
Employee Number | empNum | N/A | N/A | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
First Name | forename | N/A | N/A | String | Text |
Last Name | surname | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Tender Amount | tndrTtl | N/A | Measure | Decimal2 | Currency |
Tender Count | tndrCnt | N/A | Measure | Integer | Integer |
Tender Name | tndrName | N/A | N/A | String | Text |
Tender Number | tndrNum | N/A | N/A | Integer | Integer |
Tender Subtype | tndrSubType | N/A | N/A | Integer | Integer |
Tender Type | tndrType | N/A | N/A | Integer | Integer |
Job Code Daily Total
Data Permissions: General Labor, Hourly Pay Rates, and Salaried Pay Rates.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Average Pay Rate | avgPayRate | N/A | Measure | Decimal2 | Currency |
Business Date | busDate | Business Date | N/A | Date | Date |
Job Code Name | jobName | N/A | N/A | String | Text |
Job Code Number | jobNum | N/A | N/A | Integer | Integer |
Labor Category Name | labCat | N/A | N/A | String | Text |
Labor Category Number | labCatNum | N/A | N/A | Integer | Integer |
Location | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Overtime 1 Hours | otHrs1 | N/A | Measure | Decimal2 | Currency |
Overtime 1 Pay | otPay1 | N/A | Measure | Decimal2 | Currency |
Overtime 2 Hours | otHrs2 | N/A | Measure | Decimal2 | Currency |
Overtime 2 Pay | otPay2 | N/A | Measure | Decimal2 | Currency |
Overtime 3 Hours | otHrs3 | N/A | Measure | Decimal2 | Currency |
Overtime 3 Pay | otPay3 | N/A | Measure | Decimal2 | Currency |
Overtime 4 Hours | otHrs4 | N/A | Measure | Decimal2 | Currency |
Overtime 4 Pay | otPay4 | N/A | Measure | Decimal2 | Currency |
Regular Hours | regHrs | N/A | Measure | Decimal2 | Currency |
Regular Pay | regPay | N/A | Measure | Decimal2 | Currency |
Revenue Center | rvc | Revenue Center | N/A | String | Text |
Total Overtime Hours | otHrsTtl | N/A | Measure | Decimal2 | Currency |
Total Overtime Pay | otPayTtl | N/A | Measure | Decimal2 | Currency |
Labor Category Daily Total
Data Permissions: General Labor, Hourly Pay Rates, and Salaried Pay Rates.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Labor Category Name | labCat | N/A | N/A | String | Text |
Labor Category Number | labCatNum | N/A | N/A | Integer | Integer |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Regular Hours | regHrs | N/A | Measure | Decimal2 | Currency |
Regular Pay | regPay | N/A | Measure | Decimal2 | Currency |
Theoretical Hours | theoHrs | N/A | Measure | Decimal2 | Currency |
Total Overtime Hours | otHrsTtl | N/A | Measure | Decimal2 | Currency |
Total Overtime Pay | otPayTtl | N/A | Measure | Decimal2 | Currency |
Menu Item Daily Total
Data Permission: Sales and Operations.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Average Cost | avgCost | N/A | N/A | Decimal2 | Currency |
Average Price | avgPrice | N/A | N/A | Decimal2 | Currency |
Business Date | busDate | Business Date | N/A | Date | Date |
Category Group 1 Name | catGrpName1 | Yes, for iQuery only | N/A | String | Text |
Category Group 2 Name | catGrpName2 | Yes, for iQuery only | N/A | String | Text |
Category Group 3 Name | catGrpName3 | Yes, for iQuery only | N/A | String | Text |
Category Group 4 Name | catGrpName4 | Yes, for iQuery only | N/A | String | Text |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Cost of Goods Sold Amount | cogs | N/A | Measure | Decimal2 | Currency |
Cost of Goods Sold Percent | prepCostPercent | N/A | N/A | Decimal2 | Currency |
Day of Week | dayofTheWeek | N/A | N/A | String | String |
Discount Amount | discAmt | N/A | Measure | Decimal2 | Currency |
Discount VAT Amount Extended Precision | discVatTtlExt | N/A | Measure | Decimal2 | Currency |
External Reference 1 | extRef | N/A | N/A | String | Text |
Family Group Name | familyGrp | Yes, for iQuery only | N/A | String | Text |
Family Group Number | familyGroupNum | N/A | N/A | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
Gross Sales after Discount | slsGrossAftDisc | N/A | Measure | Decimal2 | Currency |
Gross Sales before Discount | slsGrossB4Disc | N/A | Measure | Decimal2 | Currency |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Major Group Name | majorGrp | Yes, for iQuery only | N/A | String | Text |
Major Group Number | majorGroupNum | N/A | N/A | Integer | Integer |
Menu Item Name | itemName | N/A | N/A | String | Text |
Menu Item Number | itemNum | N/A | N/A | Integer | Integer |
Order Channel Name | orderChannelName | N/A | N/A | String | Text |
Order Channel Number | orderChannelNum | N/A | N/A | Integer | Integer |
Order Type Name | orderName | Order Type | N/A | String | Text |
Order Type Number | orderTypeNum | N/A | N/A | Integer | Integer |
Return Count | retCnt | N/A | Measure | Integer | Integer |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Sales Count | slsCnt | N/A | Measure | Integer | Integer |
Sales less Item Discount | slsTtl | N/A | Measure | Decimal2 | Currency |
Sales Net VAT/GST/Taxes | slsNetVatAftDisc | N/A | Measure | Decimal2 | Currency |
Sales Net VAT/GST/Taxes before Discount | slsNetVatB4Disc | N/A | Measure | Decimal2 | Currency |
Total VAT/GST/Inclusive Taxes Amount | vatTtl | N/A | Measure | Decimal2 | Currency |
VAT Amount Extended Precision | vatTtlExt | N/A | Measure | Decimal2 | Currency |
Volume | vol | N/A | Measure | Decimal2 | Currency |
Operations Daily Total
Data Permission: Sales and Operations.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
All Sales Net VAT/GST/Taxes | allSlsNetTax | N/A | Measure | Decimal2 | Currency |
Average Check | avgCheck | N/A | Measure | Decimal2 | Currency |
Budget Total | budgTtl | N/A | Measure | Decimal2 | Currency |
Business Date | busDate | Business Date | N/A | Date | Date |
Carry Over Amount | caryOvrAmt | N/A | Measure | Decimal2 | Currency |
Carry Over Count | caryOvrCnt | N/A | Measure | Integer | Integer |
Check Closed Amount | chkClsdAmt | N/A | Measure | Decimal2 | Currency |
Check Closed Count | chkClsdCnt | N/A | Measure | Integer | Integer |
Check Open Amount | chkOpnAmt | N/A | Measure | Decimal2 | Currency |
Check Open Count | chkOpnCnt | N/A | Measure | Integer | Integer |
Checks Count | chksCnt | N/A | Measure | Integer | Integer |
Check Transfer-in Amount | chkXferInAmt | N/A | Measure | Decimal2 | Currency |
Check Transfer-in Count | chkXferInCnt | N/A | Measure | Integer | Integer |
Check Transfer Out Amount | chkXferOutAmt | N/A | Measure | Decimal2 | Currency |
Check Transfer Out Count | chkXferOutCnt | N/A | Measure | Integer | Integer |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Contribution Margin | contributionMargin | N/A | Measure | Decimal2 | Currency |
Cost of Goods Sold Amount | cosAmt | N/A | Measure | Decimal2 | Currency |
Cost of Goods Sold Percent | cosAmt | N/A | Measure | Decimal2 | Currency |
Credit Total | creditTotal | N/A | Measure | Decimal2 | Currency |
Day of Week | dayOfTheWeek | N/A | N/A | String | Text |
Dining Time | dineTime | N/A | Measure | Integer | Integer |
Drive Thru Time | drvThruTime | N/A | Measure | Integer | Integer |
Error Correct Amount | errCorAmt | N/A | Measure | Decimal2 | Currency |
Error Correct Count | errCorCnt | N/A | Measure | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
Grand Total | grandTtl | N/A | Measure | Decimal2 | Currency |
Gross Sales | grossSales | N/A | Measure | Decimal2 | Currency |
Gross Sales after Discount | slsGrossAftDisc | N/A | Measure | Decimal2 | Currency |
Gross Sales before Discount | slsGrossB4Disc | N/A | Measure | Decimal2 | Currency |
Guest Count | guestCnt | N/A | Measure | Integer | Integer |
High Temperature | tempHigh | N/A | N/A | Integer | Integer |
Item Discount Amount | itemDiscAmt | N/A | Measure | Decimal2 | Currency |
Labor Cost | laborCost | N/A | Measure | Decimal2 | Currency |
Labor Cost Percent | laborCostPercent | N/A | Measure | Decimal2 | Currency |
Last Years Checks | lastYrChks | N/A | Measure | Decimal2 | Currency |
Last Years Guests | lastYrGuest | N/A | Measure | Decimal2 | Currency |
Last Years Sales | lastYrSls | N/A | Measure | Decimal2 | Currency |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Low Temperature | tempLow | N/A | N/A | Integer | Integer |
Manager Void Amount | mgrVdAmt | N/A | Measure | Decimal2 | Currency |
Manager Void Count | mgrVdCnt | N/A | Measure | Integer | Integer |
Net Sales | netSls | N/A | Measure | Decimal2 | Currency |
Non-Revenue Total | nonRevTotal | N/A | Measure | Decimal2 | Currency |
Non Taxable Sales Total | nonTaxSlsTtl | N/A | Measure | Decimal2 | Currency |
Operating Margin | operatingMargin | N/A | Measure | Decimal2 | Currency |
Over Short | ovrShrt | N/A | Measure | Decimal2 | Currency |
Parked Cars Count | parkCarCnt | N/A | Measure | Integer | Integer |
Prepared Items Count | prepItemCnt | N/A | Measure | Integer | Integer |
Regular Hours | regHrs | N/A | Measure | Decimal2 | Currency |
Regular Pay | regPay | N/A | Measure | Decimal2 | Currency |
Return Amount | retAmt | N/A | Measure | Decimal2 | Currency |
Return Count | retCnt | N/A | Measure | Integer | Integer |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Rounding Total | roundTtl | N/A | Measure | Decimal2 | Currency |
Sales Forecast | slsFcast | N/A | Measure | Decimal2 | Currency |
Sales Net VAT/GST/Taxes | slsNetInclTax | N/A | Measure | Decimal2 | Currency |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
Speed of Service Time 1 | timeSos1 | N/A | Measure | Integer | Integer |
Speed of Service Time 2 | timeSos2 | N/A | Measure | Integer | Integer |
Speed of Service Time 3 | timeSos3 | N/A | Measure | Integer | Integer |
Speed of Service Time 4 | timeSos4 | N/A | Measure | Integer | Integer |
Spend per Guest | spendPerGuest | N/A | Measure | Decimal2 | Currency |
Subtotal Discount Amount 1 | subDiscTtl1 | N/A | Measure | Decimal2 | Currency |
Subtotal Discount Amount 2 | subDiscTtl2 | N/A | Measure | Decimal2 | Currency |
Subtotal Discount Amount 3 | subDiscTtl3 | N/A | Measure | Decimal2 | Currency |
Subtotal Discount Amount 4 | subDiscTtl4 | N/A | Measure | Decimal2 | Currency |
Tables Count | tblCnt | N/A | Measure | Integer | Integer |
Table Turns Count | tblTurnCnt | N/A | Measure | Integer | Integer |
Tax Collected Total | taxCollectAmt | N/A | Measure | Decimal2 | Currency |
Tax Credited | taxCreditedTotal | N/A | Measure | Decimal2 | Currency |
Tax Exempt Sales Total | taxExmptSlsTtl | N/A | Measure | Decimal2 | Currency |
Total Overtime Hours | otHrsTtle | N/A | Measure | Decimal2 | Currency |
Total Overtime Pay | otPayTtl | N/A | Measure | Decimal2 | Currency |
Total Prep Time | timeToPrep | N/A | Measure | Integer | Integer |
Total Revenue | totalRevenue | N/A | Measure | Decimal2 | Currency |
Total VAT/GST/Inclusive Taxes Amount | inclTaxTtlAmount | N/A | Measure | Decimal2 | Currency |
Transaction Canceled Amount | xferCnclAmount | N/A | Measure | Decimal2 | Currency |
Transaction Canceled Count | xferCnclCnt | N/A | Measure | Integer | Integer |
Void Amount | vdAmt | N/A | Measure | Decimal2 | Currency |
Void Count | vdCnt | N/A | Measure | Integer | Integer |
Waiting Parties Count | waitCnt | N/A | Measure | Integer | Integer |
Wait Time | timeToWait | N/A | Measure | Integer | Integer |
Weather Condition | weather | N/A | N/A | String | Text |
Order Channel Daily Total
Data Permission: Sales and Operations.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
All Sales Net VAT/GST/Taxes | allSlsNetTax | N/A | Measure | Decimal2 | Currency |
Average Check | avgCheck | N/A | Measure | Decimal2 | Currency |
Business Date | busDate | Business Date | N/A | Date | Date |
Checks Count | chksCnt | N/A | Measure | Integer | Integer |
Check Transfer-in Amount | checkxferintotal | N/A | Measure | Decimal2 | Currency |
Check Transfer-in Count | checkxferincount | N/A | Measure | Integer | Integer |
Check Transfer Out Amount | checkxferouttotal | N/A | Measure | Decimal2 | Currency |
Check Transfer Out Count | checkxferoutcount | N/A | Measure | Integer | Integer |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Contribution Margin | contributionMargin | N/A | Measure | Decimal2 | Currency |
Cost of Goods Sold Amount | cogs | N/A | Measure | Decimal2 | Currency |
Credit Total | creditTotal | N/A | Measure | Decimal2 | Currency |
Day of Week | dayOfTheWeek | N/A | N/A | String | Text |
Dining Time | dineTime | N/A | Measure | Integer | Integer |
Discount Amount | discAmt | N/A | Measure | Decimal2 | Currency |
Error Correct Amount | errCorAmt | N/A | Measure | Decimal2 | Currency |
Error Correct Count | errCorCnt | N/A | Measure | Integer | Integer |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
Gross Sales | grossSales | N/A | Measure | Decimal2 | Currency |
Gross Sales after Discount | slsGrossAftDisc | N/A | Measure | Decimal2 | Currency |
Gross Sales before Discount | slsGrossB4Disc | N/A | Measure | Decimal2 | Currency |
Guest Count | guestCnt | N/A | Measure | Integer | Integer |
Last Years Checks | lastYrChks | N/A | Measure | Decimal2 | Currency |
Last Years Guests | lastYrGuest | N/A | Measure | Decimal2 | Currency |
Last Years Sales | lastYrSls | N/A | Measure | Decimal2 | Currency |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Manager Void Amount | mgrVdAmt | N/A | Measure | Decimal2 | Currency |
Manager Void Count | mgrVdCnt | N/A | Measure | Integer | Integer |
Net Sales | netSls | N/A | Measure | Decimal2 | Currency |
Non-Revenue Total | nonRevTotal | N/A | Measure | Decimal2 | Currency |
Order Channel Name | orderChannelName | Order Channel | N/A | String | Text |
Order Channel Number | orderChannelNum | N/A | N/A | Integer | Integer |
Order Type Name | orderName | Order Type | N/A | String | Text |
Order Type Number | orderTypeNum | N/A | N/A | Integer | Integer |
Return Amount | retAmt | N/A | Measure | Decimal2 | Currency |
Return Count | retCnt | N/A | Measure | Integer | Integer |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Sales Net VAT/GST/Taxes | slsNetTaxes | N/A | Measure | Decimal2 | Currency |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
Spend per Guest | spendPerGuest | N/A | Measure | Decimal2 | Currency |
Table Turns Count | tblTurnCnt | N/A | Measure | Integer | Integer |
Tax Collected Total | taxCollectAmt | N/A | Measure | Decimal2 | Currency |
Total VAT/GST/Inclusive Taxes Amount | inclTaxTtlAmount | N/A | Measure | Decimal2 | Currency |
Transaction Canceled Amount | xferCnclAmount | N/A | Measure | Decimal2 | Currency |
Transaction Canceled Count | xferCnclCnt | N/A | Measure | Integer | Integer |
Void Amount | vdAmt | N/A | Measure | Decimal2 | Currency |
Void Count | vdCnt | N/A | Measure | Integer | Integer |
Service Charge Daily Total
Data Permission: Sales and Operations.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Category Group 1 Name | catGrpName1 | Yes, iQuery only | N/A | String | Text |
Category Group 2 Name | catGrpName2 | Yes, iQuery only | N/A | String | Text |
Category Group 3 Name | catGrpName3 | Yes, iQuery only | N/A | String | Text |
Category Group 4 Name | catGrpName4 | Yes, iQuery only | N/A | String | Text |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Service Charge Amount | srvcChrgTip | N/A | Measure | Decimal2 | Currency |
Service Charge Count | srvcCnt | N/A | Measure | Integer | Integer |
Service Charge Name | srvcName | N/A | N/A | String | Text |
Service Charge Number | srvcNum | N/A | N/A | Integer | Integer |
Tax Rate | taxRate | N/A | N/A | Decimal2 | Currency |
Total VAT/GST/Inclusive Taxes Amount | inclTaxTtlAmount | N/A | Measure | Decimal2 | Currency |
Type | accType | N/A | N/A | Integer | Integer |
Tax Daily Total
Data Permission: Sales and Operation.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Business Date | busDate | Business Date | N/A | Date | Date |
Category Group 1 Name | catGrpName1 | Yes, iQuery only | N/A | String | Text |
Category Group 2 Name | catGrpName2 | Yes, iQuery only | N/A | String | Text |
Category Group 3 Name | catGrpName3 | Yes, iQuery only | N/A | String | Text |
Category Group 4 Name | catGrpName4 | Yes, iQuery only | N/A | String | Text |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Taxable Sales | taxSls | N/A | Measure | Decimal2 | Currency |
Taxable Sales Net VAT/GST/Taxes | taxableInclTaxTtl | N/A | Measure | Decimal2 | Currency |
Tax Collected | collectTax | N/A | Measure | Decimal2 | Currency |
Tax Exempt Sales | taxSlsExmpt | N/A | Measure | Decimal2 | Currency |
Tax Name | nameTax | N/A | N/A | String | Text |
Tax Number | numTax | N/A | N/A | Integer | Integer |
Tax Rate | rateTax | N/A | N/A | Decimal2 | Currency |
Type | accType | N/A | N/A | Integer | Integer |
VAT/GST/Inclusive Tax Collected | inclTaxColl | N/A | Measure | Decimal2 | Currency |
Tender Daily Total
Data Permission: Sales and Operations.
Name | Alias | Filter/Parameter | Type (Measure or Attribute) | Data Type | Data Format |
---|---|---|---|---|---|
Auto Closed Tender | autoCloseTender | N/A | N/A | Integer | Integer |
Business Date | busDate | Business Date | N/A | Date | Date |
Category Group 1 Name | catGrpName1 | Yes, for iQuery only | N/A | String | Text |
Category Group 2 Name | catGrpName2 | Yes, for iQuery only | N/A | String | Text |
Category Group 3 Name | catGrpName3 | Yes, for iQuery only | N/A | String | Text |
Category Group 4 Name | catGrpName4 | Yes, for iQuery only | N/A | String | Text |
Comp Location | compLoc | N/A | N/A | Integer | Integer |
Day of Week | dayofTheWeek | N/A | N/A | String | Text |
Financial Period | financialPeriod | N/A | N/A | String | Text |
Financial Quarter | financialQuarter | N/A | N/A | String | Text |
Financial Week | financialWeek | N/A | N/A | String | Text |
Financial Year | financialYear | N/A | N/A | String | Text |
Location Name | locName | Location | N/A | String | Text |
Location Number | locNum | N/A | N/A | String | Text |
Location Open Date | locOpenDate | N/A | N/A | Date | Date |
Revenue Center Name | rvc | Revenue Center | N/A | String | Text |
Revenue Center Number | rvcNum | N/A | N/A | Integer | Integer |
Revenue Center Type | rvcType | N/A | N/A | Integer | Integer |
Tender Amount | tndrTtl | N/A | Measure | Decimal2 | Currency |
Tender Count | tndrCnt | N/A | Measure | Integer | Integer |
Tender Name | tndrName | N/A | N/A | String | Text |
Tender Number | tndrNum | N/A | N/A | Integer | Integer |
Tender Subtype | tndrSubType | N/A | N/A | Integer | Integer |
Tender Type | tndrType | N/A | N/A | Integer | Integer |
Parent topic: Subject Areas