TransactionLines: Exact Online Transaction Lines
insert update delete per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
FinancialTransaction - Primary Keys:
ID - Label: Transaction Lines
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Changes arrive through the webhook topic FinancialTransactions on EntryID.
API Source
- Endpoint:
/api/v1/{division}/financialtransaction/TransactionLines - Metadata:
/api/v1/{division}/financialtransaction/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table TransactionLines are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
Account Name | writable | Name of account. | |
Amount |
double |
Amount Division Currency | writable | Amount in the default currency of the company. | |
Amount |
double |
Amount Foreign Currency | writable | Amount in the currency of the transaction. | |
Amount |
double |
Amount VAT Base Foreign Currency | writable | Vat base amount in the currency of the transaction. | |
Amount |
double |
Amount VAT Foreign Currency | writable | Vat amount in the currency of the transaction. | |
Asset |
guid |
Asset | filters on the platform, writable | Reference to asset. | |
Asset |
varchar2 |
Asset Code | writable | Code of Asset. | |
Asset |
varchar2 |
Asset Description | writable | Description of Asset. | |
Cost |
varchar2 |
Cost Centre | filters on the platform, writable | Reference to cost center. | |
Cost |
varchar2 |
Cost Centre Description | writable | Description of CostCenter. | |
Cost |
varchar2 |
Cost Unit | filters on the platform, writable | Reference to cost unit. | |
Cost |
varchar2 |
Cost Unit Description | writable | Description of CostUnit. | |
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full Name | writable | Name of creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency. | |
Custom |
varchar2 |
Custom Field | writable | ||
Date |
datetime |
Date | filters on the platform, writable | Date. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
Display |
varchar2 |
Display Documents (URL) | writable | URL to display documents attached to this transaction using Get My Report. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters on the platform, writable | Reference to document. | |
Document |
int32 |
Document Number | writable | Number of the document. | |
Document |
varchar2 |
Document Subject | writable | Subject of the document. | |
Due |
datetime |
Due Date | writable | Date that payment should be done. | |
Entry |
guid |
Entry ID | filters on the platform, writable | The transaction lines that make up a financial entry share the same EntryID. | |
Entry |
int32 |
Entry Number | filters on the platform, writable | Entry number of the header. | |
Exchange |
double |
Exchange Rate | writable | Exchange rate. | |
External |
varchar2 |
External Link Description | filters on the platform, writable | ||
External |
varchar2 |
External Link Reference | filters on the platform, writable | ||
Extra |
double |
Extra Duty Amount Foreign Currency | writable | Extra duty amount. | |
Extra |
double |
Extra Duty (%) | writable | Extra duty percentage. | |
Financial |
int16 |
Financial Period | filters on the platform, writable | Financial period. | |
Financial |
int16 |
Financial Year | filters on the platform, writable | Financial year. | |
GL |
guid |
General Ledger Account | filters on the platform, writable | General ledger account. | |
GL |
varchar2 |
GL Account Balance Side | writable | Balance side of transactions on this GL account. | |
GL |
varchar2 |
GL Account Balance Type | writable | Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss. | |
GL |
varchar2 |
GL Account Code | filters on the platform, writable | Code of the G/L account. | |
GL |
varchar2 |
GL Account Description | writable | Description of the G/L account. | |
GL |
char |
GL Account Revalue Currency | writable | Whether to revalue amounts posted on this GL account. | |
GL |
varchar2 |
GL Account Search Code | writable | User-friendly search code for the GL account. | |
GL |
int32 |
GL Account Type | writable | Type of GL account. See view GLAccountTypes. | |
GL |
varchar2 |
GL Account Type Description | writable | Description of the GL account type. | |
GL |
char |
Use Cost Centre | writable | Indicator whether to use cost centers for transaction lines on the GL account. | |
GL |
char |
Use Cost Unit | writable | Indicator whether to use cost units for transaction lines on the GL account. | |
GL |
varchar2 |
VAT Code of GL Account | writable | Associated VAT code of the GL account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Invoice |
int32 |
Invoice Number | filters on the platform, writable | Invoice number. | |
Item |
guid |
Item | filters on the platform, writable | Reference to item. | |
Item |
varchar2 |
Item Code | writable | Code of Item. | |
Item |
varchar2 |
Item Description | writable | Description of Item. | |
Journal |
varchar2 |
Journal Code | filters on the platform, writable | The journal code. | |
Journal |
varchar2 |
Journal Description | writable | The journal description. | |
Line |
int32 |
Line Number | writable | Line number. | |
Line |
int16 |
Line Type | writable | Line type. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Modified Full Name | writable | Name of modifier. | |
Notes |
varchar2 |
Notes | writable | Extra remarks. | |
Offset |
guid |
Offset GL Account ID | filters on the platform, writable | OffsetID. | |
Order |
int32 |
Order Number | filters on the platform, writable | Order number. | |
Payment |
double |
Payment Discount Amount | filters on the platform, writable | Discount amount when paid in time. | |
Payment |
varchar2 |
Payment Reference | writable | Payment reference. | |
Project |
guid |
Project | writable | Reference to project. | |
Project |
varchar2 |
Project Code | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Project Description | writable | Description of Project. | |
Project |
guid |
Project WBS | writable | Project WBS ID. | |
Project |
varchar2 |
Project WBS Description | writable | Project WBS description. | |
Quantity |
double |
Quantity | writable | Quantity. | |
Serial |
varchar2 |
Serial Number | writable | Serial number of item. | |
Shop |
guid |
Shop Order | 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 |
Subscription Description | writable | Description of subscription line. | |
Tracking |
varchar2 |
Tracking Number | writable | Tracking number of item. | |
Tracking |
varchar2 |
Tracking Number Description | 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 |
VAT Code | filters on the platform, writable | VAT code. | |
VAT |
varchar2 |
VAT Code Description | writable | Description of VAT code. | |
VAT |
double |
VAT Percentage | writable | Vat percentage. | |
VAT |
varchar2 |
VAT Type | filters on the platform, writable | VAT type. | |
Your |
varchar2 |
Your Reference | filters on the platform, writable | Your reference (of customer). |
Keys
| Key | Column | Refers to | 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 |
Sample Queries
--
-- 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
What changed per release in the tables, columns, attributes and capabilities of the driver: