Restricted tables requiring Dynamics 365 licenses

App makers, who are building custom apps, can use all of the Microsoft Dataverse tables available within Common Data Model to create apps and flows for users who have any version of Power Apps and Power Automate license.

However, a smaller set of tables tied to Dynamics 365 apps (Dynamics 365 Sales, Customer Service, Field Service, Marketing, or Project Service Automation) require canvas and model-driven app users to have a license for the corresponding Dynamics 365 app if they need to create, update, or delete rows within the tables. These are referred to as restricted tables.

Tables may be restricted to a Dynamics 365 app license for the following reasons:

• The table is used to store and maintain product-specific configuration data that should typically be not used outside of the application.
• The table is accompanied by advanced logic that creates and maintains data in a specific way when used within a Dynamics 365 product.

If an app or flow only reads information from a table, a Dynamics 365 app license is not required and an appropriate Power Apps or Power Automate license is all that's needed.

Restricted tables for create, update, and delete operations

The following table lists the restricted tables and the associated Dynamics 365 license requirements for users who create, update, or delete data stored within these tables.

Note

Dynamics 365 Customer Engagement Plan and Dynamics 365 Plan licenses are no longer available for purchase and is referenced here only for the benefit of existing customers who have bought these licenses in the past.

Table	Logical name	License required
Actual	msdyn_actual	Dynamics 365 for Field Service or Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Agreement Business Process	msdyn_bpf_baa0a411a239410cb8bded8b5fdd88e3	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Booking journal	msdyn_bookingjournal	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Booking Setup Metadata	msdyn_bookingsetupmetadata	Dynamics 365 for Field Service or Dynamics 365 for Project Service Automation or Dynamics 365 for Customer Service Enterprise edition or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Booking timestamp	msdyn_bookingtimestamp	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Case1	incident	Dynamics 365 for Customer Service Professional edition or Dynamics 365 for Customer Service Enterprise edition or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Case to Work Order Business Process	msdyn_bpf_989e9b1857e24af18787d5143b67523b	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Configuration	msdyn_configuration	Dynamics 365 for Field Service or Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Entitlement	entitlement	Dynamics 365 for Customer Service, Enterprise edition or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Estimate Line	msdyn_estimateline	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Estimate	msdyn_estimate	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Fact	msdyn_fact	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Field service setting	msdyn_fieldservicesetting	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Field Service System Job	msdyn_fieldservicesystemjob	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Goal	goal	Dynamics 365 for Sales Professional, or Dynamics 365 for Sales, Enterprise edition, or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Inventory Journal	msdyn_inventoryjournal	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Invoice Process	msdyn_bpf_d8f9dc7f099f44db9d641dd81fbd470d	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Journey	journey	Dynamics 365 for Marketing or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Knowledge article	knowledgearticle	Dynamics 365 for Customer Service, Enterprise edition or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Organizational Unit	msdyn_organizationalunit	Dynamics 365 for Field Service or Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Product Inventory	msdyn_productinventory	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Project Parameter	msdyn_projectparameter	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Project Stages	msdyn_bpf_665e73aa18c247d886bfc50499c73b82	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Project Task Dependency	msdyn_projecttaskdependency	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Project Task	msdyn_projecttask	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Project Team Member	msdyn_projecteam	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Purchase Order Business Process	msdyn_bpf_2c5fe86acc8b414b8322ae571000c799	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Resource Assignment Detail (Deprecated)	msdyn_resourceassignmentdetail	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Resource Assignment	msdyn_resourceassignment	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Resource Restriction (Deprecated)	msdyn_workorderresourcerestriction	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Routing rule set	routingrule	Dynamics 365 for Customer Service, Enterprise edition or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Schedule Board Setting	msdyn_scheduleboardsetting	Dynamics 365 for Field Service or Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Scheduling Parameter	msdyn_schedulingparameter	Dynamics 365 for Field Service or Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
SLA	sla	Dynamics 365 for Customer Service Professional edition or Dynamics 365 for Customer Service Enterprise edition or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
System User Scheduler Setting	msdyn_systemuserschedulersetting	Dynamics 365 for Field Service or Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Transaction Connection	msdyn_transactionconnection	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Transaction Origin	msdyn_transactionorigin	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Transaction Type	msdyn_transactiontype	Dynamics 365 for Project Service Automation or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Unique Number	msdyn_uniquenumber	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Work Order2	msdyn_workorder	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan
Work Order Details Generation Queue (Deprecated)	msdyn_workorderdetailsgenerationqueue	Dynamics 365 for Field Service or Dynamics 365 Customer Engagement plan or Dynamics 365 plan

[1] Case table actions permitted with only Power Apps, Power Automate, Power Pages or Microsoft Copilot Studio license:
Power Apps, Power Automate, or Copilot Studio licensed users can ‘create’ cases; can ‘read’, ‘update’ and ‘delete’ self-created cases to enable scenarios including employee self-service and case creation on behalf of customers. Power Apps, Power Automate, or Copilot Studio licensed users can only perform ‘read’ operation on cases created by other users. They cannot ‘update’, ‘resolve’, ‘route’, ‘close’,‘delete’,‘assign’,‘duplicate’, ‘merge’, ‘create child cases’ or perform any other custom operation on cases created by others. Users can't act as a customer service agent, can't manage cases.

[2] Work Order table requires Dynamics 365 for Field Service license in most scenarios except for users self-reporting issues (for example, an employee reporting a facilities issue) in which case creating, reading, updating, and deleting work orders is permitted with the Power Apps or Power Pages license. Users cannot complete/close work orders or act in a manner similar to that of performing or completing service.

Licensing

For more information on Power Apps, Power Automate, Power Pages, Copilot Studio, and Dynamics 365 licenses, see Licensing overview page.