We will accept data that is flattened (joined together) or as separate tables with foreign keys. We understand that the nomenclature used here may not match what is in your data warehouse - that is okay! We will use part of the onboarding process to confirm our understanding of the data you send before the programmatic setup begins.
Required vs Preferred Fields
All red items in the list are required for match integrity. If you are unable to send a required field Banyan will work with you to find a proxy.
Credit card vs Debit card transaction
Visa, Mastercard, AMEX
The network the card was issued on
Last 4 digits on the debit card, credit card
Amount paid for goods/services
3 lettered code of the currency the amount is in
Raw Merchant Name
Bob's Convenience Store at Shell Gas 143
Clean Merchant Name
123 Main Street
Merchant Category Code (MCC)
Delineation of where the transaction took place, whether in store or online
Unique Customer Token
Unique Account Token
Unique Transaction ID
Bob's Convenience Boston MA
Six digit alphanumeric code passed between banks that signal a transaction is possible
Acquirer Reference Number (ARN)
A unique 16-digit number that tags a credit or debit card transaction when it goes from the merchant’s bank through to the cardholder's bank. Also called a trace ID, this number is often used to determine where a transaction's funds lie at a certain time, and make a transaction traceable in case of an error in bank or merchant accounts.
Note: only available with some payment schemes (VISA / Mastercard / Discover)
Updated 10 days ago