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

Modèle de données REST Loket.nl

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

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.
  • Une Query peut interroger plusieurs entreprises à la fois.
  • Les données peuvent être aussi bien écrites que lues.
  • Forfaits Invantive Cloud : Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Langue de sa communauté d'utilisateurs : néerlandais.

Chiffres

Figure Count
Tables 630
Columns 16,991

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, 1 feuille 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.

Loket.nl REST Modèle de données, Page 1 sur 1Loket.nl REST Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 24.1.3-BETA+4689 · 10-06-2024AutrePage 1 sur 1 · documentation.invantive.euAutreLoketNlRest.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_pluralAchmeaInsuranceContractsByUserIdClientLoketNlRest.User.ClientsByBearerToken: itgen_loketnl_clientsbybearertoken_pluralClientsByBearerTokenCollectiveLoketNlRest.WageProjection.CollectiveLaborAgreementsByUserId: itgen_loketnl_collectivelaboragreementsbyuserid_pluralCollectiveLaborAgreementsByUserIdConnectéLoketNlRest.ConnectedApplications.ConnectedApplicationsByBearerToken: itgen_loketnl_connectedapplicationsbybearertoken_pluralConnectedApplicationsByBearerTokenDonnéesLoketNlRest.DataNewBusiness.DataNewBusinessFunctions: itgen_loketnl_datanewbusinessfunctions_pluralDataNewBusinessFunctionsLoketNlRest.DataNewBusiness.DataNewBusinessToken: itgen_loketnl_datanewbusinesstoken_pluralDataNewBusinessTokenTéléchargerLoketNlRest.DownloadRequest.DownloadRequestsByBearerToken: itgen_loketnl_downloadrequestsbybearertoken_pluralDownloadRequestsByBearerTokenL’employéLoketNlRest.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 PartnersEmployeePartnersEmployeursLoketNlRest.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_pluralEmployersMinimizedByUserEmploiLoketNlRest.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 RequestsNATIVEPLATFORMSCALARREQUESTSPaieLoketNlRest.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: PayslipsPayslipsFournisseurLoketNlRest.Provider.ProvidersByUser: itgen_loketnl_providersbyuser_pluralProvidersByUserUtilisateurLoketNlRest.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 RESTNotesCe 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.SujetsAutre1Tables sans relations1Lé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: n relations between the same tablesGé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/loketnl
L'affiche sous forme de texte : tableaux par thème et leurs relations

Autre

AdministrationsByBearerToken, AnnouncementsSummaryByBearerToken, CollectiveActionsByBearerToken, QwoaterEmployersByUser, Employers, Providers

Achmea (sans relations)

AchmeaInsuranceContracts, AchmeaInsuranceContractsByUserId

Client (sans relations)

ClientsByBearerToken

Collective (sans relations)

CollectiveLaborAgreementsByUserId

Connecté (sans relations)

ConnectedApplicationsByBearerToken

Données (sans relations)

DataNewBusinessFunctions, DataNewBusinessToken

Télécharger (sans relations)

DownloadRequestsByBearerToken

L’employé (sans relations)

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

Employeurs (sans relations)

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

Emploi (sans relations)

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

Initiated (sans relations)

InitiatedWorkflowAllowedTransitionTransitionssByBearerToken, InitiatedWorkflowAllowedTransitionsByBearerToken, InitiatedWorkflowsByBearerToken

Integration (sans relations)

IntegrationsByBearerToken

NATIVEPLATFORMSCALARREQUESTS (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Paie (sans relations)

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

Payslip (sans relations)

Payslips

Fournisseur (sans relations)

ProvidersByUser

Utilisateur (sans relations)

UserByToken, UserFilterSettingsByEmployerId, UserPhotoByTokenAsJpeg, UserPhotoByTokenAsJpeg1, UserPhotoByTokenAsPng

Relations

Tableaux

LoketNlRest.AOWDate

LoketNlRest.AbpFunds

LoketNlRest.Absence

LoketNlRest.AbsenceProgress

LoketNlRest.Achmea

LoketNlRest.Réel

LoketNlRest.Address

LoketNlRest.Administration

LoketNlRest.Announcement

LoketNlRest.ApgPensionDeclaration

LoketNlRest.Applicationsets

LoketNlRest.Évaluation

LoketNlRest.AttachmentOfEarnings

LoketNlRest.AuditTrail

LoketNlRest.AuditTrailPayrollRun

LoketNlRest.AuthorizationSets

LoketNlRest.Authorizations

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.Contact

LoketNlRest.ContactHistory

LoketNlRest.ContractCode

LoketNlRest.CostPerHour

LoketNlRest.CustomField

LoketNlRest.CustomHoliday

LoketNlRest.CustomNotification

LoketNlRest.DashboardLicenses

LoketNlRest.DataNewBusiness

LoketNlRest.Déclarations

LoketNlRest.DeclarationsAttachments

LoketNlRest.Départements

LoketNlRest.DeviatingAWFContribution

LoketNlRest.DeviatingHourlyWage

LoketNlRest.DocumentManagement

LoketNlRest.DocumentTemplate

LoketNlRest.DossierReport

LoketNlRest.DownloadRequest

LoketNlRest.Education

LoketNlRest.EducationFurtherIndication

LoketNlRest.EducationType

LoketNlRest.EmailIdentities

LoketNlRest.EmailTemplates

LoketNlRest.Modèles d'e-mail

LoketNlRest.Salarié

LoketNlRest.EmployeeBenefits

LoketNlRest.EmployeeCustomField

LoketNlRest.EmployeeNotes

LoketNlRest.EmployeeSelfService

LoketNlRest.Employeur

LoketNlRest.EmployerDashboard

LoketNlRest.EmployerDossier

LoketNlRest.EmployerNotes

LoketNlRest.EmployerReports

LoketNlRest.EmployerUser

LoketNlRest.EmployerUserAuthorizations

LoketNlRest.EmployerUserNotificationSettings

LoketNlRest.Employment

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.Functions

LoketNlRest.HealthcareInsuranceAct

LoketNlRest.InitiatePayrollRun

LoketNlRest.JournalAllocation

LoketNlRest.JournalApplication

LoketNlRest.JournalConfiguration

LoketNlRest.JournalProfile

LoketNlRest.JournalRun

LoketNlRest.JournalRunOverview

LoketNlRest.JournalRunResults

LoketNlRest.LastModifiedVersionNumbers

LoketNlRest.Congé

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.Notification

LoketNlRest.NotificationSets

LoketNlRest.OccupationalDisability

LoketNlRest.OrganizationalEntity

LoketNlRest.OtherPayrollVariables

LoketNlRest.Partner

LoketNlRest.PawwDeclaration

LoketNlRest.Échelle de salaire

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.Bulletin de paie

LoketNlRest.PensionBenefit

LoketNlRest.PensionWageStatement

LoketNlRest.Proforma

LoketNlRest.ProtectedEarnings

LoketNlRest.Provider

LoketNlRest.ProviderDashboard

LoketNlRest.ProviderLeavePolicy

LoketNlRest.ProviderUser

LoketNlRest.ProviderUserAuthorizations

LoketNlRest.Qwoater

LoketNlRest.SignDocument

LoketNlRest.SocialSecurity

LoketNlRest.SocialSecurityBenefits

LoketNlRest.TransitionCompensation

LoketNlRest.UpaPensionDeclaration

LoketNlRest.Utilisateur

LoketNlRest.UserClient

LoketNlRest.UserFilterSettings

LoketNlRest.Views

LoketNlRest.Wachtgeld

LoketNlRest.Salaire

LoketNlRest.WageImport

LoketNlRest.WageProjection

LoketNlRest.WageProposal

LoketNlRest.WorkRelatedCostsScheme

LoketNlRest.WorkflowTemplate

LoketNlRest.WorkflowTrigger

LoketNlRest.WorkflowTriggerMapping

LoketNlRest.Flux de travail

LoketNlRest.WorkingHours

LoketNlRest.Année-endStatement

LoketNlRest.Année-endStatementAtAdministrationLevel

Attributs

Les caractéristiques de cette plateforme sont présentées sur la 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 :