Batch: Recommended Field List

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.

Transaction Information

NameExampleData TypeDescriptionNotes
Unique Transaction ID21980107303829034String
Purchase Timestamp2021-11-01 01:34RFC3339 if CSV, Epoch Millis if AvroWhen end customer completed their transactionThis can differ from when the transaction is received from the Banyan client
DescriptionBob's Convenience Boston MAString
Authorization Code102481StringSix digit alphanumeric code passed between banks that signal a transaction is possible
Acquirer Reference Number (ARN)1209481040110814StringA 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)

Payment Information

NameExampleData TypeDescriptionNote
Payment TypeDebit, CreditStringCredit card vs Debit card transaction
Card SchemeVisa, Mastercard, AMEXStringThe network the card was issued on
Card Last 42393NumericLast 4 digits on the debit card, credit card
BIN392019StringBank Identification Number associated with the card usedBINs will soon be 8 digits in length
Total Amount34.50NumericAmount paid for goods/services
Currency CodeUSD, CADString3 lettered code of the currency the amount is in

Merchant Information

NameExampleData TypeDescriptionNotes
Raw Merchant NameBob's Convenience Store at Shell Gas 143String
Merchant NameShellStringBanner name of the merchant
Address123 Main StreetStringIf ecommerce, should be null
CityBostonStringIf ecommerce, should be null
StateMAStringIf ecommerce, should be null
Zip Code02108StringIf ecommerce, should be null
Merchant Category Code (MCC)9301StringAcquirer assigned category code
Merchant Category Code NameConvenienceStringMCC code name
Store ID143StringID for the specific location under the merchant
Order TypeIn Store, Web, App, PhoneStringDelineation of where the transaction took place
Merchant Identification Number (MID)132480128410647StringA merchant identification number (MID) is a distinctive, numerical code that identifies a merchant to their acquirer.

Customer Information

NameExampleData TypeDescriptionNotes
Customer Token50198WEN370032StringFinX specified consumer token to be used for querying Banyan API Consumer History product
Customer Account Token1029470127401410StringFinX specified account IDAvailable if more than one user can share an account