Home > Reports Reference > Differences in XML Reports

Differences in XML Reports

Some of the new reports contain different headers, date formats, and element names. Below are examples of the differences between the old and new XML reports. New elements and attributes are highlighted in the examples.

Conversion Detail Report

Order Detail Report

Example 20Order Detail Report

 

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

 <!DOCTYPE Report SYSTEM "https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd">

<Report Name="OrderDetailReport_Daily_Classic" Type="TransactionRequestReport" Version="1.10" xmlns="https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd" OrganizationID="orgID" ReportStartDate="2018-12-10T05:00:00Z" ReportEndDate="2018-12-11T05:00:00Z">

 <Requests>

  <Request MerchantID="merchantID" RequestID="xx443875249650xx" RequestDate="2018-12-10T12:11:15Z" MerchantReferenceNumber="xx6082xx" Source="Secure Acceptance Web/Mobile" User="" Comments="">

   <BillTo>

     <CustomerID/>

     <FirstName>John</FirstName>

     <LastName>Doe</LastName>

     <Address1>23 Main Ave</Address1>

     <Address2/>

     <City>Toronto</City>

     <State>ON</State>

     <Zip>m4n1n7</Zip>

     <Country>CA</Country>

     <CompanyName/>

     <Email>johndoe@gmail.com</Email>

     <Title/>

     <Phone/>

     <IPAddress/>

   </BillTo>

   <ShipTo>

     <FirstName/>

     <LastName/>

     <Address1/>

     <Address2/>

     <City/>

     <State/>

     <Zip/>

     <Country/>

     <Phone/>

   </ShipTo>

   <PaymentMethod>

     <Card>

       <CardType>MasterCard</CardType>

       <ExpirationMonth>03</ExpirationMonth>

       <ExpirationYear>2024</ExpirationYear>

       <AccountSuffix>5876</AccountSuffix>

     </Card>

   </PaymentMethod>

   <LineItems>

     <LineItem>

       <FulfillmentType/>

       <Quantity>1</Quantity>

       <UnitPrice>25.00</UnitPrice>

       <TaxAmount>0.00</TaxAmount>

       <MerchantProductSKU/>

       <ProductName/>

       <ProductCode>default</ProductCode>

     </LineItem>

   </LineItems>

   <ApplicationReplies>

     <ApplicationReply Name="ics_auth">

       <RCode>1</RCode>

       <RFlag>SOK</RFlag>

       <ReasonCode>100</ReasonCode>

       <RMsg>Request was processed successfully.</RMsg>

     </ApplicationReply>

     <ApplicationReply Name="ics_bill">

       <RCode>1</RCode>

       <RFlag>SOK</RFlag>

       <ReasonCode>100</ReasonCode>

       <RMsg>Request was processed successfully.</RMsg>

     </ApplicationReply>

   </ApplicationReplies>

   <PaymentData>

     <PaymentInfo>

       <TransactionReferenceNumber>xx39391xx</TransactionReferenceNumber>

       <eCommerceIndicator>7</eCommerceIndicator>

       <Amount>25.00</Amount>

       <AVSResult>Y</AVSResult>

       <AuthorizationCode>03491S</AuthorizationCode>

       <CVResult>M</CVResult>

       <AuthFactorCode/>

     </PaymentInfo>

     <PaymentInfo>

       <TransactionReferenceNumber>xx117744QK5TOOJXXxx</TransactionReferenceNumber>

       <eCommerceIndicator>7</eCommerceIndicator>

       <Amount>25.00</Amount>

       <AVSResult>Y</AVSResult>

       <AuthorizationCode>xx491S</AuthorizationCode>

       <CVResult>M</CVResult>

       <AuthFactorCode/>

     </PaymentInfo>

   </PaymentData>

   <MerchantDefinedData>

     <field1>Field 1</field1>

     <field2>Field 2</field2>

     <field3/>

     <field4>Field 4</field4>

   </MerchantDefinedData>

  </Request>

 </Requests>

</Report>

 

Payment Batch Detail Report

Example 23Payment Batch Detail Report

 

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

 <!DOCTYPE Report SYSTEM "https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd">

<Report Name="PaymentBatchtDetailReport_Daily_Classic" Type="PaymentBatchDetail" Version="1.10" xmlns="https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd" OrganizationID="orgID" ReportStartDate="2018-12-10T08:00:00Z" ReportEndDate="2018-12-11T08:00:00Z">

 <Requests>

  <Request MerchantID="merchantID" RequestID="xx262165703040xx" MerchantReferenceNumber="xxx93799xxx" RequestDate="2018-12-10T06:21:22Z">

     <BillTo>

      <CustomerID/>

     </BillTo>

     <PaymentMethod>

      <TypeDescription>Visa</TypeDescription>

     </PaymentMethod>

     <LineItems>

       <LineItem Number="0">

        <InvoiceNumber/>

       </LineItem>

     </LineItems>

     <ApplicationReplies>

      <ApplicationReply Name="ics_auth"/>

      <ApplicationReply Name="ics_bill"/>

     </ApplicationReplies>

     <PaymentData>

      <PaymentInfo>

       <TransactionReferenceNumber>xxx26216570304xxx</TransactionReferenceNumber>

       <Amount>100.00</Amount>

       <SolutionType/>

       <ProcessorTID/>

       <NetworkTransactionID/>

       <CurrencyCode>USD</CurrencyCode>

       <CurrencyCode/>

      </PaymentInfo>

      <PaymentInfo>

       <TransactionReferenceNumber>xxx6216570304xxx</TransactionReferenceNumber>

       <Amount>100.00</Amount>

       <SolutionType/>

       <ProcessorTID/>

       <NetworkTransactionID>xxx44228821xxx</NetworkTransactionID>

       <CurrencyCode>USD</CurrencyCode>

       <CurrencyCode/>

      </PaymentInfo>

     </PaymentData>

     <BATCH>

      <BatchID>xx60279xx</BatchID>

      <BatchDate>2018-12-11T03:49:00Z</BatchDate>

      <Status>BATCHED</Status>

     </BATCH>

  </Request>

 </Requests>

</Report>

 

Payment Event Detail Report

Example 26Payment Event Detail Report

 

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

 <!DOCTYPE Report SYSTEM "https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd">

<Report Name="PaymentEventDetailReport_Daily_Classic" Type="ProcessorEventsDetail" Version="1.10" xmlns="https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd" OrganizationID="orgID" ReportStartDate="2018-12-10T08:00:00Z" ReportEndDate="2018-12-11T08:00:00Z">

 <Requests>

  <Request RequestID="xxx5134031684790xxx" MerchantID="merchantID" MerchantReferenceNumber="xxx52_2xxx" RequestDate="2018-11-28T14:25:34Z">

    <BillTo>

     <CustomerID/>

    </BillTo>

    <PaymentMethod>

     <TypeDescription>Checking</TypeDescription>

    </PaymentMethod>

    <ApplicationReplies>

     <ApplicationReply Name="ics_ecp_debit"/>

    </ApplicationReplies>

    <PaymentData>

     <PaymentInfo>

      <TransactionReferenceNumber>xxxHV1VJOKxxx</TransactionReferenceNumber>

      <ProcessorTransactionID>xxx9831xxx</ProcessorTransactionID>

     </PaymentInfo>

    </PaymentData>

    <Events>

     <Event>

      <Event>FINAL NSF</Event>

      <EventDate>2018-11-29T16:00:00Z</EventDate>

      <CurrencyCode>USD</CurrencyCode>

      <Amount>2484.5</Amount>

      <ConsumerCurrencyCode>USD</ConsumerCurrencyCode>

      <ConsumerAmount>2484.5</ConsumerAmount>

      <FeeCurrencyCode/>

      <FeeAmount/>

      <ProcessorMessage>R01: Insufficient Funds</ProcessorMessage>

      <DebitIndicator>26</DebitIndicator>

     </Event>

    </Events>

  </Request>

 </Requests>

</Report>

 

Payment Submission Detail Report

Example 29Payment Submission Detail Report

 

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

 <!DOCTYPE Report SYSTEM "https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd">

<Report Name="PaymentSubmissionDetailReport_Daily_Classic" Type="PaymentBatchDetail" Version="1.10" xmlns="https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd" OrganizationID="orgID" ReportStartDate="2018-12-13T08:00:00Z" ReportEndDate="2018-12-14T08:00:00Z">

 <Requests>

  <Request MerchantID="merchantID" RequestID="xxx783033586435203xxx" MerchantReferenceNumber="xxx456475919.154467xxx" RequestDate="2018-12-13T05:18:23Z">

    <BillTo>

     <CustomerID/>

    </BillTo>

    <PaymentMethod>

     <TypeDescription>Visa</TypeDescription>

     <OverridePaymentMethod/>

    </PaymentMethod>

    <ApplicationReplies>

     <ApplicationReply Name="ics_auth"/>

     <ApplicationReply Name="ics_bill"/>

    </ApplicationReplies>

    <PaymentData>

     <PaymentInfo>

      <TransactionReferenceNumber>xxxOQPKU7xxx</TransactionReferenceNumber>

      <Amount>300.00</Amount>

      <PaymentProcessor>fdiaus</PaymentProcessor>

      <CardCategory/>

      <CardCategoryCode/>

      <TargetAmount/>

      <TargetCurrency/>

      <ExchangeRate/>

      <ExchangeRateDate/>

      <DCCIndicator/>

      <AuthorizationCode>xx5706</AuthorizationCode>

      <ProcessorTID/>

      <NetworkTransactionID/>

      <CurrencyCode>AUD</CurrencyCode>

      <NumberOfInstallments/>

      <CurrencyCode/>

     </PaymentInfo>

     <PaymentInfo>

      <TransactionReferenceNumber>xxxOQPKU7xxx</TransactionReferenceNumber>

      <Amount>300.00</Amount>

      <PaymentProcessor>fdiaus</PaymentProcessor>

      <CardCategory/>

      <CardCategoryCode/>

      <TargetAmount/>

      <TargetCurrency/>

      <ExchangeRate/>

      <ExchangeRateDate/>

      <DCCIndicator/>

      <AuthorizationCode>xx706</AuthorizationCode>

      <ProcessorTID/>

      <NetworkTransactionID/>

      <CurrencyCode>AUD</CurrencyCode>

      <NumberOfInstallments/>

      <CurrencyCode/>

     </PaymentInfo>

    </PaymentData>

    <BATCH>

     <BatchID>xxx6198xxx</BatchID>

     <BatchDate>2018-12-14T04:18:58Z</BatchDate>

     <Status>BATCHED</Status>

    </BATCH>

  </Request>

 </Requests>

</Report>

 

Subscription Detail Report

Example 32Subscription Detail Report

 

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

<Report Name="SubscriptionDetailReport_Daily_Classic" Type="SubscriptionDetailReport" Version="1.0" xmlns="https://ebctest.cybersource.com/ebctest/reports/dtd/sdr.dtd" MerchantID="mcafeetechmasteruk" ReportStartDate="2018-12-13T08:00:00Z" ReportEndDate="2018-12-14T08:00:00Z">

 <SubscriptionPayments>

  <SubscriptionPayment payment_request_id="xxxx44404682390xxx" subscription_id="xxx260603628800xxx" transaction_date="2018-12-13T11:24:06Z" merchant_ref_number="xxx701" transaction_ref_number="xxx39099xxx" e_commerce_indicator="R">

    <BillTo>

     <customer_firstname>John</customer_firstname>

     <customer_lastname>Doe</customer_lastname>

     <bill_address1>Flat 193</bill_address1>

     <bill_city>Southend on sea</bill_city>

     <bill_state>ESS</bill_state>

     <bill_zip>SS1 2EU</bill_zip>

     <bill_country>GB</bill_country>

     <customer_email>john.doe@yahoo.co.uk</customer_email>

    </BillTo>

    <ShipTo/>

    <PaymentMethod>

     <Card>

      <card_type>MasterCard</card_type>

      <customer_cc_expmo>01</customer_cc_expmo>

      <customer_cc_expyr>2020</customer_cc_expyr>

      <account_suffix>3898</account_suffix>

     </Card>

    </PaymentMethod>

    <PaymentData>

     <ics_applications>ics_bill,ics_auth</ics_applications>

     <recurring_payment_event_amount>129.99</recurring_payment_event_amount>

     <currency_code>GBP</currency_code>

     <reason_code>203</reason_code>

     <auth_rcode>0</auth_rcode>

     <auth_auth_avs>1</auth_auth_avs>

     <auth_auth_response>xxx0285</auth_auth_response>

     <ics_rcode>0</ics_rcode>

     <ics_rflag>DCARDREFUSED</ics_rflag>

     <ics_rmsg>Not authorised</ics_rmsg>

     <request_token>xxjUN3s6V86HZY8Exxx</request_token>

     <payment_processor>globalcollect</payment_processor>

    </PaymentData>

    <MerchantDefinedData>

     <merchant_defined_data1>subscription</merchant_defined_data1>

     <merchant_defined_data2>129.99</merchant_defined_data2>

     <merchant_defined_data3>IVRSGS</merchant_defined_data3>

    </MerchantDefinedData>

    <SubscriptionDetails>

     <recurring_payment_amount>129.99</recurring_payment_amount>

     <subscription_type>recurring</subscription_type>

     <last_subscription_status>HOLD</last_subscription_status>

     <subscription_status>HOLD</subscription_status>

     <subscription_payment_method>MC</subscription_payment_method>

     <recurring_start_date>2017-11-28 08:00:00.0</recurring_start_date>

     <event_retry_count>0</event_retry_count>

     <payments_success>1</payments_success>

     <payment_success_amount>129.99</payment_success_amount>

     <recurring_frequency>annually</recurring_frequency>

     <recurring_approval_required>N</recurring_approval_required>

     <recurring_automatic_renew>Y</recurring_automatic_renew>

     <setup_fee>129.99</setup_fee>

     <setup_fee_currency>GBP</setup_fee_currency>

     <tax_amount>0.00</tax_amount>

    </SubscriptionDetails>

  </SubscriptionPayment>

 </SubscriptionPayments>

</Report>

 

Transaction Exception Detail Report

Example 35Transaction Exception Detail Report

 

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

 <!DOCTYPE Report SYSTEM "https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd">

<Report Name="TransactionDetailReport_Daily_Classic" Type="TransactionRequestReport" Version="1.10" xmlns="https://ebctest.cybersource.com/ebctest/reports/dtd/ctdr_1_10.dtd" OrganizationID="orgID" ReportStartDate="2018-12-10T05:00:00Z" ReportEndDate="2018-12-11T05:00:00Z">

 <Requests>

  <Request RequestID="xxx20998729685170xxx" RequestDate="2018-12-10T05:49:58Z" MerchantReferenceNumber="xxdaf4-cc37-4xx" MerchantID="merchantID" Source="HOA" SubscriptionID="" User="xxx9-0001xx" Comments="">

    <BillTo>

     <FirstName>John</FirstName>

     <LastName>Doe</LastName>

     <MiddleName/>

     <Address1/>

     <Address2/>

     <City/>

     <State/>

     <Zip/>

     <Country/>

     <CompanyName/>

     <Email/>

     <Title/>

     <Phone/>

     <IPAddress/>

     <HostName/>

     <CustomerID/>

     <NameSuffix/>

     <UserName/>

     <PersonalID/>

    </BillTo>

    <ShipTo>

     <Address1/>

     <Address2/>

     <City/>

     <State/>

     <Zip/>

     <Country/>

     <Phone/>

     <FirstName/>

     <LastName/>

     <CompanyName/>

    </ShipTo>

    <Shipping>

     <Method/>

     <Carrier/>

    </Shipping>

    <PaymentMethod>

     <TypeDescription>PayPal</TypeDescription>

     <OverridePaymentMethod/>

     <Type>paypal</Type>

    </PaymentMethod>

    <LineItems>

     <LineItem Number="0">

      <FulfillmentType/>

      <Quantity>1</Quantity>

      <UnitPrice>181.29</UnitPrice>

      <TaxAmount>0.00</TaxAmount>

      <MerchantProductSKU/>

      <ProductName/>

      <ProductCode>default</ProductCode>

      <InvoiceNumber/>

     </LineItem>

    </LineItems>

    <ApplicationReplies>

     <ApplicationReply Name="ics_paypal_ec_set">

      <RCode>1</RCode>

      <RFlag>SOK</RFlag>

      <RMsg>Success</RMsg>

     </ApplicationReply>

    </ApplicationReplies>

    <PaymentData>

     <PaymentInfo>

      <Amount>181.29</Amount>

      <AVSResultMapped/>

      <AuthorizationCode/>

      <CVResult/>

      <PaymentProcessor>paypal</PaymentProcessor>

      <eCommerceIndicator/>

      <CardCategory/>

      <CardCategoryCode/>

      <SolutionType/>

      <TransactionReferenceNumber/>

      <PaymentRequestID>xxx2099872968517xxx</PaymentRequestID>

      <TotalTaxAmount/>

      <AuthorizationType/>

      <AVSResult/>

      <ProcessorResponseCode/>

      <EMVServiceCode/>

      <NetworkTransactionID/>

      <ProcessorTID/>

      <SenderReferenceNumber/>

      <AFTIndicator/>

      <ProcessorResponseID/>

      <AuthIndicator/>

      <AuthReversalResult/>

      <AuthReversalAmount/>

      <PayerAuthenticationInfo>

       <ECI/>

       <AAV_CAVV/>

       <XID/>

      </PayerAuthenticationInfo>

      <CurrencyCode>USD</CurrencyCode>

      <NumberOfInstallments/>

      <ACHVerificationResult/>

      <ACHVerificationResultMapped/>

      <GrandTotal/>

      <CurrencyCode/>

      <BalanceAmount/>

      <BalanceCurrencyCode/>

      <RequestedAmount/>

      <RequestedAmountCurrencyCode>USD</RequestedAmountCurrencyCode>

      <EVEmail/>

      <EVEmailRaw/>

      <EVName/>

      <EVNameRaw/>

      <EVPhoneNumber/>

      <EVPhoneNumberRaw/>

      <EVStreet/>

      <EVStreetRaw/>

      <EVPostalCode/>

      <EVPostalCodeRaw/>

      <BinNumber/>

     </PaymentInfo>

    </PaymentData>

    <RiskData>

     <Factors/>

     <HostSeverity/>

     <Score/>

     <TimeLocal/>

     <ConsumerPasswordProvided/>

     <LostPassword/>

     <RepeatCustomer/>

     <CookiesAccepted/>

     <ConsumerLoyalty/>

     <ConsumerPromotions/>

     <GiftWrap/>

     <ReturnsAccepted/>

     <ProductRisk/>

     <AppliedThreshold/>

     <AppliedTimeHedge/>

     <AppliedVelocityHedge/>

     <AppliedHostHedge/>

     <AppliedCategoryGift/>

     <AppliedCategoryTime/>

     <AppliedAVS/>

     <AppliedCV/>

     <BinAccountType/>

     <BinScheme/>

     <BinIssuer/>

     <BinCountry/>

     <IPCity/>

     <IPCountry/>

     <IPRoutingMethod/>

     <IPState/>

     <DeviceFingerprint/>

     <CookiesEnabled/>

     <FlashEnabled/>

     <ImagesEnabled/>

     <JavascriptEnabled/>

     <ProxyIPAddress/>

     <ProxyIPAddressActivities/>

     <ProxyIPAddressAttributes/>

     <ProxyServerType/>

     <TrueIPAddress/>

     <TrueIPAddressActivities/>

     <TrueIPAddressAttributes/>

     <TrueIPAddressCountry/>

     <TrueIPAddressCity/>

     <InfoCodes>

      <InfoCode>

       <CodeType/>

       <CodeValue/>

      </InfoCode>

     </InfoCodes>

    </RiskData>

    <ProfileList>

      <Profile>

       <ProfileMode/>

       <ProfileDecision/>

       <RuleList>

        <Rule>

         <RuleName/>

         <RuleDecision/>

        </Rule>

       </RuleList>

     </Profile>

    </ProfileList>

    <TravelData>

     <TripInfo>

      <CompleteRoute/>

      <JourneyType/>

      <DepartureDateTime/>

     </TripInfo>

     <PassengerInfo>

      <Passenger>

       <PassengerFirstName/>

       <PassengerLastName/>

       <PassengerID/>

       <PassengerStatus/>

       <PassengerType/>

       <PassengerPhone/>

       <PassengerEmail/>

      </Passenger>

     </PassengerInfo>

    </TravelData>

  </Request>

 </Requests>

</Report>