invantive documentation
Invantive Support ForumsLog In / Sign Up

Nmbrs Data Model

Nmbrs payroll and human resources

Payrolling for both the Dutch as well as Swedish legislation are available. Nmbrs is used by entrepreneurs and accounting firms. Login to the NMBRS API requires an API token. API tokens can enable access to all debtors in NMBRS or solely to one specific debtor as described on https://support.nmbrs.nl/hc/nl/articles/360010686800-Connect-Nmbrs-with-an-API-token. NMBRS allows individual configuration of API access using API templates. Make sure from the Settings menu to check that the Template Users have sufficient API access by pressing on the 'gears' icon of the template associated with the account. Also make sure to apply the template to the NMBRS users.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/nmbrs

The data is partitioned per Company (COMPANY_CODE).

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • One query can read several companies at once.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.nmbrs.com/.
  • Language of its user community: Dutch.

Figures

Figure Count
Tables 209
Columns 1,924
Tables with insert 1
Tables with update 0
Tables with delete 0
Tables documented 1

Data Model Poster

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Nmbrs data model, Sheet 1 of 1Nmbrs data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026EmployeesSheet 1 of 1 · documentation.invantive.euEmployeesNmbrs.Employees.EmployeeContracts: Company Employee ContractsEmployeeContractsNmbrs.Employees.EmployeePersonalInformations: Company Employee Personal InformationEmployeePersonalInformationsNmbrs.Employees.PersonalInformations: Employees Company Employees Personal Information Contract Salary AddressPersonalInformationsCodeValuesNmbrs.CodeValues.ActiveTypes: Domain ActiveTypesActiveTypesNmbrs.CodeValues.AddressTypes: Domain AddressTypesAddressTypesNmbrs.CodeValues.BankAccountTypes: Domain BankAccountTypesBankAccountTypesNmbrs.CodeValues.GenderTypes: Domain GenderTypesGenderTypesNmbrs.CodeValues.LeaveStatuses: Domain LeaveStatusesLeaveStatusesNmbrs.CodeValues.LeaveTypes: Domain LeaveTypesLeaveTypesNmbrs.CodeValues.LeaveUsageTypes: Domain LeaveUsageTypesLeaveUsageTypesNmbrs.CodeValues.PaymentModeTypes: Domain PaymentModeTypesPaymentModeTypesNmbrs.CodeValues.ReservationCalcMethodAgeTypes: Domain ReservationCalcMethodAgeTypesReservationCalcMethodAgeTypesNmbrs.CodeValues.SalaryTypes: Domain SalaryTypesSalaryTypesNmbrs.CodeValues.TimeStatusTypes: Domain TimeStatusTypesTimeStatusTypesCompanyNmbrs.Company.Companies: CompaniesCompaniesNmbrs.Company.CompanyCostCenters: Company Cost CentresCompanyCostCentersNmbrs.Company.CompanyCostUnits: Company Cost UnitsCompanyCostUnitsNmbrs.Company.CompanyCurrentAddresses: Company Current AddressesCompanyCurrentAddressesNmbrs.Company.CompanyCurrentBankAccounts: Company Current Bank AccountsCompanyCurrentBankAccountsNmbrs.Company.CompanyCurrentPeriods: Company Current PeriodsCompanyCurrentPeriodsNmbrs.Company.CompanyCurrentSVWs: Company Current SVWCompanyCurrentSVWsNmbrs.Company.CompanyCurrentSchedules: Company Current ScheduleCompanyCurrentSchedulesNmbrs.Company.CompanyCurrentWageComponentsFixed: Company Current Wage Components FixedCompanyCurrentWageComponentsFixedNmbrs.Company.CompanyCurrentWageComponentsVariable: Company Current Wage Component VarCompanyCurrentWageComponentsVariableNmbrs.Company.CompanyDefaultEmployeeTemplates: Company Default Employee TemplatesCompanyDefaultEmployeeTemplatesNmbrs.Company.CompanyHourCodes: Company Hour CodesCompanyHourCodesNmbrs.Company.CompanyWageCodes: Company Wage CodesCompanyWageCodesDebtorNmbrs.Debtor.Debtors: DebtorsDebtorsEmployeesNmbrs.Employees.CompanySVWs: Company Employee SVWsCompanySVWsNmbrs.Employees.EmployeeAbsences: Employee AbsencesEmployeeAbsencesNmbrs.Employees.EmployeeAddresses: Employee AddressesEmployeeAddressesNmbrs.Employees.EmployeeChildren: Employee ChildrenEmployeeChildrenNmbrs.Employees.EmployeeDepartments: Company Employee DepartmentsEmployeeDepartmentsNmbrs.Employees.EmployeeEmployments: EmploymentsEmployeeEmploymentsNmbrs.Employees.EmployeeFunctions: EmployeesEmployeeFunctionsNmbrs.Employees.EmployeeFunctionsV2: Employees (V2)EmployeeFunctionsV2Nmbrs.Employees.EmployeePartners: Employee PartnersEmployeePartnersNmbrs.Employees.EmployeePerformanceReviews: Performance ReviewsEmployeePerformanceReviewsNmbrs.Employees.EmployeePersonalInfoContractSalaryAddresses: Employees Company Employees Personal Information Contract Salary AddressEmployeePersonalInfoContractSalaryAddressesNmbrs.Employees.EmployeeSalaries: Company Employee SalariesEmployeeSalariesNmbrs.Employees.EmployeeSchedules: Company Employee SchedulesEmployeeSchedulesNmbrs.Employees.EmployeeTypes: Employee TypesEmployeeTypesNmbrs.Employees.EndServiceReasons: End Service ReasonsEndServiceReasonsNativeNmbrs.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSViewsNmbrs.Views.CompanyLast7YearPeriods: Periods (last 7 years)CompanyLast7YearPeriodsNmbrs.Views.CompanyLast7Years: Payroll YearsCompanyLast7YearsNmbrs.Views.CompanyRunCostCenterCostUnits: Company Run Cost Centre Cost UnitsCompanyRunCostCenterCostUnitsNmbrs.Views.CompanyRunCostCenters: Company Run Cost CentersCompanyRunCostCentersNmbrs.Views.CompanyRunCostCentersV2: Company Run Cost Centers V 2CompanyRunCostCentersV2Nmbrs.Views.CompanyRunDepartments: Company Run DepartmentsCompanyRunDepartmentsNmbrs.Views.CompanyRunDepartmentsV2: Company Run Departments V 2CompanyRunDepartmentsV2Nmbrs.Views.CompanyRunEmployees: Company Run EmployeesCompanyRunEmployeesNmbrs.Views.CompanyRunEmployeesV2: Company Run Employees V 2CompanyRunEmployeesV2Nmbrs.Views.CompanyRunJournalHeaders: Company Run Journal HeadersCompanyRunJournalHeadersNmbrs.Views.CompanyRunJournalLines: Company Run Journal LinesCompanyRunJournalLinesNmbrs.Views.CompanyRunJournalLinesV2: Company Run Journal Lines V 2CompanyRunJournalLinesV2Nmbrs.Views.CompanyRunPayslipPdfs: Company Run Payslip PDFsCompanyRunPayslipPdfsNmbrs.Views.CompanyRunPayslipPdfsV2: Company Run Payslip PDFs V 2CompanyRunPayslipPdfsV2Nmbrs.Views.CompanyRunWageCodesV2: Company Run Wage CodesCompanyRunWageCodesV2Nmbrs.Views.CompanyRuns: Nmbrs NL Company RunsCompanyRunsNmbrs.Views.DebtorAbsences: AbsencesDebtorAbsencesNmbrs.Views.DebtorAccountsAndContacts: Accounts and ContactsDebtorAccountsAndContactsNmbrs.Views.DebtorAddresses: Debtor AddressesDebtorAddressesNmbrs.Views.DebtorBankAccounts: Debtor Bank AccountsDebtorBankAccountsNmbrs.Views.DebtorContactPersons: Debtor Contact PersonsDebtorContactPersonsNmbrs.Views.DebtorDepartments: Debtor DepartmentsDebtorDepartmentsNmbrs.Views.DebtorFunctions: Debtor FunctionsDebtorFunctionsNmbrs.Views.DebtorIsOwners: Is Owner DebtorsDebtorIsOwnersNmbrs.Views.DebtorManagers: Debtor ManagersDebtorManagersNmbrs.Views.DebtorServiceLevels: Debtor Service LevelsDebtorServiceLevelsNmbrs.Views.DebtorTags: Debtor TagsDebtorTagsNmbrs.Views.DebtorTitles: Debtor TitlesDebtorTitlesNmbrs.Views.EmployeeBankAccountsCurrent: Employee Current Bank AccountsEmployeeBankAccountsCurrentNmbrs.Views.EmployeeContractPeriodsCurrent: Employee Current Contract PeriodsEmployeeContractPeriodsCurrentNmbrs.Views.EmployeeCostCentersCurrent: Employee Current Cost CentresEmployeeCostCentersCurrentNmbrs.Views.EmployeeExtraFields: Employee Extra FieldsEmployeeExtraFieldsNmbrs.Views.EmployeeFixedHourComponents: Fixed Hour ComponentsEmployeeFixedHourComponentsNmbrs.Views.EmployeeHourComponentsFixedCurrent: Employee Current Fixed Hour ComponentsEmployeeHourComponentsFixedCurrentNmbrs.Views.EmployeeHourComponentsVariableCurrent: Employee Current Variable Hour ComponentsEmployeeHourComponentsVariableCurrentNmbrs.Views.EmployeeLabourAgreementsCurrent: Employee Current Labour AgreementsEmployeeLabourAgreementsCurrentNmbrs.Views.EmployeeLeaseCarsCurrent: Employee Current Lease CarsEmployeeLeaseCarsCurrentNmbrs.Views.EmployeeLeaveBalancesCurrent: Employee Current Leave BalancesEmployeeLeaveBalancesCurrentNmbrs.Views.EmployeeManagersCurrent: Employee Current ManagersEmployeeManagersCurrentNmbrs.Views.EmployeePeriodDaysFixedCurrent: Employee Current Fixed Period DaysEmployeePeriodDaysFixedCurrentNmbrs.Views.EmployeePeriodDaysVariableCurrent: Employee Current Variable Period DaysEmployeePeriodDaysVariableCurrentNmbrs.Views.EmployeeSchedules: Employee SchedulesEmployeeSchedulesNmbrs.Views.EmployeeVariableHourComponents: Variable Hour ComponentsEmployeeVariableHourComponentsNmbrs.Views.EmployeesActive: Active EmployeesEmployeesActiveNmbrs.Views.EmployeesAll: All EmployeesEmployeesAllNmbrs.Views.EmployeesInactive: Inactive EmployeesEmployeesInactiveNmbrs.Views.PeriodLengthTypes: Period TypesPeriodLengthTypesNmbrs.Views.RunRequestsPerYearAndPeriod: Run Requests per Year and PeriodRunRequestsPerYearAndPeriodNmbrs.Views.ScheduleCalendars: Schedule CalendarsScheduleCalendarsNmbrs.Views.WorkCostsPerYearAndPeriod: Work Costs per Year and PeriodWorkCostsPerYearAndPeriodNmbrsPayrolling for both the Dutch as well as Swedish legislation areavailable. Nmbrs is used by entrepreneurs and accountingfirms. Login to the NMBRS API requires an API token. APItokens can enable access to all debtors in NMBRS or solely toone specific debtor as described onhttps://support.nmbrs.nl/hc/nl/articles/360010686800-Connect-Nmbrs-with-an-API-token.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsEmployees1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n relations between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/nmbrs
The poster as text: tables per topic and their relations

