Microsoft Dynamics AX (Archived)

EcoResProduct (sys) - Table

(0) Share

Report

Posted on by Community Member

Hi Community,

the table "EcoResProduct" is that the table where all the products of a Company are recorded ?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Lee Bailey 340 on at

Like (1)

Report

The EcoResProduct table is the base table in the Product Master hierarchy of tables . Your product masters are stored here for your entire organization and you then release these products masters to your various legal entities in the form of Released Products.

Was this reply helpful? Yes No
Suggested answer

Amir Kaftari 210 on at

Like (1)

Report
Hi Khashayar .

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

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (1)

Report

Hi Khashayar

The EcoResProduct table stores products and is the base table in the products hierarchy.

AX uses new EcoRes... tables for product management. And most of these tables are inhereted from the other one. The base table is EcoResProduct. The items that's subtype is product master, is stored in EcoResProductMaster table. And the variants of this products are stored in EcoResDistinctProductVariant table.

The items that's subtype is product is stored in EcoResDistinctProduct table. There is no "product subtype" field in any table. The "Product subtype" field indicates which type of record you're looking at (method EcoResProduct.productSubtype) - This just returns the type based on the value of the instanceRelationType, which determines the specific record type within the table hierarchy.

Actually, it is not possible to change product subtype. You have to check these tables:

-EcoResProductMaster

-EcoResDistinctProductVariant

-EcoResDistinctProduct

For more details you can read this whitepaper:

technet.microsoft.com/.../hh272877.aspx

Best regards,Hossein

Was this reply helpful? Yes No