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

Modelo de datos REST de Loket.nl

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

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.
  • Una Query puede leer varios datos de empresas a la vez.
  • Los datos se pueden leer y escribir.
  • Planes de Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Idioma de su comunidad de usuarios: neerlandés.

Cifras

Figure Count
Tables 630
Columns 16,991

Póster del Modelo de Datos

Este modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de los nombres de las columnas.

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.

Loket.nl REST Modelo de Datos, Hoja 1 de 1Loket.nl REST Modelo de Datospara su uso con Invantive UniversalSQLComunicado 24.1.3-BETA+4689 · 10-06-2024OtroHoja 1 de 1 · documentation.invantive.euOtroLoketNlRest.Administration.AdministrationsByBearerToken: itgen_loketnl_administrationsbybearertoken_pluralAdministrationsByBearerTokenLoketNlRest.Announcement.AnnouncementsSummaryByBearerToken: itgen_loketnl_announcementssummarybybearertoken_pluralAnnouncementsSummaryByBearer…LoketNlRest.CollectiveAction.CollectiveActionsByBearerToken: itgen_loketnl_collectiveactionsbybearertoken_pluralCollectiveActionsByBearerTokenLoketNlRest.Qwoater.QwoaterEmployersByUser: itgen_loketnl_qwoateremployersbyuser_pluralQwoaterEmployersByUserLoketNlRest.Views.Employers: EmployersEmployersLoketNlRest.Views.Providers: ProvidersProvidersAchmeaLoketNlRest.Views.AchmeaInsuranceContracts: Achmea Insurance ContractsAchmeaInsuranceContractsLoketNlRest.Achmea.AchmeaInsuranceContractsByUserId: itgen_loketnl_achmeainsurancecontractsbyuserid_pluralAchmeaInsuranceContractsByUserIdClienteLoketNlRest.User.ClientsByBearerToken: itgen_loketnl_clientsbybearertoken_pluralClientsByBearerTokenCollectiveLoketNlRest.WageProjection.CollectiveLaborAgreementsByUserId: itgen_loketnl_collectivelaboragreementsbyuserid_pluralCollectiveLaborAgreementsByUserIdConectadoLoketNlRest.ConnectedApplications.ConnectedApplicationsByBearerToken: itgen_loketnl_connectedapplicationsbybearertoken_pluralConnectedApplicationsByBearerTokenDato(s)LoketNlRest.DataNewBusiness.DataNewBusinessFunctions: itgen_loketnl_datanewbusinessfunctions_pluralDataNewBusinessFunctionsLoketNlRest.DataNewBusiness.DataNewBusinessToken: itgen_loketnl_datanewbusinesstoken_pluralDataNewBusinessTokenDescargarLoketNlRest.DownloadRequest.DownloadRequestsByBearerToken: itgen_loketnl_downloadrequestsbybearertoken_pluralDownloadRequestsByBearerTokenEmpleadoLoketNlRest.Views.EmployeeAbsenceProgresses: Employee Absence ProgressesEmployeeAbsenceProgressesLoketNlRest.Views.EmployeeAbsences: Employee AbsencesEmployeeAbsencesLoketNlRest.Views.EmployeeChildren: Employee ChildrenEmployeeChildrenLoketNlRest.Views.EmployeeContacts: Employee ContactsEmployeeContactsLoketNlRest.Views.EmployeeEducations: Employee EducationsEmployeeEducationsLoketNlRest.Views.EmployeeEmployments: Employee EmploymentsEmployeeEmploymentsLoketNlRest.Views.EmployeeOccupationalDisabilities: Employee Occupational DisabilitiesEmployeeOccupationalDisabilitiesLoketNlRest.Views.EmployeePartners: Employee PartnersEmployeePartnersEmpleadorLoketNlRest.Views.EmployerAuthorizations: {res:itgen_loketnl_employer_authorizationsEmployerAuthorizationsLoketNlRest.Views.EmployerCalendarAbsences: Employer Calendar AbsencesEmployerCalendarAbsencesLoketNlRest.Views.EmployerCalendarAvailableHours: Employer Calendar Available HoursEmployerCalendarAvailableHoursLoketNlRest.Views.EmployerCalendarLeaveRequests: Calendar Employer Leave RequestsEmployerCalendarLeaveRequestsLoketNlRest.Views.EmployerCalendarLeaves: Employer Calendar LeavesEmployerCalendarLeavesLoketNlRest.Views.EmployerEmployees: Employer EmployeesEmployerEmployeesLoketNlRest.Views.EmployerEmploymentPayrollPeriodComponents: Employer Employment Payroll Period ComponentsEmployerEmploymentPayrollPeriodComponentsLoketNlRest.Views.EmployerEmploymentPayrollPeriodPayslipComponents: Employer Employment Payroll Period Payslip ComponentsEmployerEmploymentPayrollPeriodPayslipCompon…LoketNlRest.Views.EmployerEmploymentPayrollPeriods: Employer Employment Payroll PeriodsEmployerEmploymentPayrollPeriodsLoketNlRest.Views.EmployerEmployments: Employer EmploymentsEmployerEmploymentsLoketNlRest.LastModifiedVersionNumbers.EmployerLastModifiedVersionNumbersByUser: itgen_loketnl_employerlastmodifiedversionnumbersbyuser_pluralEmployerLastModifiedVersionNumbersByUserLoketNlRest.Views.EmployerModules: Employer ModulesEmployerModulesLoketNlRest.Views.EmployerNotifications: Employer NotificationsEmployerNotificationsLoketNlRest.Views.EmployerPayrollAdministrations: Employer Payroll AdministrationsEmployerPayrollAdministrationsLoketNlRest.Employer.EmployersByUserId: itgen_loketnl_employersbyuserid_pluralEmployersByUserIdLoketNlRest.Employer.EmployersMinimizedByUser: itgen_loketnl_employersminimizedbyuser_pluralEmployersMinimizedByUserEmpleoLoketNlRest.Views.EmploymentCompanyCars: Employment Company CarsEmploymentCompanyCarsLoketNlRest.Views.EmploymentFiscalProperties: Employment Fiscal PropertiesEmploymentFiscalPropertiesLoketNlRest.Views.EmploymentLeaveBalances: Employment Leave BalancesEmploymentLeaveBalancesLoketNlRest.Views.EmploymentLeaves: Employment LeavesEmploymentLeavesLoketNlRest.Views.EmploymentOrganizationalEntities: Employment Organizational EntitiesEmploymentOrganizationalEntitiesLoketNlRest.Views.EmploymentWages: Employment WagesEmploymentWagesLoketNlRest.Views.EmploymentWorkingHours: Employment Working HoursEmploymentWorkingHoursInitiatedLoketNlRest.Workflows.InitiatedWorkflowAllowedTransitionTransitionssByBearerToken: itgen_loketnl_initiatedworkflowallowedtransitiontransitionssbybearertoken_pluralInitiatedWorkflowAllowedTransitionTransitionssByB…LoketNlRest.Workflows.InitiatedWorkflowAllowedTransitionsByBearerToken: itgen_loketnl_initiatedworkflowallowedtransitionsbybearertoken_pluralInitiatedWorkflowAllowedTransitionsByBearerTokenLoketNlRest.Workflows.InitiatedWorkflowsByBearerToken: itgen_loketnl_initiatedworkflowsbybearertoken_pluralInitiatedWorkflowsByBearerTokenIntegrationLoketNlRest.User.IntegrationsByBearerToken: itgen_loketnl_integrationsbybearertoken_pluralIntegrationsByBearerTokenNATIVEPLATFORMSCALARREQUESTSLoketNlRest.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSNóminaLoketNlRest.Views.PayrollAdministrationJournalRuns: Payroll Administration Journal RunsPayrollAdministrationJournalRunsLoketNlRest.Views.PayrollAdministrationPayrollRunDefaultSets: Payroll Administration Payroll Run Default SetsPayrollAdministrationPayrollRunDefaultSetsLoketNlRest.Views.PayrollAdministrationPayrollRunOverviews: Payroll Administration Payroll Run OverviewsPayrollAdministrationPayrollRunOverviewsLoketNlRest.Views.PayrollAdministrationPayrollRunPaySlips: Payroll Administration Payroll Run PayslipsPayrollAdministrationPayrollRunPaySlipsLoketNlRest.Views.PayrollAdministrationPayrollRunPeriodComponentResults: Payroll Administration Payroll Run Component ResultsPayrollAdministrationPayrollRunPeriodComponent…LoketNlRest.Views.PayrollAdministrationPayrollRunPeriodResults: Payroll Administration Payroll Run ResultsPayrollAdministrationPayrollRunPeriodResultsLoketNlRest.Views.PayrollAdministrationPayrollRunResults: Payroll Administration Payroll Run ResultsPayrollAdministrationPayrollRunResultsLoketNlRest.Views.PayrollAdministrationPayrollRunWageSheetsAsPdf: Payroll Administration Payroll Run Wage SheetsPayrollAdministrationPayrollRunWageSheetsAsPdfLoketNlRest.Views.PayrollAdministrationPayrollRuns: Payroll Administration Payroll RunsPayrollAdministrationPayrollRunsLoketNlRest.Views.PayrollAdministrationTaxReturns: Payroll Administration Tax ReturnsPayrollAdministrationTaxReturnsPayslipLoketNlRest.Views.Payslips: PayslipsPayslipsProveedorLoketNlRest.Provider.ProvidersByUser: itgen_loketnl_providersbyuser_pluralProvidersByUserUsuarioLoketNlRest.User.UserByToken: itgen_loketnl_userbytoken_pluralUserByTokenLoketNlRest.UserFilterSettings.UserFilterSettingsByEmployerId: itgen_loketnl_userfiltersettingsbyemployerid_pluralUserFilterSettingsByEmployerIdLoketNlRest.User.UserPhotoByTokenAsJpeg: itgen_loketnl_userphotobytokenasjpeg_pluralUserPhotoByTokenAsJpegLoketNlRest.User.UserPhotoByTokenAsJpeg1: itgen_loketnl_userphotobytokenasjpeg_pluralUserPhotoByTokenAsJpeg1LoketNlRest.User.UserPhotoByTokenAsPng: itgen_loketnl_userphotobytokenaspng_pluralUserPhotoByTokenAsPngLoket.nl RESTNotasEste modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de losnombres de las columnas.Diccionario 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.TemasOtro1Tablas 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×n: n relations between the same tablesGenerado a partir de los metadatos de Invantive UniversalSQL 24.1.3-BETA+4689 el 10-06-2024. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/loketnl
El póster en forma de texto: tablas por tema y sus relaciones

Otro

AdministrationsByBearerToken, AnnouncementsSummaryByBearerToken, CollectiveActionsByBearerToken, QwoaterEmployersByUser, Employers, Providers

Achmea (sin relaciones)

AchmeaInsuranceContracts, AchmeaInsuranceContractsByUserId

Cliente (sin relaciones)

ClientsByBearerToken

Collective (sin relaciones)

CollectiveLaborAgreementsByUserId

Conectado (sin relaciones)

ConnectedApplicationsByBearerToken

Dato(s) (sin relaciones)

DataNewBusinessFunctions, DataNewBusinessToken

Descargar (sin relaciones)

DownloadRequestsByBearerToken

Empleado (sin relaciones)

EmployeeAbsenceProgresses, EmployeeAbsences, EmployeeChildren, EmployeeContacts, EmployeeEducations, EmployeeEmployments, EmployeeOccupationalDisabilities, EmployeePartners

Empleador (sin relaciones)

EmployerAuthorizations, EmployerCalendarAbsences, EmployerCalendarAvailableHours, EmployerCalendarLeaveRequests, EmployerCalendarLeaves, EmployerEmployees, EmployerEmploymentPayrollPeriodComponents, EmployerEmploymentPayrollPeriodPayslipComponents, EmployerEmploymentPayrollPeriods, EmployerEmployments, EmployerLastModifiedVersionNumbersByUser, EmployerModules, EmployerNotifications, EmployerPayrollAdministrations, EmployersByUserId, EmployersMinimizedByUser

Empleo (sin relaciones)

EmploymentCompanyCars, EmploymentFiscalProperties, EmploymentLeaveBalances, EmploymentLeaves, EmploymentOrganizationalEntities, EmploymentWages, EmploymentWorkingHours

Initiated (sin relaciones)

InitiatedWorkflowAllowedTransitionTransitionssByBearerToken, InitiatedWorkflowAllowedTransitionsByBearerToken, InitiatedWorkflowsByBearerToken

Integration (sin relaciones)

IntegrationsByBearerToken

NATIVEPLATFORMSCALARREQUESTS (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Nómina (sin relaciones)

PayrollAdministrationJournalRuns, PayrollAdministrationPayrollRunDefaultSets, PayrollAdministrationPayrollRunOverviews, PayrollAdministrationPayrollRunPaySlips, PayrollAdministrationPayrollRunPeriodComponentResults, PayrollAdministrationPayrollRunPeriodResults, PayrollAdministrationPayrollRunResults, PayrollAdministrationPayrollRunWageSheetsAsPdf, PayrollAdministrationPayrollRuns, PayrollAdministrationTaxReturns

Payslip (sin relaciones)

Payslips

Proveedor (sin relaciones)

ProvidersByUser

Usuario (sin relaciones)

UserByToken, UserFilterSettingsByEmployerId, UserPhotoByTokenAsJpeg, UserPhotoByTokenAsJpeg1, UserPhotoByTokenAsPng

Relaciones

Tablas

LoketNlRest.AOWDate

LoketNlRest.AbpFunds

LoketNlRest.Absence

LoketNlRest.AbsenceProgress

LoketNlRest.Achmea

LoketNlRest.Reales

LoketNlRest.Address

LoketNlRest.Administración

LoketNlRest.Announcement

LoketNlRest.ApgPensionDeclaration

LoketNlRest.Applicationsets

LoketNlRest.Evaluación

LoketNlRest.AttachmentOfEarnings

LoketNlRest.AuditTrail

LoketNlRest.AuditTrailPayrollRun

LoketNlRest.AuthorizationSets

LoketNlRest.Autorizaciones

LoketNlRest.BaseForCalculation

LoketNlRest.BaseForEmploymentFundCalculation

LoketNlRest.BenefitInKind

LoketNlRest.BenefitInKindType

LoketNlRest.BenefitsAndDeductions

LoketNlRest.BenefitsAndDeductionsImport

LoketNlRest.BillableItem

LoketNlRest.BillableItems

LoketNlRest.Calendar

LoketNlRest.ChamberOfCommerce

LoketNlRest.Child

LoketNlRest.CollectiveAction

LoketNlRest.CompanyCar

LoketNlRest.ConceptEmployee

LoketNlRest.ConceptEmployeeDossier

LoketNlRest.ConceptEmployeeNotes

LoketNlRest.ConceptEmployeeSelfService

LoketNlRest.ConnectedApplications

LoketNlRest.Contacto

LoketNlRest.ContactHistory

LoketNlRest.ContractCode

LoketNlRest.CostPerHour

LoketNlRest.CustomField

LoketNlRest.CustomHoliday

LoketNlRest.CustomNotification

LoketNlRest.DashboardLicenses

LoketNlRest.DataNewBusiness

LoketNlRest.Declaraciones

LoketNlRest.DeclarationsAttachments

LoketNlRest.Departamentos

LoketNlRest.DeviatingAWFContribution

LoketNlRest.DeviatingHourlyWage

LoketNlRest.DocumentManagement

LoketNlRest.DocumentTemplate

LoketNlRest.DossierReport

LoketNlRest.DownloadRequest

LoketNlRest.Education

LoketNlRest.EducationFurtherIndication

LoketNlRest.EducationType

LoketNlRest.EmailIdentities

LoketNlRest.EmailTemplates

LoketNlRest.Emailtemplates

LoketNlRest.Empleado

LoketNlRest.EmployeeBenefits

LoketNlRest.EmployeeCustomField

LoketNlRest.EmployeeNotes

LoketNlRest.EmployeeSelfService

LoketNlRest.Empleador

LoketNlRest.EmployerDashboard

LoketNlRest.EmployerDossier

LoketNlRest.EmployerNotes

LoketNlRest.EmployerReports

LoketNlRest.EmployerUser

LoketNlRest.EmployerUserAuthorizations

LoketNlRest.EmployerUserNotificationSettings

LoketNlRest.Relación laboral

LoketNlRest.EmploymentCustomField

LoketNlRest.EmploymentDossier

LoketNlRest.EmploymentFunds

LoketNlRest.EmploymentNotes

LoketNlRest.EmploymentReports

LoketNlRest.EmploymentTemplate

LoketNlRest.EventNotificationConfiguration

LoketNlRest.ExternalTenant

LoketNlRest.ExternalTenantEmployerUser

LoketNlRest.ExternalTenantProviderUser

LoketNlRest.FiscalCompanyCar

LoketNlRest.FiscalProperties

LoketNlRest.Funciones

LoketNlRest.HealthcareInsuranceAct

LoketNlRest.InitiatePayrollRun

LoketNlRest.JournalAllocation

LoketNlRest.JournalApplication

LoketNlRest.JournalConfiguration

LoketNlRest.JournalProfile

LoketNlRest.JournalRun

LoketNlRest.JournalRunOverview

LoketNlRest.JournalRunResults

LoketNlRest.LastModifiedVersionNumbers

LoketNlRest.Ausencia

LoketNlRest.LeaveBalance

LoketNlRest.LeaveImport

LoketNlRest.LeavePolicy

LoketNlRest.LeavePolicyAccrual

LoketNlRest.LeavePolicyEntitlement

LoketNlRest.LeaveRequest

LoketNlRest.LeaveTypes

LoketNlRest.LinkedDepartments

LoketNlRest.LinkedEmployers

LoketNlRest.LocationService

LoketNlRest.Marketplace

LoketNlRest.ModuleSets

LoketNlRest.Modules

LoketNlRest.NationalHoliday

LoketNlRest.Native

LoketNlRest.NonPayrollAdministration

LoketNlRest.Notificación

LoketNlRest.NotificationSets

LoketNlRest.OccupationalDisability

LoketNlRest.OrganizationalEntity

LoketNlRest.OtherPayrollVariables

LoketNlRest.Partner

LoketNlRest.PawwDeclaration

LoketNlRest.Paygrade

LoketNlRest.PaymentInformation

LoketNlRest.PaymentInformationNon-SEPA

LoketNlRest.PaymentInformationSeparatePayments

LoketNlRest.PayrollAdministration

LoketNlRest.PayrollAdministrationProcessOverview

LoketNlRest.PayrollAdministrationReports

LoketNlRest.PayrollComponentSet

LoketNlRest.PayrollComponents

LoketNlRest.PayrollPeriodData

LoketNlRest.PayrollPeriodDataOnAdministrationLevel

LoketNlRest.PayrollPeriods

LoketNlRest.PayrollProcessStatus

LoketNlRest.PayrollResults

LoketNlRest.PayrollRun

LoketNlRest.PayrollRunDownloads

LoketNlRest.PayrollRunNotes

LoketNlRest.PayrollRunResults

LoketNlRest.PayrollSimulator

LoketNlRest.PayrollTaxReturn

LoketNlRest.PayrollTaxReturnDownloads

LoketNlRest.Payslip

LoketNlRest.PensionBenefit

LoketNlRest.PensionWageStatement

LoketNlRest.Proforma

LoketNlRest.ProtectedEarnings

LoketNlRest.Proveedor

LoketNlRest.ProviderDashboard

LoketNlRest.ProviderLeavePolicy

LoketNlRest.ProviderUser

LoketNlRest.ProviderUserAuthorizations

LoketNlRest.Qwoater

LoketNlRest.SignDocument

LoketNlRest.SocialSecurity

LoketNlRest.SocialSecurityBenefits

LoketNlRest.TransitionCompensation

LoketNlRest.UpaPensionDeclaration

LoketNlRest.Usuario

LoketNlRest.UserClient

LoketNlRest.UserFilterSettings

LoketNlRest.Vistas

LoketNlRest.Wachtgeld

LoketNlRest.Wage

LoketNlRest.WageImport

LoketNlRest.WageProjection

LoketNlRest.WageProposal

LoketNlRest.WorkRelatedCostsScheme

LoketNlRest.WorkflowTemplate

LoketNlRest.WorkflowTrigger

LoketNlRest.WorkflowTriggerMapping

LoketNlRest.Flujos de trabajo

LoketNlRest.WorkingHours

LoketNlRest.Año-endStatement

LoketNlRest.Año-endStatementAtAdministrationLevel

Atributos

Las características de esta plataforma se encuentran en la página Attributes.

Notas de la Versión

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