Modello dati Twinfield
Twinfield è un pacchetto di contabilità online utilizzato nei Paesi Bassi e in Belgio. I professionisti contabili costituiscono una larga parte della comunità di utenti di Twinfield.
Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/twinfield
I dati sono suddivisi per società (COMPANY_CODE).
I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.
Piattaforma
- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria API.
- I dati sono suddivisi, ad esempio per azienda o per amministrazione.
- Una query può leggere i dati di più aziende contemporaneamente.
- Piani Invantive Cloud: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Lingua della sua comunità di utenti: olandese.
Figure
| Figure | Count |
|---|---|
| Tables | 251 |
| Columns | 14,640 |
| Tabella con inserti | 1 |
| Tabella con aggiornamento | 0 |
| Tabella con la clausola DELETE | 0 |
| Tabella documentata | 93 |
Poster sul modello di dati
Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.
Il poster come testo: tabelle per argomento e le loro relazioni
Twinfield · Offices
AnnualReportTotals, AnnualReportTotalsMulticurrency, AnnualReportYtd, AssetMethods, AssetTransactions, BankLinkDetails, BankLinkDetailsV2, BillingSchedules, Budgets, Certificates, CommercialAnnualReportTotals, CommercialAnnualReportTotalsMulticurrency, CommercialAnnualReportYtd, CostCenters, CreditManagement, CreditManagementActionCodes, Currencies, CustomerTransactions, Customers, CustomersV2, CustomersV3, Declarations, DistributionByPeriods, EconomicAnnualReportTotals, EconomicAnnualReportTotalsMulticurrency, EconomicAnnualReportYtd, FilterMappings, FinancialDimensions, FiscalAnnualReportTotals, FiscalAnnualReportTotalsMulticurrency, FiscalAnnualReportYtd, FixedAssets, Gateways, GeneralLedgerDetails, GeneralLedgerDetailsV2, GeneralLedgerDetailsV3, GeneralLedgerIntercompany, GeneralLedgerIntercompanyV2, GeneralLedgerTransactions, HierarchyAccess, IctCountries, MatchingTypes, OfficeGroups, Offices, OfficesForInterCompanyTransactions, PayinginSlips, PaymentFiles, Periods, ProjectDimensions, ProjectTransactions, ReminderScenarios, Reports, Roles, SupplierTransactions, Suppliers, SuppliersV2, TaxGroups, TimeAndExpensesBillingDetails, TimeAndExpensesBillingPerPeriod, TimeAndExpensesBillingPerWeek, TimeAndExpensesDetails, TimeAndExpensesMulticurrency, TimeAndExpensesTotals, TimeAndExpensesTotalsPerPeriod, TimeAndExpensesTotalsPerWeek, TimeAndQuantitiesTransactionTypes, TransactionList, TransactionSummary, TransactionsToBeMatched, Translations, VATCodes, VATGroupCountries, VATGroups, VATNumberOfRelations, VatReturnStatus, VatTypes, WordTemplates
Twinfield
Assets, BalancesheetBanks, BalancesheetChildValidations, BalancesheetGroups, Balancesheets, CostCenters, ProfitAndLoss, ProfitAndLossBanks, ProfitAndLossChildValidations, ProfitAndLossGroups
Dimensions · Customers
CustomerAddresses, CustomerBanks, CustomerChildValidations, CustomerPaymentConditions, Customers
Dimensions · Suppliers
SupplierAddresses, SupplierBanks, SupplierChildValidations, SupplierPaymentConditions, Suppliers
Dimensions · Activities
Activities, ActivityChildValidations, ActivityProjectQuantities
Dimensions · Projects
ProjectChildValidations, ProjectQuantities, Projects
Twinfield · CashbooksAndBanks
BankTransactions, CashTransactions, CashbooksAndBanks
ActiveAnalysis (senza relazioni)
CodeValues (senza relazioni)
AccessTypes, AddressTypes, ArticleTypes, AssetCalculationMethods, AssetStatuses, BankTransactionTypeFilters, BrowseCodes, BrowseOperators, BrowseSortOrders, CollectionSchemas, Cultures, DebitCredits, DepreciationStartMoments, DimensionBehaviours, DimensionLevels, DimensionStatuses, DimensionTypeCodes, FinderSearchFields, FinderTypeCodes, FreeTextTypes, InvitationStatuses, ItemValueVatInclusions, MatchStatuses, MatchTypes, MatchingTypeCodes, MeansOfPayment, PayAddresses, PerformanceTypes, RateTypes, SalesInvoicePaymentMethods, SalesInvoiceStatuses, SendReminders, SendTypes, SepaDirectDebitSchemes, SingleSignOnSettings, SmsLogonServices, SubAnalyses, SubscriptionChangeReasons, SubstitutionLevels, SubstitutionTypes, TemplateCompanyAccesses, TimeEntryTypes, TimeTransactionCodes, TransactionLineTypes, TransactionStatuses, UserTypes, VatCodeLineTypes, VatCodeTypes, WaysOfPayment, WordTemplateKinds
Native (senza relazioni)
Twinfield (senza relazioni)
Cheques, DocketInvoices, PlatformVersion, TableColumnSpecifications
Visualizzazioni (senza relazioni)
ActivityDimensionValues, ArticleLines, ArticleSettings, BalanceSheetDimensionValues, CostCenterBudgets, CostCenterDimensionValues, CreditorDimensionValues, DebtorDimensionValues, FinancialYears, FixedAssetDimensionValues, GeneralLedgerAccountMappingAccounts, GeneralLedgerAccountMappings, IctReturnsAsXbrl, IctReturnsAsXml, OfficeSettings, PaymentTypeSettings, Periods, PeriodsWithTransactions, ProfitAndLossBudgets, ProfitAndLossDimensionValues, ProjectBudgets, ProjectDimensionValues, ProjectRateChanges, ProjectRateSettings, SubItems, TaxGroupVatReturnPaymentReferences, TaxGroupVatReturnsAsXbrl, TaxGroupVatReturnsAsXml, UserSettings, VatCodePercentages, VatCodeSettings, VatReturnPaymentReferences, VatReturnsAsXbrl, VatReturnsAsXml
Relazioni
- Activities → Offices (chiave)
- ActivityChildValidations → Activities (chiave)
- ActivityChildValidations → Offices (chiave)
- ActivityProjectQuantities → Activities (chiave)
- ActivityProjectQuantities → Offices (chiave)
- Assets → Offices (chiave)
- BalancesheetBanks → Offices (chiave)
- BalancesheetChildValidations → Offices (chiave)
- BalancesheetGroups → Offices (chiave)
- Balancesheets → Offices (chiave)
- CostCenters → Offices (chiave)
- CustomerAddresses → Customers (chiave)
- CustomerAddresses → Offices (chiave)
- CustomerBanks → Customers (chiave)
- CustomerBanks → Offices (chiave)
- CustomerChildValidations → Customers (chiave)
- CustomerChildValidations → Offices (chiave)
- CustomerPaymentConditions → Customers (chiave)
- CustomerPaymentConditions → Offices (chiave)
- Customers → Offices (chiave)
- Customers → VATCodes (chiave)
- ProfitAndLoss → Offices (chiave)
- ProfitAndLossBanks → Offices (chiave)
- ProfitAndLossChildValidations → Offices (chiave)
- ProfitAndLossGroups → Offices (chiave)
- ProjectChildValidations → Projects (chiave)
- ProjectChildValidations → Offices (chiave)
- ProjectQuantities → Projects (chiave)
- ProjectQuantities → Offices (chiave)
- Projects → Offices (chiave)
- SupplierAddresses → Suppliers (chiave)
- SupplierAddresses → Offices (chiave)
- SupplierBanks → Suppliers (chiave)
- SupplierBanks → Offices (chiave)
- SupplierChildValidations → Suppliers (chiave)
- SupplierChildValidations → Offices (chiave)
- SupplierPaymentConditions → Suppliers (chiave)
- SupplierPaymentConditions → Offices (chiave)
- Suppliers → Offices (chiave)
- Suppliers → VATCodes (chiave)
- AnnualReportTotals → Offices (chiave)
- AnnualReportTotalsMulticurrency → Offices (chiave)
- AnnualReportYtd → Offices (chiave)
- AssetMethods → Offices (chiave)
- AssetTransactions → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- AssetTransactions → Offices (chiave)
- AssetTransactions → VATCodes (chiave)
- BankLinkDetails → Offices (chiave)
- BankLinkDetailsV2 → Offices (chiave)
- BankTransactions → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- BankTransactions → Currencies (chiave)
- BankTransactions → Offices (chiave)
- BankTransactions → VATCodes (chiave)
- BillingSchedules → Offices (chiave)
- Budgets → Offices (chiave)
- CashTransactions → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- CashTransactions → Currencies (chiave)
- CashTransactions → Offices (chiave)
- CashTransactions → VATCodes (chiave)
- CashbooksAndBanks → Offices (chiave)
- Certificates → Offices (chiave)
- CommercialAnnualReportTotals → Offices (chiave)
- CommercialAnnualReportTotalsMulticurrency → Offices (chiave)
- CommercialAnnualReportYtd → Offices (chiave)
- CostCenters → Offices (chiave)
- CreditManagement → Offices (chiave)
- CreditManagementActionCodes → Offices (chiave)
- Currencies → Offices (chiave)
- CustomerTransactions → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- CustomerTransactions → Offices (chiave)
- CustomerTransactions → VATCodes (chiave)
- Customers → Offices (chiave)
- CustomersV2 → Offices (chiave)
- CustomersV3 → Offices (chiave)
- Declarations → Offices (chiave)
- DistributionByPeriods → Offices (chiave)
- EconomicAnnualReportTotals → Offices (chiave)
- EconomicAnnualReportTotalsMulticurrency → Offices (chiave)
- EconomicAnnualReportYtd → Offices (chiave)
- FilterMappings → Offices (chiave)
- FinancialDimensions → Offices (chiave)
- FiscalAnnualReportTotals → Offices (chiave)
- FiscalAnnualReportTotalsMulticurrency → Offices (chiave)
- FiscalAnnualReportYtd → Offices (chiave)
- FixedAssets → Offices (chiave)
- Gateways → Offices (chiave)
- GeneralLedgerDetails → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- GeneralLedgerDetails → Offices (chiave)
- GeneralLedgerDetails → VATCodes (chiave)
- GeneralLedgerDetailsV2 → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- GeneralLedgerDetailsV2 → Offices (chiave)
- GeneralLedgerDetailsV2 → VATCodes (chiave)
- GeneralLedgerDetailsV3 → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- GeneralLedgerDetailsV3 → Offices (chiave)
- GeneralLedgerDetailsV3 → VATCodes (chiave)
- GeneralLedgerIntercompany → Offices (chiave)
- GeneralLedgerIntercompanyV2 → Offices (chiave)
- GeneralLedgerTransactions → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- GeneralLedgerTransactions → Offices (chiave)
- GeneralLedgerTransactions → VATCodes (chiave)
- HierarchyAccess → Offices (chiave)
- IctCountries → Offices (chiave)
- MatchingTypes → Offices (chiave)
- OfficeGroups → Offices (chiave)
- OfficesForInterCompanyTransactions → Offices (chiave)
- PayinginSlips → Offices (chiave)
- PaymentFiles → Offices (chiave)
- Periods → Offices (chiave)
- ProjectDimensions → Offices (chiave)
- ProjectTransactions → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- ProjectTransactions → Offices (chiave)
- ProjectTransactions → VATCodes (chiave)
- ReminderScenarios → Offices (chiave)
- Reports → Offices (chiave)
- Roles → Offices (chiave)
- SupplierTransactions → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- SupplierTransactions → Offices (chiave)
- SupplierTransactions → VATCodes (chiave)
- Suppliers → Offices (chiave)
- SuppliersV2 → Offices (chiave)
- TaxGroups → Offices (chiave)
- TimeAndExpensesBillingDetails → Offices (chiave)
- TimeAndExpensesBillingPerPeriod → Offices (chiave)
- TimeAndExpensesBillingPerWeek → Offices (chiave)
- TimeAndExpensesDetails → Offices (chiave)
- TimeAndExpensesMulticurrency → Offices (chiave)
- TimeAndExpensesTotals → Offices (chiave)
- TimeAndExpensesTotalsPerPeriod → Offices (chiave)
- TimeAndExpensesTotalsPerWeek → Offices (chiave)
- TimeAndQuantitiesTransactionTypes → Offices (chiave)
- TransactionList → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- TransactionList → Offices (chiave)
- TransactionList → VATCodes (chiave)
- TransactionSummary → Offices (chiave)
- TransactionsToBeMatched → Balancesheets (descritto a parole): 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 (descritto a parole): 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 (chiave)
- TransactionsToBeMatched → Offices (chiave)
- TransactionsToBeMatched → VATCodes (chiave)
- Translations → Offices (chiave)
- VATCodes → Offices (chiave)
- VATGroupCountries → Offices (chiave)
- VATGroups → Offices (chiave)
- VATNumberOfRelations → Offices (chiave)
- VatReturnStatus → Offices (chiave)
- VatTypes → Offices (chiave)
- WordTemplates → Offices (chiave)
Tabelle
Twinfield.ActiveAnalysis
- ActiveAnalyses: Analisi attive
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: Culture del 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: Movimenti eliminati
Twinfield.Dimensions
- Activities: Attività
- ActivityChildValidations: Validazioni figlie attività
- ActivityProjectQuantities: Quantità progetto attività
- Assets: Cespiti
- BalancesheetBanks: Banca stato patrimoniale
- BalancesheetChildValidations: Validazioni figlie del bilancio
- BalancesheetGroups: Gruppi stato patrimoniale
- Balancesheets: Stati patrimoniali
- CostCenters: Centri di costo
- CustomerAddresses: Indirizzi clienti
- CustomerBanks: Banche clienti
- CustomerChildValidations: Validazioni figlie clienti
- CustomerPaymentConditions: Condizioni di pagamento clienti
- Customers: Clienti
- ProfitAndLoss: Conto economico
- ProfitAndLossBanks: Banche conto economico
- ProfitAndLossChildValidations: Validazioni figlio Profit and Loss
- ProfitAndLossGroups: Gruppi conto economico
- ProjectChildValidations: Validazioni progetti figli
- ProjectQuantities: Quantità Progetto
- Projects: Progetti
- SupplierAddresses: Indirizzi fornitori
- SupplierBanks: Banche fornitori
- SupplierChildValidations: Validazioni figlio fornitori
- SupplierPaymentConditions: Condizioni di pagamento fornitori
- Fornitori: Fornitori
Twinfield.Native
- NATIVEPLATFORMSCALARREQUESTS: Richieste scalari della piattaforma nativa
Twinfield.Settings
- ArticleLinesByCode: Righe articolo per codice
- ArticleSettingsByCode: Impostazioni articoli per codice
- OfficeSettingsByCode: Impostazioni azienda per codice
- PaymentTypeSettingsByCode: Impostazioni tipo di pagamento per codice
- ProjectRateChangesByCode: Variazioni tariffe progetto per codice
- ProjectRateSettingsByCode: Impostazioni tariffa progetto per codice
- SalesInvoiceByNumber: Fattura di vendita per numero
- SalesInvoiceLinesByNumber: Righe fattura di vendita per numero
- SalesInvoiceVatLinesByNumber: Righe IVA fattura di vendita per numero
- TransactionByNumber: Movimento per numero
- TransactionLinesByNumber: Righe movimento per numero
- UserSettingsByUserCode: Impostazioni utente per codice utente
- VatCodePercentagesByCode: Percentuali codice IVA per codice
- VatCodeSettingsByCode: Impostazioni codice IVA per codice
Twinfield.Twinfield
- AnnualReportTotals: Totali relazione annuale
- AnnualReportTotalsMulticurrency: Totali bilancio annuale (multivaluta)
- AnnualReportYtd: Bilancio annuale YTD
- AssetMethods: Metodi di ammortamento cespiti
- AssetTransactions: Transazioni di cespiti
- BankBookByCode: Libro banca per codice
- BankLinkDetails: Dettagli collegamento bancario
- BankLinkDetailsV2: Dettagli collegamento bancario (V2)
- BankStatementLinesByStatementDate: Righe estratto conto per data estratto
- BankStatementsByStatementDate: Estratti conto per data estratto
- BankTransactions: Transazioni bancarie
- BillingSchedules: Piani di fatturazione
- BudgetByCostCenter: Budget per centro di costo
- BudgetByProfitAndLoss: Budget per conto economico
- BudgetByProject: Budget per progetto
- Budgets: Budget
- CashBookByCode: Libro cassa per codice
- CashTransactions: Movimenti di cassa
- CashbooksAndBanks: Conti cassa e banche
- Certificati: Certificati
- Assegni: Assegni
- CommercialAnnualReportTotals: Totali bilancio annuale commerciale
- CommercialAnnualReportTotalsMulticurrency: Totali Relazione Annuale Commerciale Multi Valuta
- CommercialAnnualReportYtd: Relazione annuale commerciale da inizio anno
- CostCenters: Centri di costo
- Countries: Paesi
- CreditManagement: Gestione crediti
- CreditManagementActionCodes: Codici azione gestione crediti
- Currencies: Valute
- CustomerTransactions: Movimenti clienti
- Customers: Clienti
- CustomersV2: Clienti (V2)
- CustomersV3: Clienti (V3)
- DaybooksTransactionTypes: Tipi movimento prima nota
- Declarations: Dichiarazioni IVA
- DeclarationsByRange: Dichiarazioni IVA per intervallo
- DeclarationsByYear: Dichiarazioni per anno
- DeclarationsByYearSinceModified: Dichiarazioni per anno dall'ultima modifica
- DeclarationsSinceModified: Dichiarazioni dall'ultima modifica
- DimensionGroups: Gruppi di dimensioni
- DimensionTypes: Tipi di Dimensione
- DimensionsModifiedSince: Dimensioni modificate dal
- DistributionByPeriods: Distribuzione per Periodi
- DocketInvoices: Fatture di bolla
- EconomicAnnualReportTotals: Totali bilancio annuale economico
- EconomicAnnualReportTotalsMulticurrency: Totali bilancio annuale economico (multivaluta)
- EconomicAnnualReportYtd: Relazione Annuale Economica YTD
- FilterMappings: Mappature dei filtri
- FinancialDimensions: Dimensioni finanziarie
- FiscalAnnualReportTotals: Totali bilancio fiscale
- FiscalAnnualReportTotalsMulticurrency: Totali Relazione Annuale Fiscale (Multi Valuta)
- FiscalAnnualReportYtd: Bilancio fiscale YTD
- FixedAssets: Cespiti
- Gateways: Gateway
- GeneralLedgerAccountMappingAccountsByHierarchyCode: Conti di mappatura del piano dei conti per codice gerarchia
- GeneralLedgerAccountMappingByHierarchyCode: Mappatura conti contabili per codice gerarchia
- GeneralLedgerDetails: Dettagli del libro mastro generale
- GeneralLedgerDetailsV2: Dettagli libro mastro (V2)
- GeneralLedgerDetailsV3: Dettagli libro mastro (V3)
- GeneralLedgerIntercompany: Libro mastro intercompany
- GeneralLedgerIntercompanyV2: Libro mastro intercompany (V2)
- GeneralLedgerTransactions: Transazioni Libro Mastro Generale
- Gerarchie: Gerarchie
- HierarchyAccess: Privilegi di Accesso Gerarchia
- HierarchyNodes: Nodi di gerarchia
- IctCountries: Paesi ICT
- IctReturnAsXbrlByDocumentId: Dichiarazione ICT come XBRL per ID documento
- IctReturnAsXmlByDocumentId: Dichiarazione ICT come XML per ID documento
- InvoiceTypes: Tipi di fattura
- Fatture: Fatture
- Items: Articoli
- MatchingTypes: Tipi di abbinamento
- NumberOfDeclarations: Numero di dichiarazioni
- OfficeGroups: Gruppi Amministrazione
- Uffici: Amministrazioni
- OfficesForInterCompanyTransactions: Amministrazioni per transazioni intercompany
- PayAndCollectRunById: Esecuzione pagamenti e incassi per identificativo
- PayAndCollectRuns: Esecuzioni pagamenti e incassi
- PayinginSlips: Pagamenti in Lavorazione
- PaymentFiles: Formati File di Pagamento
- PaymentTypes: Tipi di pagamento
- PeriodYears: Anni del periodo
- Periods: Periodi
- PeriodsByYear: Periodi per anno
- PlatformVersion: Versione della piattaforma
- ProjectDimensions: Dimensioni progetto
- ProjectTransactions: Transazioni di progetto
- ReminderScenarios: Scenari di sollecito
- Report: Report
- Roles: Ruoli
- SubItemsByArticle: Sottovoci per articolo
- SupplierTransactions: Transazioni Fornitori
- Fornitori: Fornitori
- SuppliersV2: Fornitori (V2)
- TableColumnSpecifications: Specifiche delle colonne della tabella
- TaxGroupVatReturnAsXbrlByDocumentId: Dichiarazione IVA del gruppo fiscale come XBRL per ID documento
- TaxGroupVatReturnAsXmlByDocumentId: Dichiarazione IVA Gruppo Imposte come XML per ID Documento
- TaxGroupVatReturnPaymentReferenceByDocumentId: Riferimento di pagamento IVA del gruppo fiscale per ID documento
- TaxGroups: Gruppi Imposte
- TimeAndExpensesBillingDetails: Dettagli di fatturazione tempi e spese
- TimeAndExpensesBillingPerPeriod: Fatturazione Tempo e Spese per Periodo
- TimeAndExpensesBillingPerWeek: Fatturazione ore e spese per settimana
- TimeAndExpensesDetails: Dettagli Tempo e Spese
- TimeAndExpensesMulticurrency: Ore e spese (multivaluta)
- TimeAndExpensesTotals: Totali tempi e spese
- TimeAndExpensesTotalsPerPeriod: Totali Tempo e Spese per Periodo
- TimeAndExpensesTotalsPerWeek: Totali tempi e spese per settimana
- TimeAndQuantitiesTransactionTypes: Tipi di movimento tempi e quantità
- TimeProjectRates: Tariffe progetto tempi
- TransactionList: Elenco movimenti
- TransactionSummary: Riepilogo movimenti
- TransactionsToBeMatched: Transazioni da abbinare
- Translations: Traduzioni
- Utenti: Utenti
- VATCodes: Codici IVA
- VATGroupCountries: Paesi del gruppo IVA
- VATGroups: Gruppi IVA
- VATNumberOfRelations: Numero IVA delle relazioni
- VatReturnAsXbrlByDocumentId: Dichiarazione IVA in XBRL per ID documento
- VatReturnAsXmlByDocumentId: Dichiarazione IVA come XML per ID documento
- VatReturnPaymentReferenceByDocumentId: Riferimento pagamento dichiarazione IVA per ID documento
- VatReturnStatus: Stati delle dichiarazioni IVA
- VatTypes: Tipi IVA
- WordTemplates: Modelli Word
Twinfield.Views
- ActivityDimensionValues: Valori dimensione attività
- ArticleLines: Righe articolo
- ArticleSettings: Impostazioni articolo
- BalanceSheetDimensionValues: Valori Dimensione Stato Patrimoniale
- CostCenterBudgets: Budget centri di costo
- CostCenterDimensionValues: Valori dimensione centro di costo
- CreditorDimensionValues: Valori dimensione fornitori
- DebtorDimensionValues: Valori dimensione debitore
- FinancialYears: Esercizi finanziari
- FixedAssetDimensionValues: Valori dimensione cespiti
- GeneralLedgerAccountMappingAccounts: Conti di mappatura del piano dei conti
- GeneralLedgerAccountMappings: Mappature dei conti del libro mastro generale
- IctReturnsAsXbrl: Dichiarazioni ICT come XBRL
- IctReturnsAsXml: Dichiarazioni ICT come XML
- OfficeSettings: Impostazioni azienda
- PaymentTypeSettings: Impostazioni tipo di pagamento
- Periods: Periodi finanziari
- PeriodsWithTransactions: Periodi con Transazioni
- ProfitAndLossBudgets: Budget conto economico
- ProfitAndLossDimensionValues: Valori dimensione Profit&Loss
- ProjectBudgets: Budget di progetto
- ProjectDimensionValues: Valori Dimensione Progetto
- ProjectRateChanges: Variazioni Tariffe Progetto
- ProjectRateSettings: Impostazioni tariffe progetto
- SubItems: Sottovoci
- TaxGroupVatReturnPaymentReferences: Riferimenti di pagamento IVA del gruppo fiscale
- TaxGroupVatReturnsAsXbrl: Dichiarazioni IVA del gruppo fiscale come XBRL
- TaxGroupVatReturnsAsXml: Dichiarazioni IVA del gruppo fiscale come XML
- UserSettings: Impostazioni utente
- VatCodePercentages: Percentuali codici IVA
- VatCodeSettings: Impostazioni Codici IVA
- VatReturnPaymentReferences: Riferimenti di pagamento dichiarazione IVA
- VatReturnsAsXbrl: Dichiarazioni IVA come XBRL
- VatReturnsAsXml: Dichiarazioni IVA come XML
Esempi di Query
--
-- List Twinfield financial transaction details.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/twinfield-data-model/webhelp/twinfield-connector-twinfield-generalledgerdetailsv3.html
--
select *
from Twinfield.Twinfield.GeneralLedgerDetailsV3@tfd
limit 100
--
-- Mapping from Twinfield general ledger accounts to the hierarchies.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/twinfield-data-model/webhelp/twinfield-connector-twinfield-generalledgeraccountmappingaccountsbyhierarchycode.html
--
select *
from Twinfield.Views.GeneralLedgerAccountMappingAccounts@tfd
limit 100
Attributi
Le caratteristiche di questa piattaforma sono riportate nella pagina Attributes.
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: