invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Modelo de datos de Nmbrs

NMBRS: nóminas y recursos humanos

Está disponible la nómina tanto para la legislación neerlandesa como para la sueca. Nmbrs es utilizado por autónomos y despachos de contabilidad. El inicio de sesión en la API de NMBRS requiere un token de API. Los tokens de API pueden permitir el acceso a todos los deudores en NMBRS o solo a un deudor específico, como se describe en https://support.nmbrs.nl/hc/nl/articles/360010686800-Connect-Nmbrs-with-an-API-token. NMBRS permite la configuración individual del acceso a la API mediante plantillas de API. Asegúrese en el menú Configuración de comprobar que los usuarios de plantilla tienen acceso API suficiente pulsando el icono de 'engranajes' de la plantilla asociada a la cuenta. Asegúrese también de aplicar la plantilla a los usuarios de NMBRS.

Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/nmbrs

Los datos están particionados por empresa (COMPANY_CODE).

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su API.
  • Los datos se agrupan por categorías, como por empresa o por administración.
  • Una Query puede leer varios datos de empresas a la vez.
  • Planes de Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Estado de la plataforma: https://status.nmbrs.com/.
  • Idioma de su comunidad de usuarios: neerlandés.

Cifras

Figure Count
Tables 209
Columns 1,924
Tablas con inserciones 1
Tablas con actualización 0
Tablas con la instrucción «DELETE» 0
Tablas documentadas 1

Póster del Modelo de Datos

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Nmbrs Modelo de Datos, Hoja 1 de 1Nmbrs Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.3-BETA+6294 · 01-11-2026EmpleadosHoja 1 de 1 · documentation.invantive.euEmpleadosNmbrs.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 TimeStatusTypesTimeStatusTypesCompañíaNmbrs.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 CodesCompanyWageCodesDeudorNmbrs.Debtor.Debtors: DebtorsDebtorsEmpleadosNmbrs.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 RequestsNATIVEPLATFORMSCALARREQUESTSVistasNmbrs.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.Diccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasEmpleados1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes×n: n relations between the same tablesGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.3-BETA+6294 el 01-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/nmbrs
El póster en forma de texto: tablas por tema y sus relaciones

Empleados

EmployeeContracts, EmployeePersonalInformations, PersonalInformations

CodeValues (sin relaciones)

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

Compañía (sin relaciones)

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

Deudor (sin relaciones)

Debtors

Empleados (sin relaciones)

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

Native (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Vistas (sin relaciones)

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

Relaciones

Tablas

Nmbrs.CodeValues

Nmbrs.Company

Nmbrs.Debtor

Nmbrs.Employees

Nmbrs.Native

Nmbrs.Views

Ejemplos 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

Atributos

Las características de esta plataforma se encuentran en la página Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: