CTI_ParseExceptionDetailReport()
This subprocedure is used to parse a previously downloaded exception detail report. This subprocedure requires that you provide the fully-qualified filepath of the downloaded report file in the IFS. If this report was downloaded with CTI_DownloadReport(), the report file will be found in the default download directory specified in your CTICFGMCH record.
Parsed data will be written to the output tables described below. This data can then be retrieved from the tables and stored in a more permanent manner; the output tables should be treated as temporary, transactional tables and not used for long-term storage.
If an error occurs, this subprocedure will return *OFF, and information about the error will be present in the pErrorDS parameter which contains a CTI_ErrorDS_t data structure.
Subprocedure Prototype
|
Returns *OFF if an error occurs during processing, *ON otherwise. |
|
Unique ID, generated with CTI_NextUniqueID(), that will be used to identify the parsed records from this file Required |
|
The fully-qualified filepath of the report file in the IFS that will be parsed. If this report was downloaded using CTI_DownloadReport(), the file will be in the default download directory specified in your CTICFGMCH record |
|
Error data structure used to capture subprocedure and CyberSource errors Required |
Data Structures
|
|
|
Name of subprocedure returning error |
|
Message ID of error message |
|
Error message text |
|
Error message source |
|
IFS filepath of generated log file |
Output Table Files
|
Record CyberSource Exception Detail Report Record |
|
Key Report Unique ID |
|
Key CyberSource request unique ID |
|
Merchant ID for the reporting account |
|
Filepath of the parsed report |
|
Report name |
|
Report type |
|
Report version |
|
Report organization ID |
|
Report start date |
|
Report end date |
|
Request comments |
|
Request localized date |
|
Request merchant ID |
|
Request merchant reference number |
|
Request partner original transaction ID |
|
Request partner SDK version |
|
Request source |
|
Request subscription ID |
|
Request terminal serial number |
|
Request date |
|
Request user |
|
Action description |
|
CyberSource exception ID |
|
Client ID |
|
Processor response code |
|
DCC exchange rate |
|
DCC lookup status |
|
DCC margin rate |
|
Exception amount |
|
Exception amount currency |
|
Exception category |
|
Exception date |
|
Exception description |
|
Exception device hardware revision |
|
Exception device ID |
|
Exception device OS |
|
Exception device OS version |
|
Exception device terminal ID |
|
Exception message |
|
Exception reason code |
|
Exception reason description |
|
Exception status |
|
Exception status code |
|
Exception type |
|
Financial status |
|
Last action date |
|
Local currency code |
|
Next action date |
|
Original transaction submission date |
|
Partner merchant ID |
|
Partner merchant name |
|
Payment number |
|
Processor-assigned case ID |
|
Retries |
|
SDK version |
|
Scheme operator |
|
Storage mechanism |
|
Bill to address line 1 |
|
Bill to address line 2 |
|
Bill to city |
|
Bill to company name |
|
Bill to company tax ID |
|
Bill to country |
|
Bill to customer ID |
|
Bill to email |
|
Bill to customer first name |
|
Bill to hostname |
|
Bill to IP address |
|
Bill to customer last name |
|
Bill to customer middle name |
|
Bill to customer name suffix |
|
Bill to personal ID |
|
Bill to phone number |
|
Bill to state |
|
Bill to customer title |
|
Bill to customer user name |
|
Bill to ZIP |
|
Ship to address line 1 |
|
Ship to address line 2 |
|
Ship to city |
|
Ship to company name |
|
Ship to country |
|
Ship to customer first name |
|
Ship to customer last name |
|
Ship to phone number |
|
Ship to state |
|
Ship to ZIP |
|
Shipping carrier |
|
Shipping method |
|
Payment method type description |
|
Override payment method |
|
Last 4 digits of check payment account number |
|
Check number |
|
ID reference for direct debit mandate |
|
Mandate type |
|
Date of signature |
|
Check account type |
|
Check account encoder ID |
|
Check bank transit number |
|
Check effective date |
|
Type of wallet |
|
Type of card |
|
Card expiration month |
|
Card expiration year |
|
Card start month |
|
Card start year |
|
Maestro card issue number |
|
Payment account number last 4 digits |
|
Additional card type |
|
Card prepaid reloadable |
|
Card prepaid type |
|
Card virtual |
|
Bank check digit |
|
IBAN |
|
Bank address |
|
Bank branch code |
|
Bank city |
|
Bank country |
|
Bank name |
|
Bank SWIFT/BIC code |
|
Transaction token code |
|
Network token transaction type |
|
Bank/sort code |
|
Bank account name |
|
Boleto barcode number |
|
Payment method type |
|
Boleto Bancario payment number |
|
Applied AVS |
|
Appled CV |
|
Applied category gift |
|
Applied category time |
|
Applied host hedge |
|
Applied threshold |
|
Applied time hedge |
|
Applied velocity hedge |
|
BIN account type |
|
BIN country |
|
BIN issuer |
|
BIN scheme |
|
Consumer loyalty |
|
Consumer password provided |
|
Consumer promotions |
|
Cookies accepted |
|
Cookies enabled |
|
Device fingerprint |
|
Factors |
|
Flash enabled |
|
Giftwrap |
|
Host severity |
|
IP city |
|
IP country |
|
IP routing method |
|
IP state |
|
Images enabled |
|
JavaScript enabled |
|
Lost password |
|
Product risk |
|
Proxy IP address |
|
Proxy IP address activities |
|
Proxy IP address attributes |
|
Proxy server type |
|
Repeat customer |
|
Returns accepted |
|
Risk score |
|
Risk time local |
|
True IP address |
|
True IP address attributes |
|
True IP address city |
|
True IP address country |
|
True IP address activities |
|
Device ID |
|
Gift card current balance |
|
Gift card previous balance |
|
Custom data 1 |
|
Record CyberSource Exception Detail Report Application Reply Record |
|
Key Parent Report Unique ID |
|
Key CyberSource request unique ID |
|
Key Application reply unique ID |
|
Application name |
|
Application reply RCODE |
|
Application reply reason code |
|
Application reply RFLAG |
|
Application reply message |
|
Record CyberSource Exception Detail Report Info Code Record |
|
Key Parent Report Unique ID |
|
Key CyberSource request unique ID |
|
Key Info code unique ID |
|
Info code type |
|
Info code value |
|
Record CyberSource Exception Detail Report Line Item Record |
|
Key Parent Report Unique ID |
|
Key CyberSource request unique ID |
|
Key Line item unique ID |
|
Line item number |
|
Line item fullfillment type |
|
Line item invoice number |
|
Line item merchant product SKU |
|
Line item product code |
|
Line item product name |
|
Line item quantity |
|
Line item tax amount |
|
Line item unit price |
|
Record CyberSource Exception Detail Report Merchant-Defined Data Record |
|
Key Parent Report Unique ID |
|
Key CyberSource request unique ID |
|
Merchant-defined data 1 |
|
Merchant-defined data 2 |
|
Merchant-defined data 3 |
|
Merchant-defined data 4 |
|
Merchant-defined data 5 |
|
Merchant-defined data 6 |
|
Merchant-defined data 7 |
|
Merchant-defined data 8 |
|
Merchant-defined data 9 |
|
Merchant-defined data 10 |
|
Merchant-defined data 11 |
|
Merchant-defined data 12 |
|
Merchant-defined data 13 |
|
Merchant-defined data 14 |
|
Merchant-defined data 15 |
|
Merchant-defined data 16 |
|
Merchant-defined data 17 |
|
Merchant-defined data 18 |
|
Merchant-defined data 19 |
|
Merchant-defined data 20 |
|
Record CyberSource Exception Detail Report Payment Info Record |
|
Key Parent Report Unique ID |
|
Key CyberSource request unique ID |
|
Key Payment info unique ID |
|
AVS result |
|
AVS result mapped |
|
Acquirer merchant number |
|
Grand total amount |
|
Auth factor code |
|
Auth indicator |
|
Auth reversal amount |
|
Auth reversal result |
|
Authorization code |
|
Authorization type |
|
Batch files ID |
|
VCN result code |
|
Card category |
|
Card category code |
|
Card present |
|
Card verification method |
|
Customer ID |
|
DCC indicator |
|
EMV request fallback |
|
Exchange rate |
|
Exchange rate date |
|
Issuer response code |
|
Mandated reference number |
|
Network code |
|
Network transaction ID |
|
Original amount |
|
Original currency |
|
POS CAT level |
|
POST entry mode |
|
POS environment |
|
Payment processor |
|
Payment request ID |
|
PIN type |
|
Processor MID |
|
Processor response code |
|
Processor response ID |
|
Processor TID |
|
Processor transaction ID |
|
Token network type |
|
Solution type |
|
Store and forward indicator |
|
Sub-merchant city |
|
Sub-merchant country |
|
Sub-merchant email |
|
Sub-merchant ID |
|
Sub-merchant name |
|
Sub-merchant phone |
|
Sub-merchant postal code |
|
Sub-merchant state |
|
Sub-merchant street |
|
Target amount |
|
Target currency |
|
Terminal ID alternate |
|
Total tax amount |
|
Transaction reference number |
|
E-commerce indicator |
|
Recipient address |
|
Recipient city |
|
Recipient country |
|
Recipient date of birth |
|
Recipient first name |
|
Recipient last name |
|
Recipient middle initial |
|
Recipient phone |
|
Recipient postal code |
|
Recipient billing amount |
|
Recipient billing curency |
|
Recipient state |
|
Sender address |
|
Sender city |
|
Sender country |
|
Sender date of birth |
|
Sender first name |
|
Sender last name |
|
Sender middle initial |
|
Sender phone |
|
Sender postal code |
|
Sender reference number |
|
Sender source of funds |
|
Sender state |
|
AAV CAVV |
|
Payer authentication e-commerce information |
|
Payer authentication transaction ID |
|
Raw ACH verification result |
|
Mapped ACH verification result |
|
Currency code |
|
Number of installments |
|
Product code |
|
Grand total |
|
Balance amount |
|
Balance currency code |
|
Requested amount |
|
Requested amount currency |
|
BIN number |
|
Electronic email verification result |
|
Raw electronic email verification result |
|
Electronic name verification result |
|
Raw electronic name verification result |
|
Electronic phone verification result |
|
Raw electronic phone verification result |
|
Electronic post code verification result |
|
Raw electronic post code verification result |
|
Electronic street verification result |
|
Raw electronic street verification result |
|
Debit indicator |
|
EMV service code |
|
AFT indicator |
|
Category affiliate |
|
Category campaign |
|
Category group |
|
AVS result mode |
|
AVS response |
|
Record CyberSource Exception Detail Report Profile and Rules Record |
|
Key Parent Report Unique ID |
|
Key CyberSource request unique ID |
|
Key Profile unique ID |
|
Profile name |
|
Profile activity mode |
|
Profile decision |
|
Profile rule name |
|
Profile rule decision |