Activity Download report
Last updated: Aug 15th, 7:37am
The Activity Download Report provides users with access to transaction details for advanced reporting. This feature allows merchants to customize reports, through user-selected date ranges, file types, and data fields. The Activity Download Report is available for merchants with access to the reporting portal. It is available at the account level.
Know before you begin
-
The reports character encoding is UTF-8 (8-bit UCS/Unicode Transformation Format).
-
The reports are available in these formats:
-
Portable Document Format (PDF)
-
Comma-Separated Values (CSV)
-
Tab-Separated Value (TAB)
-
Quickbooks (IIF-enabled only for US accounts)
-
Quicken (QIF-USD only)
-
Report availability and retention
Activity download reports are available for any time period within the last 7 years.
In addition to choosing dates from a calendar, you can choose:
- Since last download
- Today
- Yesterday
- Past month
- Past 3 months
- Past 6 months
Report file name
The filename of a report from Activity Download follows this naming convention:
Download.*format*
format is one of the following |
---|
CSV . A comma-separated value file.TAB . A tab-separated value file.PDF . A portable document format file.IFF . An Intuit Interchange Format file.QIF . A Quicken Interchange Format file. |
Download fields
The following download fields are available in the Activity Download report. The column names below reflect the column names in the report, which contain details for each transaction. Position refers to the order of columns if all were to be selected. Download fields indicated as having an "unselected" state are those which are not selected upon default to appear in the report, in contrast to fields in "selected" and "mandatory" states which do appear in the report. Fields with "unselected" or "selected" as their state may have the state changed by the user choosing to edit/customize download fields.
Download data fields
Position | Column name | Data type | Char max length | State | In PDF | Description |
---|---|---|---|---|---|---|
1 | Date | Date | 10 | Mandatory | Yes | The localized completion date of the transaction in a format based on the user's country. For the US, MM/DD/YYYY |
2 | Time | Time | 8 | Mandatory | No | The localized completion time of the transaction. Format is HH:MM:SS . |
3 | TimeZone | Alphanumeric | 32 | Mandatory | No | The time zone used for displaying transaction date and time. |
4 | Name | Alphanumeric | 200 | Mandatory | No | Counterparty name. Business name for business users and name for personal or premier users. Is not unique and can have blanks. |
5 | Type | Alphanumeric | 100 | Mandatory | Yes | Transaction event code (T-Code) description. Is not unique and can have spaces. See the Transaction Detail Report Specification for a full list of T-Codes. |
6 | Status | Alphanumeric | 127 | Mandatory | Yes | The status of the transaction. Possible values for all activity:
|
7 | Currency | 3-char currency code | 3 | Mandatory | Yes | Currency of transaction. It is not unique and cannot have blanks. |
8 | Gross | Currency/Money | 25 | Mandatory | Yes | Localized gross amount. To talk amount of the transaction including fees. It is not unique and cannot have blanks. |
9 | Fee | Currency/Money | 25 | Mandatory | Yes | Localized fee amount associated with the transaction. This field contains the fee amount value for all transactions where a transactional fee has been processed. Fees are not amortized across several transactions. Is not unique and can have spaces. |
10 | Net | Currency/Money | 25 | Mandatory | Yes | Localized net amount of the transaction (usually gross fee). It is not unique and can have blanks. |
11 | From Email Address | Alphanumeric | 127 | Mandatory | No | The email address of the person with which the merchant transacted (buyer). It is not unique and can have blanks. |
12 | To Email Address | Alphanumeric | 127 | Mandatory | No | The email address of the transaction recipient. It is not unique and can have blanks. |
13 | Transaction ID | Varchar | 24 | Mandatory | No | Encrypted Transaction ID. The ID of the transaction against which the case was filed. This unique 17-character ID is generated by PayPal and cannot be altered. It is unique and can have blanks. |
14 | CounterParty Status | Alphanumeric | 127 | Unselected | No | The accounts status of the counterparty. Possible values:
|
15 | Shipping Address | Alphanumeric | 127 | Unselected | No | The complete shipping address for the transaction. This information is a pass-through of what was provided by the payer. It is not unique and can have blanks. |
16 | Address Status | Alphanumeric | 127 | Selected | No | The status of the counterparty's shipping address. Possible values:
|
17 | Item Title | Alphanumeric | 127 | Selected | No | The item title specified by a buyer in the website Auction/Item title field. It is specified by the seller in any of the following buttoncreation fields (item_name or item_name_x ):
|
18 | Item ID | Alphanumeric | 127 | Selected | No | Specified by the seller in any of the following buttoncreation fields (item_name or item_name_x ):
|
19 | Shipping and Handling Amount | Currency/Money | 25 | Selected | No | The localized amount paid, as reported by either PayPal or the merchant, for shipping and handling as a part of the transaction. It is not unique and can have blanks. |
20 | Insurance Amount | Currency/Money | 25 | Selected | No | The localized insurance amount, as reported by either PayPal or the merchant, for the transaction. It is not unique and can have blanks. |
21 | Sales Tax | Currency/Money | 25 | Selected | No | The localized sales tax amount, as reported by either PayPal or the merchant, paid as part of the transaction. It is not unique and can have blanks. |
22 | Option 1 Name | Alphanumeric | 64 | Selected | No | The Option 1 Name associated with a transaction. It is specified by the seller in any of the following buttoncreation fields )on0 or on0_x ):
|
23 | Option 1 Value | Alphanumeric | 200 | Selected | No | The Option 1 Value associated with a transaction. It is entered by the buyer in any of the following website fields:
A1:F56 fields:
|
24 | Option 2 Name | Alphanumeric | 64 | Selected | No | The Option 2 Name associated with a transaction. It is specified by the seller in any of the following buttoncreation fields )on0 or on0_x ):
|
25 | Option 2 Value | Alphanumeric | 200 | Selected | No | The Option 2 Value associated with a transaction. It is entered by the buyer in any of the following website fields:
|
26 | Auction Site | Varchar | 255 | Unselected | No | The name of the auction site:
|
27 | Buyer ID | Varchar | 255 | Unselected | No | The ID of the buyer making the purchase in the auction. This ID can be different from the payer ID provided for the payment. It is not unique and can have blanks. |
28 | Item URL | Alphameric | 4000 | Unselected | No | The URL of the eBay/Auction Item. In the case of multiple items, items are separated with a comma and shown along with the payment row. For example, http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=252297991684 . It is not unique and can have blanks. |
29 | Closing Date | Alphanumeric | 100 | Unselected | No | The close date of eBay/Auction Item. The date format is based on the user's country. For example, 3/12/2016 10:31:52 PM . It is not unique and can have blanks. |
30 | Escrow ID | Numeric | 22 | Unselected | No | The ID associated with the eBay Escrow CN Checkout transaction. It is not unique and can have blanks. |
31 | Reference Txn ID | Varchar | 24 | Mandatory | No | The encrypted Transaction ID of the parent transaction. It is unique and can have blanks. |
32 | Invoice Number Text | 127 | Selected | No | The invoice ID set by the merchant with the transaction. Uniqueness enforced by PayPal when the transaction is created. If an invoice ID was sent with the capture request, this value is reported here. However, if no invoice ID was sent with the capture request, the value of the invoice ID (if any) from the authorizing transaction is reported here. It is not unique and can have blanks. | |
33 | Custom Number | Alphanumeric | 256 | Selected | No | Shown only to seller/admin. The shopping cart customer number, Buy Now customer number, Subscription custom number, gift certificate tracking ID, or Masspay 2.0 disbursement ID. It is not unique and can have blanks. |
34 | Quantity | Numeric | 25 | Selected | No | This shows the total number of items present in the payment transaction. For item rows, it shows quantity of an individual item. |
35 | Receipt ID | Alphanumeric | 19 | Mandatory | No | The receipt identification number. 16-digit number in xxxx-xxxx-xxxx-xxxx format. It is not unique and can contain blanks. |
36 | Balance | Currency/Money | 25 | Selected | No | Reflects the running amount in the merchant's bank account (available balance) in the currency of the transaction. Balance equals the previous balance plus the net. It is not unique and can contain blanks. |
37 | Address Line 1 | Varchar | 300 | Selected | No | The first line of the shipping address. It is not unique and can have blanks. |
38 | Address Line 2/District/Neighborhood | Varchar | 300 | Selected | No | The second line of the shipping address. It is not unique and can have blanks. |
39 | Town/City | Alphanumeric | 120 | Selected | No | The town or city of the shipping address. |
40 | State/Province/Region/County/ Territory/Prefecture/Republic |
Alphanumeric | 120 | Selected | No | The state, province, region, territory, prefecture, or republic of the shipping address. It is not unique and can have blanks. |
41 | Zip/Postal Code | Varchar | 60 | Selected | No | The zip or postal code of the shipping address. It is not unique and can contain blanks. |
43 | Contact Phone Number | Numeric | 22 | Selected | No | The contact phone number. It is not unique and can contain blanks. |
44 | Subject | Alphanumeric | 256 | Selected | No | The Transaction Subject/Item name. The subject of the payment as passed through the payer to the payee. This data is controlled by the payer exclusively in the interfaces through which it is sent. It is not unique and can contain blanks. |
45 | Note | Varchar | 4000 | Selected | No | The transaction note. A special note of payment as passed through by the payer to the payee. This data is controlled by the payer exclusively in the interfaces through which it is sent. It is not unique and can have blanks. |
46 | Payment Source | Varchar | 50 | Unselected | No | The funding method. Possible values are:
|
47 | Card Type | Varchar | 30 | Unselected | No | The funding source used for the transaction. Possible values are:
|
48 | Transaction Event Code | Alpahanumeric | 5 | Unselected | No | The T-Code number. It is not unique and cannot have blanks. |
49 | Payment Tracking ID | Varchar | 127 | Unselected | No | The tracking ID specified by partners to obtain information about a payment or to request a refund. It is not unique and can have blanks. |
50 | Bank Reference ID | Varchar | 13 | Unselected | No | The bank reference ID. It is unique and can have blanks. |
51 | Transaction Buyer Country Code | Varchar | 45 | Unselected | No | The buyer country code. It is not unique and can have blanks. |
52 | Item Details | Varchar | 1024 | Unselected | No | The item details. It is not unique and can have blanks. |
53 | Coupons | Varchar | 2048 | Unselected | No | The information about all the coupons associated with the transaction. Each individual item contains four pipe-delimited parts of information:
|
54 | Special Offers | Varchar | 2048 | Unselected | No | The informationa bout all the store credits associated with the transaction. Each individual item contains four pipe-delimited parts of information:
|
55 | Loyalty Card Number | Varchar | 100 | Unselected | No | The customer's loyalty card provided to the merchant. This is applicable for Point of Sale transactions only. It is not unique and can have blanks. |
56 | Authorization Review Status | Varchar | 2 | Unselected | No | Indicated the current status of the transaction and whether it is under review. If it is under review, then the status is either Green (01) or Yellow (02). Possible values are:
|
57 | Protection Eligibility | Varchar | 2 | Unselected | No | Indicates whether the transaction is eligible (01), not eligible (02), or partially eligible (03) for seller protection. Possible values are:
|
58 | Country Code | Varchar | 64 | Selected | No | The two letter country code of the shipping address. It is not unique and can have blanks. |
59 | Balance Impact | Varchar | 64 | Selected | No | The impact on the balance for the transaction. Possible values are:
|
60 | Buyer Wallet | Varchar | 10 | Unselected | No | The text that identifies the company (PayPal or one of its subsidiaries) that processes the payment. It is not unique and can have blanks. |
61 | Comment 1 | Varchar | 1000 | Unselected | No | A note that accompanies a gateway transaction. It is not unique and can have blanks. |
62 | Comment 2 | Varchar | 1000 | Unselected | No | A note that accompanies a gateway transaction. It is not unique and can have blanks. |
63 | Invoice Number | Varchar | 200 | Selected | No | The identifier of the invoice issued by the merchant. It is not unique and can have blanks. |
64 | PO Number | Varchar | 200 | Unselected | No | The identifier of the manifest of goods bought from the merchant. It is not unique and can have blanks. |
65 | Customer Reference Number | Varchar | 80 | Unselected | No | The identifier of the customer for a merchant. It is not unique and can have blanks. |
66 | Payflow Transaction ID (PNREF) | Varchar | 80 | Unselected | No | The unique idenitifier for the gateway transaction. It is not unique and can have blanks. |
67 | Tip | Currency/Money | 25 | Unselected | No | The amount of money paid by a consumer to a merchant over and above the item costs and any handling amounts in appreciation for services rendered. It is not unique and can have blanks. |
68 | Discount | Currency/Money | 25 | Unselected | No | The amount of discount given on the ordinary price of an item or group of items by the merchant. It is not unique and can have blanks. |
69 | SellerID | Varchar | 200 | Unselected | No | The unique idenitifier for the merchant at the marketplace site. It is not unique and can have blanks. |
70 | Risk Filter | Varchar | 500 | Unselected | No | The risk checks that the transaction matches. For a list of possible balues see Changed Download Fields It is not unique and can have blanks. |
71 | Tax ID Type | Varchar | 4 | Unselected | No | Indicates the tax ID type of the buyer. Available for Brazil only. Possible values are:
|
72 | Tax ID | Varchar | 80 | Unselected | No | The buyer's taxpayer registry number. Avaiable for Brazil only. It is not unique and can have blanks. |
73 | Number of Installments | Numeric | 26 | Unselected | No | The number of installments for the credit offer. Available for Brazil and Mexico only. It is not unique and can have blanks. |
74 | Installment Amount | Currency/Money | 26 | Unselected | No | The installment amount for the credit offer. Only available for Brazil and Mexico. It is not unique and can have blanks. |
75 | Installment Fee | Currency/Money | 26 | Unselected | No | The installment fee for the credit offer. Only available for Brazil and Mexico. It is not unique and can have blanks. |
76 | Credit Transactional Fee | Currency/Money | 26 | Unselected | No | The credit-related transaction fee amount for a merchant-selected credit offering. |
77 | Credit Promotional Fee | Currency/Money | 26 | Unselected | No | The credit-related transaction fee amount for a merchant-selected credit offering with a promotional APR. |
78 | Credit Term | Numeric | 26 | Unselected | No | The time span covered by the merchant-selected credit offer. The length of the term is captured in months. |
79 | Credit Offer Type | Alphanumeric | 64 | Unselected | No | The name of the credit offer used by the buyer as a funding instrument. |
80 | Original Invoice ID | Varchar | 200 | Unselected | No | The invoice ID of the original payment record. This ID helps users link and track all related transactions to the original parent transaction. |
81 | Campaign Fee | Currency/Money | 22 | Unselected | No | The fee charged to a merchant for each sale with a discount applied during a campaign. |
82 | Campaign Name | Varchar | 200 | Unselected | No | The name given to the campaign. Merchants can track this name on the campaign dashboard. Examples: XMAS2021 , Sales Recovery Campaign . |
83 | Campaign Discount | Currency/Money | 22 | Unselected | No | Denotes the value of a discount amount applied in the transaction. For marketing campaigns, merchants can offer customers a discount in either a dollar amount or percentage. |
84 | Campaign Discount Currency | 3-char currency code | 3 | Unselected | No | Denotes the currency of the discounted amount. |
85 | Payment Source Subtype | Varchar | 50 | Unselected | No | The funding source used for the transaction and the name of the credit offer used by the buyer as a funding instrument. Possible values are:
For example:
|
86 | Decline Code | Varchar | 50 | Unselected | No | |
87 | Fastlane Checkout Transaction | Varchar | 1 | Unselected | No | Indicates whether the transaction was checked out using fastlane accelerated checkout. |