The format below is for the generic IDI Verification file for processing response files. You can use these files to import information into Batch Cash Management. This file format can be used in the future for any payment service provider the IDI platform uses.
The first line in the file is a header identifying the file type and version:
IDI Verification File v. 1.00
The verification records comprise the 2nd through the nth lines. The field delimiter is a comma. Each line is terminated by a standard CRLF combination. Values in bold indicate inserts into the database. The rows in italics are optional.
Field Name | Description | Value/Formats | Table.Column |
|---|---|---|---|
EPay | ID of the original entry in the EPayTransaction table. | int | EPayTransaction.EPayTransactionID |
Customer ID | Customer’s ID. | int | Customer.CustID |
Transaction Date | Date the transaction was processed, approved, or declined. | MM/DD/YY or MM/DD/YYYY | EPayTransaction.ApprovalDate |
Amount | Dollar amount. Returned amounts are expected to echo the original entry in the EPayTransaction table. We do not cross-check. | $$$$.cc format | EPayTransaction.Amount |
Transaction Type | Determines whether the transaction goes into the Payments or Adjustments table. | “P” (payment) | Payments |
Payment Method | Used with Transaction Type to determine the transaction type ID for the appropriate table. | “EC” (e-check) | Payments.PaymentTypeID |
Approval Code | Indicates the outcome of processing for this transaction. | 4=Approved | EPayTransaction.EPayStatusID |
Bureau Transaction ID | Number the credit service/bureau assigns to a transaction after it is submitted for processing. If your company uses Authorize.Net, this field is required for Credits. | 50 chars. | EPayTransaction.BureauTransactionID |
Description | Your company's description of the transaction. | 50 chars | Payments.Description |