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
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
Other
Accruals, ProposalAccruals, CostCenters
Accrual (without relations)
Administration (without relations)
AdministrationAddressEmailAddresses, AdministrationAddressEmailAddresses2, AdministrationAddressPhoneNumbers, AdministrationAddresses, AdministrationAddresses2, AdministrationAddresssPhoneNumbers, AdministrationBanks, AdministrationById, AdministrationCustomFields, AdministrationFiscalYears, AdministrationLayouts, AdministrationOrderProcesses, Administrations
Bank (without relations)
Budget (without relations)
Cost (without relations)
CostTypes, Cost_centerSearchBudget, Cost_typeSearchBudget
Custom (without relations)
Customer (without relations)
Distance (without relations)
Document (without relations)
DocumentBlobs, DocumentProcessLogs, Documents
Email (without relations)
Fiscal (without relations)
Item (without relations)
Journal (without relations)
Layout (without relations)
Loket (without relations)
LoketNlLoonrunCheckForNew, LoketNlLoonruns, LoketNlSettings
Mollie (without relations)
NATIVEPLATFORMSCALARREQUESTS (without relations)
Nmbr (without relations)
NmbrsCompanySettings, NmbrsLoonruns, NmbrsSettings
Ocr (without relations)
OcrHistories, OcrProposals, OcrTransactionProposals
Order (without relations)
Paragon (without relations)
ParagonHistories, ParagonSettings
Payment (without relations)
Profit (without relations)
Region (without relations)
Representative (without relations)
Searched (without relations)
SearchedCostCenters, SearchedCostTypes
Vat (without relations)
Webhook (without relations)
Xml (without relations)
Relations
- Accruals → CostCenters (key)
- ProposalAccruals → CostCenters (key)
Tables
Minox.CodeValues
- OrderTypes: Domain OrderTypes
- XmlMessageTypes: Domain XmlMessageTypes
Minox.DistanceSales
- DistanceSales: Distance Sales
- DistanceSalesById: Distance Sale by ID
Minox.FinancialAccruals
- AccrualByAccrualId: Accrual by Accrual ID
- AccrualProposalsByAccrualId: Accrual Proposals by Accrual ID
- AccrualSettings: Accrual Settings
- Accruals: Accruals
- ProposalAccruals: Proposal Accruals
Minox.FinancialPayable
- Payables: Payables
Minox.FinancialReceivable
- Receivables: Receivables
Minox.FinancialReporting
- ReportColumnbalanceFiscalYear: Report Column Balance in Fiscal Year
- ReportCountriesFiscalYear: Report for Countries in Fiscal Year
- ReportCurrenciesFiscalYear: Report for Currencies in Fiscal Year
- ReportJournalbalanceFiscalYear: Report for Journal Balance in Fiscal Year
- ReportPayablesFiscalYear: Report for Payables in Fiscal Year
- ReportPeriodTrialbalanceFiscalYear: Report for Period Trial Balance in Fiscal Year
- ReportProfitlossFiscalYear: Report for Profit&Loss in Fiscal Year
- ReportReceivablesFiscalYear: Report for Receivables in Fiscal Year
- ReportRgsTrialbalanceFiscalYearReportRgsTrialbalance: Report for RGS Trial Balance in Fiscal Year
- ReportTrialbalanceFiscalYear: Report for Trial Balance in Fiscal Year
- ReportYearoverviewFiscalYear: Report for Year Overview in Fiscal Year
Minox.FinancialTransactionLineBatch
- TransactionLineBatch_Cost_centerSearchBatchId: itgen_minox_transactionlinebatch_cost_centersearchbatchid_plural
- TransactionLineBatch_Cost_typeSearchBatchId: itgen_minox_transactionlinebatch_cost_typesearchbatchid_plural
- TransactionLinesByBatchId: Transaction Lines by Batch ID
Minox.FinancialTransactionLines
- TransactionLinesByFiscalYearPeriod: Transaction Lines by Fiscal Year and Period
- YearFiscalYear_CollectionCost_centerSearchTransactionLines: itgen_minox_yearfiscalyear_collectioncost_centersearchtransactionlines_plural
- YearFiscalYear_CollectionCost_typeSearchTransactionLines: itgen_minox_yearfiscalyear_collectioncost_typesearchtransactionlines_plural
Minox.MasterDataAdministration
- AdministrationAddressEmailAddresses: Administration Address Email Addresses
- AdministrationAddressEmailAddresses2: Administration Address Email Addresses
- AdministrationAddressPhoneNumbers: Administration Address Phone Numbers
- AdministrationAddresses: Administration Addresses
- AdministrationAddresses2: Administration Addresses
- AdministrationAddresssPhoneNumbers: Administration Address Phone Numbers
- AdministrationBanks: Administration Banks
- AdministrationById: Administration by ID
- AdministrationCustomFields: Administration Custom Fields
- AdministrationFiscalYears: Administration Fiscal Years
- AdministrationLayouts: Administration Layouts
- AdministrationOrderProcesses: Administration Order Processes
- Administrations: Administrations
- Banks: Banks
- CustomFieldAdministrations: Custom Field Administrations
- FiscalYears: Fiscal Years
- Layouts: Layouts
- OrderProcesses: Order Processes
Minox.MasterDataBudget
- Budgets: Budgets
- Cost_centerSearchBudget: itgen_minox_cost_centersearchbudget_plural
- Cost_typeSearchBudget: itgen_minox_cost_typesearchbudget_plural
Minox.MasterDataCostCenter
- CostCenters: Cost Centres
- SearchedCostCenters: Searched Cost Centres
Minox.MasterDataCostType
- CostTypes: Cost Types
- SearchedCostTypes: Searched Cost Types
Minox.MasterDataCustomer
- CustomCustomFieldsByEmail: Custom Custom Fields by Email
- CustomFieldCustomers: Custom Field Customers
- Customer2ById: Customer by ID
- CustomerAddressByCustomerId: Customer Address by Customer ID
- CustomerAddressEmailAddresses: Customer Address Email Addresses
- CustomerAddressEmailAddressesByEmail: Customer Address Email Addresses by Email
- CustomerAddressEmailAddressesByExternalId: itgen_minox_customeraddressemailaddressesbyexternalid_plural
- CustomerAddressEmailAddressesById: Customer Address Email Addresses by ID
- CustomerAddressPhoneNumberByExternalId: Customer Address Phone Number by External ID
- CustomerAddressPhoneNumbersByEmail: Customer Address Phone Numbers by Email
- CustomerAddressPhoneNumbersById: Customer Address Phone Numbers by ID
- CustomerAddresses: Customer Addresses
- CustomerAddressesByExternalId: Customer Addresses by External ID
- CustomerAddresssPhoneNumbers: Customer Address Phone Numbers
- CustomerById: Customer by ID
- CustomerCustomFieldsByCustomerId: Customer Custom Fields by Customer ID
- CustomerCustomFieldsByExternalId: Customer Custom Fields by External ID
- Customers: Customers
- CustomersByEmail: Customers by Email
- CustomersByEmail2: Customers by Email
- CustomersByExternalId: Customers by External ID
- CustomersSearchedByEmail: Customers Searched by Email
- SearchedCustomers: Searched Customers
- SearchedCustomersByExternalId: Searched Customers by External ID
Minox.MasterDataCustomerType
- CustomerTypes: Customer Types
Minox.MasterDataDocument
- DocumentBlobs: Document BLOBs
- DocumentById: Document by ID
- DocumentProcessLogs: Document Processing Logs
- Document_DocumentBlobsDocumentId: itgen_minox_document_documentblobsdocumentid_plural
- Document_DocumentProcess_logsDocumentId: itgen_minox_document_documentprocess_logsdocumentid_plural
- Documents: Documents
Minox.MasterDataItem
- CustomFieldItems: Custom Field Items
- ItemById: Item by ID
- ItemById2: Item by ID
- ItemCustomFieldsByItemId: Item Custom Fields by Item ID
- ItemPriceDeviantsByItemId: Item Price Deviants by Item ID
- Items: Items
- PriceDeviants: Price Deviants
- SearchItems: Search Items
Minox.MasterDataItemGroup
- ItemGroups: Item Groups
Minox.MasterDataJournal
- JournalTerms: Journal Terms
- Journals: Journals
Minox.MasterDataLedger
- Cost_typeSearchLedgerAccount: itgen_minox_cost_typesearchledgeraccount_plural
- LedgerAccountById: Ledger Account by ID
- LedgerAccount_Cost_typeSearchAccountId: itgen_minox_ledgeraccount_cost_typesearchaccountid_plural
- LedgerAccounts: Ledger Accounts
Minox.MasterDataMandate
- MandateById: Mandate by ID
- Mandates: Mandates
Minox.MasterDataPaymentTerm
- PaymentTerms: Payment Terms
Minox.MasterDataProfitLossBalance
- ProfitLossBalances: Profit/Loss and Balances
Minox.MasterDataRegion
- Regions: Regions
Minox.MasterDataRepresentative
- Representatives: Representatives
Minox.MasterDataSupplier
- SupplierByEmail: Supplier by Email
- SupplierByExternalId: Supplier by External ID
- SupplierById: Supplier by ID
- Suppliers: Suppliers
Minox.MasterDataVat
- Vats: VATs
Minox.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Minox.Ordering
- OrderDocumentBlobsById: Order Document BLOBs by ID
- OrderDocumentById: Order Document by ID
- OrderLinesByOrderDocumentId: Order Lines by Order Document ID
- OrderLinesByType: Order Lines by Type
- OrderSummaryLinesByType: Order Summary Lines by Type
- OrderSummaryVatTotalsByType: Order Summary VAT Totals by Type
- OrderVatTotalsByOrderDocumentId: Order VAT Totals by Order Document ID
- OrderVatTotalsByType: Order VAT Totals by Type
- OrderingSummaryByType: Ordering Summary by Type
- OrderingTasks: Ordering Tasks
- OrderingTasksByTaskId: Ordering Tasks by Task ID
- OrdersByType: Orders by Type
Minox.OtherDocument
- DocumentBlobsByDocumentId: Document BLOBs by Document ID
- TransactionLineBlobsByBatchId: Transaction Line BLOBs by Batch ID
Minox.OtherDocumentTexts
- DocumentTexts: Document Texts
Minox.OtherEmail
- EmailHistories: Email Histories
- EmailHistoryAttachmentsByEmail: Email History Attachments by Email
Minox.OtherImport
- ImportTasks: Import Tasks
Minox.OtherOcr
- OcrHistories: OCR Histories
- OcrHistoriesByID: OCR Histories by ID
- OcrHistoryById: OCR History by ID
- OcrProposals: OCR Proposals
- OcrSettings: OCR Settings
- OcrTransactionProposals: OCR Transaction Proposals
Minox.ThirdPartyLoketNl
- LoketNlConnectState: Loket.nl Connection State
- LoketNlLoonrunCheckForNew: Loket.nl Payroll Run Check for New
- LoketNlLoonruns: Loket.nl Payroll Runs
- LoketNlSettings: Loket.nl Settings
Minox.ThirdPartyMollie
- MollieSettings: Mollie Settings
Minox.ThirdPartyNmbrs
- NmbrsCompanySettings: Nmbrs Company Settings
- NmbrsLoonruns: Nmbrs Payroll Runs
- NmbrsSettings: Nmbrs Settings
Minox.ThirdPartyParagon
- ParagonHistories: Paragon Histories
- ParagonSettings: Paragon Settings
Minox.ThirdPartyWebhook
- WebhookById: Webhook by ID
- WebhookHistoriesById: Webhook Histories by ID
- Webhooks: Webhooks
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: