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. | |
Account |
varchar2 |
Account Code | filters on the platform, writable | Code of the Account. | |
Account |
varchar2 |
Accountnaam | writable | Name of account. | |
Amount |
double |
Bedrag Administratie Munteenheid | writable | Amount in the default currency of the company. | |
Amount |
double |
Bedrag Vreemde Valuta | writable | Amount in the currency of the transaction. | |
Amount |
double |
BTW-bedrag Basis Vreemde Valuta | writable | Vat base amount in the currency of the transaction. | |
Amount |
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. | |
Asset |
varchar2 |
Activacode | writable | Code of Asset. | |
Asset |
varchar2 |
Activa Omschrijving | writable | Description of Asset. | |
Cost |
varchar2 |
Kostenplaats | filters on the platform, writable | Reference to cost center. | |
Cost |
varchar2 |
Kostenplaats Omschrijving | writable | Description of CostCenter. | |
Cost |
varchar2 |
Kostendrager | filters on the platform, writable | Reference to cost unit. | |
Cost |
varchar2 |
Kostendrager Omschrijving | writable | Description of CostUnit. | |
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Aanmaker Volledige Naam | writable | Name of creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency. | |
Custom |
varchar2 |
Aangepast Veld | writable | ||
Date |
datetime |
Date | filters on the platform, writable | Date. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
Display |
varchar2 |
Weergave Documenten (URL) | writable | URL to display documents attached to this transaction using Get My Report. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters on the platform, writable | Reference to document. | |
Document |
int32 |
Documentnummer | writable | Number of the document. | |
Document |
varchar2 |
Document Onderwerp | writable | Subject of the document. | |
Due |
datetime |
Vervaldag | writable | Date that payment should be done. | |
Entry |
guid |
Boeking ID | filters on the platform, writable | The transaction lines that make up a financial entry share the same EntryID. | |
Entry |
int32 |
Boekingnummer | filters on the platform, writable | Entry number of the header. | |
Exchange |
double |
Wisselkoers | writable | Exchange rate. | |
External |
varchar2 |
Externe Link Omschrijving | filters on the platform, writable | ||
External |
varchar2 |
Externe Link Referentie | filters on the platform, writable | ||
Extra |
double |
Extra Belasting Bedrag Vreemde Valuta | writable | Extra duty amount. | |
Extra |
double |
Extra Belasting (%) | writable | Extra duty percentage. | |
Financial |
int16 |
Boekperiode | filters on the platform, writable | Financial period. | |
Financial |
int16 |
Boekjaar | filters on the platform, writable | Financial year. | |
GL |
guid |
Grootboekrekening | filters on the platform, writable | General ledger account. | |
GL |
varchar2 |
Grootboekrekening Balanszijde | writable | Balance side of transactions on this GL account. | |
GL |
varchar2 |
Grootboekrekening Balanssoort | writable | Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss. | |
GL |
varchar2 |
Grootboekrekening Code | filters on the platform, writable | Code of the G/L account. | |
GL |
varchar2 |
Grootboekrekening Omschrijving | writable | Description of the G/L account. | |
GL |
char |
Grootboekrekening Herwaarderingsvaluta | writable | Whether to revalue amounts posted on this GL account. | |
GL |
varchar2 |
Grootboekrekening Zoekcode | writable | User-friendly search code for the GL account. | |
GL |
int32 |
Grootboekrekeningsoort | writable | Type of GL account.See view GLAccountTypes. | |
GL |
varchar2 |
Grootboekrekeningsoortomschrijving | writable | Description of the GL account type. | |
GL |
char |
Gebruik Kostenplaats | writable | Indicator whether to use cost centers for transaction lines on the GL account. | |
GL |
char |
Gebruik Kostendrager | writable | Indicator whether to use cost units for transaction lines on the GL account. | |
GL |
varchar2 |
BTW Code van Grootboekrekening | writable | Associated VAT code of the GL account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Invoice |
int32 |
Factuurnummer | filters on the platform, writable | Invoice number. | |
Item |
guid |
Item | filters on the platform, writable | Reference to item. | |
Item |
varchar2 |
Artikelcode | writable | Code of Item. | |
Item |
varchar2 |
Artikelomschrijving | writable | Description of Item. | |
Journal |
varchar2 |
Dagboekcode | filters on the platform, writable | The journal code. | |
Journal |
varchar2 |
Dagboekomschrijving | writable | The journal description. | |
Line |
int32 |
Regelnummer | writable | Line number. | |
Line |
int16 |
Regelsoort | writable | Line type. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Gewijzigd Volledige Naam | writable | Name of modifier. | |
Notes |
varchar2 |
Notes | writable | Extra remarks. | |
Offset |
guid |
Grootboektegenrekening ID | filters on the platform, writable | OffsetID. | |
Order |
int32 |
Ordernummer | filters on the platform, writable | Order number. | |
Payment |
double |
Betaalkortingsbedrag | filters on the platform, writable | Discount amount when paid in time. | |
Payment |
varchar2 |
Betalingskenmerk | writable | Payment reference. | |
Project |
guid |
Project | writable | Reference to project. | |
Project |
varchar2 |
Projectcode | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Projectomschrijving | writable | Description of Project. | |
Project |
guid |
Project WBS | writable | Project WBS ID. | |
Project |
varchar2 |
Project WBS Omschrijving | writable | Project WBS description. | |
Quantity |
double |
Quantity | writable | Quantity. | |
Serial |
varchar2 |
Serienummer | writable | Serial number of item. | |
Shop |
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. | |
Subscription |
varchar2 |
Abonnementsomschrijving | writable | Description of subscription line. | |
Tracking |
varchar2 |
Tracking Nummer | writable | Tracking number of item. | |
Tracking |
varchar2 |
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. | |
VAT |
varchar2 |
BTW-code | filters on the platform, writable | VAT code. | |
VAT |
varchar2 |
BTW Code Omschrijving | writable | Description of VAT code. | |
VAT |
double |
BTW-percentage | writable | Vat percentage. | |
VAT |
varchar2 |
BTW Soort | filters on the platform, writable | VAT type. | |
Your |
varchar2 |
Uw Referentie | filters on the platform, writable | Your reference (of customer). |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Transaction |
Account |
Accounts.ID |
Key | |
Transaction |
Asset |
Assets.ID |
Key | |
Transaction |
Cost |
Costcenters.Code |
Key | |
Transaction |
Cost |
Costunits.Code |
Key | |
Transaction |
Creator |
Users. |
Key | |
Transaction |
Currency |
Currencies.Code |
Key | |
Transaction |
Document |
Documents.ID |
Key | |
Transaction |
GL |
GLAccounts.ID |
Key | |
Transaction |
Item |
Items.ID |
Key | |
Transaction |
Journal |
Journals.Code |
Key | |
Transaction |
Modifier |
Users. |
Key | |
Transaction |
Project |
ProjectWBS.ID |
Key | |
Transaction |
Project |
Projects.ID |
Key | |
Transaction |
Shop |
ShopOrders.ID |
Key | |
Transaction |
Subscription |
Subscriptions. |
Key | |
Transaction |
VAT |
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: