Elements in the Report - China Payment Processing

Elements:

 "<Report>"

 "<Summary>"

 "<Range>"

 "<TransactionDetail>"

 "<Transaction>"

DateTime YYYY-MM-DDTHH:MM:SS[+ | -]HH:MM where:

 YYYY is the four-digit year

 MM is the two-digit month

 DD is the two-digit day

 T separates the date information from the time information

 HH is the two-digit hours

 MM is the two-digit minutes

 SS is the two-digit seconds

 [+ | -]HH:MM is the time zone’s offset from GMT (Greenwich Mean Time)

The hyphens are included in a DateTime value.

Numeric String containing numbers.

Table 5 Data Types for XML Reports (Continued) Data Type Description

Chapter 6 Working with Reports and Queries

<Report>

The <Report> element is the root of the report.

Syntax

<?xml version="1.0" encoding="utf-8" ?>

(Summary)

(TransactionDetail)?

</Report>

Table 6 Attributes of <Report> in the Unfunded Transaction Report-China

Attribute Name Description Data Type & Length

Name Name of the report. This value is always UnfundedTransactionReport-China.

Alphanumeric (100)

Version Version number of the report. Numeric (10) xmlns XML namespace for the report. This value is

always https://ebc.cybersource.com/

ebc/reports/dtd/utr-china.dtd.

Alphanumeric (100)

MerchantID CyberSource merchant ID. Alphanumeric (30) ReportDate Date the report was generated. DateTime (25)

Table 7 Child Elements of <Report>

Element Name Description

<Summary> Summary of the transaction information for each range. See

"<Summary>," page 42.

<TransactionDetail> Information about all of the unfunded transactions that have occurred during the previous 3 to 180 days. See "<TransactionDetail>,"

page 45.

Chapter 6 Working with Reports and Queries

Example <Report> Element

<Summary>

The <Summary> element contains a summary of the transaction information for each range:

 3 days outstanding

 4 days outstanding

 5 to 7 days outstanding

 8 to 14 days outstanding

 15 to 30 days outstanding

 31 to 60 days outstanding

 61 to 90 days outstanding

 91 to 180 days outstanding

 3 to 180 days outstanding

Syntax

<?xml version="1.0" encoding="utf-8" ?>

<Report Name="UnfundedTransactionReport-China"

Version="1.0"

xmlns=https://ebc.cybersource.com/ebc/reports/dtd/utr-china.dtd MerchantID="chinaShoeMerchant"

ReportDate="2008-01-14T07:50:00-08:00">

...

</Summary>

...

</TransactionDetail>

</Report>

(Range)*

</Summary>

Table 8 Child Element of <Summary> in the Unfunded Transaction Report-China Element Name Description

<Range> Summary of the transaction information for one range. See

"<Range>," page 44.

Chapter 6 Working with Reports and Queries

Example <Summary> Element

Example Entire <Summary> Element

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

Chapter 6 Working with Reports and Queries

<Range>

The <Range> element contains a summary of the transaction information for one currency in one range.

Syntax

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

</Range>

</Summary>

(Count) (NetAmount)

</Range>

Chapter 6 Working with Reports and Queries

Example <Range> Element

<TransactionDetail>

The <TransactionDetail> element contains information about all of the unfunded transactions that occurred during the previous 3 to 180 days.

Syntax

Table 9 Attributes of <Range> in the Unfunded Transaction Report-China

Attribute Name Description Data Type &

Length DaysOutstandingStart Start of the range of the number of days

outstanding. For example, for the range of 5 to 7 days outstanding, the start of the range is 5.

Alphanumeric (4)

DaysOutstandingEnd End of the range of the number of days outstanding. For example, for the range of 5 to 7 days outstanding, the end of the range is 7.

Alphanumeric (4)

CurrencyCode Currency code. Possible values:

 CNY (RMB)

 USD

Alphanumeric (5)

Table 10 Child Elements of <Range> in the Unfunded Transaction Report-China Element Name Description

Count Number of transactions that await funding in the currency specified by CurrencyCode and in the range specified by

DaysOutstandingStart and DaysOutstandingEnd.

NetAmount Sum of transactions that await funding in the currency specified by CurrencyCode and in the range specified by

DaysOutstandingStart and DaysOutstandingEnd.

</Range>

(Transaction)*

</TransactionDetail>

Chapter 6 Working with Reports and Queries

Table 11 Child Element of <TransactionDetail> in the Unfunded Transaction Report-China

Element Name Description

<Transaction> Information about an unfunded transaction. See "<Transaction>,"

page 47.

Chapter 6 Working with Reports and Queries

Example <TransactionDetail> Element

<Transaction>

The <Transaction> element contains information about an unfunded transaction.

Syntax

...

</Transaction>

</TransactionDetail>

<Transaction Processor=CDATA DaysOutstanding=CDATA MerchantID=CDATA

OriginalTransactionDate=CDATA RequestID=CDATA

TransactionReferenceNumber=CDATA MerchantReferenceNumber=CDATA Amount=CDATA

CurrencyCode=CDATA TransactionType=CDATA EventType=CDATA PaymentMethod=CDATA BankName=CDATA AccountSuffix=CDATA>

</Transaction>

Table 12 Attributes of <Transaction> in the Unfunded Transaction Report-China

Attribute Name Description Data Type &

Length Processor Payment processor used for the

transaction. This value is always PayEase.

Alphanumeric (40)

DaysOutstanding Number of days since the transaction was initiated.

Alphanumeric (4)

MerchantID CyberSource merchant ID. Alphanumeric (30) OriginalTransactionDate Date the original transaction was initiated. DateTime (25) RequestID Unique identifier generated by

CyberSource for the transaction. See the information about order tracking in Getting Started with CyberSource Advanced.

Numeric (26)

Chapter 6 Working with Reports and Queries

TransactionReference Number

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)

MerchantReference Number

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 the information about order tracking in Getting Started with CyberSource

Advanced.

Alphanumeric (50)

Amount Amount of the transaction. For refunds, the amount is negative.

Amount (19)

CurrencyCode Currency code used for the transaction.

Possible values:

 CNY (RMB)

 USD

Alphanumeric (5)

TransactionType Type of transaction. Possible values:

 ics_china_payment: China payment

 ics_china_refund: China refund

Alphanumeric (50) Table 12 Attributes of <Transaction> in the Unfunded Transaction Report-China

(Continued)

Attribute Name Description Data Type &

Length

Chapter 6 Working with Reports and Queries

EventType 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 has refused the payment request.

Alphanumeric (20)

 Payment Failed: The payment request failed. The reason is not specified.

 Payment Funded: The processor has 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 has not been completed. It is awaiting settlement by the processor.

 Payment Settled: The payment has been confirmed by the processor and is expected to be funded.

 Refund Abnormal: The refund has been held up for regulatory or legal reasons.

 Refund Declined: The processor has refused the refund request.

 Refund Failed: The refund request failed. The reason is not specified.

Table 12 Attributes of <Transaction> in the Unfunded Transaction Report-China (Continued)

Attribute Name Description Data Type &

Length

Chapter 6 Working with Reports and Queries

 Refund Funded: The processor has submitted a transfer to the merchant's bank account as a result of a settled refund.

 Refund Pending Cyb: The refund has not been completed. It is awaiting transmission by CyberSource.

 Refund Pending Proc: The refund has not been completed. It is awaiting settlement by the processor.

 Refund Settled: The refund has been confirmed by the processor and is expected to be funded.

 Unknown: The processor does not acknowledge receiving the request.

PaymentMethod 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)

BankName Bank or payment company involved in the transaction. This value is included in the

<Transaction> element only when the payment method is China Bank Transfer.

Alphanumeric (15)

AccountSuffix Last four characters of the account number.

This field will contain the pound or hash (#)symbol.

Alphanumeric (19) Table 12 Attributes of <Transaction> in the Unfunded Transaction Report-China

(Continued)

Attribute Name Description Data Type &

Length

Chapter 6 Working with Reports and Queries

Example <Transaction> Element

DTD

<Transaction Processor="PayEase"

DaysOutstanding="3"

PaymentMethod="China Bank Transfer"

BankName="Bank of China Great Wall Credit Card"

AccountSuffix="################">

</Transaction>

<!ELEMENT Report (Summary, TransactionDetail)

<!ATTLIST Report Name CDATA #REQUIRED Version NMTOKEN #REQUIRED xmlns CDATA #REQUIRED MerchantID CDATA #REQUIRED ReportDate CDATA #REQUIRED>

<!ELEMENT Summary (Range*)>

<!ELEMENT Range (Count, NetAmount)>

<!ATTLIST Range DaysOutStandingStart CDATA #REQUIRED DaysOutStandingEnd CDATA #REQUIRED CurrencyCode CDATA #REQUIRED>

<!ELEMENT Count (#PCDATA)>

<!ELEMENT NetAmount (#PCDATA)>

<!ELEMENT TransactionDetail (Transaction*)>

<!ELEMENT Transaction EMPTY>

<!ATTLIST Transaction Processor CDATA #REQUIRED DaysOutstanding CDATA #REQUIRED MerchantID CDATA #REQUIRED

OriginalTransactionDate CDATA #REQUIRED RequestID CDATA #REQUIRED

TransactionReferenceNumber CDATA #REQUIRED MerchantReferenceNumber CDATA #REQUIRED Amount CDATA #REQUIRED

CurrencyCode CDATA #REQUIRED TransactionType CDATA #REQUIRED EventType CDATA #REQUIRED PaymentMethod CDATA #REQUIRED BankName CDATA #REQUIRED AccountSuffix CDATA #REQUIRED>

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 80 days outstanding

<?xml version="1.0" encoding="utf-8" ?>

<!DOCTYPE Report SYSTEM

"https://ebc.cybersource.com/ebc/reports/dtd/utr-china.dtd">

<Report Name="UnfundedTransactionReport-China"

Version="1.0"

Chapter 6 Working with Reports and Queries

PaymentMethod="China Bank Transfer"

BankName="Bank of China Great Wall Credit Card"

AccountSuffix="################">

Chapter 6 Working with Reports and Queries

In document China Payment Processing (Page 40-55)