api_project_service_cost_budgets
⚠️ 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 cost budget data for project services from Simplicate.
Description
The api_project_service_cost_budgets table exposes cost budget information configured for project services, broken
down by item type.
Fields
| Field Name | Type | Description |
|---|---|---|
project_id | Integer | Identifier of the project (composite key) |
project_service_id | Integer | Identifier of the project service (composite key) |
item_type_id | Integer | Identifier of the item type (cost type) (composite key) |
budget_amount | Numeric | Budgeted quantity or amount for this cost type |
budget_purchase_value | Numeric | Budgeted purchase value (cost to the organization) |
budget_selling_value | Numeric | Budgeted selling value (revenue from 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_project_id | Integer | project_id |
key_project_service_id | Integer | project_service_id |
key_item_type_id | Integer | item_type_id |
Related Tables
api_projects- Project details viaproject_idapi_project_services- Service details viaproject_service_idapi_item_types- Item type details viaitem_type_id