api_project_service_costs

Description

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

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)