invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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

PDF, 2 A0-vellen

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Twinfield datamodel, Pagina 1 van 2Twinfield datamodelvoor gebruik met Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026Twinfield · Offices · Dimensions · Customers · Dimensions · Suppliers · Twinfield · Twinfield · CashbooksAndBanks · Dimensions · Activities · Dimensions · ProjectsPagina 1 van 2 · documentation.invantive.euTwinfield · OfficesTwinfield.Twinfield.AnnualReportTotals: Annual Report TotalsAnnualReportTotalsTwinfield.Twinfield.AnnualReportTotalsMulticurrency: Annual Report Totals (Multi-currency)AnnualReportTotalsMulticurrencyTwinfield.Twinfield.AnnualReportYtd: Annual Report YTDAnnualReportYtdTwinfield.Twinfield.AssetMethods: Asset MethodsAssetMethodsTwinfield.Twinfield.AssetTransactions: Asset TransactionsAssetTransactionsTwinfield.Twinfield.BankLinkDetails: Bank Link DetailsBankLinkDetailsTwinfield.Twinfield.BankLinkDetailsV2: Bank Link Details (V2)BankLinkDetailsV2Twinfield.Twinfield.BillingSchedules: Billing SchedulesBillingSchedulesTwinfield.Twinfield.Budgets: BudgetsBudgetsTwinfield.Twinfield.Certificates: CertificatesCertificatesTwinfield.Twinfield.CommercialAnnualReportTotals: Commercial Annual Report TotalsCommercialAnnualReportTotalsTwinfield.Twinfield.CommercialAnnualReportTotalsMulticurrency: Commercial Annual Report Totals Multi CurrencyCommercialAnnualReportTotalsMulti…Twinfield.Twinfield.CommercialAnnualReportYtd: Commercial Annual Report YtdCommercialAnnualReportYtdTwinfield.Twinfield.CostCenters: Cost CentresCostCentersTwinfield.Twinfield.CreditManagement: Credit ManagementCreditManagementTwinfield.Twinfield.CreditManagementActionCodes: Credit Management Action CodesCreditManagementActionCodesTwinfield.Twinfield.Currencies: CurrenciesCurrenciesTwinfield.Twinfield.CustomerTransactions: Customer TransactionsCustomerTransactionsTwinfield.Twinfield.Customers: CustomersCustomersTwinfield.Twinfield.CustomersV2: Customers (V2)CustomersV2Twinfield.Twinfield.CustomersV3: Customers (V3)CustomersV3Twinfield.Twinfield.Declarations: VAT DeclarationsDeclarationsTwinfield.Twinfield.DistributionByPeriods: Distribution by PeriodsDistributionByPeriodsTwinfield.Twinfield.EconomicAnnualReportTotals: Economic Annual Report TotalsEconomicAnnualReportTotalsTwinfield.Twinfield.EconomicAnnualReportTotalsMulticurrency: Economic Annual Report Totals (Multi Currency)EconomicAnnualReportTotalsMulticur…Twinfield.Twinfield.EconomicAnnualReportYtd: Economic Annual Report YTDEconomicAnnualReportYtdTwinfield.Twinfield.FilterMappings: Filter MappingsFilterMappingsTwinfield.Twinfield.FinancialDimensions: Financial DimensionsFinancialDimensionsTwinfield.Twinfield.FiscalAnnualReportTotals: Fiscal Annual Report TotalsFiscalAnnualReportTotalsTwinfield.Twinfield.FiscalAnnualReportTotalsMulticurrency: Fiscal Annual Report Totals (Multi Currency)FiscalAnnualReportTotalsMulticurrencyTwinfield.Twinfield.FiscalAnnualReportYtd: Fiscal Annual Report YTDFiscalAnnualReportYtdTwinfield.Twinfield.FixedAssets: Fixed AssetsFixedAssetsTwinfield.Twinfield.Gateways: GatewaysGatewaysTwinfield.Twinfield.GeneralLedgerDetails: General Ledger DetailsGeneralLedgerDetailsTwinfield.Twinfield.GeneralLedgerDetailsV2: General Ledger Details (V2)GeneralLedgerDetailsV2Twinfield.Twinfield.GeneralLedgerDetailsV3: General Ledger Details (V3)GeneralLedgerDetailsV3Twinfield.Twinfield.GeneralLedgerIntercompany: General Ledger IntercompanyGeneralLedgerIntercompanyTwinfield.Twinfield.GeneralLedgerIntercompanyV2: General Ledger Intercompany (V2)GeneralLedgerIntercompanyV2Twinfield.Twinfield.GeneralLedgerTransactions: General Ledger TransactionsGeneralLedgerTransactionsTwinfield.Twinfield.HierarchyAccess: Hierarchy Access PrivilegesHierarchyAccessTwinfield.Twinfield.IctCountries: ICT CountriesIctCountriesTwinfield.Twinfield.MatchingTypes: Matching TypesMatchingTypesTwinfield.Twinfield.OfficeGroups: Administration GroupsOfficeGroupsTwinfield.Twinfield.Offices: AdministrationsOfficesTwinfield.Twinfield.OfficesForInterCompanyTransactions: Administrations for Inter Company TransactionsOfficesForInterCompanyTransactionsTwinfield.Twinfield.PayinginSlips: Payments in ProcessPayinginSlipsTwinfield.Twinfield.PaymentFiles: Payment File FormatsPaymentFilesTwinfield.Twinfield.Periods: PeriodsPeriodsTwinfield.Twinfield.ProjectDimensions: Project DimensionsProjectDimensionsTwinfield.Twinfield.ProjectTransactions: Project TransactionsProjectTransactionsTwinfield.Twinfield.ReminderScenarios: Reminder ScenariosReminderScenariosTwinfield.Twinfield.Reports: ReportsReportsTwinfield.Twinfield.Roles: RolesRolesTwinfield.Twinfield.SupplierTransactions: Supplier TransactionsSupplierTransactionsTwinfield.Twinfield.Suppliers: SuppliersSuppliersTwinfield.Twinfield.SuppliersV2: Suppliers (V2)SuppliersV2Twinfield.Twinfield.TaxGroups: Tax GroupsTaxGroupsTwinfield.Twinfield.TimeAndExpensesBillingDetails: Time and Expenses Billing DetailsTimeAndExpensesBillingDetailsTwinfield.Twinfield.TimeAndExpensesBillingPerPeriod: Time and Expenses Billing per PeriodTimeAndExpensesBillingPerPeriodTwinfield.Twinfield.TimeAndExpensesBillingPerWeek: Time and Expenses Billing per WeekTimeAndExpensesBillingPerWeekTwinfield.Twinfield.TimeAndExpensesDetails: Time and Expenses DetailsTimeAndExpensesDetailsTwinfield.Twinfield.TimeAndExpensesMulticurrency: Time and Expenses (Multi-currency)TimeAndExpensesMulticurrencyTwinfield.Twinfield.TimeAndExpensesTotals: Time and Expenses TotalsTimeAndExpensesTotalsTwinfield.Twinfield.TimeAndExpensesTotalsPerPeriod: Time and Expenses Totals per PeriodTimeAndExpensesTotalsPerPeriodTwinfield.Twinfield.TimeAndExpensesTotalsPerWeek: Time and Expenses Totals per WeekTimeAndExpensesTotalsPerWeekTwinfield.Twinfield.TimeAndQuantitiesTransactionTypes: Time and Quantities Transaction TypesTimeAndQuantitiesTransactionTypesTwinfield.Twinfield.TransactionList: Transactions ListTransactionListTwinfield.Twinfield.TransactionSummary: Transactions SummaryTransactionSummaryTwinfield.Twinfield.TransactionsToBeMatched: Transactions to be MatchedTransactionsToBeMatchedTwinfield.Twinfield.Translations: TranslationsTranslationsTwinfield.Twinfield.VATCodes: VAT CodesVATCodesTwinfield.Twinfield.VATGroupCountries: VAT Group CountriesVATGroupCountriesTwinfield.Twinfield.VATGroups: VAT GroupsVATGroupsTwinfield.Twinfield.VATNumberOfRelations: VAT Number of RelationsVATNumberOfRelationsTwinfield.Twinfield.VatReturnStatus: VAT Return StatusesVatReturnStatusTwinfield.Twinfield.VatTypes: VAT TypesVatTypesTwinfield.Twinfield.WordTemplates: Word TemplatesWordTemplatesTwinfield.Dimensions.Balancesheets: Balance SheetsBalancesheetsTwinfieldTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ProfitAndLoss: Profit and LossProfitAndLossTwinfieldTwinfield.Twinfield.OfficesODimensions · CustomersTwinfield.Dimensions.CustomerAddresses: Customer AddressesCustomerAddressesTwinfield.Twinfield.OfficesOTwinfield.Dimensions.CustomerBanks: Customer BanksCustomerBanksTwinfield.Twinfield.OfficesOTwinfield.Dimensions.CustomerChildValidations: Customer Child ValidationsCustomerChildValidationsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.CustomerPaymentConditions: Customer Payment ConditionsCustomerPaymentConditionsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.Customers: CustomersCustomersTwinfield.Twinfield.OfficesOTwinfield.Twinfield.VATCodes: VAT CodesVATCodesTwinfield · OfficesDimensions · SuppliersTwinfield.Dimensions.SupplierAddresses: Supplier AddressesSupplierAddressesTwinfield.Twinfield.OfficesOTwinfield.Dimensions.SupplierBanks: Supplier BanksSupplierBanksTwinfield.Twinfield.OfficesOTwinfield.Dimensions.SupplierChildValidations: Supplier Child ValidationsSupplierChildValidationsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.SupplierPaymentConditions: Supplier Payment ConditionsSupplierPaymentConditionsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.Suppliers: SuppliersSuppliersTwinfield.Twinfield.OfficesOTwinfield.Twinfield.VATCodes: VAT CodesVATCodesTwinfield · OfficesTwinfieldTwinfield.Dimensions.Assets: AssetsAssetsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.BalancesheetBanks: Balance Sheet BankBalancesheetBanksTwinfield.Twinfield.OfficesOTwinfield.Dimensions.BalancesheetChildValidations: Balance Sheet Child ValidationsBalancesheetChildValidationsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.BalancesheetGroups: Balance Sheet GroupsBalancesheetGroupsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.Balancesheets: Balance SheetsBalancesheetsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.CostCenters: Cost CentresCostCentersTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ProfitAndLoss: Profit and LossProfitAndLossTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ProfitAndLossBanks: Profit and Loss BanksProfitAndLossBanksTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ProfitAndLossChildValidations: Profit and Loss Child ValidationsProfitAndLossChildValidationsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ProfitAndLossGroups: Profit and Loss GroupsProfitAndLossGroupsTwinfield.Twinfield.OfficesOTwinfield · CashbooksAndBanksTwinfield.Twinfield.BankTransactions: Bank TransactionsBankTransactionsTwinfield.Twinfield.OfficesOTwinfield.Twinfield.CashTransactions: Cash TransactionsCashTransactionsTwinfield.Twinfield.OfficesOTwinfield.Twinfield.CashbooksAndBanks: Cash Books and BanksCashbooksAndBanksTwinfield.Twinfield.OfficesOTwinfield.Dimensions.Balancesheets: Balance SheetsBalancesheetsTwinfieldTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ProfitAndLoss: Profit and LossProfitAndLossTwinfieldTwinfield.Twinfield.OfficesOTwinfield.Twinfield.Currencies: CurrenciesCurrenciesTwinfield · OfficesTwinfield.Twinfield.VATCodes: VAT CodesVATCodesTwinfield · OfficesDimensions · ActivitiesTwinfield.Dimensions.Activities: ActivitiesActivitiesTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ActivityChildValidations: Activity Child ValidationsActivityChildValidationsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ActivityProjectQuantities: Activity Project QuantitiesActivityProjectQuantitiesTwinfield.Twinfield.OfficesODimensions · ProjectsTwinfield.Dimensions.ProjectChildValidations: Project Child ValidationsProjectChildValidationsTwinfield.Twinfield.OfficesOTwinfield.Dimensions.ProjectQuantities: Project QuantitiesProjectQuantitiesTwinfield.Twinfield.OfficesOTwinfield.Dimensions.Projects: ProjectsProjectsTwinfield.Twinfield.OfficesOActiveAnalysisTwinfield.ActiveAnalysis.ActiveAnalyses: Active AnalysesActiveAnalysesCodeValuesTwinfield.CodeValues.AccessTypes: Domain AccessTypesAccessTypesTwinfield.CodeValues.AddressTypes: Domain AddressTypesAddressTypesTwinfield.CodeValues.ArticleTypes: Domain ArticleTypesArticleTypesTwinfield.CodeValues.AssetCalculationMethods: Domain AssetCalculationMethodsAssetCalculationMethodsTwinfield.CodeValues.AssetStatuses: Domain AssetStatusesAssetStatusesTwinfield.CodeValues.BankTransactionTypeFilters: Domain BankTransactionTypeFiltersBankTransactionTypeFiltersTwinfield.CodeValues.BrowseCodes: Domain BrowseCodesBrowseCodesTwinfield.CodeValues.BrowseOperators: Domain BrowseOperatorsBrowseOperatorsTwinfield.CodeValues.BrowseSortOrders: Domain BrowseSortOrdersBrowseSortOrdersTwinfield.CodeValues.CollectionSchemas: Domain CollectionSchemasCollectionSchemasTwinfield.CodeValues.Cultures: Domain CulturesCulturesTwinfield.CodeValues.DebitCredits: Domain DebitCreditsDebitCreditsTwinfield.CodeValues.DepreciationStartMoments: Domain DepreciationStartMomentsDepreciationStartMomentsTwinfield.CodeValues.DimensionBehaviours: Domain DimensionBehavioursDimensionBehavioursTwinfield.CodeValues.DimensionLevels: Domain DimensionLevelsDimensionLevelsTwinfield.CodeValues.DimensionStatuses: Domain DimensionStatusesDimensionStatusesTwinfield.CodeValues.DimensionTypeCodes: Domain DimensionTypeCodesDimensionTypeCodesTwinfield.CodeValues.FinderSearchFields: Domain FinderSearchFieldsFinderSearchFieldsTwinfield.CodeValues.FinderTypeCodes: Domain FinderTypeCodesFinderTypeCodesTwinfield.CodeValues.FreeTextTypes: Domain FreeTextTypesFreeTextTypesTwinfield.CodeValues.InvitationStatuses: Domain InvitationStatusesInvitationStatusesTwinfield.CodeValues.ItemValueVatInclusions: Domain ItemValueVatInclusionsItemValueVatInclusionsTwinfield.CodeValues.MatchStatuses: Domain MatchStatusesMatchStatusesTwinfield.CodeValues.MatchTypes: Domain MatchTypesMatchTypesTwinfield.CodeValues.MatchingTypeCodes: Domain MatchingTypeCodesMatchingTypeCodesTwinfield.CodeValues.MeansOfPayment: Domain MeansOfPaymentMeansOfPaymentTwinfield.CodeValues.PayAddresses: Domain PayAddressesPayAddressesTwinfield.CodeValues.PerformanceTypes: Domain PerformanceTypesPerformanceTypesTwinfield.CodeValues.RateTypes: Domain RateTypesRateTypesTwinfield.CodeValues.SalesInvoicePaymentMethods: Domain SalesInvoicePaymentMethodsSalesInvoicePaymentMethodsTwinfield.CodeValues.SalesInvoiceStatuses: Domain SalesInvoiceStatusesSalesInvoiceStatusesTwinfield.CodeValues.SendReminders: Domain SendRemindersSendRemindersTwinfield.CodeValues.SendTypes: Domain SendTypesSendTypesTwinfield.CodeValues.SepaDirectDebitSchemes: Domain SepaDirectDebitSchemesSepaDirectDebitSchemesTwinfield.CodeValues.SingleSignOnSettings: Domain SingleSignOnSettingsSingleSignOnSettingsTwinfield.CodeValues.SmsLogonServices: Domain SmsLogonServicesSmsLogonServicesTwinfield.CodeValues.SubAnalyses: Domain SubAnalysesSubAnalysesTwinfield.CodeValues.SubscriptionChangeReasons: Domain SubscriptionChangeReasonsSubscriptionChangeReasonsTwinfield.CodeValues.SubstitutionLevels: Domain SubstitutionLevelsSubstitutionLevelsTwinfield.CodeValues.SubstitutionTypes: Domain SubstitutionTypesSubstitutionTypesTwinfield.CodeValues.TemplateCompanyAccesses: Domain TemplateCompanyAccessesTemplateCompanyAccessesTwinfield.CodeValues.TimeEntryTypes: Domain TimeEntryTypesTimeEntryTypesTwinfield.CodeValues.TimeTransactionCodes: Domain TimeTransactionCodesTimeTransactionCodesTwinfield.CodeValues.TransactionLineTypes: Domain TransactionLineTypesTransactionLineTypesTwinfield.CodeValues.TransactionStatuses: Domain TransactionStatusesTransactionStatusesTwinfield.CodeValues.UserTypes: Domain UserTypesUserTypesTwinfield.CodeValues.VatCodeLineTypes: Domain VatCodeLineTypesVatCodeLineTypesTwinfield.CodeValues.VatCodeTypes: Domain VatCodeTypesVatCodeTypesTwinfield.CodeValues.WaysOfPayment: Domain WaysOfPaymentWaysOfPaymentTwinfield.CodeValues.WordTemplateKinds: Domain WordTemplateKindsWordTemplateKindsTwinfieldDatadictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenDimensions · Activities1Dimensions · Customers1Dimensions · Projects1Dimensions · Suppliers1Twinfield1Twinfield · CashbooksAndBanks1Twinfield · Offices1Tabeller uden relationen1, 2LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten×n: n relations between the same tablesBrieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: O = OfficesGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.3-BETA+6294 op 01-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/twinfield
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)

ActiveAnalyses

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)

NATIVEPLATFORMSCALARREQUESTS

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

Tabellen

Twinfield.ActiveAnalysis

Twinfield.CodeValues

Twinfield.Deleted

Twinfield.Dimensions

Twinfield.Native

Twinfield.Settings

Twinfield.Twinfield

Twinfield.Views

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: