Inventory Size Details by Product

Inventory Size Details by Product

Submitted by Nathan Clouse on 10/04/15.

A view that shows Inventory Size Details by Product with details on the inventory size, if assigned, by product including the name and translated description.

AX Version: 

Module: 

CREATE view [dbo].[vw_pimProductSizes] as

select  'productRecId' = erp.recid,
		translate.languageId,
		ers.name,
		translate.description,
		erp.partition
from EcoResProductMasterDimensionValue value
inner join ecoResProduct erp 
	on erp.recid = value.sizeProductMaster 
	and value.partition = erp.partition
inner join EcoResSize ers 
	on ers.recid = value.size_ 
	and ers.partition = value.partition
left join EcoResProductMasterDimValueTranslation translate 
	on translate.productMasterDimensionValue = value.recid
	and translate.partition = value.partition
GO