CTI Report Output Tables
The following DB2 physical files are used to hold parsed report data. You should retrieve the parsed information and store it in a more permanent manner; these tables should be treated as temporary, transactional tables and not used as permanent storage.
- CTIRPTREQ - Request Data
- CTIRPTAPR - Application Replies
- CTIRPTCBD - Chargeback Data
- CTIRPTFEI - Fee Info Data
- CTIRPTICD - Info Code Data
- CTIRPTLIN - Line Item Data
- CTIRPTPAY - Payment Info Data
- CTIRPTPRF and CTIRPTRUL - Profiles and Rule Lists
CTIRPTREQ - Request Data
This table will hold data from the <Request>
elements of the report. This includes non-repeating elements and some nested elements.
|
Record CyberSource Report Request Info Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID |
|
Merchant Reference Number |
|
Merchant ID |
|
Request Date |
|
Subscription ID |
|
Source |
|
User |
|
Comments |
|
Transaction Reference Number |
|
Predecessor Request ID |
|
eCommerce Indicator |
|
Bill To First Name |
|
Bill To Last Name |
|
Bill To Middle Name |
|
Bill To Name Suffix |
|
Bill To Address Line 1 |
|
Bill To Address Line 2 |
|
Bill To City |
|
Bill To State |
|
Bill To Zip |
|
Bill To Company Name |
|
Bill To Email |
|
Bill To Country |
|
Bill To Title |
|
Bill To Phone Number |
|
Bill To IP Address |
|
Bill To Host Name |
|
Bill To User Name |
|
Bill To Customer ID |
|
Bill To Personal ID |
|
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 Number |
|
Shipping Method |
|
Shipping Carrier |
|
Card Account Suffix |
|
Card Expiration Month |
|
Card Expiration Year |
|
Card Start Month |
|
Card Start Year |
|
Card Issue Number |
|
Card Type |
|
Card Boleto Number |
|
Card Category |
|
Card Category Code |
|
Wallet Type |
|
Batch ID |
|
Batch Date |
|
Batch Status |
|
Batch Success Flag |
|
Merchant-Defined Data Field 1 Name |
|
Merchant-Defined Data Field 1 Value |
|
Merchant-Defined Data Field 2 Name |
|
Merchant-Defined Data Field 2 Value |
|
Merchant-Defined Data Field 3 Name |
|
Merchant-Defined Data Field 3 Value |
|
Merchant-Defined Data Field 4 Name |
|
Merchant-Defined Data Field 4 Value |
|
Merchant-Defined Data Field 5 Name |
|
Merchant-Defined Data Field 5 Value |
|
Merchant-Defined Data Field 6 Name |
|
Merchant-Defined Data Field 6 Value |
|
Merchant-Defined Data Field 7 Name |
|
Merchant-Defined Data Field 7 Value |
|
Merchant-Defined Data Field 8 Name |
|
Merchant-Defined Data Field 8 Value |
|
Merchant-Defined Data Field 9 Name |
|
Merchant-Defined Data Field 9 Value |
|
Merchant-Defined Data Field 10 Name |
|
Merchant-Defined Data Field 10 Value |
|
Merchant-Defined Data Field 11 Name |
|
Merchant-Defined Data Field 11 Value |
|
Merchant-Defined Data Field 12 Name |
|
Merchant-Defined Data Field 12 Value |
|
Merchant-Defined Data Field 13 Name |
|
Merchant-Defined Data Field 13 Value |
|
Merchant-Defined Data Field 14 Name |
|
Merchant-Defined Data Field 14 Value |
|
Merchant-Defined Data Field 15 Name |
|
Merchant-Defined Data Field 15 Value |
|
Merchant-Defined Data Field 16 Name |
|
Merchant-Defined Data Field 16 Value |
|
Merchant-Defined Data Field 17 Name |
|
Merchant-Defined Data Field 17 Value |
|
Merchant-Defined Data Field 18 Name |
|
Merchant-Defined Data Field 18 Value |
|
Merchant-Defined Data Field 19 Name |
|
Merchant-Defined Data Field 19 Value |
|
Merchant-Defined Data Field 20 Name |
|
Merchant-Defined Data Field 20 Value |
|
Risk Factors |
|
Risk Host Severity |
|
Risk Score |
|
Risk Time Local |
|
Risk Consumer Password Provided |
|
Risk Lost Password |
|
Risk Repeat Customer |
|
Risk Cookies Accepted |
|
Risk Consumer Loyalty |
|
Risk Consumer Promotions |
|
Risk Gift Wrap |
|
Risk Returns Accepted |
|
Product Risk |
|
Risk Appled Threshold |
|
Risk Applied Time Hedge |
|
Risk Applied Velocity Hedge |
|
Risk Applied Host Hedge |
|
Risk Applied Category Gift |
|
Risk Applied Category Time |
|
Risk Applied AVS |
|
Risk Applied CV |
|
Risk Bin Account Type |
|
Risk Bin Scheme |
|
Risk Bin Issuer |
|
Risk Bin Country |
|
Risk IP City |
|
Risk IP Country |
|
Risk IP Routing Method |
|
Risk IP State |
|
Risk Device Fingerprint |
|
Risk Cookies Enabled |
|
Risk Flash Enabled |
|
Risk Images Enabled |
|
Risk JavaScript Enabled |
|
Risk Proxy IP Address |
|
Risk Proxy IP Address Activities |
|
Risk Proxy IP Address Attributes |
|
Risk Proxy Server Type |
|
Risk True IP Address |
|
Risk True IP Activities |
|
Risk True IP Attributes |
|
Risk True IP Country |
|
Risk True IP City |
|
Exception Processor Response Code |
|
Exception Action |
|
Exception Message |
|
Exception Processor Case ID |
|
Exception Amount Currency |
|
Exception Reason Code |
|
Exception Reason Description |
|
Exception Date |
|
Exception Status |
|
Exception Original Transaction Submission Date |
|
Exception Amount |
|
Exception Financial Status |
|
CYBS Exception ID |
|
Settlement Status |
|
Settlement Source Response Code |
|
Settlement Source Response Message |
|
Settlement Age |
|
Funding Currency Exchange Rate |
|
Funding Currency Exchange Description |
|
Funding Processor Message |
|
Funding Processor Response Code |
|
Funding Status |
|
Funding Fee Amount |
|
Funding Fee Currency |
|
Funding Fee Description |
|
Application |
|
Transaction Type |
|
Original Request ID |
|
Error Category |
|
Batch Effective Date |
CTIRPTAPR - Application Replies
This table will hold data from the <ApplicationReply>
child elements of the <ApplicationReplies>
element. There may be one or more CTIRPTAPR records for a given CTIRPTREQ record.
|
Record CyberSource Report Application Reply Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Key Application Reply Unique ID |
|
Key Application Reply Name |
|
Application Reply RCode |
|
Application Reply RFlag |
|
Application Reply RMsg |
CTIRPTCBD - Chargeback Data
This table will hold data from chargeback reports.
|
Record CyberSource Report Chargeback Data Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Key Chargeback ID |
|
Chargeback Case ID |
|
Chargeback Case Type |
|
Chargeback ARN |
|
Merchant Category Code |
|
Transaction Type |
|
Case Number |
|
Chargeback Amount |
|
Chargeback Currency |
|
Case Time |
|
Chargeback Time |
|
Adjustment Amount |
|
Adjustment Currency |
|
Fee Amount |
|
Fee Currency |
|
Financial Impact |
|
Financial Impact Type |
|
Partial Indicator |
|
Document Indicator |
|
Respond By Date |
|
Chargeback Reason Code |
|
Chargeback Reason Code Description |
|
Resolved To Indicator |
|
Resolution Time |
|
Chargeback Message |
CTIRPTFEI - Fee Info Data
This table will hold data from fee reports. There may be one or more CTIRPTFEI records for a given CTIRPTREQ record.
|
Record CyberSource Report Fee Info Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Key Fee Info Unique ID |
|
Settlement Time |
|
Settlement Time Zone |
|
Settlement Amount |
|
Settlement Currency |
|
Discount Rate |
|
Discount Amount |
|
Discount Currency |
|
Priced Interchange Level |
|
Cleared Interchange Level |
|
Downgrade Reason Code |
|
Source Descriptor |
|
Interchange Rate |
|
Billing Type |
|
Billing Cycle |
|
Total Fee Amount |
|
Total Fee Currency |
|
Per Item Fee Amount |
|
Per Item Fee Currency |
|
Interchange Amount |
|
Interchange Currency |
|
Assessment Amount |
|
Assessment Currency |
CTIRPTICD - Info Code Data
This table will hold data from the <InfoCode>
child elements of the <InfoCodes>
element. There may be one or more CTIRPTICD records for a given CTIRPTREQ record.
|
Record CyberSource Report Info Code Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Info Code Unique ID |
|
Info Code Type |
|
Info Code Value |
CTIRPTLIN - Line Item Data
This table will hold data from the <LineItem>
child elements of the <LineItems>
element. There maybe one or more CTIRPTLIN records for a given CTIRPTREQ record.
|
Record CyberSource Report Line Item Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Key Line Item Number |
|
Fulfillment Type |
|
Quantity |
|
Unit Price |
|
Tax Amount |
|
Merchant Product SKU |
|
Product Name |
|
Product Code |
|
Invoice Number |
CTIRPTPAY - Payment Info Data
This table will hold payment data from <PaymentData>
elements or similar fields.
|
Record CyberSource Report Payment Info Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Key Payment ID |
|
Payment Request ID |
|
Payment Processor |
|
Amount |
|
Currency Code |
|
Total Tax Amount |
|
Authorization Type |
|
Authorization Code |
|
AVS Result |
|
ABS Result Mapped |
|
CV Result |
|
Processor Response Code |
|
Payer Authentication ECI |
|
Payer Authentication AAV_CAVV |
|
Payer Authentication XID |
|
Event Type |
|
Number of Installments |
|
ACH Verification Result |
|
ACH Verification Result Mapped |
|
Grand Total |
|
Balance Amount |
|
Balance Currency Code |
|
Requested Amount |
|
Requested Amount Currency Code |
|
EV Email |
|
EV Email Raw |
|
EV Name |
|
EV Name Raw |
|
EV Phone Number |
|
EV Phone Number Raw |
|
EV Street |
|
EV Street Raw |
|
EV Postal Code |
|
EV Postal Code Raw |
|
Bin Number |
|
Processor Response ID |
|
Processor TID |
|
Network Transaction ID |
|
Boleto BarCode Number |
|
Bank Code |
|
Bank Account Name |
|
Target Amount |
|
Target Currency |
|
Exchange Rate |
|
Exchange Rate Date |
|
DCC Indicator Valid Values:
|
|
Boleto Number |
CTIRPTPRF and CTIRPTRUL - Profiles and Rule Lists
These tables hold profile data and the associated rule lists. There may be one or more CTIRPTPRF records for a given CTIRPTREQ record, and each CTIRPTPRF may have one or more CTIRPTRUL records.
|
Record CyberSource Report Profile List Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Key Profile ID |
|
Profile Name |
|
Profile Mode |
|
Profile Decision |
|
Record CyberSource Report Profile Rule List Record |
|
Key Report Unique ID (corresponds to unique ID in CTIRPT) |
|
Key Request ID (corresponds to record in CTIRPTREQ) |
|
Key Profile ID (corresponds to a record in CTIRPTPRF) |
|
Key Rule ID |
|
Rule Name |
|
Rule Decision |