Hotel Batch 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.

Payment Information

NameExampleData TypeDescriptionNotes
Payment TypeDebit, CreditStringCredit card vs Debit card transaction
Card SchemeVisa, Mastercard, AMEXStringThe network the card was issued on
Last 42393NumericLast 4 digits on the debit card, credit card
BIN918202StringBank Identification Number associated with the card usedSome BINs will be 8 digits in the near future
Amount34.50NumericAmount paid for goods/services

Location Information

NameExampleData TypeDescriptionNotes
Merchant NameUmbrella HotelsStringBusiness Name
Location ID12093710StringLocation Identifier
Hotel NameBoutique Hotel -NJStringThe legal / listed name of the store of the purchase
Store Display NameBoutique HotelStringThe banner name of the store of the purchase
Street Address 1100 Main StreetStringNumber and Street
Street Address 2Fl 2String
CityHolmdelStringCity of hotel
StateNJStringState of hotel
Zip/ Postal Code23908StringPostal code of the hotel
Country CodeUSAStringCountry code of the hotel
Phone555-555-5555StringPhone number of the hotel

Receipt Information

NameExampleData TypeDescriptionNotes
Itinerary Number120394032820StringYour unique ID rendered for each saleThis field will be the same for split tenders whereas your receipt ID will differ
Merchant ID345802717909StringMerchant IDA unique ID for each merchant POS, assigned by merchant bank
Guest Name(s)John Smith, Olivia SmithArrayNames of hotel guestsThis data will be either encrypted before it gets to Banyan or on ingestion and will stay encrypted to the consumer of the data
Purchase Timestamp2021-11-01 10:45:55RFC3339The time that payment is used to charge the total amount of the stayThis can be different than when the charge is posted to the financial institution. Please let Banyan know if this is the case
Reservation Timestamp2021-10-01 10:45:55RFC3339The time at which the reservation occurred (UTC if possible)
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)
Total Charges1000.00NumericAmount paid by the customer
Total Credits50.00NumericCashing in any points or other refunds associated with the stay
Receipt Bar Code URLwww.pickles.com/receipts/barcode/2StringThe URL of the barcode for the receipt if available
Receipt Image URLwww.pickles.com/receipts/images/29StringThe URL for the image of the receipt if available

📘

As rates change per day, Banyan has "Per Night Date" as a top level object that houses an array of fees/costs within each date value

Room Information

NameExampleData TypeDescriptionNote
Per Night Date2022-10-01DateDate of the chargeIllustrative to show that each field within room information is by day. Can be represented in local timezone.
Room Rate239NumericNightly rate for the room
Room DescriptionKing with Balcony and Ocean ViewStringLong name for the room
Room TypeKing SuiteStringType of bed

Tax Information

NameExampleData TypeDescriptionNote
Per Night Date2022-10-01DateDate of the chargeIllustrative to show that each field within tax information is by day. Can be represented in local timezone.
Tourism Tax20.00NumericAny revenue-generating measure targeted at tourists
State Occupancy14.00NumericOccupancy taxes typically apply to short-term lodging rentals, and go by many names, such as hotel tax, hotel/motel tax, lodging tax and transient room tax
City Occupancy7.00NumericOccupancy taxes typically apply to short-term lodging rentals, and go by many names, such as hotel tax, hotel/motel tax, lodging tax and transient room tax
Other TaxNumeric

Dining Information

NameExampleData TypeDescriptionNote
Per Night Date2022-10-01DateDate of the chargeIllustrative to show that each field within dining information is by day. Can be represented in local timezone.
Room Service Food Daily Amount14.99NumericAmount of food ordered in the room
Room Service Food DescriptionCaesar SaladArrayDescription of food ordered in the room
Room Service Tip2.99NumericAmount of tip on the room service
Mini Bar Charge Daily Amount15.00NumericAmount of mini bar charges
Mini Bar Charge Description15.00StringDescription of mini bar items

Fee and Cost Information

NameExampleData TypeDescriptionNote
Per Night Date2022-10-01DateDate of the chargeIllustrative to show that each field within dining information is by day. Can be represented in local timezone.
Resort Fee4.99NumericA daily resort fee is an additional fee charged by the property for guests to enjoy their amenities.
Incidental Cost8.99NumericGratuities and other minor fees or costs incurred
Parking Fee25NumericDaily amount for parking
Business Center Fee9.99NumericDaily amount for using the business center
Laundry Fee8.99NumericCharge for using laundry service
Upgrade Fee29.99NumericUpgrading to a higher priced room
Cancellation Fee25NumericFee for cancelling outside of the refund window
No Show Fee50NumericNot showing up for the reservation
Other Fee2.99NumericUse for any fee particular to your fee list that isn't already covered by Banyan's schema

Customer Information

NameExampleData TypeDescriptionNote
Custom field for loyalty group 110290StringA segment of customers you later want to filter on/see as a dimension in your reports
Custom field for loyalty group 223424StringA second segment of customers you later want to filter on/see as a dimension in your reports

🚧

These are logical groupings of fields and should have no bearing on how you break up or flatten the data you send to Banyan