TransactionLinesBulk: Exact Online Transaction Lines (Bulk)
read only per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
FinancialTransaction - Primary Keys:
ID - Label: Transaction Lines (Bulk)
The data in this table is partitioned per value of the Division column.
Can only retrieve data.
Changes arrive through the webhook topic FinancialTransactions on EntryID.
API Source
- Endpoint:
/api/v1/{division}/bulk/financial/TransactionLines - Metadata:
/api/v1/{division}/bulk/financial/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 20,000 |
| 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 TransactionLinesBulk 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 | 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 | 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 | writable | Currency. | |
Custom |
varchar2 |
Custom Field | writable | ||
Date |
datetime |
Date | filters on the platform, writable | Date. | |
Description |
varchar2 |
Description | 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 | |||
External |
varchar2 |
External Link Reference | |||
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 | 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 | 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 | writable | OffsetID. | |
Order |
int32 |
Order Number | filters on the platform, writable | Order number. | |
Payment |
double |
Payment Discount Amount | writable | Discount amount when paid in time. | |
Payment |
varchar2 |
Payment Reference | writable | Payment reference. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project. | |
Project |
varchar2 |
Project Code | 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 | Reference to shop order. | ||
Status |
int16 |
Status | filters on the platform, writable | 20 = Open, 50 = Processed. | |
Subscription |
guid |
Subscription | 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 | 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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: