# DeletedProjects: Bouw7 Deleted Projects Returns a list of deleted projects associated with the organization. Returns a list of deleted projects associated with the organization. - Catalog: `Bouw7` - Schema: `Project` - Label: Deleted Projects This is a read-only table. 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. ## Table Columns The columns of the table `DeletedProjects` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `contact_email` | `varchar2` | Contact Email | ☐ | The email address. | | `contact_id` | `int64` | Contact ID | ☐ | ID of contact. | | `contact_isVatShifted` | `char` | Contact Is VAT Shifted | ☐ | Whether VAT is shifted for the contact. | | `contact_name` | `varchar2` | Contact Name | ☐ | Name of contact. | | `contact_phoneNumber` | `varchar2` | Contact Phone Number | ☐ | The phone number of the contact. | | `deletedAt` | `varchar2` | Deleted at | ☐ | The date the project was deleted in ATOM format. | | `deletedBy_id` | `int64` | Deleted by ID | ☐ | ID of the user. | | `deletedBy_username` | `varchar2` | Deleted by User Name | ☐ | The username of the user. | | `fullProjectNumber` | `varchar2` | Full Project Number | ☐ | The full project number including year. | | `id` | `int64` | ID | ☐ | The ID of the project. | | `name` | `varchar2` | Name | ☐ | The name of the project. | | `status_closesProject` | `char` | Status Closes Project | ☐ | Whether or not this status closes a project. | | `status_createdAt` | `datetime` | Status Created at | ☐ | The creation time of the entity. | | `status_createdBy` | `varchar2` | Status Created by | ☐ | The user that created the entity. | | `status_id` | `int64` | Status ID | ☐ | The ID of the status. | | `status_invoicesProject` | `char` | Status Invoices Project | ☐ | Whether or not this status invoices a project. | | `status_name` | `varchar2` | Status Name | ☐ | The name of the status. | | `status_plansProject` | `char` | Status Plans Project | ☐ | Whether or not this status plans a project. | | `status_updatedAt` | `datetime` | Status Updated at | ☐ | The last updated time of the entity. | | `status_updatedBy` | `varchar2` | Status Updated by | ☐ | The user that last updated the entity. |