invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectsIncremental: Exact Online Projects

popular read only per partition

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

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) 261
Full scan rows per minute 14,700
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table ProjectsIncremental 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
AccountContact guid Account Contact filters on the platform
AllowAdditionalInvoicing char Allow Additional Invoicing filters on the platform
AllowMemberEntryOnly char itgen_eol_allowmemberentryonly filters on the platform
BlockEntry char Block Entry of Time and Cost filters on the platform
BlockInvoicing char itgen_eol_blockinvoicing
BlockPlanning char Block Planning filters on the platform
BlockPurchasing char Block Purchasing filters on the platform
BlockRebilling char Block Rebilling filters on the platform
BudgetOverrunHours int16 Budget Overrun Hours Status filters on the platform
BudgetType int16 Budget Type filters on the platform
BudgetedAmount double Budgeted Amount filters on the platform
BudgetedCosts double Budgeted Costs filters on the platform
BudgetedRevenue double Budgeted Revenue filters on the platform
Classification guid Classification filters on the platform
Code varchar2 Code filters on the platform
CostsAmountFC double itgen_eol_costsamountfc filters on the platform
Created datetime Created filters on the platform
Creator guid Creator filters on the platform
CustomField varchar2 Custom Field filters on the platform
CustomerPOnumber varchar2 Customer PO Number filters on the platform
Description varchar2 Description filters on the platform
Division int32 Division
EndDate datetime End Date filters on the platform
FixedPriceItem guid Fixed Price Item filters on the platform
HasWBSLines char Has WBS Lines filters on the platform
ID guid ID filters on the platform
IncludeInvoiceSpecification int16 itgen_eol_includeinvoicespecification filters on the platform
IncludeSpecificationInInvoicePdf char itgen_eol_includespecificationininvoicepdf filters on the platform
InternalNotes varchar2 Internal Notes filters on the platform
InvoiceAddress guid Invoice Address filters on the platform
InvoiceAsQuoted char Invoice as Quoted filters on the platform
Manager guid Manager filters on the platform
MarkupPercentage double Mark-up Percentage 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
PaymentCondition varchar2 Payment Condition
PrepaidItem guid Prepaid Item filters on the platform
PrepaidType int16 Prepaid Type filters on the platform
SalesTimeQuantity double Sales Time Quantity filters on the platform
SourceQuotation guid Source Quotation filters on the platform
StartDate datetime Start Date filters on the platform
TimeQuantityToAlert double Time Quantity to Alert filters on the platform
Timestamp int64 Timestamp filters on the platform
Type int32 Type filters on the platform
UseBillingMilestones char itgen_eol_usebillingmilestones filters on the platform

Release Notes

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