invantive documentation
Invantive Support ForumsLog In / Sign Up

TransactionLinesIncremental: Exact Online Transaction Lines (Incremental)

popular read only per partition

  • Catalog: ExactOnlineREST
  • Schema: Incremental
  • Primary Keys: ID
  • Label: Transaction Lines (Incremental)

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 181
Full scan rows per minute 40,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table TransactionLinesIncremental 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 Reference to account.
AmountDC double Amount Division Currency Amount in the default currency of the company.
AmountFC double Amount Foreign Currency Amount in the currency of the transaction.
AmountVATBaseFC double Amount VAT Base Foreign Currency VAT base amount in the currency of the transaction.
AmountVATFC double Amount VAT Foreign Currency VAT amount in the currency of the transaction.
Asset guid Asset Reference to asset.
CostCenter varchar2 Cost Centre Reference to cost center.
CostUnit varchar2 Cost Unit Reference to cost unit.
Created datetime Created Creation date.
Creator guid Creator User ID of creator.
Currency varchar2 Currency Currency.
CustomField varchar2 Custom Field
Date datetime Date Entry date.
Description varchar2 Description Description.
Division int32 Division Division code.
Document guid Document Reference to document.
DueDate datetime Due Date Date that payment should be done.
EntryID guid Entry ID The transaction lines that make up a financial entry share the same EntryID.
EntryNumber int32 Entry Number Entry number of the header.
ExchangeRate double Exchange Rate Exchange rate.
ExtraDutyAmountFC double Extra Duty Amount Foreign Currency Extra duty amount.
ExtraDutyPercentage double Extra Duty (%) Extra duty percentage.
FinancialPeriod int16 Financial Period Financial period.
FinancialYear int16 Financial Year Financial year.
GLAccount guid General Ledger Account General ledger account.
ID guid ID Primary key.
InvoiceNumber int32 Invoice Number Invoice number.
Item guid Item Reference to item.
JournalCode varchar2 Journal Code Journal code.
LineNumber int32 Line Number Line number.
LineType int16 Line Type Line type.
Modified datetime Modified Last modified date.
Modifier guid Modifier User ID of modifier.
Notes varchar2 Notes Extra remarks.
OffsetID guid Offset GL Account ID Offset ID.
OrderNumber int32 Order Number Order number.
PaymentDiscountAmount double Payment Discount Amount Discount amount when paid in time.
PaymentReference varchar2 Payment Reference Payment reference.
Project guid Project Reference to project.
Quantity double Quantity Quantity.
SerialNumber varchar2 Serial Number
Status int16 Status Status, 20 = Open, 50 = Processed.
Subscription guid Subscription Reference to subscription line.
Timestamp int64 Timestamp Timestamp.
TrackingNumber varchar2 Tracking Number Tracking number.
Type int32 Type Transaction type.
VATCode varchar2 VAT Code VAT code.
VATPercentage double VAT Percentage VAT percentage.
VATType varchar2 VAT Type VAT type.
YourRef varchar2(60) Your Reference Your reference (of customer).

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: