Recommended Field List

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.

Tender Information

Name

Example

Description

Note

Payment Type

Debit, Credit

Credit card vs Debit card transaction

Card Scheme

Visa, Mastercard, AMEX

The network the card was issued on

Last 4

2393

Last 4 digits on the debit card, credit card

Amount

34.50

Amount paid for goods/services

Currency Code

USD, CAD

3 lettered code of the currency the amount is in

Merchant Information

Name

Example

Description

Notes

Raw Merchant Name

Bob's Convenience Store at Shell Gas 143

Clean Merchant Name

Shell

Address

123 Main Street

City

Boston

State

MA

Zip Code

02108

Merchant Category Code (MCC)

9301

Category

Convenience

Store ID

143

Transaction Origin

Physical

Delineation of where the transaction took place, whether in store or online

Customer Information

Name

Example

Description

Notes

Unique Customer Token

50198WEN370032

Unique Account Token

120801713803003

Transaction Information

Name

Example

Description

Notes

Unique Transaction ID

21980107303829034

Description

Bob's Convenience Boston MA

Authorization Code

102481

Six digit alphanumeric code passed between banks that signal a transaction is possible

Acquirer Reference Number (ARN)

1209481040110814

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)


Did this page help you?