---
title: "Nmbrs Data Model"
description: "Nmbrs payroll and human resources"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/nmbrs
original: https://documentation.invantive.eu/en/datamodels/nmbrs
updated: 2026-11-01T17:57:29Z
license: https://documentation.invantive.eu/en/
---

# 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/](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 |

## Tables

### Nmbrs.CodeValues

- [ActiveTypes](Nmbrs.CodeValues.ActiveTypes): Domain ActiveTypes
- [AddressTypes](Nmbrs.CodeValues.AddressTypes): Domain AddressTypes
- [BankAccountTypes](Nmbrs.CodeValues.BankAccountTypes): Domain BankAccountTypes
- [GenderTypes](Nmbrs.CodeValues.GenderTypes): Domain GenderTypes
- [LeaveStatuses](Nmbrs.CodeValues.LeaveStatuses): Domain LeaveStatuses
- [LeaveTypes](Nmbrs.CodeValues.LeaveTypes): Domain LeaveTypes
- [LeaveUsageTypes](Nmbrs.CodeValues.LeaveUsageTypes): Domain LeaveUsageTypes
- [PaymentModeTypes](Nmbrs.CodeValues.PaymentModeTypes): Domain PaymentModeTypes
- [ReservationCalcMethodAgeTypes](Nmbrs.CodeValues.ReservationCalcMethodAgeTypes): Domain ReservationCalcMethodAgeTypes
- [SalaryTypes](Nmbrs.CodeValues.SalaryTypes): Domain SalaryTypes
- [TimeStatusTypes](Nmbrs.CodeValues.TimeStatusTypes): Domain TimeStatusTypes

### Nmbrs.Company

- [Companies](Nmbrs.Company.Companies): Companies
- [CompanyCostCenters](Nmbrs.Company.CompanyCostCenters): Company Cost Centres
- [CompanyCostUnits](Nmbrs.Company.CompanyCostUnits): Company Cost Units
- [CompanyCurrentAddresses](Nmbrs.Company.CompanyCurrentAddresses): Company Current Addresses
- [CompanyCurrentBankAccounts](Nmbrs.Company.CompanyCurrentBankAccounts): Company Current Bank Accounts
- [CompanyCurrentPeriods](Nmbrs.Company.CompanyCurrentPeriods): Company Current Periods
- [CompanyCurrentSVWs](Nmbrs.Company.CompanyCurrentSVWs): Company Current SVW
- [CompanyCurrentSchedules](Nmbrs.Company.CompanyCurrentSchedules): Company Current Schedule
- [CompanyCurrentWageComponentsFixed](Nmbrs.Company.CompanyCurrentWageComponentsFixed): Company Current Wage Components Fixed
- [CompanyCurrentWageComponentsVariable](Nmbrs.Company.CompanyCurrentWageComponentsVariable): Company Current Wage Component Var
- [CompanyDefaultEmployeeTemplates](Nmbrs.Company.CompanyDefaultEmployeeTemplates): Company Default Employee Templates
- [CompanyHourCodes](Nmbrs.Company.CompanyHourCodes): Company Hour Codes
- [CompanyRunCostCentersByCompanyRun](Nmbrs.Company.CompanyRunCostCentersByCompanyRun): Company Run Cost Centres
- [CompanyRunCostCentersCostUnitsByCompanyRunYear](Nmbrs.Company.CompanyRunCostCentersCostUnitsByCompanyRunYear): Company Run Cost Centers Cost Units
- [CompanyRunCostCentersV2ByCompanyRunYear](Nmbrs.Company.CompanyRunCostCentersV2ByCompanyRunYear): Company Run Cost Centres V2
- [CompanyRunDepartmentsByCompanyRun](Nmbrs.Company.CompanyRunDepartmentsByCompanyRun): Company Run Departments
- [CompanyRunDepartmentsV2ByCompanyRunYear](Nmbrs.Company.CompanyRunDepartmentsV2ByCompanyRunYear): Company Run Departments V2
- [CompanyRunEmployeesByCompanyRun](Nmbrs.Company.CompanyRunEmployeesByCompanyRun): Company Run Employees
- [CompanyRunEmployeesV2ByCompanyRunYear](Nmbrs.Company.CompanyRunEmployeesV2ByCompanyRunYear): Company Run Employees V 2
- [CompanyRunJournalsByCompanyRun](Nmbrs.Company.CompanyRunJournalsByCompanyRun): Company Run Journals
- [CompanyRunJournalsV2ByCompanyRunYear](Nmbrs.Company.CompanyRunJournalsV2ByCompanyRunYear): Company Run Journals V2
- [CompanyRunPayslipsByCompanyRunYear](Nmbrs.Company.CompanyRunPayslipsByCompanyRunYear): Company Run Payslips
- [CompanyRunReportWageCodesByCompanyRunYear](Nmbrs.Company.CompanyRunReportWageCodesByCompanyRunYear): Company Run Report Wage Codes
- [CompanyRunWageCodesV2ByCompanyRunYear](Nmbrs.Company.CompanyRunWageCodesV2ByCompanyRunYear): Company Run Wage Codes V2
- [CompanyRunsByCompanyYear](Nmbrs.Company.CompanyRunsByCompanyYear): Company Run Years
- [CompanySalaryScalesByCompanyYearPeriod](Nmbrs.Company.CompanySalaryScalesByCompanyYearPeriod): Company Salary Table
- [CompanySalaryTableByCompanyYearPeriodByCompanyRunYear](Nmbrs.Company.CompanySalaryTableByCompanyYearPeriodByCompanyRunYear): Salary Tables by Company, Year and Period
- [CompanyWageCodes](Nmbrs.Company.CompanyWageCodes): Company Wage Codes
- [CompanyWageCodesReportByCompanyYear](Nmbrs.Company.CompanyWageCodesReportByCompanyYear): Company Wage Codes Year Report
- [CompanyWageComponentsFixedByEmployeeYearPeriod](Nmbrs.Company.CompanyWageComponentsFixedByEmployeeYearPeriod): Company Wage Components Fixed Period Year
- [CompanyWageComponentsVariableByEmployeeYearPeriod](Nmbrs.Company.CompanyWageComponentsVariableByEmployeeYearPeriod): Company Wage Components Var Period Year
- [CompanyWageTaxesByCompanyYear](Nmbrs.Company.CompanyWageTaxesByCompanyYear): Company Wage Taxes Year
- [PayslipPdfsByCompanyRunByCompanyRunYear](Nmbrs.Company.PayslipPdfsByCompanyRunByCompanyRunYear): Company Run Payslips
- [PayslipsV2ByCompanyRunAndYear](Nmbrs.Company.PayslipsV2ByCompanyRunAndYear): Company Run Payslips V 2
- [RunPayslipPdfsV2ByCompanyYearRun](Nmbrs.Company.RunPayslipPdfsV2ByCompanyYearRun): Company Run Payslip PDFs V2
- [RunRequestsByCompanyYear](Nmbrs.Company.RunRequestsByCompanyYear): Company Run Requests Year
- [WorkCostsByCompanyYear](Nmbrs.Company.WorkCostsByCompanyYear): Company Work Costs Year

### Nmbrs.Debtor

- [AbsencesByDebtor](Nmbrs.Debtor.AbsencesByDebtor): Absences by Debtor
- [DebtorAccountAndContactsByDebtor](Nmbrs.Debtor.DebtorAccountAndContactsByDebtor): Debtor Accountant Contacts
- [DebtorAddressesByDebtor](Nmbrs.Debtor.DebtorAddressesByDebtor): Debtor Address
- [DebtorBankAccountsByDebtor](Nmbrs.Debtor.DebtorBankAccountsByDebtor): Debtor Bank Accounts
- [DebtorById](Nmbrs.Debtor.DebtorById): Debtor by ID
- [DebtorCompaniesByDebtor](Nmbrs.Debtor.DebtorCompaniesByDebtor): Debtor Companies
- [DebtorContactPersonsByDebtor](Nmbrs.Debtor.DebtorContactPersonsByDebtor): Debtor Contact Persons
- [DebtorDepartmentsByDebtor](Nmbrs.Debtor.DebtorDepartmentsByDebtor): Debtor Departments
- [DebtorFunctionsByDebtor](Nmbrs.Debtor.DebtorFunctionsByDebtor): Debtor Functions
- [DebtorIsOwnerByDebtor](Nmbrs.Debtor.DebtorIsOwnerByDebtor): Debtor is Owner
- [DebtorServiceLevelsByDebtor](Nmbrs.Debtor.DebtorServiceLevelsByDebtor): Debtor Service Level
- [DebtorTagsByDebtor](Nmbrs.Debtor.DebtorTagsByDebtor): Debtor Tags
- [DebtorTitlesByDebtor](Nmbrs.Debtor.DebtorTitlesByDebtor): Debtor Titles
- [Debtors](Nmbrs.Debtor.Debtors): Debtors
- [LabourAgreementSettingsByDebtorYearPeriod](Nmbrs.Debtor.LabourAgreementSettingsByDebtorYearPeriod): Labour Agreement Settings by Debtor, Year and Period
- [ManagersByDebtor](Nmbrs.Debtor.ManagersByDebtor): Managers by Debtor

### Nmbrs.Employees

- [CompanySVWs](Nmbrs.Employees.CompanySVWs): Company Employee SVWs
- [EmployeeAbsences](Nmbrs.Employees.EmployeeAbsences): Employee Absences
- [EmployeeAbsencesByEmployee](Nmbrs.Employees.EmployeeAbsencesByEmployee): Employee Absence by Employee
- [EmployeeAbsencesV2ByEmployee](Nmbrs.Employees.EmployeeAbsencesV2ByEmployee): Employee Absence by Employee (V2)
- [EmployeeAddresses](Nmbrs.Employees.EmployeeAddresses): Employee Addresses
- [EmployeeAddressesByEmployeeYearPeriod](Nmbrs.Employees.EmployeeAddressesByEmployeeYearPeriod): Employee Addresses by Employee, Year and Period
- [EmployeeAddressesCurrentByEmployee](Nmbrs.Employees.EmployeeAddressesCurrentByEmployee): Employee Current Addresses
- [EmployeeAnnualSalaryStatementsByEmployeeYear](Nmbrs.Employees.EmployeeAnnualSalaryStatementsByEmployeeYear): Annual Salary Statements by Employee and Year
- [EmployeeBankAccountsByEmployeeYearPeriod](Nmbrs.Employees.EmployeeBankAccountsByEmployeeYearPeriod): Employee Bank Accounts by Employee, Year and Period
- [EmployeeBankAccountsCurrentByEmployee](Nmbrs.Employees.EmployeeBankAccountsCurrentByEmployee): Employee Current Bank Accounts
- [EmployeeChildren](Nmbrs.Employees.EmployeeChildren): Employee Children
- [EmployeeChildrenByEmployee](Nmbrs.Employees.EmployeeChildrenByEmployee): Employee Current Children
- [EmployeeCompanyPeriodsCurrentByEmployee](Nmbrs.Employees.EmployeeCompanyPeriodsCurrentByEmployee): Employee Current Periods by Employee
- [EmployeeContractPeriodsCurrentByEmployee](Nmbrs.Employees.EmployeeContractPeriodsCurrentByEmployee): Employee Current Contracts Period
- [EmployeeContracts](Nmbrs.Employees.EmployeeContracts): Company Employee Contracts
- [EmployeeContractsV2ByEmployee](Nmbrs.Employees.EmployeeContractsV2ByEmployee): Employee Contracts by Employee (V2)
- [EmployeeCostCenters](Nmbrs.Employees.EmployeeCostCenters): Employee Cost Centres
- [EmployeeCostCentersByEmployeeYearPeriod](Nmbrs.Employees.EmployeeCostCentersByEmployeeYearPeriod): Employee Cost Centres by Employee, Year and Period
- [EmployeeCostCentersCurrentByEmployee](Nmbrs.Employees.EmployeeCostCentersCurrentByEmployee): Employee Current Cost Centre
- [EmployeeDaysFixedByEmployeeYearPeriod](Nmbrs.Employees.EmployeeDaysFixedByEmployeeYearPeriod): Employee Days Fixed Period Year
- [EmployeeDaysVariableByEmployeeYearPeriod](Nmbrs.Employees.EmployeeDaysVariableByEmployeeYearPeriod): Employee Days Var Period Year
- [EmployeeDepartments](Nmbrs.Employees.EmployeeDepartments): Company Employee Departments
- [EmployeeDepartmentsCurrentByEmployee](Nmbrs.Employees.EmployeeDepartmentsCurrentByEmployee): Employee Current Department
- [EmployeeEmployments](Nmbrs.Employees.EmployeeEmployments): Employments
- [EmployeeEstimatedCostsPerHourByEmployeeYearPeriod](Nmbrs.Employees.EmployeeEstimatedCostsPerHourByEmployeeYearPeriod): Estimated Costs per Hour by Employee, Year and Period
- [EmployeeExtraFieldsByEmployee](Nmbrs.Employees.EmployeeExtraFieldsByEmployee): Employee Extra Fields
- [EmployeeExtraFieldsWithStartDate](Nmbrs.Employees.EmployeeExtraFieldsWithStartDate): Employee Extra Fields with Start Date
- [EmployeeFunctions](Nmbrs.Employees.EmployeeFunctions): Employees
- [EmployeeFunctionsCurrentByEmployee](Nmbrs.Employees.EmployeeFunctionsCurrentByEmployee): Employee Current Function
- [EmployeeFunctionsV2](Nmbrs.Employees.EmployeeFunctionsV2): Employees (V2)
- [EmployeeHourComponentsFixedByEmployeeYearPeriod](Nmbrs.Employees.EmployeeHourComponentsFixedByEmployeeYearPeriod): Employee Hour Components Fixed Period Year
- [EmployeeHourComponentsFixedCurrentByEmployee](Nmbrs.Employees.EmployeeHourComponentsFixedCurrentByEmployee): Employee Current Hour Components Fixed
- [EmployeeHourComponentsVariableByEmployeeYearPeriod](Nmbrs.Employees.EmployeeHourComponentsVariableByEmployeeYearPeriod): Employee Hour Components Var Period Year
- [EmployeeHourComponentsVariableCurrentByEmployee](Nmbrs.Employees.EmployeeHourComponentsVariableCurrentByEmployee): Employee Current Hour Components Var
- [EmployeeLabourAgreementsByEmployeeYearPeriod](Nmbrs.Employees.EmployeeLabourAgreementsByEmployeeYearPeriod): Labour Agreements by Employee, Year and Period
- [EmployeeLabourAgreementsCurrentByEmployee](Nmbrs.Employees.EmployeeLabourAgreementsCurrentByEmployee): {Res:itgen_nmbr_current_labour_agreements_by_employee}
- [EmployeeLeaseCarByEmployeeYearPeriod](Nmbrs.Employees.EmployeeLeaseCarByEmployeeYearPeriod): Employee Period Year Lease Car
- [EmployeeLeaseCarsByCompanyYearPeriod](Nmbrs.Employees.EmployeeLeaseCarsByCompanyYearPeriod): Lease Cars by Company, Year and Period
- [EmployeeLeaseCarsByEmployeeYearPeriod](Nmbrs.Employees.EmployeeLeaseCarsByEmployeeYearPeriod): Employee Period Year Lease Cars
- [EmployeeLeaseCarsCurrentByEmployee](Nmbrs.Employees.EmployeeLeaseCarsCurrentByEmployee): Employee Current Leasecar
- [EmployeeLeaseCarsV2ByCompanyYearPeriod](Nmbrs.Employees.EmployeeLeaseCarsV2ByCompanyYearPeriod): Lease Cars by Company, Year and Period
- [EmployeeLeaveBalancesByEmployee](Nmbrs.Employees.EmployeeLeaveBalancesByEmployee): Employee Leave Balance
- [EmployeeLeaveBalancesByEmployeeLeaveType](Nmbrs.Employees.EmployeeLeaveBalancesByEmployeeLeaveType): Leave Balance by Employee and Leave Type
- [EmployeeLeavesByEmployeeYearLeaveTypeLeaveUsageType](Nmbrs.Employees.EmployeeLeavesByEmployeeYearLeaveTypeLeaveUsageType): Leaves by Employee, Year, Leave Type and Leave Usage Type
- [EmployeeLeavesV2ByEmployeeYearLeaveTypeLeaveUsageType](Nmbrs.Employees.EmployeeLeavesV2ByEmployeeYearLeaveTypeLeaveUsageType): Leaves by Employee, Year, Leave Type and Leave Usage Type
- [EmployeeLevensloopByEmployeeYearPeriod](Nmbrs.Employees.EmployeeLevensloopByEmployeeYearPeriod): Employee Period Year Life Course Savings
- [EmployeeManagersByEmployeeYearPeriod](Nmbrs.Employees.EmployeeManagersByEmployeeYearPeriod): Managers by Employee, Year and Period
- [EmployeeManagersCurrentByEmployee](Nmbrs.Employees.EmployeeManagersCurrentByEmployee): Current Managers by Employee
- [EmployeePartnerByEmployee](Nmbrs.Employees.EmployeePartnerByEmployee): Employee Partner
- [EmployeePartners](Nmbrs.Employees.EmployeePartners): Employee Partners
- [EmployeePerformanceReviews](Nmbrs.Employees.EmployeePerformanceReviews): Performance Reviews
- [EmployeePerformanceReviewsByEmployee](Nmbrs.Employees.EmployeePerformanceReviewsByEmployee): Performance Reviews by Employee
- [EmployeePeriodDaysFixedCurrentByEmployee](Nmbrs.Employees.EmployeePeriodDaysFixedCurrentByEmployee): Employee Current Period Days Fixed
- [EmployeePeriodDaysVariableCurrentByEmployee](Nmbrs.Employees.EmployeePeriodDaysVariableCurrentByEmployee): Employee Current Period Days Variable
- [EmployeePersonalInfoContractSalaryAddresses](Nmbrs.Employees.EmployeePersonalInfoContractSalaryAddresses): Employees Company Employees Personal Information Contract Salary Address
- [EmployeePersonalInformationByEmployeeYearPeriod](Nmbrs.Employees.EmployeePersonalInformationByEmployeeYearPeriod): Employee Period Year Personal Information
- [EmployeePersonalInformationCurrentByEmployee](Nmbrs.Employees.EmployeePersonalInformationCurrentByEmployee): Employee Current Personal Information
- [EmployeePersonalInformations](Nmbrs.Employees.EmployeePersonalInformations): Company Employee Personal Information
- [EmployeeReservationsByEmployeeYearPeriod](Nmbrs.Employees.EmployeeReservationsByEmployeeYearPeriod): Reservations by Employee, Year and Period
- [EmployeeSVWByEmployeeYearPeriod](Nmbrs.Employees.EmployeeSVWByEmployeeYearPeriod): Employee Period Year SVW
- [EmployeeSVWsByEmployee](Nmbrs.Employees.EmployeeSVWsByEmployee): Employee SVW
- [EmployeeSVWsCurrentByEmployee](Nmbrs.Employees.EmployeeSVWsCurrentByEmployee): Employee Current SVW
- [EmployeeSalaries](Nmbrs.Employees.EmployeeSalaries): Company Employee Salaries
- [EmployeeSalaries2ByEmployeeYearPeriod](Nmbrs.Employees.EmployeeSalaries2ByEmployeeYearPeriod): Employee Period Year Salaries
- [EmployeeSalariesByEmployeeYearPeriod](Nmbrs.Employees.EmployeeSalariesByEmployeeYearPeriod): Employee Period Year Salary
- [EmployeeSalariesCurrentByEmployee](Nmbrs.Employees.EmployeeSalariesCurrentByEmployee): Employee Current Salary
- [EmployeeScheduleByEmployeeYearPeriod](Nmbrs.Employees.EmployeeScheduleByEmployeeYearPeriod): Employee Period Year Schedule
- [EmployeeSchedules](Nmbrs.Employees.EmployeeSchedules): Company Employee Schedules
- [EmployeeSchedulesByEmployeeYearPeriod](Nmbrs.Employees.EmployeeSchedulesByEmployeeYearPeriod): Employee Period Year Schedules
- [EmployeeSchedulesCurrentByEmployee](Nmbrs.Employees.EmployeeSchedulesCurrentByEmployee): Employee Current Schedule
- [EmployeeServiceIntervalsByEmployee](Nmbrs.Employees.EmployeeServiceIntervalsByEmployee): Employee Service
- [EmployeeSpaarlonenByEmployeeYearPeriod](Nmbrs.Employees.EmployeeSpaarlonenByEmployeeYearPeriod): Employee Period Year Savings Wages
- [EmployeeSpaarloonByEmployeeYearPeriod](Nmbrs.Employees.EmployeeSpaarloonByEmployeeYearPeriod): Employee Period Year Savings Wage
- [EmployeeTimeScheduleSlotsByCompanyYearPeriod](Nmbrs.Employees.EmployeeTimeScheduleSlotsByCompanyYearPeriod): Time Schedule Slots by Company, Year and Period
- [EmployeeTimeScheduleSlotsByEmployee](Nmbrs.Employees.EmployeeTimeScheduleSlotsByEmployee): Time Schedule Slots by Employee
- [EmployeeTimeScheduleSlotsByEmployeeYearPeriod](Nmbrs.Employees.EmployeeTimeScheduleSlotsByEmployeeYearPeriod): Time Schedule Slots by Employee, Year and Period
- [EmployeeTimeSchedulesByCompanyYearPeriod](Nmbrs.Employees.EmployeeTimeSchedulesByCompanyYearPeriod): Time Schedules by Company, Year and Period
- [EmployeeTimeSchedulesByEmployee](Nmbrs.Employees.EmployeeTimeSchedulesByEmployee): Time Schedules by Employee
- [EmployeeTimeSchedulesByEmployeeYearPeriod](Nmbrs.Employees.EmployeeTimeSchedulesByEmployeeYearPeriod): Time Schedules by Employee, Year and Period
- [EmployeeTypes](Nmbrs.Employees.EmployeeTypes): Employee Types
- [EmployeeWageComponentsFixedByEmployeeYearPeriod](Nmbrs.Employees.EmployeeWageComponentsFixedByEmployeeYearPeriod): Employee Period Year Wage Components Fixed
- [EmployeeWageComponentsFixedCurrentByEmployee](Nmbrs.Employees.EmployeeWageComponentsFixedCurrentByEmployee): Employee Wage Component Fixed Get Current
- [EmployeeWageComponentsVariableByEmployeeYearPeriod](Nmbrs.Employees.EmployeeWageComponentsVariableByEmployeeYearPeriod): Employee Period Year Wage Components Var
- [EmployeeWageComponentsVariableCurrentByEmployee](Nmbrs.Employees.EmployeeWageComponentsVariableCurrentByEmployee): Employee Wage Component Var Get Current
- [EmployeeWageTaxByEmployeeYearPeriod](Nmbrs.Employees.EmployeeWageTaxByEmployeeYearPeriod): Employee Period Year Wage Tax
- [EmployeeWageTaxesByEmployee](Nmbrs.Employees.EmployeeWageTaxesByEmployee): Employee Wage Taxes
- [EmployeeWageTaxesCurrentByEmployee](Nmbrs.Employees.EmployeeWageTaxesCurrentByEmployee): Employee Current Wage Tax
- [EmployeesAll](Nmbrs.Employees.EmployeesAll): All Employees
- [EmployeesByDebtor](Nmbrs.Employees.EmployeesByDebtor): Employees by Debtor
- [EndServiceReasons](Nmbrs.Employees.EndServiceReasons): End Service Reasons
- [FunctionById](Nmbrs.Employees.FunctionById): Function by ID
- [JournalsByEmployeeStartEndYear](Nmbrs.Employees.JournalsByEmployeeStartEndYear): Journals by Employee, Year, and Start and Period
- [PersonalInformations](Nmbrs.Employees.PersonalInformations): Employees Company Employees Personal Information Contract Salary Address
- [ScheduleCalendarsByEmployeeYearPeriod](Nmbrs.Employees.ScheduleCalendarsByEmployeeYearPeriod): Employee Schedule Calendars