Employees

EmployeeContracts, EmployeePersonalInformations, PersonalInformations

CodeValues (without relations)

ActiveTypes, AddressTypes, BankAccountTypes, GenderTypes, LeaveStatuses, LeaveTypes, LeaveUsageTypes, PaymentModeTypes, ReservationCalcMethodAgeTypes, SalaryTypes, TimeStatusTypes

Company (without relations)

Companies, CompanyCostCenters, CompanyCostUnits, CompanyCurrentAddresses, CompanyCurrentBankAccounts, CompanyCurrentPeriods, CompanyCurrentSVWs, CompanyCurrentSchedules, CompanyCurrentWageComponentsFixed, CompanyCurrentWageComponentsVariable, CompanyDefaultEmployeeTemplates, CompanyHourCodes, CompanyWageCodes

Debtor (without relations)

Debtors

Employees (without relations)

CompanySVWs, EmployeeAbsences, EmployeeAddresses, EmployeeChildren, EmployeeDepartments, EmployeeEmployments, EmployeeFunctions, EmployeeFunctionsV2, EmployeePartners, EmployeePerformanceReviews, EmployeePersonalInfoContractSalaryAddresses, EmployeeSalaries, EmployeeSchedules, EmployeeTypes, EndServiceReasons

Native (without relations)

NATIVEPLATFORMSCALARREQUESTS

Views (without relations)

CompanyLast7YearPeriods, CompanyLast7Years, CompanyRunCostCenterCostUnits, CompanyRunCostCenters, CompanyRunCostCentersV2, CompanyRunDepartments, CompanyRunDepartmentsV2, CompanyRunEmployees, CompanyRunEmployeesV2, CompanyRunJournalHeaders, CompanyRunJournalLines, CompanyRunJournalLinesV2, CompanyRunPayslipPdfs, CompanyRunPayslipPdfsV2, CompanyRunWageCodesV2, CompanyRuns, DebtorAbsences, DebtorAccountsAndContacts, DebtorAddresses, DebtorBankAccounts, DebtorContactPersons, DebtorDepartments, DebtorFunctions, DebtorIsOwners, DebtorManagers, DebtorServiceLevels, DebtorTags, DebtorTitles, EmployeeBankAccountsCurrent, EmployeeContractPeriodsCurrent, EmployeeCostCentersCurrent, EmployeeExtraFields, EmployeeFixedHourComponents, EmployeeHourComponentsFixedCurrent, EmployeeHourComponentsVariableCurrent, EmployeeLabourAgreementsCurrent, EmployeeLeaseCarsCurrent, EmployeeLeaveBalancesCurrent, EmployeeManagersCurrent, EmployeePeriodDaysFixedCurrent, EmployeePeriodDaysVariableCurrent, EmployeeSchedules, EmployeeVariableHourComponents, EmployeesActive, EmployeesAll, EmployeesInactive, PeriodLengthTypes, RunRequestsPerYearAndPeriod, ScheduleCalendars, WorkCostsPerYearAndPeriod

Relations

Tables

Nmbrs.CodeValues

Nmbrs.Company

Nmbrs.Debtor

Nmbrs.Employees

Nmbrs.Native

Nmbrs.Views

Sample Queries

--
-- A view joining employees with a table function on contract to get a list of employee contracts from Nmbrs.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/nmbrs-data-model/webhelp/nmbrs-connector-views-employeecontractperiodscurrent.html
--
-- Related forum post: https://forums.invantive.eu/t/what-are-table-functions-and-table-function-parameters/1868
--
select *
from   Nmbrs.Views.EmployeeContractPeriodsCurrent@nms
limit  100
--
-- List of contract periods of employees in Nmbrs.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/nmbrs-data-model/webhelp/nmbrs-connector-employees-employeecontracts.html
--
select *
from   Nmbrs.Employees.EmployeeContracts@nms
limit  100

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: