Corporate Card Mapping: American Express
|
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/TransactionDate |
|
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 |