api_project_service_costs

⚠️ 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 cost registration data from Simplicate.

Description

The api_project_service_costs table exposes cost registrations on project services, including purchase and selling values.

Fields

Field Name	Type	Description
cost_id	Integer	Unique identifier for the cost registration
project_id	Integer	Identifier of the project
project_service_id	Integer	Identifier of the project service
item_type_id	Integer	Identifier of the item type (cost type)
invoice_id	Integer	Identifier of the invoice (if the cost has been invoiced)
employee_id	Integer	Identifier of the employee who registered the cost
date	Date	Date when the cost was incurred
flushed_at	Date	Date when the cost was flushed/processed for invoicing
reference	String	Reference text or description for the cost
cost_type	String	Type or category of the cost
invoice_status	String	Current invoicing status for this cost (e.g., not invoiced, invoiced)
cost_registration_type	String	Type of cost registration (e.g., expense, purchase)
amount	Numeric	Quantity or amount of the cost item
costs_purchase_value	Numeric	Purchase value (cost to the organization)
costs_selling_value	Numeric	Selling value (amount to be charged to the client)

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_cost_id	Integer	cost_id
key_project_id	Integer	project_id
key_project_service_id	Integer	project_service_id
key_item_type_id	Integer	item_type_id
key_invoice_id	Integer	invoice_id
key_employee_id	Integer	employee_id
item_type	String	cost_type

Related Tables

• api_projects - Project details via project_id
• api_project_services - Service details via project_service_id
• api_employees - Employee details via employee_id
• api_item_types - Item type details via item_type_id
• api_invoices - Invoice details via invoice_id