web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Do the fields name in ...

Finance | Project Operations, Human Resources, ...

Answered

Do the fields name in the entity and the staging table have to be the same?

(0) Share

Report

Report

Posted on by akshi

152

Hi

Do the fields name in the entity and the staging table have to be the same?
If so, why should they have the same name?

Mapping was done automatically, but what information is used for automatic mapping?

Please give me information.

Thanks.

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (2)

Verified answer

Martin Dráb 237,970 Most Valuable Professional on at

Like (0)

Report

I believe that field names (and no other information) is used to generate source mapping. Therefore if names weren't the same, they wouldn't be mapped automatically.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

They don't need to have the same name. But if they don't, then you have to define the mapping manually.

Was this reply helpful? Yes No
Anrini on at

Like (0)

Report

If the column names in the staging table and the file match, the system automatically establishes the mapping, based on the names. However, if the names differ, columns aren’t mapped automatically. In these cases, you must complete the mapping by selecting the View map option on the entity in the data job.

Data import and export jobs overview - Finance & Operations | Dynamics 365 | Microsoft Docs

Was this reply helpful? Yes No
akshi 152 on at

Like (0)

Report

Hi Martin

Thanks for info.

Was this reply helpful? Yes No
akshi 152 on at

Like (0)

Report

Hi Nikolaos

Thanks for info.

Was this reply helpful? Yes No
akshi 152 on at

Like (0)

Report

Hi Anrini

Thanks for the detailed explanation.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

André Arnaud de Cal... 456 Super User 2025 Season 2

#2

Martin Dráb 429 Most Valuable Professional

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans