How to Find all Credit Cards linked to a specific Household
RecTrac 3.1.10.28.00
Table of Contents
Problem
I need to be able to see all cards from all gateways // processors that are linked to a specific household.
Solution
You can use DB Inquiry to obtain the ID of a household from the SAHousehold table, then use that ID to query the EpayInfo table to see a list of all cards that have been linked to that household.
Note:
To be PCI compliant, the full credit card number is not stored anywhere in the database. You will see instead a masked number that represents this value.
Steps For Solution
- From the RecTrac main menu, go to DB Inquiry.
- Change Select table to view to be SAHousehold.
- Enter your query into the Query area using Householdnumber = "household number here".
- Click View.
- Find the column labeled ID and take note of the ID (either jot it down or take a screenshot).
- Click Close.
- Change Select table to view to be EpayInfo.
- Enter your query into the query area using ParentID = "the id from the household you just jotted down or took a screenshot of".
- Click View.
Here you will find a list of all of the cards associated with that household. An important note would be that the AccountID field should reference which profile was used to create the token.