As of the 7.3 release, the Credit Card Request Review screen allows you to view credit card request and response information from credit card processors. This information is visible for all credit card receipts and vouchers. This screen is read-only and displays records from the CCP_Req_Ans table, which stores records created by CCP610. Only records related to credit card receipts or vouchers that exist in the CCP_Req_Ans table can be viewed on this screen. Pre-settled credit cards do not have records in CCP_Req_Ans table, so they would not display here.
You can search for a credit card processing record by searching for a receipt or a voucher. Unlike check refunds, credit card refunds only apply to a single credit card receipt. Therefore, searching for a voucher will only return a single receipt.
A credit card receipt can have a record in CCP_Req_Ans but not in the FAR_Receipt table in Personify. This can happen if the initial credit card record authorization is successful but Personify does not approve the transaction because the credit card failed with CVV or address validation.
You can access this screen by performing one of the following:
Clicking Review CC Requests on the Receipt Analysis tab of the Customer Financial Analysis screen. The Credit Card Request Review screen displays with the receipt number highlighted.
Clicking Review CC Requests on the Unapplied Receipt tab of the Customer Financial Analysis screen. The Credit Card Request Review screen displays with the receipt number highlighted.
Clicking Review CC Requests on the Refund Analysis tab of the Customer Financial Analysis screen. The Credit Card Request Review screen displays with the voucher number highlighted.
Clicking Review CC Requests on the Receipt Review screen. The Credit Card Request Review screen displays with the receipt number highlighted.
Selecting Accounting > Receipts > Review CC Requests from the toolbar. The Credit Card Request Review search screen displays where you must search for the appropriate receipt.
The Credit Card Processing Review section displays high-level information about the credit card, such as:
Receipt Number – the receipt number in the CCP_REQ_ANS table.
Card Type – the type of card. For example, Master Card or Visa.
Amount – the amount of the credit card receipt. If the receipt was made in the base currency, then this amount is the same as the Base Amount.
Card Holder – the name of the credit card holder. This is the same value as the “Name” field on the Card tab.
Receipt Date – the date the selected receipt was created.
Currency – the currency used on the receipt. This is pulled from the Receipt table, so it will display blank if there is no matching receipt.
The Request Type table displays the requests made for the credit card for the specified receipt. The Request Types can include Pre-Sale, Pre-Auth, Sale, and Credit.
The Authorization tab displays the following authorization/verification information:
Credit Card Req Answer ID – the system-generated ID number in the CCP_REQ_ANS table.
Batch – the Batch ID of the batch used for the payment.
Log Message – this varies based on the answer received to the request. A concatenation of several fields. Use the icon next to this field to view more text.
Authorization – the number of the authorization. You can use this number to void a transaction online.
Authorization Reference – the token used in the authorization.
Original Authorization – the token used in the original authorization. Used for all subsequent transactions (settlements, refunds, void transactions).
Deferred Auth Exp Date – the answer timestamp plus the number of days from the CCP_Auth_Hold_Period application parameter.
Settlement Number – the settlement number. If the transaction was good, then the settlement number is the date timestamp. If the transaction was bad, then the settlement number is set to a negative date/timestamp. If the transaction was pre-settled, then the settlement number is set to “-1.”
Voucher Number – a system-generated ID that identifies the Personify voucher. If some or all of a credit card payment is to be or has been refunded, then this field will store the voucher ID. A value of zero indicates no voucher exists for the credit card receipt.
Original Receipt Number- displays the original receipt number.
AVS Result – “Y” indicates the street address passed the authorization. “N” indicates the street address did not pass the authorization.
ZIP Result – “Y” indicates the zip/postal code passed the authorization. “N” indicates the zip/postal code did not pass the authorization.
CVV Result – “Y” indicates the CVV code passed the authorization. “N” indicates the CVV code did not pass the authorization.
The Request/Response tab provides information on the processor’s response to the credit card request:
Request Answer Date/Time – the date and time the payment handler answered the request.
Error Code – the error code returned by the credit card processor (if applicable).
Reject Reason – the reason the credit card was rejected (if applicable). This field is when the answer is received and it will be blank if the request was approved. Use the icon next to this field to view more text.
Request Token – the encrypted AUTH_REFERENCE from CyberSource. This is not used with PayPal. Use the icon next to this field to view more text.
Original Request Token – the encrypted ORIGINAL_AUTH_REFERENCE from CyberSource. This is not used with PayPal. Use the icon next to this field to view more text.
Original Request Type – the request type of the original request. This is only used with CyberSource.
Response Code – the code for the type of response from the payment handler.
Response Message – the response message from the payment handler. Use the icon next to this field to view more text.
Processor Response Code – the code for the type of response from the processor.
Processor Response Message – the response message from the processor. Use the icon next to this field to view more text.
The Card tab lists all of the card and card-holder information:
Address – the first line of the credit card holder’s billing address. Processors use the numeric street number to execute AVS (address verification service) verification. Payor does not need to be in our system.
City, State, Zip – the city, state, and zip code for the billing address of the credit card holder.
Country – the country name for the billing address of the credit card holder.
Email Address – the email address of the credit card holder.
Home Phone – the home phone number of the credit card holder.
Customer IP Address – stores the IP Address from the browser header. This functionality is not yet implemented.
Name – the name of the credit card holder.
Issuer Number – this is only used on European credit cards.
Begin Date – this is only used on European credit cards.
Expiration Date – the expiration date of the credit card.
The Miscellaneous tab provides the following information regarding the credit card request:
Comments – this is the same as the Credit Card Req Answer ID, but PayPal refers to it as “Comments.”
Requester – User ID of the logged in user that initiated the credit card transaction.
Application – the Personify screen or batch process that generated the credit card activity.
Merchant ID – the Merchant_ID used to process the credit card activity.
Payment Handler – identifies the payment handler used for the credit card transaction. Personify supports PayPal and CyberSource payment handlers. The code “VERISIGN” is used for PayPal.
