invantive documentation
Invantive Support ForumsLog In / Sign Up

QuotationsV2Incremental: Exact Online Quotations

read only per partition

  • Catalog: ExactOnlineREST
  • Schema: Incremental
  • Primary Keys: ID
  • Label: Quotations

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) 172
Full scan rows per minute 12,100
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table QuotationsV2Incremental 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
AmountDC double Amount Division Currency filters on the platform
AmountDiscount double Amount Discount filters on the platform
AmountDiscountExclVat double Amount Discount excluding VAT filters on the platform
AmountFC double Amount Foreign Currency filters on the platform
CloseDate datetime Date Closed filters on the platform
ClosingDate datetime Date Closing filters on the platform
Created datetime Created filters on the platform
Creator guid Creator filters on the platform
Currency varchar2 Currency filters on the platform
DeliveryAccount guid Delivery Account filters on the platform
DeliveryAccountContact guid Delivery Account Contact filters on the platform
DeliveryAddress guid Delivery Address filters on the platform
DeliveryDate datetime Delivery Date filters on the platform
Description varchar2 Description filters on the platform
Discount double Discount filters on the platform
Division int32 Division
Document guid Document filters on the platform
DueDate datetime Due Date filters on the platform
ID guid ID filters on the platform
IncotermAddress varchar2 Incoterm Address filters on the platform
IncotermCode varchar2 Incoterm Code filters on the platform
IncotermVersion int16 Incoterm Version filters on the platform
InvoiceAccount guid Invoice Account filters on the platform
InvoiceAccountContact guid Invoice Account Contact filters on the platform
Modified datetime Modified filters on the platform
Modifier guid Modifier filters on the platform
Notes varchar2 Notes filters on the platform
Opportunity guid Opportunity filters on the platform
OrderAccount guid Order Account filters on the platform
OrderAccountContact guid Order Account Contact filters on the platform
PaymentCondition varchar2 Payment Condition filters on the platform
Project guid Project filters on the platform
QuotationDate datetime Quotation Date filters on the platform
QuotationID guid Quotation ID filters on the platform
QuotationNumber int32 Quotation Number filters on the platform
Remarks varchar2 Remarks filters on the platform
SalesChannel guid Sales Channel filters on the platform
SalesPerson guid Sales Person filters on the platform
ShippingMethod guid Shipping Method filters on the platform
Status int16 Status filters on the platform
Timestamp int64 Timestamp filters on the platform
VersionNumber int32 Version Number filters on the platform
YourRef varchar2(60) Your Reference filters on the platform

Release Notes

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