---
title: "Data modeling studio metadata tables in D365 F&SCM"
slug: "data-modeling-studio-metadata-tables-in-d365-fscm"
tags: ["Concept", "Data Modeling Studio", "DMS"]
updated: 2026-03-20T11:26:48Z
published: 2026-03-20T17:44:45Z
canonical: "docs.staedean.com/data-modeling-studio-metadata-tables-in-d365-fscm"
---

> ## 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.

# Data modeling studio metadata tables in D365 F&SCM

In Data Modeling Studio, several metadata tables exist, which are used:

- On deploy.
- On deploy or export.
- In data modeling.

## Metadata tables used on deploy

For Data Modeling Studio, several metadata tables exist in D365 F&SCM that are used when you deploy a data model. Whether these tables are used is defined by the deployed data model.

These metadata tables are used on deploy:

- **Labels (CDPLabel)**: This table contains the labels from D365 F&SCM. On deploy, the **CDPLabelSTAGING** table is created in the target database. So, in the target database, the UI labels are shown instead of the technical names.
- **Enumerations (CDPEnumerations)**: This table contains the enum value names from D365 F&SCM. On deploy, the **CDPEnumerationsSTAGING** table is created in the target database. So, in the target database, the enum value names are shown instead of the enum value numbers.
- **Data dictionary (CDPDictionary)**: This table contains all D365 F&SCM tables. On deploy, the **CDPEnumerationsSTAGING** table is created in the target database.

## Metadata table used on deploy and export

For Data Modeling Studio, the **Entity export status (CDPEntityExportStatus)** table exists in D365 F&SCM that is used when you deploy a data model or export data. Whether this table is used is defined by the **Entity export status** parameter.

If in the **Data modeling studio parameters**, the **Entity export status** field is set to '**Yes**', on:

- Deploy, the **CDPEntityExportStatusSTAGING** table is created in the target database. It is also filled with the data that exists in the **CDPEntityExportStatus** table in D365 F&SCM.
- Data export, for each table for which data is exported, the export status and related dates are set in the **CDPEntityExportStatus** table in D365 F&SCM and the **CDPEntityExportStatusSTAGING** table in the target database.

## Metadata tables used in data modeling

In Data Modeling Studio, several metadata tables exist in D365 F&SCM, which are used in data modeling:

- **Tables (CDPExcludedTables)** and **(CDPDataModelTableList)**: The **CDPExcludedTables** table lists all tables that are used in data sets. these tables are excluded from selection on data set creation. The **CDPDataModelTableList** table lists all non-staging D365 F&SCM tables. These tables together define the tables that you can enter or select on data set creation.
- **Forms (CDPFormsNameTable)**: This table is used to define what is shown in the lookup of the **Form labels filled** on the **Design data set** page. The table contains all form names and captions of non-CDP tables in D365 F&SCM.
- **Master data tables relations (CDPMasterDataProfilesRelationTable)**: This table is used to define the **Available** fields for the selected entity on the **Master data profile design** page. For these entities, data is stored in the **CDPMasterDataProfilesRelationTable** table:
  - **Customer**: Information of the **CustTable** table and of the tables that are linked to the **CustTable** form.
  - **Vendor**: Information of the **VendTable** table and of the tables that are linked to the **VendTable** form.
  - **Product**: Information of the **EcoResProductDetailsExtended** table and **InventTable** table and of the tables that are linked to the main forms for these tables.
  - **Employee**: Information of the **HcmWorker** table and of the tables that are linked to the **HcmWorker** form.

## Update metadata

For the Data Modeling Studio metadata tables, the data is collected in D365 F&SCM and stored in these tables in D365 F&SCM.

On deploy or export, for some of these metadata tables, the data is taken from these metadata tables in D365 F&SCM. For other metadata tables, the data is used in data modeling.

It is important to keep the data in the metadata tables up-to-date. To update the metadata in the metadata tables in D365 F&SCM, on the Data Modeling Studio parameters page, on the Metadata synchronization tab, click Update metadata.

> [!NOTE]
> Note
> 
> Make sure to update the metadata tables after each change or creation of a data model.

## Related

- [Set up data models](/set-up-data-models.md)
- [Update metadata](/update-metadata.md)
- [Set up metadata synchronization parameters](/set-up-metadata-synchronization-parameters.md)
- [Create data model](/create-data-model.md)