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

Modèle de données Nmbrs

Paie et ressources humaines Nmbrs

La paie selon la législation néerlandaise comme suédoise est disponible. Nmbrs est utilisé par les entrepreneurs et les cabinets comptables. La connexion à l'API NMBRS nécessite un jeton API. Les jetons API peuvent donner accès à tous les débiteurs de NMBRS ou uniquement à un débiteur spécifique, comme décrit sur https://support.nmbrs.nl/hc/nl/articles/360010686800-Connect-Nmbrs-with-an-API-token. NMBRS permet une configuration individuelle de l'accès à l'API à l'aide de modèles API. Depuis le menu Paramètres, vérifiez que les utilisateurs modèles disposent d'un accès API suffisant en cliquant sur l'icône « engrenage » du modèle associé au compte. Veillez également à appliquer le modèle aux utilisateurs NMBRS.

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

Les données sont partitionnées par société (COMPANY_CODE).

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.
  • Forfaits Invantive Cloud : Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • État de la plateforme : https://status.nmbrs.com/.
  • Langue de sa communauté d'utilisateurs : néerlandais.

Chiffres

Figure Count
Tables 209
Columns 1,924
Tableaux avec insert 1
Tables avec mise à jour 0
Tables avec la clause DELETE 0
Tableaux documentés 1

Affiche sur le modèle de données

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.

Nmbrs Modèle de données, Page 1 sur 1Nmbrs Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 27.1.3-BETA+6294 · 01-11-2026EmployésPage 1 sur 1 · documentation.invantive.euEmployésNmbrs.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 TimeStatusTypesTimeStatusTypesSociétéNmbrs.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 CodesCompanyWageCodesDébiteurNmbrs.Debtor.Debtors: DebtorsDebtorsEmployésNmbrs.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 RequestsNATIVEPLATFORMSCALARREQUESTSVuesNmbrs.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.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.SujetsEmployés1Tables 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 27.1.3-BETA+6294 le 01-11-2026. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/nmbrs
L'affiche sous forme de texte : tableaux par thème et leurs relations

Employés

EmployeeContracts, EmployeePersonalInformations, PersonalInformations

CodeValues (sans relations)

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

Société (sans relations)

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

Débiteur (sans relations)

Debtors

Employés (sans relations)

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

Native (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Vues (sans 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

Tableaux

Nmbrs.CodeValues

Nmbrs.Company

Nmbrs.Debtor

Nmbrs.Employees

Nmbrs.Native

Nmbrs.Views

Exemples de 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

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 :