invantive documentation
Forum di supporto InvantiveAccedi / Registrati

TransactionLinesBulk: Exact Online Transaction Lines (Bulk)

read only per partition webhook REST

  • Catalogo: ExactOnlineREST
  • Schema: FinancialTransaction
  • Chiavi primarie: ID
  • Label: Transaction Lines (Bulk)

I dati in questa tabella sono partizionati per valore della colonna Division.

È possibile solo recuperare i dati.

Le modifiche vengono inviate tramite il topic del webhook FinancialTransactions su EntryID.

Codice sorgente dell'API

  • Punto finale: /api/v1/{division}/bulk/financial/TransactionLines
  • Metadati: /api/v1/{division}/bulk/financial/$metadata

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 5
Righe di scansione completa al minuto 20,000
Numero di righe di Query al minuto 300
Scrittura di righe al minuto 300

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella TransactionLinesBulk. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
Account guid Account filters on the platform, writable Reference to account.
AccountCode varchar2(18) Codice conto writable Code of the Account.
AccountName varchar2(50) Nome dell'account writable Name of account.
AmountDC double Valuta della divisione degli importi writable Amount in the default currency of the company.
AmountFC double Importo in valuta estera writable Amount in the currency of the transaction.
AmountVATBaseFC double Importo Base IVA Valuta estera writable Vat base amount in the currency of the transaction.
AmountVATFC double Importo IVA in valuta estera writable Vat amount in the currency of the transaction.
Asset guid Asset writable Reference to asset.
AssetCode varchar2(30) Codice bene writable Code of Asset.
AssetDescription varchar2(60) Descrizione della risorsa writable Description of Asset.
CostCenter varchar2(8) Centro di costo filters on the platform, writable Reference to cost center.
CostCenterDescription varchar2(60) Descrizione del centro di costo writable Description of CostCenter.
CostUnit varchar2(8) Unità del costo filters on the platform, writable Reference to cost unit.
CostUnitDescription varchar2(60) Unità del costo Descrizione writable Description of CostUnit.
Created datetime Created writable Creation date.
CreatedUtc datetime Creato writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Nome completo del creatore writable Name of creator.
Currency varchar2(30) Currency writable Currency.
CustomField varchar2 Campo personalizzato writable
Date datetime Date filters on the platform, writable Date.
Description varchar2(60) Description writable Description.
DisplayDocumentsUrl varchar2 Visualizza documenti (URL) writable URL to display documents attached to this transaction using Get My Report.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Numero di iscrizione alla Camera di Commercio della Divisione writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Codice IBAN della divisione writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisione - Nome dell'azienda writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Numero di divisione RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Partita IVA della divisione writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Codice fiscale salariale della divisione writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Etichetta della divisione writable Label of the Exact Online division.
DivisionName varchar2(50) Nome dell'amministrazione writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Nome del titolare dell'abbonamento writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Numero di abbonato writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Nome abbreviato della divisione writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable Reference to document.
DocumentNumber int32 Numero del documento writable Number of the document.
DocumentSubject varchar2(256) Oggetto del documento writable Subject of the document.
DueDate datetime Scadenza writable Date that payment should be done.
EntryID guid ID di ingresso filters on the platform, writable The transaction lines that make up a financial entry share the same EntryID.
EntryNumber int32 Numero di ingresso filters on the platform, writable Entry number of the header.
ExchangeRate double Tasso di cambio writable Exchange rate.
ExternalLinkDescription varchar2 Descrizione del link esterno
ExternalLinkReference varchar2 Riferimento al link esterno
ExtraDutyAmountFC double Importo supplementare in Valuta estera writable Extra duty amount.
ExtraDutyPercentage double Maggiorazione (%) writable Extra duty percentage.
FinancialPeriod int16 Periodo finanziario filters on the platform, writable Financial period.
FinancialYear int16 Esercizio finanziario filters on the platform, writable Financial year.
GLAccount guid Conto di contabilità generale filters on the platform, writable General ledger account.
GLAccountBalanceSide varchar2(1) Lato “Saldo conto GL” writable Balance side of transactions on this GL account.
GLAccountBalanceType varchar2(1) Tipo di saldo del conto GL writable Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss.
GLAccountCode varchar2(30) Codice conto GL writable Code of the G/L account.
GLAccountDescription varchar2(60) Descrizione del conto GL writable Description of the G/L account.
GLAccountRevalueCurrency char GL: Rivalutazione conto in Valuta writable Whether to revalue amounts posted on this GL account.
GLAccountSearchCode varchar2(9) Codice di ricerca conto GL writable User-friendly search code for the GL account.
GLAccountType int32 Tipo di conto GL writable Type of GL account.See view GLAccountTypes.
GLAccountTypeDescription varchar2 Tipo di conto GL - Descrizione writable Description of the GL account type.
GLAccountUseCostCenter char Usare il centro costi writable Indicator whether to use cost centers for transaction lines on the GL account.
GLAccountUseCostUnit char Usa unità di costo writable Indicator whether to use cost units for transaction lines on the GL account.
GLAccountVatCode varchar2(3) Codice IVA del conto di contabilità generale writable Associated VAT code of the GL account.
ID guid ID filters on the platform, writable Primary key.
InvoiceNumber int32 Numero della fattura filters on the platform, writable Invoice number.
Item guid Item writable Reference to item.
ItemCode varchar2(30) Codice articolo writable Code of Item.
ItemDescription varchar2(255) Descrizione dell'articolo writable Description of Item.
JournalCode varchar2(20) Codice del giornale filters on the platform, writable The journal code.
JournalDescription varchar2(60) Descrizione del diario writable The journal description.
LineNumber int32 Numero della linea writable Line number.
LineType int16 Tipo di linea writable Line type.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificato (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
ModifierFullName varchar2(240) Nome completo modificato writable Name of modifier.
Notes varchar2 Notes writable Extra remarks.
OffsetID guid ID conto contabile GL con offset writable OffsetID.
OrderNumber int32 Numero dell'ordine filters on the platform, writable Order number.
PaymentDiscountAmount double Importo dello sconto sul pagamento writable Discount amount when paid in time.
PaymentReference varchar2(60) Riferimento di pagamento writable Payment reference.
Project guid Project filters on the platform, writable Reference to project.
ProjectCode varchar2(20) Codice del progetto writable Code of Project.
ProjectDescription varchar2(60) Descrizione del progetto writable Description of Project.
ProjectWBS guid Struttura di suddivisione del lavoro (WBS) del progetto writable Project WBS ID.
ProjectWBSDescription varchar2 Descrizione della struttura di suddivisione del lavoro (WBS) del progetto writable Project WBS description.
Quantity double Quantity writable Quantity.
SerialNumber varchar2(30) Numero di serie writable Serial number of item.
ShopOrder guid Ordine del negozio Reference to shop order.
Status int16 Status filters on the platform, writable 20 = Open, 50 = Processed.
Subscription guid Subscription writable Reference to subscription line.
SubscriptionDescription varchar2(60) Descrizione dell'abbonamento writable Description of subscription line.
TrackingNumber varchar2(100) Numero di tracciamento writable Tracking number of item.
TrackingNumberDescription varchar2(240) Descrizione del numero di tracciamento writable Tracking number description.
Type int32 Type filters on the platform, writable The transaction type.Possible values: see TransactionLineTypes.
VATCode varchar2(3) Codice IVA filters on the platform, writable VAT code.
VATCodeDescription varchar2(60) Descrizione del codice IVA writable Description of VAT code.
VATPercentage double Percentuale IVA writable Vat percentage.
VATType varchar2(1) Tipo di IVA filters on the platform, writable VAT type.
YourRef varchar2(60) Il tuo Riferimento filters on the platform, writable Your reference (of customer).

Chiavi

Key Column Si riferisce a Kind Description
TransactionLinesBulk_Account_Accounts_fk Account Accounts.ID Key
TransactionLinesBulk_Asset_Assets_fk Asset Assets.ID Key
TransactionLinesBulk_CostCenter_Costcenters_fk CostCenter Costcenters.Code Key
TransactionLinesBulk_CostUnit_Costunits_fk CostUnit Costunits.Code Key
TransactionLinesBulk_Creator_Users_fk Creator Users.UserID Key
TransactionLinesBulk_Currency_Currencies_fk Currency Currencies.Code Key
TransactionLinesBulk_Document_Documents_fk Document Documents.ID Key
TransactionLinesBulk_GLAccount_GLAccounts_fk GLAccount GLAccounts.ID Key
TransactionLinesBulk_Item_Items_fk Item Items.ID Key
TransactionLinesBulk_JournalCode_Journals_fk JournalCode Journals.Code Key
TransactionLinesBulk_Modifier_Users_fk Modifier Users.UserID Key
TransactionLinesBulk_ProjectWBS_ProjectWBS_fk ProjectWBS ProjectWBS.ID Key
TransactionLinesBulk_Project_Projects_fk Project Projects.ID Key
TransactionLinesBulk_ShopOrder_ShopOrders_fk ShopOrder ShopOrders.ID Key
TransactionLinesBulk_Subscription_Subscriptions_fk Subscription Subscriptions.EntryID Key
TransactionLinesBulk_VATCode_VATCodes_fk VATCode VATCodes.Code Key

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: