Yuki Data Model
Yuki online accounting package.
Set up this platform in Invantive Cloud: https://cloud.invantive.com/yuki
The data is partitioned per Company (COMPANY_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: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Language of its user community: Dutch.
Figures
| Figure | Count |
|---|---|
| Tables | 72 |
| Columns | 1,133 |
| Tables with insert | 1 |
| Tables with update | 0 |
| Tables with delete | 0 |
| Tables documented | 1 |
Data Model Poster
This data model declares no keys yet; the dotted relations are derived from column names.
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
CostCategories, Currencies, Menus, PaymentMethods, Administrations, Companies, Domains, SupportedLanguages, Contacts, DomainFunctions, SuppliersAndCustomers, Users
Document (without relations)
NATIVEPLATFORMSCALARREQUESTS (without relations)
Relations
- CostCategories → Domains (candidate): Derived from the column DOMAINID.
- Currencies → Domains (candidate): Derived from the column DOMAINID.
- Menus → Domains (candidate): Derived from the column DOMAINID.
- PaymentMethods → Domains (candidate): Derived from the column DOMAINID.
- Administrations → Domains (candidate): Derived from the column DOMAINID.
- Companies → Domains (candidate): Derived from the column DOMAINID.
- SupportedLanguages → Domains (candidate): Derived from the column DOMAINID.
- Contacts → Domains (candidate): Derived from the column domain_ID.
- DomainFunctions → Domains (candidate): Derived from the column domain_ID.
- SuppliersAndCustomers → Domains (candidate): Derived from the column domain_ID.
- Users → Domains (candidate): Derived from the column domain_ID.
Tables
Yuki.Accounting
- BalancesByDate: Balances by Date
- CheckOutstandingAdminItemsByReference: Check Outstanding Admin Items by Reference
- CheckOutstandingItemsByReference: Check Outstanding Items by Reference
- FiscalBalancesByDate: Fiscal Balances by Date
- FiscalNetRevenues: Fiscal Net Revenues
- FiscalTransactions: Fiscal Transactions
- NetRevenues: Net Revenues
- OutstandingCreditorItems: Outstanding Creditor Items
- OutstandingCreditorItemsByDate: Outstanding Creditor Items by Date
- OutstandingCreditorItemsByDateOutstanding: itgen_yuki_outstanding_creditor_items_by_date_outstanding
- OutstandingCreditorItemsWithPaymentReference: itgen_yuki_outstanding_creditor_items_with_payment_reference
- OutstandingDebtorItems: Outstanding Debtor Items
- OutstandingDebtorItemsByDate: Outstanding Debtor Items by Date
- OutstandingDebtorItemsByDateOutstanding: itgen_yuki_outstanding_debtor_items_by_date_outstanding
- OutstandingDebtorItemsWithLanguage: itgen_yuki_outstanding_debtor_items_with_language
- OutstandingDebtorItemsWithPaymentReference: itgen_yuki_outstanding_debtor_items_with_payment_reference
- Transactions: Transactions
- TransactionsAndContacts: Transactions and Contacts
- YearEndBalancesByDate: Year-End Balances by Date
Yuki.AccountingInfo
- ContactDefaultValuesByContactId: Contact Default Values by Contact ID
- CustomPaymentMethods: Custom Payment Methods
- DocumentsByTransaction: Documents by Transaction
- FinancialPeriodsByYear: Financial Periods by Year
- FinancialYearModifiedDatesByYear: Financial Year Modified Dates by Year
- GLAccountSchemes: GL Account Schemes
- ProjectBalancesByDate: Project Balances by Date
- ProjectDetails: Project Details
- Projects: Projects
- RGSSchemes: RGS Schemes
- StartBalancesByYear: Opening Balances by Year
- TransactionDetailsByDate: Transaction Details by Date
- TransactionsByPeriod: Transactions by Period
Yuki.Archive
- ArchiveProjects: Projects
- CostCategories: Cost Categories
- Currencies: Currencies
- DocumentBinaryDataById: Document Binary Data by ID
- DocumentById: Document by ID
- DocumentDownloadUrlByDocumentId: itgen_yuki_document_download_url_by_document_id
- DocumentFolderCounts: Document Folder Counts
- DocumentFolderTabsByFolderId: Document Folder Tabs by Folder ID
- DocumentFolders: Document Folders
- DocumentImageByDocumentId: Document Image by Document ID
- DocumentImageCountByDocumentId: Document Image Count by Document ID
- DocumentXmlDataByDocumentId: itgen_yuki_document_xml_data_by_document_id
- Documents: Documents
- DocumentsByFolderId: Documents by Folder ID
- DocumentsBySearchCriteria: Documents by Search Criteria
- DocumentsByTabId: Documents by Tab ID
- DocumentsByType: itgen_yuki_documents_by_type
- Menus: Menus
- ModifiedDocumentsByFolderId: itgen_yuki_modified_documents_by_folder_id
- ModifiedDocumentsByType: itgen_yuki_modified_documents_by_type
- PaymentMethods: Payment Methods
Yuki.Contact
- ContactsByDomainId: Contacts by Domain ID
- SuppliersAndCustomersByDomainId: Suppliers and Customers by Domain ID
Yuki.Domains
- DomainFunctionsByDomainId: Domain Functions by Domain ID
- UsersByDomainId: Users by Domain ID
Yuki.General
- Administrations: Administrations
- Companies: Companies
- Domains: Domains
- SupportedLanguages: Supported Languages
Yuki.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Yuki.Purchase
- PurchaseInvoiceSchemas: Purchase Invoice Schemas
Yuki.Sales
- SalesInvoiceSchemas: Sales Invoice Schemas
- SalesItems: Sales Items
Yuki.Vat
- ActiveVatCodes: Active VAT Codes
- VatReturnsByYear: VAT Returns by Year
Yuki.Views
- Contacts: Contacts
- DocumentFolderTabs: Document Folder Tabs
- DomainFunctions: Domain Functions
- SuppliersAndCustomers: Suppliers and Customers
- Users: Users
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: