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.

Payment 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

BIN

392019

Bank Identification Number associated with the card used

BINs will soon be 8 digits in length

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

Merchant Name

Shell

Banner name of the merchant

Address

123 Main Street

If ecommerce, should be null

City

Boston

If ecommerce, should be null

State

MA

If ecommerce, should be null

Zip Code

02108

If ecommerce, should be null

Merchant Category Code (MCC)

9301

Acquirer assigned category code

Category

Convenience

MCC code name

Store ID

143

ID for the specific location under the merchant

Transaction Origin

Physical

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

Merchant Identification Number (MID)

132480128410647

A merchant identification number (MID) is a distinctive, numerical code that identifies a merchant to their acquirer.

Customer Information

Name

Example

Description

Notes

Customer Token

50198WEN370032

Transaction Information

Name

Example

Description

Notes

Unique Transaction ID

21980107303829034

Purchase Timestamp

2021-11-01 01:34

When end customer completed their transaction

This can differ from when the transaction is received from the Banyan client

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?