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

Notifications

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) / Table Detail For Relea...
Microsoft Dynamics AX (Archived)

Table Detail For Released Products in AX 2012 R2

(0) ShareShare
ReportReport
Posted on by Sathish Sivakumar 3,732

Hi,

Which is the Released Products Table in AOT?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hello Sathish,

    Please check InventTable.

    Thanks,

    Rommel

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Sathish,

    As Rommel answered, the InventTable is the base table for released product. There are more related tables. Some of them  do have an innerjoin on the form and are required to have a corresponding record.

    You can see all these tables in the data sources node of the form EcoResProductDetailsExtended.

  • Suggested answer
    Hossein.K Profile Picture
    Hossein.K 6,648 on at

    Hi Sathish,

    The base table is 'InventTable' and The other of the tables that affect it, are:

    ecoresproduct

    ecoresproducttranslation

    inventtable

    inventtabelmodule

    inventitemgroupitem

    EcoResTrackingDimensionGroupProduct

    EcoResTrackingDimensionGroupItem

    EcoResTrackingDimensionGroupFldSetup

    Thanks Hossein

  • Suggested answer
    Amir Kaftari Profile Picture
    Amir Kaftari 210 on at

    Hi Sathish.

    You can use this query for see Released product in Ax : 

    Sql Server :

select * from ECORESPRODUCT
inner join INVENTTABLE on ECORESPRODUCT.RECID = INVENTTABLE.PRODUCT
    

    

    X++ : 
select * from ECORESPRODUCT
join InventTable where Ecoresproduct.RecId == InventTable.Product 
    

    


     
    

    
                      
    
                    
    
                        
                        
    
                            





 





 










 





 






    
    
    
    
    
        
    
    
    


                        
    
                         
                      
                          
                       
                        
                            
                            
     
                              
                            
    
                            
                            
                            
                                
                            
                        
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
            
            
        
         
        
            
        
  • 
          
    
            
    
              
    
                
    
                  
    

                    
    
                    
                    
    
                        
                         
                    
    
                    
                      
    
                     
    
                        






 
    


 
    
    
    
    
    
    
    
    
    

        

    
    
        
        
    

    
        
     

       

        
            Community Member Profile Picture
        

    

  
                        
    
                            










 











 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
            
                
            
            
        
        
        

        
            
              
                Community Member
                
                
                 
                
                
             
         
            
                
                        
                 
            

    


 on  at 
                        
    
                    
    
                        
    
                        
    
                        
                          
                        
                      
    
                    
    
                  
    
                
    
              
    
              
    
                
    
                  
    
                    
    
                      
    
                        
    Thanks! which table have Units of products?
    

                      
    
                    
    
                        
                        
    
                            





 





 










 





 






    
    
    
    
    
        
    
    
    


                        
    
                         
                      
                          
                       
                        
                            
                            
     
                              
                            
    
                            
                            
                            
                                
                            
                        
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
      







 
                              
                            

                                

                                    

                                        
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

                



	
 

	

		

			
			
		

		

			

				
Responsible AI policies

				

					
As AI tools become more common, we’re introducing a Responsible AI Use…

				

			

		

	


	
 

	

		

			
			
		

		

			

				
Neeraj Kumar – Community Spotlight

				

					
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

				

			

		

	


	
 

	

		

			
				
		

		

			

				
Congratulations to the November Top 10 Community Leaders!

				

					
These are the community rock stars!

				

			

		

	



            

            
        


        
        




 





 


        

         
            
                











 





 






    
    
    
    

            
            
            

    



    
    
    
        
        
        
        
        
    
 

            
        

          
        
             
              
            
            
                
              
             
              

                        
Leaderboard > 🔒一 Microsoft Dynamics AX (Archived) 
 
                        
 
                         









 





 










 





 






 
























 





 









        
        
        
        
        
            
        

        

        
            
        

        
                

                    

                        
 
                            

                                
                                
                                
                                #1
                                
                                

                                    
                                         Priya_K Profile Picture
                                     
                                

                                

                                    

                                        























 





 












 





 


  











 





 












 





 









     


  

  
 
 
    
 


 
    

    
      
        
        

         

         
        
           
                
                
                
                
                    
                
            
            
        

        
        

        
            
              
                Priya_K
                4 
                
                
                 
                
             
         
            
                
                        
                 
            

    



                                    

                                

                            

                        

                    

                

                
        
  

        
        
        
        
        
            
        

        

        

        
                

                    

                        
 
                            

                                
                                
                                
                                #1
                                
                                

                                    
                                         Martin Dráb Profile Picture
                                     
                                

                                

                                    

                                        























 





 












 





 


  











 





 












 





 









     


  

  
 
 
    
 


 
    

    
      
        
        

         

         
        
           
                
                
                
                
                    
                
            
            
        

        
        

        
            
              
                Martin Dráb
                4 
                
                
                 
                
             
         
            
                
                        
                        
                             
                                
                                        
                                        Most Valuable Professional
                                        
                            
                         
                     
                 
            

    



                                    

                                

                            

                        

                    

                

                
        
  

        
        
        
        
        
            
        

        

        
            
            
        

        
                

                    

                        
 
                            

                                
                                
                                
                                #3
                                
                                

                                    
                                         Sukrut Parab Profile Picture
                                     
                                

                                

                                    

                                        























 





 












 





 


  











 





 












 





 









     


  

  
 
 
    
 


 
    

    
      
        
        

         

         
        
           
                
                
                
                
                    
                
            
            
        

        
        

        
            
              
                Sukrut Parab
                2 
                
                
                 
                
             
         
            
                
                        
                        
                             
                                
                                        
                                        Moderator
                                        
                            
                         
                     
                 
            

    



                                    

                                

                            

                        

                    

                

                
        
  


  
                         

                            Last 30 days
                            Overall leaderboard 
                        

              

               
            
        

        

    






    
    

        
Featured topics

    

    

  

        

            
Product updates
 
            

            Dynamics 365 release plans