invantive documentation
Invantive Support ForumsLog In / Sign Up

Autotask Data Model

Autotask is Professional Services Automation (PSA) software from Datto. Autotask provides a cloud-based PSA platform for businesses.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/autotask

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • Data can be written as well as read.
  • Invantive Cloud plans: Free, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.datto.com/.

Figures

Figure Count
Tables 2,609
Columns 38,275

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 2 A0 sheets

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Autotask data model, Sheet 1 of 2Autotask data modelfor use with Invantive UniversalSQLRelease 24.1.3-BETA+4689 · 10-06-2024Configuration · Contract · Company · Ticket · Billing · Document · Task · Service · Purchase · ArticleSheet 1 of 2 · documentation.invantive.euConfiguration×2×2×2×2×2×2×2×2×2×2×2×2×2Autotask.AttachmentInfo.AttachmentInfo: itgen_autotask_attachmentinfo_plural (Autotask.AttachmentInfo.AttachmentInfoCount)AttachmentInfoAutotask.Tickets.TicketsTAutotask.ConfigurationItemAttachments.ConfigurationItemAttachments: itgen_autotask_configurationitemattachments_plural (Autotask.ConfigurationItemAttachments.ConfigurationItemAttachmentsCount)ConfigurationItemAttachmentsAutotask.ConfigurationItemBillingProductAssociations.ConfigurationItemBillingProductAssociations: itgen_autotask_configurationitembillingproductassociations_plural (Autotask.ConfigurationItemBillingProductAssociations.ConfigurationItemBillingProductAssociationsCount)ConfigurationItemBillingProductAsso…Autotask.ConfigurationItemCategories.ConfigurationItemCategories: itgen_autotask_configurationitemcategories_plural (Autotask.ConfigurationItemCategories.ConfigurationItemCategoriesCount)ConfigurationItemCategoriesAutotask.ConfigurationItemCategoryUdfAssociations.ConfigurationItemCategoryUdfAssociations: itgen_autotask_configurationitemcategoryudfassociations_plural (Autotask.ConfigurationItemCategoryUdfAssociations.ConfigurationItemCategoryUdfAssociationsCount)ConfigurationItemCategoryUdfAssoci…Autotask.ConfigurationItemNoteAttachments.ConfigurationItemNoteAttachments: itgen_autotask_configurationitemnoteattachments_plural (Autotask.ConfigurationItemNoteAttachments.ConfigurationItemNoteAttachmentsCount)ConfigurationItemNoteAttachmentsAutotask.ConfigurationItemNotes.ConfigurationItemNotes: itgen_autotask_configurationitemnotes_plural (Autotask.ConfigurationItemNotes.ConfigurationItemNotesCount)ConfigurationItemNotesAutotask.ConfigurationItemRelatedItems.ConfigurationItemRelatedItems: itgen_autotask_configurationitemrelateditems_plural (Autotask.ConfigurationItemRelatedItems.ConfigurationItemRelatedItemsCount)ConfigurationItemRelatedItemsAutotask.ConfigurationItemSslSubjectAlternativeNames.ConfigurationItemSslSubjectAlternativeNames: itgen_autotask_configurationitemsslsubjectalternativenames_plural (Autotask.ConfigurationItemSslSubjectAlternativeNames.ConfigurationItemSslSubjectAlternativeNamesCount)ConfigurationItemSslSubjectAlternati…Autotask.ConfigurationItemWebhookExcludedResources.ConfigurationItemWebhookExcludedResources: itgen_autotask_configurationitemwebhookexcludedresources_plural (Autotask.ConfigurationItemWebhookExcludedResources.ConfigurationItemWebhookExcludedResourcesCount)ConfigurationItemWebhookExcluded…Autotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItems+_ItemsUserDefinedFieldsAutotask.DomainRegistrars.DomainRegistrars: itgen_autotask_domainregistrars_plural (Autotask.DomainRegistrars.DomainRegistrarsCount)DomainRegistrarsAutotask.SubscriptionPeriods.SubscriptionPeriods: itgen_autotask_subscriptionperiods_plural (Autotask.SubscriptionPeriods.SubscriptionPeriodsCount)SubscriptionPeriodsAutotask.Subscriptions.Subscriptions: itgen_autotask_subscriptions_plural (Autotask.Subscriptions.SubscriptionsCount, Autotask.Subscriptions.Subscriptions_ItemsUserDefinedFields)Subscriptions+_ItemsUserDefinedFieldsAutotask.UserDefinedFieldDefinitions.UserDefinedFieldDefinitions: itgen_autotask_userdefinedfielddefinitions_plural (Autotask.UserDefinedFieldDefinitions.UserDefinedFieldDefinitionsCount)UserDefinedFieldDefinitionsAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesCompanyAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsCompanyAutotask.CompanyNotes.CompanyNotes: itgen_autotask_companynotes_plural (Autotask.CompanyNotes.CompanyNotesCount)CompanyNotesCompanyAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContactAutotask.ContractNotes.ContractNotes: itgen_autotask_contractnotes_plural (Autotask.ContractNotes.ContractNotesCount)ContractNotesContractAutotask.ContractServiceBundles.ContractServiceBundles: itgen_autotask_contractservicebundles_plural (Autotask.ContractServiceBundles.ContractServiceBundlesCount)ContractServiceBundlesContractAutotask.ContractServices.ContractServices: itgen_autotask_contractservices_plural (Autotask.ContractServices.ContractServicesCount)ContractServicesContractAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContractAutotask.Documents.Documents: itgen_autotask_documents_plural (Autotask.Documents.DocumentsCount)DocumentsDocumentAutotask.ExpenseItems.ExpenseItems: itgen_autotask_expenseitems_plural (Autotask.ExpenseItems.ExpenseItemsCount)ExpenseItemsExpenseAutotask.Tickets.TicketsTAutotask.ExpenseReports.ExpenseReports: itgen_autotask_expensereports_plural (Autotask.ExpenseReports.ExpenseReportsCount)ExpenseReportsExpenseAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesCompanyAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProductAutotask.ProjectNotes.ProjectNotes: itgen_autotask_projectnotes_plural (Autotask.ProjectNotes.ProjectNotesCount)ProjectNotesProjectAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjectAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesResourceAutotask.SalesOrders.SalesOrders: itgen_autotask_salesorders_plural (Autotask.SalesOrders.SalesOrdersCount, Autotask.SalesOrders.SalesOrders_ItemsUserDefinedFields)SalesOrdersCompanyAutotask.ServiceBundles.ServiceBundles: itgen_autotask_servicebundles_plural (Autotask.ServiceBundles.ServiceBundlesCount)ServiceBundlesServiceAutotask.Services.Services: itgen_autotask_services_plural (Autotask.Services.ServicesCount)ServicesServiceAutotask.TaskNotes.TaskNotes: itgen_autotask_tasknotes_plural (Autotask.TaskNotes.TaskNotesCount)TaskNotesTaskAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTaskAutotask.TicketNotes.TicketNotes: itgen_autotask_ticketnotes_plural (Autotask.TicketNotes.TicketNotesCount)TicketNotesTicketAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTimeAutotask.Tickets.TicketsTContract×2×2×2×2×2Autotask.ChangeOrderCharges.ChangeOrderCharges: itgen_autotask_changeordercharges_plural (Autotask.ChangeOrderCharges.ChangeOrderChargesCount)ChangeOrderChargesAutotask.ContractBillingRules.ContractBillingRules: itgen_autotask_contractbillingrules_plural (Autotask.ContractBillingRules.ContractBillingRulesCount)ContractBillingRulesAutotask.ContractBlockHourFactors.ContractBlockHourFactors: itgen_autotask_contractblockhourfactors_plural (Autotask.ContractBlockHourFactors.ContractBlockHourFactorsCount)ContractBlockHourFactorsAutotask.ContractBlocks.ContractBlocks: itgen_autotask_contractblocks_plural (Autotask.ContractBlocks.ContractBlocksCount)ContractBlocksAutotask.ContractCharges.ContractCharges: itgen_autotask_contractcharges_plural (Autotask.ContractCharges.ContractChargesCount)ContractChargesAutotask.ContractExclusionBillingCodes.ContractExclusionBillingCodes: itgen_autotask_contractexclusionbillingcodes_plural (Autotask.ContractExclusionBillingCodes.ContractExclusionBillingCodesCount)ContractExclusionBillingCodesAutotask.ContractExclusionRoles.ContractExclusionRoles: itgen_autotask_contractexclusionroles_plural (Autotask.ContractExclusionRoles.ContractExclusionRolesCount)ContractExclusionRolesAutotask.ContractExclusionSetExcludedRoles.ContractExclusionSetExcludedRoles: itgen_autotask_contractexclusionsetexcludedroles_plural (Autotask.ContractExclusionSetExcludedRoles.ContractExclusionSetExcludedRolesCount)ContractExclusionSetExcludedRolesAutotask.ContractExclusionSetExcludedWorkTypes.ContractExclusionSetExcludedWorkTypes: itgen_autotask_contractexclusionsetexcludedworktypes_plural (Autotask.ContractExclusionSetExcludedWorkTypes.ContractExclusionSetExcludedWorkTypesCount)ContractExclusionSetExcludedWorkT…Autotask.ContractExclusionSets.ContractExclusionSets: itgen_autotask_contractexclusionsets_plural (Autotask.ContractExclusionSets.ContractExclusionSetsCount)ContractExclusionSetsAutotask.ContractMilestones.ContractMilestones: itgen_autotask_contractmilestones_plural (Autotask.ContractMilestones.ContractMilestonesCount)ContractMilestonesAutotask.ContractNoteAttachments.ContractNoteAttachments: itgen_autotask_contractnoteattachments_plural (Autotask.ContractNoteAttachments.ContractNoteAttachmentsCount)ContractNoteAttachmentsAutotask.ContractNotes.ContractNotes: itgen_autotask_contractnotes_plural (Autotask.ContractNotes.ContractNotesCount)ContractNotesAutotask.ContractRates.ContractRates: itgen_autotask_contractrates_plural (Autotask.ContractRates.ContractRatesCount)ContractRatesAutotask.ContractRetainers.ContractRetainers: itgen_autotask_contractretainers_plural (Autotask.ContractRetainers.ContractRetainersCount)ContractRetainersAutotask.ContractRoleCosts.ContractRoleCosts: itgen_autotask_contractrolecosts_plural (Autotask.ContractRoleCosts.ContractRoleCostsCount)ContractRoleCostsAutotask.ContractServiceBundleUnits.ContractServiceBundleUnits: itgen_autotask_contractservicebundleunits_plural (Autotask.ContractServiceBundleUnits.ContractServiceBundleUnitsCount)ContractServiceBundleUnitsAutotask.ContractServiceBundles.ContractServiceBundles: itgen_autotask_contractservicebundles_plural (Autotask.ContractServiceBundles.ContractServiceBundlesCount)ContractServiceBundlesAutotask.ContractServiceUnits.ContractServiceUnits: itgen_autotask_contractserviceunits_plural (Autotask.ContractServiceUnits.ContractServiceUnitsCount)ContractServiceUnitsAutotask.ContractServices.ContractServices: itgen_autotask_contractservices_plural (Autotask.ContractServices.ContractServicesCount)ContractServicesAutotask.ContractTicketPurchases.ContractTicketPurchases: itgen_autotask_contractticketpurchases_plural (Autotask.ContractTicketPurchases.ContractTicketPurchasesCount)ContractTicketPurchasesAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)Contracts+_ItemsUserDefinedFieldsAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesAutotask.BillingCodes.BillingCodes: itgen_autotask_billingcodes_plural (Autotask.BillingCodes.BillingCodesCount)BillingCodesBillingAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesCompanyAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContactAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesCompanyAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProductAutotask.QuoteItems.QuoteItems: itgen_autotask_quoteitems_plural (Autotask.QuoteItems.QuoteItemsCount)QuoteItemsQuoteAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesResourceAutotask.ServiceBundles.ServiceBundles: itgen_autotask_servicebundles_plural (Autotask.ServiceBundles.ServiceBundlesCount)ServiceBundlesServiceAutotask.Services.Services: itgen_autotask_services_plural (Autotask.Services.ServicesCount)ServicesServiceAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTaskCompany×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2Autotask.ComanagedAssociations.ComanagedAssociations: itgen_autotask_comanagedassociations_plural (Autotask.ComanagedAssociations.ComanagedAssociationsCount)ComanagedAssociationsAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)Companies+_ItemsUserDefinedFieldsAutotask.CompanyAlerts.CompanyAlerts: itgen_autotask_companyalerts_plural (Autotask.CompanyAlerts.CompanyAlertsCount)CompanyAlertsAutotask.CompanyAttachments.CompanyAttachments: itgen_autotask_companyattachments_plural (Autotask.CompanyAttachments.CompanyAttachmentsCount)CompanyAttachmentsAutotask.CompanyCategories.CompanyCategories: itgen_autotask_companycategories_plural (Autotask.CompanyCategories.CompanyCategoriesCount)CompanyCategoriesAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsAutotask.CompanyNoteAttachments.CompanyNoteAttachments: itgen_autotask_companynoteattachments_plural (Autotask.CompanyNoteAttachments.CompanyNoteAttachmentsCount)CompanyNoteAttachmentsAutotask.CompanyNotes.CompanyNotes: itgen_autotask_companynotes_plural (Autotask.CompanyNotes.CompanyNotesCount)CompanyNotesAutotask.CompanySiteConfigurations.CompanySiteConfigurations: itgen_autotask_companysiteconfigurations_plural (Autotask.CompanySiteConfigurations.CompanySiteConfigurationsCount, Autotask.CompanySiteConfigurations.CompanySiteConfigurations_ItemsUserDefinedFields)CompanySiteConfigurations+_ItemsUserDefinedFieldsAutotask.CompanyTeams.CompanyTeams: itgen_autotask_companyteams_plural (Autotask.CompanyTeams.CompanyTeamsCount)CompanyTeamsAutotask.CompanyToDos.CompanyToDos: itgen_autotask_companytodos_plural (Autotask.CompanyToDos.CompanyToDosCount)CompanyToDosAutotask.Tickets.TicketsTAutotask.CompanyWebhookExcludedResources.CompanyWebhookExcludedResources: itgen_autotask_companywebhookexcludedresources_plural (Autotask.CompanyWebhookExcludedResources.CompanyWebhookExcludedResourcesCount)CompanyWebhookExcludedResourcesAutotask.Countries.Countries: itgen_autotask_countries_plural (Autotask.Countries.CountriesCount)CountriesAutotask.HolidaySets.HolidaySets: itgen_autotask_holidaysets_plural (Autotask.HolidaySets.HolidaySetsCount)HolidaySetsAutotask.Holidays.Holidays: itgen_autotask_holidays_plural (Autotask.Holidays.HolidaysCount)HolidaysAutotask.InternalLocationWithBusinessHours.InternalLocationWithBusinessHours: itgen_autotask_internallocationwithbusinesshours_plural (Autotask.InternalLocationWithBusinessHours.InternalLocationWithBusinessHoursCount)InternalLocationWithBusinessHoursAutotask.InternalLocations.InternalLocations: itgen_autotask_internallocations_plural (Autotask.InternalLocations.InternalLocationsCount)InternalLocationsAutotask.InvoiceTemplates.InvoiceTemplates: itgen_autotask_invoicetemplates_plural (Autotask.InvoiceTemplates.InvoiceTemplatesCount)InvoiceTemplatesAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)Opportunities+_ItemsUserDefinedFieldsAutotask.OpportunityAttachments.OpportunityAttachments: itgen_autotask_opportunityattachments_plural (Autotask.OpportunityAttachments.OpportunityAttachmentsCount)OpportunityAttachmentsAutotask.SalesOrderAttachments.SalesOrderAttachments: itgen_autotask_salesorderattachments_plural (Autotask.SalesOrderAttachments.SalesOrderAttachmentsCount)SalesOrderAttachmentsAutotask.SalesOrders.SalesOrders: itgen_autotask_salesorders_plural (Autotask.SalesOrders.SalesOrdersCount, Autotask.SalesOrders.SalesOrders_ItemsUserDefinedFields)SalesOrders+_ItemsUserDefinedFieldsAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContactAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContractAutotask.Currencies.Currencies: itgen_autotask_currencies_plural (Autotask.Currencies.CurrenciesCount)CurrenciesPriceAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProductAutotask.QuoteTemplates.QuoteTemplates: itgen_autotask_quotetemplates_plural (Autotask.QuoteTemplates.QuoteTemplatesCount)QuoteTemplatesQuoteAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesResourceAutotask.TaxRegions.TaxRegions: itgen_autotask_taxregions_plural (Autotask.TaxRegions.TaxRegionsCount)TaxRegionsTaxAutotask.Taxes.Taxes: itgen_autotask_taxes_plural (Autotask.Taxes.TaxesCount)TaxesTaxTicket×2×2×2×2×2×2×2×2×2×2×2Autotask.ChecklistLibraries.ChecklistLibraries: itgen_autotask_checklistlibraries_plural (Autotask.ChecklistLibraries.ChecklistLibrariesCount)ChecklistLibrariesAutotask.ChecklistLibraryChecklistItems.ChecklistLibraryChecklistItems: itgen_autotask_checklistlibrarychecklistitems_plural (Autotask.ChecklistLibraryChecklistItems.ChecklistLibraryChecklistItemsCount)ChecklistLibraryChecklistItemsAutotask.KnowledgeBaseArticles.KnowledgeBaseArticles: itgen_autotask_knowledgebasearticles_plural (Autotask.KnowledgeBaseArticles.KnowledgeBaseArticlesCount)KnowledgeBaseArticlesAutotask.TicketAdditionalConfigurationItems.TicketAdditionalConfigurationItems: itgen_autotask_ticketadditionalconfigurationitems_plural (Autotask.TicketAdditionalConfigurationItems.TicketAdditionalConfigurationItemsCount)TicketAdditionalConfigurationItemsAutotask.TicketAdditionalContacts.TicketAdditionalContacts: itgen_autotask_ticketadditionalcontacts_plural (Autotask.TicketAdditionalContacts.TicketAdditionalContactsCount)TicketAdditionalContactsAutotask.TicketAttachments.TicketAttachments: itgen_autotask_ticketattachments_plural (Autotask.TicketAttachments.TicketAttachmentsCount)TicketAttachmentsAutotask.TicketCategories.TicketCategories: itgen_autotask_ticketcategories_plural (Autotask.TicketCategories.TicketCategoriesCount)TicketCategoriesAutotask.TicketCategoryFieldDefaults.TicketCategoryFieldDefaults: itgen_autotask_ticketcategoryfielddefaults_plural (Autotask.TicketCategoryFieldDefaults.TicketCategoryFieldDefaultsCount)TicketCategoryFieldDefaultsAutotask.TicketChangeRequestApprovals.TicketChangeRequestApprovals: itgen_autotask_ticketchangerequestapprovals_plural (Autotask.TicketChangeRequestApprovals.TicketChangeRequestApprovalsCount)TicketChangeRequestApprovalsAutotask.TicketCharges.TicketCharges: itgen_autotask_ticketcharges_plural (Autotask.TicketCharges.TicketChargesCount)TicketChargesAutotask.TicketChecklistItems.TicketChecklistItems: itgen_autotask_ticketchecklistitems_plural (Autotask.TicketChecklistItems.TicketChecklistItemsCount)TicketChecklistItemsAutotask.TicketNoteAttachments.TicketNoteAttachments: itgen_autotask_ticketnoteattachments_plural (Autotask.TicketNoteAttachments.TicketNoteAttachmentsCount)TicketNoteAttachmentsAutotask.TicketNoteWebhookExcludedResources.TicketNoteWebhookExcludedResources: itgen_autotask_ticketnotewebhookexcludedresources_plural (Autotask.TicketNoteWebhookExcludedResources.TicketNoteWebhookExcludedResourcesCount)TicketNoteWebhookExcludedResourc…Autotask.TicketNotes.TicketNotes: itgen_autotask_ticketnotes_plural (Autotask.TicketNotes.TicketNotesCount)TicketNotesAutotask.TicketRmaCredits.TicketRmaCredits: itgen_autotask_ticketrmacredits_plural (Autotask.TicketRmaCredits.TicketRmaCreditsCount)TicketRmaCreditsAutotask.TicketSecondaryResources.TicketSecondaryResources: itgen_autotask_ticketsecondaryresources_plural (Autotask.TicketSecondaryResources.TicketSecondaryResourcesCount)TicketSecondaryResourcesAutotask.TicketTagAssociations.TicketTagAssociations: itgen_autotask_tickettagassociations_plural (Autotask.TicketTagAssociations.TicketTagAssociationsCount)TicketTagAssociationsAutotask.TicketWebhookExcludedResources.TicketWebhookExcludedResources: itgen_autotask_ticketwebhookexcludedresources_plural (Autotask.TicketWebhookExcludedResources.TicketWebhookExcludedResourcesCount)TicketWebhookExcludedResourcesAutotask.Tickets.Tickets: itgen_autotask_tickets_plural (Autotask.Tickets.TicketsCount, Autotask.Tickets.Tickets_ItemsUserDefinedFields)Tickets+_ItemsUserDefinedFieldsAutotask.BillingCodes.BillingCodes: itgen_autotask_billingcodes_plural (Autotask.BillingCodes.BillingCodesCount)BillingCodesBillingAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesCompanyAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsCompanyAutotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItemsConfigurationAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContactAutotask.ContractServiceBundles.ContractServiceBundles: itgen_autotask_contractservicebundles_plural (Autotask.ContractServiceBundles.ContractServiceBundlesCount)ContractServiceBundlesContractAutotask.ContractServices.ContractServices: itgen_autotask_contractservices_plural (Autotask.ContractServices.ContractServicesCount)ContractServicesContractAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContractAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesCompanyAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProductAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjectAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesResourceAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContractAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsTagAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTimeAutotask.Tickets.TicketsTBillingAutotask.BillingCodes.BillingCodes: itgen_autotask_billingcodes_plural (Autotask.BillingCodes.BillingCodesCount)BillingCodesAutotask.BillingItemApprovalLevels.BillingItemApprovalLevels: itgen_autotask_billingitemapprovallevels_plural (Autotask.BillingItemApprovalLevels.BillingItemApprovalLevelsCount)BillingItemApprovalLevelsAutotask.BillingItems.BillingItems: itgen_autotask_billingitems_plural (Autotask.BillingItems.BillingItemsCount)BillingItemsAutotask.Tickets.TicketsTAutotask.Invoices.Invoices: itgen_autotask_invoices_plural (Autotask.Invoices.InvoicesCount)InvoicesAutotask.ShippingTypes.ShippingTypes: itgen_autotask_shippingtypes_plural (Autotask.ShippingTypes.ShippingTypesCount)ShippingTypesAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesCompanyAutotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItemsConfigurationAutotask.ContractCharges.ContractCharges: itgen_autotask_contractcharges_plural (Autotask.ContractCharges.ContractChargesCount)ContractChargesContractAutotask.ContractServiceBundles.ContractServiceBundles: itgen_autotask_contractservicebundles_plural (Autotask.ContractServiceBundles.ContractServiceBundlesCount)ContractServiceBundlesContractAutotask.ContractServices.ContractServices: itgen_autotask_contractservices_plural (Autotask.ContractServices.ContractServicesCount)ContractServicesContractAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContractAutotask.ExpenseItems.ExpenseItems: itgen_autotask_expenseitems_plural (Autotask.ExpenseItems.ExpenseItemsCount)ExpenseItemsExpenseAutotask.Tickets.TicketsTAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.ProjectCharges.ProjectCharges: itgen_autotask_projectcharges_plural (Autotask.ProjectCharges.ProjectChargesCount)ProjectChargesProjectAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjectAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContractAutotask.ServiceBundles.ServiceBundles: itgen_autotask_servicebundles_plural (Autotask.ServiceBundles.ServiceBundlesCount)ServiceBundlesServiceAutotask.Services.Services: itgen_autotask_services_plural (Autotask.Services.ServicesCount)ServicesServiceAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTaskAutotask.TaxCategories.TaxCategories: itgen_autotask_taxcategories_plural (Autotask.TaxCategories.TaxCategoriesCount)TaxCategoriesTaxAutotask.TicketCharges.TicketCharges: itgen_autotask_ticketcharges_plural (Autotask.TicketCharges.TicketChargesCount)TicketChargesTicketAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTimeAutotask.Tickets.TicketsTDocumentAutotask.DocumentAttachments.DocumentAttachments: itgen_autotask_documentattachments_plural (Autotask.DocumentAttachments.DocumentAttachmentsCount)DocumentAttachmentsAutotask.DocumentCategories.DocumentCategories: itgen_autotask_documentcategories_plural (Autotask.DocumentCategories.DocumentCategoriesCount)DocumentCategoriesAutotask.DocumentChecklistItems.DocumentChecklistItems: itgen_autotask_documentchecklistitems_plural (Autotask.DocumentChecklistItems.DocumentChecklistItemsCount)DocumentChecklistItemsAutotask.DocumentConfigurationItemAssociations.DocumentConfigurationItemAssociations: itgen_autotask_documentconfigurationitemassociations_plural (Autotask.DocumentConfigurationItemAssociations.DocumentConfigurationItemAssociationsCount)DocumentConfigurationItemAssociati…Autotask.DocumentConfigurationItemCategoryAssociations.DocumentConfigurationItemCategoryAssociations: itgen_autotask_documentconfigurationitemcategoryassociations_plural (Autotask.DocumentConfigurationItemCategoryAssociations.DocumentConfigurationItemCategoryAssociationsCount)DocumentConfigurationItemCategor…Autotask.DocumentNotes.DocumentNotes: itgen_autotask_documentnotes_plural (Autotask.DocumentNotes.DocumentNotesCount)DocumentNotesAutotask.DocumentTagAssociations.DocumentTagAssociations: itgen_autotask_documenttagassociations_plural (Autotask.DocumentTagAssociations.DocumentTagAssociationsCount)DocumentTagAssociationsAutotask.DocumentTicketAssociations.DocumentTicketAssociations: itgen_autotask_documentticketassociations_plural (Autotask.DocumentTicketAssociations.DocumentTicketAssociationsCount)DocumentTicketAssociationsAutotask.Tickets.TicketsTAutotask.DocumentToArticleAssociations.DocumentToArticleAssociations: itgen_autotask_documenttoarticleassociations_plural (Autotask.DocumentToArticleAssociations.DocumentToArticleAssociationsCount)DocumentToArticleAssociationsAutotask.DocumentToDocumentAssociations.DocumentToDocumentAssociations: itgen_autotask_documenttodocumentassociations_plural (Autotask.DocumentToDocumentAssociations.DocumentToDocumentAssociationsCount)DocumentToDocumentAssociationsAutotask.Documents.Documents: itgen_autotask_documents_plural (Autotask.Documents.DocumentsCount)DocumentsAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesCompanyAutotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItemsConfigurationAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesCompanyAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsTagTask×2×2×2×2×2Autotask.TaskAttachments.TaskAttachments: itgen_autotask_taskattachments_plural (Autotask.TaskAttachments.TaskAttachmentsCount)TaskAttachmentsAutotask.TaskNoteAttachments.TaskNoteAttachments: itgen_autotask_tasknoteattachments_plural (Autotask.TaskNoteAttachments.TaskNoteAttachmentsCount)TaskNoteAttachmentsAutotask.TaskNotes.TaskNotes: itgen_autotask_tasknotes_plural (Autotask.TaskNotes.TaskNotesCount)TaskNotesAutotask.TaskSecondaryResources.TaskSecondaryResources: itgen_autotask_tasksecondaryresources_plural (Autotask.TaskSecondaryResources.TaskSecondaryResourcesCount)TaskSecondaryResourcesAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)Tasks+_ItemsUserDefinedFieldsAutotask.BillingCodes.BillingCodes: itgen_autotask_billingcodes_plural (Autotask.BillingCodes.BillingCodesCount)BillingCodesBillingAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsCompanyAutotask.Departments.Departments: itgen_autotask_departments_plural (Autotask.Departments.DepartmentsCount)DepartmentsResourceAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesCompanyAutotask.Phases.Phases: itgen_autotask_phases_plural (Autotask.Phases.PhasesCount)PhasesProjectAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjectAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesResourceAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContractAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTimeAutotask.Tickets.TicketsTServiceAutotask.ServiceBundleServices.ServiceBundleServices: itgen_autotask_servicebundleservices_plural (Autotask.ServiceBundleServices.ServiceBundleServicesCount)ServiceBundleServicesAutotask.ServiceBundles.ServiceBundles: itgen_autotask_servicebundles_plural (Autotask.ServiceBundles.ServiceBundlesCount)ServiceBundlesAutotask.ServiceCallTaskResources.ServiceCallTaskResources: itgen_autotask_servicecalltaskresources_plural (Autotask.ServiceCallTaskResources.ServiceCallTaskResourcesCount)ServiceCallTaskResourcesAutotask.ServiceCallTasks.ServiceCallTasks: itgen_autotask_servicecalltasks_plural (Autotask.ServiceCallTasks.ServiceCallTasksCount)ServiceCallTasksAutotask.ServiceCallTicketResources.ServiceCallTicketResources: itgen_autotask_servicecallticketresources_plural (Autotask.ServiceCallTicketResources.ServiceCallTicketResourcesCount)ServiceCallTicketResourcesAutotask.ServiceCallTickets.ServiceCallTickets: itgen_autotask_servicecalltickets_plural (Autotask.ServiceCallTickets.ServiceCallTicketsCount)ServiceCallTicketsAutotask.Tickets.TicketsTAutotask.ServiceCalls.ServiceCalls: itgen_autotask_servicecalls_plural (Autotask.ServiceCalls.ServiceCallsCount)ServiceCallsAutotask.ServiceLevelAgreementResults.ServiceLevelAgreementResults: itgen_autotask_servicelevelagreementresults_plural (Autotask.ServiceLevelAgreementResults.ServiceLevelAgreementResultsCount)ServiceLevelAgreementResultsAutotask.Tickets.TicketsTAutotask.Services.Services: itgen_autotask_services_plural (Autotask.Services.ServicesCount)ServicesAutotask.BillingCodes.BillingCodes: itgen_autotask_billingcodes_plural (Autotask.BillingCodes.BillingCodesCount)BillingCodesBillingAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesCompanyAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsCompanyAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesResourceAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTaskPurchaseAutotask.PurchaseOrderItemReceiving.PurchaseOrderItemReceiving: itgen_autotask_purchaseorderitemreceiving_plural (Autotask.PurchaseOrderItemReceiving.PurchaseOrderItemReceivingCount)PurchaseOrderItemReceivingAutotask.PurchaseOrderItems.PurchaseOrderItems: itgen_autotask_purchaseorderitems_plural (Autotask.PurchaseOrderItems.PurchaseOrderItemsCount)PurchaseOrderItemsAutotask.Tickets.TicketsTAutotask.PurchaseOrders.PurchaseOrders: itgen_autotask_purchaseorders_plural (Autotask.PurchaseOrders.PurchaseOrdersCount)PurchaseOrdersAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContractAutotask.InventoryLocations.InventoryLocations: itgen_autotask_inventorylocations_plural (Autotask.InventoryLocations.InventoryLocationsCount)InventoryLocationsInventoryAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProductAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjectAutotask.SalesOrders.SalesOrders: itgen_autotask_salesorders_plural (Autotask.SalesOrders.SalesOrdersCount, Autotask.SalesOrders.SalesOrders_ItemsUserDefinedFields)SalesOrdersCompanyAutotask.TaxRegions.TaxRegions: itgen_autotask_taxregions_plural (Autotask.TaxRegions.TaxRegionsCount)TaxRegionsTaxArticleAutotask.ArticleAttachments.ArticleAttachments: itgen_autotask_articleattachments_plural (Autotask.ArticleAttachments.ArticleAttachmentsCount)ArticleAttachmentsAutotask.ArticleTagAssociations.ArticleTagAssociations: itgen_autotask_articletagassociations_plural (Autotask.ArticleTagAssociations.ArticleTagAssociationsCount)ArticleTagAssociationsAutotask.ArticleTicketAssociations.ArticleTicketAssociations: itgen_autotask_articleticketassociations_plural (Autotask.ArticleTicketAssociations.ArticleTicketAssociationsCount)ArticleTicketAssociationsAutotask.Tickets.TicketsTAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesCompanyAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsTagAutotaskAutotask is Professional Services Automation (PSA) softwarefrom Datto. Autotask provides a cloud-based PSA platform forbusinesses.NotesThis data model declares no keys yet; the dotted relations are derived from column names.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.Notes1672 objects of technical metadata are left out.TopicsArticle1Billing1Company1Configuration1Contact2Contract1Deleted2Document1Expense2Inventory2Organizational2Price2Product2Project2Purchase1Quote2Resource2Service1Tag2Task1Tax2Ticket1Time2Tables without relations2LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n keys between the same tablesEvery table also exists as Count.Letters: refers to a table used by most topics: T = TicketsGenerated from the metadata of Invantive UniversalSQL 24.1.3-BETA+4689 on 10-06-2024. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/autotask
The poster as text: tables per topic and their relations

Contract

ChangeOrderCharges, ContractBillingRules, ContractBlockHourFactors, ContractBlocks, ContractCharges, ContractExclusionBillingCodes, ContractExclusionRoles, ContractExclusionSetExcludedRoles, ContractExclusionSetExcludedWorkTypes, ContractExclusionSets, ContractMilestones, ContractNoteAttachments, ContractNotes, ContractRates, ContractRetainers, ContractRoleCosts, ContractServiceBundleUnits, ContractServiceBundles, ContractServiceUnits, ContractServices, ContractTicketPurchases, Contracts, Roles

Company

ComanagedAssociations, Companies, CompanyAlerts, CompanyAttachments, CompanyCategories, CompanyLocations, CompanyNoteAttachments, CompanyNotes, CompanySiteConfigurations, CompanyTeams, CompanyToDos, CompanyWebhookExcludedResources, Countries, HolidaySets, Holidays, InternalLocationWithBusinessHours, InternalLocations, InvoiceTemplates, Opportunities, OpportunityAttachments, SalesOrderAttachments, SalesOrders

Ticket

ChecklistLibraries, ChecklistLibraryChecklistItems, KnowledgeBaseArticles, TicketAdditionalConfigurationItems, TicketAdditionalContacts, TicketAttachments, TicketCategories, TicketCategoryFieldDefaults, TicketChangeRequestApprovals, TicketCharges, TicketChecklistItems, TicketNoteAttachments, TicketNoteWebhookExcludedResources, TicketNotes, TicketRmaCredits, TicketSecondaryResources, TicketTagAssociations, TicketWebhookExcludedResources, Tickets

Configuration

AttachmentInfo, ConfigurationItemAttachments, ConfigurationItemBillingProductAssociations, ConfigurationItemCategories, ConfigurationItemCategoryUdfAssociations, ConfigurationItemNoteAttachments, ConfigurationItemNotes, ConfigurationItemRelatedItems, ConfigurationItemSslSubjectAlternativeNames, ConfigurationItemWebhookExcludedResources, ConfigurationItems, DomainRegistrars, SubscriptionPeriods, Subscriptions, UserDefinedFieldDefinitions

Document

DocumentAttachments, DocumentCategories, DocumentChecklistItems, DocumentConfigurationItemAssociations, DocumentConfigurationItemCategoryAssociations, DocumentNotes, DocumentTagAssociations, DocumentTicketAssociations, DocumentToArticleAssociations, DocumentToDocumentAssociations, Documents

Contact

ClientPortalUsers, ContactBillingProductAssociations, ContactGroupContacts, ContactGroups, ContactWebhookExcludedResources, ContactWebhooks, Contacts, SurveyResults, Surveys, WebhookEventErrorLogs

Resource

Appointments, Departments, ResourceAttachments, ResourceRoleDepartments, ResourceRoleQueues, ResourceRoles, ResourceServiceDeskRoles, ResourceSkills, Resources, Skills

Price

Currencies, PriceListMaterialCodes, PriceListProductTiers, PriceListProducts, PriceListRoles, PriceListServiceBundles, PriceListServices, PriceListWorkTypeModifiers, WorkTypeModifiers

Service

ServiceBundleServices, ServiceBundles, ServiceCallTaskResources, ServiceCallTasks, ServiceCallTicketResources, ServiceCallTickets, ServiceCalls, ServiceLevelAgreementResults, Services

Project

NotificationHistory, Phases, ProjectAttachments, ProjectCharges, ProjectNoteAttachments, ProjectNotes, Projects

Inventory

InventoryItemSerialNumbers, InventoryItems, InventoryLocations, InventoryProducts, InventoryStockedItems, InventoryTransfers

Billing

BillingCodes, BillingItemApprovalLevels, BillingItems, Invoices, ShippingTypes

Task

TaskAttachments, TaskNoteAttachments, TaskNotes, TaskSecondaryResources, Tasks

Expense

ExpenseItemAttachments, ExpenseItems, ExpenseReportAttachments, ExpenseReports

Organizational

OrganizationalLevel1s, OrganizationalLevel2s, OrganizationalLevelAssociations, OrganizationalResources

Product

ProductNotes, ProductTiers, ProductVendors, Products

Article

ArticleAttachments, ArticleTagAssociations, ArticleTicketAssociations

Deleted

DeletedTaskActivityLogs, DeletedTicketActivityLogs, DeletedTicketLogs

Purchase

PurchaseOrderItemReceiving, PurchaseOrderItems, PurchaseOrders

Quote

QuoteItems, QuoteTemplates, Quotes

Tag

TagAliases, TagGroups, Tags

Tax

TaxCategories, TaxRegions, Taxes

Time

TimeEntries, TimeEntryAttachments, TimeOffRequests

Action (without relations)

ActionTypes

Additional (without relations)

AdditionalInvoiceFieldValues

Article (without relations)

ArticleConfigurationItemCategoryAssociations, ArticleNotes, ArticlePlainTextContent, ArticleToArticleAssociations, ArticleToDocumentAssociations

Change (without relations)

ChangeRequestLinks

Classification (without relations)

ClassificationIcons

Company (without relations)

CompanyWebhookFields, CompanyWebhookUdfFields, CompanyWebhooks

Configuration (without relations)

ConfigurationItemDnsRecords, ConfigurationItemTypes, ConfigurationItemWebhookFields, ConfigurationItemWebhookUdfFields, ConfigurationItemWebhooks

Contact (without relations)

ContactWebhookFields, ContactWebhookUdfFields

Document (without relations)

DocumentPlainTextContent

Entity (without relations)

EntityInformation

Integration (without relations)

IntegrationVendorInsights, IntegrationVendorWidgets

Knowledge (without relations)

KnowledgeBaseCategories

Module (without relations)

Modules

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Payment (without relations)

PaymentTerms

Purchase (without relations)

PurchaseApprovals

Quote (without relations)

QuoteLocations

Task (without relations)

TaskPredecessors

Threshold (without relations)

ThresholdInformation

Ticket (without relations)

TicketHistoryCount, TicketNoteWebhookFields, TicketNoteWebhooks, TicketWebhookFields, TicketWebhookUdfFields, TicketWebhooks

User (without relations)

UserDefinedFieldListItems

Version (without relations)

Version, VersionInformation

Relations

Tables

Autotask.ActionTypes

Autotask.AdditionalInvoiceFieldValues

Autotask.ApiVersion

Autotask.Appointments

Autotask.ArticleAttachments

Autotask.ArticleAttachmentsChild

Autotask.ArticleConfigurationItemCategoryAssociations

Autotask.ArticleConfigurationItemCategoryAssociationsChild

Autotask.ArticleNotes

Autotask.ArticleNotesChild

Autotask.ArticlePlainTextContent

Autotask.ArticlePlainTextContentChild

Autotask.ArticleTagAssociations

Autotask.ArticleTagAssociationsChild

Autotask.ArticleTicketAssociations

Autotask.ArticleTicketAssociationsChild

Autotask.ArticleToArticleAssociations

Autotask.ArticleToArticleAssociationsChild

Autotask.ArticleToDocumentAssociations

Autotask.ArticleToDocumentAssociationsChild

Autotask.AttachmentInfo

Autotask.AutotaskVersionApiIntegration

  • Version: itgen_autotask_version_plural

Autotask.BillingCodes

Autotask.BillingItemApprovalLevels

Autotask.BillingItems

Autotask.ChangeOrderCharges

Autotask.ChecklistLibraries

Autotask.ChecklistLibraryChecklistItems

Autotask.ChecklistLibraryChecklistItemsChild

Autotask.ClassificationIcons

Autotask.ClientPortalUsers

Autotask.ComanagedAssociations

Autotask.Companies

Autotask.CompanyAlerts

Autotask.CompanyAlertsChild

Autotask.CompanyAttachments

Autotask.CompanyAttachmentsChild

Autotask.CompanyCategories

Autotask.CompanyContactsChild

Autotask.CompanyLocations

Autotask.CompanyLocationsChild

Autotask.CompanyNoteAttachments

Autotask.CompanyNoteAttachmentsChild

Autotask.CompanyNotes

Autotask.CompanyNotesChild

Autotask.CompanySiteConfigurations

Autotask.CompanySiteConfigurationsChild

Autotask.CompanyTeams

Autotask.CompanyTeamsChild

Autotask.CompanyToDos

Autotask.CompanyToDosChild

Autotask.CompanyWebhookExcludedResources

Autotask.CompanyWebhookExcludedResourcesChild

Autotask.CompanyWebhookFields

Autotask.CompanyWebhookFieldsChild

Autotask.CompanyWebhookUdfFields

Autotask.CompanyWebhookUdfFieldsChild

Autotask.CompanyWebhooks

Autotask.ConfigurationItemAttachments

Autotask.ConfigurationItemAttachmentsChild

Autotask.ConfigurationItemBillingProductAssociations

Autotask.ConfigurationItemBillingProductAssociationsChild

Autotask.ConfigurationItemCategories

Autotask.ConfigurationItemCategoryUdfAssociations

Autotask.ConfigurationItemCategoryUdfAssociationsChild

Autotask.ConfigurationItemDnsRecords

Autotask.ConfigurationItemDnsRecordsChild

Autotask.ConfigurationItemNoteAttachments

Autotask.ConfigurationItemNoteAttachmentsChild

Autotask.ConfigurationItemNotes

Autotask.ConfigurationItemNotesChild

Autotask.ConfigurationItemRelatedItems

Autotask.ConfigurationItemRelatedItemsChild

Autotask.ConfigurationItemSslSubjectAlternativeNames

Autotask.ConfigurationItemSslSubjectAlternativeNamesChild

Autotask.ConfigurationItemTypes

Autotask.ConfigurationItemWebhookExcludedResources

Autotask.ConfigurationItemWebhookExcludedResourcesChild

Autotask.ConfigurationItemWebhookFields

Autotask.ConfigurationItemWebhookFieldsChild

Autotask.ConfigurationItemWebhookUdfFields

Autotask.ConfigurationItemWebhookUdfFieldsChild

Autotask.ConfigurationItemWebhooks

Autotask.ConfigurationItems

Autotask.ContactBillingProductAssociations

Autotask.ContactBillingProductAssociationsChild

Autotask.ContactGroupContacts

Autotask.ContactGroupContactsChild

Autotask.ContactGroups

Autotask.ContactWebhookExcludedResources

Autotask.ContactWebhookExcludedResourcesChild

Autotask.ContactWebhookFields

Autotask.ContactWebhookFieldsChild

Autotask.ContactWebhookUdfFields

Autotask.ContactWebhookUdfFieldsChild

Autotask.ContactWebhooks

Autotask.Contacts

Autotask.ContractBillingRules

Autotask.ContractBillingRulesChild

Autotask.ContractBlockHourFactors

Autotask.ContractBlockHourFactorsChild

Autotask.ContractBlocks

Autotask.ContractBlocksChild

Autotask.ContractCharges

Autotask.ContractChargesChild

Autotask.ContractExclusionBillingCodes

Autotask.ContractExclusionBillingCodesChild

Autotask.ContractExclusionRoles

Autotask.ContractExclusionRolesChild

Autotask.ContractExclusionSetExcludedRoles

Autotask.ContractExclusionSetExcludedRolesChild

Autotask.ContractExclusionSetExcludedWorkTypes

Autotask.ContractExclusionSetExcludedWorkTypesChild

Autotask.ContractExclusionSets

Autotask.ContractMilestones

Autotask.ContractMilestonesChild

Autotask.ContractNoteAttachments

Autotask.ContractNoteAttachmentsChild

Autotask.ContractNotes

Autotask.ContractNotesChild

Autotask.ContractRates

Autotask.ContractRatesChild

Autotask.ContractRetainers

Autotask.ContractRetainersChild

Autotask.ContractRoleCosts

Autotask.ContractRoleCostsChild

Autotask.ContractServiceBundleUnits

Autotask.ContractServiceBundleUnitsChild

Autotask.ContractServiceBundles

Autotask.ContractServiceBundlesChild

Autotask.ContractServiceUnits

Autotask.ContractServiceUnitsChild

Autotask.ContractServices

Autotask.ContractServicesChild

Autotask.ContractTicketPurchases

Autotask.ContractTicketPurchasesChild

Autotask.Contracts

Autotask.Countries

Autotask.Currencies

Autotask.DeletedTaskActivityLogs

Autotask.DeletedTicketActivityLogs

Autotask.DeletedTicketLogs

Autotask.Departments

Autotask.DocumentAttachments

Autotask.DocumentAttachmentsChild

Autotask.DocumentCategories

Autotask.DocumentChecklistItems

Autotask.DocumentChecklistItemsChild

Autotask.DocumentConfigurationItemAssociations

Autotask.DocumentConfigurationItemAssociationsChild

Autotask.DocumentConfigurationItemCategoryAssociations

Autotask.DocumentConfigurationItemCategoryAssociationsChild

Autotask.DocumentNotes

Autotask.DocumentNotesChild

Autotask.DocumentPlainTextContent

Autotask.DocumentPlainTextContentChild

Autotask.DocumentTagAssociations

Autotask.DocumentTagAssociationsChild

Autotask.DocumentTicketAssociations

Autotask.DocumentTicketAssociationsChild

Autotask.DocumentToArticleAssociations

Autotask.DocumentToArticleAssociationsChild

Autotask.DocumentToDocumentAssociations

Autotask.DocumentToDocumentAssociationsChild

Autotask.Documents

Autotask.DocumentsChild

Autotask.DomainRegistrars

Autotask.ExpenseItemAttachments

Autotask.ExpenseItemAttachmentsChild

Autotask.ExpenseItems

Autotask.ExpenseItemsChild

Autotask.ExpenseReportAttachments

Autotask.ExpenseReportAttachmentsChild

Autotask.ExpenseReports

Autotask.HolidaySets

Autotask.Holidays

Autotask.HolidaysChild

Autotask.IntegrationVendorInsights

Autotask.IntegrationVendorWidgets

Autotask.InternalLocationWithBusinessHours

Autotask.InternalLocations

Autotask.InventoryItemSerialNumbers

Autotask.InventoryItemSerialNumbersChild

Autotask.InventoryItems

Autotask.InventoryLocations

Autotask.InventoryProducts

Autotask.InventoryStockedItems

Autotask.InventoryStockedItemsChild

Autotask.InventoryTransfers

Autotask.InvoiceMarkupApiIntegration

Autotask.InvoiceTemplates

Autotask.Invoices

Autotask.KnowledgeBaseArticles

Autotask.KnowledgeBaseArticlesChild

Autotask.KnowledgeBaseCategories

Autotask.Metadata

Autotask.MetadataApiIntegration

Autotask.ModuleAccessApiIntegration

  • Modules: itgen_autotask_modules_plural

Autotask.Native

Autotask.NotificationHistory

Autotask.Opportunities

Autotask.OpportunityAttachments

Autotask.OpportunityAttachmentsChild

Autotask.OrganizationalLevel1

Autotask.OrganizationalLevel2

Autotask.OrganizationalLevelAssociation

Autotask.OrganizationalResources

Autotask.OrganizationalResourcesChild

Autotask.PaymentTerms

Autotask.Phases

Autotask.PhasesChild

Autotask.PriceListMaterialCodes

Autotask.PriceListProductTiers

Autotask.PriceListProducts

Autotask.PriceListRoles

Autotask.PriceListServiceBundles

Autotask.PriceListServices

Autotask.PriceListWorkTypeModifiers

Autotask.ProductNotes

Autotask.ProductNotesChild

Autotask.ProductTiers

Autotask.ProductTiersChild

Autotask.ProductVendors

Autotask.ProductVendorsChild

Autotask.Products

Autotask.ProjectAttachments

Autotask.ProjectAttachmentsChild

Autotask.ProjectCharges

Autotask.ProjectChargesChild

Autotask.ProjectNoteAttachments

Autotask.ProjectNoteAttachmentsChild

Autotask.ProjectNotes

Autotask.ProjectNotesChild

Autotask.Projects

Autotask.PurchaseApprovals

Autotask.PurchaseOrderItemReceiving

Autotask.PurchaseOrderItemReceivingChild

Autotask.PurchaseOrderItems

Autotask.PurchaseOrderItemsChild

Autotask.PurchaseOrders

Autotask.QuoteItems

Autotask.QuoteItemsChild

Autotask.QuoteLocations

Autotask.QuoteTemplates

Autotask.Quotes

Autotask.ResourceAttachments

Autotask.ResourceAttachmentsChild

Autotask.ResourceRoleDepartments

Autotask.ResourceRoleDepartmentsChild

Autotask.ResourceRoleQueues

Autotask.ResourceRoleQueuesChild

Autotask.ResourceRoles

Autotask.ResourceRolesChild

Autotask.ResourceServiceDeskRoles

Autotask.ResourceServiceDeskRolesChild

Autotask.ResourceSkills

Autotask.ResourceSkillsChild

Autotask.Resources

Autotask.Roles

  • Roles: itgen_autotask_roles_plural
  • RolesById: itgen_autotask_rolesbyid_plural
  • RolesCount: itgen_autotask_rolescount_plural

Autotask.SalesOrderAttachments

Autotask.SalesOrderAttachmentsChild

Autotask.SalesOrders

Autotask.SalesOrdersChild

Autotask.ServiceBundleServices

Autotask.ServiceBundleServicesChild

Autotask.ServiceBundles

Autotask.ServiceCallTaskResources

Autotask.ServiceCallTaskResourcesChild

Autotask.ServiceCallTasks

Autotask.ServiceCallTasksChild

Autotask.ServiceCallTicketResources

Autotask.ServiceCallTicketResourcesChild

Autotask.ServiceCallTickets

Autotask.ServiceCallTicketsChild

Autotask.ServiceCalls

Autotask.ServiceLevelAgreementResults

Autotask.ServiceLevelAgreementResultsChild

Autotask.Services

Autotask.ShippingTypes

Autotask.Skills

Autotask.SubscriptionPeriods

Autotask.SubscriptionPeriodsChild

Autotask.Subscriptions

Autotask.SurveyResults

Autotask.Surveys

Autotask.TagAliases

Autotask.TagAliasesChild

Autotask.TagGroups

Autotask.Tags

  • Tags: itgen_autotask_tags_plural
  • TagsById: itgen_autotask_tagsbyid_plural
  • TagsCount: itgen_autotask_tagscount_plural

Autotask.TaskAttachments

Autotask.TaskAttachmentsChild

Autotask.TaskNoteAttachments

Autotask.TaskNoteAttachmentsChild

Autotask.TaskNotes

Autotask.TaskNotesChild

Autotask.TaskPredecessors

Autotask.TaskPredecessorsChild

Autotask.TaskSecondaryResources

Autotask.TaskSecondaryResourcesChild

Autotask.Tasks

Autotask.TasksChild

Autotask.TaxCategories

Autotask.TaxRegions

Autotask.Taxes

  • Taxes: itgen_autotask_taxes_plural
  • TaxesById: itgen_autotask_taxesbyid_plural
  • TaxesCount: itgen_autotask_taxescount_plural

Autotask.ThresholdApiIntegration

Autotask.TicketAdditionalConfigurationItems

Autotask.TicketAdditionalConfigurationItemsChild

Autotask.TicketAdditionalContacts

Autotask.TicketAdditionalContactsChild

Autotask.TicketAttachments

Autotask.TicketAttachmentsChild

Autotask.TicketCategories

Autotask.TicketCategoryFieldDefaults

Autotask.TicketCategoryFieldDefaultsChild

Autotask.TicketChangeRequestApprovals

Autotask.TicketChangeRequestApprovalsChild

Autotask.TicketCharges

Autotask.TicketChargesChild

Autotask.TicketChecklistItems

Autotask.TicketChecklistItemsChild

Autotask.TicketHistory

Autotask.TicketNoteAttachments

Autotask.TicketNoteAttachmentsChild

Autotask.TicketNoteWebhookExcludedResources

Autotask.TicketNoteWebhookExcludedResourcesChild

Autotask.TicketNoteWebhookFields

Autotask.TicketNoteWebhookFieldsChild

Autotask.TicketNoteWebhooks

Autotask.TicketNotes

Autotask.TicketNotesChild

Autotask.TicketRmaCredits

Autotask.TicketRmaCreditsChild

Autotask.TicketSecondaryResources

Autotask.TicketSecondaryResourcesChild

Autotask.TicketTagAssociations

Autotask.TicketTagAssociationsChild

Autotask.TicketWebhookExcludedResources

Autotask.TicketWebhookExcludedResourcesChild

Autotask.TicketWebhookFields

Autotask.TicketWebhookFieldsChild

Autotask.TicketWebhookUdfFields

Autotask.TicketWebhookUdfFieldsChild

Autotask.TicketWebhooks

Autotask.Tickets

Autotask.TimeEntries

Autotask.TimeEntryAttachments

Autotask.TimeEntryAttachmentsChild

Autotask.TimeOffRequests

Autotask.TimeOffRequestsChild

Autotask.UserDefinedFieldDefinitions

Autotask.UserDefinedFieldListItems

Autotask.UserDefinedFieldListItemsChild

Autotask.WebhookEventErrorLogs

Autotask.WorkTypeModifiers

Autotask.ZoneInformationApiIntegration

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: