invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ProjectSecurityLinkById: Bouw7 Project Security Link by ID

read only REST

  • Catalogus: 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.

Kan alleen gegevens ophalen.

Samenvatting

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

API-bron

  • Eindpunt: /project/project-security-link/{id}
  • Operatie: get /project/project-security-link/{id}

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 90
Aantal rijen per minuut bij volledige scan 241,000
Aantal rijen per minuut in een Query 666

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
id `` Project security link ID.

Tabelkolommen

De kolommen van de tabel ProjectSecurityLinkById worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
additionalWorkAmount varchar2 Extra Werkbedrag 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 Budgetbedrag filters on the platform, writable, budgetAmount The budget amount of the project security link.
costTypeId int64 Kostentype ID filters on the platform, writable, costTypeId The cost type ID of the project security link.
createdAt datetime Aangemaakt op filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Gemaakt door 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 Uurinformatie Budget Uren filters on the platform, writable, hourInfo.budgetHours Only filled for cost type labor and equipment!The budget hours of the ProjectSecurityLink.
hourInfo_hourlyRate varchar2 Uurinfo Uurtarief filters on the platform, writable, hourInfo.hourlyRate The hourly rate.
hourInfo_prognosisHours varchar2 Uurinformatie Prognose Uren filters on the platform, writable, hourInfo.prognosisHours Only filled for cost type labor and equipment!The prognosis hours of the ProjectSecurityLink.
hourInfo_prognosisOtherHours varchar2 Uurinformatie Prognose Overige Uren 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 Uurinformatie Prognose Gereserveerde Uren 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 Prognosebedrag filters on the platform, writable, prognosisAmount The prognosis amount of the project security link.
prognosisOtherAmount varchar2 Prognose Ander Bedrag filters on the platform, writable, prognosisOtherAmount The prognosis other amount of the project security link.
prognosisReservedAmount varchar2 Prognose Gereserveerd Bedrag 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 Beveiligingscode-ID filters on the platform, writable, securityCodeId The security code ID of the project security link.
securityObject_code varchar2 Beveiligingsobjectcode filters on the platform, writable, securityObject.code The code of the security object.
securityObject_id int64 Beveiligingsobject-ID filters on the platform, writable, securityObject.id The unique identifier of the security object.
securityObject_name varchar2 Beveiligingsobjectnaam 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 Bijgewerkt op filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Bijgewerkt door filters on the platform, writable, updatedBy The user that last updated the entity.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: