EOD Posting File Lockbox I v1

Lockbox Version I v1 of the EOD Posting File is known to work with several existing Patient Accounts Receivable systems.  Contact your Implementations Manager for further information.

File Name Standard: Report Configuration ID | Report File Configuration ID | Account ID + _ + <ConfigurableValue> + “_” + CCYYMMDD + “.txt”

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

File Format: Fixed Position, Fixed Width

No Header Record

 

Field	Location	Type	Description	Comments
Detail Record
Account Number	1/12/2016	AN	Left Justified/Zero Filled	Patient Account Number.
Patient Name	13-24	AN	Left Justified/Space Filled	Patient Last Name + ", " + Patient First Name No "," if only have last name. If have first name only, will put "," without last name (", name")."
OCR Scan Line	25-78	AN	Space filled	Empty String, not used.
Statement Date	79-86	DT		Today's Date, not Business Date (mmddccyy).
COID	87-91	NUM	Zero filled	Zero Filled String.
Practice/Facility ID	92-96	AN	Left Justified/Zero Filled	Additional Info 1.
Payment Date	97-104	DT		Business Date of Transaction.
Payment Type	105	NUM		0 = Default 1 = eCheck Transaction 2 = Credit Card Transaction 3 = Manual Check."
Credit Card Type	106	NUM		0 = Default 1 = American Express 2 = Visa 3 = Discover.
Check Number	107-116	NUM	Left Justified/Zero Filled	Check number if present
Paid Amount	117-127	NUM	Left Justified/Zero Filled	Absolute value of payment, implied decimal.
Balance Due	128-138	NUM	Zero Filled	Zero Filled String.
Trailer Record
Record ID	1/2/2016	AN		"99".
Total Patient Records	3-12	NUM	Left Justified/Zero Filled	Total Transactions in the file (count).
Total Check Payments	13-23	NUM	Left Justified/Zero Filled	Total Check Sale Amount - Check Refund Amount Monetary Value, not a count of how many transactions Implied Decimal.
Total Credit Payments	24-34	NUM	Left Justified/Zero Filled	Total Credit Card Sale Amount - Credit Card Refund Amount. Monetary Value, not a count of how many transactions. Implied Decimal.
Total Cash Payments	35-45	NUM	Left Justified/Zero Filled	Total Cash Sale Amount - Cash Refund Amount. Monetary Value, not a count of how many transactions Implied Decimal.
Total Sum of All Payments	46-56	NUM	Left Justified/Zero Filled	Total Sale Amount - Total Refund Amount. Monetary Value, not a count of how many transactions. Implied Decimal.
Filter	57-138	AN	Space Filled	Empty String.