Skip to main content

 

 

Coupa Success Portal

Corporate Card Mapping: MasterCard

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. This is different from the original transaction amount, which could have been in a different currency, 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, 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

  • Was this article helpful?