invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Gripp CRM Data Model

Gripp CRM ofrece la gestión de clientes: proyectos, hojas de tiempo y flujos de trabajo.

Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/grippcrm

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su API.
  • Los datos se agrupan por categorías, como por empresa o por administración.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Cifras

Figure Count
Tables 213
Columns 4,194
Tablas con inserciones 1
Tablas con actualización 0
Tablas con la instrucción «DELETE» 0
Tablas documentadas 1

Póster del Modelo de Datos

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Gripp CRM Modelo de Datos, Hoja 1 de 1Gripp CRM Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.3-BETA+6294 · 01-11-2026GrippCrm · Employees · GrippCrm · Contracts · GrippCrm · TimelineEntries · GrippCrm · Offers · GrippCrm · Projects · GrippCrm · Invoices · GrippCrm · PurchaseOr…Hoja 1 de 1 · documentation.invantive.euGrippCrm · Employees×2GrippCrm.GrippCrm.BulkPrices: Bulk PricesBulkPricesGrippCrm.GrippCrm.Companies: CompaniesCompaniesGrippCrm.GrippCrm.CompanyCompanyRoles: Company RolesCompanyCompanyRolesGrippCrm.GrippCrm.CompanyDossierFiles: Company Dossier FilesCompanyDossierFilesGrippCrm.GrippCrm.CompanyDossiers: Company DossiersCompanyDossiersGrippCrm.GrippCrm.CompanyFiles: Company FilesCompanyFilesGrippCrm.GrippCrm.CompanyTags: Company TagsCompanyTagsGrippCrm.GrippCrm.ContactTags: Contact TagsContactTagsGrippCrm.GrippCrm.Contacts: ContactsContactsGrippCrm.GrippCrm.Departments: DepartmentsDepartmentsGrippCrm.GrippCrm.EmployeeFamilies: Employee FamiliesEmployeeFamiliesGrippCrm.GrippCrm.EmployeeTags: Employee TagsEmployeeTagsGrippCrm.GrippCrm.EmployeeTargets: Employee TargetsEmployeeTargetsGrippCrm.GrippCrm.EmployeeYearlyLeaveBudgets: Employee Yearly Leave BudgetsEmployeeYearlyLeaveBudgetsGrippCrm.GrippCrm.Employees: EmployeesEmployeesGrippCrm.GrippCrm.EmploymentContracts: Employment ContractsEmploymentContractsGrippCrm.GrippCrm.Files: FilesFilesGrippCrm.GrippCrm.PriceExceptions: Price ExceptionsPriceExceptionsGrippCrm.GrippCrm.ProductAttachmentsExternal: Product External AttachmentsProductAttachmentsExternalGrippCrm.GrippCrm.ProductAttachmentsInternal: Product Internal AttachmentsProductAttachmentsInternalGrippCrm.GrippCrm.ProductTags: Product TagsProductTagsGrippCrm.GrippCrm.Products: ProductsProductsGrippCrm.GrippCrm.PurchaseInvoiceEmployees: Purchase Invoice EmployeesPurchaseInvoiceEmployeesGrippCrm.GrippCrm.PurchaseInvoiceEmployeesStarred: Purchase Invoice Employees StarredPurchaseInvoiceEmployeesStarredGrippCrm.GrippCrm.PurchaseInvoiceFiles: Purchase Invoice FilesPurchaseInvoiceFilesGrippCrm.GrippCrm.PurchaseInvoicePurchaseInvoiceLines: Purchase Invoice Purchase Invoice LinesPurchaseInvoicePurchaseInvoiceLinesGrippCrm.GrippCrm.PurchaseInvoicePurchasePayments: Purchase Invoice Purchase PaymentsPurchaseInvoicePurchasePaymentsGrippCrm.GrippCrm.PurchaseInvoiceTags: Purchase Invoice TagsPurchaseInvoiceTagsGrippCrm.GrippCrm.PurchaseInvoices: Purchase InvoicesPurchaseInvoicesGrippCrm.GrippCrm.PurchasePayments: Purchase PaymentsPurchasePaymentsGrippCrm.GrippCrm.RevenueTargets: Revenue TargetsRevenueTargetsGrippCrm.GrippCrm.Tags: TagsTagsGrippCrm.GrippCrm.CostHeadings: Cost HeadingsCostHeadingsGrippCrm · ContractsGrippCrm.GrippCrm.Ledgers: LedgersLedgersGrippCrm · ContractsGrippCrm.GrippCrm.TaskTypes: Task TypesTaskTypesGrippCrm · ContractsGrippCrm.GrippCrm.Units: UnitsUnitsGrippCrm · ContractsGrippCrm · ContractsGrippCrm.GrippCrm.ContractContractLines: Contract Contract LinesContractContractLinesGrippCrm.GrippCrm.ContractEmployees: Contract EmployeesContractEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ContractEmployeesStarred: Contract Employees StarredContractEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ContractFiles: Contract FilesContractFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContractLines: Contract LinesContractLinesGrippCrm.GrippCrm.ContractTags: Contract TagsContractTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Contracts: ContractsContractsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.CostHeadings: Cost HeadingsCostHeadingsGrippCrm.GrippCrm.Costs: CostsCostsGrippCrm.GrippCrm.EmployeeSkills: Employee SkillsEmployeeSkillsGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.Hours: HoursHoursGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.InvoiceLines: Invoice LinesInvoiceLinesGrippCrm.GrippCrm.Ledgers: LedgersLedgersGrippCrm.GrippCrm.MemorialLines: Memo Rial LinesMemorialLinesGrippCrm.GrippCrm.MemorialTags: Memo Rial TagsMemorialTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Memorials: MemorialsMemorialsGrippCrm.GrippCrm.OfferProjectLines: Offer Project LinesOfferProjectLinesGrippCrm.GrippCrm.PacketLines: Packet LinesPacketLinesGrippCrm.GrippCrm.PacketPacketLines: Packet Packet LinesPacketPacketLinesGrippCrm.GrippCrm.PacketTags: Packet TagsPacketTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Packets: PacketsPacketsGrippCrm.GrippCrm.PurchaseInvoiceLines: Purchase Invoice LinesPurchaseInvoiceLinesGrippCrm.GrippCrm.PurchaseOrderLines: Purchase Order LinesPurchaseOrderLinesGrippCrm.GrippCrm.TaskCalendarItems: Task Calendar ItemsTaskCalendarItemsGrippCrm.GrippCrm.TaskFiles: Task FilesTaskFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.TaskPhases: Task PhasesTaskPhasesGrippCrm.GrippCrm.TaskTypes: Task TypesTaskTypesGrippCrm.GrippCrm.Tasks: TasksTasksGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.UmbrellaProjectTags: Umbrella Project TagsUmbrellaProjectTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.UmbrellaProjects: Umbrella ProjectsUmbrellaProjectsGrippCrm.GrippCrm.Units: UnitsUnitsGrippCrm.GrippCrm.Invoices: InvoicesInvoicesGrippCrm · InvoicesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Products: ProductsProductsGrippCrm · EmployeesGrippCrm.GrippCrm.Projects: ProjectsProjectsGrippCrm · ProjectsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.PurchaseInvoices: Purchase InvoicesPurchaseInvoicesGrippCrm · EmployeesGrippCrm.GrippCrm.PurchaseOrders: Purchase OrdersPurchaseOrdersGrippCrm · Purchase…GrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm · TimelineEntriesGrippCrm.GrippCrm.CalendarItems: Calendar ItemsCalendarItemsGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.TimelineEntries: Timeline EntriesTimelineEntriesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.TimelineEntryFiles: Timeline Entry FilesTimelineEntryFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.Contracts: ContractsContractsGrippCrm · ContractsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Invoices: InvoicesInvoicesGrippCrm · InvoicesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Offers: OffersOffersGrippCrm · OffersGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Projects: ProjectsProjectsGrippCrm · ProjectsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.PurchaseInvoices: Purchase InvoicesPurchaseInvoicesGrippCrm · EmployeesGrippCrm.GrippCrm.PurchaseOrders: Purchase OrdersPurchaseOrdersGrippCrm · Purchase…GrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Tasks: TasksTasksGrippCrm · ContractsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm · OffersGrippCrm.GrippCrm.OfferEmployees: Offer EmployeesOfferEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.OfferEmployeesStarred: Offer Employees StarredOfferEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.OfferFiles: Offer FilesOfferFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.OfferOfferLines: Offer Offer LinesOfferOfferLinesGrippCrm.GrippCrm.OfferPhases: Offer PhasesOfferPhasesGrippCrm.GrippCrm.OfferTags: Offer TagsOfferTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Offers: OffersOffersGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.UmbrellaProjects: Umbrella ProjectsUmbrellaProjectsGrippCrm · ContractsGrippCrm · ProjectsGrippCrm.GrippCrm.ProjectEmployees: Project EmployeesProjectEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ProjectEmployeesStarred: Project Employees StarredProjectEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.ProjectFiles: Project FilesProjectFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ProjectPhases: Project PhasesProjectPhasesGrippCrm.GrippCrm.ProjectProjectLines: Project Project LinesProjectProjectLinesGrippCrm.GrippCrm.ProjectTags: Project TagsProjectTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Projects: ProjectsProjectsGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.UmbrellaProjects: Umbrella ProjectsUmbrellaProjectsGrippCrm · ContractsGrippCrm · InvoicesGrippCrm.GrippCrm.InvoiceFiles: Invoice FilesInvoiceFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.InvoiceInvoiceLines: Invoice Invoice LinesInvoiceInvoiceLinesGrippCrm.GrippCrm.InvoicePayments: Invoice PaymentsInvoicePaymentsGrippCrm.GrippCrm.InvoiceTags: Invoice TagsInvoiceTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.Invoices: InvoicesInvoicesGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm.GrippCrm.Payments: PaymentsPaymentsGrippCrm · PurchaseOrdersGrippCrm.GrippCrm.PurchaseOrderEmployees: Purchase Order EmployeesPurchaseOrderEmployeesGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.PurchaseOrderEmployeesStarred: Purchase Order Employees StarredPurchaseOrderEmployeesStarredGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.PurchaseOrderFiles: Purchase Order FilesPurchaseOrderFilesGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.PurchaseOrderPurchaseOrderLines: Purchase Order Purchase Order LinesPurchaseOrderPurchaseOrderLinesGrippCrm.GrippCrm.PurchaseOrderTags: Purchase Order TagsPurchaseOrderTagsGrippCrm.GrippCrm.TagsTGrippCrm.GrippCrm.PurchaseOrders: Purchase OrdersPurchaseOrdersGrippCrm.GrippCrm.CompaniesCGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.FilesFGrippCrm.GrippCrm.ContactsOGrippCrm · AbsenceRequestsGrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLines: Absence Request LinesAbsenceRequestAbsenceRequestLinesGrippCrm.GrippCrm.AbsenceRequestLines: Absence Request LinesAbsenceRequestLinesGrippCrm.GrippCrm.AbsenceRequests: Absence RequestsAbsenceRequestsGrippCrm.GrippCrm.EmployeesEGrippCrm.GrippCrm.YearTargetTypes: Year Target TypesYearTargetTypesGrippCrm.GrippCrm.YearTargets: Year TargetsYearTargetsGrippCrmGrippCrm.GrippCrm.CompanyCustomFieldValues: Company Custom Field ValuesCompanyCustomFieldValuesGrippCrm.GrippCrm.ContactCustomFieldValues: Contact Custom Field ValuesContactCustomFieldValuesGrippCrm.GrippCrm.ContractCustomFieldValues: Contract Custom Field ValuesContractCustomFieldValuesGrippCrm.GrippCrm.EmployeeCustomFieldValues: Employee Custom Field ValuesEmployeeCustomFieldValuesGrippCrm.GrippCrm.ExternalLinks: External LinksExternalLinksGrippCrm.GrippCrm.FileContents: File ContentsFileContentsGrippCrm.GrippCrm.InvoiceCustomFieldValues: Invoice Custom Field ValuesInvoiceCustomFieldValuesGrippCrm.GrippCrm.OfferCustomFieldValues: Offer Custom Field ValuesOfferCustomFieldValuesGrippCrm.GrippCrm.ProductCustomFieldValues: Product Custom Field ValuesProductCustomFieldValuesGrippCrm.GrippCrm.ProjectCustomFieldValues: Project Custom Field ValuesProjectCustomFieldValuesGrippCrm.GrippCrm.PurchaseInvoiceCustomFieldValues: Purchase Invoice Custom Field ValuesPurchaseInvoiceCustomFieldValuesGrippCrm.GrippCrm.PurchaseOrderCustomFieldValues: Purchase Order Custom Field ValuesPurchaseOrderCustomFieldValuesGrippCrm.GrippCrm.RejectionReasons: Rejection ReasonsRejectionReasonsGrippCrm.GrippCrm.TaskCustomFieldValues: Task Custom Field ValuesTaskCustomFieldValuesGrippCrm.GrippCrm.UmbrellaProjectCustomFieldValues: Umbrella Project Custom Field ValuesUmbrellaProjectCustomFieldValuesGrippCrm.GrippCrm.Webhooks: WebhooksWebhooksNativeGrippCrm.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSGripp CRMDiccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasGrippCrm · AbsenceRequests1GrippCrm · Contracts1GrippCrm · Employees1GrippCrm · Invoices1GrippCrm · Offers1GrippCrm · Projects1GrippCrm · PurchaseOrders1GrippCrm · TimelineEntries1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes\u00D7n: n claves entre las mismas tablasLetras: se refiere a una tabla que se utiliza en la mayoría de los temas: C = Companies, O = Contacts, E =Employees, F = Files, T = TagsGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.3-BETA+6294 el 01-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/grippcrm
El póster en forma de texto: tablas por tema y sus relaciones

