invantive documentation
Invantive Support ForumsLog In / Sign Up

CostTransactionsIncremental: Exact Online Cost Transactions

read only

  • Catalog: ExactOnlineREST
  • Schema: Views
  • Label: Cost Transactions

Cost registrations on projects.

Can only retrieve data.

Performance Characteristics

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

The result can be cached on the client.

Table Columns

The columns of the table CostTransactionsIncremental 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
AmountFC double Amount Foreign Currency filters on the platform
Attachment guid Attachment 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
CustomField varchar2 Custom Field
Date datetime Date filters on the platform
Division int32 Division
Employee guid Employee filters on the platform
EndTime datetime End Time filters on the platform
EntryNumber int32 Entry Number filters on the platform
ErrorText varchar2 Error Text filters on the platform
HourStatus int16 Hour Status filters on the platform
ID guid ID filters on the platform
Item guid Item filters on the platform
ItemDivisable char Item Divisable 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
PriceFC double Price Foreign Currency filters on the platform
Project guid Project filters on the platform
ProjectAccount guid Project Account
Quantity double Quantity filters on the platform
StartTime datetime Start Time filters on the platform
Subscription guid Subscription filters on the platform
SubscriptionAccount guid Subscription Account
Timestamp int64 Timestamp filters on the platform
Type int16 Type filters on the platform
WBS guid WBS filters on the platform

Release Notes

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