How to Query all Credit Card transactions associated with a specific household in DB Inquiry
RecTrac 3.1.10.29.00
Table of Contents
Problem
I would like to see all credit card transactions associated with a specific household.
Solution
To find all credit card transactions associated with a specific household the easiest way is to query the SACreditCardHistory table using the ParentID of the household in question.
Steps For Solution
- Find the household number for the household in question.
- From the RecTrac main menu, go to DB Inquiry.
- Change Select table to view to SAHousehold.
- Enter your query into the Query field using Householdnumber = "XXXXXXX" syntax.
- Click View.
- Find the column labeled ID and take note of the household ID.
- Click Close.
- Change Select table to view to SACreditCardHistory.
- Enter your query into the Query area using ParentID = "XXXXX" syntax.
- ParentID is the ID from the household you identified in step 6.
- Click View.
Here you will find a list of all of the credit card transactions associated with that household.
Note:
The DeviceCodeLink field should reference which profile was used to process the transaction.