invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Loket.nl REST-datamodel

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

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

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Met één Query kunnen meerdere bedrijven tegelijk worden opgehaald.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • Invantive Cloud-abonnementen: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Taal van de gebruikersgemeenschap: Nederlands.

Cijfers

Figure Count
Tables 630
Columns 16,991

Poster met datamodel

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

PDF, 1 A0-vel

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

Loket.nl REST datamodel, Pagina 1 van 1Loket.nl REST datamodelvoor gebruik met Invantive UniversalSQLRelease 24.1.3-BETA+4689 · 10-06-2024OverigePagina 1 van 1 · documentation.invantive.euOverigeLoketNlRest.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_pluralAchmeaInsuranceContractsByUserIdCliëntLoketNlRest.User.ClientsByBearerToken: itgen_loketnl_clientsbybearertoken_pluralClientsByBearerTokenCollectiveLoketNlRest.WageProjection.CollectiveLaborAgreementsByUserId: itgen_loketnl_collectivelaboragreementsbyuserid_pluralCollectiveLaborAgreementsByUserIdVerbondenLoketNlRest.ConnectedApplications.ConnectedApplicationsByBearerToken: itgen_loketnl_connectedapplicationsbybearertoken_pluralConnectedApplicationsByBearerTokenGegevensLoketNlRest.DataNewBusiness.DataNewBusinessFunctions: itgen_loketnl_datanewbusinessfunctions_pluralDataNewBusinessFunctionsLoketNlRest.DataNewBusiness.DataNewBusinessToken: itgen_loketnl_datanewbusinesstoken_pluralDataNewBusinessTokenDownloadLoketNlRest.DownloadRequest.DownloadRequestsByBearerToken: itgen_loketnl_downloadrequestsbybearertoken_pluralDownloadRequestsByBearerTokenMedewerkerLoketNlRest.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 PartnersEmployeePartnersWerkgeverLoketNlRest.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_pluralEmployersMinimizedByUserDienstverbandLoketNlRest.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 RequestsNATIVEPLATFORMSCALARREQUESTSLonenLoketNlRest.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: PayslipsPayslipsProviderLoketNlRest.Provider.ProvidersByUser: itgen_loketnl_providersbyuser_pluralProvidersByUserGebruikerLoketNlRest.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 RESTNotitiesIn dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties wordenafgeleid uit de namen van de kolommen.DatadictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenOverige1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten×n: n relations between the same tablesGegenereerd op basis van de metagegevens van Invantive UniversalSQL 24.1.3-BETA+4689 op 10-06-2024. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/loketnl
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

Overige

AdministrationsByBearerToken, AnnouncementsSummaryByBearerToken, CollectiveActionsByBearerToken, QwoaterEmployersByUser, Employers, Providers

Achmea (zonder relaties)

AchmeaInsuranceContracts, AchmeaInsuranceContractsByUserId

Cliënt (zonder relaties)

ClientsByBearerToken

Collective (zonder relaties)

CollectiveLaborAgreementsByUserId

Verbonden (zonder relaties)

ConnectedApplicationsByBearerToken

Gegevens (zonder relaties)

DataNewBusinessFunctions, DataNewBusinessToken

Download (zonder relaties)

DownloadRequestsByBearerToken

Medewerker (zonder relaties)

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

Werkgever (zonder relaties)

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

Dienstverband (zonder relaties)

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

Initiated (zonder relaties)

InitiatedWorkflowAllowedTransitionTransitionssByBearerToken, InitiatedWorkflowAllowedTransitionsByBearerToken, InitiatedWorkflowsByBearerToken

Integration (zonder relaties)

IntegrationsByBearerToken

NATIVEPLATFORMSCALARREQUESTS (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Lonen (zonder relaties)

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

Payslip (zonder relaties)

Payslips

Provider (zonder relaties)

ProvidersByUser

Gebruiker (zonder relaties)

UserByToken, UserFilterSettingsByEmployerId, UserPhotoByTokenAsJpeg, UserPhotoByTokenAsJpeg1, UserPhotoByTokenAsPng

Relaties

Tabellen

LoketNlRest.AOWDate

LoketNlRest.AbpFunds

LoketNlRest.Afwezigheid

LoketNlRest.AbsenceProgress

LoketNlRest.Achmea

LoketNlRest.Actuals

LoketNlRest.Address

LoketNlRest.Administration

LoketNlRest.Announcement

LoketNlRest.ApgPensionDeclaration

LoketNlRest.Applicationsets

LoketNlRest.Beoordeling

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

LoketNlRest.DeclarationsAttachments

LoketNlRest.Afdelingen

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

LoketNlRest.EmployeeBenefits

LoketNlRest.EmployeeCustomField

LoketNlRest.EmployeeNotes

LoketNlRest.EmployeeSelfService

LoketNlRest.Werkgever

LoketNlRest.EmployerDashboard

LoketNlRest.EmployerDossier

LoketNlRest.EmployerNotes

LoketNlRest.EmployerReports

LoketNlRest.EmployerUser

LoketNlRest.EmployerUserAuthorizations

LoketNlRest.EmployerUserNotificationSettings

LoketNlRest.Dienstverband

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

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

LoketNlRest.PensionBenefit

LoketNlRest.PensionWageStatement

LoketNlRest.Proforma

LoketNlRest.ProtectedEarnings

LoketNlRest.Aanbieder

LoketNlRest.ProviderDashboard

LoketNlRest.ProviderLeavePolicy

LoketNlRest.ProviderUser

LoketNlRest.ProviderUserAuthorizations

LoketNlRest.Qwoater

LoketNlRest.SignDocument

LoketNlRest.SocialSecurity

LoketNlRest.SocialSecurityBenefits

LoketNlRest.TransitionCompensation

LoketNlRest.UpaPensionDeclaration

LoketNlRest.User

LoketNlRest.UserClient

LoketNlRest.UserFilterSettings

LoketNlRest.Views

LoketNlRest.Wachtgeld

LoketNlRest.Loon

LoketNlRest.WageImport

LoketNlRest.WageProjection

LoketNlRest.WageProposal

LoketNlRest.WorkRelatedCostsScheme

LoketNlRest.WorkflowTemplate

LoketNlRest.WorkflowTrigger

LoketNlRest.WorkflowTriggerMapping

LoketNlRest.Workflows

LoketNlRest.WorkingHours

LoketNlRest.Jaar-endStatement

LoketNlRest.Jaar-endStatementAtAdministrationLevel

Attributen

De kenmerken van dit platform staan op de pagina Attributes.

Release Notes

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