invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Modello Dati Nmbrs

NMBRS: gestione stipendi e risorse umane

Sono disponibili le elaborazioni paghe sia per la normativa olandese sia per quella svedese. Nmbrs è utilizzato da imprenditori e studi contabili. L'accesso all'API NMBRS richiede un token API. I token API possono consentire l'accesso a tutti i debitori in NMBRS oppure a un solo debitore specifico, come descritto in https://support.nmbrs.nl/hc/nl/articles/360010686800-Connect-Nmbrs-with-an-API-token. NMBRS consente la configurazione individuale dell'accesso API tramite template API. Verificare dal menu Impostazioni che gli utenti Template abbiano accesso API sufficiente premendo sull'icona 'ingranaggio' del template associato all'account. Assicurati inoltre di applicare il modello agli utenti NMBRS.

Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/nmbrs

I dati sono suddivisi per società (COMPANY_CODE).

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

Piattaforma

  • Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
  • Tipo: un'applicazione accessibile tramite la propria API.
  • I dati sono suddivisi, ad esempio per azienda o per amministrazione.
  • Una query può leggere i dati di più aziende contemporaneamente.
  • Piani Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Stato della piattaforma: https://status.nmbrs.com/.
  • Lingua della sua comunità di utenti: olandese.

Figure

Figure Count
Tables 209
Columns 1,924
Tabella con inserti 1
Tabella con aggiornamento 0
Tabella con la clausola DELETE 0
Tabella documentata 1

Poster sul modello di dati

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Nmbrs Modello di dati, Foglio 1 di 1Nmbrs Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.3-BETA+6294 · 01-11-2026DipendentiFoglio 1 di 1 · documentation.invantive.euDipendentiNmbrs.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 TimeStatusTypesTimeStatusTypesImpresaNmbrs.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 CodesCompanyWageCodesDebitoreNmbrs.Debtor.Debtors: DebtorsDebtorsDipendentiNmbrs.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 RequestsNATIVEPLATFORMSCALARREQUESTSVisualizzazioniNmbrs.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.Dizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiDipendenti1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti×n: n relations between the same tablesGenerato dai metadati di Invantive UniversalSQL 27.1.3-BETA+6294 il 01-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/nmbrs
Il poster come testo: tabelle per argomento e le loro relazioni

Dipendenti

EmployeeContracts, EmployeePersonalInformations, PersonalInformations

CodeValues (senza relazioni)

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

Impresa (senza relazioni)

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

Debitore (senza relazioni)

Debtors

Dipendenti (senza relazioni)

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

Native (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

Visualizzazioni (senza relazioni)

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

Relazioni

Tabelle

Nmbrs.CodeValues

Nmbrs.Company

Nmbrs.Debtor

Nmbrs.Employees

Nmbrs.Native

Nmbrs.Views

Esempi di Query

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

Attributi

Le caratteristiche di questa piattaforma sono riportate nella pagina Attributes.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: