invantive documentation
Invantive Support ForumsLog In / Sign Up

ptprognosisproject: AFAS Profit itgen_aoe_ptprognosisproject

insert update delete REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_ptprognosisproject

Projectvoortgang

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /connectors/PtPrognosisProject
  • Metadata: metainfo/update/PtPrognosisProject

Performance Characteristics

Characteristic Value
Average access latency (ms) 353
Full scan rows per minute 65,100
Point query rows per minute 169

The result can be cached on the client.

Table Columns

The columns of the table ptprognosisproject 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
adju number Bijstelling fetched only when named, Adju
dati datetime Datum fetched only when named, DaTi
id int32 Projectvoortgang fetched only when named, Id
pere number Voortgang (%) fetched only when named, PeRe
prid varchar2(15) Project fetched only when named, PrId
prst varchar2(15) Projectfase fetched only when named, PrSt