EOD Posting File 1.3 - InstaMed Developer Portal

The 1.3 version of EOD Posting File includes all the fields in EOD Posting File Version 1.2 plus additional fields for the guarantor: Guarantor ID, Guarantor First Name, Guarantor last name.

Record ID: IMDPA13

File Format: Pipe-Delimited

#	Field Name	Format	Required?	Min	Max	Comment
1	Record ID	"IMDPA13"	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	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	50
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	DEC				A negative value here will indicate a refund.
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

Build a better healthcare payments experience with InstaMed