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
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
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)
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)
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
- Activities → Offices (key)
- ActivityChildValidations → Activities (key)
- ActivityChildValidations → Offices (key)
- ActivityProjectQuantities → Activities (key)
- ActivityProjectQuantities → Offices (key)
- Assets → Offices (key)
- BalancesheetBanks → Offices (key)
- BalancesheetChildValidations → Offices (key)
- BalancesheetGroups → Offices (key)
- Balancesheets → Offices (key)
- CostCenters → Offices (key)
- CustomerAddresses → Customers (key)
- CustomerAddresses → Offices (key)
- CustomerBanks → Customers (key)
- CustomerBanks → Offices (key)
- CustomerChildValidations → Customers (key)
- CustomerChildValidations → Offices (key)
- CustomerPaymentConditions → Customers (key)
- CustomerPaymentConditions → Offices (key)
- Customers → Offices (key)
- Customers → VATCodes (key)
- ProfitAndLoss → Offices (key)
- ProfitAndLossBanks → Offices (key)
- ProfitAndLossChildValidations → Offices (key)
- ProfitAndLossGroups → Offices (key)
- ProjectChildValidations → Projects (key)
- ProjectChildValidations → Offices (key)
- ProjectQuantities → Projects (key)
- ProjectQuantities → Offices (key)
- Projects → Offices (key)
- SupplierAddresses → Suppliers (key)
- SupplierAddresses → Offices (key)
- SupplierBanks → Suppliers (key)
- SupplierBanks → Offices (key)
- SupplierChildValidations → Suppliers (key)
- SupplierChildValidations → Offices (key)
- SupplierPaymentConditions → Suppliers (key)
- SupplierPaymentConditions → Offices (key)
- Suppliers → Offices (key)
- Suppliers → VATCodes (key)
- AnnualReportTotals → Offices (key)
- AnnualReportTotalsMulticurrency → Offices (key)
- AnnualReportYtd → Offices (key)
- AssetMethods → Offices (key)
- AssetTransactions → Balancesheets (described in words): 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 (described in words): 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 (key)
- AssetTransactions → Offices (key)
- AssetTransactions → VATCodes (key)
- BankLinkDetails → Offices (key)
- BankLinkDetailsV2 → Offices (key)
- BankTransactions → Balancesheets (described in words): 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 (described in words): 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 (key)
- BankTransactions → Currencies (key)
- BankTransactions → Offices (key)
- BankTransactions → VATCodes (key)
- BillingSchedules → Offices (key)
- Budgets → Offices (key)
- CashTransactions → Balancesheets (described in words): 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 (described in words): 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 (key)
- CashTransactions → Currencies (key)
- CashTransactions → Offices (key)
- CashTransactions → VATCodes (key)
- CashbooksAndBanks → Offices (key)
- Certificates → Offices (key)
- CommercialAnnualReportTotals → Offices (key)
- CommercialAnnualReportTotalsMulticurrency → Offices (key)
- CommercialAnnualReportYtd → Offices (key)
- CostCenters → Offices (key)
- CreditManagement → Offices (key)
- CreditManagementActionCodes → Offices (key)
- Currencies → Offices (key)
- CustomerTransactions → Balancesheets (described in words): 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 (described in words): 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 (key)
- CustomerTransactions → Offices (key)
- CustomerTransactions → VATCodes (key)
- Customers → Offices (key)
- CustomersV2 → Offices (key)
- CustomersV3 → Offices (key)
- Declarations → Offices (key)
- DistributionByPeriods → Offices (key)
- EconomicAnnualReportTotals → Offices (key)
- EconomicAnnualReportTotalsMulticurrency → Offices (key)
- EconomicAnnualReportYtd → Offices (key)
- FilterMappings → Offices (key)
- FinancialDimensions → Offices (key)
- FiscalAnnualReportTotals → Offices (key)
- FiscalAnnualReportTotalsMulticurrency → Offices (key)
- FiscalAnnualReportYtd → Offices (key)
- FixedAssets → Offices (key)
- Gateways → Offices (key)
- GeneralLedgerDetails → Balancesheets (described in words): 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 (described in words): 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 (key)
- GeneralLedgerDetails → Offices (key)
- GeneralLedgerDetails → VATCodes (key)
- GeneralLedgerDetailsV2 → Balancesheets (described in words): 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 (described in words): 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 (key)
- GeneralLedgerDetailsV2 → Offices (key)
- GeneralLedgerDetailsV2 → VATCodes (key)
- GeneralLedgerDetailsV3 → Balancesheets (described in words): 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 (described in words): 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 (key)
- GeneralLedgerDetailsV3 → Offices (key)
- GeneralLedgerDetailsV3 → VATCodes (key)
- GeneralLedgerIntercompany → Offices (key)
- GeneralLedgerIntercompanyV2 → Offices (key)
- GeneralLedgerTransactions → Balancesheets (described in words): 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 (described in words): 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 (key)
- GeneralLedgerTransactions → Offices (key)
- GeneralLedgerTransactions → VATCodes (key)
- HierarchyAccess → Offices (key)
- IctCountries → Offices (key)
- MatchingTypes → Offices (key)
- OfficeGroups → Offices (key)
- OfficesForInterCompanyTransactions → Offices (key)
- PayinginSlips → Offices (key)
- PaymentFiles → Offices (key)
- Periods → Offices (key)
- ProjectDimensions → Offices (key)
- ProjectTransactions → Balancesheets (described in words): 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 (described in words): 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 (key)
- ProjectTransactions → Offices (key)
- ProjectTransactions → VATCodes (key)
- ReminderScenarios → Offices (key)
- Reports → Offices (key)
- Roles → Offices (key)
- SupplierTransactions → Balancesheets (described in words): 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 (described in words): 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 (key)
- SupplierTransactions → Offices (key)
- SupplierTransactions → VATCodes (key)
- Suppliers → Offices (key)
- SuppliersV2 → Offices (key)
- TaxGroups → Offices (key)
- TimeAndExpensesBillingDetails → Offices (key)
- TimeAndExpensesBillingPerPeriod → Offices (key)
- TimeAndExpensesBillingPerWeek → Offices (key)
- TimeAndExpensesDetails → Offices (key)
- TimeAndExpensesMulticurrency → Offices (key)
- TimeAndExpensesTotals → Offices (key)
- TimeAndExpensesTotalsPerPeriod → Offices (key)
- TimeAndExpensesTotalsPerWeek → Offices (key)
- TimeAndQuantitiesTransactionTypes → Offices (key)
- TransactionList → Balancesheets (described in words): 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 (described in words): 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 (key)
- TransactionList → Offices (key)
- TransactionList → VATCodes (key)
- TransactionSummary → Offices (key)
- TransactionsToBeMatched → Balancesheets (described in words): 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 (described in words): 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 (key)
- TransactionsToBeMatched → Offices (key)
- TransactionsToBeMatched → VATCodes (key)
- Translations → Offices (key)
- VATCodes → Offices (key)
- VATGroupCountries → Offices (key)
- VATGroups → Offices (key)
- VATNumberOfRelations → Offices (key)
- VatReturnStatus → Offices (key)
- VatTypes → Offices (key)
- WordTemplates → Offices (key)
Tables
Twinfield.ActiveAnalysis
- ActiveAnalyses: Active Analyses
Twinfield.CodeValues
- AccessTypes: Domain AccessTypes
- AddressTypes: Domain AddressTypes
- ArticleTypes: Domain ArticleTypes
- AssetCalculationMethods: Domain AssetCalculationMethods
- AssetStatuses: Domain AssetStatuses
- BankTransactionTypeFilters: Domain BankTransactionTypeFilters
- BrowseCodes: Domain BrowseCodes
- BrowseOperators: Domain BrowseOperators
- BrowseSortOrders: Domain BrowseSortOrders
- CollectionSchemas: Domain CollectionSchemas
- Cultures: Domain Cultures
- DebitCredits: Domain DebitCredits
- DepreciationStartMoments: Domain DepreciationStartMoments
- DimensionBehaviours: Domain DimensionBehaviours
- DimensionLevels: Domain DimensionLevels
- DimensionStatuses: Domain DimensionStatuses
- DimensionTypeCodes: Domain DimensionTypeCodes
- FinderSearchFields: Domain FinderSearchFields
- FinderTypeCodes: Domain FinderTypeCodes
- FreeTextTypes: Domain FreeTextTypes
- InvitationStatuses: Domain InvitationStatuses
- ItemValueVatInclusions: Domain ItemValueVatInclusions
- MatchStatuses: Domain MatchStatuses
- MatchTypes: Domain MatchTypes
- MatchingTypeCodes: Domain MatchingTypeCodes
- MeansOfPayment: Domain MeansOfPayment
- PayAddresses: Domain PayAddresses
- PerformanceTypes: Domain PerformanceTypes
- RateTypes: Domain RateTypes
- SalesInvoicePaymentMethods: Domain SalesInvoicePaymentMethods
- SalesInvoiceStatuses: Domain SalesInvoiceStatuses
- SendReminders: Domain SendReminders
- SendTypes: Domain SendTypes
- SepaDirectDebitSchemes: Domain SepaDirectDebitSchemes
- SingleSignOnSettings: Domain SingleSignOnSettings
- SmsLogonServices: Domain SmsLogonServices
- SubAnalyses: Domain SubAnalyses
- SubscriptionChangeReasons: Domain SubscriptionChangeReasons
- SubstitutionLevels: Domain SubstitutionLevels
- SubstitutionTypes: Domain SubstitutionTypes
- TemplateCompanyAccesses: Domain TemplateCompanyAccesses
- TimeEntryTypes: Domain TimeEntryTypes
- TimeTransactionCodes: Domain TimeTransactionCodes
- TransactionLineTypes: Domain TransactionLineTypes
- TransactionStatuses: Domain TransactionStatuses
- UserTypes: Domain UserTypes
- VatCodeLineTypes: Domain VatCodeLineTypes
- VatCodeTypes: Domain VatCodeTypes
- WaysOfPayment: Domain WaysOfPayment
- WordTemplateKinds: Domain WordTemplateKinds
Twinfield.Deleted
- DeletedTransactions: Deleted Transactions
Twinfield.Dimensions
- Activities: Activities
- ActivityChildValidations: Activity Child Validations
- ActivityProjectQuantities: Activity Project Quantities
- Assets: Assets
- BalancesheetBanks: Balance Sheet Bank
- BalancesheetChildValidations: Balance Sheet Child Validations
- BalancesheetGroups: Balance Sheet Groups
- Balancesheets: Balance Sheets
- CostCenters: Cost Centres
- CustomerAddresses: Customer Addresses
- CustomerBanks: Customer Banks
- CustomerChildValidations: Customer Child Validations
- CustomerPaymentConditions: Customer Payment Conditions
- Customers: Customers
- ProfitAndLoss: Profit and Loss
- ProfitAndLossBanks: Profit and Loss Banks
- ProfitAndLossChildValidations: Profit and Loss Child Validations
- ProfitAndLossGroups: Profit and Loss Groups
- ProjectChildValidations: Project Child Validations
- ProjectQuantities: Project Quantities
- Projects: Projects
- SupplierAddresses: Supplier Addresses
- SupplierBanks: Supplier Banks
- SupplierChildValidations: Supplier Child Validations
- SupplierPaymentConditions: Supplier Payment Conditions
- Suppliers: Suppliers
Twinfield.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Twinfield.Settings
- ArticleLinesByCode: Item Lines by Code
- ArticleSettingsByCode: Item Settings by Code
- OfficeSettingsByCode: Company Settings by Code
- PaymentTypeSettingsByCode: Payment Type Settings by Code
- ProjectRateChangesByCode: Project Rate Changes by Code
- ProjectRateSettingsByCode: Project Rate Settings by Code
- SalesInvoiceByNumber: Sales Invoice by Number
- SalesInvoiceLinesByNumber: Sales Invoice Lines by Number
- SalesInvoiceVatLinesByNumber: Sales Invoice VAT Lines by Number
- TransactionByNumber: Transaction by Number
- TransactionLinesByNumber: Transaction Lines by Number
- UserSettingsByUserCode: User Settings by User Code
- VatCodePercentagesByCode: VAT Code Percentages by Code
- VatCodeSettingsByCode: VAT Code Settings by Code
Twinfield.Twinfield
- AnnualReportTotals: Annual Report Totals
- AnnualReportTotalsMulticurrency: Annual Report Totals (Multi-currency)
- AnnualReportYtd: Annual Report YTD
- AssetMethods: Asset Methods
- AssetTransactions: Asset Transactions
- BankBookByCode: Bank Book by Code
- BankLinkDetails: Bank Link Details
- BankLinkDetailsV2: Bank Link Details (V2)
- BankStatementLinesByStatementDate: Bank Statement Lines by Statement Date
- BankStatementsByStatementDate: Bank Statements by Statement Date
- BankTransactions: Bank Transactions
- BillingSchedules: Billing Schedules
- BudgetByCostCenter: Budget by Cost Centre
- BudgetByProfitAndLoss: Budget by Profit & Loss
- BudgetByProject: Budget by Project
- Budgets: Budgets
- CashBookByCode: Cash Book by Code
- CashTransactions: Cash Transactions
- CashbooksAndBanks: Cash Books and Banks
- Certificates: Certificates
- Cheques: Cheques
- CommercialAnnualReportTotals: Commercial Annual Report Totals
- CommercialAnnualReportTotalsMulticurrency: Commercial Annual Report Totals Multi Currency
- CommercialAnnualReportYtd: Commercial Annual Report Ytd
- CostCenters: Cost Centres
- Countries: Countries
- CreditManagement: Credit Management
- CreditManagementActionCodes: Credit Management Action Codes
- Currencies: Currencies
- CustomerTransactions: Customer Transactions
- Customers: Customers
- CustomersV2: Customers (V2)
- CustomersV3: Customers (V3)
- DaybooksTransactionTypes: Journal Transaction Types
- Declarations: VAT Declarations
- DeclarationsByRange: VAT Declarations by Range
- DeclarationsByYear: Declarations by Year
- DeclarationsByYearSinceModified: Declarations by Year Since Modified
- DeclarationsSinceModified: Declarations Since Modified
- DimensionGroups: Dimension Groups
- DimensionTypes: Dimension Types
- DimensionsModifiedSince: Dimensions Modified Since
- DistributionByPeriods: Distribution by Periods
- DocketInvoices: Docket Invoices
- EconomicAnnualReportTotals: Economic Annual Report Totals
- EconomicAnnualReportTotalsMulticurrency: Economic Annual Report Totals (Multi Currency)
- EconomicAnnualReportYtd: Economic Annual Report YTD
- FilterMappings: Filter Mappings
- FinancialDimensions: Financial Dimensions
- FiscalAnnualReportTotals: Fiscal Annual Report Totals
- FiscalAnnualReportTotalsMulticurrency: Fiscal Annual Report Totals (Multi Currency)
- FiscalAnnualReportYtd: Fiscal Annual Report YTD
- FixedAssets: Fixed Assets
- Gateways: Gateways
- GeneralLedgerAccountMappingAccountsByHierarchyCode: General Ledger Account Mapping Accounts by Hierarchy Code
- GeneralLedgerAccountMappingByHierarchyCode: General Ledger Account Mapping by Hierarchy Code
- GeneralLedgerDetails: General Ledger Details
- GeneralLedgerDetailsV2: General Ledger Details (V2)
- GeneralLedgerDetailsV3: General Ledger Details (V3)
- GeneralLedgerIntercompany: General Ledger Intercompany
- GeneralLedgerIntercompanyV2: General Ledger Intercompany (V2)
- GeneralLedgerTransactions: General Ledger Transactions
- Hierarchies: Hierarchies
- HierarchyAccess: Hierarchy Access Privileges
- HierarchyNodes: Hierarchy Nodes
- IctCountries: ICT Countries
- IctReturnAsXbrlByDocumentId: ICT Return as XBRL by Document ID
- IctReturnAsXmlByDocumentId: ICT Return as XML by Document ID
- InvoiceTypes: Invoice Types
- Invoices: Invoices
- Items: Items
- MatchingTypes: Matching Types
- NumberOfDeclarations: Number of Declarations
- OfficeGroups: Administration Groups
- Offices: Administrations
- OfficesForInterCompanyTransactions: Administrations for Inter Company Transactions
- PayAndCollectRunById: Pay and Collect Run by Identifier
- PayAndCollectRuns: Pay and Collect Runs
- PayinginSlips: Payments in Process
- PaymentFiles: Payment File Formats
- PaymentTypes: Payment Types
- PeriodYears: Period Years
- Periods: Periods
- PeriodsByYear: Periods by Year
- PlatformVersion: Platform Version
- ProjectDimensions: Project Dimensions
- ProjectTransactions: Project Transactions
- ReminderScenarios: Reminder Scenarios
- Reports: Reports
- Roles: Roles
- SubItemsByArticle: Sub-items by Article
- SupplierTransactions: Supplier Transactions
- Suppliers: Suppliers
- SuppliersV2: Suppliers (V2)
- TableColumnSpecifications: Table Column Specifications
- TaxGroupVatReturnAsXbrlByDocumentId: Tax Group VAT Return as XBRL by Document ID
- TaxGroupVatReturnAsXmlByDocumentId: Tax Group VAT Return as XML by Document ID
- TaxGroupVatReturnPaymentReferenceByDocumentId: Tax Group VAT Return Payment Reference by Document ID
- TaxGroups: Tax Groups
- TimeAndExpensesBillingDetails: Time and Expenses Billing Details
- TimeAndExpensesBillingPerPeriod: Time and Expenses Billing per Period
- TimeAndExpensesBillingPerWeek: Time and Expenses Billing per Week
- TimeAndExpensesDetails: Time and Expenses Details
- TimeAndExpensesMulticurrency: Time and Expenses (Multi-currency)
- TimeAndExpensesTotals: Time and Expenses Totals
- TimeAndExpensesTotalsPerPeriod: Time and Expenses Totals per Period
- TimeAndExpensesTotalsPerWeek: Time and Expenses Totals per Week
- TimeAndQuantitiesTransactionTypes: Time and Quantities Transaction Types
- TimeProjectRates: Time Project Rates
- TransactionList: Transactions List
- TransactionSummary: Transactions Summary
- TransactionsToBeMatched: Transactions to be Matched
- Translations: Translations
- Users: Users
- VATCodes: VAT Codes
- VATGroupCountries: VAT Group Countries
- VATGroups: VAT Groups
- VATNumberOfRelations: VAT Number of Relations
- VatReturnAsXbrlByDocumentId: VAT Return as XBRL by Document ID
- VatReturnAsXmlByDocumentId: VAT Return as XML by Document ID
- VatReturnPaymentReferenceByDocumentId: VAT Return Payment Reference by Document ID
- VatReturnStatus: VAT Return Statuses
- VatTypes: VAT Types
- WordTemplates: Word Templates
Twinfield.Views
- ActivityDimensionValues: Activity Dimension Values
- ArticleLines: Item Lines
- ArticleSettings: Item Settings
- BalanceSheetDimensionValues: Balance Sheet Dimension Values
- CostCenterBudgets: Cost Centre Budgets
- CostCenterDimensionValues: Cost Centre Dimension Values
- CreditorDimensionValues: Creditor Dimension Values
- DebtorDimensionValues: Debtor Dimension Values
- FinancialYears: Financial Years
- FixedAssetDimensionValues: Fixed Asset Dimension Values
- GeneralLedgerAccountMappingAccounts: General Ledger Account Mapping Accounts
- GeneralLedgerAccountMappings: General Ledger Account Mappings
- IctReturnsAsXbrl: ICT Returns as XBRL
- IctReturnsAsXml: ICT Returns as XML
- OfficeSettings: Company Settings
- PaymentTypeSettings: Payment Type Settings
- Periods: Financial Periods
- PeriodsWithTransactions: Periods with Transactions
- ProfitAndLossBudgets: Profit and Loss Budgets
- ProfitAndLossDimensionValues: Profit&Loss Dimension Values
- ProjectBudgets: Project Budgets
- ProjectDimensionValues: Project Dimension Values
- ProjectRateChanges: Project Rate Changes
- ProjectRateSettings: Project Rate Settings
- SubItems: Sub-items
- TaxGroupVatReturnPaymentReferences: Tax Group VAT Payment References
- TaxGroupVatReturnsAsXbrl: Tax Group VAT Returns as XBRL
- TaxGroupVatReturnsAsXml: Tax Group VAT Returns as XML
- UserSettings: User Settings
- VatCodePercentages: VAT Code Percentages
- VatCodeSettings: VAT Code Settings
- VatReturnPaymentReferences: VAT Return Payment References
- VatReturnsAsXbrl: VAT Returns as XBRL
- VatReturnsAsXml: VAT Returns as XML
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: