Finance | Project Operations, Human Resources, ...

Upload Subsegment Entity by DMF & Form information

(0) Share

Report

Posted on by Alfi_al

Hi all, im trying to figure the right entities for Customer->Sales Demographic-> SUBSEGMENT(Scr 1) to upload that by DMF.

Also i'd really like to know what it means(see scr2) if i'll right click on SUBSEGMENT it will show me FORM INFORMATOIN (FORM NAME & CONTROL NAME) how can i find those tables?

Scr1:

ef4b6add_2D00_da4c_2D00_4b89_2D00_9e65_2D00_fc96ba9bac49.png

Scr2:

1bf15e5c_2D00_c677_2D00_4227_2D00_bf60_2D00_2e30a3c17b6d.png

Thanks in advance, i've blown my mind already to get the answers on that.

Kindly regards.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Alfi_al

You can use standard entity Customers V3 for export values for "Segment"/SALESSEGMENTID and "Subsegment"/SALESSUBSEGMENTID for customers:

In order to find tables for "Segment", you need first open form for "Segment", then click on more informastion and choose form name.

and then check query statement:

PS. The same applies for Sub segment

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

By the way, It does find standard entities for Segment and Sub segment that you can use also. They are as follows:

-Business segments

-Business subsegments

Was this reply helpful? Yes No
Alfi_al 10 on at

Like (1)

Report

I was looking for Customer instead of Customers, im silly=) Thank you so much for that.

Also What is this query statement is using for? I've never use it before but i know SQL and language is clear but i'm not sure how to use this tool?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (1)

Report

Hi Anatolii,

Query statement on a form name in D365FO indicates which table(s) and possibly joins existing on the form. You can use it to find the table id.

Was this reply helpful? Yes No