EOD Posting File Lockbox C

Lockbox Version C of the EOD Posting File is known to work with several existing Patient Accounts Receivable systems. The header record of this format includes an identifier for EOD Posting File Groups. Contact your Implementations Manager for further information.

File Name Standard: <BusinessDate> + <Account/Group/Outlet> + “.pmt”

• File can be generated by Account, End of Day File Group or Outlet.

File Format: Fixed Position, Fixed Width

Field	Location	Type	Description	Comments
Header
Account Identifier	3-8	AN	Right Justified/Space Filled	InstaMed EMC ID.
Group Identifier	9-18	AN	Right Justified/Zero Filled (space filled if empty)	EOD Posting File Group Name.
Total Number of Payments	19-24	NUM	Right Justified/Zero Filled	Refunds included in count.
Total Payment Amounts	25-34	NUM	Right Justified/Zero Filled No Decimal Point	Total Amount = Total Sale Amount - Total Refund Amount.
Patient Payment Transaction Code	35-39	AN		"P0000" or P.
Total Number of Adjustments	40-45	NUM		All Zeros.
Total Adjustment Amount	46-55	NUM		All Zeros.
Patient Adjustment transaction Code	56-60	AN		All Spaces.
Filler	61-250	AN		All Spaces.
Transaction Record
Record Type	1-2	AN		Constant Value = "01".
Patient Account Number	3-12	AN	Right Justified/Zero Filled	If PatientID is greater than 10 characters, map the first 10 characters.
Facility Indicator	13	AN	Upper Case/Blank Filled	Prefix for Patient Account Number.
Patient last Name	14-28	AN	Right Justified/Space Filled
Patient First Name	29-40	AN	Right Justified/Space Filled
Patient Middle Initial	41	AN	Right Justified/Space Filled
Transaction Type	42	AN		"P" = Payment, "A" = Adjustment.
Date Paid	43-48	DT	YYMMDD	Business date of transaction
Payment Amount Indicator	49	AN		"0" for payments, "-" for adjustments.
Payment Amount	50-59	NUM	Right Justified/Zero Filled No Decimal Point	2 places assumed.
Payment Type	60	AN		"C" = Credit Card , "A" = all other payment methods (e.g., check or cash).
Credit Card or Bank Account Owner Name	61-100	AN	Right Justified/Space Filled	Cardholder Name if Payment Type = "C," otherwise Bank Account Holder Name if available.
Credit Card Type	101-125	AN	Right Justified/Space Filled	"AMEX," "VISA," "MASTERCARD," "DISCOVER" or "OTHER" when applicable.
Account Number	126-129	NUM	Right Justified/Space Filled	Last 4 digits of card if Payment Type = "C," otherwise last four digits of bank account, if applicable.
Confirmation Code	130-159	AN	Right Justified/Zero Filled	Authorization Number if Payment Type = "C".
Transaction ID	160-191	AN		32-character InstaMed Platform ID.
Filler	192-250	AN	Space Filled	Blank.