News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Cannot locate table cu...

Finance | Project Operations, Human Resources, ...

Answered

Cannot locate table custdefaultrolelocation

(0) Share

Report

Report

Posted on by AstridMalanka

8

Hello,

I am trying to do an export of the tables I need to recreate Customers V3 to the datalake.

One of the last joins on the view that creates the entity is custdefaultrolelocation.

If I look into my dev machine I can see the table on the AXDB database, but when I try to look for it on the datalake export, I cannot find it.

Any ideas why?

Thanks

All responses Img

All responses (2)

Answers Img

Answers (0)

AstridMalanka 8 on at

Like (0)

Report

RE: Cannot locate table custdefaultrolelocation

thanks
Suggested answer

nunomaia 11 Super User 2024 Season 1 on at

Like (1)

Report

RE: Cannot locate table custdefaultrolelocation

CustDefaultRoleLocation is a view over tables DirPartyLocationRole, LogisticsLocationRole, DirPartyLocation and LogisticsLocation.

You need those tables to recreate view.

You can check View details in Application Explorer

Helpful resources

News and Announcements

Announcing Our 2025 Season 1 Super Users!

Announcing Forum Attachment Improvements!

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,853 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans