web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Where can I find the C...
Finance | Project Operations, Human Resources, ...
Answered

Where can I find the Custom Fields created in HcmWorker Table?

(0) ShareShare
ReportReport
Posted on by davidmvg 15

Hi,

We used the Export to Datalake Feature in F&O to export system tables to our DataWarehouse.

There are a couple of Custom fields that have been created in the table HcmWorker. (Image below from the systembrowser)

pastedimage1675872982024v1.png

Does anyone know where are they stored in the system in the backend?

A bit of urgency here, any help is apricated  

Categories:
Other
Financial Management
Administration and Setup
I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,862 Test role Public on at
    RE: Where can I find the Custom Fields created in HcmWorker Table in D365F&O?

    Hi David,

    As the field names have a suffix '_Custom', I think they are not created in Visual Studio, but configured in the application. Are these fields created as custom fields via the user interface? If so, still like Girish mentioned, the data entities need to get the same fields as well. More information about adding the configurable custom fields can be found on my blog: Custom fields: Handle with care (Microsoft Dynamics 365 for Finance and Operations) (dynamicspedia.com)

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,799 Moderator on at
    RE: Where can I find the Custom Fields created in HcmWorker Table in D365F&O?

    Hi David Molina,

    Extension fields will be store against the HcmWorker table only.

    In visual studio it will be available under  Data model >> Table extensions >> HcmWorker.ModelName.

    But it will be clubbed against the HcmWorker table only - There wont be any separate tables.

    If you are referring to entity then you must extend the entity and add your custom fields to it.

    Thanks,

    Girish S.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Private forums Quick links

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Last month Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans