invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Modèle de données Twinfield

Twinfield est un logiciel de comptabilité en ligne utilisé aux Pays-Bas et en Belgique. Les professionnels de la comptabilité constituent une part importante de la communauté des utilisateurs de Twinfield.

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/twinfield

Les données sont partitionnées par société (COMPANY_CODE).

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Une Query peut interroger plusieurs entreprises à la fois.
  • Forfaits Invantive Cloud : Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Langue de sa communauté d'utilisateurs : néerlandais.

Chiffres

Figure Count
Tables 251
Columns 14,640
Tableaux avec insert 1
Tables avec mise à jour 0
Tables avec la clause DELETE 0
Tableaux documentés 93

Affiche sur le modèle de données

PDF, 2 feuilles A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

Twinfield Modèle de données, Page 1 sur 2Twinfield Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 27.1.3-BETA+6294 · 01-11-2026Twinfield · Offices · Dimensions · Customers · Dimensions · Suppliers · Twinfield · Twinfield · CashbooksAndBanks · Dimensions · Activities · Dimensions · ProjectsPage 1 sur 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 WordTemplateKindsWordTemplateKindsTwinfieldDictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.SujetsDimensions · Activities1Dimensions · Customers1Dimensions · Projects1Dimensions · Suppliers1Twinfield1Twinfield · CashbooksAndBanks1Twinfield · Offices1Tables sans relations1, 2LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes×n: n relations between the same tablesLettres : désigne une table utilisée dans la plupart des rubriques: O = OfficesGénéré à partir des métadonnées d'Invantive UniversalSQL 27.1.3-BETA+6294 le 01-11-2026. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/twinfield
L'affiche sous forme de texte : tableaux par thème et leurs 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 (sans relations)

ActiveAnalyses

CodeValues (sans 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 (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Twinfield (sans relations)

Cheques, DocketInvoices, PlatformVersion, TableColumnSpecifications

Vues (sans 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

Tableaux

Twinfield.ActiveAnalysis

Twinfield.CodeValues

Twinfield.Deleted

Twinfield.Dimensions

Twinfield.Native

Twinfield.Settings

Twinfield.Twinfield

Twinfield.Views

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

Attributs

Les caractéristiques de cette plateforme sont présentées sur la page Attributes.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :