The 1.4 version of EOD Posting File includes all the fields in EOD Posting File Version 1.3 plus additional fields for the response code, response message, and fields reserved for future use.
Record ID: IMDPA14
File Format: Pipe-Delimited
| Field # | Field Name | Format | Required? | Min | Max | Comment |
|---|---|---|---|---|---|---|
| 1 | Record ID | "IMDPA14" | 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 | Payment Transaction Type | AN | Y | 1 | 35 | Supported values are: "CreditCard", "eCheck", "DebitCard", and "Cash." |
| 6 | Payment Transaction Action | AN | Y | 1 | 35 | Supported values are: "AuthCapt", "Credit", and "Return" |
| 7 | Amount | DEC | O | Always positive decimal value. Payment Transaction Action = "Credit" should cause this field to be interpreted as a refund. | ||
| 8 | Card Type | AN | O | 1 | 25 | This field is returned when the transaction type is CreditCard. Values include: "VISA," "MC," "AMEX," "DISCOVER" and "OTHER." |
| 9 | Transaction ID | AN | Y | 1 | 50 | This is a unique ID assigned by InstaMed, e.g., "3c4fabfad61e47e4aa10b52529476529." |
| 10 | Authorization Number | AN | S | 1 | 50 | |
| 11 | Transaction Date | DT | Y | 14 | 14 | Date/time in CCYYMMDDHHMMSS format. |
| 12 | Transaction Status Code | AN | Y | 1 | 10 | Supported values are: A, C, CB, D, RI, S, SE, V See Transaction Status Codes. |
| 13 | Patient LastName | AN | O | 1 | 50 | |
| 14 | Patient FirstName | AN | O | 1 | 50 | |
| 15 | Patient MiddleName | AN | O | 1 | 50 | |
| 16 | Patient Account Number | AN | O | 1 | 50 | |
| 17 | Patient Address 1 | AN | O | 1 | 150 | |
| 18 | Patient Address 2 | AN | O | 1 | 150 | |
| 19 | Patient City | AN | O | 1 | 50 | |
| 20 | Patient State | AN | O | 1 | 30 | |
| 21 | Patient ZipCode | AN | O | 1 | 15 | |
| 22 | AdditionalInfo1 | AN | O | 1 | 100 | User-defined fields captured with the payment transaction. |
| 23 | AdditionalInfo2 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 24 | AdditionalInfo3 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 25 | AdditionalInfo4 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 26 | AdditionalInfo5 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 27 | AdditionalInfo6 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 28 | User | AN | O | 1 | 100 | May also include punctuation (e.g., "@" or "."). |
| 29 | 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. |
| 30 | Market Segment | AN | O | 1 | 15 | Supported values are: "Check", "POP," "ARC", "WEBTEL", "Credit Card", "MOTO", "RETAIL", and "ECOM." |
| 31 | Is Swiped | AN | S | 1 | 1 | Supported values are: "Y" or "N" indicating whether the card was swiped or not. |
| 32 | PatientServiceBeginDate | DT | O | 14 | 14 | |
| 33 | PatientServiceEndDate | DT | O | 14 | 14 | |
| 34 | Patient Medical Record Number | AN | O | 1 | 80 | |
| 35 | Patient DOB | DT | O | 14 | 14 | |
| 36 | Patient Country | AN | O | 1 | 50 | |
| 37 | Patient Phone Number | AN | O | 1 | 13 | |
| 38 | Account/Card Holder Address 1 | AN | O | 1 | 150 | |
| 39 | Account/Card Holder Address 2 | AN | O | 1 | 150 | |
| 40 | Account/Card Holder City | AN | O | 1 | 50 | |
| 41 | Account/Card Holder State | AN | O | 2 | 2 | |
| 42 | Account/Card Holder ZipCode | AN | O | 5 | 15 | |
| 43 | Account/Card Holder Country | AN | O | 1 | 50 | |
| 44 | Account/Card Holder Phone Number | AN | O | 1 | 13 | |
| 45 | Account/Card Holder Email Address | AN | O | 1 | 50 | |
| 46 | Estimated Amount | DEC | O | |||
| 47 | Reason Code | AN | O | 1 | 50 | |
| 48 | Check Number | AN | O | 1 | 50 | |
| 49 | Check AccountType | AN | O | 1 | 50 | Possible values are: checking, saving and business. |
| 50 | Taken At Merchant ID | AN | O | 1 | 50 | |
| 51 | Taken At Store ID | AN | O | 1 | 50 | |
| 52 | Taken At Terminal ID | AN | O | 1 | 50 | |
| 53 | AdditionalCode 1 | AN | O | 1 | 100 | |
| 54 | AdditionalCode 2 | AN | O | 1 | 100 | |
| 55 | AdditionalCode 3 | AN | O | 1 | 100 | |
| 56 | AdditionalCode 4 | AN | O | 1 | 100 | |
| 57 | AdditionalCode 5 | AN | O | 1 | 100 | |
| 58 | AdditionalCode 6 | AN | O | 1 | 100 | |
| 59 | Last Four Digits | NUM | O | 4 | 16 | When a 16 character value is returned all but the last four characters will be "*". |
| 60 | Account Number | NUM | O | |||
| 61 | Original Payment Transaction ID | AN | O | 1 | 50 | |
| 62 | Not Used | AN | O | 0 | 0 | |
| 63 | Outlet Description | AN | O | |||
| 64 | Effective Amount | NUM | R | 1 | 14 | Negative values in this field indicate a refund. Decimals do not show in formatting, but are implied as the final two digits, ex: $100.00 shows as 10000 , $79.99 as 7999. |
| 65 | Payment Source | AN | ||||
| 66 | Guarantor ID | AN | O | 1 | 80 | |
| 67 | Guarantor First Name | AN | O | 1 | 35 | |
| 68 | Guarantor Last name | AN | O | 1 | 60 | |
| 69 | Response Code | AN | O | 1 | 10 | |
| 70 | Response Message | AN | O | 1 | 100 | |
| 71 | Reserved for Future Use | AN | O | |||
| 72 | Reserved for Future Use | AN | O | |||
| 73 | Reserved for Future Use | AN | O | |||
| 74 | Reserved for Future Use | AN | O | |||
| 75 | Reserved for Future Use | AN | O | |||
| 76 | Reserved for Future Use | AN | O | |||
| 77 | Reserved for Future Use | AN | O | |||
| 78 | Reserved for Future Use | AN | O | |||
| 79 | Reserved for Future Use | AN | O | |||
| 80 | Reserved for Future Use | AN | O |