CTI_ParseTransactionQuery()
This subprocedure is used to parse a previously downloaded transaction query response. This subprocedure requires that you provide the fully-qualified filepath of the downloaded query response file in the IFS. If this query was performed using CTI_QueryTransaction(), 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 file in the IFS that will be parsed. If this query was performed using CTI_QueryTransaction(), 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 Transaction Detail Query Record |
|
Key Query Unique ID CyberSource query ID |
|
CyberSource request unique ID |
|
Transaction reconciliation ID |
|
Merchant ID for the account |
|
Transaction status |
|
Submission timestamp |
|
Application status |
|
Application reason code |
|
Application RCode |
|
Application RFlag |
|
Merchant customer ID |
|
Buyer hashed password |
|
Client reference code |
|
Client application version |
|
Client application name |
|
Client application user |
|
Client application comments |
|
Consumer ECI raw |
|
Consumer CVV |
|
Consumer XID |
|
Consumer transaction ID |
|
Customer device IP address |
|
Customer device host name |
|
Consumer device cookies accepted |
|
Error information reason |
|
Error information message |
|
Number of installments |
|
Fraud marking reason |
|
Merchant descriptor name |
|
Bill to customer first name |
|
Bill to customer last name |
|
Bill to customer middle name |
|
Bill to customer name suffix |
|
Bill to customer address line 1 |
|
Bill to customer address line 2 |
|
Bill to customer city |
|
Bill to customer state |
|
Bill to customer zip |
|
Bill to company name |
|
Bill to company address line 1 |
|
Bill to company address line 2 |
|
Bill to company city |
|
Bill to company state |
|
Bill to company zip |
|
Bill to company country |
|
Bill to email address |
|
Bill to customer country |
|
Bill to customer title |
|
Bill to phone |
|
Ship to first name |
|
Ship to last name |
|
Ship to address line 1 |
|
Ship to address line 2 |
|
Ship to city |
|
Ship to state |
|
Ship to zip |
|
Ship to company name |
|
Ship to country |
|
Ship to phone |
|
Total amount |
|
Amount currency |
|
Tax amount |
|
Authorized amount |
|
Settlement amount |
|
Settlement amount currency |
|
Gift wrapping |
|
Shipping method |
|
Payment type name |
|
Payment type |
|
Payment type method |
|
Payment type funding source |
|
Payment type funding source affiliation |
|
Payment type credential |
|
Payment customer ID |
|
Card suffix |
|
Card prefix |
|
Card expiration month |
|
Card expiration year |
|
Card start month |
|
Card start year |
|
Card issue number |
|
Card type |
|
Card account encoder ID |
|
Card use-as |
|
Invoice number |
|
Invoice barcode number |
|
Invoice expiration date |
|
Bank rounting number |
|
Branch code |
|
Bank swift code |
|
Bank code |
|
Bank IBAN |
|
Bank account suffix |
|
Bank account prefix |
|
Bank check number |
|
Bank account type |
|
Bank account name |
|
Bank account check digit |
|
Bank account encoder ID |
|
Bank mandate reference number |
|
Bank mandate recurring type |
|
Bank mandate ID |
|
Account balance |
|
Account previous balance |
|
Account currency |
|
Payment solution |
|
Procesing commerce indicator |
|
Processing application ID |
|
Authorization type |
|
Bank transfer sec code |
|
Processor name |
|
Processor transaction ID |
|
Processor network transaction ID |
|
Processor response ID |
|
Processor provider transaction ID |
|
Processor approval code |
|
Processor response code |
|
AVS code |
|
AVS code raw |
|
CVN result code |
|
ACH verification result code |
|
ACH verification result code raw |
|
Electronic verification email result |
|
Electronic verification email result raw |
|
Electronic verification name result |
|
Electronic verification name result raw |
|
Electronic verification phone result |
|
Electronic verification phone result raw |
|
Electronic verification street result |
|
Electronic verification street result raw |
|
Electronic verification ZIP result |
|
Electronic verification ZIP result raw |
|
Processor system trace audit number |
|
Processor response code source |
|
POS entry mode |
|
POS terminal capability |
|
Profile name |
|
Profile decision |
|
Passive profile name |
|
Passive profile decision |
|
Score factor codes |
|
Score results |
|
Risk information local time |
|
Sender reference number |
|
Record CyberSource Transaction Query Application Record |
|
Key Parent Query Unique ID |
|
Key CyberSource Query ID |
|
Key Application unique ID |
|
Application name |
|
Application status |
|
Application reason code |
|
Application RCode |
|
Application RFlag |
|
Application reconciliation ID |
|
Application rmessage |
|
Application return code |
|
Record CyberSource Transaction Query Error Record |
|
Key Parent Query Unique ID |
|
Key CyberSource Query ID |
|
Key Error unique ID |
|
Json field in error |
|
Error reason |
|
Record CyberSource Exception Detail Report Line Item Record |
|
Key Parent Query Unique ID |
|
Key CyberSource Query ID |
|
Key Line item unique ID |
|
Product code |
|
Product name |
|
Product SKU |
|
Tax amount |
|
Product quantity |
|
Unit price |
|
Fulfillment type |
|
Record CyberSource Transaction Query Merchant-Defined Information Record |
|
Key Parent Query Unique ID |
|
Key CyberSource Query ID |
|
Key Merchant-defined record unique ID |
|
Merchant-defined information key |
|
Merchant-defined information value |
|
Record CyberSource Transaction Query Passive Rule Record |
|
Key Parent Query Unique ID |
|
Key CyberSource Query ID |
|
Key Passive rule unique ID |
|
Passive rule name |
|
Passive rule decision |
|
Record CyberSource Transaction Query Rule Record |
|
Key Parent Query Unique ID |
|
Key CyberSource Query ID |
|
Key Rule unique ID |
|
Rule name |
|
Rule decision |