---
title: "ProjectFile_ProjectCategoryDivisionSettings (Bouw7)"
description: "itgen_bouw7_projectfile_projectcategorydivisionsettings_plural"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/exactonlinebouw/Bouw7.Project.ProjectFile_ProjectCategoryDivisionSettings
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Project.ProjectFile_ProjectCategoryDivisionSettings
updated: 2026-11-16T13:15:24Z
license: https://documentation.invantive.eu/nl/
---

# ProjectFile_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_projectfile_projectcategorydivisionsettings_plural

`read only` `REST`

- Catalogus: `Bouw7`
- Schema: `Project`
- Label: itgen_bouw7_projectfile_projectcategorydivisionsettings_plural

Returns a project file associated with the given id. Returns a project file associated with the given id.

Kan alleen gegevens ophalen.

## Samenvatting

Returns a project file associated with the given id.

## API-bron

- Eindpunt: `/project/file/{projectFile}`
- Operatie: `get /project/file/{projectFile}`

## 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 |
|---|---|:---:|---|---|
| `projectFile` | `` | [x] |  | Project ID |

## Tabelkolommen

De kolommen van de tabel `ProjectFile_ProjectCategoryDivisionSettings` 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 |
|---|---|---|:---:|---|---|
| `branch_code` | `varchar2` | Vestigingscode | [ ] | writable, `::ancestor.::ancestor.branch.code` | The code for this branch |
| `branch_id` | `int64` | Vestiging-ID | [ ] | writable, `::ancestor.::ancestor.branch.id` | The ID of the branch. |
| `branch_name` | `varchar2` | Filiaalnaam | [ ] | writable, `::ancestor.::ancestor.branch.name` | The name of this branch |
| `city` | `varchar2` | City | [ ] | writable, `::ancestor.::ancestor.city` | The city of the project. |
| `code` | `varchar2` | Code | [ ] | writable, `::ancestor.code` | The code for the category. |
| `contact_contactType_id` | `int64` | Contact Soort ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.contactType.id` | The ID of contact type. |
| `contact_contactType_name` | `varchar2` | Contact Soort Naam | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.contactType.name` | The name of contact type. |
| `contact_email` | `varchar2` | Contact E-mail | [ ] | writable, `::ancestor.::ancestor.contact.email` | The email address. |
| `contact_email_2` | `varchar2` | itgen_bouw7_contact_email_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.email` | The email address. |
| `contact_id` | `int64` | Contactpersoon ID | [ ] | writable, `::ancestor.::ancestor.contact.id` | ID of contact. |
| `contact_id_2` | `int64` | itgen_bouw7_contact_id_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.id` | ID of contact. |
| `contact_isVatShifted` | `char` | Contact is BTW Verlegd | [ ] | writable, `::ancestor.::ancestor.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `contact_isVatShifted_2` | `char` | itgen_bouw7_contact_isvatshifted_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `contact_name` | `varchar2` | Contactpersoon Naam | [ ] | writable, `::ancestor.::ancestor.contact.name` | Name of contact. |
| `contact_name_2` | `varchar2` | itgen_bouw7_contact_name_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.name` | Name of contact. |
| `contact_phoneNumber` | `varchar2` | Contact Telefoonnummer | [ ] | writable, `::ancestor.::ancestor.contact.phoneNumber` | The phone number of the contact. |
| `contact_phoneNumber_2` | `varchar2` | itgen_bouw7_contact_phonenumber_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.phoneNumber` | The phone number of the contact. |
| `createdAt` | `datetime` | Aangemaakt op | [ ] | writable, `::ancestor.createdAt` | The creation time of the entity. |
| `createdAt_2` | `datetime` | Aangemaakt op | [ ] | writable, `::ancestor.::ancestor.createdAt` | The creation time of the entity. |
| `createdAt_3` | `datetime` | itgen_bouw7_createdat_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Gemaakt door | [ ] | writable, `::ancestor.createdBy` | The user that created the entity. |
| `createdBy_2` | `varchar2` | Gemaakt door | [ ] | writable, `::ancestor.::ancestor.createdBy` | The user that created the entity. |
| `createdBy_3` | `varchar2` | itgen_bouw7_createdby_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.createdBy` | The user that created the entity. |
| `deliveryDate` | `datetime` | Leveringsdatum | [ ] | writable, `::ancestor.::ancestor.deliveryDate` | Delivery date for the project. |
| `endDate` | `datetime` | Einddatum | [ ] | writable, `::ancestor.::ancestor.endDate` | End date for the project. |
| `file_createdAt` | `datetime` | Bestand Gemaakt op | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.createdAt` | The creation time of the entity. |
| `file_createdBy` | `varchar2` | Bestand Gemaakt door | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.createdBy` | The user that created the entity. |
| `file_extension` | `varchar2` | Bestandsextensie | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.extension` | The extension of the file. |
| `file_id` | `int64` | Bestands-ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.id` | The ID of this file |
| `file_modelId` | `int64` | Bestandsmodel-ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.modelId` | The ID of the associated type. |
| `file_modelType` | `varchar2` | Bestandsmodelsoort | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.modelType` | The category of the file. |
| `file_name` | `varchar2` | Bestandsnaam | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.name` | The public name of the file. |
| `file_secureHash` | `varchar2` | itgen_bouw7_file_securehash | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.secureHash` | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. |
| `file_size` | `int64` | Bestandsgrootte | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.size` | The size of the file in bytes. |
| `file_updatedAt` | `datetime` | Bestand Bijgewerkt op | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.updatedAt` | The last updated time of the entity. |
| `file_updatedBy` | `varchar2` | Bestand Bijgewerkt door | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.updatedBy` | The user that last updated the entity. |
| `file_uri` | `varchar2` | Bestand URI | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.uri` | The URI of the file, used to fetch the contents. |
| `fullProjectNumber` | `varchar2` | Volledig Projectnummer | [ ] | writable, `::ancestor.::ancestor.fullProjectNumber` | The full project number including year. |
| `generalCostsOrProfit` | `varchar2` | Algemene Kosten of Winst | [ ] | writable, `::ancestor.generalCostsOrProfit` | The general costs or profit for the category. |
| `generalCostsPercentage` | `varchar2` | Algemene Kosten Percentage | [ ] | writable, `::ancestor.generalCostsPercentage` | The general costs percentage for the category. |
| `grossProfitMargin` | `varchar2` | Brutowinstmarge | [ ] | writable, `::ancestor.grossProfitMargin` | The gross profit margin for the category. |
| `houseNumber` | `varchar2` | Huisnummer | [ ] | writable, `::ancestor.::ancestor.houseNumber` | The house number for the project. |
| `id` | `int64` | ID | [ ] | writable, `::ancestor.id` | The ID of the category. |
| `id_2` | `int64` | ID | [ ] | writable, `::ancestor.::ancestor.id` | The ID of the project. |
| `id_3` | `int64` | itgen_bouw7_id_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.id` | The ID of this project file metadata. |
| `information` | `varchar2` | Information | [ ] | writable, `::ancestor.::ancestor.information` | The information of the project. |
| `information_2` | `varchar2` | itgen_bouw7_information_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.information` | The information of this project file metadata. |
| `name` | `varchar2` | Name | [ ] | writable, `::ancestor.name` | The name of the category. |
| `name_2` | `varchar2` | itgen_bouw7_name_2 | [ ] | writable, `::ancestor.::ancestor.name` | The name of the project. |
| `name_3` | `varchar2(255)` | itgen_bouw7_name_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.name` | The name of this project file metadata. |
| `projectFileCategory_id` | `int64` | Project Bestandscategorie-ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.projectFileCategory.id` | The ID of the file category. |
| `projectFileCategory_name` | `varchar2` | Project Bestandscategorienaam | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.projectFileCategory.name` | The name of the file category. |
| `projectNumber` | `varchar2` | Projectnummer | [ ] | writable, `::ancestor.::ancestor.projectNumber` | The project number. |
| `reference` | `varchar2` | Reference | [ ] | writable, `::ancestor.::ancestor.reference` | The reference of the project. |
| `startDate` | `datetime` | Startdatum | [ ] | writable, `::ancestor.::ancestor.startDate` | Start date for the project. |
| `status_closesProject` | `char` | Status Sluit Project | [ ] | writable, `::ancestor.::ancestor.status.closesProject` | Whether or not this status closes a project. |
| `status_createdAt` | `datetime` | Status Aangemaakt op | [ ] | writable, `::ancestor.::ancestor.status.createdAt` | The creation time of the entity. |
| `status_createdBy` | `varchar2` | Status Gemaakt door | [ ] | writable, `::ancestor.::ancestor.status.createdBy` | The user that created the entity. |
| `status_id` | `int64` | Status-ID | [ ] | writable, `::ancestor.::ancestor.status.id` | The ID of the status. |
| `status_invoicesProject` | `char` | Status Factureert Project | [ ] | writable, `::ancestor.::ancestor.status.invoicesProject` | Whether or not this status invoices a project. |
| `status_name` | `varchar2` | Statusnaam | [ ] | writable, `::ancestor.::ancestor.status.name` | The name of the status. |
| `status_plansProject` | `char` | Status Plant Project | [ ] | writable, `::ancestor.::ancestor.status.plansProject` | Whether or not this status plans a project. |
| `status_updatedAt` | `datetime` | Status geüpdatet op | [ ] | writable, `::ancestor.::ancestor.status.updatedAt` | The last updated time of the entity. |
| `status_updatedBy` | `varchar2` | Status Bijgewerkt door | [ ] | writable, `::ancestor.::ancestor.status.updatedBy` | The user that last updated the entity. |
| `streetName` | `varchar2` | Straatnaam | [ ] | writable, `::ancestor.::ancestor.streetName` | The street name for the project. |
| `updatedAt` | `datetime` | Bijgewerkt op | [ ] | writable, `::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedAt_2` | `datetime` | Bijgewerkt op | [ ] | writable, `::ancestor.::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedAt_3` | `datetime` | itgen_bouw7_updatedat_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Bijgewerkt door | [ ] | writable, `::ancestor.updatedBy` | The user that last updated the entity. |
| `updatedBy_2` | `varchar2` | Bijgewerkt door | [ ] | writable, `::ancestor.::ancestor.updatedBy` | The user that last updated the entity. |
| `updatedBy_3` | `varchar2` | itgen_bouw7_updatedby_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.updatedBy` | The user that last updated the entity. |
| `zipCode` | `varchar2` | Postcode | [ ] | writable, `::ancestor.::ancestor.zipCode` | The zip code for the project. |


## Release Notes

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

- [Bouw7](/nl/release-notes/drivers?driver=bouw7)
