---
title: "Project Control Suite data model"
slug: "bc-project-control-suite-data-model"
description: "Explore how Microsoft Dynamics 365 Business Central manages project planning with Budget, Billable, and Planning lines, optimizing your industrial equipment manufacturing."
updated: 2026-06-25T09:59:10Z
published: 2026-06-25T09:59:10Z
canonical: "docs.staedean.com/bc-project-control-suite-data-model"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Project Control Suite data model

Project, task, and details are stored in table 1003: **ProjectPlanning Line**. Microsoft Dynamics 365 Business Central recognizes three types of that line: **Budget**, **Billable**, and **Both Budget and Billable**.

Because Industrial Equipment Manufacturing (JMS) clearly separates budget, planning, and billing, an additional type has been added: **Planning**. The **Both Budget and Billable** type is hidden. Industrial Equipment Manufacturing previously had separate tables for budget and billing lines; these no longer exist.

The **Copy Budget to Planning** action copies a planning line of the type **Budget** to a new planning line of the type **Planning** by changing the type.

Table 1003 can grow quite large. To accommodate this, the following archiving rules apply:

- When a project quote is converted to an order, only the active budget is copied. All other budget versions are archived.
- When a project is completed, all planning line types are archived.

![Project Control Suite Data Model](https://cdn.document360.io/da662430-6a41-47b1-8c7e-7e4ac37a9756/Images/Documentation/Datamodel.png)

In Industrial Equipment Manufacturing, the planning line has three types: **Budget**, **Billable**, and **Planning**. The line type is not editable but is set per page:

- In the **Budget Lines** page, you can only create lines of the type **Budget**.
- In the **Planning Lines** page, you can only create lines of the type **Planning**.
  - Planning lines are also created by the **Copy to Planning Lines** action.
- In the **Billable Lines** page, you can only create lines of the type **Billable**.
  - Billable lines are also created by the **Initialize** action that breaks down a contract amount.
  - Billable lines are also created when usage is posted in a project with invoicing method **Time and Material**.

## Related

- [Design details](/bc-design-details-pcs.md)
- [Project Control Suite](/bc-project-control-suite.md)