invantive documentation
Invantive Support ForumsLog In / Sign Up

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.
AccountCode varchar2(18) Account Code writable Code of the Account.
AccountName varchar2(50) Account Name writable Name of account.
AmountDC double Amount Division Currency writable Amount in the default currency of the company.
AmountFC double Amount Foreign Currency writable Amount in the currency of the transaction.
AmountVATBaseFC double Amount VAT Base Foreign Currency writable Vat base amount in the currency of the transaction.
AmountVATFC double Amount VAT Foreign Currency writable Vat amount in the currency of the transaction.
Asset guid Asset writable Reference to asset.
AssetCode varchar2(30) Asset Code writable Code of Asset.
AssetDescription varchar2(60) Asset Description writable Description of Asset.
CostCenter varchar2(8) Cost Centre filters on the platform, writable Reference to cost center.
CostCenterDescription varchar2(60) Cost Centre Description writable Description of CostCenter.
CostUnit varchar2(8) Cost Unit filters on the platform, writable Reference to cost unit.
CostUnitDescription varchar2(60) Cost Unit Description writable Description of CostUnit.
Created datetime Created writable Creation date.
CreatedUtc datetime Created (UTC) writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Creator Full Name writable Name of creator.
Currency varchar2(30) Currency writable Currency.
CustomField varchar2 Custom Field writable
Date datetime Date filters on the platform, writable Date.
Description varchar2(60) Description writable Description.
DisplayDocumentsUrl varchar2 Display Documents (URL) writable URL to display documents attached to this transaction using Get My Report.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Division Chamber of Commerce Number writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Division IBAN Number writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division Company Name writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Division RSIN Number writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Division VAT Number writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Division Wage Tax Number writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Division Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administration Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Subscription Holder Name writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Subscription Holder Number writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Division Short Name writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable Reference to document.
DocumentNumber int32 Document Number writable Number of the document.
DocumentSubject varchar2(256) Document Subject writable Subject of the document.
DueDate datetime Due Date writable Date that payment should be done.
EntryID guid Entry ID filters on the platform, writable The transaction lines that make up a financial entry share the same EntryID.
EntryNumber int32 Entry Number filters on the platform, writable Entry number of the header.
ExchangeRate double Exchange Rate writable Exchange rate.
ExternalLinkDescription varchar2 External Link Description
ExternalLinkReference varchar2 External Link Reference
ExtraDutyAmountFC double Extra Duty Amount Foreign Currency writable Extra duty amount.
ExtraDutyPercentage double Extra Duty (%) writable Extra duty percentage.
FinancialPeriod int16 Financial Period filters on the platform, writable Financial period.
FinancialYear int16 Financial Year filters on the platform, writable Financial year.
GLAccount guid General Ledger Account filters on the platform, writable General ledger account.
GLAccountBalanceSide varchar2(1) GL Account Balance Side writable Balance side of transactions on this GL account.
GLAccountBalanceType varchar2(1) GL Account Balance Type writable Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss.
GLAccountCode varchar2(30) GL Account Code writable Code of the G/L account.
GLAccountDescription varchar2(60) GL Account Description writable Description of the G/L account.
GLAccountRevalueCurrency char GL Account Revalue Currency writable Whether to revalue amounts posted on this GL account.
GLAccountSearchCode varchar2(9) GL Account Search Code writable User-friendly search code for the GL account.
GLAccountType int32 GL Account Type writable Type of GL account. See view GLAccountTypes.
GLAccountTypeDescription varchar2 GL Account Type Description writable Description of the GL account type.
GLAccountUseCostCenter char Use Cost Centre writable Indicator whether to use cost centers for transaction lines on the GL account.
GLAccountUseCostUnit char Use Cost Unit writable Indicator whether to use cost units for transaction lines on the GL account.
GLAccountVatCode varchar2(3) VAT Code of GL Account writable Associated VAT code of the GL account.
ID guid ID filters on the platform, writable Primary key.
InvoiceNumber int32 Invoice Number filters on the platform, writable Invoice number.
Item guid Item writable Reference to item.
ItemCode varchar2(30) Item Code writable Code of Item.
ItemDescription varchar2(255) Item Description writable Description of Item.
JournalCode varchar2(20) Journal Code filters on the platform, writable The journal code.
JournalDescription varchar2(60) Journal Description writable The journal description.
LineNumber int32 Line Number writable Line number.
LineType int16 Line Type writable Line type.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modified (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
ModifierFullName varchar2(240) Modified Full Name writable Name of modifier.
Notes varchar2 Notes writable Extra remarks.
OffsetID guid Offset GL Account ID writable OffsetID.
OrderNumber int32 Order Number filters on the platform, writable Order number.
PaymentDiscountAmount double Payment Discount Amount writable Discount amount when paid in time.
PaymentReference varchar2(60) Payment Reference writable Payment reference.
Project guid Project filters on the platform, writable Reference to project.
ProjectCode varchar2(20) Project Code writable Code of Project.
ProjectDescription varchar2(60) Project Description writable Description of Project.
ProjectWBS guid Project WBS writable Project WBS ID.
ProjectWBSDescription varchar2 Project WBS Description writable Project WBS description.
Quantity double Quantity writable Quantity.
SerialNumber varchar2(30) Serial Number writable Serial number of item.
ShopOrder 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.
SubscriptionDescription varchar2(60) Subscription Description writable Description of subscription line.
TrackingNumber varchar2(100) Tracking Number writable Tracking number of item.
TrackingNumberDescription varchar2(240) Tracking Number Description writable Tracking number description.
Type int32 Type filters on the platform, writable The transaction type. Possible values: see TransactionLineTypes.
VATCode varchar2(3) VAT Code filters on the platform, writable VAT code.
VATCodeDescription varchar2(60) VAT Code Description writable Description of VAT code.
VATPercentage double VAT Percentage writable Vat percentage.
VATType varchar2(1) VAT Type filters on the platform, writable VAT type.
YourRef varchar2(60) Your Reference filters on the platform, writable Your reference (of customer).

Keys

Key Column Refers to 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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: