InstaMed is able to support a transaction level interchange cost report which includes all transactions and all associated assessment, network, and interchange fees.
InstaMed’s Interchange Daily File is generated at the transaction level. InstaMed will only output one record per transaction and can support the delivery of zero byte files.
This Interchange Daily file is a batch file in a pipe-delimited format.
The file is uploaded daily by InstaMed via SFTP.
| Field Number | Field Name | Format | Min | Max | Required | Comments/Notes |
|---|---|---|---|---|---|---|
| 1 | Record ID | IMIRF10 | 7 | 7 | Y | |
| 2 | Merchant ID | AN | 16 | 16 | Y | |
| 3 | Store ID | AN | 4 | 4 | Y | |
| 4 | Terminal ID | AN | 4 | 4 | Y | |
| 5 | Transaction ID | AN | 32 | 32 | Y | |
| 6 | Transaction Date | AN | 8 | 8 | Y | YYYYMMDD, Available when transactions status is paid |
| 7 | Payment Transaction Action | AN | 1 | 35 | Y | |
| 8 | Amount | DEC | 1 | 12 | Y | |
| 9 | Request Amount | DEC | 1 | 12 | Y | |
| 10 | Effective Amount | DEC | 1 | 12 | Y | |
| 11 | Authorization Number | AN | 1 | 6 | Y | |
| 12 | Market Segment | AN | 1 | 10 | Y | Retail, MOTO, ECOM |
| 13 | Is Swiped | AN | 1 | 1 | Y | |
| 14 | Card Type | AN | 1 | 20 | Y | Visa, MC, Discover |
| 15 | Card BIN Number | AN | 6 | 6 | Y | |
| 16 | Last Four Digits | AN | 4 | 4 | Y | |
| 17 | Network Interchange Category | AN | 1 | 20 | Y | |
| 18 | Interchange Rate Percent | DEC | 1 | 12 | N | |
| 19 | Network Interchange Cost | DEC | 1 | 12 | Y | |
| 20 | Interchange Per Item | DEC | 1 | 12 | N | |
| 21 | Interchange Receipt Date | AN | 1 | 15 | Y | YYYYMMDD_HHMMSS |