InstaMed is able to support a transaction level report which includes all daily AMEX transactions.
InstaMed’s AMEX Daily File is generated at the transaction level. InstaMed will only output one record per transaction and can support the delivery of zero byte files.
This AMEX Daily file is a batch file in a pipe-delimited format.
The file is uploaded daily by InstaMed via SFTP.
| Field # | Field Name | Format | Required? | Min | Max | Comment |
|---|---|---|---|---|---|---|
| 1 | Record ID | IMARF10 | Y | 7 | 7 | |
| 2 | Merchant ID | AN | Y | 1 | 50 | The unique ID associated with your merchant processing account, which will be given by your Implementations Manager. |
| 3 | Store ID | AN | Y | 1 | 50 | Default value is 1. |
| 4 | Terminal ID | AN | Y | 1 | 50 | May differ by location (at no extra cost to the provider) to enhance security and reporting. |
| 5 | Deposit ACH Trace Number | AN | Y | 1 | 50 | Empty Value |
| 6 | Deposit Effective Date | DT | Y | 14 | 14 | Empty Value |
| 7 | Payment Transaction Type | AN | Y | 1 | 35 | Supported values are: “CreditCard,” “eCheck,” “DebitCard” and “Cash. |
| 8 | Payment Transaction Action | AN | Y | 1 | 35 | Supported values are: “AuthCapt,” “Credit,” and “Return” |
| 9 | Amount | DEC | Y | 1 | 12 | |
| 10 | Card Type | AN | O | 1 | 25 | This field is returned when the transaction type is CreditCard. Values include: “VISA,” “MC,” “AMEX,” “DISCOVER” and “OTHER.” |
| 11 | Transaction ID | AN | Y | 1 | 50 | This is a unique ID assigned by InstaMed, e.g., “3c4fabfad61e47e4aa10b52529476529.” |
| 12 | Authorization Number | AN | S | 1 | 50 | |
| 13 | Transaction Date | AN | Y | 8 | 8 | Date/time in CCYYMMDDHHMMSS format. |
| 14 | Transaction Status Code | AN | Y | 1 | 10 | Supported values are: “S” “CB” and “RI” representing settled, chargebacks and returns |
| 15 | Consumer LastName | AN | O | 1 | 50 | |
| 16 | Consumer FirstName | AN | O | 1 | 50 | |
| 17 | Consumer MiddleName | AN | O | 1 | 50 | |
| 18 | Consumer Account Number | AN | O | 1 | 50 | |
| 19 | Consumer Address 1 | AN | O | 1 | 150 | |
| 20 | Consumer Address 2 | AN | O | 1 | 150 | |
| 21 | Consumer City | AN | O | 1 | 50 | |
| 22 | Consumer State | AN | O | 1 | 30 | |
| 23 | Consumer ZipCode | AN | O | 1 | 15 | |
| 24 | AdditionalInfo1 | AN | O | 1 | 100 | User-defined fields captured with the payment transaction. |
| 25 | AdditionalInfo2 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 26 | AdditionalInfo3 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 27 | AdditionalInfo4 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 28 | AdditionalInfo5 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 29 | AdditionalInfo6 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 30 | User | AN | O | 1 | 100 | May also include punctuation (e.g., “@” or “.”). User performed original sale |
| 31 | Transaction Code | AN | O | 1 | 50 | Note: Transaction codes are passed in the EOD Posting file rather than descriptions. Consult your Implementations Manager to configure Transaction Codes on your account. |
| 32 | Market Segment | AN | O | 1 | 15 | See Market Segment Codes. |
| 33 | Is Swiped | AN | S | 1 | 1 | Supported values are: “Y” or “N” indicating whether the card was swiped or not. |
| 34 | ConsumerServiceBeginDate | DT | O | 14 | 14 | |
| 35 | ConsumerServiceEndDate | DT | O | 14 | 14 | |
| 36 | Consumer Medical Record Number | AN | O | 1 | 50 | |
| 37 | Consumer DOB | DT | O | 14 | 14 | |
| 38 | Consumer Country | AN | O | 1 | 50 | |
| 39 | Consumer Phone Number | AN | O | 1 | 13 | |
| 40 | Account/Card Holder Address 1 | AN | O | 1 | 150 | |
| 41 | Account/Card Holder Address 2 | AN | O | 1 | 150 | |
| 42 | Account/Card Holder City | AN | O | 1 | 50 | |
| 43 | Account/Card Holder State | AN | O | 2 | 2 | |
| 44 | Account/Card Holder ZipCode | AN | O | 5 | 15 | |
| 45 | Account/Card Holder Country | AN | O | 1 | 50 | |
| 46 | Account/Card Holder Phone Number | AN | O | 1 | 13 | |
| 47 | Account/Card Holder Email Address | AN | O | 1 | 50 | |
| 48 | Estimated Amount | DEC | O | |||
| 49 | Reason Code | AN | O | 1 | 50 | |
| 50 | Check Number | AN | O | 1 | 50 | |
| 51 | Check Account Type | AN | O | 1 | 50 | Possible values are: checking, saving and business. |
| 52 | Taken At Merchant ID | AN | O | 1 | 50 | |
| 53 | Taken At Store ID | AN | O | 1 | 50 | |
| 54 | Taken At Terminal ID | AN | O | 1 | 50 | |
| 55 | AdditionalCode 1 | AN | O | 1 | 100 | |
| 56 | AdditionalCode 2 | AN | O | 1 | 100 | |
| 57 | AdditionalCode 3 | AN | O | 1 | 100 | |
| 58 | AdditionalCode 4 | AN | O | 1 | 100 | |
| 59 | AdditionalCode 5 | AN | O | 1 | 100 | |
| 60 | AdditionalCode 6 | AN | O | 1 | 100 | |
| 61 | Processing MID | AN | C | 1 | 50 | |
| 62 | Card Brand Txn ID | AN | O | 1 | 50 | If card brand provides proprietary transaction ID, will be populated here; Expected to be available for Sales |
| 63 | Card First 6 | N | O | 6 | 6 | If payment method is Card, first 6 digits will be populated here |
| 64 | Card Last 4 | AN | Y | 4 | 4 | If payment method is Card, last four digits of the credit card |
| 65 | AmEx SE | AN | O | 1 | 50 | If AmEx SE # is available, will be populated here |
| 66 | [Reserved for future use] | AN | O | 1 | 100 | |
| 67 | [Reserved for future use] | AN | O | 1 | 100 |