Purchase & Refund Details

Purchase & Refund Details

The Purchase & Refunds Details report contains the following attributes and elements:

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

HierarchyLevel=CDATA

ReportStartDate=CDATA

ReportEndDate=CDATA>

The table below lists the attributes of <Report>.

Table 22

Attributes of <Report>

Data Type and Length

ReportHierarchy
Level

Node value for which the report is requested

ReportStartDate

First date that is included in the report

Last date that is included in the report

Example

<Report> Element

<Report HierarchyLevel="SampleMerchant (101011000241000110001)" StartDate="7/29/2008" EndDate="7/29/2008">

The table below lists the child element of <Report>.

Table 23

Child Element of <Report>

Contains all of the requests in the report. See <Requests> for a list of child elements

The <Request> element contains all the requests that are included in the report.

The table below lists the child elements of <Request>.

Table 24

Child Elements of <Request>

Data Type and Length

Request ID of the transaction

CyberSource merchant ID

Merchant ID assigned by the processor

Hierarchy ID of the purchase or refund transaction

Transaction reference number assigned by CyberSource

<MerchantRefNo>

Reference number assigned to the purchase transaction by the merchant

<TransactionType>

Value defining the transaction type (Purchase or Refund)

<SubmissionDate>

Date of the purchase or refund transaction

Amount of the purchase or refund transaction

<TransactionAmountCurrency>

Transaction currency code

<PaymentMethod>

Method of payment used in the original transaction–MasterCard, Visa, Discover, American Express

Mode of payment, such as credit card

<AccountSuffix>

Last 4 digits of the account number

<AuthTransRefNo>

Transaction reference number of the authorization

Date of the original authorization transaction

<AuthRequestId>

Request ID of the original authorization transaction

Amount of the associated authorization transaction

Currency code of the authorization transaction

Authorization code returned by the issuer for the associated authorization transaction

<AuthResponseCode>

CyberSource response code to the authorization request that was associated with the purchase

<CYBSBatchDateTime>

Date and time the transaction was batched at CyberSource for submission to the processor

Date and time (28)

Batch ID assigned by CyberSource

Reference to the card product type used to define the interchange qualification level

<InterchangeDescription>*

Description of the interchange qualification level. Interchange Qualification is used to determine the fees due to the card issuing banks for processing of payment transactions through the payment networks

<InterchangePercentage>*

Fee paid to the issuing banks that is calculated as a percentage of the purchase amount which applies to the purchase transaction

<InterchangePercentage
Amount*>

Amount calculated when the interchange percentage is applied to the value of the purchase transaction. This amount is passed on to the issuing bank

<InterchangePerItemFee>*

Portion of the interchange fee that is calculated as a peritem amount for this transaction

Indicates the Debit Network used for this transaction

<DiscountPercentage>

Fee calculated as a percentage of the purchase amount which may include interchange and other fees bundled together

<DiscountAmount>

Amount calculated when the discount percentage is applied to the value of the purchase transaction

<DiscountPerItemFee>

Fee amount assessed for each transaction in addition to the discount percentage

Total of fees collected for the transaction being reported

Currency in which the fees were collected (this is always the same as the funding currency)

<MerchantData1>

Merchant defined data fields

<MerchantData2>

Merchant defined data fields

<MerchantData3>

Merchant defined data fields

<MerchantData4>

Merchant defined data fields

<FundingAmount>

Amount of the transaction face value in funding currency

<FundingCurrency>

Funding currency code

<BucketMerchant>

Indicates whether customer is a small business merchant

String (1) Yes or No

Customer’s first name

Customer’s last name

* Not applicable to bundled-pricing merchants

Example

<Request> Element

<CYBSMID>SampleMerchant</CYBSMID>

<RequestId>2393877730000167904567</RequestId>

<ProcessorMID>8610007940810</ProcessorMID>

<HierarchyID>101011000031000110003</HierarchyID>

<TransRefNo>36385350004</TransRefNo>

<MerchantRefNo>33557799</MerchantRefNo>

<TransactionType>Purchases</TransactionType>

<SubmissionDate>04/10/09</SubmissionDate>

<Amount>2.40</Amount>

<TransactionAmountCurrency>USD</TransactionAmountCurrency>

<PaymentMethod>Visa</PaymentMethod>

<PaymentType>credit card</PaymentType>

<AccountSuffix>1111</AccountSuffix>

<AuthTransRefNo>36385350004</AuthTransRefNo>

<AuthDate>04/10/09</AuthDate>

<AuthRequestId>2393877730000167904567</AuthRequestId>

<AuthAmount>2.40</AuthAmount>

<AuthCurrency>USD</AuthCurrency>

<AuthCode>831000</AuthCode>

<AuthResponseCode>1</AuthResponseCode>

<CYBSBatchDateTime>04/10/09 01:22 PM</CYBSBatchDateTime>

<CYBSBatchID>2500000000020465</CYBSBatchID>

<MerchantData1 />

<MerchantData2 />

<MerchantData3 />

<MerchantData4 />

<CardType>Consumer Credit</CardType>

<InterchangeDescription>Standard</InterchangeDescription>

<InterchangePercentage>2.7</InterchangePercentage>

<InterchangePercentageAmount>0.06</InterchangePercentageAmount>

<InterchangePerItemFee>0.10</InterchangePerItemFee>

<DiscountPercentage>5</DiscountPercentage>

<DiscountAmount>0.12</DiscountAmount>

<TotalFee>0.38</TotalFee>

<FeeCurrency>USD</FeeCurrency>

<DiscountPerItemFee>0.10</DiscountPerItemFee>

<FundingAmount>2.40</FundingAmount>

<FundingCurrency>USD</FundingCurrency>

<BucketMerchant>N</BucketMerchant>

<FirstName>Sally</FirstName>

<LastName>Jones</LastName>