invantive documentation
Invantive Support ForumsLog In / Sign Up

Minox Data Model

Minox is an online accounting package used in the Netherlands by entrepreneurs and accounting professionals.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/minox

The data is partitioned per Administration (administration_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: Free for Exact Online, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Figures

Figure Count
Tables 148
Columns 4,745
Tables with insert 1
Tables with update 0
Tables with delete 0
Tables documented 11

Data Model Poster

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Minox data model, Sheet 1 of 1Minox data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026OtherSheet 1 of 1 · documentation.invantive.euOtherMinox.FinancialAccruals.Accruals: AccrualsAccrualsMinox.FinancialAccruals.ProposalAccruals: Proposal AccrualsProposalAccrualsMinox.MasterDataCostCenter.CostCenters: Cost CentresCostCentersAccrualMinox.FinancialAccruals.AccrualSettings: Accrual SettingsAccrualSettingsAdministrationMinox.MasterDataAdministration.AdministrationAddressEmailAddresses: Administration Address Email AddressesAdministrationAddressEmailAddressesMinox.MasterDataAdministration.AdministrationAddressEmailAddresses2: Administration Address Email AddressesAdministrationAddressEmailAddresses2Minox.MasterDataAdministration.AdministrationAddressPhoneNumbers: Administration Address Phone NumbersAdministrationAddressPhoneNumbersMinox.MasterDataAdministration.AdministrationAddresses: Administration AddressesAdministrationAddressesMinox.MasterDataAdministration.AdministrationAddresses2: Administration AddressesAdministrationAddresses2Minox.MasterDataAdministration.AdministrationAddresssPhoneNumbers: Administration Address Phone NumbersAdministrationAddresssPhoneNumbersMinox.MasterDataAdministration.AdministrationBanks: Administration BanksAdministrationBanksMinox.MasterDataAdministration.AdministrationById: Administration by IDAdministrationByIdMinox.MasterDataAdministration.AdministrationCustomFields: Administration Custom FieldsAdministrationCustomFieldsMinox.MasterDataAdministration.AdministrationFiscalYears: Administration Fiscal YearsAdministrationFiscalYearsMinox.MasterDataAdministration.AdministrationLayouts: Administration LayoutsAdministrationLayoutsMinox.MasterDataAdministration.AdministrationOrderProcesses: Administration Order ProcessesAdministrationOrderProcessesMinox.MasterDataAdministration.Administrations: AdministrationsAdministrationsBankMinox.MasterDataAdministration.Banks: BanksBanksBudgetMinox.MasterDataBudget.Budgets: BudgetsBudgetsCostMinox.MasterDataCostType.CostTypes: Cost TypesCostTypesMinox.MasterDataBudget.Cost_centerSearchBudget: itgen_minox_cost_centersearchbudget_pluralCost_centerSearchBudgetMinox.MasterDataBudget.Cost_typeSearchBudget: itgen_minox_cost_typesearchbudget_pluralCost_typeSearchBudgetCustomMinox.MasterDataAdministration.CustomFieldAdministrations: Custom Field AdministrationsCustomFieldAdministrationsCustomerMinox.MasterDataCustomerType.CustomerTypes: Customer TypesCustomerTypesDistanceMinox.DistanceSales.DistanceSales: Distance SalesDistanceSalesDocumentMinox.MasterDataDocument.DocumentBlobs: Document BLOBsDocumentBlobsMinox.MasterDataDocument.DocumentProcessLogs: Document Processing LogsDocumentProcessLogsMinox.MasterDataDocument.Documents: DocumentsDocumentsEmailMinox.OtherEmail.EmailHistories: Email HistoriesEmailHistoriesFiscalMinox.MasterDataAdministration.FiscalYears: Fiscal YearsFiscalYearsItemMinox.MasterDataItemGroup.ItemGroups: Item GroupsItemGroupsJournalMinox.MasterDataJournal.JournalTerms: Journal TermsJournalTermsMinox.MasterDataJournal.Journals: JournalsJournalsLayoutMinox.MasterDataAdministration.Layouts: LayoutsLayoutsLoketMinox.ThirdPartyLoketNl.LoketNlLoonrunCheckForNew: Loket.nl Payroll Run Check for NewLoketNlLoonrunCheckForNewMinox.ThirdPartyLoketNl.LoketNlLoonruns: Loket.nl Payroll RunsLoketNlLoonrunsMinox.ThirdPartyLoketNl.LoketNlSettings: Loket.nl SettingsLoketNlSettingsMollieMinox.ThirdPartyMollie.MollieSettings: Mollie SettingsMollieSettingsNATIVEPLATFORMSCALARREQUESTSMinox.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSNmbrMinox.ThirdPartyNmbrs.NmbrsCompanySettings: Nmbrs Company SettingsNmbrsCompanySettingsMinox.ThirdPartyNmbrs.NmbrsLoonruns: Nmbrs Payroll RunsNmbrsLoonrunsMinox.ThirdPartyNmbrs.NmbrsSettings: Nmbrs SettingsNmbrsSettingsOcrMinox.OtherOcr.OcrHistories: OCR HistoriesOcrHistoriesMinox.OtherOcr.OcrProposals: OCR ProposalsOcrProposalsMinox.OtherOcr.OcrTransactionProposals: OCR Transaction ProposalsOcrTransactionProposalsOrderMinox.MasterDataAdministration.OrderProcesses: Order ProcessesOrderProcessesMinox.CodeValues.OrderTypes: Domain OrderTypesOrderTypesParagonMinox.ThirdPartyParagon.ParagonHistories: Paragon HistoriesParagonHistoriesMinox.ThirdPartyParagon.ParagonSettings: Paragon SettingsParagonSettingsPaymentMinox.MasterDataPaymentTerm.PaymentTerms: Payment TermsPaymentTermsProfitMinox.MasterDataProfitLossBalance.ProfitLossBalances: Profit/Loss and BalancesProfitLossBalancesRegionMinox.MasterDataRegion.Regions: RegionsRegionsRepresentativeMinox.MasterDataRepresentative.Representatives: RepresentativesRepresentativesSearchedMinox.MasterDataCostCenter.SearchedCostCenters: Searched Cost CentresSearchedCostCentersMinox.MasterDataCostType.SearchedCostTypes: Searched Cost TypesSearchedCostTypesVatMinox.MasterDataVat.Vats: VATsVatsWebhookMinox.ThirdPartyWebhook.Webhooks: WebhooksWebhooksXmlMinox.CodeValues.XmlMessageTypes: Domain XmlMessageTypesXmlMessageTypesMinoxData dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsOther1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n relations between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/minox
The poster as text: tables per topic and their relations

Other

Accruals, ProposalAccruals, CostCenters

Accrual (without relations)

AccrualSettings

Administration (without relations)

AdministrationAddressEmailAddresses, AdministrationAddressEmailAddresses2, AdministrationAddressPhoneNumbers, AdministrationAddresses, AdministrationAddresses2, AdministrationAddresssPhoneNumbers, AdministrationBanks, AdministrationById, AdministrationCustomFields, AdministrationFiscalYears, AdministrationLayouts, AdministrationOrderProcesses, Administrations

Bank (without relations)

Banks

Budget (without relations)

Budgets

Cost (without relations)

CostTypes, Cost_centerSearchBudget, Cost_typeSearchBudget

Custom (without relations)

CustomFieldAdministrations

Customer (without relations)

CustomerTypes

Distance (without relations)

DistanceSales

Document (without relations)

DocumentBlobs, DocumentProcessLogs, Documents

Email (without relations)

EmailHistories

Fiscal (without relations)

FiscalYears

Item (without relations)

ItemGroups

Journal (without relations)

JournalTerms, Journals

Layout (without relations)

Layouts

Loket (without relations)

LoketNlLoonrunCheckForNew, LoketNlLoonruns, LoketNlSettings

Mollie (without relations)

MollieSettings

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Nmbr (without relations)

NmbrsCompanySettings, NmbrsLoonruns, NmbrsSettings

Ocr (without relations)

OcrHistories, OcrProposals, OcrTransactionProposals

Order (without relations)

OrderProcesses, OrderTypes

Paragon (without relations)

ParagonHistories, ParagonSettings

Payment (without relations)

PaymentTerms

Profit (without relations)

ProfitLossBalances

Region (without relations)

Regions

Representative (without relations)

Representatives

Searched (without relations)

SearchedCostCenters, SearchedCostTypes

Vat (without relations)

Vats

Webhook (without relations)

Webhooks

Xml (without relations)

XmlMessageTypes

Relations

Tables

Minox.CodeValues

Minox.DistanceSales

Minox.FinancialAccruals

Minox.FinancialPayable

Minox.FinancialReceivable

Minox.FinancialReporting

Minox.FinancialTransactionLineBatch

Minox.FinancialTransactionLines

Minox.MasterDataAdministration

Minox.MasterDataBudget

Minox.MasterDataCostCenter

Minox.MasterDataCostType

Minox.MasterDataCustomer

Minox.MasterDataCustomerType

Minox.MasterDataDocument

Minox.MasterDataItem

Minox.MasterDataItemGroup

Minox.MasterDataJournal

Minox.MasterDataLedger

Minox.MasterDataMandate

Minox.MasterDataPaymentTerm

Minox.MasterDataProfitLossBalance

Minox.MasterDataRegion

Minox.MasterDataRepresentative

Minox.MasterDataSupplier

Minox.MasterDataVat

Minox.Native

Minox.Ordering

Minox.OtherDocument

Minox.OtherDocumentTexts

Minox.OtherEmail

Minox.OtherImport

Minox.OtherOcr

Minox.ThirdPartyLoketNl

Minox.ThirdPartyMollie

Minox.ThirdPartyNmbrs

Minox.ThirdPartyParagon

Minox.ThirdPartyWebhook

Sample Queries

--
-- Retrieve companies from Minox.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/minox-data-model/webhelp/minox-connector-masterdataadministration-administrations.html
--
select *
from   Minox.MasterDataAdministration.Administrations@mnx
limit  100

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

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