Lockbox Version A 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: <Corporate ID> + <ReportGroupID> + “_” + <ReportGroupName> + “_” + YYYYMMDD + “.txt”
- Date is the processing date of the detail transactions
- Report Group ID and Name are included only if End of Day File Groups are configured
- If End of Day File Groups are not configured, the Merchant ID is returned in the file name between the Corporate ID and date
File Format: Fixed Position, Fixed Width
| Field | Location | Type | Description | Comments |
|---|---|---|---|---|
| Header | ||||
| Record Code | 1 | AN | Constant Value = "H". | |
| Capture Date | 2-9 | DT | YYYYMMDD | Business Date for transactions. |
| Lockbox Number | 10-15 | AN | Zero Filled | Last 6 digits of the Merchant ID. If EOD Posting File Groups are configured, the Merchant ID is replaced by the Report Group ID. |
| Report Group IDs must be numeric and cannot exceed 6 characters. | ||||
| Detail Record | ||||
| Record Code | 1 | AN | Constant Value = "D". | |
| Capture Date | 2-9 | DT - YYYYMMDD | Business date of transaction, same as header. | |
| Check Number | 10-19 | NUM | Right Justified/Zero Filled | All zeros if cash or card. |
| Paid Amount | 20-34 | NUM | Right Justified/Zero Filled | |
| Guarantor Account Number | 35-54 | AN | Patient ID from payment form. | |
| Payment Source | 55-60 | NUM | Tender/Card Type | |
| Payment Procedure | 61-66 | NUM | Default = "000001" or Transaction Code from payment form. | |
| Trailer Record | ||||
| Record Code | 1 | AN | Constant Value = "T". | |
| Total File Amount | 2-16 | NUM | No Decimal Point | Sum total of all Detail transaction amounts. |
| File Total Payment Count | 17-26 | NUM | Sum total of Detail transaction count. | |