Some data from D365 MainAccountEntity not displaying in BYOD table

(0) Share

Report

Posted on by bluestar5000

I published the MainAccountEntity from D365FO to the BYOD in Azure SQL and did a data export. When I run a query against the MainAccountStaging table in BYOD, I find data appearing in most of the columns except for the ParentMainAccountID (which is blank). When I query the MainAccountEntity using management studio in AxDB, there are values showing in the ParentMainAccountID column.

Why are the values not showing in the ParentMainAccountID column in the MainAccountStaging table in BYOD?

Categories:

Data Integration

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

That field is specific to countries BR and MX (may be Brazil and Mexico), may be that could be the reason.

Was this reply helpful? Yes No