ICVER001.REQ is the CSV file format used to import credit card (and customer) transactions into RPOWER.
- Command. One of:
CA : Preauthorization only. Will not settle.
C1 : Auth and Sale. Will settle.
C3 : Credit.
C5 : Force with approval code only.
CS : Force with approval code and server data.
- Server ID (number)
- (Optional) RPOWER ticket number.
- If C and E are present, the 8-digit Omaha ticket/invoice number. If not, a unique 8-digit number, typically a 4-digit RPOWER ticket number followed by a 4-digit old-fashioned "TNUMBER."
- The new 6-digit uppercase alphanumeric ICT.dbf TNUMBER.
- Card number.
- Expiration date in the form YYMM.
- If there is a '=' in this column, the expiration date before it is ignored and everyting after it is treated as actual track 2 data, such that the card number + this column starting at the equals sign reproduces the original track 2 read from the card.
- Base amount (authorized).
- Tip used by everthing except CA.
- Approval code used by C5 and CS. This can be followed by internal 911 data following a colon (L), which will be ignored.
- Server data used by CS. With Mercury Payment Systems, for example, this is present at the end of the approval line in the logs. Having server data allows us to capture and settle transactions using the original authorizations on the host.
- Optional transaction date in the form CCYYMMDD (e.g,. 20130920 for September 20, 2013).
- Optional transaction time in the form HH:MM:SS.
- Optional business date. If dates are provided, they can be used to break up the Settle Credit Cards Now operation.
Copy the Capture line for each transaction you want to process from the logs and paste in to ICVER001-REQ.txt
20160111 7:05:37p CASH1 : Capture : Visa/MC : 0001 : REG SALE : T : 20160111 18:52:33 : 0001228 : 000102-03361517-QILLNX : 549016xxxxxx123 : SPH : ___36.65+___5.00=___41.65 : 487265 : 526938942:
20160111 7:05:36p CASH1 : Capture : Visa/MC : 0001 : REG SALE : T : 20160111 13:05:38 : 0001228 : 000070-46549790-E00HZY : 456789xxxxxx5529 : mnH : ___18.30+___2.00=___20.30 : 06199C : 526745902: