eProcessingNetwork has developed the eProcessingNetwork Transparent Database Engine Template for merchants that securely collect and save ALL customer, order, shipping and credit card information. This is often done by merchants to automate shipping or for customer notifications.  
Use of this integration template requires intermediate- to advanced-level programming capability. eProcessingNetwork offers support for this template via email only at DevUtils@eProcessingNetwork.Com.

The eProcessingNetwork Transparent Database Engine Template allows merchants to process transactions from their web page without actually flipping the customer over to a page on the eProcessingNetwork server. This requires the merchants web server to securely collect and save ALL customer, order, shipping and credit card information, to POST the transaction processing request to eProcessingNetwork, and to parse the response returned by eProcessingNetwork for the status of each processed transaction.

In this case, the merchants' eProcessingNetwork account number, the credit card number, the expiration month (01 thru 12), expiration year (last two digits), the transaction amount, the customers street address, zip code and email address need to be passed to the eProcessingNetwork Secure Transaction Processing Server. Optionally, CVV2 information can also be passed for processing.

The required format of these variable are case sensitive and these names are as follows.
 

Variables

Values
ePNAccount 05971 (numeric value only)
CardNo XXXXXXXXXXXX2736
(numeric value only no spaces)
ExpMonth 05    (2 Digit Month)
ExpYear 06    (2 Digit Year)
Total 20.00 (numeric value only)
Address 123 Main
Zip 77008 (numeric value only)
EMail customer@url.com
Post to URL https://www.eProcessingNetwork.Com/cgi-bin/tdbe/transact.pl

 (Sample Code)

Optional Variables

Values
FirstName

Johnny
LastName

America
CVV2Type
(more info)		 1 I have entered my CVV2 above
2 My cards' CVV2 is illegible
9 My card has no CVV2 imprint
0 Not passing CVV2
CVV2
 (more info) 		123 (numeric value only)
HTML
 (more info)

No

 Causes the template to output the response without the HTML tags
Processing Check Variables Learn about processing checks with TDBE

 

HTML

By default, the eProcessingNetwork Transparent Database Engine Template outputs its' response in HTML format, i.e. wrapped in <html> and <body> tags, which can often aid in testing. Sending the additional variable HTML set to No causes the template to output the response without the HTML tags.

After the transaction has been processed, the banks' response to the transaction, as well as the Address Verification System response, are output as follows:

With HTML:

<html>
<body>
"YAUTH/TKT 019829","Address and Zip Code Do Not Match","CVV2 Not a Match"
</body>
</html>

Without HTML:

"YAUTH/TKT 019829","Address and Zip Code Do Not Match","CVV2 Not a Match"

The response is essentially three quoted, comma-delimited strings. The first string always starts with a Y (Yes, approved), an N (No, declined) or a U (No, unable), and is followed by up to 16 characters describing the transaction response. The second string is the Address Verification Systems' response to the street address and Zip code supplied. The third string is the CVV2 systems' response to the CVV2 information supplied. Available CVV2 options are documented here.

Sample Code

eProcessingNetwork offers sample Perl, ASP, ASP.Net and PHP source code to assist developers in integrating the eProcessingNetwork Transparent Database Engine Template.

Detailed Documentation

eProcessingNetwork offers detailed documentation on Integrating the TDBE into Web Sites, third-party software and devices, including a reference guide of TDBE Variables and Advanced Features.

For questions, suggestions or special requests, send e-mail to DevUtils@eProcessingNetwork.Com

 

Copyright © 2000 - 2010 eProcessing Network, LLC. All Rights Reserved.