ICVER001.REQ

From RPOWERWiki

Jump to: navigation, search

ICVER001.REQ is the CSV file format used to import credit card (and customer) transactions into RPOWER.

Line Format

A,B,[C-]D[-E],F,G[H],I,J,K[:L],M,N,O,P

AA 
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.

BBBBBBB 
Server ID (number)
CCCCCC 
(Optional) RPOWER ticket number.
DDDDDDDD 
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."
EEEEEE 
The new 6-digit uppercase alphanumeric ICT.dbf TNUMBER.
FFFFFFFFFFFFFFFF 
Card number.
GGGG 
Expiration date in the form YYMM.
HHHHHHHH... 
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.
IIII.II 
Base amount (authorized).
JJJ.JJ 
Tip used by everthing except CA.
KKKKKK 
Approval code used by C5 and CS. This can be followed by internal 911 data following a colon (L), which will be ignored.
MMMMMMMMM... 
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.
NNNNNNNN 
Optional transaction date in the form CCYYMMDD (e.g,. 20130920 for September 20, 2013).
OOOOOOOO 
Optional transaction time in the form HH:MM:SS.
PPPPPPPP 
Optional business date. If dates are provided, they can be used to break up the Settle Credit Cards Now operation.

Example

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:

Views
Personal tools