invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectSecurityLinkById: Bouw7 Project Security Link by ID

read only REST

  • Catalog: Bouw7
  • Schema: Security
  • Label: Project Security Link by ID

Returns a single project security link based on the given ID. Returns a single project security link based on the given ID.

Can only retrieve data.

Summary

Returns a single project security link based on the given ID.

API Source

  • Endpoint: /project/project-security-link/{id}
  • Operation: get /project/project-security-link/{id}

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id `` Project security link ID.

Table Columns

The columns of the table ProjectSecurityLinkById 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
additionalWorkAmount varchar2 Additional Work Amount filters on the platform, writable, additionalWorkAmount The additional work amount of the project security link.
adjustment int64 Adjustment filters on the platform, writable, adjustment The total adjustment amount of the project security link.
budgetAmount varchar2 Budget Amount filters on the platform, writable, budgetAmount The budget amount of the project security link.
costTypeId int64 Cost Type ID filters on the platform, writable, costTypeId The cost type ID of the project security link.
createdAt datetime Created at filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, createdBy The user that created the entity.
fixedPurchaseAmount varchar2 itgen_bouw7_fixedpurchaseamount filters on the platform, writable, fixedPurchaseAmount The fixed purchase amount of the project security link.
hourInfo_budgetHours varchar2 Hour Info Budget Hours filters on the platform, writable, hourInfo.budgetHours Only filled for cost type labor and equipment! The budget hours of the ProjectSecurityLink.
hourInfo_hourlyRate varchar2 Hour Info Hourly Rate filters on the platform, writable, hourInfo.hourlyRate The hourly rate.
hourInfo_prognosisHours varchar2 Hour Info Prognosis Hours filters on the platform, writable, hourInfo.prognosisHours Only filled for cost type labor and equipment! The prognosis hours of the ProjectSecurityLink.
hourInfo_prognosisOtherHours varchar2 Hour Info Prognosis Other Hours filters on the platform, writable, hourInfo.prognosisOtherHours Only filled for cost type labor and equipment! The prognosis other hours of the ProjectSecurityLink.
hourInfo_prognosisReservedHours varchar2 Hour Info Prognosis Reserved Hours filters on the platform, writable, hourInfo.prognosisReservedHours Only filled for cost type labor and equipment! The prognosis reserved hours of the ProjectSecurityLink.
id int64 ID filters on the platform, writable, id The unique identifier of the project security link.
name varchar2 Name filters on the platform, writable, name The name of the project security link.
prognosisAmount varchar2 Prognosis Amount filters on the platform, writable, prognosisAmount The prognosis amount of the project security link.
prognosisOtherAmount varchar2 Prognosis Other Amount filters on the platform, writable, prognosisOtherAmount The prognosis other amount of the project security link.
prognosisReservedAmount varchar2 Prognosis Reserved Amount filters on the platform, writable, prognosisReservedAmount The prognosis reserved amount of the project security link.
progress varchar2 Progress filters on the platform, writable, progress The total progress amount of the project security link.
projectId int64 Project ID filters on the platform, writable, projectId The project ID of the project security link.
securityCodeId int64 Security Code ID filters on the platform, writable, securityCodeId The security code ID of the project security link.
securityObject_code varchar2 Security Object Code filters on the platform, writable, securityObject.code The code of the security object.
securityObject_id int64 Security Object ID filters on the platform, writable, securityObject.id The unique identifier of the security object.
securityObject_name varchar2 Security Object Name filters on the platform, writable, securityObject.name The name of the security object.
status int64 Status filters on the platform, writable, status The status of the project security link.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy The user that last updated the entity.

Release Notes

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