File Name
The file must be named: ach_upload_MerchantID_yyyyMMdd
File Header
The file should have a header record with the column names.
You can copy this line and add it as your header:
customerUniqueId|bvpRequestGuid|blpRequestGuid|bqRequestId|merchantId|firstName|lastName|email|phone|street|city|state|zip|businessName|businessEmail|businessPhone|businessStreet|businessCity|businessState|businessZip|routingNumber|accountNumber|transactionAmount|transactionDateTime|transactionId|transactionDescription|returnCode|returnAmount|returnDate|recoveredAmount|recoveredDate|refundAmount|refundDate
File Contents
string
GUID
GUID
GUID
integer
string
string
string
string
string
string
string
string
string
string
string
string
string
string
string
string(9)
string(17)
Decimal
datetime (yyyy-mm-dd hh:mm)
string
string
string(3)
decimal
date (yyyy-mm-dd)
decimal
date (yyyy-mm-dd)
decimal
date (yyyy-mm-dd)