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

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