api_project_services

Description

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

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	Formatted 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)
`fixed_price_amount`	Numeric	Fixed price amount for fixed-price services
`fixed_price_invoiced_amount`	Numeric	Amount already invoiced for fixed-price services
`project_service_created_at`	Date	Date when the project service was created