Transactions and Transaction Details Subject Areas

The transaction and transaction details subject areas contain data at a check or check detail level for operations, menu item sales, discounts, tender, service charge, tax, or SPI payment details. It also includes non-sales details. 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 check. The subject areas include:

• Discount Transaction Details
• Guest Checks
• Menu Item Transaction Details
• Non Sales Transaction Details
• Service Charge Transaction Details
• SPI Payment Details
• Tax Guest Checks
• Tender Media Transaction Details

Discount Transaction Details

Data Permission: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Authorizing Employee	authEmp	N/A	N/A	String	Text
Business Date	busDate	Business Date	N/A	Date	Date
Check Employee	chkEmp	N/A	N/A	String	Text
Check Line Count	chkLineCnt	N/A	N/A	Integer	Integer
Check Line Total	chkLineTtl	N/A	N/A	Decimal2	Currency
Check Number	chkNum	N/A	N/A	Integer	Integer
Day Part	dayPart	N/A	N/A	String	Text
Discount Location Name	discLoc	N/A	N/A	String	Text
Discount Master Name	discMasterName	N/A	N/A	String	Text
Discount Number	discNum	N/A	N/A	String	Text
Do Not Show Flag	doNotShowFlag	N/A	N/A	Integer	Integer
Error Correct Flag	errCorFlag	N/A	N/A	Integer	Integer
Guest Check Line Item ID	chkLineId	N/A	N/A	String	Text
Location	locName	N/A	N/A	String	Text
Meal Employee	mealEmp	N/A	N/A	String	Text
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
Quarter Hour	qtrHr	N/A	N/A	Integer	Integer
Reference Information Line 1	refInfo1	N/A	N/A	String	Text
Report Line Count	rptLineCnt	N/A	N/A	Integer	Integer
Report Line Total	rptLineTtl	N/A	N/A	Decimal2	Currency
Revenue Center	rvc	Revenue Center	N/A	String	Text
Seat Number	seat	N/A	N/A	Integer	Integer
Total VAT/GST/Inclusive Taxes Amount	inclTaxTtlAmount	N/A	N/A	Decimal2	Currency
Transaction Date and Time	transDate	N/A	N/A	Date	Date
Transaction Employee	transEmp	N/A	N/A	String	Text
Void Flag	void	N/A	N/A	Integer	Integer
Void Reason Code	vdReason	N/A	N/A	Integer	Integer

Guest Checks

Data Permission: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Auto Closed Flag	autoClosedFlag	N/A	N/A	Integer	Integer
Check Information	chkInfo	N/A	N/A	String	Text
Check Number	chkNum	N/A	N/A	Integer	Integer
Check Reference	chkRef	N/A	N/A	String	Text
Check Total	chkTtl	N/A	Measure	Decimal2	Currency
Close Business Date	clsdBusDate	Business Date	N/A	Date	Date
Closed Date and Time	clsdTime	N/A	N/A	Date-time	Date-time
Close Quarter Hour Number	clsdQtrHr	Yes, iQuery only	N/A	Integer	Integer
Discount Amount	discAmt	N/A	Measure	Decimal2	Currency
Employee Number	empNum	N/A	N/A	Integer	Integer
Error Correct Amount	errCorAmt	N/A	Measure	Decimal2	Currency
Guest Count	guestCnt	N/A	Measure	Integer	Integer
Inclusive Tax Exempt Total	inclTaxExmpTtl	N/A	Measure	Decimal2	Currency
Item Count	ItemCnt	N/A	Measure	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
Manager Void Amount	mgrVdAmt	N/A	Measure	Decimal2	Currency
Number of Service Rounds	numSrvcRnd	N/A	Measure	Integer	Integer
Open Business Date	opnBusDate	Business Date	N/A	Date	Date
Open Date and Time	opnTime	N/A	N/A	Date-time	Date-time
Open Quarter Hour Number	opnQtrHr	Yes, iQuery only	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
Return Amount	retAmt	N/A	Measure	Decimal2	Currency
Revenue Center	rvc	Revenue Center	N/A	String	Text
Service Charge Amount	srvcChrgTip	N/A	Measure	Decimal2	Currency
Subtotal	subTtl	N/A	Measure	Decimal2	Currency
Table Group Number	tblGrpNum	N/A	N/A	Integer	Integer
Table Reference	tblRef	N/A	N/A	String	Text
Tax Amount	taxAmt	N/A	Measure	Decimal2	Currency
Tax Exempt	ExmptTax	N/A	Measure	Decimal2	Currency
Total Tip Amount	tipAmt	N/A	Measure	Decimal2	Currency
Total VAT/GST/Inclusive Taxes Amount	inclTaxAmt	N/A	Measure	Decimal2	Currency
Transfer Status	xferStat	N/A	N/A	String	Text
Transfer To Check Number	xferChkNum	N/A	N/A	Integer	Integer
Void Amount	vdAmt	N/A	Measure	Decimal2	Currency

Menu Item Transaction Details

Data Permission: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Authorizing Employee	authEmp	N/A	N/A	String	Text
Business Date	busDate	Business Date	N/A	Date	Date
Check Employee	chkEmp	N/A	N/A	String	Text
Check Line Count	chkLineCnt	N/A	N/A	Integer	Integer
Check Line Total	chKLineTtl	N/A	N/A	Decimal2	Currency
Check Number	chkNum	N/A	N/A	Integer	Integer
Cost of Goods Sold	cogs	N/A	N/A	Decimal2	Currency
Day Part	dayPart	N/A	N/A	String	Text
Do Not Show Flag	doNotShowFlag	N/A	N/A	Integer	Integer
Error Correct Flag	errCorFlag	N/A	N/A	Integer	Integer
Family Group Name	familyGrp	Yes for iQuery only	N/A	String	Text
Family Group Number	familyGrpNum	N/A	N/A	String	Text
Guest Check Line Item ID	ChkLineId	N/A	N/A	String	Text
Location	locName	Location	N/A	String	Text
Major Group Name	majorGrp	Yes for iQuery only	N/A	String	Text
Major Group Number	majorGrpNum	N/A	N/A	String	Text
Menu Item External Reference 1	itemExtRef1	N/A	N/A	String	Text
Menu Item External Reference 2	itemExtRef2	N/A	N/A	String	Text
Menu Item Master Name	itemMasterName	N/A	N/A	String	Text
Menu Item Name	itemName	N/A	N/A	String	Text
Menu Item Number	itemNum	N/A	N/A	String	Text
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
Quarter Hour	qtrHr	Yes	N/A	Integer	Integer
Reference Information Line 1	refInfo1	N/A	N/A	String	Text
Report Line Count	rptLineCnt	N/A	N/A	Integer	Integer
Report Line Total	rptLineTtl	N/A	N/A	Decimal2	Currency
Return Flag	retFlag	N/A	N/A	Integer	Integer
Revenue Center	rvc	Revenue Center	N/A	String	Text
Sales Net VAT/GST/Taxes	salesNetTax	N/A	N/A	Decimal2	Currency
Seat Number	seat	N/A	N/A	Integer	Integer
Total VAT/GST/Inclusive Taxes Amount	inclTaxTtlAmount	N/A	N/A	Decimal2	Currency
Transaction Date and Time	transDate	N/A	N/A	Date	Date
Transaction Employee	transEmp	N/A	N/A	String	Text
Void Flag	void	N/A	N/A	Integer	Integer
Void Reason Code	vdReason	N/A	N/A	Integer	Integer
Weight	weight	N/A	N/A	Decimal2	Currency

Non Sales Transaction Details

Data Permission: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Amount	amt	N/A	N/A	Decimal2	Currency
Business Date	busDate	Business Date	N/A	Date	Date
Check Number	chkNum	N/A	N/A	Integer	Integer
Day Part	dayPart	N/A	N/A	String	Text
Location Name	locName	Location	N/A	String	Text
Non Sales ID	noSlsNum	N/A	Measure	String	Text
Non Sales Type	noSlsType	N/A	Measure	Integer	Integer
Quarter Hour	qtrHr	Yes, iQuery only	N/A	Integer	Integer
Reference Information Line 1	refInfo1	N/A	N/A	String	Text
Revenue Center Name	rvc	Revenue Center	N/A	String	Text
Tender/Media Location Name	tndrMedLocName	N/A	N/A	String	Text
Transaction Date and Time	transDate	N/A	Measure	Date	Date
Workstation	wsNum	N/A	Measure	Integer	Integer

Service Charge Transaction Details

Data Permissions: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Authorizing Employee	authEmp	N/A	N/A	String	Text
Business Date	busDate	Business Date	N/A	Date	Date
Check Employee	chkEmp	N/A	N/A	String	Text
Check Line Count	chkLineCnt	N/A	N/A	Integer	Integer
Check Line Total	chkLineTtl	N/A	N/A	Decimal2	Currency
Check Number	chkNum	N/A	N/A	Integer	Integer
Day Part	dayPart	N/A	N/A	String	Text
Do Not Show Flag	doNotShowFlag	N/A	N/A	Integer	Integer
Error Correct Flag	errCorflag	N/A	N/A	Integer	Integer
Guest Check Line Item ID	chkLineId	N/A	N/A	String	Text
Location	locName	Location	N/A	String	Text
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
Quarter Hour	qtrHr	Yes, for iQuery only	N/A	Integer	Integer
Reference Info Line 1	refInfo1	N/A	N/A	String	Text
Report Line Count	rptLineCnt	N/A	N/A	Integer	Integer
Report Line Total	rptLineTtl	N/A	N/A	Decimal2	Currency
Revenue Center	rvc	Revenue Center	N/A	String	Text
Seat Number	seat	N/A	N/A	Integer	Integer
Service Charge Location Name	srvcChrgLoc	N/A	N/A	String	Text
Service Charge Master Name	srvcChrgName	N/A	N/A	String	Text
Service Charge Number	srvcChrgNum	N/A	N/A	String	Text
Total VAT/GST/Inclusive Taxes Amount	inclTaxTtlAmount	N/A	N/A	Decimal2	Currency
Transaction Date and Time	transDate	N/A	N/A	Date	Date
Transaction Employee	transEmp	N/A	N/A	String	Text
Void Flag	void	N/A	N/A	Integer	Integer
Void Reason Code	vdReason	N/A	N/A	Integer	Integer

SPI Payment Details

Data Permission: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Authorization Code	authCode	N/A	N/A	String	Text
Business Date	busDate	Business Date	N/A	Date	Date
Business Hour	busHour	Yes, for iQuery only	N/A	Integer	Integer
Card Alias	crdAlias	N/A	N/A	String	Text
Card Present Flag	crdPrsntFlag	Yes, for iQuery only	N/A	String	Text
Check Number	chkNum	Yes, for iQuery only	N/A	Integer	Integer
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
Employee Name	employeeName	N/A	N/A	String	Text
Employee Number	empNum	N/A	N/A	Integer	Integer
Entry Mode Name	entryModeName	N/A	N/A	String	Text
Entry Mode Number	entryModeNum	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
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
Offline Flag	offlineFlag	N/A	N/A	String	Text
Payment Service Provider Reference	pspRef	Yes, for iQuery only	N/A	String	Text
Payment Type	pymntType	Yes, for iQuery only	N/A	String	Text
Quarter Hour	qtrHr	Yes, for iQuery only	N/A	Integer	Integer
Retrieval Reference Number	rrn	N/A	N/A	String	Text
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
Sequence Number	SeqNum	N/A	N/A	String	Text
Tender Name	tndrName	N/A	N/A	String	Text
Tender Number	tndrNum	N/A	N/A	Integer	Integer
Terminal ID	termID	N/A	N/A	String	Text
Tip Amount	tipAmt	N/A	Measure	Decimal2	Currency
Transaction Amount	transAmt	N/A	Measure	Decimal2	Currency
Transaction Date Time	transDateTime	N/A	N/A	Date-Time	Date-Time
Workstation Name	wsName	N/A	N/A	String	Text
Workstation Number	wsNum	N/A	N/A	Integer	Integer

Tax Guest Checks

Data Permission: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Check Number	chkNum	N/A	N/A	Integer	Integer
Check Reference	chkRef	N/A	N/A	String	Text
Check Total	chkTtl	N/A	Measure	Decimal2	Currency
Closed Business Date	clsdBusDate	Yes, for iQuery only	N/A	Date	Date
Closed Date and Time	clsdTime	N/A	N/A	Date-Time	Date-Time
Closed Quarter Hour Number	clsdQtrHr	Yes, for iQuery only	N/A	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
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
Open Business Date	opnBusDate	Yes, for iQuery only	N/A	Date	Date
Open Date and Time	opnTime	N/A	N/A	Date-Time	Date-Time
Open Quarter Hour Number	opnQtrHr	Yes, for iQuery only	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
Revenue Center Name	rvc	Revenue Center	N/A	String	Text
Service Charges Amount	servChrgTip	N/A	Measure	Decimal2	Currency
Subtotal	subTtl	N/A	Measure	Decimal2	Currency
Table Group Number	tblGrpNum	N/A	N/A	Integer	Integer
Table Reference	tblRef	N/A	N/A	String	Text
Tax Amount	taxAmt	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	taxRate	N/A	N/A	Decimal2	Currency
Tax Type	taxType	N/A	N/A	Integer	Integer

Tender Media Transaction Details

Data Permissions: Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Authorizing Employee	authEmp	N/A	N/A	String	Text
Business Date	busDate	Business Date	N/A	Date	Date
Check Employee	chkEmp	N/A	N/A	String	Text
Check Line Count	chkLineCnt	N/A	N/A	Integer	Integer
Check Line Total	chkLineTtl	N/A	N/A	Decimal2	Currency
Check Number	chkNum	N/A	N/A	Integer	Integer
Day Part	dayPart	N/A	N/A	String	Text
Error Correct Flag	errCorFlag	N/A	N/A	Integer	Integer
Guest Check Line Item ID	chkLineId	N/A	N/A	String	Text
Location	locName	Location	N/A	String	Text
Meal Employee	mealEmp	N/A	N/A	String	Text
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
Quarter Hour	qtrHr	Yes, for iQuery only	N/A	Integer	Integer
Reference Information Line 1	refInfo1	N/A	N/A	String	Text
Reference Information Line 2	refInfo2	N/A	N/A	String	Text
Report Line Count	rptLineCnt	N/A	N/A	Integer	Integer
Report Line Total	rptLineTtl	N/A	N/A	Decimal2	Currency
Revenue Center	rvc	Revenue Center	N/A	String	Text
Seat Number	seat	N/A	N/A	Integer	Integer
Tender/Media Location Name	tndrMedLocName	N/A	N/A	String	Text
Tender/Media Master Name	tndrMedMastName	N/A	N/A	String	Text
Tender/Media Number	tndrMedNum	N/A	N/A	String	Text
Transaction Date and Time	transDate	N/A	N/A	Date	Date
Transaction Employee	transEmp	N/A	N/A	String	Text
Void Flag	void	N/A	N/A	Integer	Integer
Void Reason Code	vdReason	N/A	N/A	Integer	Integer