Migrating to Business Center Reports

In August 2017, reports migrated to the Business Center. User permissions are the same. Your existing report subscriptions have been moved and the report names are appended with _portfolio. For example, if you have a report named TransactionRequests, the name in the Business Center will be TransactionRequests_portfolio. The fields, field order (for CSV), and frequency did not change during this migration.

You can use the Business Center to create new reports, edit reports that were migrated, and download reports. For more information on using Business Center Reports, see Business Center Reporting Developer Guide.

What is Changing?

You will see some minor changes to reports after the migration. These changes include:

■	Renamed/removed fields

■	Changes to the XML report header

■	Changes to the CSV report header

■	Changes to the XML report structure

■	Changes to the XML report request object

Field Changes

Some fields in UMP have been renamed or removed.

Table 15

Field Name Changes

UMP Field Name	Business Center Field Name
ShipTo_FirstNameCity	ShipTo_City
ShipTo_FirstNameState	ShipTo_State
ShipTo_FirstNameZip	ShipTo_Zip
ShipTo_FirstNameCountry	ShipTo_Country
ShipTo_FirstNameLastName	ShipTo_LastName
ErrorCategory	ExceptionCategory
ErrorMessage	ExceptionMessage
ReasonCode	ExceptionReasonCode
Exception_ProcessorResponseCode	ProcessorResponseCode

 

Table 16

Removed Fields

UMP Field Name

SettlementProcessor

Processor#

XML Report Header

The XML report header now contains the “type” attribute that defines the report type that is being downloaded.

Example

Old CSV Report Header

<?xml version=”1.0” encoding=”UTF-8”?> <!DOCTYPE Report SYSTEM “https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_1.dtd”> <Report ReportEndDate=”2017-04-08T23:59:59Z” ReportStartDate=”2017-04-08T00:00:00Z” OrganizationID=”orgid” xmlns=”https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_1.dtd” Version=”1.0” Name=”OldTransactionRequestJuly12th_XML”>

Example

New CSV Report Header

<?xml version=”1.0” encoding=”UTF-8”?> <!DOCTYPE Report SYSTEM “https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_1.dtd”> <Report ReportEndDate=”2017-04-08T23:59:59Z” ReportStartDate=”2017-04-08T00:00:00Z” OrganizationID=”orgid” xmlns=”https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_1.dtd” Version=”1.0” Type=”TransactionRequestReport” Name=”OldTransactionRequestJuly12th_XML”>

CSV Report Header

The CSV report header now contains the “type” field that defines the report type that is being downloaded.

Example

Old CSV Report Header

orgID TransactionRequestReportJuly12th_CSV 1.6 2017-04-08T00:00:00Z to 2017-04-08T23:59:59Z

Example

New CSV Report Header

orgID TransactionRequestReportJuly12th_CSV TransactionRequestReport 1.6 2017-04-08T00:00:00Z to 2017-04-08T23:59:59Z

XML Report Structure

The XML report structure has been changed to reflect the migration to Business Center reporting. <PaymentInfo> has been added to <PaymentData>.

Example

Old XML Structure

<PaymentData>    <AuthorizationType>0</AuthorizationType>    <AuthorizationCode>831000</AuthorizationCode>    <Amount>1.00</Amount>    <PaymentRequestID>4916104037596904201029</PaymentRequestID>    <TransactionReferenceNumber>4916104037596904201029</TransactionReferenceNumber> </PaymentData>

Example

New XML Structure

<PaymentData>    <PaymentInfo>       <AuthorizationType>0</AuthorizationType>       <AuthorizationCode>831000</AuthorizationCode>       <Amount>1.00</Amount>       <PaymentRequestID>4916104037596904201029</PaymentRequestID>       <TransactionReferenceNumber>4916104037596904201029</TransactionReferenceNumber>    </PaymentInfo> </PaymentData>

XML Request Object

The XML Request Object has been changed to reflect the migration to Business Center reporting. The following fields have moved from the Request object to the PaymentInfo object:

■	TransactionReferenceNumber

■	eCommerceIndicator

The following fields were added to the Request object:

■	PartnerOriginalTransactionID

■	TerminalSerialNumber

■	PartnerSDKVersion

These fields will only be present if they return values.