# Maxio Advanced Billing datasets and fields

> The 14 datasets Maven lands from Maxio Advanced Billing, every field in them, and how the connection syncs.

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

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

## Connection and sync

You connect Maxio Advanced Billing with API key and your Maxio Advanced Billing subdomain from the Maxio Advanced Billing account. Maven stores them encrypted.

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

## Datasets

### Customers

Customer identity and billing contact details.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| address | Text |
| address 2 | Text |
| city | Text |
| country | Text |
| created at | Text |
| customer ID | Text |
| email | Text |
| first name | Text |
| is tax exempt | Text |
| is verified | Text |
| last name | Text |
| organization | Text |
| parent ID | Text |
| phone | Text |
| postal code | Text |
| reference | Text |
| state | Text |
| updated at | Text |
| site host | Text |
| maxio ID | Text |
| state name | Text |
| country name | Text |
| locale | Text |
| vat number | Text |
| tax exempt reason | Text |
| custom fields json | Text |
| source version at | Text |

### Subscriptions

Subscription lifecycle, product, billing period, price, balance, and lifetime revenue.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| activated at | Text |
| balance | Text |
| cancel at end of period | Text |
| canceled at | Text |
| created at | Text |
| currency | Text |
| current period ends at | Text |
| current period started at | Text |
| customer ID | Text |
| expires at | Text |
| next assessment at | Text |
| previous state | Text |
| product handle | Text |
| product ID | Text |
| product name | Text |
| product price | Text |
| signup revenue | Text |
| state | Text |
| subscription ID | Text |
| total revenue | Text |
| trial ended at | Text |
| trial started at | Text |
| updated at | Text |
| site host | Text |
| product price point ID | Text |
| product price point name | Text |
| payment collection method | Text |
| balance minor | Text |
| total revenue minor | Text |
| product price minor | Text |
| cancellation message | Text |
| coupon codes json | Text |
| custom fields json | Text |
| source version at | Text |

### Products

Product catalog, pricing, trial, family, and interval details.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| accounting code | Text |
| archived at | Text |
| created at | Text |
| default price point ID | Text |
| description | Text |
| family ID | Text |
| family name | Text |
| handle | Text |
| initial charge | Text |
| interval | Text |
| interval unit | Text |
| is taxable | Text |
| name | Text |
| price | Text |
| price point name | Text |
| product ID | Text |
| trial interval | Text |
| trial interval unit | Text |
| trial price | Text |
| updated at | Text |
| site host | Text |
| price minor | Text |
| initial charge minor | Text |
| trial price minor | Text |
| family handle | Text |
| source version at | Text |

### Invoices

Invoice status, customer, dates, totals, payments, credits, and refunds.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| collection method | Text |
| credit amount | Text |
| currency | Text |
| customer email | Text |
| customer first name | Text |
| customer ID | Text |
| customer last name | Text |
| customer organization | Text |
| discount amount | Text |
| due amount | Text |
| due date | Text |
| invoice number | Text |
| invoice uid | Text |
| issue date | Text |
| paid amount | Text |
| paid date | Text |
| product family name | Text |
| product name | Text |
| refund amount | Text |
| status | Text |
| subscription ID | Text |
| subtotal amount | Text |
| tax amount | Text |
| total amount | Text |
| site host | Text |
| site ID | Text |
| invoice ID | Text |
| sequence number | Integer |
| role | Text |
| consolidation level | Text |
| parent invoice uid | Text |
| group primary subscription ID | Text |
| payer ID | Text |
| payer organization | Text |
| billing country | Text |
| shipping country | Text |
| transaction time | Text |
| created at | Text |
| updated at | Text |
| debit amount | Text |
| discounts json | Text |
| taxes json | Text |
| custom fields json | Text |
| source version at | Text |

### Invoice line items

Product and component line-item amounts attached to Maxio invoices.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| component ID | Text |
| description | Text |
| discount amount | Text |
| invoice line item ID | Text |
| invoice uid | Text |
| period end | Text |
| period start | Text |
| price point ID | Text |
| product ID | Text |
| quantity | Text |
| subtotal amount | Text |
| tax amount | Text |
| title | Text |
| total amount | Text |
| unit price | Text |
| site host | Text |
| transaction ID | Text |
| kind | Text |
| tax included | True/false |
| tiered unit price | True/false |
| custom item | True/false |
| component cost json | Text |
| source version at | Text |

