Twinfield-datamodel
Twinfield is een online boekhoudpakket dat in Nederland en België wordt gebruikt. Accountants vormen een groot deel van de Twinfield-gebruikersgemeenschap.
Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/twinfield
De gegevens zijn gepartitioneerd per Bedrijf (COMPANY_CODE).
Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.
Platform
- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Met één Query kunnen meerdere bedrijven tegelijk worden opgehaald.
- Invantive Cloud-abonnementen: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Taal van de gebruikersgemeenschap: Nederlands.
Cijfers
| Figure | Count |
|---|---|
| Tables | 251 |
| Columns | 14,640 |
| Tabeller med invoegsel | 1 |
| Tabeller med update | 0 |
| Tabellen met de functie 'verwijderen' | 0 |
| Tabeller gedocumenteerd | 93 |
Poster met datamodel
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden
Twinfield · Offices
AnnualReportTotals, AnnualReportTotalsMulticurrency, AnnualReportYtd, AssetMethods, AssetTransactions, BankLinkDetails, BankLinkDetailsV2, BillingSchedules, Budgets, Certificates, CommercialAnnualReportTotals, CommercialAnnualReportTotalsMulticurrency, CommercialAnnualReportYtd, CostCenters, CreditManagement, CreditManagementActionCodes, Currencies, CustomerTransactions, Customers, CustomersV2, CustomersV3, Declarations, DistributionByPeriods, EconomicAnnualReportTotals, EconomicAnnualReportTotalsMulticurrency, EconomicAnnualReportYtd, FilterMappings, FinancialDimensions, FiscalAnnualReportTotals, FiscalAnnualReportTotalsMulticurrency, FiscalAnnualReportYtd, FixedAssets, Gateways, GeneralLedgerDetails, GeneralLedgerDetailsV2, GeneralLedgerDetailsV3, GeneralLedgerIntercompany, GeneralLedgerIntercompanyV2, GeneralLedgerTransactions, HierarchyAccess, IctCountries, MatchingTypes, OfficeGroups, Offices, OfficesForInterCompanyTransactions, PayinginSlips, PaymentFiles, Periods, ProjectDimensions, ProjectTransactions, ReminderScenarios, Reports, Roles, SupplierTransactions, Suppliers, SuppliersV2, TaxGroups, TimeAndExpensesBillingDetails, TimeAndExpensesBillingPerPeriod, TimeAndExpensesBillingPerWeek, TimeAndExpensesDetails, TimeAndExpensesMulticurrency, TimeAndExpensesTotals, TimeAndExpensesTotalsPerPeriod, TimeAndExpensesTotalsPerWeek, TimeAndQuantitiesTransactionTypes, TransactionList, TransactionSummary, TransactionsToBeMatched, Translations, VATCodes, VATGroupCountries, VATGroups, VATNumberOfRelations, VatReturnStatus, VatTypes, WordTemplates
Twinfield
Assets, BalancesheetBanks, BalancesheetChildValidations, BalancesheetGroups, Balancesheets, CostCenters, ProfitAndLoss, ProfitAndLossBanks, ProfitAndLossChildValidations, ProfitAndLossGroups
Dimensions · Customers
CustomerAddresses, CustomerBanks, CustomerChildValidations, CustomerPaymentConditions, Customers
Dimensions · Suppliers
SupplierAddresses, SupplierBanks, SupplierChildValidations, SupplierPaymentConditions, Suppliers
Dimensions · Activities
Activities, ActivityChildValidations, ActivityProjectQuantities
Dimensions · Projects
ProjectChildValidations, ProjectQuantities, Projects
Twinfield · CashbooksAndBanks
BankTransactions, CashTransactions, CashbooksAndBanks
ActiveAnalysis (zonder relaties)
CodeValues (zonder relaties)
AccessTypes, AddressTypes, ArticleTypes, AssetCalculationMethods, AssetStatuses, BankTransactionTypeFilters, BrowseCodes, BrowseOperators, BrowseSortOrders, CollectionSchemas, Cultures, DebitCredits, DepreciationStartMoments, DimensionBehaviours, DimensionLevels, DimensionStatuses, DimensionTypeCodes, FinderSearchFields, FinderTypeCodes, FreeTextTypes, InvitationStatuses, ItemValueVatInclusions, MatchStatuses, MatchTypes, MatchingTypeCodes, MeansOfPayment, PayAddresses, PerformanceTypes, RateTypes, SalesInvoicePaymentMethods, SalesInvoiceStatuses, SendReminders, SendTypes, SepaDirectDebitSchemes, SingleSignOnSettings, SmsLogonServices, SubAnalyses, SubscriptionChangeReasons, SubstitutionLevels, SubstitutionTypes, TemplateCompanyAccesses, TimeEntryTypes, TimeTransactionCodes, TransactionLineTypes, TransactionStatuses, UserTypes, VatCodeLineTypes, VatCodeTypes, WaysOfPayment, WordTemplateKinds
Native (zonder relaties)
Twinfield (zonder relaties)
Cheques, DocketInvoices, PlatformVersion, TableColumnSpecifications
Views (zonder relaties)
ActivityDimensionValues, ArticleLines, ArticleSettings, BalanceSheetDimensionValues, CostCenterBudgets, CostCenterDimensionValues, CreditorDimensionValues, DebtorDimensionValues, FinancialYears, FixedAssetDimensionValues, GeneralLedgerAccountMappingAccounts, GeneralLedgerAccountMappings, IctReturnsAsXbrl, IctReturnsAsXml, OfficeSettings, PaymentTypeSettings, Periods, PeriodsWithTransactions, ProfitAndLossBudgets, ProfitAndLossDimensionValues, ProjectBudgets, ProjectDimensionValues, ProjectRateChanges, ProjectRateSettings, SubItems, TaxGroupVatReturnPaymentReferences, TaxGroupVatReturnsAsXbrl, TaxGroupVatReturnsAsXml, UserSettings, VatCodePercentages, VatCodeSettings, VatReturnPaymentReferences, VatReturnsAsXbrl, VatReturnsAsXml
Relaties
- Activities → Offices (sleutel)
- ActivityChildValidations → Activities (sleutel)
- ActivityChildValidations → Offices (sleutel)
- ActivityProjectQuantities → Activities (sleutel)
- ActivityProjectQuantities → Offices (sleutel)
- Assets → Offices (sleutel)
- BalancesheetBanks → Offices (sleutel)
- BalancesheetChildValidations → Offices (sleutel)
- BalancesheetGroups → Offices (sleutel)
- Balancesheets → Offices (sleutel)
- CostCenters → Offices (sleutel)
- CustomerAddresses → Customers (sleutel)
- CustomerAddresses → Offices (sleutel)
- CustomerBanks → Customers (sleutel)
- CustomerBanks → Offices (sleutel)
- CustomerChildValidations → Customers (sleutel)
- CustomerChildValidations → Offices (sleutel)
- CustomerPaymentConditions → Customers (sleutel)
- CustomerPaymentConditions → Offices (sleutel)
- Customers → Offices (sleutel)
- Customers → VATCodes (sleutel)
- ProfitAndLoss → Offices (sleutel)
- ProfitAndLossBanks → Offices (sleutel)
- ProfitAndLossChildValidations → Offices (sleutel)
- ProfitAndLossGroups → Offices (sleutel)
- ProjectChildValidations → Projects (sleutel)
- ProjectChildValidations → Offices (sleutel)
- ProjectQuantities → Projects (sleutel)
- ProjectQuantities → Offices (sleutel)
- Projects → Offices (sleutel)
- SupplierAddresses → Suppliers (sleutel)
- SupplierAddresses → Offices (sleutel)
- SupplierBanks → Suppliers (sleutel)
- SupplierBanks → Offices (sleutel)
- SupplierChildValidations → Suppliers (sleutel)
- SupplierChildValidations → Offices (sleutel)
- SupplierPaymentConditions → Suppliers (sleutel)
- SupplierPaymentConditions → Offices (sleutel)
- Suppliers → Offices (sleutel)
- Suppliers → VATCodes (sleutel)
- AnnualReportTotals → Offices (sleutel)
- AnnualReportTotalsMulticurrency → Offices (sleutel)
- AnnualReportYtd → Offices (sleutel)
- AssetMethods → Offices (sleutel)
- AssetTransactions → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- AssetTransactions → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- AssetTransactions → Currencies (sleutel)
- AssetTransactions → Offices (sleutel)
- AssetTransactions → VATCodes (sleutel)
- BankLinkDetails → Offices (sleutel)
- BankLinkDetailsV2 → Offices (sleutel)
- BankTransactions → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- BankTransactions → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- BankTransactions → CashbooksAndBanks (sleutel)
- BankTransactions → Currencies (sleutel)
- BankTransactions → Offices (sleutel)
- BankTransactions → VATCodes (sleutel)
- BillingSchedules → Offices (sleutel)
- Budgets → Offices (sleutel)
- CashTransactions → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- CashTransactions → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- CashTransactions → CashbooksAndBanks (sleutel)
- CashTransactions → Currencies (sleutel)
- CashTransactions → Offices (sleutel)
- CashTransactions → VATCodes (sleutel)
- CashbooksAndBanks → Offices (sleutel)
- Certificates → Offices (sleutel)
- CommercialAnnualReportTotals → Offices (sleutel)
- CommercialAnnualReportTotalsMulticurrency → Offices (sleutel)
- CommercialAnnualReportYtd → Offices (sleutel)
- CostCenters → Offices (sleutel)
- CreditManagement → Offices (sleutel)
- CreditManagementActionCodes → Offices (sleutel)
- Currencies → Offices (sleutel)
- CustomerTransactions → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- CustomerTransactions → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- CustomerTransactions → Currencies (sleutel)
- CustomerTransactions → Offices (sleutel)
- CustomerTransactions → VATCodes (sleutel)
- Customers → Offices (sleutel)
- CustomersV2 → Offices (sleutel)
- CustomersV3 → Offices (sleutel)
- Declarations → Offices (sleutel)
- DistributionByPeriods → Offices (sleutel)
- EconomicAnnualReportTotals → Offices (sleutel)
- EconomicAnnualReportTotalsMulticurrency → Offices (sleutel)
- EconomicAnnualReportYtd → Offices (sleutel)
- FilterMappings → Offices (sleutel)
- FinancialDimensions → Offices (sleutel)
- FiscalAnnualReportTotals → Offices (sleutel)
- FiscalAnnualReportTotalsMulticurrency → Offices (sleutel)
- FiscalAnnualReportYtd → Offices (sleutel)
- FixedAssets → Offices (sleutel)
- Gateways → Offices (sleutel)
- GeneralLedgerDetails → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerDetails → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerDetails → Currencies (sleutel)
- GeneralLedgerDetails → Offices (sleutel)
- GeneralLedgerDetails → VATCodes (sleutel)
- GeneralLedgerDetailsV2 → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerDetailsV2 → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerDetailsV2 → Currencies (sleutel)
- GeneralLedgerDetailsV2 → Offices (sleutel)
- GeneralLedgerDetailsV2 → VATCodes (sleutel)
- GeneralLedgerDetailsV3 → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerDetailsV3 → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerDetailsV3 → Currencies (sleutel)
- GeneralLedgerDetailsV3 → Offices (sleutel)
- GeneralLedgerDetailsV3 → VATCodes (sleutel)
- GeneralLedgerIntercompany → Offices (sleutel)
- GeneralLedgerIntercompanyV2 → Offices (sleutel)
- GeneralLedgerTransactions → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerTransactions → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- GeneralLedgerTransactions → Currencies (sleutel)
- GeneralLedgerTransactions → Offices (sleutel)
- GeneralLedgerTransactions → VATCodes (sleutel)
- HierarchyAccess → Offices (sleutel)
- IctCountries → Offices (sleutel)
- MatchingTypes → Offices (sleutel)
- OfficeGroups → Offices (sleutel)
- OfficesForInterCompanyTransactions → Offices (sleutel)
- PayinginSlips → Offices (sleutel)
- PaymentFiles → Offices (sleutel)
- Periods → Offices (sleutel)
- ProjectDimensions → Offices (sleutel)
- ProjectTransactions → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- ProjectTransactions → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- ProjectTransactions → Currencies (sleutel)
- ProjectTransactions → Offices (sleutel)
- ProjectTransactions → VATCodes (sleutel)
- ReminderScenarios → Offices (sleutel)
- Reports → Offices (sleutel)
- Roles → Offices (sleutel)
- SupplierTransactions → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- SupplierTransactions → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- SupplierTransactions → Currencies (sleutel)
- SupplierTransactions → Offices (sleutel)
- SupplierTransactions → VATCodes (sleutel)
- Suppliers → Offices (sleutel)
- SuppliersV2 → Offices (sleutel)
- TaxGroups → Offices (sleutel)
- TimeAndExpensesBillingDetails → Offices (sleutel)
- TimeAndExpensesBillingPerPeriod → Offices (sleutel)
- TimeAndExpensesBillingPerWeek → Offices (sleutel)
- TimeAndExpensesDetails → Offices (sleutel)
- TimeAndExpensesMulticurrency → Offices (sleutel)
- TimeAndExpensesTotals → Offices (sleutel)
- TimeAndExpensesTotalsPerPeriod → Offices (sleutel)
- TimeAndExpensesTotalsPerWeek → Offices (sleutel)
- TimeAndQuantitiesTransactionTypes → Offices (sleutel)
- TransactionList → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- TransactionList → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- TransactionList → Currencies (sleutel)
- TransactionList → Offices (sleutel)
- TransactionList → VATCodes (sleutel)
- TransactionSummary → Offices (sleutel)
- TransactionsToBeMatched → Balancesheets (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- TransactionsToBeMatched → ProfitAndLoss (in woorden beschreven): Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table.
- TransactionsToBeMatched → Currencies (sleutel)
- TransactionsToBeMatched → Offices (sleutel)
- TransactionsToBeMatched → VATCodes (sleutel)
- Translations → Offices (sleutel)
- VATCodes → Offices (sleutel)
- VATGroupCountries → Offices (sleutel)
- VATGroups → Offices (sleutel)
- VATNumberOfRelations → Offices (sleutel)
- VatReturnStatus → Offices (sleutel)
- VatTypes → Offices (sleutel)
- WordTemplates → Offices (sleutel)
Tabellen
Twinfield.ActiveAnalysis
- ActiveAnalyses: Actieve analyses
Twinfield.CodeValues
- AccessTypes: Domein AccessTypes
- AddressTypes: Domein AddressTypes
- ArticleTypes: Domein ArticleTypes
- AssetCalculationMethods: Domein AssetCalculationMethods
- AssetStatuses: Domein AssetStatuses
- BankTransactionTypeFilters: Domein BankTransactionTypeFilters
- BrowseCodes: Domein BrowseCodes
- BrowseOperators: Domein BrowseOperators
- BrowseSortOrders: Domein BrowseSortOrders
- CollectionSchemas: Domein CollectionSchemas
- Cultures: Domeinculturen
- DebitCredits: Domein DebitCredits
- DepreciationStartMoments: Domein DepreciationStartMoments
- DimensionBehaviours: Domein DimensionBehaviours
- DimensionLevels: Domein DimensionLevels
- DimensionStatuses: Domein DimensionStatuses
- DimensionTypeCodes: Domein DimensionTypeCodes
- FinderSearchFields: Domein FinderSearchFields
- FinderTypeCodes: Domein FinderTypeCodes
- FreeTextTypes: Domein FreeTextTypes
- InvitationStatuses: Domein InvitationStatuses
- ItemValueVatInclusions: Domein ItemValueVatInclusions
- MatchStatuses: Domein MatchStatuses
- MatchTypes: Domein MatchTypes
- MatchingTypeCodes: Domein MatchingTypeCodes
- MeansOfPayment: Domein MeansOfPayment
- PayAddresses: Domein PayAddresses
- PerformanceTypes: Domein PerformanceTypes
- RateTypes: Domein RateTypes
- SalesInvoicePaymentMethods: Domein SalesInvoicePaymentMethods
- SalesInvoiceStatuses: Domein SalesInvoiceStatuses
- SendReminders: Domein SendReminders
- SendTypes: Domein SendTypes
- SepaDirectDebitSchemes: Domein SepaDirectDebitSchemes
- SingleSignOnSettings: Domein SingleSignOnSettings
- SmsLogonServices: Domein SmsLogonServices
- SubAnalyses: Domein SubAnalyses
- SubscriptionChangeReasons: Domein SubscriptionChangeReasons
- SubstitutionLevels: Domein SubstitutionLevels
- SubstitutionTypes: Domein SubstitutionTypes
- TemplateCompanyAccesses: Domein TemplateCompanyAccesses
- TimeEntryTypes: Domein TimeEntryTypes
- TimeTransactionCodes: Domein TimeTransactionCodes
- TransactionLineTypes: Domein TransactionLineTypes
- TransactionStatuses: Domein TransactionStatuses
- UserTypes: Domein UserTypes
- VatCodeLineTypes: Domein VatCodeLineTypes
- VatCodeTypes: Domein VatCodeTypes
- WaysOfPayment: Domein WaysOfPayment
- WordTemplateKinds: Domein WordTemplateKinds
Twinfield.Deleted
- DeletedTransactions: Verwijderde transacties
Twinfield.Dimensions
- Activities: Activities
- ActivityChildValidations: Activiteit onderliggende validaties
- ActivityProjectQuantities: Activiteit projecthoeveelheden
- Assets: Activa
- BalancesheetBanks: Balans bank
- BalancesheetChildValidations: Validaties onderliggende balans
- BalancesheetGroups: Balansgroepen
- Balancesheets: Balansen
- CostCenters: Kostenplaatsen
- CustomerAddresses: Klantadressen
- CustomerBanks: Klantbanken
- CustomerChildValidations: Validaties onderliggende debiteuren
- CustomerPaymentConditions: Betalingscondities debiteuren
- Customers: Klanten
- ProfitAndLoss: Winst en verlies
- ProfitAndLossBanks: Winst- en verliesbanken
- ProfitAndLossChildValidations: Validaties onderliggende winst-en-verliesrekening
- ProfitAndLossGroups: Winst- en verliesgroepen
- ProjectChildValidations: Project-onderliggende validaties
- ProjectQuantities: Projecthoeveelheden
- Projecten: Projecten
- SupplierAddresses: Leveranciersadressen
- SupplierBanks: Leverancierbanken
- SupplierChildValidations: Validaties onderliggende leveranciers
- SupplierPaymentConditions: Leverancierbetalingsvoorwaarden
- Suppliers: Leveranciers
Twinfield.Native
- NATIVEPLATFORMSCALARREQUESTS: Scalaire verzoeken op het native platform
Twinfield.Settings
- ArticleLinesByCode: Artikelregels per code
- ArticleSettingsByCode: Artikelinstellingen op code
- OfficeSettingsByCode: Bedrijfsinstellingen op code
- PaymentTypeSettingsByCode: Instellingen betaaltype per code
- ProjectRateChangesByCode: Projecttariefwijzigingen op code
- ProjectRateSettingsByCode: Projecttariefinstellingen op code
- SalesInvoiceByNumber: Verkoopfactuur per nummer
- SalesInvoiceLinesByNumber: Verkoopfactuurregels op nummer
- SalesInvoiceVatLinesByNumber: Verkoopfactuur-btw-regels op nummer
- TransactionByNumber: Transactie op nummer
- TransactionLinesByNumber: Transactieregels per nummer
- UserSettingsByUserCode: Gebruikersinstellingen op gebruikerscode
- VatCodePercentagesByCode: btw-codepercentages op code
- VatCodeSettingsByCode: btw-codeinstellingen op code
Twinfield.Twinfield
- AnnualReportTotals: Jaarverslagtotalen
- AnnualReportTotalsMulticurrency: Jaarverslagtotalen (meerdere valuta's)
- AnnualReportYtd: Jaarverslag YTD
- AssetMethods: Activamethoden
- AssetTransactions: Activatransacties
- BankBookByCode: Bankboek op code
- BankLinkDetails: Banklinkdetails
- BankLinkDetailsV2: Bankkoppelingsdetails (V2)
- BankStatementLinesByStatementDate: Bankafschriftregels op afschriftdatum
- BankStatementsByStatementDate: Bankafschriften op afschriftdatum
- BankTransactions: Banktransacties
- BillingSchedules: Factureringsschema's
- BudgetByCostCenter: Budget per kostenplaats
- BudgetByProfitAndLoss: Budget per winst- en verliesrekening
- BudgetByProject: Budget per project
- Budgets: Budgetten
- CashBookByCode: Kasboek op code
- CashTransactions: Kastransacties
- CashbooksAndBanks: Kasboeken en banken
- Certificates: Certificaten
- Cheques: Cheques
- CommercialAnnualReportTotals: Commerciële jaarrapportage-totalen
- CommercialAnnualReportTotalsMulticurrency: Commerciële jaarrapportage-totalen meerdere valuta
- CommercialAnnualReportYtd: Commercieel jaarrapport Ytd
- CostCenters: Kostenplaatsen
- Countries: Landen
- CreditManagement: Kredietbeheer
- CreditManagementActionCodes: Credit Management-actiecodes
- Currencies: Valuta's
- CustomerTransactions: Debiteurentransacties
- Customers: Klanten
- CustomersV2: Debiteuren (V2)
- CustomersV3: Debiteuren (V3)
- DaybooksTransactionTypes: Journaaltransactietypen
- Declarations: BTW-aangiften
- DeclarationsByRange: btw-aangiften per bereik
- DeclarationsByYear: Aangiften per jaar
- DeclarationsByYearSinceModified: Aangiften per jaar sinds wijziging
- DeclarationsSinceModified: Aangiften sinds wijziging
- DimensionGroups: Dimensiegroepen
- DimensionTypes: Dimensietypen
- DimensionsModifiedSince: Dimensies gewijzigd sinds
- DistributionByPeriods: Verdeling per periode
- DocketInvoices: Docket-facturen
- EconomicAnnualReportTotals: Economisch jaarverslagtotalen
- EconomicAnnualReportTotalsMulticurrency: Economische jaarrapportage-totalen (meerdere valuta)
- EconomicAnnualReportYtd: Economisch jaarverslag YTD
- FilterMappings: Filtertoewijzingen
- FinancialDimensions: Financiële dimensies
- FiscalAnnualReportTotals: Fiscale jaarrapporttotalen
- FiscalAnnualReportTotalsMulticurrency: Fiscaal jaarverslagtotalen (meerdere valuta's)
- FiscalAnnualReportYtd: Fiscaal jaarrapport YTD
- FixedAssets: Vaste activa
- Gateways: Gateways
- GeneralLedgerAccountMappingAccountsByHierarchyCode: Grootboekkoppeling rekeningen op hiërarchiecode
- GeneralLedgerAccountMappingByHierarchyCode: Grootboekrekeningmapping op hiërarchiecode
- GeneralLedgerDetails: Details grootboek
- GeneralLedgerDetailsV2: Grootboekdetails (V2)
- GeneralLedgerDetailsV3: Grootboekdetails (V3)
- GeneralLedgerIntercompany: Grootboek intercompany
- GeneralLedgerIntercompanyV2: Grootboek intercompany (V2)
- GeneralLedgerTransactions: Grootboektransacties
- Hierarchies: Hiërarchieën
- HierarchyAccess: Hiërarchie-toegangsrechten
- HierarchyNodes: Hiërarchieknooppunten
- IctCountries: ICT-landen
- IctReturnAsXbrlByDocumentId: ICT-aangifte als XBRL op documentnummer
- IctReturnAsXmlByDocumentId: ICT-aangifte als XML per document-ID
- InvoiceTypes: Factuurtypen
- Facturen: Facturen
- Items: Items
- MatchingTypes: Matchingtypen
- NumberOfDeclarations: Aantal aangiften
- OfficeGroups: Administratiegroepen
- Offices: Administraties
- OfficesForInterCompanyTransactions: Administraties voor intercompany-transacties
- PayAndCollectRunById: Betaal- en incassorun op identificatie
- PayAndCollectRuns: Pay en Collect-runs
- PayinginSlips: Betalingen in behandeling
- PaymentFiles: Betalingsbestandsindelingen
- PaymentTypes: Betaaltypen
- PeriodYears: Periodejaren
- Periods: Periodes
- PeriodsByYear: Periodes per jaar
- PlatformVersion: Platformversie
- ProjectDimensions: Projectdimensies
- ProjectTransactions: Projecttransacties
- ReminderScenarios: Herinneringsscenario's
- Reports: Rapporten
- Roles: Rollen
- SubItemsByArticle: Subitems per artikel
- SupplierTransactions: Leveranciertransacties
- Suppliers: Leveranciers
- SuppliersV2: Leveranciers (V2)
- TableColumnSpecifications: Tabelkolomspecificaties
- TaxGroupVatReturnAsXbrlByDocumentId: Belastinggroep btw-aangifte als XBRL op document-ID
- TaxGroupVatReturnAsXmlByDocumentId: Belastinggroep BTW-aangifte als XML op documentnummer
- TaxGroupVatReturnPaymentReferenceByDocumentId: Belastinggroep btw-aangifte betalingskenmerk op document-ID
- TaxGroups: Belastinggroepen
- TimeAndExpensesBillingDetails: Factureringsdetails uren en kosten
- TimeAndExpensesBillingPerPeriod: Tijd- en kostenfacturatie per periode
- TimeAndExpensesBillingPerWeek: Tijd- en kostenfacturatie per week
- TimeAndExpensesDetails: Tijd en kosten details
- TimeAndExpensesMulticurrency: Tijd en kosten (meerdere valuta's)
- TimeAndExpensesTotals: Uren- en kostentotalen
- TimeAndExpensesTotalsPerPeriod: Tijd- en kostentotalen per periode
- TimeAndExpensesTotalsPerWeek: Uren- en kostentotalen per week
- TimeAndQuantitiesTransactionTypes: Tijd- en hoeveelheidstransactietypen
- TimeProjectRates: Urentarieven projecten
- TransactionList: Transactielijst
- TransactionSummary: Transactieoverzicht
- TransactionsToBeMatched: Transacties om te matchen
- Vertalingen: Vertalingen
- Users: Gebruikers
- VATCodes: BTW-codes
- VATGroupCountries: BTW-groepslanden
- VATGroups: BTW-groepen
- VATNumberOfRelations: btw-nummer van relaties
- VatReturnAsXbrlByDocumentId: BTW-aangifte als XBRL op documentnummer
- VatReturnAsXmlByDocumentId: BTW-aangifte als XML per document-ID
- VatReturnPaymentReferenceByDocumentId: BTW-aangifte betalingskenmerk op documentnummer
- VatReturnStatus: btw-aangiftestatussen
- VatTypes: btw-typen
- WordTemplates: Worddsjablonen
Twinfield.Views
- ActivityDimensionValues: Activiteit dimensiewaarden
- ArticleLines: Artikelregels
- ArticleSettings: Artikelinstellingen
- BalanceSheetDimensionValues: Saldibalanswaarden dimensies
- CostCenterBudgets: Kostenplaatsbudgetten
- CostCenterDimensionValues: Kostenplaats dimensiewaarden
- CreditorDimensionValues: Crediteur-dimensiewaarden
- DebtorDimensionValues: Dimensiewaarden debiteuren
- FinancialYears: Boekjaren
- FixedAssetDimensionValues: Dimensiewaarden vaste activa
- GeneralLedgerAccountMappingAccounts: Grootboekrekening-koppelingsrekeningen
- GeneralLedgerAccountMappings: Grootboekrekening-koppelingen
- IctReturnsAsXbrl: ICT-aangiften als XBRL
- IctReturnsAsXml: ICT-aangiften als XML
- OfficeSettings: Bedrijfsinstellingen
- PaymentTypeSettings: Betaalwijze-instellingen
- Periods: Financiële periodes
- PeriodsWithTransactions: Periodes met transacties
- ProfitAndLossBudgets: Winst- en verliesbudgetten
- ProfitAndLossDimensionValues: Winst&verlies dimensiewaarden
- ProjectBudgets: Projectbudgetten
- ProjectDimensionValues: Projectdimensiewaarden
- ProjectRateChanges: Projecttariefwijzigingen
- ProjectRateSettings: Projecttarief-instellingen
- SubItems: Subitems
- TaxGroupVatReturnPaymentReferences: Betalingskenmerken BTW-groep
- TaxGroupVatReturnsAsXbrl: BTW-aangiften BTW-groep als XBRL
- TaxGroupVatReturnsAsXml: Belastinggroep btw-aangiften als XML
- UserSettings: Gebruikersinstellingen
- VatCodePercentages: btw-codepercentages
- VatCodeSettings: BTW-codeinstellingen
- VatReturnPaymentReferences: Betalingskenmerken btw-aangifte
- VatReturnsAsXbrl: btw-aangiften als XBRL
- VatReturnsAsXml: BTW-aangiften als XML
Voorbeeldqueries
--
-- List Twinfield financial transaction details.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/twinfield-data-model/webhelp/twinfield-connector-twinfield-generalledgerdetailsv3.html
--
select *
from Twinfield.Twinfield.GeneralLedgerDetailsV3@tfd
limit 100
--
-- Mapping from Twinfield general ledger accounts to the hierarchies.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/twinfield-data-model/webhelp/twinfield-connector-twinfield-generalledgeraccountmappingaccountsbyhierarchycode.html
--
select *
from Twinfield.Views.GeneralLedgerAccountMappingAccounts@tfd
limit 100
Attributen
De kenmerken van dit platform staan op de pagina Attributes.
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: