invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Autotask Data Model

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

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/autotask

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • Invantive Cloud plans: Free, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.datto.com/.

Cijfers

Figure Count
Tables 2,609
Columns 38,275

Poster met datamodel

In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.

PDF, 2 A0-vellen

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Autotask Datamodel, Pagina 1 van 2Autotask Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 24.1.3-BETA+4689 · 10-06-2024Instellingen · Contract · Bedrijf · Ticket · Facturering · Document · Taak · Service · Inkoop · ArtikelPagina 1 van 2 · documentation.invantive.euInstellingen×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)CompaniesBedrijfAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsBedrijfAutotask.CompanyNotes.CompanyNotes: itgen_autotask_companynotes_plural (Autotask.CompanyNotes.CompanyNotesCount)CompanyNotesBedrijfAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContactpersoonAutotask.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)ExpenseItemsUitgaveAutotask.Tickets.TicketsTAutotask.ExpenseReports.ExpenseReports: itgen_autotask_expensereports_plural (Autotask.ExpenseReports.ExpenseReportsCount)ExpenseReportsUitgaveAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesBedrijfAutotask.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)ResourcesBronAutotask.SalesOrders.SalesOrders: itgen_autotask_salesorders_plural (Autotask.SalesOrders.SalesOrdersCount, Autotask.SalesOrders.SalesOrders_ItemsUserDefinedFields)SalesOrdersBedrijfAutotask.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)TaskNotesTaakAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTaakAutotask.TicketNotes.TicketNotes: itgen_autotask_ticketnotes_plural (Autotask.TicketNotes.TicketNotesCount)TicketNotesTicketAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTijdstipAutotask.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)BillingCodesFactureringAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesBedrijfAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContactpersoonAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesBedrijfAutotask.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)ResourcesBronAutotask.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)TasksTaakBedrijf×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)ContactsContactpersoonAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContractAutotask.Currencies.Currencies: itgen_autotask_currencies_plural (Autotask.Currencies.CurrenciesCount)CurrenciesPrijsAutotask.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)ResourcesBronAutotask.TaxRegions.TaxRegions: itgen_autotask_taxregions_plural (Autotask.TaxRegions.TaxRegionsCount)TaxRegionsBelastingAutotask.Taxes.Taxes: itgen_autotask_taxes_plural (Autotask.Taxes.TaxesCount)TaxesBelastingTicket×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)BillingCodesFactureringAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesBedrijfAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsBedrijfAutotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItemsInstellingenAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContactpersoonAutotask.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)OpportunitiesBedrijfAutotask.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)ResourcesBronAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContractAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsLabelAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTijdstipAutotask.Tickets.TicketsTFactureringAutotask.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)CompaniesBedrijfAutotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItemsInstellingenAutotask.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)ExpenseItemsUitgaveAutotask.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)TasksTaakAutotask.TaxCategories.TaxCategories: itgen_autotask_taxcategories_plural (Autotask.TaxCategories.TaxCategoriesCount)TaxCategoriesBelastingAutotask.TicketCharges.TicketCharges: itgen_autotask_ticketcharges_plural (Autotask.TicketCharges.TicketChargesCount)TicketChargesTicketAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTijdstipAutotask.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)CompaniesBedrijfAutotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItemsInstellingenAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesBedrijfAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsLabelTaak×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)BillingCodesFactureringAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsBedrijfAutotask.Departments.Departments: itgen_autotask_departments_plural (Autotask.Departments.DepartmentsCount)DepartmentsBronAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesBedrijfAutotask.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)ResourcesBronAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContractAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTijdstipAutotask.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)BillingCodesFactureringAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesBedrijfAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsBedrijfAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesBronAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTaakInkoopAutotask.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)InventoryLocationsInventarisAutotask.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)SalesOrdersBedrijfAutotask.TaxRegions.TaxRegions: itgen_autotask_taxregions_plural (Autotask.TaxRegions.TaxRegionsCount)TaxRegionsBelastingArtikelAutotask.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)OpportunitiesBedrijfAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsLabelAutotaskAutotask is Professional Services Automation (PSA) softwarefrom Datto. Autotask provides a cloud-based PSA platform forbusinesses.NotitiesIn dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties wordenafgeleid uit de namen van de kolommen.Data DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.Notities1672 objecten met technische metagegevens worden buiten beschouwing gelaten.OnderwerpenArtikel1Bedrijf1Belasting2Bron2Contactpersoon2Contract1Document1Facturering1Inkoop1Instellingen1Inventaris2Label2Organizational2Prijs2Product2Project2Quote2Service1Taak1Ticket1Tijdstip2Uitgave2Verwijderd2Tabeller uden relationen2LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenElke tabel bestaat ook als Count.Brieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: T = TicketsGegenereerd op basis van de metagegevens van Invantive UniversalSQL 24.1.3-BETA+4689 op 10-06-2024. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/autotask
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

Contract

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

Bedrijf

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

Instellingen

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

Contactpersoon

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

Bron

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

Prijs

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

Inventaris

InventoryItemSerialNumbers, InventoryItems, InventoryLocations, InventoryProducts, InventoryStockedItems, InventoryTransfers

Facturering

BillingCodes, BillingItemApprovalLevels, BillingItems, Invoices, ShippingTypes

Taak

TaskAttachments, TaskNoteAttachments, TaskNotes, TaskSecondaryResources, Tasks

Uitgave

ExpenseItemAttachments, ExpenseItems, ExpenseReportAttachments, ExpenseReports

Organizational

OrganizationalLevel1s, OrganizationalLevel2s, OrganizationalLevelAssociations, OrganizationalResources

Product

ProductNotes, ProductTiers, ProductVendors, Products

Artikel

ArticleAttachments, ArticleTagAssociations, ArticleTicketAssociations

Verwijderd

DeletedTaskActivityLogs, DeletedTicketActivityLogs, DeletedTicketLogs

Inkoop

PurchaseOrderItemReceiving, PurchaseOrderItems, PurchaseOrders

Quote

QuoteItems, QuoteTemplates, Quotes

Label

TagAliases, TagGroups, Tags

Belasting

TaxCategories, TaxRegions, Taxes

Tijdstip

TimeEntries, TimeEntryAttachments, TimeOffRequests

Actie (zonder relaties)

ActionTypes

Additional (zonder relaties)

AdditionalInvoiceFieldValues

Artikel (zonder relaties)

ArticleConfigurationItemCategoryAssociations, ArticleNotes, ArticlePlainTextContent, ArticleToArticleAssociations, ArticleToDocumentAssociations

Wijzigen (zonder relaties)

ChangeRequestLinks

Classificatie (zonder relaties)

ClassificationIcons

Bedrijf (zonder relaties)

CompanyWebhookFields, CompanyWebhookUdfFields, CompanyWebhooks

Instellingen (zonder relaties)

ConfigurationItemDnsRecords, ConfigurationItemTypes, ConfigurationItemWebhookFields, ConfigurationItemWebhookUdfFields, ConfigurationItemWebhooks

Contactpersoon (zonder relaties)

ContactWebhookFields, ContactWebhookUdfFields

Document (zonder relaties)

DocumentPlainTextContent

Entiteit (zonder relaties)

EntityInformation

Integration (zonder relaties)

IntegrationVendorInsights, IntegrationVendorWidgets

Knowledge (zonder relaties)

KnowledgeBaseCategories

Module (zonder relaties)

Modules

NATIVEPLATFORMSCALARREQUESTS (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Payment (zonder relaties)

PaymentTerms

Inkoop (zonder relaties)

PurchaseApprovals

Quote (zonder relaties)

QuoteLocations

Taak (zonder relaties)

TaskPredecessors

Threshold (zonder relaties)

ThresholdInformation

Ticket (zonder relaties)

TicketHistoryCount, TicketNoteWebhookFields, TicketNoteWebhooks, TicketWebhookFields, TicketWebhookUdfFields, TicketWebhooks

Gebruiker (zonder relaties)

UserDefinedFieldListItems

Versie (zonder relaties)

Version, VersionInformation

Relaties

Tabellen

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

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: