# Stripe datasets and fields

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

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

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

## Connection and sync

You connect Stripe with API credentials from the Stripe account. Maven stores them encrypted.

Each Stripe sync takes a fresh copy of the current records, so the workspace always reflects what is in Stripe now.

## Datasets

### Accounts

Authenticated Stripe seller account reporting context.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| account business type | Text |
| charges enabled | True/false |
| payouts enabled | True/false |
| livemode | True/false |
| source version at | Timestamp |

### Sync state

Last completed authoritative full snapshot per account and mutable stream.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| stream | Text |
| full snapshot at | Timestamp |
| source version at | Timestamp |

### Events

Non-payload Stripe event ledger used for mutable object reconciliation and freshness.

| Field | Type |
| --- | --- |
| event ID | Text |
| event type | Text |
| object type | Text |
| object ID | Text |
| API version | Text |
| request ID | Text |
| livemode | True/false |
| event created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Deletions

Customer, invoice, and product deletion tombstones from Stripe events.

| Field | Type |
| --- | --- |
| event ID | Text |
| event type | Text |
| object type | Text |
| object ID | Text |
| deleted at | Timestamp |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Charges

Account-scoped charge attempts, payment method classification, refunds, and risk outcome.

| Field | Type |
| --- | --- |
| charge ID | Text |
| amount cents | Integer |
| amount minor | Integer |
| amount refunded cents | Integer |
| amount refunded minor | Integer |
| application fee amount minor | Integer |
| currency | Text |
| status | Text |
| is paid | True/false |
| is refunded | True/false |
| is captured | True/false |
| is disputed | True/false |
| customer ID | Text |
| invoice ID | Text |
| payment intent ID | Text |
| payment method ID | Text |
| balance transaction ID | Text |
| payment method type | Text |
| card brand | Text |
| card funding | Text |
| card country | Text |
| card network | Text |
| wallet type | Text |
| risk level | Text |
| seller outcome type | Text |
| description | Text |
| failure code | Text |
| failure message | Text |
| billing city | Text |
| billing state | Text |
| billing country | Text |
| metadata json | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Payment intents

PaymentIntent lifecycle, attempted and received amounts, capture state, and safe failure codes.

| Field | Type |
| --- | --- |
| payment intent ID | Text |
| customer ID | Text |
| latest charge ID | Text |
| payment method ID | Text |
| amount minor | Integer |
| amount received minor | Integer |
| amount capturable minor | Integer |
| application fee amount minor | Integer |
| currency | Text |
| status | Text |
| capture method | Text |
| confirmation method | Text |
| cancellation reason | Text |
| setup future usage | Text |
| payment method types json | Text |
| failure type | Text |
| failure code | Text |
| decline code | Text |
| description | Text |
| metadata json | Text |
| canceled at | Timestamp |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Invoices

Current account-scoped invoice headers with receivables lifecycle and amount components.

| Field | Type |
| --- | --- |
| invoice ID | Text |
| customer ID | Text |
| subscription ID | Text |
| invoice number | Text |
| status | Text |
| billing reason | Text |
| collection method | Text |
| total cents | Integer |
| total minor | Integer |
| subtotal cents | Integer |
| subtotal minor | Integer |
| amount due cents | Integer |
| amount due minor | Integer |
| amount paid cents | Integer |
| amount paid minor | Integer |
| amount remaining cents | Integer |
| amount remaining minor | Integer |
| tax minor | Integer |
| discount minor | Integer |
| starting balance minor | Integer |
| ending balance minor | Integer |
| currency | Text |
| is paid | True/false |
| is auto advance | True/false |
| attempt count | Integer |
| period start | Timestamp |
| period end | Timestamp |
| due date | Timestamp |
| finalized at | Timestamp |
| paid at | Timestamp |
| voided at | Timestamp |
| marked uncollectible at | Timestamp |
| metadata json | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Invoice lines

Versioned complete invoice lines with product, price, quantity, discounts, tax, and service period.

| Field | Type |
| --- | --- |
| invoice ID | Text |
| line ID | Text |
| line index | Integer |
| line type | Text |
| invoice item ID | Text |
| subscription ID | Text |
| price ID | Text |
| product ID | Text |
| description | Text |
| quantity | Number |
| amount minor | Integer |
| amount excluding tax minor | Integer |
| discount minor | Integer |
| tax minor | Integer |
| currency | Text |
| is proration | True/false |
| is discountable | True/false |
| period start | Timestamp |
| period end | Timestamp |
| metadata json | Text |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Subscriptions

Full current subscription lifecycle with fixed recurring amount context.

| Field | Type |
| --- | --- |
| subscription ID | Text |
| customer ID | Text |
| status | Text |
| collection method | Text |
| default payment method ID | Text |
| latest invoice ID | Text |
| days until due | Integer |
| billing cycle anchor | Timestamp |
| start date | Timestamp |
| current period start | Timestamp |
| current period end | Timestamp |
| cancel at period end | True/false |
| cancel at | Timestamp |
| canceled at | Timestamp |
| ended at | Timestamp |
| trial start | Timestamp |
| trial end | Timestamp |
| pause collection behavior | Text |
| created at | Timestamp |
| quantity | Integer |
| currency | Text |
| monthly recurring amount cents | Number |
| monthly recurring amount minor | Number |
| subscription item count | Integer |
| metadata json | Text |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Subscription items

Current subscription item hierarchy at subscription and price grain.

| Field | Type |
| --- | --- |
| subscription ID | Text |
| subscription item ID | Text |
| item index | Integer |
| price ID | Text |
| product ID | Text |
| quantity | Number |
| currency | Text |
| unit amount minor | Number |
| unit amount decimal minor | Number |
| billing scheme | Text |
| recurring interval | Text |
| recurring interval count | Integer |
| recurring usage type | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Customers

Current account-scoped customer dimensions and receivables context.

| Field | Type |
| --- | --- |
| customer ID | Text |
| email | Text |
| name | Text |
| description | Text |
| currency | Text |
| is delinquent | True/false |
| balance cents | Integer |
| balance minor | Integer |
| tax exempt | Text |
| billing city | Text |
| billing state | Text |
| billing country | Text |
| shipping city | Text |
| shipping state | Text |
| shipping country | Text |
| preferred locales json | Text |
| metadata json | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Products

Active and inactive product catalog.

| Field | Type |
| --- | --- |
| product ID | Text |
| product name | Text |
| description | Text |
| is active | True/false |
| default price ID | Text |
| is shippable | True/false |
| statement descriptor | Text |
| tax code | Text |
| unit label | Text |
| metadata json | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Prices

Active and inactive price catalog with recurring terms.

| Field | Type |
| --- | --- |
| price ID | Text |
| product ID | Text |
| is active | True/false |
| price type | Text |
| billing scheme | Text |
| currency | Text |
| unit amount minor | Number |
| unit amount decimal minor | Number |
| nickname | Text |
| lookup key | Text |
| recurring interval | Text |
| recurring interval count | Integer |
| recurring usage type | Text |
| recurring meter ID | Text |
| tax behavior | Text |
| tiers mode | Text |
| metadata json | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Balance transactions

Stripe balance ledger with reporting category, fee, net, exchange rate, and availability.

| Field | Type |
| --- | --- |
| transaction ID | Text |
| amount cents | Integer |
| amount minor | Integer |
| fee cents | Integer |
| fee minor | Integer |
| net cents | Integer |
| net minor | Integer |
| currency | Text |
| transaction type | Text |
| reporting category | Text |
| status | Text |
| description | Text |
| source ID | Text |
| exchange rate | Number |
| available on | Timestamp |
| fee details json | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Refunds

Refund lifecycle and charge/payment relationships.

| Field | Type |
| --- | --- |
| refund ID | Text |
| amount cents | Integer |
| amount minor | Integer |
| currency | Text |
| status | Text |
| reason | Text |
| failure reason | Text |
| charge ID | Text |
| payment intent ID | Text |
| balance transaction ID | Text |
| receipt number | Text |
| description | Text |
| metadata json | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Disputes

Dispute amount, reason, status, evidence deadline, and payment relationships.

| Field | Type |
| --- | --- |
| dispute ID | Text |
| charge ID | Text |
| payment intent ID | Text |
| balance transaction ID | Text |
| amount minor | Integer |
| currency | Text |
| status | Text |
| reason | Text |
| is charge refundable | True/false |
| evidence due by | Timestamp |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Payouts

Bank payout lifecycle and destination context.

| Field | Type |
| --- | --- |
| payout ID | Text |
| amount cents | Integer |
| amount minor | Integer |
| currency | Text |
| status | Text |
| method | Text |
| payout type | Text |
| source type | Text |
| is automatic | True/false |
| description | Text |
| statement descriptor | Text |
| failure code | Text |
| failure message | Text |
| balance transaction ID | Text |
| destination ID | Text |
| reconciliation status | Text |
| arrival date | Timestamp |
| metadata json | Text |
| created at | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |

### Payout transactions

Payout-to-balance-transaction bridge with gross, fee, and net reconciliation amounts.

| Field | Type |
| --- | --- |
| payout ID | Text |
| transaction ID | Text |
| source ID | Text |
| transaction type | Text |
| reporting category | Text |
| status | Text |
| currency | Text |
| amount minor | Integer |
| fee minor | Integer |
| net minor | Integer |
| available on | Timestamp |
| transaction created at | Timestamp |
| payout arrival date | Timestamp |
| account ID | Text |
| account name | Text |
| account country | Text |
| account default currency | Text |
| account timezone | Text |
| source version at | Timestamp |
