# ProjectServices: Simplicate Project Services Fetches all services Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Projects` - Primary Keys: `id` - Label: Project Services ## Table Columns The columns of the table `ProjectServices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `float` | Amount | ☐ | | | `budget_financial_hours` | `string` | Financial Budget (hours) | ☐ | | | `budget` | `float` | Budget | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `default_service_id` | `string` | Default Service ID | ☐ | | | `end_date` | `string` | End Date | ☐ | | | `expected_invoice_date` | `string` | Expected Invoice Date | ☐ | | | `explanation` | `string` | Explanation | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_date` | `string` | Invoice Date | ☐ | | | `invoice_in_installments` | `boolean` | Invoice in Instalments | ☐ | | | `invoice_method` | `string` | Invoice Method: | ☐ | | | `name` | `string` | Name | ☐ | | | `price` | `float` | Price | ☐ | | | `project_id` | `string` | Project ID | ☐ | | | `related_service_id` | `string` | Related Service ID | ☐ | | | `revenue_group_id` | `string` | Revenue Group ID | ☐ | | | `revenue_group_label` | `string` | Revenue Group Label | ☐ | | | `service_number` | `string` | Service Number | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `status` | `string` | Status | ☐ | | | `subscription_cycle` | `string` | Subscription Cycle | ☐ | | | `track_cost` | `boolean` | Track Costs | ☐ | | | `track_hours` | `boolean` | Register Hours | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `use_in_resource_planner` | `boolean` | Use in Resource Planner | ☐ | | | `vat_class_code` | `string` | VAT Class Code | ☐ | | | `vat_class_id` | `string` | VAT Class ID | ☐ | | | `vat_class_label` | `string` | VAT Class Label | ☐ | | | `vat_class_name` | `string` | VAT Class Name | ☐ | | | `vat_class_percentage` | `float` | VAT Class Percentage | ☐ | | | `write_hours_end_date` | `string` | Write Hours End Date | ☐ | | | `write_hours_start_date` | `string` | Write Hours Start Date | ☐ | |