Minox Data Model
Minox ist ein Online-Buchhaltungspaket, das in den Niederlanden von Unternehmern und Buchhaltern verwendet wird.
Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/minox
The data is partitioned per Administration (administration_code).
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
- Mit einer Query können mehrere Unternehmen gleichzeitig abgerufen werden.
- Invantive Cloud plans: Free for Exact Online, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Angaben
| Figure | Count |
|---|---|
| Tables | 148 |
| Columns | 4,745 |
| Tabellen mit Einfügung | 1 |
| Tabellen mit Aktualisierung | 0 |
| Tabellen mit Löschfunktion | 0 |
| Tabellen dokumentiert | 11 |
Poster zum Daten Muster
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
Anderes
Accruals, ProposalAccruals, CostCenters
Accrual (ohne Beziehungen)
Verwaltung (ohne Beziehungen)
AdministrationAddressEmailAddresses, AdministrationAddressEmailAddresses2, AdministrationAddressPhoneNumbers, AdministrationAddresses, AdministrationAddresses2, AdministrationAddresssPhoneNumbers, AdministrationBanks, AdministrationById, AdministrationCustomFields, AdministrationFiscalYears, AdministrationLayouts, AdministrationOrderProcesses, Administrations
Bank (ohne Beziehungen)
Budget (ohne Beziehungen)
Kosten (ohne Beziehungen)
CostTypes, Cost_centerSearchBudget, Cost_typeSearchBudget
Benutzerdefiniert (ohne Beziehungen)
Kunde (ohne Beziehungen)
Distanz (ohne Beziehungen)
Dokument (ohne Beziehungen)
DocumentBlobs, DocumentProcessLogs, Documents
E-Mail (ohne Beziehungen)
Fiscal (ohne Beziehungen)
Element (ohne Beziehungen)
Journal (ohne Beziehungen)
Layout (ohne Beziehungen)
Loket (ohne Beziehungen)
LoketNlLoonrunCheckForNew, LoketNlLoonruns, LoketNlSettings
Mollie (ohne Beziehungen)
NATIVEPLATFORMSCALARREQUESTS (ohne Beziehungen)
Nmbr (ohne Beziehungen)
NmbrsCompanySettings, NmbrsLoonruns, NmbrsSettings
Ocr (ohne Beziehungen)
OcrHistories, OcrProposals, OcrTransactionProposals
Auftrag (ohne Beziehungen)
Paragon (ohne Beziehungen)
ParagonHistories, ParagonSettings
Payment (ohne Beziehungen)
Gewinn (ohne Beziehungen)
Region (ohne Beziehungen)
Vertreter (ohne Beziehungen)
Searched (ohne Beziehungen)
SearchedCostCenters, SearchedCostTypes
Vat (ohne Beziehungen)
Webhook (ohne Beziehungen)
Xml (ohne Beziehungen)
Beziehungen
- Accruals → CostCenters (Schlüssel)
- ProposalAccruals → CostCenters (Schlüssel)
Tabellen
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: Skalare Anfragen auf nativen Plattformen
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
Beispiel-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
Attribute
Die Eigenschaften dieser Plattform finden Sie auf der Seite Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: