invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Modello dati Twinfield

Twinfield è un pacchetto di contabilità online utilizzato nei Paesi Bassi e in Belgio. I professionisti contabili costituiscono una larga parte della comunità di utenti di Twinfield.

Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/twinfield

I dati sono suddivisi per società (COMPANY_CODE).

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

Piattaforma

  • Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
  • Tipo: un'applicazione accessibile tramite la propria API.
  • I dati sono suddivisi, ad esempio per azienda o per amministrazione.
  • Una query può leggere i dati di più aziende contemporaneamente.
  • Piani Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Lingua della sua comunità di utenti: olandese.

Figure

Figure Count
Tables 251
Columns 14,640
Tabella con inserti 1
Tabella con aggiornamento 0
Tabella con la clausola DELETE 0
Tabella documentata 93

Poster sul modello di dati

PDF, 2 fogli in formato A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Twinfield Modello di dati, Foglio 1 di 2Twinfield Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.3-BETA+6294 · 01-11-2026Twinfield · Offices · Dimensions · Customers · Dimensions · Suppliers · Twinfield · Twinfield · CashbooksAndBanks · Dimensions · Activities · Dimensions · ProjectsFoglio 1 di 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 WordTemplateKindsWordTemplateKindsTwinfieldDizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiDimensions · Activities1Dimensions · Customers1Dimensions · Projects1Dimensions · Suppliers1Twinfield1Twinfield · CashbooksAndBanks1Twinfield · Offices1Tabella senza relazioni1, 2LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti×n: n relations between the same tablesLettere: si riferisce a una tabella utilizzata nella maggior parte degli argomenti: O = OfficesGenerato dai metadati di Invantive UniversalSQL 27.1.3-BETA+6294 il 01-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/twinfield
Il poster come testo: tabelle per argomento e le loro relazioni

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 (senza relazioni)

ActiveAnalyses

CodeValues (senza relazioni)

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 (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

Twinfield (senza relazioni)

Cheques, DocketInvoices, PlatformVersion, TableColumnSpecifications

Visualizzazioni (senza relazioni)

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

Relazioni

Tabelle

Twinfield.ActiveAnalysis

Twinfield.CodeValues

Twinfield.Deleted

Twinfield.Dimensions

Twinfield.Native

Twinfield.Settings

Twinfield.Twinfield

Twinfield.Views

Esempi di Query

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

Attributi

Le caratteristiche di questa piattaforma sono riportate nella pagina Attributes.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: