invantive documentation
Invantive Support ForumsLog In / Sign Up

DocumentsIncremental: Exact Online Documents (Incremental)

read only per partition

  • Catalog: ExactOnlineREST
  • Schema: Incremental
  • Primary Keys: ID
  • Label: Documents (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) 392
Full scan rows per minute 42,600
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table DocumentsIncremental 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
AmountFC double Amount Foreign Currency
Body varchar2 Body filters on the platform, writable Body of this document.
Category guid Category filters on the platform, writable ID of the category of this document.
Contact guid Contact filters on the platform, writable ID of the related contact of this document.
Created datetime Created filters on the platform, writable Creation date.
Creator guid Creator filters on the platform, writable User ID of creator.
Currency varchar2 Currency
Division int32 Division
DocumentDate datetime Document Date filters on the platform, writable Entry date of the incoming document.
DocumentFolder guid Document Folder filters on the platform, writable The Id of document folder.
DocumentViewUrl varchar2 Document View URL writable Url to view the document.
ExpiryDate datetime Expiry Date
FinancialTransactionEntryID guid itgen_eol_financialtransactionentryid
HID int32 HID
HasEmptyBody char Has Empty Body
ID guid ID
InheritShare char Inherit Share filters on the platform
Item guid Item
Language varchar2 Language
Modified datetime Modified
Modifier guid Modifier
Opportunity guid Opportunity
Project guid Project
ProposedEntryStatus int16 Proposed Entry Status
SalesInvoiceNumber int32 Sales Invoice Number
SalesOrderNumber int32 Sales Order Number
SendMethod int32 Send Method
ShopOrderNumber int32 Shop Order Number
Subject varchar2 Subject
TeamsMeetingId varchar2 itgen_eol_teamsmeetingid
Timestamp int64 Timestamp
Type int32 Type

Release Notes

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