api_project_services

⚠️ Important: Some fields in this table will be deprecated on Wednesday, January 7th, 2025. Please review the Deprecated Fields section below and migrate to the recommended alternatives.

This table provides project service data from Simplicate.

Description

The api_project_services table exposes project service entities, which represent the individual services configured within a project.

Fields

Field Name	Type	Description
project_service_id	Integer	Unique identifier for the project service
project_id	Integer	Identifier of the parent project
revenue_group_id	Integer	Identifier of the revenue group for categorization
project_service	String	Name of the project service
default_service	String	Default name template for this type of service
service_number	String	Human-readable service number or code
project_service_invoice_method	String	Method used for invoicing this service (e.g., hours, fixed price)
project_service_subscription_cycle	String	Billing cycle for subscription-based services (e.g., monthly, quarterly, half_year, yearly)
is_active	String	Indicator whether the project service is active or inactive
should_not_invoice_value	Numeric	Flag indicating if the value should not be invoiced (1=do not invoice, 0=invoice)
tracking_budget_enabled	Numeric	Whether budget tracking is enabled for this service (1=enabled, 0=disabled)
progress	Numeric	Progress percentage of the project service (0-100)
project_service_created_at	Date	Date when the project service was created

Deprecated Fields

⚠️ Deprecation Notice: The following fields will be deprecated on Wednesday, January 7th, 2025. Please migrate to the recommended alternatives.

Deprecated Field	Type	Recommended Alternative
key_projectsservice_id	Integer	project_service_id
key_project_id	Integer	project_id
key_revenue_group_id	Integer	revenue_group_id
project_service_name	String	project_service
default_service_name	String	default_service
invoice_method	String	project_service_invoice_method
subscription_cycle	String	project_service_subscription_cycle
has_tracking_budget	Numeric	tracking_budget_enabled
create_date	Date	project_service_created_at

Related Tables

• api_projects - Project details via project_id
• api_revenuegroups - Revenue group details via revenue_group_id
• api_project_service_hour_budgets - Hour budgets via project_service_id
• api_project_service_cost_budgets - Cost budgets via project_service_id
• api_project_service_costs - Costs via project_service_id
• api_project_service_date_facts - Daily facts via project_service_id
• api_time_registrations - Time registrations via project_service_id
• api_project_assignments - Assignments via project_service_id