---
title: "ProjectAssignmentById (Simplicate)"
description: "Project Assignment by ID"
language: nl
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/nl/datamodels/simplicate/Simplicate.Projects.ProjectAssignmentById
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectAssignmentById
updated: 2026-11-18T23:54:05Z
license: https://documentation.invantive.eu/nl/
---

# ProjectAssignmentById: Simplicate projectopdracht op ID

`read only` `REST`

- Catalogus: `Simplicate`
- Schema: `Projects`
- Label: Projecttoewijzing op ID

Haalt één opdracht op aan de hand van het id

Kan alleen gegevens ophalen.

## API-bron

- Eindpunt: `/projects/assignment/{id}`
- Operatie: `get /projects/assignment/{id}`

## Parameters

| Name | Datatype | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  | De id van de sjabloon |

## Tabelkolommen

De kolommen van de tabel `ProjectAssignmentById` 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 |
|---|---|---|:---:|---|---|
| `created_at` | `varchar2` | Aangemaakt op | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `end_date` | `varchar2` | Einddatum | [ ] |  |  |
| `hours` | `double` | Hours | [ ] |  |  |
| `hours_total` | `double` | Uren Totaal | [ ] |  |  |
| `hours_type` | `varchar2` | Urensoort | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `is_planned` | `char` | Is Gepland | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Project ID | [ ] |  |  |
| `project_name` | `varchar2` | Projectnaam | [ ] |  |  |
| `project_organization_id` | `varchar2` | Projectorganisatie-ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Naam Projectorganisatie | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Project Persoon Volledige naam | [ ] |  |  |
| `project_person_id` | `varchar2` | Projectpersoon-ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Projectmanager Bedrag | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Projectmanager Declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Projectmanager Werknemer ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Projectmanager ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Projectmanager Naam | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Projectmanager Persoon ID | [ ] |  | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie |
| `project_project_manager_tariff` | `double` | Projectmanager Tarief | [ ] |  |  |
| `project_project_number` | `varchar2` | Projectnummer | [ ] |  |  |
| `projecthourstype_billable` | `char` | itgen_spe_projecthourstype_billable | [ ] |  |  |
| `projecthourstype_budgeted_amount` | `double` | itgen_spe_projecthourstype_budgeted_amount | [ ] |  |  |
| `projecthourstype_color` | `varchar2` | itgen_spe_projecthourstype_color | [ ] |  |  |
| `projecthourstype_hourstype_billable` | `double` | itgen_spe_projecthourstype_hourstype_billable | [ ] |  |  |
| `projecthourstype_hourstype_blocked` | `char` | itgen_spe_projecthourstype_hourstype_blocked | [ ] |  |  |
| `projecthourstype_hourstype_color` | `varchar2` | itgen_spe_projecthourstype_hourstype_color | [ ] |  |  |
| `projecthourstype_hourstype_id` | `varchar2` | itgen_spe_projecthourstype_hourstype_id | [ ] |  |  |
| `projecthourstype_hourstype_label` | `varchar2` | itgen_spe_projecthourstype_hourstype_label | [ ] |  |  |
| `projecthourstype_hourstype_tariff` | `double` | itgen_spe_projecthourstype_hourstype_tariff | [ ] |  |  |
| `projecthourstype_hourstype_type` | `varchar2` | itgen_spe_projecthourstype_hourstype_type | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_code` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_code | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_id` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_id | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_label` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_label | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_name` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_name | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_percentage` | `double` | itgen_spe_projecthourstype_hourstype_vatclass_percentage | [ ] |  |  |
| `projecthourstype_id` | `varchar2` | itgen_spe_projecthourstype_id | [ ] |  |  |
| `projecthourstype_tariff` | `double` | itgen_spe_projecthourstype_tariff | [ ] |  |  |
| `projectservice_default_service_id` | `varchar2` | itgen_spe_projectservice_default_service_id | [ ] |  |  |
| `projectservice_id` | `varchar2` | Projectdienst ID | [ ] |  |  |
| `projectservice_name` | `varchar2` | Projectservicenaam | [ ] |  |  |
| `projectservice_revenue_group_id` | `varchar2` | itgen_spe_projectservice_revenue_group_id | [ ] |  |  |
| `projectservice_use_in_resource_planner` | `char` | itgen_spe_projectservice_use_in_resource_planner | [ ] |  |  |
| `spent_amount` | `varchar2` | Besteed Bedrag | [ ] |  |  |
| `spread` | `varchar2` | itgen_spe_spread | [ ] |  |  |
| `start_date` | `varchar2` | Startdatum | [ ] |  |  |
| `status_color` | `varchar2` | Statuskleur | [ ] |  |  |
| `status_created_at` | `varchar2` | Status Aangemaakt op | [ ] |  |  |
| `status_id` | `varchar2` | Status-ID | [ ] |  |  |
| `status_is_blocked` | `char` | Status is Geblokkeerd | [ ] |  |  |
| `status_is_done` | `char` | Status is Voltooid | [ ] |  |  |
| `status_name` | `varchar2` | Statusnaam | [ ] |  |  |
| `status_order` | `int64` | Orderstatus | [ ] |  |  |
| `status_updated_at` | `varchar2` | Status geüpdatet op | [ ] |  |  |
| `updated_at` | `varchar2` | Bijgewerkt op | [ ] |  |  |
| `use_spread` | `char` | Gebruik Spread | [ ] |  |  |


## Release Notes

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

- [Simplicate](/nl/release-notes/drivers?driver=simplicate)
