The 1.2 version of EOD Posting File includes additional fields which are not available in the 1.1 or 1.0 versions.
Record ID: IMDPA12
File Format: Piped Delimited
| Field # | Field Name | Format | Required? | Min | Max | Comment |
|---|---|---|---|---|---|---|
| 1 | Record ID | "IMDPA12" | 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." See Market Segment Codes. |
| 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 | Reserved for future use. |
| 54 | AdditionalCode 2 | AN | O | 1 | 100 | Reserved for future use. |
| 55 | AdditionalCode 3 | AN | O | 1 | 100 | Reserved for future use. |
| 56 | AdditionalCode 4 | AN | O | 1 | 100 | Reserved for future use. |
| 57 | AdditionalCode 5 | AN | O | 1 | 100 | Reserved for future use. |
| 58 | AdditionalCode 6 | AN | O | 1 | 100 | Reserved for future use. |
| 59 | Credit Card Number | AN | O | 0 | 16 | All digits are masked with “*” except the last four. |
| 60 | Check Account Number | AN | O | 0 | 30 | All digits are masked with “*” except the last four. |
| 61 | Original Payment Transaction | AN | O | 32 | 32 | |
| 62 | Field61 | AN | O | 1 | 100 | Reserved for future use. |