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 |
|---|---|---|---|---|---|
additional |
varchar2 |
Extra Werkbedrag | filters on the platform, writable, additional |
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. | |
budget |
varchar2 |
Budgetbedrag | filters on the platform, writable, budget |
The budget amount of the project security link. | |
cost |
int64 |
Kostentype ID | filters on the platform, writable, cost |
The cost type ID of the project security link. | |
created |
datetime |
Aangemaakt op | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Gemaakt door | filters on the platform, writable, created |
The user that created the entity. | |
fixed |
varchar2 |
itgen_bouw7_fixedpurchaseamount | filters on the platform, writable, fixed |
The fixed purchase amount of the project security link. | |
hour |
varchar2 |
Uurinformatie Budget Uren | filters on the platform, writable, hour |
Only filled for cost type labor and equipment!The budget hours of the ProjectSecurityLink. | |
hour |
varchar2 |
Uurinfo Uurtarief | filters on the platform, writable, hour |
The hourly rate. | |
hour |
varchar2 |
Uurinformatie Prognose Uren | filters on the platform, writable, hour |
Only filled for cost type labor and equipment!The prognosis hours of the ProjectSecurityLink. | |
hour |
varchar2 |
Uurinformatie Prognose Overige Uren | filters on the platform, writable, hour |
Only filled for cost type labor and equipment!The prognosis other hours of the ProjectSecurityLink. | |
hour |
varchar2 |
Uurinformatie Prognose Gereserveerde Uren | filters on the platform, writable, hour |
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. | |
prognosis |
varchar2 |
Prognosebedrag | filters on the platform, writable, prognosis |
The prognosis amount of the project security link. | |
prognosis |
varchar2 |
Prognose Ander Bedrag | filters on the platform, writable, prognosis |
The prognosis other amount of the project security link. | |
prognosis |
varchar2 |
Prognose Gereserveerd Bedrag | filters on the platform, writable, prognosis |
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. | |
project |
int64 |
Project ID | filters on the platform, writable, project |
The project ID of the project security link. | |
security |
int64 |
Beveiligingscode-ID | filters on the platform, writable, security |
The security code ID of the project security link. | |
security |
varchar2 |
Beveiligingsobjectcode | filters on the platform, writable, security |
The code of the security object. | |
security |
int64 |
Beveiligingsobject-ID | filters on the platform, writable, security |
The unique identifier of the security object. | |
security |
varchar2 |
Beveiligingsobjectnaam | filters on the platform, writable, security |
The name of the security object. | |
status |
int64 |
Status | filters on the platform, writable, status |
The status of the project security link. | |
updated |
datetime |
Bijgewerkt op | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Bijgewerkt door | filters on the platform, writable, updated |
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: