EOD Posting File Lockbox D

Lockbox Version D 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: <Account/Group ID/Outlet> + “_” + CCYYMMDD + “.txt”

  • File can be generated by Account or Outlet.

File Format: Fixed Position, Fixed Width

FieldLocationTypeDescriptionComments
Record Type1NUMConstant Value = "1".
Priority Code2-3NUMConstant Value = "00".
Destination4-13NUMRight Justified/Space FilledInstaMed EMC ID.
Origin14-23ANRight Justified/Zero FilledConstant Value = "INSTAMED".
File Date24-29DTYYMMDDBusiness date of transactions.
File Time30-33NUMAll Zeros.
Lockbox Header
Record Type1NUMConstant Value = "2".
Priority Code2-3NUMConstant Value = "00".
Destination4-13NUMLeft Justified/Space FilledInstaMed EMC ID.
Origin14-23ANRight Justified/Zero FilledConstant Value = "INSTAMED".
Filler24-31ANAll Zeros.
Service Type Code32-34ANRight Justified/Zero FilledDefault = 400 unless configured.
Record Size35-37NUMConstant Value = "080".
Block Size38-41NUMConstant Value = "0080".
Format No Compress42NUMConstant Value = "1".
Batch Header
Record Type1NUMConstant Value = "5".
Batch Number2-5NUMSequence number starting at 0001.
Filler6-8ANAll Zeros.
Lockbox Number9-15ANAll Zeros.
Batch Date16-21DTYYMMDDBusiness date of transactions.
Company DDA22-36NUMAll Zeros.
Origin37-46ANRight Justified/Zero FilledConstant Value = INSTAMED.
Check and Invoice Record: 1
Record Type1NUMRight Justified/Zero FilledConstant Value = "6" for first record; all zeros for remaining records in batch.
Batch Number2-5NUMSequence number starting at 0001.
Item Number6-8NUMRight Justified/Zero FilledSequence number 1-999.
Lockbox Number9-15ANAll Zeros.
Payment Date16-21DTYYMMDDBusiness date of transaction.
Payment Account Number22-34NUMRight Justified/Zero FilledLast 4 digits of Card Number or Check DDA Number.
Check Routing Number35-44NUMRight Justified/Zero FilledUsed for check transactions only.
Payment Amount45-54NUMRight Justified/Zero Filled No Decimal PointTwo places assumed.
Payment Serial Number55-64ANRight Justified/Zero FilledAuthorization Number for card transactions, Check Number for check transactions.
Check and Invoice Record: 2
Record Type1NUMConstant Value = "4".
Batch Number2-5NUMSequence number starting at 0001.
Item Number6-8ANRight Justified/Zero FilledSequence number 1-999.
Overflow Type9ANConstant Value = "6".
Overflow Seq Number10-11NUMAll Zeros.
Last Overflow Flag12NUMAll Zeros.
Account Number13-27ANRight Justified/Zero FilledPatient Account Number.
Payment Amount28-37NUMRight Justified/Zero Filled No Decimal PointTwo places assumed.
Batch Trailer
Record Type1NUMConstant Value = "7".
Batch Number2-5NUMSequence number starting at 0001.
Filler6-8ANAll Zeros.
Lockbox Number9-15ANAll Zeros.
Batch Date16-21DTYYMMDDBusiness date of transactions.
Batch Record Count22-24NUMMaximum 999.
Batch Total Amount25-34NUMRight Justified/Zero Filled No Decimal Point
Lockbox Trailer
Record Type1ANConstant Value = "8".
Batch Number2-5ANAll Zeros.
Filler6-8ANAll Zeros.
Lockbox Number9-15ANAll Zeros.
Batch Date16-21DTYYMMDDBusiness date of transactions.
Lockbox Batch Count22-24NUMRight Justified/Zero Filled
Lockbox Total Amount25-34NUMRight Justified/Zero Filled No Decimal Point
File Trailer
Record Type1ANConstant Value = "9".
File Record Count2-7ANRight Justified/Zero FilledFile record count, includes Lockbox Header records.