GrippCrm · Employees

BulkPrices, Companies, CompanyCompanyRoles, CompanyDossierFiles, CompanyDossiers, CompanyFiles, CompanyTags, ContactTags, Contacts, Departments, EmployeeFamilies, EmployeeTags, EmployeeTargets, EmployeeYearlyLeaveBudgets, Employees, EmploymentContracts, Files, PriceExceptions, ProductAttachmentsExternal, ProductAttachmentsInternal, ProductTags, Products, PurchaseInvoiceEmployees, PurchaseInvoiceEmployeesStarred, PurchaseInvoiceFiles, PurchaseInvoicePurchaseInvoiceLines, PurchaseInvoicePurchasePayments, PurchaseInvoiceTags, PurchaseInvoices, PurchasePayments, RevenueTargets, Tags

GrippCrm · Contracts

ContractContractLines, ContractEmployees, ContractEmployeesStarred, ContractFiles, ContractLines, ContractTags, Contracts, CostHeadings, Costs, EmployeeSkills, Hours, InvoiceLines, Ledgers, MemorialLines, MemorialTags, Memorials, OfferProjectLines, PacketLines, PacketPacketLines, PacketTags, Packets, PurchaseInvoiceLines, PurchaseOrderLines, TaskCalendarItems, TaskFiles, TaskPhases, TaskTypes, Tasks, UmbrellaProjectTags, UmbrellaProjects, Units

GrippCrm · Offers

OfferEmployees, OfferEmployeesStarred, OfferFiles, OfferOfferLines, OfferPhases, OfferTags, Offers

GrippCrm · Projects

ProjectEmployees, ProjectEmployeesStarred, ProjectFiles, ProjectPhases, ProjectProjectLines, ProjectTags, Projects

GrippCrm · Invoices

InvoiceFiles, InvoiceInvoiceLines, InvoicePayments, InvoiceTags, Invoices, Payments

GrippCrm · PurchaseOrders

PurchaseOrderEmployees, PurchaseOrderEmployeesStarred, PurchaseOrderFiles, PurchaseOrderPurchaseOrderLines, PurchaseOrderTags, PurchaseOrders

GrippCrm · AbsenceRequests

AbsenceRequestAbsenceRequestLines, AbsenceRequestLines, AbsenceRequests, YearTargetTypes, YearTargets

GrippCrm · TimelineEntries

CalendarItems, TimelineEntries, TimelineEntryFiles

GrippCrm (sin relaciones)

CompanyCustomFieldValues, ContactCustomFieldValues, ContractCustomFieldValues, EmployeeCustomFieldValues, ExternalLinks, FileContents, InvoiceCustomFieldValues, OfferCustomFieldValues, ProductCustomFieldValues, ProjectCustomFieldValues, PurchaseInvoiceCustomFieldValues, PurchaseOrderCustomFieldValues, RejectionReasons, TaskCustomFieldValues, UmbrellaProjectCustomFieldValues, Webhooks

Native (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Relaciones

Tablas

GrippCrm.GrippCrm

GrippCrm.Native

Atributos

The attributes of this platform are on the page Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: