invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

TransactionLines: Exact Online Transaction Lines

insert update delete per partition webhook REST

  • Catalogus: ExactOnlineREST
  • Schema: FinancialTransaction
  • Primaire sleutels: ID
  • Label: Transaction Lines

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

Wijzigingen worden binnengekomen via het webhook-onderwerp FinancialTransactions op EntryID.

API-bron

  • Eindpunt: /api/v1/{division}/financialtransaction/TransactionLines
  • Metagegevens: /api/v1/{division}/financialtransaction/$metadata

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 5
Aantal rijen per minuut bij volledige scan 7,200
Aantal rijen per minuut in een Query 300
Aantal rijen per minuut schrijven 300

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel TransactionLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
Account guid Account filters on the platform, writable Reference to account.
AccountCode varchar2(18) Account Code filters on the platform, writable Code of the Account.
AccountName varchar2(50) Accountnaam writable Name of account.
AmountDC double Bedrag Administratie Munteenheid writable Amount in the default currency of the company.
AmountFC double Bedrag Vreemde Valuta writable Amount in the currency of the transaction.
AmountVATBaseFC double BTW-bedrag Basis Vreemde Valuta writable Vat base amount in the currency of the transaction.
AmountVATFC double Bedrag BTW Buitenlandse Valuta writable Vat amount in the currency of the transaction.
Asset guid Asset filters on the platform, writable Reference to asset.
AssetCode varchar2(30) Activacode writable Code of Asset.
AssetDescription varchar2(60) Activa Omschrijving writable Description of Asset.
CostCenter varchar2(8) Kostenplaats filters on the platform, writable Reference to cost center.
CostCenterDescription varchar2(60) Kostenplaats Omschrijving writable Description of CostCenter.
CostUnit varchar2(8) Kostendrager filters on the platform, writable Reference to cost unit.
CostUnitDescription varchar2(60) Kostendrager Omschrijving writable Description of CostUnit.
Created datetime Created writable Creation date.
CreatedUtc datetime Aangemaakt (UTC) writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Aanmaker Volledige Naam writable Name of creator.
Currency varchar2(30) Currency filters on the platform, writable Currency.
CustomField varchar2 Aangepast Veld writable
Date datetime Date filters on the platform, writable Date.
Description varchar2(60) Description filters on the platform, writable Description.
DisplayDocumentsUrl varchar2 Weergave Documenten (URL) writable URL to display documents attached to this transaction using Get My Report.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Divisie Kamer van Koophandel Nummer writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Divisie IBAN Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisie Bedrijfsnaam writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Divisie RSIN Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Divisie BTW Nummer writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Divisie Loonbelastingnummer writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Divisie Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administratie Naam writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Naam Abonnementhouder writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnementhoudernummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Divisie Korte Naam writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable Reference to document.
DocumentNumber int32 Documentnummer writable Number of the document.
DocumentSubject varchar2(256) Document Onderwerp writable Subject of the document.
DueDate datetime Vervaldag writable Date that payment should be done.
EntryID guid Boeking ID filters on the platform, writable The transaction lines that make up a financial entry share the same EntryID.
EntryNumber int32 Boekingnummer filters on the platform, writable Entry number of the header.
ExchangeRate double Wisselkoers writable Exchange rate.
ExternalLinkDescription varchar2 Externe Link Omschrijving filters on the platform, writable
ExternalLinkReference varchar2 Externe Link Referentie filters on the platform, writable
ExtraDutyAmountFC double Extra Belasting Bedrag Vreemde Valuta writable Extra duty amount.
ExtraDutyPercentage double Extra Belasting (%) writable Extra duty percentage.
FinancialPeriod int16 Boekperiode filters on the platform, writable Financial period.
FinancialYear int16 Boekjaar filters on the platform, writable Financial year.
GLAccount guid Grootboekrekening filters on the platform, writable General ledger account.
GLAccountBalanceSide varchar2(1) Grootboekrekening Balanszijde writable Balance side of transactions on this GL account.
GLAccountBalanceType varchar2(1) Grootboekrekening Balanssoort writable Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss.
GLAccountCode varchar2(30) Grootboekrekening Code filters on the platform, writable Code of the G/L account.
GLAccountDescription varchar2(60) Grootboekrekening Omschrijving writable Description of the G/L account.
GLAccountRevalueCurrency char Grootboekrekening Herwaarderingsvaluta writable Whether to revalue amounts posted on this GL account.
GLAccountSearchCode varchar2(9) Grootboekrekening Zoekcode writable User-friendly search code for the GL account.
GLAccountType int32 Grootboekrekeningsoort writable Type of GL account.See view GLAccountTypes.
GLAccountTypeDescription varchar2 Grootboekrekeningsoortomschrijving writable Description of the GL account type.
GLAccountUseCostCenter char Gebruik Kostenplaats writable Indicator whether to use cost centers for transaction lines on the GL account.
GLAccountUseCostUnit char Gebruik Kostendrager writable Indicator whether to use cost units for transaction lines on the GL account.
GLAccountVatCode varchar2(3) BTW Code van Grootboekrekening writable Associated VAT code of the GL account.
ID guid ID filters on the platform, writable Primary key.
InvoiceNumber int32 Factuurnummer filters on the platform, writable Invoice number.
Item guid Item filters on the platform, writable Reference to item.
ItemCode varchar2(30) Artikelcode writable Code of Item.
ItemDescription varchar2(255) Artikelomschrijving writable Description of Item.
JournalCode varchar2(20) Dagboekcode filters on the platform, writable The journal code.
JournalDescription varchar2(60) Dagboekomschrijving writable The journal description.
LineNumber int32 Regelnummer writable Line number.
LineType int16 Regelsoort writable Line type.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Gewijzigd (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
ModifierFullName varchar2(240) Gewijzigd Volledige Naam writable Name of modifier.
Notes varchar2 Notes writable Extra remarks.
OffsetID guid Grootboektegenrekening ID filters on the platform, writable OffsetID.
OrderNumber int32 Ordernummer filters on the platform, writable Order number.
PaymentDiscountAmount double Betaalkortingsbedrag filters on the platform, writable Discount amount when paid in time.
PaymentReference varchar2(60) Betalingskenmerk writable Payment reference.
Project guid Project writable Reference to project.
ProjectCode varchar2(20) Projectcode filters on the platform, writable Code of Project.
ProjectDescription varchar2(60) Projectomschrijving writable Description of Project.
ProjectWBS guid Project WBS writable Project WBS ID.
ProjectWBSDescription varchar2 Project WBS Omschrijving writable Project WBS description.
Quantity double Quantity writable Quantity.
SerialNumber varchar2(30) Serienummer writable Serial number of item.
ShopOrder guid Productieorder filters on the platform, writable Reference to shop order.
Status int16 Status filters on the platform, writable 20 = Open, 50 = Processed.
Subscription guid Subscription filters on the platform, writable Reference to subscription line.
SubscriptionDescription varchar2(60) Abonnementsomschrijving writable Description of subscription line.
TrackingNumber varchar2(100) Tracking Nummer writable Tracking number of item.
TrackingNumberDescription varchar2(240) Tracking Nummer Omschrijving filters on the platform, writable Tracking number description.
Type int32 Type filters on the platform, writable The transaction type.Possible values: see TransactionLineTypes.
VATCode varchar2(3) BTW-code filters on the platform, writable VAT code.
VATCodeDescription varchar2(60) BTW Code Omschrijving writable Description of VAT code.
VATPercentage double BTW-percentage writable Vat percentage.
VATType varchar2(1) BTW Soort filters on the platform, writable VAT type.
YourRef varchar2(60) Uw Referentie filters on the platform, writable Your reference (of customer).

Toetsen

Key Column Verwijst naar Kind Description
TransactionLines_Account_Accounts_fk Account Accounts.ID Key
TransactionLines_Asset_Assets_fk Asset Assets.ID Key
TransactionLines_CostCenter_Costcenters_fk CostCenter Costcenters.Code Key
TransactionLines_CostUnit_Costunits_fk CostUnit Costunits.Code Key
TransactionLines_Creator_Users_fk Creator Users.UserID Key
TransactionLines_Currency_Currencies_fk Currency Currencies.Code Key
TransactionLines_Document_Documents_fk Document Documents.ID Key
TransactionLines_GLAccount_GLAccounts_fk GLAccount GLAccounts.ID Key
TransactionLines_Item_Items_fk Item Items.ID Key
TransactionLines_JournalCode_Journals_fk JournalCode Journals.Code Key
TransactionLines_Modifier_Users_fk Modifier Users.UserID Key
TransactionLines_ProjectWBS_ProjectWBS_fk ProjectWBS ProjectWBS.ID Key
TransactionLines_Project_Projects_fk Project Projects.ID Key
TransactionLines_ShopOrder_ShopOrders_fk ShopOrder ShopOrders.ID Key
TransactionLines_Subscription_Subscriptions_fk Subscription Subscriptions.EntryID Key
TransactionLines_VATCode_VATCodes_fk VATCode VATCodes.Code Key

Voorbeeldqueries

--
-- Financial transaction lines from all journals and selected companies. Note that LineNumber 0 reflects the header and 9999 the VAT.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-incremental-transactionlinesincremental.html
--
-- Related forum post: https://forums.invantive.eu/t/recommended-and-popular-exact-online-tables-for-2022/2340
--
select *
from   ExactOnlineREST.Incremental.TransactionLinesIncremental@eol
limit  100

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: