Amex Record 1 Common Mapping

The Amex KR-1025 Record 1 Common file layout identifies detail information for each expense.  Each detail row's layout is the same with the following exceptions:

(*) - Redefine Area - The group of characters starting with 614 and going through 819 can be used for different things depending on the MIS industry code. For example, the fields may be used for one thing for Car Rental expenses and another thing for Lodging expenses. See details regarding this section in the table below.

Field Picture Location Length Notes
Record Type X(01) 1 1 1 = Detail Billing Data
Requesting Control Account Number X(19) 2-20 19 The account number requesting the report.
Requesting Control Account Name X(35) 21-55 35 The name associated with the account requesting the report.
Billing Basic Control Acct Number X(19) 56-74 19 Billed BCA for the billed account number.
Billing Basic Control Account Name X(35) 75-109 35 The name associated with the billed BCA for billed account number.
FIPS Code X(04) 110-113 4 Internal US Federal Agency grouping,
Billing Account Number X(19) 114-132 19 Billed Account Number - Can be CM or a Diverted Account.
Cardmember Embossed Name X(26) 133-158 26 Name of the card member incurring the charge.
Employee ID X(10) 159-168 10 A textual field assigned by the user.
Cost Center X(10) 169-178 10 A textual field assigned by the user.
Universal Number X(25) 179-203 25 A textual field assigned by the user.
Social Security Number X(10) 204-213 10 A textual field assigned by the user.
Language Preference Code X(01) 214 1 Space - US

0 - English

1 - French

2 - Spanish

3 - Portuguese

Corporate Identifier Number X(19) 215-233 19 A number used to represent a corporate client.
Supplier Reference Number X(11) 234-244 11 Provided by the service establishment at the point of sale.
Sign Indicator (+ or -) X(01) 245 1 Indicates where amounts are positive or negative. Valid values are + and -.
Billed Amount Decimal (15,0) 246-260 15 The amount of the billed charge.
Billed Tax Amount Decimal (15,0) 261-275 15 The amount of the billed tax.
Billed Currency Code X(03) 276-278 3 The ISO code for the billed currency.
Billed Decimal Place Number X(01) 279 1 The number of decimal places needed to display currency.
Local Charge Amount Decimal (15,0) 280-294 15 The amount of the charge in local currency
Local Tax Amount Decimal (15,0) 295-309 15 The amount of the tax in local currency.
Local Currency Code X(03) 310-312 3 The ISO code for the local currency.
Local Decimal Place Number X(01) 313 1 The number of decimal places needed to display currency.
Currency Exchange Rate Decimal (15,8) 314-328 15 The exchange rate from the local currency to US Dollars.
Transaction Type Code X(02) 329-330 2 The type of charge or credit for a transaction.
Financial Category Code X(01) 331 1 Indicates financial category of transaction

1 = New Charge

2 = Other Credits

3 = Debit Remittance

4 = Payment

5 = Other Credit

Account Type X(05) 332-336 5 The type of account for this card member (CM, BTA, BTBA, ACB, FCB, CRCB)
Originating Basic Control Account Number X(19) 337-355 19 This will be the originating BCA for the originating CM account number if this is a diverted transaction.
Originating CM Account Number X(19) 356-374 19 This will be the originating CM account number for the actual charge if this is a diverted transaction.
Transaction Number X(15) 375-389 15 Sequence Number (375-381)

Julian Date (YYDDD) (382-386)

Batch Number (387-389)

Charge Date (CCYYMMDD format) X(08) 390-397 8 Actual date on which the transaction was incurred.
Business Process Date (CCYYMMDD format) X(08) 398-405 8 The date on which the transaction was processed by American express.
Bill Date (CCYYMMDD format) X(08) 406-413 8 Billing Date or Cycle Cut Date.
CM Reference Number X(17) 414-430 17 The field that the CM at the point of sale.
MIS Industry Code X(02) 431-432 2 This is the MIS industry code for the transaction:

01 = Airline

02 = Rail

03 = Lodging

04 = Car Rental

05 = Restaurant

06 = Retail

07 = Car Misc.

08 = All Other

CA, DC, FE, IN, NG, OA, OI, PA, TC, NF, SP, DS, CT = Misc

ROC ID X(13) 433-445 13 Uniquely identifies a record of charge.
Charge Description Line 1 X(42) 446-487 42 First line of description for the record of charge.
Charge Description Line 2 X(42) 488-529 42 Second line of description for the record of charge.
Charge Description Line 3 X(42) 530-571 42 Third line of description for the record of charge.
Charge Description Line 4 X(42) 572-613 42 Fourth line of description for the record of charge.
Redefine Area (*) X(206) 614-819 206 This area is redefined based on the MIS industry code. See Details on other sheets.
SE Number X(10) 820-829 10 The Establishment Services account number for the SE where the charge was incurred.
SE Chain Code X(10) 830-839 10 The parent company code for the Service Establishment where the charge was incurred.
SE Name 1 X(40) 840-879 40 The first SE name field.
SE Name 2 X(40) 880-919 40 Second SE name field.
SE Street 1 X(40) 920-959 40 First SE address line.
SE Street 2 X(40) 960-999 40 Second SE address line.
SE City X(40) 1000-1039 40 SE city name.
SE State X(06) 1040-1045 6 SE state code.
SE Zip Code X(15) 1046-1060 15 SE ZIP code.
SE Country Name X(35) 1061-1095 35 SE country name.
SE Country Code X(03) 1096-1098 3 The ISO country code.
SE Corporate Status Code X(01) 1099 1 Identifies the corporate status.
SE Purchasing Card Code X(02) 1100-1101 2 Defines the different Purchasing Card/Non-Purchasing Card SEs.
SE Purchasing Card Owner Type Code X(02) 1102-1103 2 Defines the minority status of the SE's owner.
SIC Code X(04) 1104-1107 4 The Standard Industry Code.
SE Sales Tax Collected Flag X(01) 1108 1 Indicates whether sales tax has been collected.
Ship To Postal Code X(15) 1109-1123 15 Postal code shipped to.
Ship To City X(30) 1124-1153 30 City name shipped to.
Ship To Country * X(30) 1154-1183 30 Country name shipped to.
Ship To State X(06) 1184-1189 6 State name shipped to.
DDA Number X(22) 1190-1121 22 Funds Access checking account number.
Bank Routing Number X(04) 1212-1215 4 Routing number for the bank.
US CM ABA Number X(04) 1216-1219 4 Number that identifies the domestic bank used.
Spool Number * X(22) 1220-1241 22 Internal number assigned by AMEX that identifies the order in which the transaction was spooled.
Funds Access Log Date X(08) 1242-1249 8 Date on which the transaction was logged by AMEX.
Funds Access Log Time X(08) 1250-1257 8 Time the transaction was logged by AMEX.
Machine Number X(08) 1258-1265 8 Unique number that identifies the ATM from which a transaction originated.
Terminal Location X(40) 1266-1305 40 Location of the ATM.
Network Route and Transit Number X(10) 1306-1315 10  
Terminal Route and Transit Number X(10) 1316-1325 10  
Cash Batch Number X(06) 1326-1331 6 Internal number assigned to identify type of transaction for cash transactions.
MIS Sub-Industry Code X(03) 1332-1334 3 11,51 - General

12,52 - Airline

13,53 - Car Rental

14,54 - Hotel

15,55 - Retail

16,56 - Restaurant

17 - Mail Order

18 - Insurance

19, 59 - Oil

20 - Telephone

21 - Event

62 - Rail

VAT Tax Percent Decimal (5,3) 1335-1339 5 Percentage of VAT tax collected.
Capture Center Code X(1) 1340 1 Need Codes.
Mercator Key X(21) 1341-1361 21 For Internal AMEX CPCIS use only.
Transaction Fee Indicator X(3) 1362-1364 3 001= Paper Tix

002=Refund

003=Exchange

004=E-Tix

005=Interactive Tix

 006=Reconciliation Fee

Filler X(582) 1365-1946 582 Spaces
Note: The Redefine Area of the AMEX KF1025 file is used to compile specific information based on the type of expense. The purpose of the fields will vary depending on the expense. The Redefine Area begins at location 614 and ends at location 819. The layout of each field is detailed below.