Skip to main content

api_project_service_cost_budgets

Description

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

Fields

Field NameTypeDescription
project_idIntegerIdentifier of the project (composite key)
project_service_idIntegerIdentifier of the project service (composite key)
item_type_idIntegerIdentifier of the item type (cost type) (composite key)
budget_amountNumericBudgeted quantity or amount for this cost type
budget_purchase_valueNumericBudgeted purchase value (cost to the organization)
budget_selling_valueNumericBudgeted selling value (revenue from the client)
  • 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