invantive documentation
Invantive SupportforenAnmelden / Eintragen

Nmbrs-Datenmodell

Nmbrs Lohnbuchhaltung und Personalwesen

Lohnabrechnung nach niederländischer sowie schwedischer Gesetzgebung ist verfügbar. Nmbrs wird von Unternehmern und Buchhaltungsbüros genutzt. Die Anmeldung an der NMBRS-API erfordert ein API-Token. API-Token können Zugriff auf alle Debitoren in NMBRS oder nur auf einen bestimmten Debitor ermöglichen, wie unter https://support.nmbrs.nl/hc/nl/articles/360010686800-Connect-Nmbrs-with-an-API-token. beschrieben NMBRS erlaubt die individuelle Konfiguration des API-Zugriffs mithilfe von API-Vorlagen. Prüfen Sie im Einstellungsmenü, ob die Template-Benutzer ausreichend API-Zugriff haben, indem Sie auf das Zahnrad-Symbol der mit dem Konto verbundenen Vorlage klicken. Stellen Sie außerdem sicher, dass die Vorlage auf die NMBRS-Benutzer angewendet wird.

Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/nmbrs

Die Daten sind pro Firma (COMPANY_CODE) partitioniert.

Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.

Plattform

  • Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
  • Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
  • Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
  • Mit einer Query können mehrere Unternehmen gleichzeitig abgerufen werden.
  • Invantive Cloud-Pläne: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status der Plattform: https://status.nmbrs.com/.
  • Sprache ihrer Benutzergemeinschaft: Niederländisch.

Angaben

Figure Count
Tables 209
Columns 1,924
Tabellen mit Einfügung 1
Tabellen mit Aktualisierung 0
Tabellen mit Löschfunktion 0
Tabellen dokumentiert 1

Poster zum Daten Muster

PDF, 1 A0-Blatt

Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.

Nmbrs Daten Muster, Seite 1 von 1Nmbrs Daten Musterzur Verwendung mit Invantive UniversalSQLVeröffentlichung 27.1.3-BETA+6294 · 01-11-2026MitarbeiterSeite 1 von 1 · documentation.invantive.euMitarbeiterNmbrs.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 TimeStatusTypesTimeStatusTypesFirmaNmbrs.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 CodesCompanyWageCodesDebitorNmbrs.Debtor.Debtors: DebtorsDebtorsMitarbeiterNmbrs.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.DatadictionaryJede Tabelle und jede Spalte dieses Daten Musters wird mit einer entsprechenden Dokumentationauf documentation.invantive.eu beschrieben, wo die Dokumentation auch in anderen Sprachenverfügbar ist.NotizenDie Boxen sind nach Themen gruppiert und je nach Kategorie farblich gekennzeichnet. Im Themader Tabelle, die den Schlüssel enthält, wird eine Beziehung eingezeichnet; in einem anderen Themawird eine hellgraue Box definiert.ThemenMitarbeiter1Tabellen ohne Beziehungen1LegendeTransaktionalSetupTechnischFest codierte WerteIn einem anderen Thema definiertDeklarierter SchlüsselIn Worten beschriebene BeziehungAus Spaltennamen abgeleiteter KandidatFett: eine beliebte Tabelle+Bulk, +Read: Die Tabelle ist auch in diesen Varianten verfügbar×n: n relations between the same tablesErstellt anhand der Metadaten von Invantive UniversalSQL 27.1.3-BETA+6294 am 01-11-2026. Jede Tabelle enthälteinen Link zu ihrer Seite mit Spalten, Schlüsseln und Beispiel-Queries.documentation.invantive.eu/de/datamodels/nmbrs
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge

Mitarbeiter

EmployeeContracts, EmployeePersonalInformations, PersonalInformations

CodeValues (ohne Beziehungen)

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

Firma (ohne Beziehungen)

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

Debitor (ohne Beziehungen)

Debtors

Mitarbeiter (ohne Beziehungen)

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

Native (ohne Beziehungen)

NATIVEPLATFORMSCALARREQUESTS

Views (ohne Beziehungen)

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

Beziehungen

Tabellen

Nmbrs.CodeValues

Nmbrs.Company

Nmbrs.Debtor

Nmbrs.Employees

Nmbrs.Native

Nmbrs.Views

Beispiel-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

Attribute

Die Eigenschaften dieser Plattform finden Sie auf der Seite Attributes.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: