# PayPal datasets and fields

> The 5 datasets Maven lands from PayPal, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/paypal

Maven lands 5 datasets from PayPal in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [PayPal integration page](https://mavendata.ai/integrations/paypal).

## Connection and sync

You connect PayPal with client ID and client secret from the PayPal account. Maven stores them encrypted.

The first PayPal sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 3 years in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

## Datasets

### Accounts

Current PayPal reporting account identity, capability status, and sync metadata.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| default currency | Text |
| timezone | Text |
| livemode | True/false |
| transactions available | True/false |
| balances available | True/false |
| disputes status | Text |
| transaction count | Integer |
| balance currency count | Integer |
| dispute count | Integer |
| last refreshed at | Timestamp |

### Balances

PayPal per-currency total, available, and withheld balances at the requested reporting time.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| currency | Text |
| is primary | True/false |
| total balance | Number |
| available balance | Number |
| withheld balance | Number |
| as of at | Timestamp |
| last refreshed at | Timestamp |

### Transactions

PayPal transaction ledger including completed, pending, denied, reversed, fee, transfer, and balance activity.

| Field | Type |
| --- | --- |
| date | Date |
| transaction row key | Text |
| transaction ID | Text |
| account ID | Text |
| account name | Text |
| paypal account ID | Text |
| payer account ID | Text |
| payer email | Text |
| payer given name | Text |
| payer surname | Text |
| payer country code | Text |
| payer status | Text |
| payer address status | Text |
| invoice ID | Text |
| cart invoice ID | Text |
| reference ID | Text |
| reference ID type | Text |
| event code | Text |
| event group | Text |
| status | Text |
| subject | Text |
| transaction note | Text |
| payment tracking ID | Text |
| bank reference ID | Text |
| custom field | Text |
| currency | Text |
| gross amount | Number |
| fee amount | Number |
| net amount after fee | Number |
| discount amount | Number |
| insurance amount | Number |
| sales tax amount | Number |
| shipping amount | Number |
| shipping discount amount | Number |
| shipping tax amount | Number |
| other amount | Number |
| tip amount | Number |
| ending balance | Number |
| available balance | Number |
| credit transactional fee | Number |
| credit promotional fee | Number |
| payment method type | Text |
| instrument type | Text |
| instrument sub type | Text |
| decline code | Text |
| protection eligibility | Text |
| shipping method | Text |
| shipping city | Text |
| shipping state | Text |
| shipping country code | Text |
| store ID | Text |
| terminal ID | Text |
| tax inclusive | True/false |
| incentive type | Text |
| incentive code | Text |
| incentive program code | Text |
| incentive amount | Number |
| incentives json | Text |
| initiated at | Timestamp |
| updated at | Timestamp |
| item count | Integer |

### Transaction items

Product details passed by the merchant to PayPal for each account-qualified transaction.

| Field | Type |
| --- | --- |
| date | Date |
| transaction row key | Text |
| transaction ID | Text |
| account ID | Text |
| account name | Text |
| event code | Text |
| item index | Integer |
| item code | Text |
| item name | Text |
| item description | Text |
| quantity | Number |
| unit price | Number |
| item amount | Number |
| total item amount | Number |
| discount amount | Number |
| adjustment amount | Number |
| gift wrap amount | Number |
| basic shipping amount | Number |
| extra shipping amount | Number |
| handling amount | Number |
| insurance amount | Number |
| tax percentage | Number |
| tax amount | Number |
| item options json | Text |
| currency | Text |
| invoice number | Text |

### Disputes

Optional PayPal dispute summaries when the connected REST app has the Disputes feature.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| dispute ID | Text |
| reason | Text |
| status | Text |
| dispute state | Text |
| lifecycle stage | Text |
| channel | Text |
| amount | Number |
| currency | Text |
| outcome code | Text |
| seller response due at | Timestamp |
| buyer response due at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