### Nmbrs.Native

- [NATIVEPLATFORMSCALARREQUESTS](Nmbrs.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### Nmbrs.Views

- [CompanyLast7YearPeriods](Nmbrs.Views.CompanyLast7YearPeriods): Periods (last 7 years)
- [CompanyLast7Years](Nmbrs.Views.CompanyLast7Years): Payroll Years
- [CompanyRunCostCenterCostUnits](Nmbrs.Views.CompanyRunCostCenterCostUnits): Company Run Cost Centre Cost Units
- [CompanyRunCostCenters](Nmbrs.Views.CompanyRunCostCenters): Company Run Cost Centers
- [CompanyRunCostCentersV2](Nmbrs.Views.CompanyRunCostCentersV2): Company Run Cost Centers V 2
- [CompanyRunDepartments](Nmbrs.Views.CompanyRunDepartments): Company Run Departments
- [CompanyRunDepartmentsV2](Nmbrs.Views.CompanyRunDepartmentsV2): Company Run Departments V 2
- [CompanyRunEmployees](Nmbrs.Views.CompanyRunEmployees): Company Run Employees
- [CompanyRunEmployeesV2](Nmbrs.Views.CompanyRunEmployeesV2): Company Run Employees V 2
- [CompanyRunJournalHeaders](Nmbrs.Views.CompanyRunJournalHeaders): Company Run Journal Headers
- [CompanyRunJournalLines](Nmbrs.Views.CompanyRunJournalLines): Company Run Journal Lines
- [CompanyRunJournalLinesV2](Nmbrs.Views.CompanyRunJournalLinesV2): Company Run Journal Lines V 2
- [CompanyRunPayslipPdfs](Nmbrs.Views.CompanyRunPayslipPdfs): Company Run Payslip PDFs
- [CompanyRunPayslipPdfsV2](Nmbrs.Views.CompanyRunPayslipPdfsV2): Company Run Payslip PDFs V 2
- [CompanyRunWageCodesV2](Nmbrs.Views.CompanyRunWageCodesV2): Company Run Wage Codes
- [CompanyRuns](Nmbrs.Views.CompanyRuns): Nmbrs NL Company Runs
- [DebtorAbsences](Nmbrs.Views.DebtorAbsences): Absences
- [DebtorAccountsAndContacts](Nmbrs.Views.DebtorAccountsAndContacts): Accounts and Contacts
- [DebtorAddresses](Nmbrs.Views.DebtorAddresses): Debtor Addresses
- [DebtorBankAccounts](Nmbrs.Views.DebtorBankAccounts): Debtor Bank Accounts
- [DebtorContactPersons](Nmbrs.Views.DebtorContactPersons): Debtor Contact Persons
- [DebtorDepartments](Nmbrs.Views.DebtorDepartments): Debtor Departments
- [DebtorFunctions](Nmbrs.Views.DebtorFunctions): Debtor Functions
- [DebtorIsOwners](Nmbrs.Views.DebtorIsOwners): Is Owner Debtors
- [DebtorManagers](Nmbrs.Views.DebtorManagers): Debtor Managers
- [DebtorServiceLevels](Nmbrs.Views.DebtorServiceLevels): Debtor Service Levels
- [DebtorTags](Nmbrs.Views.DebtorTags): Debtor Tags
- [DebtorTitles](Nmbrs.Views.DebtorTitles): Debtor Titles
- [EmployeeBankAccountsCurrent](Nmbrs.Views.EmployeeBankAccountsCurrent): Employee Current Bank Accounts
- [EmployeeContractPeriodsCurrent](Nmbrs.Views.EmployeeContractPeriodsCurrent): Employee Current Contract Periods
- [EmployeeCostCentersCurrent](Nmbrs.Views.EmployeeCostCentersCurrent): Employee Current Cost Centres
- [EmployeeExtraFields](Nmbrs.Views.EmployeeExtraFields): Employee Extra Fields
- [EmployeeFixedHourComponents](Nmbrs.Views.EmployeeFixedHourComponents): Fixed Hour Components
- [EmployeeHourComponentsFixedCurrent](Nmbrs.Views.EmployeeHourComponentsFixedCurrent): Employee Current Fixed Hour Components
- [EmployeeHourComponentsVariableCurrent](Nmbrs.Views.EmployeeHourComponentsVariableCurrent): Employee Current Variable Hour Components
- [EmployeeLabourAgreementsCurrent](Nmbrs.Views.EmployeeLabourAgreementsCurrent): Employee Current Labour Agreements
- [EmployeeLeaseCarsCurrent](Nmbrs.Views.EmployeeLeaseCarsCurrent): Employee Current Lease Cars
- [EmployeeLeaveBalancesCurrent](Nmbrs.Views.EmployeeLeaveBalancesCurrent): Employee Current Leave Balances
- [EmployeeManagersCurrent](Nmbrs.Views.EmployeeManagersCurrent): Employee Current Managers
- [EmployeePeriodDaysFixedCurrent](Nmbrs.Views.EmployeePeriodDaysFixedCurrent): Employee Current Fixed Period Days
- [EmployeePeriodDaysVariableCurrent](Nmbrs.Views.EmployeePeriodDaysVariableCurrent): Employee Current Variable Period Days
- [EmployeeSchedules](Nmbrs.Views.EmployeeSchedules): Employee Schedules
- [EmployeeVariableHourComponents](Nmbrs.Views.EmployeeVariableHourComponents): Variable Hour Components
- [EmployeesActive](Nmbrs.Views.EmployeesActive): Active Employees
- [EmployeesAll](Nmbrs.Views.EmployeesAll): All Employees
- [EmployeesInactive](Nmbrs.Views.EmployeesInactive): Inactive Employees
- [PeriodLengthTypes](Nmbrs.Views.PeriodLengthTypes): Period Types
- [RunRequestsPerYearAndPeriod](Nmbrs.Views.RunRequestsPerYearAndPeriod): Run Requests per Year and Period
- [ScheduleCalendars](Nmbrs.Views.ScheduleCalendars): Schedule Calendars
- [WorkCostsPerYearAndPeriod](Nmbrs.Views.WorkCostsPerYearAndPeriod): Work Costs per Year and Period

## Sample Queries

```sql
--
-- 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
```

```sql
--
-- 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](attributes).



## Release Notes

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

- [Nmbrs](/en/release-notes/drivers?driver=nmbrs)

