What can we help you find? Products Platform Integration Playbooks and Resources Other Integration Playbooks Corporate Credit Card Integration Corporate Card Mapping: MasterCard

Corporate Card Mapping: MasterCard

Revised: 25 February 2020

Note

The table below provides mapping data for MasterCard only. For a full list of mapping data for all cards together refer to the Integrations Mapping file.

Category Custom Field population requires configuration within a Coupa instance and data to be populated by corporate card provider on incoming files.

Expense UI Field	Corporate Card Normalized Name	MasterCard
Expense Line Fields
Description	Name by which the card acceptor is known/referred	CorporateCardLineItemDetail_5010/ItemDescription
Total	Amount the transaction was billed in. This is different from the original transaction amount, which could have been in a different currency and is usually the local currency the transaction took place in.	FinancialTransaction_5000/AmountInPostedCurrency
Currency	Currency the transaction was billed in. This is different from the original transaction currency, which could have been in a different currency and is usually the local currency the transaction took place in.	FinancialTransaction_5000/PostedCurrencyCode
Expense Category	Merchant Category Code (4 digit Code) of the card acceptor which classifies the type of business. MCC Code drives Category default on an expense line based on instance Corporate Credit Card Category Mapping setup.	CardAcceptor_5001/CardAcceptorBusinessCode
Merchant	Name of Merchant where expense was incurred	CardAcceptor_5001/CardAcceptorName
Date	Coupa maps the TransactionDate to Expense Date by default. Customers can choose to have Coupa map the PostingDate to Expense Date instead of TransactionDate. This is a Coupa setup that requires discussion with your Coupa Integration Architect or Implementation Manager	FinancialTransaction_5000/TransactionDate OR FinancialTransaction_5000/PostingDate
Rental Car Category Custom Fields*
Rental Car	RentalCarAgreementNumber	VehicleRentalDetailAddendum_5040/RentalAgreementNum
Rent Date	Date the customer picked up the car or, in case of a No Show or Pre-paid transaction, the scheduled pickup date.	VehicleRentalDetailAddendum_5040/CheckOutDate
Return Date	RentalCarDropoffDate	VehicleRentalDetailAddendum_5040/RentalReturnDate
Duration	Represents the length of rental, measured in number of days charged in transaction.	VehicleRentalDetailAddendum_5040/DaysRented
Rent Location	RentalCarPickupLocation	VehicleRentalDetailAddendum_5040/VehicleCheckOutCity, VehicleCheckoutStateProvince,VehicleCheckOutCountry
Return Location	Destination City where car is returned to the Rental company.	VehicleRentalDetailAddendum_5040/RentalReturnCity, RentalReturnStateProvince, RentalReturnCountry
Renter Name	Renter’s name for a Car Rental transaction.	VehicleRentalDetailAddendum_5040/RenterName
Hotel Category Custom Fields*
Lodging	HotelFolioNumber	LodgingSummaryAddendum_5030/FolioNum
Arrival Date	Date customer checked into hotel, or Scheduled Arrival Date in case of a No Show or an Advance Lodging	LodgingSummaryAddendum_5030/ArrivalDate
Departure Date	HotelDepartureDate	LodgingSummaryAddendum_5030/DepartureDate
Duration	Represents the length of stay, measured in number of nights.	LodgingSummaryAddendum_5030/TotalRoomNights
Airfare Category Custom Fields*
Airfare	Ticket Number associated with the airfare transaction.	PassengerTransportDetailGeneralTicketInformation_5020/TicketNum
Departure Date	Departure Date of the airfare transaction.	PassengerTransportDetailTripLegData_5021/DepartureTime
Route	AirLegDepartAirportCode	PassengerTransportDetailTripLegData_5021/CityOfOrigin, CityofDestination
Return Date	AirLegArrivalTime	PassengerTransportDetailTripLegData_5021/ArrivalTime
Class	AirLegServiceClass	PassengerTransportDetailTripLegData_5021/ServiceClass
Passenger Name	Customer name as indicated on the ticket purchased.	PassengerTransportDetailGeneralTicketInformation_5020/PassengerName
Domestic	DomesticInternationalInd	PassengerTransportDetailGeneralTicketInformation_5020/DomesticIndicator
External Fields*
External Source Name	Indicates the Corporate Card File Type.	Hardcoded to Mastercard corporate card file type: corporate_credit_card_cdf3
External Source Data	Indicates the Visa Filename the transaction was parsed from.	Hardcoded to MasterCard Filename transaction was parsed from
External Source Ref	Indicates a unique source number for each transaction.	FinancialTransaction_5000/MasterCardFinancialTransactionId field
External Source Ref	Indicates a unique source number for each transaction.	FinancialTransaction_5000/ProcessorTransactionID