invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Modelo de datos de Twinfield

Twinfield es un paquete contable en línea utilizado en los Países Bajos y Bélgica. Los profesionales de la contabilidad constituyen una gran parte de la comunidad de usuarios de Twinfield.

Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/twinfield

Los datos están particionados por empresa (COMPANY_CODE).

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su API.
  • Los datos se agrupan por categorías, como por empresa o por administración.
  • Una Query puede leer varios datos de empresas a la vez.
  • Planes de Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Idioma de su comunidad de usuarios: neerlandés.

Cifras

Figure Count
Tables 251
Columns 14,640
Tablas con inserciones 1
Tablas con actualización 0
Tablas con la instrucción «DELETE» 0
Tablas documentadas 93

Póster del Modelo de Datos

PDF, 2 hojas A0

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Twinfield Modelo de Datos, Hoja 1 de 2Twinfield Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.3-BETA+6294 · 01-11-2026Twinfield · Offices · Dimensions · Customers · Dimensions · Suppliers · Twinfield · Twinfield · CashbooksAndBanks · Dimensions · Activities · Dimensions · ProjectsHoja 1 de 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 WordTemplateKindsWordTemplateKindsTwinfieldDiccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasDimensions · Activities1Dimensions · Customers1Dimensions · Projects1Dimensions · Suppliers1Twinfield1Twinfield · CashbooksAndBanks1Twinfield · Offices1Tablas sin relaciones1, 2LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes×n: n relations between the same tablesLetras: se refiere a una tabla que se utiliza en la mayoría de los temas: O = OfficesGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.3-BETA+6294 el 01-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/twinfield
El póster en forma de texto: tablas por tema y sus relaciones

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 (sin relaciones)

ActiveAnalyses

CodeValues (sin relaciones)

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 (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Twinfield (sin relaciones)

Cheques, DocketInvoices, PlatformVersion, TableColumnSpecifications

Vistas (sin relaciones)

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

Relaciones

Tablas

Twinfield.ActiveAnalysis

Twinfield.CodeValues

Twinfield.Deleted

Twinfield.Dimensions

Twinfield.Native

Twinfield.Settings

Twinfield.Twinfield

Twinfield.Views

Ejemplos 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

Atributos

Las características de esta plataforma se encuentran en la página Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: