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, ... 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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

nunomaia 25 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

thanks

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... 512 Super User 2026 Season 1

#2

Giorgio Bonacorsi 386

#3

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans