Minox Data Model
Minox è un pacchetto di contabilità online utilizzato nei Paesi Bassi da imprenditori e professionisti della contabilità.
Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/minox
The data is partitioned per Administration (administration_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.
- Invantive Cloud plans: Free for Exact Online, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Figure
| Figure | Count |
|---|---|
| Tables | 148 |
| Columns | 4,745 |
| Tabella con inserti | 1 |
| Tabella con aggiornamento | 0 |
| Tabella con la clausola DELETE | 0 |
| Tabella documentata | 11 |
Poster sul modello di dati
Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.
Il poster come testo: tabelle per argomento e le loro relazioni
Altro
Accruals, ProposalAccruals, CostCenters
Accrual (senza relazioni)
Amministrazione (senza relazioni)
AdministrationAddressEmailAddresses, AdministrationAddressEmailAddresses2, AdministrationAddressPhoneNumbers, AdministrationAddresses, AdministrationAddresses2, AdministrationAddresssPhoneNumbers, AdministrationBanks, AdministrationById, AdministrationCustomFields, AdministrationFiscalYears, AdministrationLayouts, AdministrationOrderProcesses, Administrations
Banca (senza relazioni)
Bilancio (senza relazioni)
Costo (senza relazioni)
CostTypes, Cost_centerSearchBudget, Cost_typeSearchBudget
Personalizzato (senza relazioni)
cliente (senza relazioni)
Distanza (senza relazioni)
Documento (senza relazioni)
DocumentBlobs, DocumentProcessLogs, Documents
E-mail (senza relazioni)
Fiscal (senza relazioni)
Articolo (senza relazioni)
Diario (senza relazioni)
Disposizione in senso orizzontale (senza relazioni)
Loket (senza relazioni)
LoketNlLoonrunCheckForNew, LoketNlLoonruns, LoketNlSettings
Mollie (senza relazioni)
NATIVEPLATFORMSCALARREQUESTS (senza relazioni)
Nmbr (senza relazioni)
NmbrsCompanySettings, NmbrsLoonruns, NmbrsSettings
Ocr (senza relazioni)
OcrHistories, OcrProposals, OcrTransactionProposals
Ordinamento (senza relazioni)
Paragon (senza relazioni)
ParagonHistories, ParagonSettings
Payment (senza relazioni)
Profitto (senza relazioni)
Regione (senza relazioni)
Rappresentante (senza relazioni)
Searched (senza relazioni)
SearchedCostCenters, SearchedCostTypes
Vat (senza relazioni)
Webhook (senza relazioni)
Xml (senza relazioni)
Relazioni
- Accruals → CostCenters (chiave)
- ProposalAccruals → CostCenters (chiave)
Tabelle
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: Richieste scalari della piattaforma nativa
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
Esempi di Query
--
-- 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
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: