web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Query product dimensio...
Microsoft Dynamics AX (Archived)

Query product dimension like size,color and configuration in sql server side

(0) ShareShare
ReportReport
Posted on by B K Sharma 737

Hi Experts,

I want to access product dimensions like size,color and configuration in sql server side in ax 2012 but when i go to AOT and check that table used in this process is Extends some other tables and this tables does not exists in database.

How can i access extended table data at sql server side.

Thanks 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    What table are you talking about? It's easier to help if you provide more accurate information.

    EcoResSize, EcoResColor and EcoResConfiguration tables contain the information about size, color and configuration.

  • B K Sharma Profile Picture
    B K Sharma 737 on at

    Correct this tables contain the respective values of Size,Color and configuration and also accessible at DB side but issue is that how to relate EcoResColo, EcoResSize and EcoResConfig tables with the InventTable...because I have to fetch Product dimension and product variant at my BI reporting, There are Tables with name EcoResProductMasterColor, EcoResProductMasterSize and EcoResProductMasterConfiguration in Ax AOT but this are not available at DB side and this extends some other tables.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Check table EcoResProductMasterDimensionValue, that's the one that the ones you mention are extending.

    Please see this article for more clarification about table inheritance in AX vs real data model in SQL: mycsharpdeveloper.wordpress.com/.../why-companyinfo-dirperson-not-exists-in-sql-server-tables

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans