Skip to main content

 

 

Coupa Success Portal

Corporate Card Mapping: American Express

The table below provides mapping data for American Express 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

Amex

Expense Line Fields

Description

Description

GL1025/TransactionDetail/ChargeDescriptionLine1

Total

BilledAmount

GL1025/TransactionDetail/BilledAmount

Currency

BilledCurrencyCode

GL1025/TransactionDetail/BilledCurrencyISO_Code

Expense Category

MerchantCategory

GL1025/TransactionDetail/ISO_MerchantCategoryCode

Merchant

MerchantName

GL1025/TransactionDetail/SE_OU_BusinessName

Date

TransactionDate

GL1025/TransactionDetail/ChargeDate

Date

PostingDate

GL1025/TransactionDetail/BillDate

Rental Car Category Custom Fields*

Rental Car

RentalCarAgreementNumber

GL1_CarRentalRedefine/CarRentalAgreementNumber

Rent Date

RentalCarPickupDate

GL1_CarRentalRedefine/CarRentalDate

Return Date

RentalCarDropoffDate

GL1_CarRentalRedefine/CarReturnDate

Duration

RentalCarDuration

GL1_CarRentalRedefine/CarRentalDays

Rent Location

RentalCarPickupLocation

GL1_CarRentalRedefine/CarRentalCity, CarRentalStateCode, CarRentalState_LAC, CarRentalRegion_ID, CarRentalCountry_ID_ISO

Return Location

RentalCarDropoffLocation

GL1_CarRentalRedefine/CarReturnCity, CarReturnStateCode, CarReturnState_LAC, CarReturnRegion_ID, CarReturnCountry_ID_ISO

Renter Name

RentalCarDriverName

GL1_CarRentalRedefine/CarRenterName

Hotel Category Custom Fields*

Lodging?

HotelReservationNumber

 

Lodging?

HotelFolioNumber

GL1_HotelRedefine/HotelFolioNumber

Arrival Date

HotelArrivalDate

GL1_HotelRedefine/HotelArrivalDate

Departure Date

HotelDepartureDate

GL1_HotelRedefine/HotelDepartDate

Duration

HotelNights

GL1_HotelRedefine/HotelStayDuration

Rate

HotelDailyRoomRate

GL1_HotelRedefine/HotelRoomRate

Guest Name

HotelGuestName

GL1_HotelRedefine/HotelGuestName

Location

HotelLocation

GL1_HotelRedefine/HotelCity, HotelStateCode, HotelState_LAC, HotelRegion_ID, HotelCountry_ID_ISO

Airfare Category Custom Fields*

Airfare

AirTicketNumber

GL1_AirlineRedefine/AirTicketNumber

Departure Date

AirDepartureDate

GL1_AirlineRedefine/AirDepartureDate

Route

AirSegments

GL1_AirlineRedefine/AirRouting

Carrier

AirLegAirlineCode

GL1_AirlineRedefine/AirCarrierCode

Class

PrimaryAirServiceClass

GL1_AirlineRedefine/PredominantClassCategoryCode

 

AirFareBasisCode

GL1_AirlineRedefine/PredominantClassCategoryCode

Passenger Name

PassengerName

GL1_AirlineRedefine/AirPassengerName

Domestic

DomesticInternationalInd

GL1_AirlineRedefine/DomesticOrInternationalCode

External Fields

External Source Name

External Source Name

Hardcoded to Amex corporate card file type: corporate_credit_card_amex

External Source Data

External Source Data

Hardcoded to Amex Filename transaction was parsed from

External Source Ref

External Source Ref

GL1025/TransactionDetail/RefNum

  • Was this article helpful?