Transaction Detail

This report lists Transaction details and status for the selected time period. It lists details about every Transaction submitted by Subscribe (one time or Subscription generated) for payment processing, and displays its status (Success, Hard Fail or Soft Fail). You can optionally show the Subscription ID. You can show totals, by page or All, provided for Pre-Tax and Total Billed. You can tailor the report to show only the transactions you wish to see by using the additional filters.

This report can be generated using Reports 1.0 or Reports 2.0 data engine.

Reports 1.0 data engineProvides the data you need in the reports up to near real-time. Reports data is displayed in UTC time zone. Reports 1.0 lets you select which display columns to include in the report. Report generation is slow and typically lasts several hours.
Reports 2.0 data engine (default)Supports 20 most commonly used Subscribe reports. Reports 2.0 operates in UTC time zone. You can select which time zone to use for the report data display. Reports display all the available columns. Data is available for the prior two years and up to the previous day according to UTC time. Report generation is quicker as data is prepared ahead of time, once a day.
Note: For a list of reports 2.0, see Subscribe Reports using the Vindicia Data Platform —Reports 2.0

To generate a one time report:

  1. Enter the date range
  2. Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered.
  3. Select the Affiliate ID as relevant for the report. Select No Affiliate if not required.
  4. For Reports 2.0, select the relevant Time Zone for data range selection and display. Data is available for the previous day at 13:00 UTC time.
    Note: A notification error message appears when attempting to run reports for which data is not yet available. The report can be submitted and includes data up to the available time.
  5. Optional. Enter Additional Filters for the report:
    • Select the Affiliate ID or Sub-Affiliate ID as a filter for the report.
    • Select the Account ID as a filter for the report.
    • Select the Product ID as a filter for the report.
    • Select the Payment Method as a filter for the report.
    • Select a Currency as a filter for the report.
    • Select a Country as a filter for the report.
  6. For Reports 1.0, select the Display Columns you'd like to include in the report.
  7. Click Submit.

    View the report in the My Reports page.

To schedule a recurring report:

  1. Toggle Recurring toggle to Yes.
  2. Select a date for the first reporting period.
    Note: Reports display data occurring starting from the defined date. For example, a monthly report starting on March 1st displays data for the month of March up to March 31st.
  3. Select the report's Frequency. Choose between Daily, Weekly, Monthly or Quarterly.
  4. Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered.
  5. For Reports 2.0, select the relevant Time Zone for data range selection and display.
  6. Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details.

    When enabled, a scheduled report will be uploaded to the specified SFTP Server. The SFTP report follows the <report name>-<frequency>-<timestamp>.csv naming convention where:

    • <report name> is the name of the report
    • <frequency> is the defined frequency such as monthly, weekly, quarterly, daily or once
    • <timestamp> is the format YYYY-MM-DD"T"HH_MI_SS.TZ, where TZ is the timezone offset, for example, 2022-01-27T10_57_02.433174455Z.

    For this report, the <report name> is transaction_detail

    Note: An email notification is sent if there is an issue in generating or downloading the report on the specified SFTP Server.
  7. Optional. Enter Additional Filters for the report:
    • Select the Affiliate ID or Sub-Affiliate ID as a filter for the report.
    • Select the Account ID as a filter for the report.
    • Select the Product ID as a filter for the report.
    • Select the Payment Method as a filter for the report.
    • Select a Currency as a filter for the report.
    • Select a Country as a filter for the report.
  8. For Reports 1.0, select the Display Columns you'd like to include in the report.
  9. Click Submit.

    The report is submitted and will be generated according to the details provided. If you have provided an email or SFTP details, you will be notified when it is available for viewing.

  10. View the report in the My Reports page.

Display Columns

Note: The report's display columns order is machine-generated and may therefore change without prior notice.
FieldDescription
Billing Information | Subscription (AutoBill ID)Unique, merchant-assigned identifier for the Subscription associated with this Transaction. If the Transaction is not generated from an Subscription, this field will not be populated.
Merchant | CompanyThe Customer’s company, if available.
Billing Information | CityCustomer’s billing city.
Billing Information | CountryCustomer’s billing country.
Billing Information | State/DistrictCustomer’s billing state or district.
Billing Information | AddressCustomer’s billing address.
Billing Information | Zip Code

Customer’s billing zip code

Note:

Your payment processor may limit this field to nine characters.

Billing Information | Billing Plan IDID of the Billing Plan associated with the Subscription that generated the Transaction. If the Transaction is not generated from an Subscription (i.e., generated by a one-time Transaction), this field will not be populated.
Billing Information | CurrencyThe Currency or Token type used for the Transaction.
Merchant | Affiliate IDAffiliate from the customer's Subscription, or as specified in the Transaction.
Merchant | Sub-Affiliate IDSub-Affiliate from the customer's Subscription, or as specified in the Transaction.
Billing Information | Payment Method

The payment method used to finance the Transaction. Valid types include:

  • All
  • CreditCard
  • PayPal
  • ECP
  • Boleto
  • Token
  • Carrier Billing
  • External Billing
  • Direct Debit
  • Gift Card
  • Hosted Page
  • Merchant Accepted Payment
  • Military Star
  • Skrill
  • ApplePay
  • Google Pay
  • Transbank
  • Amazon
Billing Information | Payment ProcessorThe processor through which the Transaction was submitted for payment.
Billing Information | Shipping CityThe city provided for product shipping.
Billing Information | Shipping CountryThe country provided for product shipping.
Billing Information | Shipping State/DistrictThe state provided for product shipping.
Billing Information | Shipping AddressThe street address provided for product shipping.
Billing Information | Zip CodeThe zip code provided for product shipping.
Note:

This field may be limited to nine characters by your payment processor.

Billing Information | Authorization CodeThe approval provided by your Payment Processor.
Billing Information | Auth Response CodeThe Response Code returned by your Payment Processor.
Billing Information | Subscription (AutoBill) CycleThe sequence number in the life of the Subscription for which this transaction charges. As this index begins with 0 for the initial billing cycle of an Subscription, it can also be considered the renewal count—that is, 1 is the first renewal, 3 is the third renewal, and so on.
Billing Information | Billing Plan CycleThe sequence number in the life of the Subscription, since the last Billing Plan change, for which this transaction charges. If there has been no billing plan change for this Subscription, this number will be the same as the Subscription Cycle.
Billing Information | Transaction TimestampTime the Transaction was processed.
Billing Information | Division IDSub-division of the merchant ID by which some payment processors report or settle funds.
Billing Information | Transaction IDID of the Transaction sent to the payment processor.
Billing Information | Processor IDThe name Vindicia uses to identify a Subscribe Transaction to the associated payment processor. This is usually the Subscribe Transaction ID. In some cases however, due to the format requirements of some payment processors, Subscribe alters the Transaction name before sending it to the processor. In those cases, the name of a transaction in a report by the payment processor will differ from the name of the same transaction in a report by Vindicia. This enables you to reconcile the original Subscribe Transaction name with the altered Transaction name Subscribe sends to the payment processor, to identify the Transaction.
Billing Information | Tax not collectedIndicate if tax is not collected due to unavailability of the tax service at the time of the Transaction. For details, see “Handling ‘Tax Not Available’ Scenarios” in Appendix B of the Subscribe Programming Guide. To enable this Merchant Option, contact Vindicia Client Technical Support.
Billing Information | Total BilledAmount plus Tax.
Billing Information | Taxcalculated Tax
Billing Information | Pre TaxAmount before tax.
Billing Information | Total Invoice AmountTotal amount plus Tax appearing in the associated Invoice including tax
Billing Information | Merchant TXB identifierThe merchant's Transaction Billing ID, which is also known as the Invoice ID
Billing Information | Invoice DateThe date the Invoice was generated.
Billing Information | Total Invoice Amount TaxThe associated invoice's calculated tax
Billing Information | Invoice Amount Pre-TaxThe associated invoice's amount before tax.
Billing Information | Transaction Status

Transaction Status from the payment processor reason code.

  • Canceled: the transaction was canceled.
  • Authorized: the transaction has been authorized, but not yet captured.
  • Captured: the transaction was successfully captured.
Billing Information | Retry NumberThe sequence number indicating which retry attempt this transaction represents for the billing period it represents. This index begins with 0 for the initial attempt to charge for a particular billing. A value of 1 indicates the first retry, 3 indicates the third retry, and so on. For one-time transactions this value is null.
Merchant | Account IDThe customer's ID.
Merchant | Account NameThe Subscriber's Customer’s name.
Product Information | Product IDProduct ID from the customer's Subscription, or as specified in the Transaction. If the Transaction is not generated from a Subscription and the Product is not defined in Subscribe, this field will not be populated.
Product Information | Product NameProduct Description from the customer's Subscription, or as specified in the Transaction. If the Transaction is not generated from an Subscription and the Product is not defined in Subscribe, this field will not be populated.
Billing Information | Payment Method TypeCustomer-defined Payment Method type (for example cash, check).