Twinfield-Datenmodell
Twinfield ist eine Online-Buchhaltungssoftware, die in den Niederlanden und Belgien verwendet wird. Buchhaltungsfachleute bilden einen großen Teil der Twinfield-Anwenderschaft.
Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/twinfield
Die Daten sind pro Firma (COMPANY_CODE) partitioniert.
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
- Mit einer Query können mehrere Unternehmen gleichzeitig abgerufen werden.
- Invantive Cloud-Pläne: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Sprache ihrer Benutzergemeinschaft: Niederländisch.
Angaben
| Figure | Count |
|---|---|
| Tables | 251 |
| Columns | 14,640 |
| Tabellen mit Einfügung | 1 |
| Tabellen mit Aktualisierung | 0 |
| Tabellen mit Löschfunktion | 0 |
| Tabellen dokumentiert | 93 |
Poster zum Daten Muster
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
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 (ohne Beziehungen)
CodeValues (ohne Beziehungen)
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 (ohne Beziehungen)
Twinfield (ohne Beziehungen)
Cheques, DocketInvoices, PlatformVersion, TableColumnSpecifications
Views (ohne Beziehungen)
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
Beziehungen
- Activities → Offices (Schlüssel)
- ActivityChildValidations → Activities (Schlüssel)
- ActivityChildValidations → Offices (Schlüssel)
- ActivityProjectQuantities → Activities (Schlüssel)
- ActivityProjectQuantities → Offices (Schlüssel)
- Assets → Offices (Schlüssel)
- BalancesheetBanks → Offices (Schlüssel)
- BalancesheetChildValidations → Offices (Schlüssel)
- BalancesheetGroups → Offices (Schlüssel)
- Balancesheets → Offices (Schlüssel)
- CostCenters → Offices (Schlüssel)
- CustomerAddresses → Customers (Schlüssel)
- CustomerAddresses → Offices (Schlüssel)
- CustomerBanks → Customers (Schlüssel)
- CustomerBanks → Offices (Schlüssel)
- CustomerChildValidations → Customers (Schlüssel)
- CustomerChildValidations → Offices (Schlüssel)
- CustomerPaymentConditions → Customers (Schlüssel)
- CustomerPaymentConditions → Offices (Schlüssel)
- Customers → Offices (Schlüssel)
- Customers → VATCodes (Schlüssel)
- ProfitAndLoss → Offices (Schlüssel)
- ProfitAndLossBanks → Offices (Schlüssel)
- ProfitAndLossChildValidations → Offices (Schlüssel)
- ProfitAndLossGroups → Offices (Schlüssel)
- ProjectChildValidations → Projects (Schlüssel)
- ProjectChildValidations → Offices (Schlüssel)
- ProjectQuantities → Projects (Schlüssel)
- ProjectQuantities → Offices (Schlüssel)
- Projects → Offices (Schlüssel)
- SupplierAddresses → Suppliers (Schlüssel)
- SupplierAddresses → Offices (Schlüssel)
- SupplierBanks → Suppliers (Schlüssel)
- SupplierBanks → Offices (Schlüssel)
- SupplierChildValidations → Suppliers (Schlüssel)
- SupplierChildValidations → Offices (Schlüssel)
- SupplierPaymentConditions → Suppliers (Schlüssel)
- SupplierPaymentConditions → Offices (Schlüssel)
- Suppliers → Offices (Schlüssel)
- Suppliers → VATCodes (Schlüssel)
- AnnualReportTotals → Offices (Schlüssel)
- AnnualReportTotalsMulticurrency → Offices (Schlüssel)
- AnnualReportYtd → Offices (Schlüssel)
- AssetMethods → Offices (Schlüssel)
- AssetTransactions → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- AssetTransactions → Offices (Schlüssel)
- AssetTransactions → VATCodes (Schlüssel)
- BankLinkDetails → Offices (Schlüssel)
- BankLinkDetailsV2 → Offices (Schlüssel)
- BankTransactions → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- BankTransactions → Currencies (Schlüssel)
- BankTransactions → Offices (Schlüssel)
- BankTransactions → VATCodes (Schlüssel)
- BillingSchedules → Offices (Schlüssel)
- Budgets → Offices (Schlüssel)
- CashTransactions → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- CashTransactions → Currencies (Schlüssel)
- CashTransactions → Offices (Schlüssel)
- CashTransactions → VATCodes (Schlüssel)
- CashbooksAndBanks → Offices (Schlüssel)
- Certificates → Offices (Schlüssel)
- CommercialAnnualReportTotals → Offices (Schlüssel)
- CommercialAnnualReportTotalsMulticurrency → Offices (Schlüssel)
- CommercialAnnualReportYtd → Offices (Schlüssel)
- CostCenters → Offices (Schlüssel)
- CreditManagement → Offices (Schlüssel)
- CreditManagementActionCodes → Offices (Schlüssel)
- Currencies → Offices (Schlüssel)
- CustomerTransactions → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- CustomerTransactions → Offices (Schlüssel)
- CustomerTransactions → VATCodes (Schlüssel)
- Customers → Offices (Schlüssel)
- CustomersV2 → Offices (Schlüssel)
- CustomersV3 → Offices (Schlüssel)
- Declarations → Offices (Schlüssel)
- DistributionByPeriods → Offices (Schlüssel)
- EconomicAnnualReportTotals → Offices (Schlüssel)
- EconomicAnnualReportTotalsMulticurrency → Offices (Schlüssel)
- EconomicAnnualReportYtd → Offices (Schlüssel)
- FilterMappings → Offices (Schlüssel)
- FinancialDimensions → Offices (Schlüssel)
- FiscalAnnualReportTotals → Offices (Schlüssel)
- FiscalAnnualReportTotalsMulticurrency → Offices (Schlüssel)
- FiscalAnnualReportYtd → Offices (Schlüssel)
- FixedAssets → Offices (Schlüssel)
- Gateways → Offices (Schlüssel)
- GeneralLedgerDetails → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- GeneralLedgerDetails → Offices (Schlüssel)
- GeneralLedgerDetails → VATCodes (Schlüssel)
- GeneralLedgerDetailsV2 → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- GeneralLedgerDetailsV2 → Offices (Schlüssel)
- GeneralLedgerDetailsV2 → VATCodes (Schlüssel)
- GeneralLedgerDetailsV3 → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- GeneralLedgerDetailsV3 → Offices (Schlüssel)
- GeneralLedgerDetailsV3 → VATCodes (Schlüssel)
- GeneralLedgerIntercompany → Offices (Schlüssel)
- GeneralLedgerIntercompanyV2 → Offices (Schlüssel)
- GeneralLedgerTransactions → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- GeneralLedgerTransactions → Offices (Schlüssel)
- GeneralLedgerTransactions → VATCodes (Schlüssel)
- HierarchyAccess → Offices (Schlüssel)
- IctCountries → Offices (Schlüssel)
- MatchingTypes → Offices (Schlüssel)
- OfficeGroups → Offices (Schlüssel)
- OfficesForInterCompanyTransactions → Offices (Schlüssel)
- PayinginSlips → Offices (Schlüssel)
- PaymentFiles → Offices (Schlüssel)
- Periods → Offices (Schlüssel)
- ProjectDimensions → Offices (Schlüssel)
- ProjectTransactions → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- ProjectTransactions → Offices (Schlüssel)
- ProjectTransactions → VATCodes (Schlüssel)
- ReminderScenarios → Offices (Schlüssel)
- Reports → Offices (Schlüssel)
- Roles → Offices (Schlüssel)
- SupplierTransactions → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- SupplierTransactions → Offices (Schlüssel)
- SupplierTransactions → VATCodes (Schlüssel)
- Suppliers → Offices (Schlüssel)
- SuppliersV2 → Offices (Schlüssel)
- TaxGroups → Offices (Schlüssel)
- TimeAndExpensesBillingDetails → Offices (Schlüssel)
- TimeAndExpensesBillingPerPeriod → Offices (Schlüssel)
- TimeAndExpensesBillingPerWeek → Offices (Schlüssel)
- TimeAndExpensesDetails → Offices (Schlüssel)
- TimeAndExpensesMulticurrency → Offices (Schlüssel)
- TimeAndExpensesTotals → Offices (Schlüssel)
- TimeAndExpensesTotalsPerPeriod → Offices (Schlüssel)
- TimeAndExpensesTotalsPerWeek → Offices (Schlüssel)
- TimeAndQuantitiesTransactionTypes → Offices (Schlüssel)
- TransactionList → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- TransactionList → Offices (Schlüssel)
- TransactionList → VATCodes (Schlüssel)
- TransactionSummary → Offices (Schlüssel)
- TransactionsToBeMatched → Balancesheets (in Worten beschrieben): 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 (in Worten beschrieben): 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 (Schlüssel)
- TransactionsToBeMatched → Offices (Schlüssel)
- TransactionsToBeMatched → VATCodes (Schlüssel)
- Translations → Offices (Schlüssel)
- VATCodes → Offices (Schlüssel)
- VATGroupCountries → Offices (Schlüssel)
- VATGroups → Offices (Schlüssel)
- VATNumberOfRelations → Offices (Schlüssel)
- VatReturnStatus → Offices (Schlüssel)
- VatTypes → Offices (Schlüssel)
- WordTemplates → Offices (Schlüssel)
Tabellen
Twinfield.ActiveAnalysis
- ActiveAnalyses: Active Analyses
Twinfield.CodeValues
- AccessTypes: Domäne AccessTypes
- AddressTypes: Domäne AddressTypes
- ArticleTypes: Domäne ArticleTypes
- AssetCalculationMethods: Domäne AssetCalculationMethods
- AssetStatuses: Domäne AssetStatuses
- BankTransactionTypeFilters: Domäne BankTransactionTypeFilters
- BrowseCodes: Domäne BrowseCodes
- BrowseOperators: Domäne BrowseOperators
- BrowseSortOrders: Domäne BrowseSortOrders
- CollectionSchemas: Domäne CollectionSchemas
- Cultures: Domain Cultures
- DebitCredits: Domäne DebitCredits
- DepreciationStartMoments: Domäne DepreciationStartMoments
- DimensionBehaviours: Domäne DimensionBehaviours
- DimensionLevels: Domäne DimensionLevels
- DimensionStatuses: Domäne DimensionStatuses
- DimensionTypeCodes: Domäne DimensionTypeCodes
- FinderSearchFields: Domäne FinderSearchFields
- FinderTypeCodes: Domäne FinderTypeCodes
- FreeTextTypes: Domäne FreeTextTypes
- InvitationStatuses: Domäne InvitationStatuses
- ItemValueVatInclusions: Domäne ItemValueVatInclusions
- MatchStatuses: Domäne MatchStatuses
- MatchTypes: Domäne MatchTypes
- MatchingTypeCodes: Domäne MatchingTypeCodes
- MeansOfPayment: Domäne MeansOfPayment
- PayAddresses: Domäne PayAddresses
- PerformanceTypes: Domäne PerformanceTypes
- RateTypes: Domäne RateTypes
- SalesInvoicePaymentMethods: Domäne SalesInvoicePaymentMethods
- SalesInvoiceStatuses: Domäne SalesInvoiceStatuses
- SendReminders: Domäne SendReminders
- SendTypes: Domäne SendTypes
- SepaDirectDebitSchemes: Domäne SepaDirectDebitSchemes
- SingleSignOnSettings: Domäne SingleSignOnSettings
- SmsLogonServices: Domäne SmsLogonServices
- SubAnalyses: Domäne SubAnalyses
- SubscriptionChangeReasons: Domäne SubscriptionChangeReasons
- SubstitutionLevels: Domäne SubstitutionLevels
- SubstitutionTypes: Domäne SubstitutionTypes
- TemplateCompanyAccesses: Domäne TemplateCompanyAccesses
- TimeEntryTypes: Domäne TimeEntryTypes
- TimeTransactionCodes: Domäne TimeTransactionCodes
- TransactionLineTypes: Domäne TransactionLineTypes
- TransactionStatuses: Domäne TransactionStatuses
- UserTypes: Domäne UserTypes
- VatCodeLineTypes: Domäne VatCodeLineTypes
- VatCodeTypes: Domäne VatCodeTypes
- WaysOfPayment: Domäne WaysOfPayment
- WordTemplateKinds: Domäne WordTemplateKinds
Twinfield.Deleted
- DeletedTransactions: Deleted Transactions
Twinfield.Dimensions
- Activities: Aktivitäten
- ActivityChildValidations: Activity Child Validations
- ActivityProjectQuantities: Activity Project Quantities
- Assets: Anlagen
- BalancesheetBanks: Balance Sheet Bank
- BalancesheetChildValidations: Validierungen untergeordneter Bilanzpositionen
- BalancesheetGroups: Bilanzgruppen
- Bilanzen: Bilanzen
- CostCenters: Kostenstellen
- CustomerAddresses: Kundenadressen
- CustomerBanks: Kundenbanken
- CustomerChildValidations: Kunden-Untergeordnete Validierungen
- CustomerPaymentConditions: Kunden-Zahlungsbedingungen
- Customers: Kunden
- ProfitAndLoss: Profit and Loss
- ProfitAndLossBanks: Profit and Loss Banks
- ProfitAndLossChildValidations: Validierungen untergeordneter GuV-Positionen
- ProfitAndLossGroups: Gewinn- und Verlustgruppen
- ProjectChildValidations: Projekt-Untergeordnete Validierungen
- ProjectQuantities: Projektmengen
- Projects: Projekte
- SupplierAddresses: Lieferantenadressen
- SupplierBanks: Supplier Banks
- SupplierChildValidations: Validierungen untergeordneter Lieferanten
- SupplierPaymentConditions: Supplier Payment Conditions
- Suppliers: Lieferanten
Twinfield.Native
- NATIVEPLATFORMSCALARREQUESTS: Skalare Anfragen auf nativen Plattformen
Twinfield.Settings
- ArticleLinesByCode: Artikelzeilen nach Code
- ArticleSettingsByCode: Item Settings by Code
- OfficeSettingsByCode: Company Settings by Code
- PaymentTypeSettingsByCode: Zahlungsartei-Einstellungen nach Code
- ProjectRateChangesByCode: Project Rate Changes by Code
- ProjectRateSettingsByCode: Projektsatz-Einstellungen nach Code
- SalesInvoiceByNumber: Ausgangsrechnung nach Nummer
- SalesInvoiceLinesByNumber: Sales Invoice Lines by Number
- SalesInvoiceVatLinesByNumber: Verkaufsrechnungs-USt-Zeilen nach Nummer
- TransactionByNumber: Transaktion nach Nummer
- TransactionLinesByNumber: Transaktionszeilen nach Nummer
- UserSettingsByUserCode: User Settings by User Code
- VatCodePercentagesByCode: Umsatzsteuersatz-Prozentsätze nach Code
- VatCodeSettingsByCode: VAT Code Settings by Code
Twinfield.Twinfield
- AnnualReportTotals: Jahresabschluss-Summen
- AnnualReportTotalsMulticurrency: Jahresabschlusssummen (Mehrwährung)
- AnnualReportYtd: Jahresbericht YTD
- AssetMethods: Abschreibungsmethoden
- AssetTransactions: Anlagentransaktionen
- BankBookByCode: Bankbuch nach Code
- BankLinkDetails: Bankverbindungsdetails
- BankLinkDetailsV2: Bankverbindungsdetails (V2)
- BankStatementLinesByStatementDate: Kontoauszugspositionen nach Auszugsdatum
- BankStatementsByStatementDate: Bank Statements by Statement Date
- BankTransactions: Banktransaktionen
- BillingSchedules: Abrechnungspläne
- BudgetByCostCenter: Budget nach Kostenstelle
- BudgetByProfitAndLoss: Budget nach Gewinn & Verlust
- BudgetByProject: Budget by Project
- Budgets: Budgets
- CashBookByCode: Kassenbuch nach Code
- CashTransactions: Kassentransaktionen
- CashbooksAndBanks: Kassenbücher und Banken
- Zertifikate: Zertifikate
- Schecks: Schecks
- CommercialAnnualReportTotals: Summen Handelsjahresabschluss
- CommercialAnnualReportTotalsMulticurrency: Commercial Annual Report Totals Multi Currency
- CommercialAnnualReportYtd: Kommerzieller Jahresabschluss YTD
- CostCenters: Kostenstellen
- Countries: Länder
- CreditManagement: Kreditmanagement
- CreditManagementActionCodes: Aktionscodes Kreditmanagement
- Currencies: Währungen
- CustomerTransactions: Kundentransaktionen
- Customers: Kunden
- CustomersV2: Kunden (V2)
- CustomersV3: Kunden (V3)
- DaybooksTransactionTypes: Journaltransaktionstypen
- Declarations: USt-Erklärungen
- DeclarationsByRange: Umsatzsteuererklärungen nach Zeitraum
- DeclarationsByYear: Erklärungen nach Jahr
- DeclarationsByYearSinceModified: Erklärungen nach Jahr seit Änderung
- DeclarationsSinceModified: Erklärungen seit Änderung
- DimensionGroups: Dimensionsgruppen
- DimensionTypes: Dimensionstypen
- DimensionsModifiedSince: Dimensionen seit Änderung
- DistributionByPeriods: Verteilung nach Perioden
- DocketInvoices: Docket-Rechnungen
- EconomicAnnualReportTotals: Summen Wirtschaftlicher Jahresberichte
- EconomicAnnualReportTotalsMulticurrency: Wirtschaftliche Jahresabschlusssummen (Mehrwährung)
- EconomicAnnualReportYtd: Wirtschaftlicher Jahresbericht YTD
- FilterMappings: Filterzuordnungen
- FinancialDimensions: Finanzdimensionen
- FiscalAnnualReportTotals: Steuerliche Jahresabschlusssummen
- FiscalAnnualReportTotalsMulticurrency: Steuerliche Jahresabschlusssummen (Mehrwährung)
- FiscalAnnualReportYtd: Steuerlicher Jahresabschluss YTD
- FixedAssets: Anlagevermögen
- Gateways: Gateways
- GeneralLedgerAccountMappingAccountsByHierarchyCode: Hauptbuchkonten-Zuordnungskonten nach Hierarchiecode
- GeneralLedgerAccountMappingByHierarchyCode: Hauptbuch-Kontenzuordnung nach Hierarchiecode
- GeneralLedgerDetails: General Ledger Details
- GeneralLedgerDetailsV2: Hauptbuchdetails (V2)
- GeneralLedgerDetailsV3: Hauptbuch-Details (V3)
- GeneralLedgerIntercompany: Hauptbuch Intercompany
- GeneralLedgerIntercompanyV2: Hauptbuch Konzernverrechnung (V2)
- GeneralLedgerTransactions: Hauptbuchtransaktionen
- Hierarchien: Hierarchien
- HierarchyAccess: Hierarchie-Zugriffsrechte
- HierarchyNodes: Hierarchieknoten
- IctCountries: ICT-Länder
- IctReturnAsXbrlByDocumentId: ICT-Meldung als XBRL nach Dokument-ID
- IctReturnAsXmlByDocumentId: ICT-Meldung als XML nach Dokument-ID
- InvoiceTypes: Rechnungsarten
- Rechnungen: Rechnungen
- Items: Artikel
- MatchingTypes: Abgleichsarten
- NumberOfDeclarations: Number of Declarations
- OfficeGroups: Verwaltungsgruppen
- Büros: Verwaltungen
- OfficesForInterCompanyTransactions: Verwaltungen für konzerninterne Transaktionen
- PayAndCollectRunById: Pay and Collect Run by Identifier
- PayAndCollectRuns: Pay and Collect Runs
- PayinginSlips: Zahlungen in Bearbeitung
- PaymentFiles: Zahlungsdateiformate
- PaymentTypes: Zahlungsarten
- PeriodYears: Periodenjahre
- Perioden: Perioden
- PeriodsByYear: Periods by Year
- PlatformVersion: Plattformversion
- ProjectDimensions: Projektdimensionen
- ProjectTransactions: Projekttransaktionen
- ReminderScenarios: Mahnszenarien
- Reports: Reports
- Roles: Rollen
- SubItemsByArticle: Unterpositionen nach Artikel
- SupplierTransactions: Lieferantentransaktionen
- Suppliers: Lieferanten
- SuppliersV2: Suppliers (V2)
- TableColumnSpecifications: Table Column Specifications
- TaxGroupVatReturnAsXbrlByDocumentId: Tax Group VAT Return as XBRL by Document ID
- TaxGroupVatReturnAsXmlByDocumentId: Steuergruppen-USt-Erklärung als XML nach Beleg-ID
- TaxGroupVatReturnPaymentReferenceByDocumentId: Tax Group VAT Return Payment Reference by Document ID
- TaxGroups: Steuergruppen
- TimeAndExpensesBillingDetails: Abrechnungsdetails Zeiten und Spesen
- TimeAndExpensesBillingPerPeriod: Time and Expenses Billing per Period
- TimeAndExpensesBillingPerWeek: Time and Expenses Billing per Week
- TimeAndExpensesDetails: Time and Expenses Details
- TimeAndExpensesMulticurrency: Time and Expenses (Multi-currency)
- TimeAndExpensesTotals: Zeit- und Spesensummen
- TimeAndExpensesTotalsPerPeriod: Zeit- und Aufwandssummen pro Periode
- TimeAndExpensesTotalsPerWeek: Summen Zeiten und Spesen pro Woche
- TimeAndQuantitiesTransactionTypes: Zeit- und Mengentransaktionstypen
- TimeProjectRates: Time Project Rates
- TransactionList: Transaktionsliste
- TransactionSummary: Transactions Summary
- TransactionsToBeMatched: Abzustimmende Transaktionen
- Translations: Translations
- Users: Benutzer
- VATCodes: USt-Codes
- VATGroupCountries: USt-Gruppenländer
- VATGroups: VAT Groups
- VATNumberOfRelations: USt-Nummer der Beziehungen
- VatReturnAsXbrlByDocumentId: VAT Return as XBRL by Document ID
- VatReturnAsXmlByDocumentId: Umsatzsteuererklärung als XML nach Dokument-ID
- VatReturnPaymentReferenceByDocumentId: USt-Erklärung Zahlungsreferenz nach Beleg-ID
- VatReturnStatus: VAT Return Statuses
- VatTypes: Umsatzsteuerarten
- WordTemplates: Word-Vorlagen
Twinfield.Views
- ActivityDimensionValues: Aktivitätsdimensionswerte
- ArticleLines: Artikelzeilen
- ArticleSettings: Artikeleinstellungen
- BalanceSheetDimensionValues: Bilanz-Dimensionswerte
- CostCenterBudgets: Kostenstellenbudgets
- CostCenterDimensionValues: Kostenstellen-Dimensionswerte
- CreditorDimensionValues: Kreditor-Dimensionswerte
- DebtorDimensionValues: Debitorendimensionswerte
- FinancialYears: Geschäftsjahre
- FixedAssetDimensionValues: Anlagendimensionswerte
- GeneralLedgerAccountMappingAccounts: Hauptbuchkonten-Zuordnungskonten
- GeneralLedgerAccountMappings: Hauptbuch-Kontenzuordnungen
- IctReturnsAsXbrl: ICT Returns as XBRL
- IctReturnsAsXml: ICT-Meldungen als XML
- OfficeSettings: Unternehmenseinstellungen
- PaymentTypeSettings: Payment Type Settings
- Periods: Financial Periods
- PeriodsWithTransactions: Perioden mit Transaktionen
- ProfitAndLossBudgets: Profit and Loss Budgets
- ProfitAndLossDimensionValues: Profit&Loss-Dimensionswerte
- ProjectBudgets: Projektbudgets
- ProjectDimensionValues: Projekt-Dimensionswerte
- ProjectRateChanges: Projekt-Kursänderungen
- ProjectRateSettings: Projektsatz-Einstellungen
- SubItems: Unterpositionen
- TaxGroupVatReturnPaymentReferences: Steuergruppen-USt-Zahlungsreferenzen
- TaxGroupVatReturnsAsXbrl: Steuergruppen-USt-Erklärungen als XBRL
- TaxGroupVatReturnsAsXml: Steuergruppen-USt-Erklärungen als XML
- UserSettings: Benutzereinstellungen
- VatCodePercentages: USt-Code-Prozentsätze
- VatCodeSettings: USt-Code-Einstellungen
- VatReturnPaymentReferences: Zahlungsreferenzen Umsatzsteuererklärung
- VatReturnsAsXbrl: USt-Erklärungen als XBRL
- VatReturnsAsXml: VAT Returns as XML
Beispiel-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
Attribute
Die Eigenschaften dieser Plattform finden Sie auf der Seite Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: