Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
Posted on by 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  

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 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,821 Super User 2024 Season 1 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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans