Table Documentation

This table holds the name and Id number of action sets that are created under the Infusionsoft Logo > Marketing Settings > Action Sets within Infusionsoft.

This table holds data related to the Affiliate records within Infusionsoft.

This table holds the Name and Status of Follow-up Sequences you have created within Infusionsoft.

This table has one entry for each person in a single follow-up sequence. One contact in three different follow-up sequences means you will find three entries in this table for that contact record.

This table holds individual follow-up sequence step data. There is one row in this table for each step found in a given follow-up sequence.

This table holds data related to credit card charges processed from Infusionsoft through a merchant account.

This table holds the Company data in the system.

This table holds contact record data as well as custom contact fields. You will not see the custom fields listed in the fields below, as these are custom to each different Infusionsoft application.

This table holds data for tasks, notes, and appointments within Infusionsoft.

This table holds data for the tags you have created within Infusionsoft. In the Infusionsoft "ice age" tags were referred to as "groups", thus the table name.

This table has one entry for each tag a single contact has. If you have one contact with five tags, you will find five entries in this table for that given contact

This table holds tag categories. For each category you have in your system, there will be one row in this table.

This table holds data about all the subscription programs you have created within Infusionsoft.

This table holds all data tied to credit cards. For each credit card in the system there will be one row in this table.

This table holds custom fields. For each field there will be one row in this table.

This table holds the headers that custom fields are displayed under.

This table holds your custom field tabs. These tabs are where your custom fields sit on contact records, orders, opportunities, etc.

These are the expenses incurred by opportunities and leadsources.

This table holds data related to the files stored within your company or contact fileboxes.

This table holds the data related to what user groups your system users are a part of.

This table holds data related to an individual invoice. Remember that one order (Job) has one invoice, while one subscription (RecurringOrder) has multiple invoices.

This table has one row for each "line item" found on an invoice. If there is an order for one product that also includes tax and shipping, you will find three rows on this table related to that particular InvoiceId.

This table holds one entry for each payment towards a particular invoice.

Job

This table holds one-time order data (not subscriptions).

This table holds data related to one instance of a subscription. For each recurring of the subscription, you will find one entry in this table.

This table holds opportunity record data.

This table holds data related to each of the Leadsources you have created under the Setup>Leadsources menu inside Infusionsoft.

This table holds line items for one-time orders. For each product, tax, discount, or shipping found on an order, there will be one entry in this table found.

This table holds each of the payments or refunds placed. This includes all types of payments. Cash, Refund, check, PayPal, etc.

This table holds the PayPlan data tied to each invoice in the system.

This table holds the data that tells our system what portion of a payment plan is due on each date.

This table holds your one-time products (non subscriptions).

This holds your products' categories and subcategories

This table holds the categories that each product has been assigned to be a part of

This table holds data from the Product/Subscription tab on Opportunities.

This table holds the product interest bundles that you have created from the Sales Settings section inside Infusionsoft.

This table holds all the subscriptions generated on contacts. For each contact that has a subscription you will find a row in this table.

This is a mirror image of the RecurringOrder table, but Contact data has been virtually included here to save you an API call. Custom contact fields are not retrievable via the table.

This table holds affiliate referrals.

This table holds all saved searches and saved reports created by users within Infusionsoft.

This table holds the opportunity stages you have created within Infusionsoft.

This table holds historic data of opportunities being moved from one stage to another.

DEPRECATED - This table is used for 'legacy' opportunities' status field

DEPRECATED - This table holds data about service tickets. This is part of a ticketing module Infusionsoft no longer offers.

DEPRECATED - This table holds the ticket stages. This is part of a ticketing module Infusionsoft no longer offers.

DEPRECATED - This table holds data related to the ticketing module Infusionsoft no longer offers.

This table holds data about your Infusionsoft users.

This table holds user group information. These are groupings for your system users, not contacts.