The 1.2.2 version of EOD Posting File includes additional fields which are not available in the previous versions.
Record ID: IMDPA12
File Format: Pipe-Delimited
EOD Posting File v.1.2.2 Data Fields
| # | Field Name | Format | Required? | Min | Max | Comment |
|---|---|---|---|---|---|---|
| Header | ||||||
| 1 | Record code | "H" | Y | 1 | 1 | Code Indicator for header line |
| 2 | Capture Date Header | YYYYMMDD | Y | 1 | 8 | Date file was created |
| 3 | Lockbox Number | Numeric | Y | 1 | 4 | Sender's lockbox number |
| Detail | ||||||
| 1 | Record code | "D" | Y | 1 | 1 | |
| 2 | Record ID | "IMDPA12" | Y | 7 | 7 | |
| 3 | Merchant ID | AN | Y | 1 | 50 | The unique ID associated with your merchant processing account, which will be given by your Implementations Manager. |
| 4 | Store ID | AN | Y | 1 | 50 | Default value is 1. |
| 5 | Terminal ID | AN | Y | 1 | 50 | May differ by location (at no extra cost to the provider) to enhance security and reporting |
| 6 | Payment Transaction Type | AN | Y | 1 | 35 | Supported values are: "AuthCapt", "Credit", and "Return" |
| 7 | Payment Transaction Action | AN | Y | 1 | 35 | Supported values are: "AuthCapt", "Credit", and "Return" |
| 8 | Amount | DEC | O | Always positive decimal value. Payment Transaction Action = "Credit" should cause this field to be interpreted as a refund. | ||
| 9 | Card Type | AN | O | 1 | 25 | This field is returned when the transaction type is CreditCard. Values include: "VISA," "MC," "AMEX," "DISCOVER" and "OTHER." |
| 10 | Transaction ID | AN | Y | 1 | 50 | This is a unique ID assigned by InstaMed, e.g., "3c4fabfad61e47e4aa10b525 29476529." |
| 11 | Authorization Number | AN | S | 1 | 50 | |
| 12 | Transaction Date | DT | Y | 14 | 14 | Date/time in CCYYMMDDHHMMSS format. |
| 13 | Transaction Status Code | AN | Y | 1 | 10 | Supported values are: A, C, CB, D, RI, S, SE, V See Transaction Status Codes. |
| 14 | Patient LastName | AN | O | 1 | 50 | |
| 15 | Patient FirstName | AN | O | 1 | 50 | |
| 16 | Patient MiddleName | AN | O | 1 | 50 | |
| 17 | Patient Account Number | AN | O | 1 | 50 | |
| 18 | Patient Address 1 | AN | O | 1 | 150 | |
| 19 | Patient Address 2 | AN | O | 1 | 150 | |
| 20 | Patient City | AN | O | 1 | 50 | |
| 21 | Patient State | AN | O | 1 | 30 | |
| 22 | Patient ZipCode | AN | O | 1 | 15 | |
| 23 | AdditionalInfo1 | AN | O | 1 | 100 | User-defined fields captured with the payment transaction. |
| 24 | AdditionalInfo2 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 25 | AdditionalInfo3 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 26 | AdditionalInfo4 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 27 | AdditionalInfo5 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 28 | AdditionalInfo6 | AN | O | 1 | 100 | See AdditionalInfo1 comments. |
| 29 | User | AN | O | 1 | 100 | May also include punctuation (e.g., "@" or "."). |
| 30 | 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. |
| 31 | Market Segment | AN | O | 1 | 15 | See Market Segment Codes. |
| 32 | Is Swiped | AN | S | 1 | 1 | Supported values are: "Y" or "N" indicating whether the card was swiped or not. |
| 33 | PatientServiceBeginDate | DT | O | 14 | 14 | |
| 34 | PatientServiceEndDate | DT | O | 14 | 14 | |
| 35 | Patient Medical Record Number | AN | O | 1 | 50 | |
| 36 | Patient DOB | DT | O | 14 | 14 | |
| 37 | Patient Country | AN | O | 1 | 50 | |
| 38 | Patient Phone Number | AN | O | 1 | 13 | |
| 39 | Account/Card Holder Address 1 | AN | O | 1 | 150 | |
| 40 | Account/Card Holder Address 2 | AN | O | 1 | 150 | |
| 41 | Account/Card Holder City | AN | O | 1 | 50 | |
| 42 | Account/Card Holder State | AN | O | 2 | 2 | |
| 43 | Account/Card Holder ZipCode | AN | O | 5 | 15 | |
| 44 | Account/Card Holder Country | AN | O | 1 | 50 | |
| 45 | Account/Card Holder Phone Number | AN | O | 1 | 13 | |
| 46 | Account/Card Holder Email Address | AN | O | 1 | 50 | |
| 47 | Estimated Amount | DEC | O | |||
| 48 | Reason Code | AN | O | 1 | 50 | |
| 49 | Check Number | AN | O | 1 | 50 | |
| 50 | Check AccountType | AN | O | 1 | 50 | Possible values are: checking, saving and business. |
| 51 | Taken At Merchant ID | AN | O | 1 | 50 | |
| 52 | Taken At Store ID | AN | O | 1 | 50 | |
| 53 | Taken At Terminal ID | AN | O | 1 | 50 | |
| 54 | AdditionalCode 1 | AN | O | 1 | 100 | |
| 55 | AdditionalCode 2 | AN | O | 1 | 100 | |
| 56 | AdditionalCode 3 | AN | O | 1 | 100 | |
| 57 | AdditionalCode 4 | AN | O | 1 | 100 | |
| 58 | AdditionalCode 5 | AN | O | 1 | 100 | |
| 59 | AdditionalCode 6 | AN | O | 1 | 100 | |
| 60 | Last Four Digits | Num | O | 4 | 16 | When a 16 character value is returned all but the last four characters will be "*". |
| 61 | Account Number | Num | O | Last four (account) | ||
| 62 | Original Payment Transaction ID | AN | O | 1 | 50 | Original payment tx ID |
| 63 | Not Used | AN | O | 0 | 0 | Reserved for future use |
| 64 | Outlet Description | AN | Y | 1 | 50 | InstaMed configured outlet description |
| 65 | Effective Amount | AN | Y | 1 | 20 | Net amount of debit or credit (+/-) |
| 66 | Payment Source | Numeric | Y | 1 | 1 | Supports tender and card type., including Cash, Check, Mastercard, Visa, Discover, American Express, Other Credit Card, Other Payment Source |
| Trailer | ||||||
| 1 | Record Code | "T" | Y | 1 | 1 | Code indicator for trailer line |
| 2 | File Total Paid | Numeric | Y | 1 | 15 | Sum of paid amount in file |
| 3 | File Total Count | Numeric | Y | 1 | 10 | Count of total number of payments in file |