invantive documentation
Invantive Support ForumsLog In / Sign Up

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

Data Model Poster

PDF, 2 A0 sheets

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Twinfield data model, Sheet 1 of 2Twinfield data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026Twinfield · Offices · Dimensions · Customers · Dimensions · Suppliers · Twinfield · Twinfield · CashbooksAndBanks · Dimensions · Activities · Dimensions · ProjectsSheet 1 of 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 WordTemplateKindsWordTemplateKindsTwinfieldData dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsDimensions · Activities1Dimensions · Customers1Dimensions · Projects1Dimensions · Suppliers1Twinfield1Twinfield · CashbooksAndBanks1Twinfield · Offices1Tables without relations1, 2LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n relations between the same tablesLetters: refers to a table used by most topics: O = OfficesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/twinfield
The poster as text: tables per topic and their relations

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 (without relations)

ActiveAnalyses

CodeValues (without relations)

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 (without relations)

NATIVEPLATFORMSCALARREQUESTS

Twinfield (without relations)

Cheques, DocketInvoices, PlatformVersion, TableColumnSpecifications

Views (without relations)

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

Relations

Tables

Twinfield.ActiveAnalysis

Twinfield.CodeValues

Twinfield.Deleted

Twinfield.Dimensions

Twinfield.Native

Twinfield.Settings

Twinfield.Twinfield

Twinfield.Views

Sample Queries

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

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: