Complex tables and licensing

Important

This topic is applicable only for older Power Apps Plan 1 and Plan 2 licenses.

Complex tables are applicable only for the older Power Apps Plan 1 and Plan 2 licenses, and not for the latest Power Apps per app and Power Apps per user plans.

For the latest information on licensing requirements for tables, see the Power Apps licensing guide.

Tables that include the following complex server-side logic require users of an app or flow that uses these tables to have a Power Apps Plan 2 or Power Automate Plan 2 license:

  • Code plug-ins. More information: Plug-in development

  • Real-time workflows. More information: Workflow processes

    Note

    Only workflows that are converted to a real-time workflow are considered real-time and synchronous. Workflows that are run in the background can still be used with the appropriate Power Apps plan and do not require additional licenses.

To know whether or not you've added complex business logic to your tables, review the list of plug-in assemblies and workflows configured in your environment.

Complex tables installed with Dynamics 365 apps

The following table lists tables that contain complex server-side logic out-of-the-box as part of the installation of customer engagement apps in Dynamics 365 (Dynamics 365 Sales, Customer Service, Field Service, Marketing, and Project Service Automation). This list is intended as a guide. Depending on the Dynamics 365 apps and versions installed in your environment, the list of complex tables may vary.

Note

If you are using the Microsoft Dataverse and have not installed a Dynamics 365 app or third-party solution, your environment won't have tables containing complex server-side logic.

  • Account
  • Agreement
  • Agreement Booking Date
  • Agreement Booking Incident
  • Agreement Booking Product
  • Agreement Booking Service
  • Agreement Booking Service Task
  • Agreement Booking Setup
  • Agreement Invoice Date
  • Agreement Invoice Product
  • Agreement Invoice Setup
  • Agreement Sub-Status
  • Bookable Resource
  • Bookable Resource Booking
  • Bookable Resource Booking Header
  • Bookable Resource Category
  • Bookable Resource Category Assn
  • Bookable Resource Characteristic
  • Bookable Resource Group
  • Booking Alert
  • Booking Alert Status
  • Booking Status
  • Characteristic
  • Competency Requirement (Deprecated)
  • Competitor
  • Contact
  • Customer Asset
  • Delegation
  • Expense
  • Field Computation
  • Field Service Price List Item
  • Filter
  • Follow
  • Incident Type
  • Incident Type Product
  • Incident Type Service
  • Incident Type Service Task
  • Integration Job
  • Integration Job Detail
  • Inventory Adjustment
  • Inventory Adjustment Product
  • Inventory Transfer
  • Invoice
  • Invoice Frequency
  • Invoice Line
  • Invoice Line Detail
  • Journal
  • Journal Line
  • Lead
  • Note
  • OData v4 Data Source
  • Opportunity
  • Opportunity Line
  • Opportunity Line Detail
  • Order
  • Order Invoicing Product
  • Order Invoicing Setup
  • Order Line
  • Payment
  • Payment Detail
  • Post Configuration
  • Post Rule Configuration
  • Postal Code
  • Price List
  • Price List Item
  • Product
  • Project
  • Project Approval
  • Project Contract Line Detail
  • Project Contract Line Milestone
  • Project Contract Line Resource Category
  • Project Contract Line Transaction Category
  • Project Parameter
  • Project Stages
  • Project Task Status User
  • Project Team Member Sign-Up
  • Purchase Order
  • Purchase Order Bill
  • Purchase Order Product
  • Purchase Order Receipt
  • Purchase Order Receipt Product
  • Purchase Order Sub Status
  • Queue Item
  • Quote
  • Quote Booking Incident
  • Quote Booking Product
  • Quote Booking Service
  • Quote Booking Service Task
  • Quote Booking Setup
  • Quote Invoicing Product
  • Quote Invoicing Setup
  • Quote Line
  • Quote Line Detail
  • Quote Line Milestone
  • Quote Line Resource Category
  • Quote Line Transaction Category
  • Quote Project Price List
  • Rating Model
  • Rating Value
  • Requirement Characteristic
  • Requirement Resource Category
  • Requirement Resource Preference
  • Requirement Status
  • Resource Request
  • Resource Requirement
  • Resource Requirement Detail
  • RMA
  • RMA Product
  • RMA Receipt
  • RMA Receipt Product
  • RMA Sub-Status
  • Role competency requirement
  • Role Price
  • RTV
  • RTV Product
  • RTV Sub-Status
  • Tax Code
  • Tax Code Detail
  • Time Entry
  • Time Group
  • Time Group Detail
  • Time Off Request
  • Transaction Category Price
  • User
  • View
  • Wall View
  • Warehouse
  • Work Order
  • Work Order Incident
  • Work Order Product
  • Work Order Service
  • Work Order Service Task
  • Work Order Sub-Status
  • Work template