### Accounts

Authoritative Maxio site boundary, observed currencies, region, and reporting context.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| site ID | Text |
| subdomain | Text |
| environment | Text |
| primary currency | Text |
| currencies json | Text |
| timezone | Text |
| source version at | Text |

### Product price points

Product price points by site and currency, including billing and trial cadence.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| price point ID | Text |
| currency key | Text |
| product ID | Text |
| name | Text |
| handle | Text |
| price point type | Text |
| currency | Text |
| price minor | Text |
| price | Text |
| interval | Integer |
| interval unit | Text |
| trial price minor | Text |
| trial price | Text |
| trial interval | Integer |
| trial interval unit | Text |
| initial charge minor | Text |
| initial charge | Text |
| use site exchange rate | True/false |
| created at | Text |
| updated at | Text |
| archived at | Text |
| source version at | Text |

### Components

Product component catalog for quantity, metered, prepaid, and on/off billing.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| component ID | Text |
| name | Text |
| handle | Text |
| description | Text |
| kind | Text |
| unit name | Text |
| unit price | Text |
| pricing scheme | Text |
| product family ID | Text |
| product family name | Text |
| product family handle | Text |
| default price point ID | Text |
| default price point name | Text |
| price point count | Integer |
| is archived | True/false |
| is taxable | True/false |
| is recurring | True/false |
| tax code | Text |
| upgrade charge | Text |
| downgrade credit | Text |
| use site exchange rate | True/false |
| prices json | Text |
| created at | Text |
| updated at | Text |
| source version at | Text |

### Subscription components

Current component allocation, usage balance, price point, and cadence by subscription.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| subscription ID | Text |
| subscription component ID | Text |
| component ID | Text |
| component handle | Text |
| component name | Text |
| component kind | Text |
| unit name | Text |
| allocated quantity | Text |
| unit balance | Text |
| is enabled | True/false |
| is recurring | True/false |
| pricing scheme | Text |
| currency | Text |
| price point ID | Text |
| price point handle | Text |
| price point name | Text |
| price point type | Text |
| product family ID | Text |
| product family handle | Text |
| interval | Integer |
| interval unit | Text |
| historic usages json | Text |
| created at | Text |
| updated at | Text |
| archived at | Text |
| source version at | Text |

### Invoice payments

Payment applications attached to invoices, with method and transaction identifiers.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| invoice uid | Text |
| payment ID | Text |
| transaction ID | Text |
| memo | Text |
| original amount | Text |
| applied amount | Text |
| transaction time | Text |
| payment method type | Text |
| card brand | Text |
| prepayment | True/false |
| source type | Text |
| source ID | Text |
| source version at | Text |

### Invoice refunds

Refund applications attached to invoices.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| invoice uid | Text |
| refund ID | Text |
| transaction ID | Text |
| memo | Text |
| original amount | Text |
| applied amount | Text |
| transaction time | Text |
| payment method type | Text |
| card brand | Text |
| prepayment | True/false |
| source type | Text |
| source ID | Text |
| source version at | Text |

### Invoice credits

Credit-note applications attached to invoices.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| invoice uid | Text |
| credit ID | Text |
| transaction ID | Text |
| memo | Text |
| original amount | Text |
| applied amount | Text |
| transaction time | Text |
| payment method type | Text |
| card brand | Text |
| prepayment | True/false |
| source type | Text |
| source ID | Text |
| source version at | Text |

### Invoice events

Invoice payment, refund, credit, void, failure, and status lifecycle events.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| invoice event ID | Text |
| event type | Text |
| event at | Text |
| invoice uid | Text |
| customer ID | Text |
| subscription ID | Text |
| currency | Text |
| invoice status | Text |
| transaction ID | Text |
| original amount | Text |
| applied amount | Text |
| from status | Text |
| to status | Text |
| event data json | Text |
| source version at | Text |

### Events

Subscription state, product, billing-date, payment, and custom-field lifecycle events.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| site host | Text |
| event ID | Text |
| event key | Text |
| message | Text |
| subscription ID | Text |
| customer ID | Text |
| event at | Text |
| previous subscription state | Text |
| new subscription state | Text |
| previous product ID | Text |
| new product ID | Text |
| resource type | Text |
| resource ID | Text |
| event specific data json | Text |
| source version at | Text |
