Quarter Hour Aggregate Sales and Operations Subject Areas

The quarter hour aggregated sales and operations subject areas contain data for operations, menu item sales, discounts, tender, service charge, job codes, and order channels. 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 needs to be broken down by day part, hour, or quarter hour. The subject areas include:

Discount Fixed Period 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
Business Hour busHour Yes, for iQuery only N/A Integer Integer
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
Day Part Name dayPart N/A N/A String Text
Day Part Number dayPartNumber N/A N/A Integer Integer
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 Decimal1 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
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
Quarter Hour qtrHr Yes, for iQuery only N/A 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

Job Code Fixed Period 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
Business Hour busHour Yes, for iQuery only N/A Integer Integer
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
Quarter Hour qtrHr Yes, for iQuery only N/A Integer Integer
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 Fixed Period 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
Business Hour busHour Yes, for iQuery only 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 Name locName Location N/A String Text
Location Number locNum N/A N/A String Text
Quarter Hour qtrHr Yes, for iQuery only N/A Integer Integer
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 Fixed Period 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
Business Hour busHour Yes N/A Integer Integer
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
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 Name dayPart N/A N/A String Text
Day Part Number dayPartNumber N/A N/A Integer Integer
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, 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 Disc. slsGrossAftDisc N/A Measure Decimal2 Currency
Gross Sales before Disc. 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, iQuery only N/A String Text
Major Group Number majorGroupNumber 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 orderTypeNumber N/A N/A Integer Integer
Quarter Hour qtrHr Yes, iQuery only 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 Net VAT/GST/Taxes slsNetVatAftDisc N/A Measure Decimal2 Currency
Sales Net VAT/GST/Taxes before Discount slsNetVatB4Disc N/A Measure Decimal2 Currency
Sales Total slsTtl 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 Fixed Period 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
Business Hour busHour Yes, iQuery only N/A Integer Integer
Checks Count chksCnt 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 prepCostPercent 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
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
Number of Guests Finished numGuestFinished N/A Measure Integer Integer
Number of Guests Present numGuestsPresent N/A Measure Integer Integer
Number of Guests Seated numGuestsSeated N/A Measure 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
Parked Cars Count parkCarCnt N/A Measure Integer Integer
Quarter Hour qtrHr Yes, iQuery only 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 Forecast slsFcast N/A Measure Decimal2 Currency
Sales Net VAT/GST/Taxes slsNetInclTax 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
Table Count tblCnt N/A Measure Integer Integer
Table Turns Count tblTurnCnt N/A Measure Integer Integer
Tax Collected taxCollected N/A Measure Decimal2 Currency
Tax Credited taxCreditedTotal N/A Measure Decimal2 Currency
Total VAT/GST/Inclusive Taxes Amount inclTaxTtlAmount N/A Measure Decimal2 Currency
Transaction Cancels Amount xferCnclAmt N/A Measure Decimal2 Currency
Transaction Cancels Count xferCnclCnt N/A Measure Decimal2 Currency
Void Amount vdAmt N/A Measure Decimal2 Currency
Void Count vdCnt N/A Measure Integer Integer

Order Channel Fixed Period 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
Business Hour busHour Yes, iQuery only N/A Integer Integer
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
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
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
Quarter Hour qtrHr Yes, iQuery only 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 Fixed Period Total

Data Permission: Sales and Operations.

Name Alias Filter/Parameter Type (Measure or Attribute) Data Type Data Format
Business Date busDate N/A N/A Date Date
Business Hour busHour Business Hour N/A Integer Integer
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 catGrpName4 Yes, iQuery only N/A String Text
Category Group 4 Name catGrpName3 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 String
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 String
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
Quarter Hour qtrHr Yes, iQuery only N/A 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
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

Tender Fixed Period 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
Business Hour busHour Yes, for iQuery only N/A Integer Integer
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
Day Part dayPart N/A N/A String Text
Day Part Number dayPartNumber 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
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
Quarter Hour qtrHr Yes, for iQuery only N/A 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
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