How do I get the VisaNet approvalCode in Commerce from Payment Manager?

[j***@sbcglobal.net]

We need to send the VisaNet approval code in our OrderCreateXML.jsp to the back-end. Unfortunately I do not see a way to do it (other than writing custom SQL and the payment manager database is local to the Payment Manager which is on another system).

Right now I can only get the AVSCode using the PayStatusPMDataBean. Is there a way from inside Commerce to get the actual 6 digit approval code and put it in the OrderCreateXML.jsp?

[geo]

Hi Jason,

We have coding that puts this in the ORDPAYINFO information during the order
flow, typically wired in during ExtOrderProcess.
--
George Niece
Solutions Architect
eGlobal Solutions
cel: 1-760-807-8823
AIM: GeorgeNiece
http://eGlobal-Sol.com

Post by j***@sbcglobal.net
We need to send the VisaNet approval code in our OrderCreateXML.jsp to the
back-end. Unfortunately I do not see a way to do it (other than writing
custom SQL and the payment manager database is local to the Payment
Manager which is on another system).
Right now I can only get the AVSCode using the PayStatusPMDataBean. Is
there a way from inside Commerce to get the actual 6 digit approval code
and put it in the OrderCreateXML.jsp?

[j***@sbcglobal.net]

I went ahead and extended the PayStatusPMDataBean (5.6.1) to add this. In 5.6.1 the approval code does not seem to flow into the ORDPAYINFO table (when using VisaNet at least).