Skip to main content

Table api_project_service_cost_budgets

The api_project_service_cost_budgets table exposes cost budget information configured for project services, broken down by item type.

Prosper Rabo avatar
Written by Prosper Rabo
Updated this week

⚠️ 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.

Fields

Field Name

Type

Description

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)

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 via project_id

  • api_project_services - Service details via project_service_id

  • api_item_types - Item type details via item_type_id

Did this answer your question?