American Express (Amex) Record Mappings

The file that you receive from Amex has a distinct layout that identifies header and detail transaction information. There are 13 Amex KR 1025 record mapping layouts:

  • Record 0 Mapping - This mapping details header information for each file.
  • Record 1 Common Mapping - This layout identifies detail information for each expense.  
  • Record 1 Car Rental Mapping - This layout identifies detail information for fields 614 through 819 as they relate to car rental expenses.
  • Record 1 Hotel Mapping - This layout identifies detail information for fields 614 through 819 as they relate to hotel expenses.
  • Record 1 Telephone Mapping - This layout identifies detail information for fields 614 through 819 as they relate to telephone expenses.
  • Record 1 Airline Mapping - This layout identifies detail information for fields 614 through 819 as they relate to airline expenses.
  • Record 1 Retail Mapping - This layout identifies detail information for fields 614 through 819 as they relate to retail expenses.
  • Record 1 Restaurant Mapping - This layout identifies detail information for fields 614 through 819 as they relate to restaurant expenses.
  • Record 1 Rail Mapping - This layout identifies detail information for fields 614 through 819 as they relate to rail expenses.
  • Record 1 Mail Order Mapping - This layout identifies detail information for fields 614 through 819 as they relate to mail order expenses.
  • Record 1 Insurance Mapping - This layout identifies detail information for fields 614 through 819 as they relate to insurance expenses.
  • Record 1 Oil Mapping - This layout identifies detail information for fields 614 through 819 as they relate to oil expenses.
  • Record 1 Event Mapping - This layout identifies detail information for fields 614 through 819 as they relate to event expenses.