A transaction record contains information about an unfunded transaction.
Example Transaction Record in Unfunded Transaction Report-China 5 net_amount Sum of transactions awaiting funding in the
currency specified by the currency value and in the range specified by #_days_outstanding.
Amount (19)
6 currency Currency code. Possible values:
CNY (RMB)
USD
Alphanumeric (5) Table 22 Fields in a Summary Record in the Unfunded Transaction Report-China (Continued)
Position Field Name Description Data Type &
Length
transaction_detail,payment_processor,#_days_outstanding,merchant_id, original_transaction_date,request_id,trans_ref_no,merchant_ref_no, amount,amount_currency,transaction_type,event_type,payment_method, bank_name,account_suffix
2,payeasecn,3,chinaShoeMerchant,2008-01-11T10:45:00-08:00,234234234234, 123567,369369369,75.00,CNY,ics_china_payment,Payment Settled,China Bank Transfer,Bank of China Great Wall Credit Card,################
Table 23 Fields in a Transaction Record in the Unfunded Transaction Report-China
Position Field Name Description Data Type &
Length
1 transaction_detail Counter for each line. Alphanumeric (4)
2 payment_processor Payment processor used for the transaction. This value is always payeasecn.
Alphanumeric (40)
3 #_days_outstanding Number of days since the transaction was initiated. Alphanumeric (4)
4 merchant_id CyberSource merchant ID. Alphanumeric (30)
5 original_
transaction_date
Date the original payment transaction was initiated. DateTime (25)
Chapter 6 Working with Reports and Queries
6 request_id Unique identifier generated by CyberSource for the transaction. See information about order tracking in Getting Started with CyberSource Advanced.
Numeric (26)
7 trans_ref_no CyberSource-generated reference or tracking number for the transaction. You can use this value to reconcile your CyberSource reports with your processor reports. This value corresponds to:
<service>_reconciliationID for the Simple Order API.
<service>_trans_ref_no for the SCMP API.
See the information about order tracking in Getting Started with CyberSource Advanced.
Alphanumeric (60)
8 merchant_ref_no Merchant-generated reference or tracking number for the transaction. You can use this value to perform searches in the Business Center. This value corresponds to:
merchantReferenceCode for the Simple Order API.
merchant_ref_number for the SCMP API.
See information about order tracking in Getting Started with CyberSource Advanced.
Alphanumeric (50)
9 amount Amount of the transaction. For refunds, the amount is negative.
Amount (19)
10 amount_currency Currency code used for the transaction. Possible values:
CNY (RMB)
USD
Alphanumeric (5)
11 transaction_type Type of transaction. Possible values:
ics_china_payment: China payment
ics_china_refund: China refund
Alphanumeric (50)
12 event_type Type of event that occurred for the transaction.
Possible values:
Chargeback: The original payment transaction is being disputed by the cardholder or the cardholder’s bank.
Payment Abnormal: The payment has been held up for regulatory or legal reasons.
Payment Declined: The processor refused the payment request.
Alphanumeric (20) Table 23 Fields in a Transaction Record in the Unfunded Transaction Report-China (Continued)
Position Field Name Description Data Type &
Length
Chapter 6 Working with Reports and Queries
Payment Failed: The payment request failed. The reason is not specified.
Payment Funded: The processor submitted a transfer to the merchant's bank account as a result of a settled payment.
Payment Initiated: The payment request was received from the merchant.
Payment Lost: The processor does not acknowledge receiving the payment request.
Payment Pending Proc: The payment is not complete. It is awaiting settlement by the processor.
Payment Settled: The payment was confirmed by the processor and is expected to be funded.
Refund Abnormal: The refund has been delayed for regulatory or legal reasons.
Refund Declined: The processor refused the refund request.
Refund Failed: The refund request failed.
The reason is not specified.
Refund Funded: The processor submitted a transfer to the merchant's bank account as a result of a settled refund.
Refund Pending Cyb: The refund is not complete. It is awaiting transmission by CyberSource.
Refund Pending Proc: The refund is not complete. It is awaiting settlement by the processor.
Refund Settled: The refund was confirmed by the processor and is expected to be funded.
Unknown: The processor does not acknowledge receiving the request.
Table 23 Fields in a Transaction Record in the Unfunded Transaction Report-China (Continued)
Position Field Name Description Data Type &
Length
Chapter 6 Working with Reports and Queries
Sample
This sample report consists of three transactions:
75.00 CNY payment, 3 days outstanding
16.55 USD refund, 5 days outstanding
5.00 CNY refund, 31 days outstanding
These three transactions are included in four ranges in the Summary section:
3 days outstanding
5 to 7 days outstanding
31 to 60 days outstanding
3 to 180 days outstanding
13 payment_method Type of card or bank account used for the transaction. Possible values:
American Express
China Bank Transfer
China Cash On Order
China eWallet
JCB
MasterCard
Visa
Alphanumeric (50)
14 bank_name Bank or payment company involved in the transaction. This value is included in the
transaction record only when the payment method is China Bank Transfer.
Alphanumeric (15)
15 account_suffix Last four characters of the account number. This field will contains the pound (hash) symbol (#).
Alphanumeric (19) Table 23 Fields in a Transaction Record in the Unfunded Transaction Report-China (Continued)
Position Field Name Description Data Type &
Length
Chapter 6 Working with Reports and Queries
UnfundedTransactionReport-China,1,2008-01-14T07:50:00-08:00, chinaShoeMerchant,,,,,,,,,,,
summary,,#_days_outstanding,count,net_amount,currency,,,,,,,,, ,,3,1,75.00,CNY,,,,,,,,,
,,4,0,0.00,CNY,,,,,,,,, ,,5 to 7,0,0.00,CNY,,,,,,,,, ,,8 to 14,0,0.00,CNY,,,,,,,,, ,,15 to 30,0,0.00,CNY,,,,,,,,, ,,31 to 60,1,(5.00),CNY,,,,,,,,, ,,61 to 90,0,0.00,CNY,,,,,,,,, ,,91 to 180,0,0.00,CNY,,,,,,,,, ,,3 to 180,2,70.00,CNY,,,,,,,,, ,,3,0,0.00,USD,,,,,,,,,
,,4,0,0.00,USD,,,,,,,,,
,,5 to 7,1,(16.55),USD,,,,,,,,, ,,8 to 14,0,0.00,USD,,,,,,,,, ,,15 to 30,0,0.00,USD,,,,,,,,, ,,31 to 60,0,0.00,USD,,,,,,,,, ,,61 to 90,0,0.00,USD,,,,,,,,, ,,91 to 180,0,0.00,USD,,,,,,,,, ,,3 to 180,1,16.55,USD,,,,,,,,, ,,,,,,,,,,,,,
,,,,,,,,,,,,,
transaction_detail,payment_processor,#_days_outstanding,merchant_id, original_transaction_date,request_id,trans_ref_no,merchant_ref_no, amount,amount_currency,transaction_type,event_type,payment_method, bank_name,account_suffix
1,payeasecn,3,chinaShoeMerchant,2008-01-11T10:45:00-08:00,234234234234, 123567,369369369,75.00,CNY,ics_china_payment,Payment Settled,China Bank Transfer,Bank of China Great Wall Credit Card,################
2,payeasecn,5,chinaShoeMerchant,2008-01-09T13:30:00-08:00,345345345345, 345678,369369369,16.55,USD,ics_china_refund,Refund Pending Proc,Visa,
################
3,payeasecn,31,chinaShoeMerchant,2007-12-14T09:22:00-08:00,456456456456,
123789,369369369,5.00,CNY,ics_china_refund,Refund Abnormal,eWallet,
################
Chapter 6 Working with Reports and Queries
Funded Transaction Report-China
This report lists PayEase China Processing transactions that have been funded. A transaction is included in the report the day after it is funded. To view this report, you must subscribe to it on the Business Center.
Records in the Report
"First Header Record"
"Second Header Record"
"Summary Record"
"Third Header Record"
"Transaction Record"
First Header Record
The first header record provides information about the report.
Example First Header Record in Funded Transaction Report-China
P
Second Header Record
The second header record provides the field names for the summary section of the report.
The content for each field is the field name. The data type and length for each field is alphanumeric (100).
Example Second Header Record in Funded Transaction Report-China FundedTransactionReport-China,1,2008-01-14T07:50:00-08:00,chinaShoeMerchant
Table 24 Fields in the First Header Record in the Funded Transaction Report-China
Position Field Name Description Data Type
& Length 1 report_name Name of the report. This value is always
FundedTransactionReport-China.
String (100)
2 version_number Version number of the report. Numeric (10)
3 report_date Date the report was generated. Date (10)
4 merchant_id CyberSource merchant ID. String (30)
summary,payment_method,transaction_type,count,net_amount,currency
Chapter 6 Working with Reports and Queries
Summary Record
A summary record contains a summary of the transaction information for each payment method that is included in the in the <TransactionDetail> section:
China Bank Transfer
China eWallet
American Express
JCB
MasterCard
Visa
Total for all payment methods
A set of summary records, one for CNY and one for USD, occurs for each payment method that is included in the detail section of the report.
Example Summary Record in Funded Transaction Report-China
Example All Summary Records in Funded Transaction Report-China ,China Bank Transfer,ics_china_payment,31,3086.64,CNY
,China Bank Transfer,ics_china_payment,1,75.00,CNY ,China Bank Transfer,ics_china_refund,1,(5.00),CNY ,China eWallet,ics_china_payment,1,55.00,CNY ,China eWallet,ics_china_refund,0,0.00,CNY ,all,all,3,125.00,CNY
,Visa,ics_china_payment,1,13.00,USD ,Visa,ics_china_refund,0,0.00,USD ,all,all,1,13.00,USD
Table 25 Fields in a Summary Record in the Funded Transaction Report-China
Position Field Name Description Data Type &
Length
1 (none) (empty) (none)
2 payment_method Payment method. Possible values:
American Express
China Bank Transfer
China Cash On Order
China eWallet
JCB
MasterCard
Visa
Alphanumeric (50)
Chapter 6 Working with Reports and Queries
Third Header Record
The third header record provides the field names for the transaction section of the report.
The content for each field is the field name. The data type and length is alphanumeric (100).
Example Third Header Record in Funded Transaction Report-China
Transaction Record
A transaction record contains information about a funded transaction.
3 transaction_type Type of transaction. Possible values:
ics_china_payment: China payment
ics_china_refund: China refund
Alphanumeric (50)
4 count Number of transactions that have been funded for the transaction type specified by
transaction_type in the currency specified by currency for the payment method specified by payment_method.
Alphanumeric (10)
5 net_amount Sum of transactions that have been funded for the transaction type specified by transaction_
type in the currency specified by currency for the payment method specified by payment_
method.
Amount (19)
6 currency Currency code. Possible values:
CNY (RMB)
USD
Alphanumeric (5) Table 25 Fields in a Summary Record in the Funded Transaction Report-China (Continued)
Position Field Name Description Data Type &
Length
transaction_detail,payment_processor,merchant_id,original_transaction_date, request_id,trans_ref_no,merchant_ref_no,amount,amount_currency,
transaction_type,event_date,event_type,payment_method,bank_name, account_suffix
Chapter 6 Working with Reports and Queries
Example Transaction Record in Funded Transaction Report-China
2,payeasecn,chinaShoeMerchant,2008-01-11T08:00:00-08:00,234234234234, 123567,369369369,75.00,CNY,ics_china_payment,2008-01-19T08:00:00-08:00, Payment Funded,China Bank Transfer,Bank of China Great Wall Credit Card,
################
Table 26 Fields in a Transaction Record in the Funded Transaction Report-China
Position Field Name Description Data Type &
Length
1 transaction_detail Counter for each line. Alphanumeric (4)
2 payment_processor Payment processor used for the transaction. This value is always payeasecn.
Alphanumeric (40)
3 merchant_id CyberSource merchant ID. Alphanumeric (30)
4 original_transaction_
date
Date the original payment transaction was initiated.
DateTime (25)
5 request_id Unique identifier generated by CyberSource for the transaction. See information about order tracking in Getting Started with CyberSource Advanced.
Numeric (26)
6 trans_ref_no CyberSource-generated reference or tracking number for the transaction. You can use this value to reconcile your CyberSource reports with your processor reports. This value corresponds to:
<service>_reconciliationID for the Simple Order API.
<service>_trans_ref_no for the SCMP API.
See information about order tracking in Getting Started with CyberSource Advanced.
Alphanumeric (60)
7 merchant_ref_no Merchant-generated reference or tracking number for the transaction. You can use this value to perform searches in the Business Center. This value corresponds to:
merchantReferenceCode for the Simple Order API.
merchant_ref_number for the SCMP API.
See information about order tracking in Getting Started with CyberSource Advanced.
Alphanumeric (50)
8 amount Amount of the transaction. For refunds, the amount is negative.
Amount (19)
Chapter 6 Working with Reports and Queries
9 amount_currency Currency code used for the transaction. Possible values:
CNY (RMB)
USD
Alphanumeric (5)
10 transaction_type Type of transaction. Possible values:
ics_china_payment: China payment
ics_china_refund: China refund
Alphanumeric (50)
11 event_date Date the event occurred. This attribute is empty for some event types.
DateTime (25)
12 event_type Type of event that occurred for the transaction.
Possible values:
Chargeback: The original payment transaction is being disputed by the cardholder or the cardholder’s bank.
Payment Abnormal: The payment has been delayed for regulatory or legal reasons.
Payment Declined: The processor has refused the payment request.
Alphanumeric (20)
Payment Failed: The payment request failed. The reason is not specified.
Payment Funded: The processor submitted a transfer to the merchant's bank account as a result of a settled payment.
Payment Initiated: The payment request was received from the merchant.
Payment Lost: The processor does not acknowledge receiving the payment request.
Payment Pending Proc: The payment is not complete. It is awaiting settlement by the processor.
Payment Settled: The payment was confirmed by the processor and is expected to be funded.
Refund Abnormal: The refund has been delayed for regulatory or legal reasons.
Refund Declined: The processor refused the refund request.
Refund Failed: The refund request failed. The reason is not specified.
Table 26 Fields in a Transaction Record in the Funded Transaction Report-China (Continued)
Position Field Name Description Data Type &
Length
Chapter 6 Working with Reports and Queries
Sample
This sample report consists of four transactions:
75.00 CNY payment, China Bank Transfer
5.00 CNY refund, China Bank Transfer
13.00 USD payment, Visa
55.00 CNY payment, China eWallet
Refund Funded: The processor submitted a transfer to the merchant's bank account as a result of a settled refund.
Refund Pending Cyb: The refund is not complete. It is awaiting transmission by CyberSource.
Refund Pending Proc: The refund is not complete. It is awaiting settlement by the processor.
Refund Settled: The refund was confirmed by the processor and is expected to be funded.
Unknown: The processor does not acknowledge receiving the request.
13 payment_method Type of card or bank account used for the transaction. Possible values:
American Express
China Bank Transfer
China Cash On Order
China eWallet
JCB
MasterCard
Visa
Alphanumeric (50)
14 bank_name Bank or payment company involved in the transaction. This value is included in the transaction record only when the payment method is China Bank Transfer.
Alphanumeric (15)
15 account_suffix Last four characters of the account number. This field will contains the pound (hash) symbol (#).
Alphanumeric (19) Table 26 Fields in a Transaction Record in the Funded Transaction Report-China (Continued)
Position Field Name Description Data Type &
Length
Chapter 6 Working with Reports and Queries
These four transactions are included in five summary records:
China Bank Transfer, CNY
China eWallet, CNY
All payment methods, CNY
Visa, USD
All payment methods, USD
Query for a Single Transaction
FundedTransactionReport-China,1,2008-01-14T07:50:00-08:00, chinaShoeMerchant
summary,payment_method,transaction_type,count,net_amount,currency ,China Bank Transfer,ics_china_payment,1,75.00,CNY
,China Bank Transfer,ics_china_refund,1,(5.00),CNY ,China eWallet,ics_china_payment,1,55.00,CNY ,China eWallet,ics_china_refund,0,0.00,CNY ,all,all,3,125.00,CNY
,Visa,ics_china_payment,1,13.00,USD ,Visa,ics_china_refund,0,0.00,USD ,all,all,1,13.00,USD
transaction_detail,payment_processor,merchant_id,original_transaction_
date,request_id,trans_ref_no,merchant_ref_no,amount,amount_currency, transaction_type,event_date,event_type,payment_method,bank_name, account_suffix
1,payeasecn,chinaShoeMerchant,2008-01-05T08:10:00-08:00,8976538745, 123456,2884554,75.00,CNY,ics_china_payment,2008-01-13T11:09:00-08:00, Payment Funded,China Bank Transfer,Bank of China Great Wall,
################
2,payeasecn,chinaShoeMerchant,2008-01-05T10:10:00-08:00,899908745, 67823456,2886697,5.00,CNY,ics_china_refund,2008-01-13T15:22:00-08:00, Payment Funded,China Bank Transfer,Bank of China Great Wall,
################
3,payeasecn,chinaShoeMerchant,2008-01-13T22:46:00-08:00,795538745, 2238456,2884566,55.00,CNY,ics_china_payment,2008-01-13T22:46:00-08:00, Chargeback,China eWallet,################
4,payeasecn,chinaShoeMerchant,2008-01-04T12:32:00-08:00,8976538987, 123678,2884554,13.00,USD,ics_china_payment,2008-01-13T22:45:00-08:00, Payment Funded,Visa,################
Chapter 6 Working with Reports and Queries
Version 1.2 of the Single Transaction Query is supported for PayEase China Processing. It is described in the Reporting Developer’s Guide. The query indicates the status of the PayEase China Processing transaction within the transaction lifetime. The query results include:
Summary information about your PayEase China Processing transactions
Detailed information about Decision Manager
Example Query for a Single Transaction
<form action="https://ebc.cybersource.com/ebc/Query" method="POST">
<table>
<tr>
<td>merchantID</td>
<td><input type="text" name="merchantID" value="nwtest1"></td>
</tr>
<tr>
<td>type</td>
<td><input type="text" name="type" value="transaction"></td>
</tr>
<tr>
<td>subtype</td>
<td><input type="text" name="subtype" value="transactionDetail"></td>
</tr>
<tr>
<td>requestID</td>
<td><input type="text" name="requestID" value="1999370597170167905049"></td>
</tr>
<tr>
<td></td>
<td><input type="reset">
<input type="submit" value="Submit"></input></td>
</tr>
</table>
</form>
Chapter 6 Working with Reports and Queries
Example Query Response
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE Report (View Source for full doctype...)>
<Report xmlns="https://ebctest.cybersource.com/ebctest/reports/dtd/tdr_
<Address1>1295 Charleston Road</Address1>
<Address2>Building 1</Address2>
<Address1>1295 Charleston Road</Address1>
<Address2>Building 1</Address2>
<CardType>China Bank Transfer</CardType>
</Card>
</PaymentMethod>
Chapter 6 Working with Reports and Queries
<LineItems>
<LineItem Number="0">
<FulfillmentType />
<Quantity>1</Quantity>
<UnitPrice>1.20</UnitPrice>
<TaxAmount>0.00</TaxAmount>
<ProductCode>default</ProductCode>
</LineItem>
</LineItems>
<ApplicationReplies>
<ApplicationReply Name="ics_china_payment">
<RCode>1</RCode>
<RFlag>SOK</RFlag>
<RMsg>china payment service was successful</RMsg>
</ApplicationReply>
</ApplicationReplies>
<PaymentData>
<PaymentProcessor>payeasecn</PaymentProcessor>
<Amount>1.20</Amount>
<CurrencyCode>CNY</CurrencyCode>
<TotalTaxAmount>0.00</TotalTaxAmount>
<EventType>Payment Settled</EventType>
</PaymentData>
</Request>
</Requests>
</Report>
CHAPTER