How do I join SalesSalesTaxItemGroupCode column to EcoResProduct table?

(0) Share

Report

Posted on by agneum

150

I have a view that joins InventTable to EcoResProduct, EcoResProductTranslation and InventItemGroupItem.
I now want to add a table that will show SalesSalesTaxItemGroupCode column, exactly as it is shown and exported in the "Released Products V2" entity.

Unfortunately I do not have access to Visual Studio or a development environment to see the joins, is there anyone who knows which table I can find the SalesSalesTaxItemGroupCode column in? And also, how it joins to one of the tables mentioned above?

All responses (2)

Answers (1)

agneum 150 on at

Like (0)

Report

RE: How do I join SalesSalesTaxItemGroupCode column to EcoResProduct table?

Hi,

Thank you for the prompt reply Girish. Your solution worked great!

I joined

dbo.InventTableModule ITM to dbo.InventTable IT on the following condition:

ITM.ItemId = IT.ItemId AND ITM.DataAreaId = IT.DataAreaId AND ITM.ModuleType = 2
Verified answer

GirishS 27,823 Moderator on at

Like (1)

Report

RE: How do I join SalesSalesTaxItemGroupCode column to EcoResProduct table?

Hi agneum,

I found that the SalesSalesTaxItemGroupCode field is coming from InventTableModule. On that table there will be field named ModuleType which is enum field which stores values against "Purch", "Sales","Invent".

Based on your requirement you can join InventTable with InventTableModule along with ModuleType to get SalesSalesTaxItemGroupCode field.

Thanks,

Girish S.