api_project_service_date_facts

⚠️ 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 daily fact data for project services from Simplicate.

Description

The api_project_service_date_facts table exposes time-series financial data for project services, including registered values, invoice values, and costs per date.

Fields

Field Name	Type	Description
project_service_date_fact_id	String	Unique identifier for the fact record
project_id	Integer	Identifier of the project
project_service_id	Integer	Identifier of the project service
revenue_group_id	Integer	Identifier of the revenue group
invoice_revenue_group_id	Integer	Identifier of the revenue group from the invoice
ps_revenue_group_id	Integer	Identifier of the revenue group from the project service
date	Date	Date of the fact record
project_service	String	Name of the project service
project_service_invoice_method	String	Method used for invoicing this service (e.g., hours, fixed price)
default_service	String	Default name template for this type of service
project_service_subscription_cycle	String	Billing cycle for subscription-based services (e.g., monthly, quarterly)
is_active	Boolean	Indicator whether the project service is active or inactive
progress	Numeric	Progress percentage of the project service (0-100)
registered_direct_value	Numeric	Direct registered value for this date
registered_declarable_value	Numeric	Declarable registered value for this date
correction_value	Numeric	Correction value for this date
invoice_value	Numeric	Invoice value for this date
costs_selling_value	Numeric	Selling value of costs for this date
costs_purchase_value	Numeric	Purchase value of costs for this date
flushed_costs_selling_value	Numeric	Flushed selling value of costs for this date
flushed_costs_purchase_value	Numeric	Flushed purchase value of costs for this date
total_registered_value_and_costs	Numeric	Total of registered declarable value, costs selling value, correction value, and flushed costs selling value for this date
balance	Numeric	Balance between total registered value/costs and invoice value for this date
invoiced_versus_registered	Numeric	Difference between invoice value and total registered value/costs for this date
costs_selling_value_with_corrections	Numeric	Selling costs with corrections applied for this date
registered_value	Numeric	Total registered value for this date

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
identifier	String	project_service_date_fact_id
key_project_id	Integer	project_id
key_project_service_id	Integer	project_service_id
key_revenue_group_id	Integer	revenue_group_id
key_invoice_revenue_group_id	Integer	invoice_revenue_group_id
key_ps_revenue_group_id	Integer	ps_revenue_group_id
ps_project_service_name	String	project_service
ps_invoice_method	String	project_service_invoice_method
ps_default_service_name	String	default_service
ps_subscription_cycle	String	project_service_subscription_cycle
ps_is_active	Boolean	is_active
ps_progress	Numeric	progress

Related Tables

• api_projects - Project details via project_id
• api_project_services - Service details via project_service_id
• api_revenuegroups - Revenue group details via revenue_group_id