---
title: "Twinfield Data Model"
description: "Twinfield is an online accounting package used in the Netherlands and Belgium. Accounting professionals form a large part of the Twinfield user community."
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/twinfield
original: https://documentation.invantive.eu/en/datamodels/twinfield
updated: 2026-11-01T17:45:47Z
license: https://documentation.invantive.eu/en/
---

# Twinfield Data Model

Twinfield is an online accounting package used in the Netherlands and Belgium. Accounting professionals form a large part of the Twinfield user community.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/twinfield

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 | 251 |
| Columns | 14,640 |
| Tables with insert | 1 |
| Tables with update | 0 |
| Tables with delete | 0 |
| Tables documented | 93 |

## Tables

### Twinfield.ActiveAnalysis

- [ActiveAnalyses](Twinfield.ActiveAnalysis.ActiveAnalyses): Active Analyses

### Twinfield.CodeValues

- [AccessTypes](Twinfield.CodeValues.AccessTypes): Domain AccessTypes
- [AddressTypes](Twinfield.CodeValues.AddressTypes): Domain AddressTypes
- [ArticleTypes](Twinfield.CodeValues.ArticleTypes): Domain ArticleTypes
- [AssetCalculationMethods](Twinfield.CodeValues.AssetCalculationMethods): Domain AssetCalculationMethods
- [AssetStatuses](Twinfield.CodeValues.AssetStatuses): Domain AssetStatuses
- [BankTransactionTypeFilters](Twinfield.CodeValues.BankTransactionTypeFilters): Domain BankTransactionTypeFilters
- [BrowseCodes](Twinfield.CodeValues.BrowseCodes): Domain BrowseCodes
- [BrowseOperators](Twinfield.CodeValues.BrowseOperators): Domain BrowseOperators
- [BrowseSortOrders](Twinfield.CodeValues.BrowseSortOrders): Domain BrowseSortOrders
- [CollectionSchemas](Twinfield.CodeValues.CollectionSchemas): Domain CollectionSchemas
- [Cultures](Twinfield.CodeValues.Cultures): Domain Cultures
- [DebitCredits](Twinfield.CodeValues.DebitCredits): Domain DebitCredits
- [DepreciationStartMoments](Twinfield.CodeValues.DepreciationStartMoments): Domain DepreciationStartMoments
- [DimensionBehaviours](Twinfield.CodeValues.DimensionBehaviours): Domain DimensionBehaviours
- [DimensionLevels](Twinfield.CodeValues.DimensionLevels): Domain DimensionLevels
- [DimensionStatuses](Twinfield.CodeValues.DimensionStatuses): Domain DimensionStatuses
- [DimensionTypeCodes](Twinfield.CodeValues.DimensionTypeCodes): Domain DimensionTypeCodes
- [FinderSearchFields](Twinfield.CodeValues.FinderSearchFields): Domain FinderSearchFields
- [FinderTypeCodes](Twinfield.CodeValues.FinderTypeCodes): Domain FinderTypeCodes
- [FreeTextTypes](Twinfield.CodeValues.FreeTextTypes): Domain FreeTextTypes
- [InvitationStatuses](Twinfield.CodeValues.InvitationStatuses): Domain InvitationStatuses
- [ItemValueVatInclusions](Twinfield.CodeValues.ItemValueVatInclusions): Domain ItemValueVatInclusions
- [MatchStatuses](Twinfield.CodeValues.MatchStatuses): Domain MatchStatuses
- [MatchTypes](Twinfield.CodeValues.MatchTypes): Domain MatchTypes
- [MatchingTypeCodes](Twinfield.CodeValues.MatchingTypeCodes): Domain MatchingTypeCodes
- [MeansOfPayment](Twinfield.CodeValues.MeansOfPayment): Domain MeansOfPayment
- [PayAddresses](Twinfield.CodeValues.PayAddresses): Domain PayAddresses
- [PerformanceTypes](Twinfield.CodeValues.PerformanceTypes): Domain PerformanceTypes
- [RateTypes](Twinfield.CodeValues.RateTypes): Domain RateTypes
- [SalesInvoicePaymentMethods](Twinfield.CodeValues.SalesInvoicePaymentMethods): Domain SalesInvoicePaymentMethods
- [SalesInvoiceStatuses](Twinfield.CodeValues.SalesInvoiceStatuses): Domain SalesInvoiceStatuses
- [SendReminders](Twinfield.CodeValues.SendReminders): Domain SendReminders
- [SendTypes](Twinfield.CodeValues.SendTypes): Domain SendTypes
- [SepaDirectDebitSchemes](Twinfield.CodeValues.SepaDirectDebitSchemes): Domain SepaDirectDebitSchemes
- [SingleSignOnSettings](Twinfield.CodeValues.SingleSignOnSettings): Domain SingleSignOnSettings
- [SmsLogonServices](Twinfield.CodeValues.SmsLogonServices): Domain SmsLogonServices
- [SubAnalyses](Twinfield.CodeValues.SubAnalyses): Domain SubAnalyses
- [SubscriptionChangeReasons](Twinfield.CodeValues.SubscriptionChangeReasons): Domain SubscriptionChangeReasons
- [SubstitutionLevels](Twinfield.CodeValues.SubstitutionLevels): Domain SubstitutionLevels
- [SubstitutionTypes](Twinfield.CodeValues.SubstitutionTypes): Domain SubstitutionTypes
- [TemplateCompanyAccesses](Twinfield.CodeValues.TemplateCompanyAccesses): Domain TemplateCompanyAccesses
- [TimeEntryTypes](Twinfield.CodeValues.TimeEntryTypes): Domain TimeEntryTypes
- [TimeTransactionCodes](Twinfield.CodeValues.TimeTransactionCodes): Domain TimeTransactionCodes
- [TransactionLineTypes](Twinfield.CodeValues.TransactionLineTypes): Domain TransactionLineTypes
- [TransactionStatuses](Twinfield.CodeValues.TransactionStatuses): Domain TransactionStatuses
- [UserTypes](Twinfield.CodeValues.UserTypes): Domain UserTypes
- [VatCodeLineTypes](Twinfield.CodeValues.VatCodeLineTypes): Domain VatCodeLineTypes
- [VatCodeTypes](Twinfield.CodeValues.VatCodeTypes): Domain VatCodeTypes
- [WaysOfPayment](Twinfield.CodeValues.WaysOfPayment): Domain WaysOfPayment
- [WordTemplateKinds](Twinfield.CodeValues.WordTemplateKinds): Domain WordTemplateKinds

### Twinfield.Deleted

- [DeletedTransactions](Twinfield.Deleted.DeletedTransactions): Deleted Transactions

### Twinfield.Dimensions

- [Activities](Twinfield.Dimensions.Activities): Activities
- [ActivityChildValidations](Twinfield.Dimensions.ActivityChildValidations): Activity Child Validations
- [ActivityProjectQuantities](Twinfield.Dimensions.ActivityProjectQuantities): Activity Project Quantities
- [Assets](Twinfield.Dimensions.Assets): Assets
- [BalancesheetBanks](Twinfield.Dimensions.BalancesheetBanks): Balance Sheet Bank
- [BalancesheetChildValidations](Twinfield.Dimensions.BalancesheetChildValidations): Balance Sheet Child Validations
- [BalancesheetGroups](Twinfield.Dimensions.BalancesheetGroups): Balance Sheet Groups
- [Balancesheets](Twinfield.Dimensions.Balancesheets): Balance Sheets
- [CostCenters](Twinfield.Dimensions.CostCenters): Cost Centres
- [CustomerAddresses](Twinfield.Dimensions.CustomerAddresses): Customer Addresses
- [CustomerBanks](Twinfield.Dimensions.CustomerBanks): Customer Banks
- [CustomerChildValidations](Twinfield.Dimensions.CustomerChildValidations): Customer Child Validations
- [CustomerPaymentConditions](Twinfield.Dimensions.CustomerPaymentConditions): Customer Payment Conditions
- [Customers](Twinfield.Dimensions.Customers): Customers
- [ProfitAndLoss](Twinfield.Dimensions.ProfitAndLoss): Profit and Loss
- [ProfitAndLossBanks](Twinfield.Dimensions.ProfitAndLossBanks): Profit and Loss Banks
- [ProfitAndLossChildValidations](Twinfield.Dimensions.ProfitAndLossChildValidations): Profit and Loss Child Validations
- [ProfitAndLossGroups](Twinfield.Dimensions.ProfitAndLossGroups): Profit and Loss Groups
- [ProjectChildValidations](Twinfield.Dimensions.ProjectChildValidations): Project Child Validations
- [ProjectQuantities](Twinfield.Dimensions.ProjectQuantities): Project Quantities
- [Projects](Twinfield.Dimensions.Projects): Projects
- [SupplierAddresses](Twinfield.Dimensions.SupplierAddresses): Supplier Addresses
- [SupplierBanks](Twinfield.Dimensions.SupplierBanks): Supplier Banks
- [SupplierChildValidations](Twinfield.Dimensions.SupplierChildValidations): Supplier Child Validations
- [SupplierPaymentConditions](Twinfield.Dimensions.SupplierPaymentConditions): Supplier Payment Conditions
- [Suppliers](Twinfield.Dimensions.Suppliers): Suppliers

### Twinfield.Native

- [NATIVEPLATFORMSCALARREQUESTS](Twinfield.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### Twinfield.Settings

- [ArticleLinesByCode](Twinfield.Settings.ArticleLinesByCode): Item Lines by Code
- [ArticleSettingsByCode](Twinfield.Settings.ArticleSettingsByCode): Item Settings by Code
- [OfficeSettingsByCode](Twinfield.Settings.OfficeSettingsByCode): Company Settings by Code
- [PaymentTypeSettingsByCode](Twinfield.Settings.PaymentTypeSettingsByCode): Payment Type Settings by Code
- [ProjectRateChangesByCode](Twinfield.Settings.ProjectRateChangesByCode): Project Rate Changes by Code
- [ProjectRateSettingsByCode](Twinfield.Settings.ProjectRateSettingsByCode): Project Rate Settings by Code
- [SalesInvoiceByNumber](Twinfield.Settings.SalesInvoiceByNumber): Sales Invoice by Number
- [SalesInvoiceLinesByNumber](Twinfield.Settings.SalesInvoiceLinesByNumber): Sales Invoice Lines by Number
- [SalesInvoiceVatLinesByNumber](Twinfield.Settings.SalesInvoiceVatLinesByNumber): Sales Invoice VAT Lines by Number
- [TransactionByNumber](Twinfield.Settings.TransactionByNumber): Transaction by Number
- [TransactionLinesByNumber](Twinfield.Settings.TransactionLinesByNumber): Transaction Lines by Number
- [UserSettingsByUserCode](Twinfield.Settings.UserSettingsByUserCode): User Settings by User Code
- [VatCodePercentagesByCode](Twinfield.Settings.VatCodePercentagesByCode): VAT Code Percentages by Code
- [VatCodeSettingsByCode](Twinfield.Settings.VatCodeSettingsByCode): VAT Code Settings by Code

### Twinfield.Twinfield

- [AnnualReportTotals](Twinfield.Twinfield.AnnualReportTotals): Annual Report Totals
- [AnnualReportTotalsMulticurrency](Twinfield.Twinfield.AnnualReportTotalsMulticurrency): Annual Report Totals (Multi-currency)
- [AnnualReportYtd](Twinfield.Twinfield.AnnualReportYtd): Annual Report YTD
- [AssetMethods](Twinfield.Twinfield.AssetMethods): Asset Methods
- [AssetTransactions](Twinfield.Twinfield.AssetTransactions): Asset Transactions
- [BankBookByCode](Twinfield.Twinfield.BankBookByCode): Bank Book by Code
- [BankLinkDetails](Twinfield.Twinfield.BankLinkDetails): Bank Link Details
- [BankLinkDetailsV2](Twinfield.Twinfield.BankLinkDetailsV2): Bank Link Details (V2)
- [BankStatementLinesByStatementDate](Twinfield.Twinfield.BankStatementLinesByStatementDate): Bank Statement Lines by Statement Date
- [BankStatementsByStatementDate](Twinfield.Twinfield.BankStatementsByStatementDate): Bank Statements by Statement Date
- [BankTransactions](Twinfield.Twinfield.BankTransactions): Bank Transactions
- [BillingSchedules](Twinfield.Twinfield.BillingSchedules): Billing Schedules
- [BudgetByCostCenter](Twinfield.Twinfield.BudgetByCostCenter): Budget by Cost Centre
- [BudgetByProfitAndLoss](Twinfield.Twinfield.BudgetByProfitAndLoss): Budget by Profit & Loss
- [BudgetByProject](Twinfield.Twinfield.BudgetByProject): Budget by Project
- [Budgets](Twinfield.Twinfield.Budgets): Budgets
- [CashBookByCode](Twinfield.Twinfield.CashBookByCode): Cash Book by Code
- [CashTransactions](Twinfield.Twinfield.CashTransactions): Cash Transactions
- [CashbooksAndBanks](Twinfield.Twinfield.CashbooksAndBanks): Cash Books and Banks
- [Certificates](Twinfield.Twinfield.Certificates): Certificates
- [Cheques](Twinfield.Twinfield.Cheques): Cheques
- [CommercialAnnualReportTotals](Twinfield.Twinfield.CommercialAnnualReportTotals): Commercial Annual Report Totals
- [CommercialAnnualReportTotalsMulticurrency](Twinfield.Twinfield.CommercialAnnualReportTotalsMulticurrency): Commercial Annual Report Totals Multi Currency
- [CommercialAnnualReportYtd](Twinfield.Twinfield.CommercialAnnualReportYtd): Commercial Annual Report Ytd
- [CostCenters](Twinfield.Twinfield.CostCenters): Cost Centres
- [Countries](Twinfield.Twinfield.Countries): Countries
- [CreditManagement](Twinfield.Twinfield.CreditManagement): Credit Management
- [CreditManagementActionCodes](Twinfield.Twinfield.CreditManagementActionCodes): Credit Management Action Codes
- [Currencies](Twinfield.Twinfield.Currencies): Currencies
- [CustomerTransactions](Twinfield.Twinfield.CustomerTransactions): Customer Transactions
- [Customers](Twinfield.Twinfield.Customers): Customers
- [CustomersV2](Twinfield.Twinfield.CustomersV2): Customers (V2)
- [CustomersV3](Twinfield.Twinfield.CustomersV3): Customers (V3)
- [DaybooksTransactionTypes](Twinfield.Twinfield.DaybooksTransactionTypes): Journal Transaction Types
- [Declarations](Twinfield.Twinfield.Declarations): VAT Declarations
- [DeclarationsByRange](Twinfield.Twinfield.DeclarationsByRange): VAT Declarations by Range
- [DeclarationsByYear](Twinfield.Twinfield.DeclarationsByYear): Declarations by Year
- [DeclarationsByYearSinceModified](Twinfield.Twinfield.DeclarationsByYearSinceModified): Declarations by Year Since Modified
- [DeclarationsSinceModified](Twinfield.Twinfield.DeclarationsSinceModified): Declarations Since Modified
- [DimensionGroups](Twinfield.Twinfield.DimensionGroups): Dimension Groups
- [DimensionTypes](Twinfield.Twinfield.DimensionTypes): Dimension Types
- [DimensionsModifiedSince](Twinfield.Twinfield.DimensionsModifiedSince): Dimensions Modified Since
- [DistributionByPeriods](Twinfield.Twinfield.DistributionByPeriods): Distribution by Periods
- [DocketInvoices](Twinfield.Twinfield.DocketInvoices): Docket Invoices
- [EconomicAnnualReportTotals](Twinfield.Twinfield.EconomicAnnualReportTotals): Economic Annual Report Totals
- [EconomicAnnualReportTotalsMulticurrency](Twinfield.Twinfield.EconomicAnnualReportTotalsMulticurrency): Economic Annual Report Totals (Multi Currency)
- [EconomicAnnualReportYtd](Twinfield.Twinfield.EconomicAnnualReportYtd): Economic Annual Report YTD
- [FilterMappings](Twinfield.Twinfield.FilterMappings): Filter Mappings
- [FinancialDimensions](Twinfield.Twinfield.FinancialDimensions): Financial Dimensions
- [FiscalAnnualReportTotals](Twinfield.Twinfield.FiscalAnnualReportTotals): Fiscal Annual Report Totals
- [FiscalAnnualReportTotalsMulticurrency](Twinfield.Twinfield.FiscalAnnualReportTotalsMulticurrency): Fiscal Annual Report Totals (Multi Currency)
- [FiscalAnnualReportYtd](Twinfield.Twinfield.FiscalAnnualReportYtd): Fiscal Annual Report YTD
- [FixedAssets](Twinfield.Twinfield.FixedAssets): Fixed Assets
- [Gateways](Twinfield.Twinfield.Gateways): Gateways
- [GeneralLedgerAccountMappingAccountsByHierarchyCode](Twinfield.Twinfield.GeneralLedgerAccountMappingAccountsByHierarchyCode): General Ledger Account Mapping Accounts by Hierarchy Code
- [GeneralLedgerAccountMappingByHierarchyCode](Twinfield.Twinfield.GeneralLedgerAccountMappingByHierarchyCode): General Ledger Account Mapping by Hierarchy Code
- [GeneralLedgerDetails](Twinfield.Twinfield.GeneralLedgerDetails): General Ledger Details
- [GeneralLedgerDetailsV2](Twinfield.Twinfield.GeneralLedgerDetailsV2): General Ledger Details (V2)
- [GeneralLedgerDetailsV3](Twinfield.Twinfield.GeneralLedgerDetailsV3): General Ledger Details (V3)
- [GeneralLedgerIntercompany](Twinfield.Twinfield.GeneralLedgerIntercompany): General Ledger Intercompany
- [GeneralLedgerIntercompanyV2](Twinfield.Twinfield.GeneralLedgerIntercompanyV2): General Ledger Intercompany (V2)
- [GeneralLedgerTransactions](Twinfield.Twinfield.GeneralLedgerTransactions): General Ledger Transactions
- [Hierarchies](Twinfield.Twinfield.Hierarchies): Hierarchies
- [HierarchyAccess](Twinfield.Twinfield.HierarchyAccess): Hierarchy Access Privileges
- [HierarchyNodes](Twinfield.Twinfield.HierarchyNodes): Hierarchy Nodes
- [IctCountries](Twinfield.Twinfield.IctCountries): ICT Countries
- [IctReturnAsXbrlByDocumentId](Twinfield.Twinfield.IctReturnAsXbrlByDocumentId): ICT Return as XBRL by Document ID
- [IctReturnAsXmlByDocumentId](Twinfield.Twinfield.IctReturnAsXmlByDocumentId): ICT Return as XML by Document ID
- [InvoiceTypes](Twinfield.Twinfield.InvoiceTypes): Invoice Types
- [Invoices](Twinfield.Twinfield.Invoices): Invoices
- [Items](Twinfield.Twinfield.Items): Items
- [MatchingTypes](Twinfield.Twinfield.MatchingTypes): Matching Types
- [NumberOfDeclarations](Twinfield.Twinfield.NumberOfDeclarations): Number of Declarations
- [OfficeGroups](Twinfield.Twinfield.OfficeGroups): Administration Groups
- [Offices](Twinfield.Twinfield.Offices): Administrations
- [OfficesForInterCompanyTransactions](Twinfield.Twinfield.OfficesForInterCompanyTransactions): Administrations for Inter Company Transactions
- [PayAndCollectRunById](Twinfield.Twinfield.PayAndCollectRunById): Pay and Collect Run by Identifier
- [PayAndCollectRuns](Twinfield.Twinfield.PayAndCollectRuns): Pay and Collect Runs
- [PayinginSlips](Twinfield.Twinfield.PayinginSlips): Payments in Process
- [PaymentFiles](Twinfield.Twinfield.PaymentFiles): Payment File Formats
- [PaymentTypes](Twinfield.Twinfield.PaymentTypes): Payment Types
- [PeriodYears](Twinfield.Twinfield.PeriodYears): Period Years
- [Periods](Twinfield.Twinfield.Periods): Periods
- [PeriodsByYear](Twinfield.Twinfield.PeriodsByYear): Periods by Year
- [PlatformVersion](Twinfield.Twinfield.PlatformVersion): Platform Version
- [ProjectDimensions](Twinfield.Twinfield.ProjectDimensions): Project Dimensions
- [ProjectTransactions](Twinfield.Twinfield.ProjectTransactions): Project Transactions
- [ReminderScenarios](Twinfield.Twinfield.ReminderScenarios): Reminder Scenarios
- [Reports](Twinfield.Twinfield.Reports): Reports
- [Roles](Twinfield.Twinfield.Roles): Roles
- [SubItemsByArticle](Twinfield.Twinfield.SubItemsByArticle): Sub-items by Article
- [SupplierTransactions](Twinfield.Twinfield.SupplierTransactions): Supplier Transactions
- [Suppliers](Twinfield.Twinfield.Suppliers): Suppliers
- [SuppliersV2](Twinfield.Twinfield.SuppliersV2): Suppliers (V2)
- [TableColumnSpecifications](Twinfield.Twinfield.TableColumnSpecifications): Table Column Specifications
- [TaxGroupVatReturnAsXbrlByDocumentId](Twinfield.Twinfield.TaxGroupVatReturnAsXbrlByDocumentId): Tax Group VAT Return as XBRL by Document ID
- [TaxGroupVatReturnAsXmlByDocumentId](Twinfield.Twinfield.TaxGroupVatReturnAsXmlByDocumentId): Tax Group VAT Return as XML by Document ID
- [TaxGroupVatReturnPaymentReferenceByDocumentId](Twinfield.Twinfield.TaxGroupVatReturnPaymentReferenceByDocumentId): Tax Group VAT Return Payment Reference by Document ID
- [TaxGroups](Twinfield.Twinfield.TaxGroups): Tax Groups
- [TimeAndExpensesBillingDetails](Twinfield.Twinfield.TimeAndExpensesBillingDetails): Time and Expenses Billing Details
- [TimeAndExpensesBillingPerPeriod](Twinfield.Twinfield.TimeAndExpensesBillingPerPeriod): Time and Expenses Billing per Period
- [TimeAndExpensesBillingPerWeek](Twinfield.Twinfield.TimeAndExpensesBillingPerWeek): Time and Expenses Billing per Week
- [TimeAndExpensesDetails](Twinfield.Twinfield.TimeAndExpensesDetails): Time and Expenses Details
- [TimeAndExpensesMulticurrency](Twinfield.Twinfield.TimeAndExpensesMulticurrency): Time and Expenses (Multi-currency)
- [TimeAndExpensesTotals](Twinfield.Twinfield.TimeAndExpensesTotals): Time and Expenses Totals
- [TimeAndExpensesTotalsPerPeriod](Twinfield.Twinfield.TimeAndExpensesTotalsPerPeriod): Time and Expenses Totals per Period
- [TimeAndExpensesTotalsPerWeek](Twinfield.Twinfield.TimeAndExpensesTotalsPerWeek): Time and Expenses Totals per Week
- [TimeAndQuantitiesTransactionTypes](Twinfield.Twinfield.TimeAndQuantitiesTransactionTypes): Time and Quantities Transaction Types
- [TimeProjectRates](Twinfield.Twinfield.TimeProjectRates): Time Project Rates
- [TransactionList](Twinfield.Twinfield.TransactionList): Transactions List
- [TransactionSummary](Twinfield.Twinfield.TransactionSummary): Transactions Summary
- [TransactionsToBeMatched](Twinfield.Twinfield.TransactionsToBeMatched): Transactions to be Matched
- [Translations](Twinfield.Twinfield.Translations): Translations
- [Users](Twinfield.Twinfield.Users): Users
- [VATCodes](Twinfield.Twinfield.VATCodes): VAT Codes
- [VATGroupCountries](Twinfield.Twinfield.VATGroupCountries): VAT Group Countries
- [VATGroups](Twinfield.Twinfield.VATGroups): VAT Groups
- [VATNumberOfRelations](Twinfield.Twinfield.VATNumberOfRelations): VAT Number of Relations
- [VatReturnAsXbrlByDocumentId](Twinfield.Twinfield.VatReturnAsXbrlByDocumentId): VAT Return as XBRL by Document ID
- [VatReturnAsXmlByDocumentId](Twinfield.Twinfield.VatReturnAsXmlByDocumentId): VAT Return as XML by Document ID
- [VatReturnPaymentReferenceByDocumentId](Twinfield.Twinfield.VatReturnPaymentReferenceByDocumentId): VAT Return Payment Reference by Document ID
- [VatReturnStatus](Twinfield.Twinfield.VatReturnStatus): VAT Return Statuses
- [VatTypes](Twinfield.Twinfield.VatTypes): VAT Types
- [WordTemplates](Twinfield.Twinfield.WordTemplates): Word Templates

### Twinfield.Views

- [ActivityDimensionValues](Twinfield.Views.ActivityDimensionValues): Activity Dimension Values
- [ArticleLines](Twinfield.Views.ArticleLines): Item Lines
- [ArticleSettings](Twinfield.Views.ArticleSettings): Item Settings
- [BalanceSheetDimensionValues](Twinfield.Views.BalanceSheetDimensionValues): Balance Sheet Dimension Values
- [CostCenterBudgets](Twinfield.Views.CostCenterBudgets): Cost Centre Budgets
- [CostCenterDimensionValues](Twinfield.Views.CostCenterDimensionValues): Cost Centre Dimension Values
- [CreditorDimensionValues](Twinfield.Views.CreditorDimensionValues): Creditor Dimension Values
- [DebtorDimensionValues](Twinfield.Views.DebtorDimensionValues): Debtor Dimension Values
- [FinancialYears](Twinfield.Views.FinancialYears): Financial Years
- [FixedAssetDimensionValues](Twinfield.Views.FixedAssetDimensionValues): Fixed Asset Dimension Values
- [GeneralLedgerAccountMappingAccounts](Twinfield.Views.GeneralLedgerAccountMappingAccounts): General Ledger Account Mapping Accounts
- [GeneralLedgerAccountMappings](Twinfield.Views.GeneralLedgerAccountMappings): General Ledger Account Mappings
- [IctReturnsAsXbrl](Twinfield.Views.IctReturnsAsXbrl): ICT Returns as XBRL
- [IctReturnsAsXml](Twinfield.Views.IctReturnsAsXml): ICT Returns as XML
- [OfficeSettings](Twinfield.Views.OfficeSettings): Company Settings
- [PaymentTypeSettings](Twinfield.Views.PaymentTypeSettings): Payment Type Settings
- [Periods](Twinfield.Views.Periods): Financial Periods
- [PeriodsWithTransactions](Twinfield.Views.PeriodsWithTransactions): Periods with Transactions
- [ProfitAndLossBudgets](Twinfield.Views.ProfitAndLossBudgets): Profit and Loss Budgets
- [ProfitAndLossDimensionValues](Twinfield.Views.ProfitAndLossDimensionValues): Profit&Loss Dimension Values
- [ProjectBudgets](Twinfield.Views.ProjectBudgets): Project Budgets
- [ProjectDimensionValues](Twinfield.Views.ProjectDimensionValues): Project Dimension Values
- [ProjectRateChanges](Twinfield.Views.ProjectRateChanges): Project Rate Changes
- [ProjectRateSettings](Twinfield.Views.ProjectRateSettings): Project Rate Settings
- [SubItems](Twinfield.Views.SubItems): Sub-items
- [TaxGroupVatReturnPaymentReferences](Twinfield.Views.TaxGroupVatReturnPaymentReferences): Tax Group VAT Payment References
- [TaxGroupVatReturnsAsXbrl](Twinfield.Views.TaxGroupVatReturnsAsXbrl): Tax Group VAT Returns as XBRL
- [TaxGroupVatReturnsAsXml](Twinfield.Views.TaxGroupVatReturnsAsXml): Tax Group VAT Returns as XML
- [UserSettings](Twinfield.Views.UserSettings): User Settings
- [VatCodePercentages](Twinfield.Views.VatCodePercentages): VAT Code Percentages
- [VatCodeSettings](Twinfield.Views.VatCodeSettings): VAT Code Settings
- [VatReturnPaymentReferences](Twinfield.Views.VatReturnPaymentReferences): VAT Return Payment References
- [VatReturnsAsXbrl](Twinfield.Views.VatReturnsAsXbrl): VAT Returns as XBRL
- [VatReturnsAsXml](Twinfield.Views.VatReturnsAsXml): VAT Returns as XML

## Sample Queries

```sql
--
-- 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
```

```sql
--
-- 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
```

## Attributes

The attributes of this platform are on the page [Attributes](attributes).



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Twinfield](/en/release-notes/drivers?driver=twinfield)

