# Projects: Bouw7 Projects
Returns a list of projects associated with the organization.
Returns a list of projects associated with the organization
- Catalog: `Bouw7`
- Schema: `Project`
- Label: Projects
This is a read-only table function. The Bouw7 API may not support changing the data or the Invantive UniversalSQL driver for Bouw7 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Bouw7 API.
## Parameters of Table Function
The following parameters can be used to control the behaviour of the table function `Projects`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
| Name | Data Type | Required | Default Value | Documentation |
|---|:---:|:---:|:---:|---|
| `q` | `` | ☐ | | A [Heimdall Query Language](https://heimdall.bouw7.nl/docs/query-language) string |
## Columns of Table Function
The columns of the table function `Projects` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `additionalWork` | `varchar2` | Additional Work | ☐ | Additional work for the project. |
| `branch_id` | `int64` | Branch ID | ☐ | The ID of the branch. |
| `branch_name` | `varchar2` | Branch Name | ☐ | The name of the branch. |
| `caC100` | `varchar2` | C100 | ☐ | |
| `caC101` | `varchar2` | C101 | ☐ | |
| `caC102` | `varchar2` | C102 | ☐ | |
| `caC15` | `varchar2` | C15 | ☐ | |
| `caC16` | `varchar2` | C16 | ☐ | |
| `caC17` | `varchar2` | C17 | ☐ | |
| `caC18` | `varchar2` | C18 | ☐ | |
| `caC19` | `varchar2` | C19 | ☐ | |
| `caC20` | `varchar2` | C20 | ☐ | |
| `caC21` | `varchar2` | C21 | ☐ | |
| `caC22` | `varchar2` | C22 | ☐ | |
| `caC23` | `varchar2` | C23 | ☐ | |
| `caC24` | `varchar2` | C24 | ☐ | |
| `caC25` | `varchar2` | C25 | ☐ | |
| `caC26` | `varchar2` | C26 | ☐ | |
| `caC27` | `varchar2` | C27 | ☐ | |
| `caC28` | `varchar2` | C28 | ☐ | |
| `caC29` | `varchar2` | C29 | ☐ | |
| `caC30` | `varchar2` | C30 | ☐ | |
| `caC31` | `varchar2` | C31 | ☐ | |
| `caC32` | `varchar2` | C32 | ☐ | |
| `caC33` | `varchar2` | C33 | ☐ | |
| `caC34` | `varchar2` | C34 | ☐ | |
| `caC35` | `varchar2` | C35 | ☐ | |
| `caC36` | `varchar2` | C36 | ☐ | |
| `caC37` | `varchar2` | C37 | ☐ | |
| `caC38` | `varchar2` | C38 | ☐ | |
| `caC39` | `varchar2` | C39 | ☐ | |
| `caC40` | `varchar2` | C40 | ☐ | |
| `caC41` | `varchar2` | C41 | ☐ | |
| `caC42` | `varchar2` | C42 | ☐ | |
| `caC43` | `varchar2` | C43 | ☐ | |
| `caC44` | `varchar2` | C44 | ☐ | |
| `caC45` | `varchar2` | C45 | ☐ | |
| `caC46` | `varchar2` | C46 | ☐ | |
| `caC47` | `varchar2` | C47 | ☐ | |
| `caC48` | `varchar2` | C48 | ☐ | |
| `caC49` | `varchar2` | C49 | ☐ | |
| `caC50` | `varchar2` | C50 | ☐ | |
| `caC51` | `varchar2` | C51 | ☐ | |
| `caC52` | `varchar2` | C52 | ☐ | |
| `caC53` | `varchar2` | C53 | ☐ | |
| `caC54` | `varchar2` | C54 | ☐ | |
| `caC55` | `varchar2` | C55 | ☐ | |
| `caC56` | `varchar2` | C56 | ☐ | |
| `caC57` | `varchar2` | C57 | ☐ | |
| `caC58` | `varchar2` | C58 | ☐ | |
| `caC59` | `varchar2` | C59 | ☐ | |
| `caC60` | `varchar2` | C60 | ☐ | |
| `caC61` | `varchar2` | C61 | ☐ | |
| `caC62` | `varchar2` | C62 | ☐ | |
| `caC63` | `varchar2` | C63 | ☐ | |
| `caC64` | `varchar2` | C64 | ☐ | |
| `caC65` | `varchar2` | C65 | ☐ | |
| `caC66` | `varchar2` | C66 | ☐ | |
| `caC67` | `varchar2` | C67 | ☐ | |
| `caC68` | `varchar2` | C68 | ☐ | |
| `caC69` | `varchar2` | C69 | ☐ | |
| `caC70` | `varchar2` | C70 | ☐ | |
| `caC71` | `varchar2` | C71 | ☐ | |
| `caC72` | `varchar2` | C72 | ☐ | |
| `caC73` | `varchar2` | C73 | ☐ | |
| `caC74` | `varchar2` | C74 | ☐ | |
| `caC75` | `varchar2` | C75 | ☐ | |
| `caC76` | `varchar2` | C76 | ☐ | |
| `caC77` | `varchar2` | C77 | ☐ | |
| `caC78` | `varchar2` | C78 | ☐ | |
| `caC79` | `varchar2` | C79 | ☐ | |
| `caC80` | `varchar2` | C80 | ☐ | |
| `caC81` | `varchar2` | C81 | ☐ | |
| `caC82` | `varchar2` | C82 | ☐ | |
| `caC83` | `varchar2` | C83 | ☐ | |
| `caC84` | `varchar2` | C84 | ☐ | |
| `caC85` | `varchar2` | C85 | ☐ | |
| `caC86` | `varchar2` | C86 | ☐ | |
| `caC87` | `varchar2` | C87 | ☐ | |
| `caC88` | `varchar2` | C88 | ☐ | |
| `caC89` | `varchar2` | C89 | ☐ | |
| `caC90` | `varchar2` | C90 | ☐ | |
| `caC91` | `varchar2` | C91 | ☐ | |
| `caC92` | `varchar2` | C92 | ☐ | |
| `caC93` | `varchar2` | C93 | ☐ | |
| `caC94` | `varchar2` | C94 | ☐ | |
| `caC95` | `varchar2` | C95 | ☐ | |
| `caC96` | `varchar2` | C96 | ☐ | |
| `caC97` | `varchar2` | C97 | ☐ | |
| `caC98` | `varchar2` | C98 | ☐ | |
| `caC99` | `varchar2` | C99 | ☐ | |
| `caCaProjectCheckbox` | `char` | CA Project Checkbox | ☐ | |
| `caCaProjectContact` | `varchar2` | CA Project Contact | ☐ | |
| `caCaProjectDatum` | `datetime` | CA Project Datum | ☐ | |
| `caCaProjectDatumtijd` | `datetime` | CA Project Datumtijd | ☐ | |
| `caCaProjectDropdown` | `varchar2` | CA Project Dropdown | ☐ | |
| `caCaProjectMedewerker` | `varchar2` | CA Project Medewerker | ☐ | |
| `caCaProjectTekstgebied` | `varchar2` | CA Project Tekstgebied | ☐ | |
| `caCaProjectTekstveld` | `varchar2` | CA Project Tekstveld | ☐ | |
| `category_code` | `varchar2` | Category Code | ☐ | The code for the category. |
| `category_id` | `int64` | Category ID | ☐ | The ID of the category. |
| `category_name` | `varchar2` | Category Name | ☐ | The name of the category. |
| `city` | `varchar2` | City | ☐ | The city of the project. |
| `contact_emailAddress` | `varchar2` | Contact Email Address | ☐ | The email address of the contact. |
| `contact_id` | `int64` | Contact ID | ☐ | The ID of the contact. |
| `contact_name` | `varchar2` | Contact Name | ☐ | The name of this contact. |
| `contact_type` | `varchar2` | Contact Type | ☐ | The type of this contact. |
| `contact_typeId` | `int64` | Contact Type ID | ☐ | The type ID of this contact. |
| `contactPerson_emailAddress` | `varchar2` | Contact Person Email Address | ☐ | The email address of the contact. |
| `contactPerson_id` | `int64` | Contact Person ID | ☐ | The ID of the contact. |
| `contactPerson_name` | `varchar2` | | ☐ | The name of this contact. |
| `contactPerson_type` | `varchar2` | | ☐ | The type of this contact. |
| `contactPerson_typeId` | `int64` | | ☐ | The type ID of this contact. |
| `countryCode` | `varchar2` | Country Code | ☐ | An ISO 3166-2 representation of the country. |
| `createdAt` | `datetime` | Created at | ☐ | The creation date of the object in ATOM/ISO-8601 format |
| `createdBy_id` | `int64` | Created by ID | ☐ | The ID of the user. |
| `createdBy_username` | `varchar2` | Created by User Name | ☐ | The username of the user. |
| `deliveryDate` | `datetime` | Delivery Date | ☐ | Delivery date for the project. |
| `division_description` | `varchar2` | Division Description | ☐ | The description of the division. |
| `division_exactDivisionId` | `varchar2` | Division Exact Division ID | ☐ | The division ID of an Exact Online environment. |
| `division_glAccountCode` | `varchar2` | Division General Ledger Account Code | ☐ | A default general ledger account code to use for sales related items. |
| `division_glAccountCodePurchase` | `varchar2` | Division General Ledger Account Code Purchase | ☐ | A default general ledger account code to use for purchase related items. |
| `division_id` | `int64` | Division ID | ☐ | The ID of the division. |
| `division_journalCode` | `varchar2` | Division Journal Code | ☐ | A default journal code to use for sales related items. |
| `division_journalCodePurchase` | `varchar2` | Division Journal Code Purchase | ☐ | A default journal code to use for purchase related items. |
| `endDate` | `datetime` | End Date | ☐ | End date for the project. |
| `executor_departmentId` | `int64` | Executor Department ID | ☐ | The ID of the department this employee is enrolled in. |
| `executor_exactSalaryFrequency` | `int64` | Executor Exact Salary Frequency | ☐ | The exact salary frequency of this employee. |
| `executor_firstName` | `varchar2` | Executor First Name | ☐ | The given name of this employee. |
| `executor_id` | `int64` | Executor ID | ☐ | The ID of the employee. |
| `executor_lastName` | `varchar2` | Executor Last Name | ☐ | The family name of this employee. |
| `fixedPrice` | `varchar2` | Fixed Price | ☐ | The fixed price of the project. |
| `fullProjectNumber` | `varchar2` | Full Project Number | ☐ | The full project number including year. |
| `houseNumber` | `varchar2` | House Number | ☐ | The house number for the project. |
| `id` | `int64` | ID | ☐ | The ID of the project. |
| `information` | `varchar2` | Information | ☐ | The information about the project. |
| `name` | `varchar2` | Name | ☐ | The name of the project. |
| `parentId` | `int64` | Parent ID | ☐ | The ID of the parent Project if this Project is a Subproject. |
| `projectLeader_departmentId` | `int64` | Project Leader Department ID | ☐ | The ID of the department this employee is enrolled in. |
| `projectLeader_exactSalaryFrequency` | `int64` | Project Leader Exact Salary Frequency | ☐ | The exact salary frequency of this employee. |
| `projectLeader_firstName` | `varchar2` | Project Leader First Name | ☐ | The given name of this employee. |
| `projectLeader_id` | `int64` | Project Leader ID | ☐ | The ID of the employee. |
| `projectLeader_lastName` | `varchar2` | Project Leader Last Name | ☐ | The family name of this employee. |
| `projectNumber` | `varchar2` | Project Number | ☐ | The project number. |
| `propertyAsset_id` | `int64` | Property Asset ID | ☐ | The ID of the property asset. |
| `propertyAsset_name` | `varchar2` | Property Asset Name | ☐ | The name of the property asset. |
| `reference` | `varchar2` | Reference | ☐ | The reference of the project. |
| `startDate` | `datetime` | Start Date | ☐ | Start date for the project. |
| `status_closesPlanning` | `char` | Status Closes Planning | ☐ | Whether the project planning is closed. |
| `status_closesProject` | `char` | Status Closes Project | ☐ | Whether this status denotes a closed-state of the project. |
| `status_id` | `int64` | Status ID | ☐ | The ID of the status. |
| `status_invoicesProject` | `char` | Status Invoices Project | ☐ | Whether this status denotes an invoiced-state of the project. |
| `status_name` | `varchar2` | Status Name | ☐ | The name of the status. |
| `status_plansProject` | `char` | Status Plans Project | ☐ | Whether this status denotes a planned-state of the project. |
| `streetName` | `varchar2` | Street Name | ☐ | The street name for the project. |
| `updatedAt` | `datetime` | Updated At | ☐ | The creation date of the object in ATOM/ISO-8601 format |
| `updatedBy_id` | `int64` | Updated by ID | ☐ | The ID of the user. |
| `updatedBy_username` | `varchar2` | Updated by User Name | ☐ | The username of the user. |
| `workPlanner_departmentId` | `int64` | Work Planner Department ID | ☐ | The ID of the department this employee is enrolled in. |
| `workPlanner_exactSalaryFrequency` | `int64` | Work Planner Exact Salary Frequency | ☐ | The exact salary frequency of this employee. |
| `workPlanner_firstName` | `varchar2` | Work Planner First Name | ☐ | The given name of this employee. |
| `workPlanner_id` | `int64` | Work Planner ID | ☐ | The ID of the employee. |
| `workPlanner_lastName` | `varchar2` | Work Planner Last Name | ☐ | The family name of this employee. |
| `zipCode` | `varchar2` | ZIP Code | ☐ | The zip code for the project. |