# Projects: Simplicate Projects Fetches all projects Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Projects` - Primary Keys: `id` - Label: Projects ## Table Columns The columns of the table `Projects` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `abnormal_address` | `boolean` | Abnormal Address | ☐ | | | `abnormal_contact_id` | `string` | Abnormal Contact ID | ☐ | | | `abnormal_organization_id` | `string` | Abnormal Organisation ID | ☐ | | | `abnormal_person_id` | `string` | Abnormal Person ID | ☐ | | | `billable` | `boolean` | Billable | ☐ | | | `budget_costs_value_budget` | `float` | | ☐ | | | `budget_costs_value_spent` | `float` | | ☐ | | | `budget_hours_amount_budget` | `float` | | ☐ | | | `budget_hours_amount_spent` | `float` | | ☐ | | | `budget_hours_value_budget` | `float` | | ☐ | | | `budget_hours_value_spent` | `float` | | ☐ | | | `budget_total_value_budget` | `float` | | ☐ | | | `budget_total_value_invoiced` | `float` | | ☐ | | | `budget_total_value_spent` | `float` | | ☐ | | | `can_register_mileage` | `boolean` | Can Register Mileage | ☐ | | | `contact_id_2` | `string` | | ☐ | | | `contact_id` | `string` | Contact Person ID | ☐ | | | `contact_organization_id` | `string` | Contact Organisation ID | ☐ | | | `contact_organization_name` | `string` | Contact Organisation Name | ☐ | | | `contact_organization_relation_number` | `string` | | ☐ | | | `contact_person_full_name` | `string` | eiContact Person Full Name | ☐ | | | `contact_person_id` | `string` | Contact Person ID | ☐ | | | `contact_person_relation_number` | `string` | | ☐ | | | `copied_from_project_has_register_mileage_enabled` | `boolean` | | ☐ | | | `copied_from_project_id` | `string` | | ☐ | | | `copied_from_project_name` | `string` | | ☐ | | | `copied_from_project_organization_id` | `string` | | ☐ | | | `copied_from_project_organization_name` | `string` | | ☐ | | | `copied_from_project_organization_relation_number` | `string` | | ☐ | | | `copied_from_project_person_full_name` | `string` | | ☐ | | | `copied_from_project_person_id` | `string` | | ☐ | | | `copied_from_project_person_relation_number` | `string` | | ☐ | | | `copied_from_project_project_manager_amount` | `float` | | ☐ | | | `copied_from_project_project_manager_declarable` | `string` | | ☐ | | | `copied_from_project_project_manager_employee_id` | `string` | | ☐ | | | `copied_from_project_project_manager_id` | `string` | | ☐ | | | `copied_from_project_project_manager_name` | `string` | | ☐ | | | `copied_from_project_project_manager_person_id` | `string` | | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `copied_from_project_project_manager_tariff` | `float` | | ☐ | | | `copied_from_project_project_number` | `string` | | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `created` | `string` | Created | ☐ | | | `divergent_payment_term_days` | `int64` | Deviating Payment Term (days) | ☐ | | | `divergent_payment_term_id` | `string` | Deviating Payment Term ID | ☐ | | | `divergent_payment_term_method` | `string` | Deviating Payment Term Method | ☐ | | | `divergent_payment_term_name` | `string` | Deviating Payment Term Name | ☐ | | | `end_date` | `string` | End Date | ☐ | | | `hours_rate_type` | `string` | Hours Rate Type | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_reference` | `string` | Invoice Reference | ☐ | | | `is_invoice_approval` | `boolean` | Is Invoice Approval | ☐ | | | `is_reverse_billing` | `boolean` | Is Reverse Invoicing | ☐ | | | `modified` | `string` | Modified | ☐ | | | `my_organization_profile_id_2` | `string` | | ☐ | | | `my_organization_profile_id` | `string` | My Organisation Profile ID | ☐ | | | `my_organization_profile_organization_id` | `string` | | ☐ | | | `my_organization_profile_organization_name` | `string` | | ☐ | | | `my_organization_profile_organization_relation_number` | `string` | | ☐ | | | `name` | `string` | Name | ☐ | | | `note` | `string` | Note | ☐ | | | `organization_id_2` | `string` | | ☐ | | | `organization_id` | `string` | Organisation ID | ☐ | | | `organization_name` | `string` | Organisation Name | ☐ | | | `organization_relation_number` | `string` | | ☐ | | | `person_full_name` | `string` | Person Full Name | ☐ | | | `person_id_2` | `string` | | ☐ | | | `person_id` | `string` | Person ID | ☐ | | | `person_relation_number` | `string` | | ☐ | | | `project_manager_amount` | `float` | | ☐ | | | `project_manager_declarable` | `string` | | ☐ | | | `project_manager_employee_id` | `string` | | ☐ | | | `project_manager_id` | `string` | | ☐ | | | `project_manager_name` | `string` | | ☐ | | | `project_manager_person_id` | `string` | | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `project_manager_tariff` | `float` | | ☐ | | | `project_number` | `string` | Project Number | ☐ | | | `project_status_color` | `string` | Project Status Colour | ☐ | | | `project_status_id` | `string` | Project Status ID | ☐ | | | `project_status_label` | `string` | Project Status Label | ☐ | | | `separate_invoice_recipient_contact_id` | `string` | | ☐ | | | `separate_invoice_recipient_contact_organization_id` | `string` | | ☐ | | | `separate_invoice_recipient_contact_organization_name` | `string` | | ☐ | | | `separate_invoice_recipient_contact_organization_relation_number` | `string` | | ☐ | | | `separate_invoice_recipient_contact_person_full_name` | `string` | | ☐ | | | `separate_invoice_recipient_contact_person_id` | `string` | | ☐ | | | `separate_invoice_recipient_contact_person_relation_number` | `string` | | ☐ | | | `separate_invoice_recipient_is_separate_invoice_recipient` | `boolean` | | ☐ | | | `separate_invoice_recipient_organization_id` | `string` | | ☐ | | | `separate_invoice_recipient_organization_name` | `string` | | ☐ | | | `separate_invoice_recipient_organization_relation_number` | `string` | | ☐ | | | `separate_invoice_recipient_person_full_name` | `string` | | ☐ | | | `separate_invoice_recipient_person_id` | `string` | | ☐ | | | `separate_invoice_recipient_person_relation_number` | `string` | | ☐ | | | `simplicate_url` | `string` | Simplicate URL | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `timeline_email_address` | `string` | Timeline Email Address | ☐ | | | `updated_at` | `string` | Updated On | ☐ | |