Lockbox Version A1.1 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> + <Account ID (without @ symbol)> + 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
Example: bWFR-WFR-WFR20100720.txt
Note: File only includes transactions that have a status of “Captured” or “Settled.”
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 | |
| Lockbox Number | 10-15 | AN | Zero Filled | Lockbox Number (last 6 characters of the Merchant ID, i.e., the "Merchant" or "M" of the MST) |
| 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 | Paid Amount. If Negative, put negative sign on far left (e.g., 00000000000001). |
| No Decimal Point | ||||
| Guarantor Account Number | 35-54 | AN | Guarantor Account Number (Patient Account Number, If larger than 20 characters, take the last 20 characters). | |
| Payment Source | 55-60 | NUM | Payment Source (000001 - Cash, 000002 - Check, 000006 - American Express, 000007 - Discover, 000008 - Master Card, 000009 - Visa, 000010 - Other). | |
| Payment Procedure | 61-66 | NUM | Default = "000001" or Transaction Code from payment form. | |
| Patient Address 2 | 67-117 | Patient Address 2. | ||
| Trailer Record | ||||
| Record Code | 1 | AN | Constant Value = "T". | |
| Total File Amount | 2-16 | NUM | No Decimal Point | Total File Amount, Negative Amounts have sign on far left (e.g., -00000000000001). |
| File Total Payment Count | 17-26 | NUM | File Total Payment Count. | |