EOD Posting File 1.2.2

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 NameFormatRequired?MinMaxComment
Header
1Record code"H"Y11Code Indicator for header line
2Capture Date HeaderYYYYMMDDY18Date file was created
3Lockbox NumberNumericY14Sender's lockbox number
Detail
1Record code"D"Y11
2Record ID"IMDPA12"Y77
3Merchant IDANY150The unique ID associated with your merchant processing account, which will be given by your Implementations Manager.
4Store IDANY150Default value is 1.
5Terminal IDANY150May differ by location (at no extra cost to the provider) to enhance security and reporting
6Payment Transaction TypeANY135Supported values are: "AuthCapt", "Credit", and "Return"
7Payment Transaction ActionANY135Supported values are: "AuthCapt", "Credit", and "Return"
8AmountDECOAlways positive decimal value. Payment Transaction Action = "Credit" should cause this field to be interpreted as a refund.
9Card TypeANO125This field is returned when the transaction type is CreditCard. Values include: "VISA," "MC," "AMEX," "DISCOVER" and "OTHER."
10Transaction IDANY150This is a unique ID assigned by InstaMed, e.g., "3c4fabfad61e47e4aa10b525 29476529."
11Authorization NumberANS150
12Transaction DateDTY1414Date/time in CCYYMMDDHHMMSS format.
13Transaction Status CodeANY110Supported values are: A, C, CB, D, RI, S, SE, V

See Transaction Status Codes.
14Patient LastNameANO150
15Patient FirstNameANO150
16Patient MiddleNameANO150
17Patient Account NumberANO150
18Patient Address 1ANO1150
19Patient Address 2ANO1150
20Patient CityANO150
21Patient StateANO130
22Patient ZipCodeANO115
23AdditionalInfo1ANO1100User-defined fields captured with the payment transaction.
24AdditionalInfo2ANO1100See AdditionalInfo1 comments.
25AdditionalInfo3ANO1100See AdditionalInfo1 comments.
26AdditionalInfo4ANO1100See AdditionalInfo1 comments.
27AdditionalInfo5ANO1100See AdditionalInfo1 comments.
28AdditionalInfo6ANO1100See AdditionalInfo1 comments.
29UserANO1100May also include punctuation (e.g., "@" or ".").
30Transaction CodeANO150Note: Transaction codes are passed in the EOD Posting file rather than descriptions. Consult your Implementations Manager to configure Transaction Codes on your account.
31Market SegmentANO115See Market Segment Codes.
32Is SwipedANS11Supported values are: "Y" or "N" indicating whether the card was swiped or not.
33PatientServiceBeginDateDTO1414
34PatientServiceEndDateDTO1414
35Patient Medical Record NumberANO150
36Patient DOBDTO1414
37Patient CountryANO150
38Patient Phone NumberANO113
39Account/Card Holder Address 1ANO1150
40Account/Card Holder Address 2ANO1150
41Account/Card Holder CityANO150
42Account/Card Holder StateANO22
43Account/Card Holder ZipCodeANO515
44Account/Card Holder CountryANO150
45Account/Card Holder Phone NumberANO113
46Account/Card Holder Email AddressANO150
47Estimated AmountDECO
48Reason CodeANO150
49Check NumberANO150
50Check AccountTypeANO150Possible values are: checking, saving and business.
51Taken At Merchant IDANO150
52Taken At Store IDANO150
53Taken At Terminal IDANO150
54AdditionalCode 1ANO1100
55AdditionalCode 2ANO1100
56AdditionalCode 3ANO1100
57AdditionalCode 4ANO1100
58AdditionalCode 5ANO1100
59AdditionalCode 6ANO1100
60Last Four DigitsNumO416When a 16 character value is returned all but the last four characters will be "*".
61Account NumberNumOLast four (account)
62Original Payment Transaction IDANO150Original payment tx ID
63Not UsedANO00Reserved for future use
64Outlet DescriptionANY150InstaMed configured outlet description
65Effective AmountANY120Net amount of debit or credit (+/-)
66Payment SourceNumericY11Supports tender and card type., including Cash, Check, Mastercard, Visa, Discover, American Express, Other Credit Card, Other Payment Source
Trailer
1Record Code"T"Y11Code indicator for trailer line
2File Total PaidNumericY115Sum of paid amount in file
3File Total CountNumericY110Count of total number of payments in file