Gift and Loyalty Subject Areas

This group of subject areas includes data points related to Gift and Loyalty transactions and customer details. Data in these subject areas is only available for customers subscribed to the Gift and Loyalty Cloud Service. The subject areas include:

• Gift and Loyalty
• Gift and Loyalty Account
• Gift and Loyalty CA Customer Program
• Gift and Loyalty CA Email Offers
• Gift and Loyalty CA Email Sent Opened
• Gift and Loyalty Coupon
• Gift and Loyalty Coupon Types
• Gift and Loyalty Customer Detail
• Gift and Loyalty Customer Overview
• Gift and Loyalty Customer Summary
• Gift and Loyalty Customer Transaction Summary
• Gift and Loyalty Redeemed Coupon
• Gift and Loyalty Transaction

Gift and Loyalty

Data Permission: Gift and Loyalty General.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Description	descript	N/A	N/A	String	Text
Name	progName	N/A	N/A	String	Text
Points Name	ptsName	N/A	N/A	String	Text
Type	accType	N/A	N/A	Integer	Integer

Gift and Loyalty Account

Data Permissions: Gift and Loyalty General and Customer Identifiable Information.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Account Number	accPos	N/A	N/A	String	Text
Account Status	accStat	Yes, for iQuery only	N/A	Integer	Integer
Activate Or Issue Date	activeIssueDate	N/A	N/A	Date	Date
Balance Total	balTtl	N/A	N/A	Decimal2	Currency
Bonus Amount	bonusTtl	N/A	N/A	Decimal2	Currency
Card Rule	progCardRule	N/A	N/A	String	Text
Credit Amount	credTtl	N/A	N/A	Decimal2	Currency
Currency ISO Code	currIsoCode	N/A	N/A	String	Text
Debit Amount	debTtl	N/A	N/A	Decimal2	Currency
First Transaction Business Date	firstTransBusDate	N/A	N/A	Date	Date
Initial Credit Total	initCredTtl	N/A	N/A	Decimal2	Currency
Initial Load Date	initLoadDate	N/A	N/A	Date	Date
Last Name	surname	N/A	N/A	String	Text
Last Transaction Business Date	lastTransBusDate1	N/A	N/A	Date	Date
Lifetime Credit Amount	lifetimeTtl	N/A	N/A	Decimal2	Currency
Lifetime Discount Amount	lifetimeDisc	N/A	N/A	Decimal2	Currency
Miscellaneous 1 Total	miscTtl1	N/A	N/A	Decimal2	Currency
Miscellaneous 2 Total	miscTtl2	N/A	N/A	Decimal2	Currency
Miscellaneous 3 Total	miscTtl3	N/A	N/A	Decimal2	Currency
Miscellaneous 4 Total	miscTtl4	N/A	N/A	Decimal2	Currency
Month to Date Credit Amount	mtdCredTtl	N/A	N/A	Decimal2	Currency
PIN	AccPin	N/A	N/A	String	Text
Points Start Date	ptStartDate	N/A	N/A	Date	Date
Program	progName	Yes, for iQuery only	N/A	String	Text
Reconciliation Location	reconLoc	Yes, for iQuery only	N/A	String	Text
Reserved Total	resTtl	N/A	N/A	Decimal2	Currency
Transfer Account Number	xferToPos	N/A	N/A	String	Text
Type	AccType	Yes, for iQuery only	N/A	Integer	Integer
Valid Until Date	validDate	N/A	N/A	Date	Date
Year to Date Credit Amount	ytdCredTtl	N/A	N/A	Decimal2	Currency
Year to Date Discount Amount	ytdDiscTtl	N/A	N/A	Decimal2	Currency

Gift and Loyalty CA Customer Program

Data Permissions: Gift and Loyalty General, Sales and Operations, and Customer Identifiable Information.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Account Balance Total	accBalTtl	N/A	N/A	Decimal2	Currency
Account Expired	accExp	N/A	N/A	Date	Date
Account Lifetime Credit Amount	accLifeCredTtl	N/A	N/A	Decimal2	Currency
Account Status	accStat	N/A	N/A	Integer	Integer
Account Transfer to Customer Number	accXferPos	N/A	N/A	String	Text
Account Year To Date Credit Amount	accYtdCredTttl	N/A	N/A	Decimal2	Currency
CA Customer ID	caCustNum	N/A	N/A	String	Text
Card Rule Name	crdRule	N/A	N/A	String	Text
Category	origCustPosRef	N/A	N/A	String	Text
Customer Number	custPosRef	N/A	N/A	String	Text
First Transaction Business Date	firstTransBusDate	N/A	N/A	Date	Date
Last Transaction Date	lastTransBusDate	N/A	N/A	Date	Date
Net Sales	netSls	N/A	N/A	Decimal2	Currency
Program	progName	N/A	N/A	String	Text
Transactions Count	transCnt	N/A	N/A	Integer	Integer

Gift and Loyalty CA Email Offers

Data Permissions: Gift and Loyalty General and Customer Identifiable Information.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Category	cat	N/A	N/A	String	Text
Coupon Code	coupNum	N/A	N/A	String	Text
Coupon Type	coupoType	N/A	N/A	String	Text
Description	descript	N/A	N/A	String	Text
Effective From	effectFrom	N/A	N/A	Date	Date
Effective To	effectTo	N/A	N/A	Date	Date
Name	offerName	N/A	N/A	String	Text
Type	accType	N/A	N/A	String	Text

Gift and Loyalty CA Email Sent Opened

Data Permission: Gift and Loyalty General.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
CA Customer ID	caCustNum	N/A	N/A	String	Text
Campaign Name	campaign	Yes, for iQuery only	N/A	String	Text
Coupon Code	coupNum	Yes, for iQuery only	N/A	String	Text
Coupon Serial Number	coupSerial	N/A	N/A	String	Text
Last Name	surname	N/A	N/A	String	Text
Offer Name	name	Yes, for iQuery only	N/A	String	Text
Promotion	promo	Yes, for iQuery only	N/A	String	Text
Received Date and Time	receiveDate	N/A	N/A	Date	Date
Sent Date and Time	sentDate	N/A	N/A	Date	Date
Text1	caText1	N/A	N/A	String	Text
Text2	caText2	N/A	N/A	String	Text

Gift and Loyalty Coupon

Data Permissions: Gift and Loyalty General and Customer Identifiable Information.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Account Number	accPos	N/A	N/A	String	Text
Coupon Code	coupNum	Yes, for iQuery only	N/A	String	Text
Coupon Type	coupType	Yes, for iQuery only	N/A	String	Text
Created Host Date and Time	createHostDate	Yes, for iQuery only	N/A	Date	Date
Created Local Date and Time	createLocalDate	N/A	N/A	Date	Date
Customer Full Name	custFullName	N/A	N/A	String	Text
Issued Host Date and Time	issueHostDate	N/A	N/A	Date	Date
Issued Local Date and Time	issueLocalDate	N/A	N/A	Date	Date
Issued Location	issueLoc	Location	N/A	String	Text
Issued State	issueState	N/A	N/A	Integer	Integer
Promotion	promo	N/A	N/A	String	Text
Serial Number	serNum	N/A	N/A	String	Text
Valid Until Date	validDate	N/A	N/A	Date	Date

Gift and Loyalty Coupon Types

Data Permission: Gift and Loyalty General.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Coupon Code	coupNum	N/A	N/A	String	Text
Coupon Name	coupName	N/A	N/A	String	Text
Description	descript	N/A	N/A	String	Text

Gift and Loyalty Customer Detail

Data Permissions: Gift and Loyalty General and Customer Identifiable Information.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Address Line 1	addr1	N/A	N/A	String	Text
Address Line 2	addr2	N/A	N/A	String	Text
Anniversary Date	custAnni	N/A	N/A	Date	Date
Birth Day of Month	birthMonthDay	N/A	N/A	Integer	Integer
Birth Month	custbirthMonth	N/A	N/A	Integer	Integer
CA Customer ID	caCustNum	N/A	N/A	String	Text
Cell Phone Number	custMobNum	N/A	N/A	String	Text
City	addrCity	N/A	N/A	String	Text
Concierge	conc	N/A	N/A	Integer	Integer
County	addrCounty	N/A	N/A	String	Text
Created Date	dateCreated	N/A	N/A	Date	Date
Customer Number	custPosRef	N/A	N/A	String	Text
Date of Birth	custBthDay	Yes, for iQuery only	N/A	Date	Date
Distance	dist	N/A	N/A	Decimal2	Currency
Email	custEmail	N/A	N/A	String	Text
Email Channel Deliverable	emailChnlDel	N/A	N/A	Integer	Integer
Email Channel Status	emailChnlStat	N/A	N/A	Integer	Integer
First Name	forename	N/A	N/A	String	Text
First Transaction Business Date	firstTransBusDate	Yes, for iQuery only	N/A	Date	Date
Gender	custGender	N/A	N/A	String	Text
Home Phone Channel Deliverable	homePhDel	N/A	N/A	Integer	Integer
Home Phone Channel Status	homePhStat	N/A	N/A	Integer	Integer
Home Phone Number	homePhNum	N/A	N/A	String	Text
Is Cleaned	clean	N/A	N/A	Integer	Integer
Is Deduped	dedup	N/A	N/A	Integer	Integer
Last Name	surname	N/A	N/A	String	Text
Last Transaction Date	lastTransBusDate	Yes, for iQuery only	N/A	Date	Date
Last Updated By	updateBy	N/A	N/A	String	Text
Last Updated Date	updatedDate	N/A	N/A	Date	Date
Latitude	lat	N/A	N/A	String	Text
Longitude	long	N/A	N/A	String	Text
Mail Channel Deliverable	mailChnlDel	N/A	N/A	Integer	Integer
Mail Channel Status	mailChnlStat	N/A	N/A	Integer	Integer
Meeting Planner	meetPlanner	N/A	N/A	Integer	Integer
Middle Name	midName	N/A	N/A	String	Text
Miscellaneous Field 1	misc1	N/A	N/A	String	Text
Miscellaneous Field 2	misc2	N/A	N/A	String	Text
Miscellaneous Field 3	misc3	N/A	N/A	String	Text
Miscellaneous Field 4	misc4	N/A	N/A	String	Text
Name Prefix	namePrefix	N/A	N/A	String	Text
Name Suffix	nameSuffix	N/A	N/A	String	Text
Other Channel Deliverable	otherChnlDel	N/A	N/A	Integer	Integer
Parent Customer First Name	parCustFirstName	N/A	N/A	String	Text
Parent Customer Last Name	parCustLastName	N/A	N/A	String	Text
Parent Customer Number	parCustPos	N/A	N/A	String	Text
Parent Customer Relationship	parCustRelat	N/A	N/A	Integer	Integer
Password	pwd	N/A	N/A	String	Text
Password Hint	pwdHint	N/A	N/A	String	Text
PMA Code	pma	N/A	N/A	String	Text
Reissue New Customer Kit Counter	reissueCustKitCnt	N/A	N/A	Integer	Integer
Reissue New Customer Kit Date	reissueCustKitDate	N/A	N/A	Date	Date
Replace Card Counter	replaceCrdCnt	N/A	N/A	Integer	Integer
Replace Card Date	replaceCrdDt	N/A	N/A	Date	Date
Sign-up Date	dateOfSignup	N/A	N/A	Date	Date
Sign-up Location	signupLoc	N/A	N/A	String	Text
State	addrState	N/A	N/A	String	Text
Use For Test Email	useTestEmail	N/A	N/A	Integer	Integer
User Defined Alpha 1	userA1	N/A	N/A	String	Text
User Defined Alpha 2	userA2	N/A	N/A	String	Text
User Defined Numeric 1	userNum1	N/A	N/A	Decimal2	Currency
User Defined Numeric 2	userNum2	N/A	N/A	Decimal2	Currency
User ID Number	userId	N/A	N/A	String	Text
User Name	custUserName	N/A	N/A	String	Text
Work Phone Number	workPhNum	N/A	N/A	String	Text
Zip Code	postCode	N/A	N/A	String	Text

Gift and Loyalty Customer Overview

Data Permissions: Gift and Loyalty General and Customer Identifiable Information.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
CA Customer ID	caCustNum	N/A	N/A	String	Text
City	addrCity	N/A	N/A	String	Text
Credit Limit	credLim	N/A	N/A	Decimal2	Currency
Customer ID	custNum	N/A	N/A	Integer	Integer
Customer Information Status	custInfoStat	Yes, for iQuery only	N/A	Integer	Integer
Customer Name	custFullName	N/A	N/A	String	Text
Customer Number	custPosRef	N/A	N/A	String	Text
Date of Birth	custBthDay	N/A	N/A	Date	Date
Email	custEmail	N/A	N/A	String	Text
First Name	forename	N/A	N/A	String	Text
Home Phone Number	homePhNum	N/A	N/A	String	Text
Last Name	surname	N/A	N/A	String	Text
Program Code	progNum	Yes, for iQuery only	N/A	String	Text
Sign-up Date	dateOfSignup	N/A	N/A	Date	Date
Work Phone Number	workPhNum	N/A	N/A	String	Text
Zip Code	postCode	N/A	N/A	String	Text

Gift and Loyalty Customer Summary

Data Permissions: Gift and Loyalty General, Customer Identifiable Information, and Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Active	custActive	N/A	N/A	Integer	Integer
Address Line 1	addr1	N/A	N/A	String	Text
Address Line 2	addr2	N/A	N/A	String	Text
Cell Phone Number	custMobNum	N/A	N/A	String	Text
Check Count	checkCnt	N/A	N/A	Decimal2	Currency
City	addrCity	N/A	N/A	String	Text
Country	addrCountry	N/A	N/A	String	Text
County	addrCounty	N/A	N/A	String	Text
Customer External Reference	custExtRef	N/A	N/A	String	Text
Customer Full Name	custFullName	N/A	N/A	String	Text
Customer Number	custPosRef	N/A	N/A	String	Text
Date of Birth	custBthDay	N/A	N/A	Date	Date
Email	custEmail	N/A	N/A	String	Text
First Name	forename	N/A	N/A	String	Text
First Transaction Business Date	firstTransBusDate	N/A	N/A	Date	Date
Guest Count	guestCnt	N/A	N/A	Decimal2	Currency
Home Phone Number	homePhNum	N/A	N/A	String	Text
Last Name	surname	N/A	N/A	String	Text
Last Transaction Date	lastTransBusDate	N/A	N/A	Date	Date
Program	progName	N/A	N/A	String	Text
Sales Amount	ttl	N/A	N/A	Decimal2	Currency
Sign-up Date	dateOfSignup	N/A	N/A	Date	Date
State	addrState	N/A	N/A	String	Text
User Defined Alpha 1	userA1	N/A	N/A	String	Text
User Defined Alpha 2	userA2	N/A	N/A	String	Text
User Defined Numeric 1	userNum1	N/A	N/A	String	Text
User Defined Numeric 2	userNum2	N/A	N/A	String	Text
Work Phone Number	workPhNum	N/A	N/A	String	Text
Zip Code	postCode	N/A	N/A	String	Text

Gift and Loyalty Customer Transaction Summary

Data Permissions: Gift and Loyalty General, Customer Identifiable Information, and Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Address Line 1	addr1	N/A	N/A	String	Text
Address Line 2	addr2	N/A	N/A	String	Text
Business Date	busDate	Business Date	N/A	Date	Date
Check Number	chkNum	N/A	N/A	Integer	Integer
City	addrCity	N/A	N/A	String	Text
Customer Full Name	custFulName	N/A	N/A	String	Text
Customer Number	custPosRef	N/A	N/A	String	Text
Email	custEmail	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	locName	Location	N/A	String	Text
Location Number	locNum	N/A	N/A	String	Text
Program	progName	N/A	N/A	String	Text
Sales Amount	ttl	N/A	Measure	Decimal2	Currency
State	addrState	N/A	N/A	String	Text
Tender Name	tndrName	N/A	N/A	String	Text
Tender Number	tndrNum	N/A	N/A	Integer	Integer
Zip Code	postCode	N/A	N/A	String	Text

Gift and Loyalty Redeemed Coupon

Data Permissions: Gift and Loyalty General and Customer Identifiable Information.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Account Number	accPos	N/A	N/A	String	Text
Amount	amt	N/A	N/A	Decimal2	Currency
Coupon Code	coupNum	Yes, for iQuery only	N/A	String	Text
Coupon Type	coupType	Yes, for iQuery only	N/A	String	Text
Created Host Date and Time	createHostDate	N/A	N/A	Date	Date
Created Local Date and Time	createLocalDate	N/A	N/A	Date	Date
Customer Name	custFullName	N/A	N/A	String	Text
Issued Host Date and Time	issueHostDate	N/A	N/A	Date	Date
Issued Local Date and Time	issueLocalDate	N/A	N/A	Date	Date
Issued Location	issueLoc	N/A	N/A	String	Text
Promotion	promo	N/A	N/A	String	Text
Redeemed Host Date and Time	redeemHostDate	Business Date	N/A	Date	Date
Redeemed Local Date and Time	redeemLocalDate	N/A	N/A	Date	Date
Redeemed Location	redeemLoc	Location	N/A	String	Text
Reversal Status	reversalStat	N/A	N/A	Integer	Integer
Serial Number	serNum	N/A	N/A	String	Text

Gift and Loyalty Transaction

Data Permissions: Gift and Loyalty General and Sales and Operations.

Name	Alias	Filter/Parameter	Type (Measure or Attribute)	Data Type	Data Format
Account Number	accPos	N/A	N/A	String	Text
Account Transaction ID	accTransId	N/A	N/A	String	Text
Amount	amt	N/A	N/A	Decimal2	Currency
Authorization Code	TransAuthCode	N/A	N/A	String	Text
Balance	bal	N/A	N/A	Decimal2	Currency
Bonus Amount	bonusAmt	N/A	N/A	Decimal2	Currency
Bonus Points	bonusPts	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	Integer	Integer
Description	descript	N/A	N/A	String	Text
Employee Number	emplNum	N/A	N/A	Integer	Integer
Exchange Rate	exchRate	N/A	N/A	Decimal2	Currency
Local Currency Amount	locCurrAmt	N/A	N/A	Decimal2	Currency
Local Currency ISO Code	locCurrIsoCode	N/A	N/A	String	Text
Local Currency Tip Amount	locCurrTipAmt	N/A	N/A	Decimal2	Currency
Local Date and Time	localDate	N/A	N/A	Date	Date
Location	locName	Location	N/A	String	Text
Loyalty Rule Name	ruleName	N/A	N/A	String	Text
Offline Status	offlineStat	N/A	N/A	Integer	Integer
Point of Sale Platform	posPlat	N/A	N/A	String	Text
Point of Sale Terminal Number	posTermNum	N/A	N/A	String	Text
Point of Sale Version Number	posVer	N/A	N/A	Integer	Integer
Points	pts	N/A	N/A	Decimal2	Currency
Previous Balance	prevBal	N/A	N/A	Decimal2	Currency
Program	progName	Yes, for iQuery only	N/A	String	Text
Quarter Hour	qtrHr	N/A	N/A	Integer	Integer
Request Code	reqCode	N/A	N/A	String	Text
Revenue Center	rvc	Revenue Center	N/A	String	Text
Reversal Status	reversalStat	N/A	N/A	Integer	Integer
Trace ID	transTraceId	N/A	N/A	String	Text
Transaction Category	transCat	Yes, for iQuery only	N/A	Integer	Integer
Transaction Key	transKey	N/A	N/A	String	Text
Transferred Account	xferAccPos	N/A	N/A	String	Text