Finance | Project Operations, Human Resources, ...

Data entity and staging table

(0) Share

Report

Posted on by Yuji

4,131

Hi expert,

Where can we specify the mapping between staging field and target field? I looked at the AOT, I could not figure out how the system will know which staging field maps the target field?

Thanks,

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (1)

Report

Hi Yuji,

the system does the mapping automatically according to the field names. So your staging field should have the same name than the entity field, then the system will map it automatically when you generate mapping in the Data entity form in D365.

If the field names are different (which makes no sense) you have to do the mapping manually in D365 - it can't be done in the AOT.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Yuji,

You can get a better overview of staging field and target fields for data entities (Workspaces > Data management > Data entities) by checking model mapping for each entity.

Was this reply helpful? Yes No
AliHadi 5 on at

Like (0)

Report

Hi Nikolaos,

How would the data from the Excel file know where to go in the staging table? I understand the mapping is done from staging table to the data entity which is automatic. But how to map data columns in excel file to the staging? I am new to D365.

Thanks for the help

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report

Hi Alihadi,

When you create an import project in DIXF, as soon as the entity is selected , an option to 'Upload file' is displayed.

If your excel has used the field names as entity fields, the mapping would be done automatically by the system.

If not, an warning message will be displayed when the upload is completed. Click on 'View Map' in the project , where you are map the fields manually to the staging fields.

Was this reply helpful? Yes No