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
En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.
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)
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)
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
- Activities → Offices (clave)
- ActivityChildValidations → Activities (clave)
- ActivityChildValidations → Offices (clave)
- ActivityProjectQuantities → Activities (clave)
- ActivityProjectQuantities → Offices (clave)
- Assets → Offices (clave)
- BalancesheetBanks → Offices (clave)
- BalancesheetChildValidations → Offices (clave)
- BalancesheetGroups → Offices (clave)
- Balancesheets → Offices (clave)
- CostCenters → Offices (clave)
- CustomerAddresses → Customers (clave)
- CustomerAddresses → Offices (clave)
- CustomerBanks → Customers (clave)
- CustomerBanks → Offices (clave)
- CustomerChildValidations → Customers (clave)
- CustomerChildValidations → Offices (clave)
- CustomerPaymentConditions → Customers (clave)
- CustomerPaymentConditions → Offices (clave)
- Customers → Offices (clave)
- Customers → VATCodes (clave)
- ProfitAndLoss → Offices (clave)
- ProfitAndLossBanks → Offices (clave)
- ProfitAndLossChildValidations → Offices (clave)
- ProfitAndLossGroups → Offices (clave)
- ProjectChildValidations → Projects (clave)
- ProjectChildValidations → Offices (clave)
- ProjectQuantities → Projects (clave)
- ProjectQuantities → Offices (clave)
- Projects → Offices (clave)
- SupplierAddresses → Suppliers (clave)
- SupplierAddresses → Offices (clave)
- SupplierBanks → Suppliers (clave)
- SupplierBanks → Offices (clave)
- SupplierChildValidations → Suppliers (clave)
- SupplierChildValidations → Offices (clave)
- SupplierPaymentConditions → Suppliers (clave)
- SupplierPaymentConditions → Offices (clave)
- Suppliers → Offices (clave)
- Suppliers → VATCodes (clave)
- AnnualReportTotals → Offices (clave)
- AnnualReportTotalsMulticurrency → Offices (clave)
- AnnualReportYtd → Offices (clave)
- AssetMethods → Offices (clave)
- AssetTransactions → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- AssetTransactions → Offices (clave)
- AssetTransactions → VATCodes (clave)
- BankLinkDetails → Offices (clave)
- BankLinkDetailsV2 → Offices (clave)
- BankTransactions → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- BankTransactions → Currencies (clave)
- BankTransactions → Offices (clave)
- BankTransactions → VATCodes (clave)
- BillingSchedules → Offices (clave)
- Budgets → Offices (clave)
- CashTransactions → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- CashTransactions → Currencies (clave)
- CashTransactions → Offices (clave)
- CashTransactions → VATCodes (clave)
- CashbooksAndBanks → Offices (clave)
- Certificates → Offices (clave)
- CommercialAnnualReportTotals → Offices (clave)
- CommercialAnnualReportTotalsMulticurrency → Offices (clave)
- CommercialAnnualReportYtd → Offices (clave)
- CostCenters → Offices (clave)
- CreditManagement → Offices (clave)
- CreditManagementActionCodes → Offices (clave)
- Currencies → Offices (clave)
- CustomerTransactions → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- CustomerTransactions → Offices (clave)
- CustomerTransactions → VATCodes (clave)
- Customers → Offices (clave)
- CustomersV2 → Offices (clave)
- CustomersV3 → Offices (clave)
- Declarations → Offices (clave)
- DistributionByPeriods → Offices (clave)
- EconomicAnnualReportTotals → Offices (clave)
- EconomicAnnualReportTotalsMulticurrency → Offices (clave)
- EconomicAnnualReportYtd → Offices (clave)
- FilterMappings → Offices (clave)
- FinancialDimensions → Offices (clave)
- FiscalAnnualReportTotals → Offices (clave)
- FiscalAnnualReportTotalsMulticurrency → Offices (clave)
- FiscalAnnualReportYtd → Offices (clave)
- FixedAssets → Offices (clave)
- Gateways → Offices (clave)
- GeneralLedgerDetails → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- GeneralLedgerDetails → Offices (clave)
- GeneralLedgerDetails → VATCodes (clave)
- GeneralLedgerDetailsV2 → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- GeneralLedgerDetailsV2 → Offices (clave)
- GeneralLedgerDetailsV2 → VATCodes (clave)
- GeneralLedgerDetailsV3 → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- GeneralLedgerDetailsV3 → Offices (clave)
- GeneralLedgerDetailsV3 → VATCodes (clave)
- GeneralLedgerIntercompany → Offices (clave)
- GeneralLedgerIntercompanyV2 → Offices (clave)
- GeneralLedgerTransactions → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- GeneralLedgerTransactions → Offices (clave)
- GeneralLedgerTransactions → VATCodes (clave)
- HierarchyAccess → Offices (clave)
- IctCountries → Offices (clave)
- MatchingTypes → Offices (clave)
- OfficeGroups → Offices (clave)
- OfficesForInterCompanyTransactions → Offices (clave)
- PayinginSlips → Offices (clave)
- PaymentFiles → Offices (clave)
- Periods → Offices (clave)
- ProjectDimensions → Offices (clave)
- ProjectTransactions → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- ProjectTransactions → Offices (clave)
- ProjectTransactions → VATCodes (clave)
- ReminderScenarios → Offices (clave)
- Reports → Offices (clave)
- Roles → Offices (clave)
- SupplierTransactions → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- SupplierTransactions → Offices (clave)
- SupplierTransactions → VATCodes (clave)
- Suppliers → Offices (clave)
- SuppliersV2 → Offices (clave)
- TaxGroups → Offices (clave)
- TimeAndExpensesBillingDetails → Offices (clave)
- TimeAndExpensesBillingPerPeriod → Offices (clave)
- TimeAndExpensesBillingPerWeek → Offices (clave)
- TimeAndExpensesDetails → Offices (clave)
- TimeAndExpensesMulticurrency → Offices (clave)
- TimeAndExpensesTotals → Offices (clave)
- TimeAndExpensesTotalsPerPeriod → Offices (clave)
- TimeAndExpensesTotalsPerWeek → Offices (clave)
- TimeAndQuantitiesTransactionTypes → Offices (clave)
- TransactionList → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- TransactionList → Offices (clave)
- TransactionList → VATCodes (clave)
- TransactionSummary → Offices (clave)
- TransactionsToBeMatched → Balancesheets (descrito con palabras): 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 (descrito con palabras): 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 (clave)
- TransactionsToBeMatched → Offices (clave)
- TransactionsToBeMatched → VATCodes (clave)
- Translations → Offices (clave)
- VATCodes → Offices (clave)
- VATGroupCountries → Offices (clave)
- VATGroups → Offices (clave)
- VATNumberOfRelations → Offices (clave)
- VatReturnStatus → Offices (clave)
- VatTypes → Offices (clave)
- WordTemplates → Offices (clave)
Tablas
Twinfield.ActiveAnalysis
- ActiveAnalyses: Análisis activos
Twinfield.CodeValues
- AccessTypes: Dominio AccessTypes
- AddressTypes: Dominio AddressTypes
- ArticleTypes: Dominio ArticleTypes
- AssetCalculationMethods: Dominio AssetCalculationMethods
- AssetStatuses: Dominio AssetStatuses
- BankTransactionTypeFilters: Dominio BankTransactionTypeFilters
- BrowseCodes: Dominio BrowseCodes
- BrowseOperators: Dominio BrowseOperators
- BrowseSortOrders: Dominio BrowseSortOrders
- CollectionSchemas: Dominio CollectionSchemas
- Cultures: Culturas de dominio
- DebitCredits: Dominio DebitCredits
- DepreciationStartMoments: Dominio DepreciationStartMoments
- DimensionBehaviours: Dominio DimensionBehaviours
- DimensionLevels: Dominio DimensionLevels
- DimensionStatuses: Dominio DimensionStatuses
- DimensionTypeCodes: Dominio DimensionTypeCodes
- FinderSearchFields: Dominio FinderSearchFields
- FinderTypeCodes: Dominio FinderTypeCodes
- FreeTextTypes: Dominio FreeTextTypes
- InvitationStatuses: Dominio InvitationStatuses
- ItemValueVatInclusions: Dominio ItemValueVatInclusions
- MatchStatuses: Dominio MatchStatuses
- MatchTypes: Dominio MatchTypes
- MatchingTypeCodes: Dominio MatchingTypeCodes
- MeansOfPayment: Dominio MeansOfPayment
- PayAddresses: Dominio PayAddresses
- PerformanceTypes: Dominio PerformanceTypes
- RateTypes: Dominio RateTypes
- SalesInvoicePaymentMethods: Dominio SalesInvoicePaymentMethods
- SalesInvoiceStatuses: Dominio SalesInvoiceStatuses
- SendReminders: Dominio SendReminders
- SendTypes: Dominio SendTypes
- SepaDirectDebitSchemes: Dominio SepaDirectDebitSchemes
- SingleSignOnSettings: Dominio SingleSignOnSettings
- SmsLogonServices: Dominio SmsLogonServices
- SubAnalyses: Dominio SubAnalyses
- SubscriptionChangeReasons: Dominio SubscriptionChangeReasons
- SubstitutionLevels: Dominio SubstitutionLevels
- SubstitutionTypes: Dominio SubstitutionTypes
- TemplateCompanyAccesses: Dominio TemplateCompanyAccesses
- TimeEntryTypes: Dominio TimeEntryTypes
- TimeTransactionCodes: Dominio TimeTransactionCodes
- TransactionLineTypes: Dominio TransactionLineTypes
- TransactionStatuses: Dominio TransactionStatuses
- UserTypes: Dominio UserTypes
- VatCodeLineTypes: Dominio VatCodeLineTypes
- VatCodeTypes: Dominio VatCodeTypes
- WaysOfPayment: Dominio WaysOfPayment
- WordTemplateKinds: Dominio WordTemplateKinds
Twinfield.Deleted
- DeletedTransactions: Transacciones eliminadas
Twinfield.Dimensions
- Actividades: Actividades
- ActivityChildValidations: Validaciones secundarias de actividad
- ActivityProjectQuantities: Cantidades de proyecto de actividad
- Assets: Activos
- BalancesheetBanks: Banco de balance
- BalancesheetChildValidations: Validaciones secundarias del balance
- BalancesheetGroups: Grupos de balance
- Balances: Balances de situación
- CostCenters: Centros de coste
- CustomerAddresses: Direcciones de cliente
- CustomerBanks: Bancos de clientes
- CustomerChildValidations: Validaciones secundarias de clientes
- CustomerPaymentConditions: Condiciones de pago de clientes
- Clientes: Clientes
- ProfitAndLoss: Pérdidas y ganancias
- ProfitAndLossBanks: Bancos de pérdidas y ganancias
- ProfitAndLossChildValidations: Validaciones secundarias de pérdidas y ganancias
- ProfitAndLossGroups: Grupos de pérdidas y ganancias
- ProjectChildValidations: Validaciones secundarias de proyecto
- ProjectQuantities: Cantidades de proyecto
- Projects: Proyectos
- SupplierAddresses: Direcciones de proveedores
- SupplierBanks: Bancos de proveedores
- SupplierChildValidations: Validaciones secundarias de proveedor
- SupplierPaymentConditions: Condiciones de pago de proveedores
- Proveedores: Proveedores
Twinfield.Native
- NATIVEPLATFORMSCALARREQUESTS: Solicitudes escalares de plataformas nativas
Twinfield.Settings
- ArticleLinesByCode: Líneas de artículo por código
- ArticleSettingsByCode: Configuración de artículos por código
- OfficeSettingsByCode: Ajustes de empresa por código
- PaymentTypeSettingsByCode: Configuración de tipo de pago por código
- ProjectRateChangesByCode: Cambios de tarifa de proyecto por código
- ProjectRateSettingsByCode: Ajustes de tarifa de proyecto por código
- SalesInvoiceByNumber: Factura de venta por número
- SalesInvoiceLinesByNumber: Líneas de factura de venta por número
- SalesInvoiceVatLinesByNumber: Líneas de IVA de facturas de venta por número
- TransactionByNumber: Transacción por número
- TransactionLinesByNumber: Líneas de transacción por número
- UserSettingsByUserCode: Configuración de usuario por código de usuario
- VatCodePercentagesByCode: Porcentajes de código de IVA por código
- VatCodeSettingsByCode: Configuración de códigos de IVA por código
Twinfield.Twinfield
- AnnualReportTotals: Totales del informe anual
- AnnualReportTotalsMulticurrency: Totales del informe anual (multidivisa)
- AnnualReportYtd: Informe anual acumulado (YTD)
- AssetMethods: Métodos de activos
- AssetTransactions: Transacciones de activos
- BankBookByCode: Libro bancario por código
- BankLinkDetails: Detalles de vínculo bancario
- BankLinkDetailsV2: Detalles de vínculo bancario (V2)
- BankStatementLinesByStatementDate: Líneas de extracto bancario por fecha de extracto
- BankStatementsByStatementDate: Extractos bancarios por fecha de extracto
- BankTransactions: Transacciones bancarias
- BillingSchedules: Calendarios de facturación
- BudgetByCostCenter: Presupuesto por centro de coste
- BudgetByProfitAndLoss: Presupuesto por pérdidas y ganancias
- BudgetByProject: Presupuesto por proyecto
- Budgets: Presupuestos
- CashBookByCode: Libro de caja por código
- CashTransactions: Transacciones de caja
- CashbooksAndBanks: Libros de caja y bancos
- Certificates: Certificados
- Cheques: Cheques
- CommercialAnnualReportTotals: Totales del informe anual comercial
- CommercialAnnualReportTotalsMulticurrency: Totales del informe anual comercial multidivisa
- CommercialAnnualReportYtd: Informe anual comercial acumulado del año
- CostCenters: Centros de coste
- Países: Países
- CreditManagement: Gestión de crédito
- CreditManagementActionCodes: Códigos de acción de gestión de crédito
- Monedas: Monedas
- CustomerTransactions: Transacciones de clientes
- Clientes: Clientes
- CustomersV2: Clientes (V2)
- CustomersV3: Clientes (V3)
- DaybooksTransactionTypes: Tipos de transacción de diario
- Declaraciones: Declaraciones de IVA
- DeclarationsByRange: Declaraciones de IVA por rango
- DeclarationsByYear: Declaraciones por año
- DeclarationsByYearSinceModified: Declaraciones por año modificadas desde
- DeclarationsSinceModified: Declaraciones modificadas desde
- DimensionGroups: Grupos de dimensiones
- DimensionTypes: Tipos de dimensión
- DimensionsModifiedSince: Dimensiones modificadas desde
- DistributionByPeriods: Distribución por periodos
- DocketInvoices: Facturas de albarán
- EconomicAnnualReportTotals: Totales de informe anual económico
- EconomicAnnualReportTotalsMulticurrency: Totales del informe anual económico (multidivisa)
- EconomicAnnualReportYtd: Informe anual económico acumulado
- FilterMappings: Asignaciones de filtros
- FinancialDimensions: Dimensiones financieras
- FiscalAnnualReportTotals: Totales del informe anual fiscal
- FiscalAnnualReportTotalsMulticurrency: Totales de informe anual fiscal (multidivisa)
- FiscalAnnualReportYtd: Informe anual fiscal acumulado del año
- FixedAssets: Activos fijos
- Gateways: Pasarelas
- GeneralLedgerAccountMappingAccountsByHierarchyCode: Cuentas de asignación del libro mayor por código de jerarquía
- GeneralLedgerAccountMappingByHierarchyCode: Asignación de cuentas del libro mayor por código de jerarquía
- GeneralLedgerDetails: Detalles del libro mayor
- GeneralLedgerDetailsV2: Detalles del libro mayor (V2)
- GeneralLedgerDetailsV3: Detalles del libro mayor (V3)
- GeneralLedgerIntercompany: Intercompañía del libro mayor
- GeneralLedgerIntercompanyV2: Intercompañía del libro mayor (V2)
- GeneralLedgerTransactions: Transacciones del libro mayor
- Jerarquías: Jerarquías
- HierarchyAccess: Privilegios de acceso a jerarquías
- HierarchyNodes: Nodos de jerarquía
- IctCountries: Países ICT
- IctReturnAsXbrlByDocumentId: Declaración ICT en XBRL por ID de documento
- IctReturnAsXmlByDocumentId: Declaración ICT como XML por ID de documento
- InvoiceTypes: Tipos de factura
- Facturas: Facturas
- Artículos: Artículos
- MatchingTypes: Tipos de coincidencia
- NumberOfDeclarations: Número de declaraciones
- OfficeGroups: Grupos de administraciones
- Offices: Administraciones
- OfficesForInterCompanyTransactions: Administraciones para transacciones intercompañía
- PayAndCollectRunById: Ejecución de pago y cobro por identificador
- PayAndCollectRuns: Ejecuciones de pago y cobro
- PayinginSlips: Pagos en proceso
- PaymentFiles: Formatos de archivo de pago
- PaymentTypes: Tipos de pago
- PeriodYears: Años de periodo
- Periods: Periodos
- PeriodsByYear: Periodos por año
- PlatformVersion: Versión de la plataforma
- ProjectDimensions: Dimensiones de proyecto
- ProjectTransactions: Transacciones de proyecto
- ReminderScenarios: Escenarios de recordatorio
- Informes: Informes
- Roles: Roles
- SubItemsByArticle: Subartículos por artículo
- SupplierTransactions: Transacciones de proveedores
- Proveedores: Proveedores
- SuppliersV2: Proveedores (V2)
- TableColumnSpecifications: Especificaciones de columnas de tabla
- TaxGroupVatReturnAsXbrlByDocumentId: Declaración de IVA por grupo fiscal en XBRL por ID de documento
- TaxGroupVatReturnAsXmlByDocumentId: Declaración de IVA de grupo fiscal en XML por ID de documento
- TaxGroupVatReturnPaymentReferenceByDocumentId: Referencia de pago de la declaración de IVA por grupo fiscal por ID de documento
- TaxGroups: Grupos fiscales
- TimeAndExpensesBillingDetails: Detalles de facturación de tiempo y gastos
- TimeAndExpensesBillingPerPeriod: Facturación de tiempo y gastos por periodo
- TimeAndExpensesBillingPerWeek: Facturación de horas y gastos por semana
- TimeAndExpensesDetails: Detalles de horas y gastos
- TimeAndExpensesMulticurrency: Horas y gastos (multidivisa)
- TimeAndExpensesTotals: Totales de horas y gastos
- TimeAndExpensesTotalsPerPeriod: Totales de horas y gastos por periodo
- TimeAndExpensesTotalsPerWeek: Totales de facturación de tiempo y gastos por semana
- TimeAndQuantitiesTransactionTypes: Tipos de transacción de horas y cantidades
- TimeProjectRates: Tarifas de proyecto de horas
- TransactionList: Lista de transacciones
- TransactionSummary: Resumen de transacciones
- TransactionsToBeMatched: Transacciones pendientes de conciliar
- Traducciones: Traducciones
- Usuarios: Usuarios
- VATCodes: Códigos de IVA
- VATGroupCountries: Países del grupo de IVA
- VATGroups: Grupos de IVA
- VATNumberOfRelations: Número de IVA de relaciones
- VatReturnAsXbrlByDocumentId: Declaración de IVA en XBRL por ID de documento
- VatReturnAsXmlByDocumentId: Declaración de IVA en XML por ID de documento
- VatReturnPaymentReferenceByDocumentId: Referencia de pago de la declaración de IVA por ID de documento
- VatReturnStatus: Estados de la declaración de IVA
- VatTypes: Tipos de IVA
- WordTemplates: Plantillas de Word
Twinfield.Views
- ActivityDimensionValues: Valores de dimensión de actividad
- ArticleLines: Líneas de artículo
- ArticleSettings: Configuración de artículos
- BalanceSheetDimensionValues: Valores de dimensión del balance de situación
- CostCenterBudgets: Presupuestos de centros de coste
- CostCenterDimensionValues: Valores de dimensión de centro de coste
- CreditorDimensionValues: Valores de dimensión de acreedores
- DebtorDimensionValues: Valores de dimensión de deudores
- FinancialYears: Ejercicios financieros
- FixedAssetDimensionValues: Valores de dimensión de activos fijos
- GeneralLedgerAccountMappingAccounts: Cuentas de asignación del libro mayor
- GeneralLedgerAccountMappings: Asignaciones de cuentas del libro mayor
- IctReturnsAsXbrl: Declaraciones TIC en XBRL
- IctReturnsAsXml: Declaraciones TIC en XML
- OfficeSettings: Configuración de la empresa
- PaymentTypeSettings: Configuración de tipos de pago
- Periods: Periodos financieros
- PeriodsWithTransactions: Periodos con transacciones
- ProfitAndLossBudgets: Presupuestos de pérdidas y ganancias
- ProfitAndLossDimensionValues: Valores de dimensión de pérdidas y ganancias
- ProjectBudgets: Presupuestos de proyecto
- ProjectDimensionValues: Valores de dimensión de proyecto
- ProjectRateChanges: Cambios de tarifa de proyecto
- ProjectRateSettings: Configuración de tarifas de proyecto
- SubItems: Subartículos
- TaxGroupVatReturnPaymentReferences: Referencias de pago de IVA por grupo fiscal
- TaxGroupVatReturnsAsXbrl: Declaraciones de IVA por grupo fiscal en XBRL
- TaxGroupVatReturnsAsXml: Declaraciones de IVA de grupo fiscal en XML
- UserSettings: Configuración de usuario
- VatCodePercentages: Porcentajes de códigos de IVA
- VatCodeSettings: Ajustes de código de IVA
- VatReturnPaymentReferences: Referencias de pago de la declaración de IVA
- VatReturnsAsXbrl: Declaraciones de IVA en XBRL
- VatReturnsAsXml: Declaraciones de IVA como XML
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: