invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Autotask Data Model

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

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/autotask

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Les données peuvent être aussi bien écrites que lues.
  • Invantive Cloud plans: Free, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.datto.com/.

Chiffres

Figure Count
Tables 2,609
Columns 38,275

Affiche sur le modèle de données

Ce modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des points sont dérivées des noms de colonnes.

PDF, 2 feuilles A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

Autotask Modèle de données, Page 1 sur 2Autotask Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 24.1.3-BETA+4689 · 10-06-2024Configuration · Contrat · Société · Billet · Facturation · Document · Tâche · Service · Achat · ArticlePage 1 sur 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)CompaniesSociétéAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsSociétéAutotask.CompanyNotes.CompanyNotes: itgen_autotask_companynotes_plural (Autotask.CompanyNotes.CompanyNotesCount)CompanyNotesSociétéAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContatAutotask.ContractNotes.ContractNotes: itgen_autotask_contractnotes_plural (Autotask.ContractNotes.ContractNotesCount)ContractNotesContratAutotask.ContractServiceBundles.ContractServiceBundles: itgen_autotask_contractservicebundles_plural (Autotask.ContractServiceBundles.ContractServiceBundlesCount)ContractServiceBundlesContratAutotask.ContractServices.ContractServices: itgen_autotask_contractservices_plural (Autotask.ContractServices.ContractServicesCount)ContractServicesContratAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContratAutotask.Documents.Documents: itgen_autotask_documents_plural (Autotask.Documents.DocumentsCount)DocumentsDocumentAutotask.ExpenseItems.ExpenseItems: itgen_autotask_expenseitems_plural (Autotask.ExpenseItems.ExpenseItemsCount)ExpenseItemsDépenseAutotask.Tickets.TicketsTAutotask.ExpenseReports.ExpenseReports: itgen_autotask_expensereports_plural (Autotask.ExpenseReports.ExpenseReportsCount)ExpenseReportsDépenseAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesSociétéAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProduitAutotask.ProjectNotes.ProjectNotes: itgen_autotask_projectnotes_plural (Autotask.ProjectNotes.ProjectNotesCount)ProjectNotesProjetAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjetAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesRessourceAutotask.SalesOrders.SalesOrders: itgen_autotask_salesorders_plural (Autotask.SalesOrders.SalesOrdersCount, Autotask.SalesOrders.SalesOrders_ItemsUserDefinedFields)SalesOrdersSociétéAutotask.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)TaskNotesTâcheAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTâcheAutotask.TicketNotes.TicketNotes: itgen_autotask_ticketnotes_plural (Autotask.TicketNotes.TicketNotesCount)TicketNotesBilletAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTempsAutotask.Tickets.TicketsTContrat×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)BillingCodesFacturationAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesSociétéAutotask.Contacts.Contacts: itgen_autotask_contacts_plural (Autotask.Contacts.ContactsCount, Autotask.Contacts.Contacts_ItemsUserDefinedFields)ContactsContatAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesSociétéAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProduitAutotask.QuoteItems.QuoteItems: itgen_autotask_quoteitems_plural (Autotask.QuoteItems.QuoteItemsCount)QuoteItemsQuoteAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesRessourceAutotask.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)TasksTâcheSociété×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)ContactsContatAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContratAutotask.Currencies.Currencies: itgen_autotask_currencies_plural (Autotask.Currencies.CurrenciesCount)CurrenciesPrixAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProduitAutotask.QuoteTemplates.QuoteTemplates: itgen_autotask_quotetemplates_plural (Autotask.QuoteTemplates.QuoteTemplatesCount)QuoteTemplatesQuoteAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesRessourceAutotask.TaxRegions.TaxRegions: itgen_autotask_taxregions_plural (Autotask.TaxRegions.TaxRegionsCount)TaxRegionsTaxeAutotask.Taxes.Taxes: itgen_autotask_taxes_plural (Autotask.Taxes.TaxesCount)TaxesTaxeBillet×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)BillingCodesFacturationAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesSociétéAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsSociétéAutotask.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)ContactsContatAutotask.ContractServiceBundles.ContractServiceBundles: itgen_autotask_contractservicebundles_plural (Autotask.ContractServiceBundles.ContractServiceBundlesCount)ContractServiceBundlesContratAutotask.ContractServices.ContractServices: itgen_autotask_contractservices_plural (Autotask.ContractServices.ContractServicesCount)ContractServicesContratAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContratAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesSociétéAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProduitAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjetAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesRessourceAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContratAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsBaliseAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTempsAutotask.Tickets.TicketsTFacturationAutotask.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)CompaniesSociétéAutotask.ConfigurationItems.ConfigurationItems: itgen_autotask_configurationitems_plural (Autotask.ConfigurationItems.ConfigurationItemsCount, Autotask.ConfigurationItems.ConfigurationItems_ItemsUserDefinedFields)ConfigurationItemsConfigurationAutotask.ContractCharges.ContractCharges: itgen_autotask_contractcharges_plural (Autotask.ContractCharges.ContractChargesCount)ContractChargesContratAutotask.ContractServiceBundles.ContractServiceBundles: itgen_autotask_contractservicebundles_plural (Autotask.ContractServiceBundles.ContractServiceBundlesCount)ContractServiceBundlesContratAutotask.ContractServices.ContractServices: itgen_autotask_contractservices_plural (Autotask.ContractServices.ContractServicesCount)ContractServicesContratAutotask.Contracts.Contracts: itgen_autotask_contracts_plural (Autotask.Contracts.ContractsCount, Autotask.Contracts.Contracts_ItemsUserDefinedFields)ContractsContratAutotask.ExpenseItems.ExpenseItems: itgen_autotask_expenseitems_plural (Autotask.ExpenseItems.ExpenseItemsCount)ExpenseItemsDépenseAutotask.Tickets.TicketsTAutotask.OrganizationalLevelAssociation.OrganizationalLevelAssociations: itgen_autotask_organizationallevelassociations_plural (Autotask.OrganizationalLevelAssociation.OrganizationalLevelAssociationsCount)OrganizationalLevelAssociationsOrganizationalAutotask.ProjectCharges.ProjectCharges: itgen_autotask_projectcharges_plural (Autotask.ProjectCharges.ProjectChargesCount)ProjectChargesProjetAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjetAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContratAutotask.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)TasksTâcheAutotask.TaxCategories.TaxCategories: itgen_autotask_taxcategories_plural (Autotask.TaxCategories.TaxCategoriesCount)TaxCategoriesTaxeAutotask.TicketCharges.TicketCharges: itgen_autotask_ticketcharges_plural (Autotask.TicketCharges.TicketChargesCount)TicketChargesBilletAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTempsAutotask.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)CompaniesSociétéAutotask.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)OpportunitiesSociétéAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsBaliseTâche×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)BillingCodesFacturationAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsSociétéAutotask.Departments.Departments: itgen_autotask_departments_plural (Autotask.Departments.DepartmentsCount)DepartmentsRessourceAutotask.Opportunities.Opportunities: itgen_autotask_opportunities_plural (Autotask.Opportunities.OpportunitiesCount, Autotask.Opportunities.Opportunities_ItemsUserDefinedFields)OpportunitiesSociétéAutotask.Phases.Phases: itgen_autotask_phases_plural (Autotask.Phases.PhasesCount)PhasesProjetAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjetAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesRessourceAutotask.Roles.Roles: itgen_autotask_roles_plural (Autotask.Roles.RolesCount)RolesContratAutotask.TimeEntries.TimeEntries: itgen_autotask_timeentries_plural (Autotask.TimeEntries.TimeEntriesCount)TimeEntriesTempsAutotask.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)BillingCodesFacturationAutotask.Companies.Companies: itgen_autotask_companies_plural (Autotask.Companies.CompaniesCount, Autotask.Companies.Companies_ItemsUserDefinedFields)CompaniesSociétéAutotask.CompanyLocations.CompanyLocations: itgen_autotask_companylocations_plural (Autotask.CompanyLocations.CompanyLocationsCount)CompanyLocationsSociétéAutotask.Resources.Resources: itgen_autotask_resources_plural (Autotask.Resources.ResourcesCount)ResourcesRessourceAutotask.Tasks.Tasks: itgen_autotask_tasks_plural (Autotask.Tasks.TasksCount, Autotask.Tasks.Tasks_ItemsUserDefinedFields)TasksTâcheAchatAutotask.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)ContractsContratAutotask.InventoryLocations.InventoryLocations: itgen_autotask_inventorylocations_plural (Autotask.InventoryLocations.InventoryLocationsCount)InventoryLocationsL'inventaireAutotask.Products.Products: itgen_autotask_products_plural (Autotask.Products.ProductsCount, Autotask.Products.Products_ItemsUserDefinedFields)ProductsProduitAutotask.Projects.Projects: itgen_autotask_projects_plural (Autotask.Projects.ProjectsCount, Autotask.Projects.Projects_ItemsUserDefinedFields)ProjectsProjetAutotask.SalesOrders.SalesOrders: itgen_autotask_salesorders_plural (Autotask.SalesOrders.SalesOrdersCount, Autotask.SalesOrders.SalesOrders_ItemsUserDefinedFields)SalesOrdersSociétéAutotask.TaxRegions.TaxRegions: itgen_autotask_taxregions_plural (Autotask.TaxRegions.TaxRegionsCount)TaxRegionsTaxeArticleAutotask.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)OpportunitiesSociétéAutotask.Tags.Tags: itgen_autotask_tags_plural (Autotask.Tags.TagsCount)TagsBaliseAutotaskAutotask is Professional Services Automation (PSA) softwarefrom Datto. Autotask provides a cloud-based PSA platform forbusinesses.NotesCe modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des pointssont dérivées des noms de colonnes.Dictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.Notes1672 objets de métadonnées techniques sont omis.SujetsAchat1Article1Balise2Billet1Configuration1Contat2Contrat1Dépense2Document1Facturation1L'inventaire2Organizational2Prix2Produit2Projet2Quote2Ressource2Service1Société1Supprimé2Tâche1Taxe2Temps2Tables sans relations2LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes: n clés entre les mêmes tablesChaque table existe également sous la forme Count.Lettres : désigne une table utilisée dans la plupart des rubriques: T = TicketsGénéré à partir des métadonnées d'Invantive UniversalSQL 24.1.3-BETA+4689 le 10-06-2024. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/autotask
L'affiche sous forme de texte : tableaux par thème et leurs relations

Contrat

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

Société

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

Billet

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

Contat

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

Ressource

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

Prix

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

Service

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

Projet

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

L'inventaire

InventoryItemSerialNumbers, InventoryItems, InventoryLocations, InventoryProducts, InventoryStockedItems, InventoryTransfers

Facturation

BillingCodes, BillingItemApprovalLevels, BillingItems, Invoices, ShippingTypes

Tâche

TaskAttachments, TaskNoteAttachments, TaskNotes, TaskSecondaryResources, Tasks

Dépense

ExpenseItemAttachments, ExpenseItems, ExpenseReportAttachments, ExpenseReports

Organizational

OrganizationalLevel1s, OrganizationalLevel2s, OrganizationalLevelAssociations, OrganizationalResources

Produit

ProductNotes, ProductTiers, ProductVendors, Products

Article

ArticleAttachments, ArticleTagAssociations, ArticleTicketAssociations

Supprimé

DeletedTaskActivityLogs, DeletedTicketActivityLogs, DeletedTicketLogs

Achat

PurchaseOrderItemReceiving, PurchaseOrderItems, PurchaseOrders

Quote

QuoteItems, QuoteTemplates, Quotes

Balise

TagAliases, TagGroups, Tags

Taxe

TaxCategories, TaxRegions, Taxes

Temps

TimeEntries, TimeEntryAttachments, TimeOffRequests

Action (sans relations)

ActionTypes

Additional (sans relations)

AdditionalInvoiceFieldValues

Article (sans relations)

ArticleConfigurationItemCategoryAssociations, ArticleNotes, ArticlePlainTextContent, ArticleToArticleAssociations, ArticleToDocumentAssociations

Modifier (sans relations)

ChangeRequestLinks

Classification (sans relations)

ClassificationIcons

Société (sans relations)

CompanyWebhookFields, CompanyWebhookUdfFields, CompanyWebhooks

Configuration (sans relations)

ConfigurationItemDnsRecords, ConfigurationItemTypes, ConfigurationItemWebhookFields, ConfigurationItemWebhookUdfFields, ConfigurationItemWebhooks

Contat (sans relations)

ContactWebhookFields, ContactWebhookUdfFields

Document (sans relations)

DocumentPlainTextContent

Entité (sans relations)

EntityInformation

Integration (sans relations)

IntegrationVendorInsights, IntegrationVendorWidgets

Knowledge (sans relations)

KnowledgeBaseCategories

Module (sans relations)

Modules

NATIVEPLATFORMSCALARREQUESTS (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Payment (sans relations)

PaymentTerms

Achat (sans relations)

PurchaseApprovals

Quote (sans relations)

QuoteLocations

Tâche (sans relations)

TaskPredecessors

Threshold (sans relations)

ThresholdInformation

Billet (sans relations)

TicketHistoryCount, TicketNoteWebhookFields, TicketNoteWebhooks, TicketWebhookFields, TicketWebhookUdfFields, TicketWebhooks

Utilisateur (sans relations)

UserDefinedFieldListItems

Version (sans relations)

Version, VersionInformation

Relations

Tableaux

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

Attributs

The attributes of this platform are on the page Attributes.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :