<?xml version="1.0"?>
<SECTIONS>
	<EW_HEADER>
		<VERSION Number="2020.0.0.0"/>
		<VERSIONS>
			<DataProjectVersion>268</DataProjectVersion>
			<AppVersion>2020.0.0.31</AppVersion>
		</VERSIONS>
		<FILENAME>DuplicatedManufacturerpartInComponent_metric</FILENAME>
		<DESCRIPTION>
			<LANGUAGE xml:lang="en">Components using too many times the same manufacturer part</LANGUAGE>
			<LANGUAGE xml:lang="fr">Composants utilisant trop souvent la même référence constructeur</LANGUAGE>
			<LANGUAGE xml:lang="cs">Součásti používající příliš často stejný díl výrobce</LANGUAGE>
			<LANGUAGE xml:lang="de">Bauteile verwenden zu häufig dasselbe Hersteller-Teil</LANGUAGE>
			<LANGUAGE xml:lang="it">Componenti che utilizzano troppe volte lo stesso pezzo costruttore</LANGUAGE>
			<LANGUAGE xml:lang="ja">ｺﾝﾎﾟｰﾈﾝﾄが同じﾒｰｶｰの部品を使用する回数が多すぎます</LANGUAGE>
			<LANGUAGE xml:lang="ko">동일한 제조업체 파트를 너무 많이 사용한 부품</LANGUAGE>
			<LANGUAGE xml:lang="zh">设备使用相同设备型号的次数太多</LANGUAGE>
			<LANGUAGE xml:lang="pl">Komponenty wykorzystują zbyt często tę samą część producenta</LANGUAGE>
			<LANGUAGE xml:lang="pt">Componentes usando a mesma peça do fabricante muitas vezes</LANGUAGE>
			<LANGUAGE xml:lang="ru">Компоненты, слишком много раз использующие одну деталь производителя</LANGUAGE>
			<LANGUAGE xml:lang="es">Componentes que utilizan la misma referencia de fabricante demasiadas veces</LANGUAGE>
			<LANGUAGE xml:lang="tr">Aynı üretici parçasını çok fazla sayıda kullanan bileşenler</LANGUAGE>
			<LANGUAGE xml:lang="zh-tw">零組件使用相同的製造商設備型號太多次</LANGUAGE>
		</DESCRIPTION>
		<FILE_TYPE>10</FILE_TYPE>
		<OBJECT_TYPE>2</OBJECT_TYPE>
		<MEASURMENT>1</MEASURMENT>
		<Datatype>2</Datatype>
	</EW_HEADER>
	<QUERY>
		<FileData>
			<FileNameFormula/>
			<TZ_0>
				<LANGUAGE xml:lang="en">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="fr">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="cs">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="de">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="it">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ja">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ko">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pl">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pt">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ru">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="es">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="tr">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh-tw">REP_DESC</LANGUAGE>
			</TZ_0>
			<AutoFilterDesc>1</AutoFilterDesc>
		</FileData>
		<SQLQuery>SELECT 
query.countref AS countref
, query.com_tagpath AS com_tagpath
, query.bom_reference AS bom_reference
, query.bom_manufacturer AS bom_manufacturer
, query.loc_tagpath AS loc_tagpath
, query.true_com_id AS com_id
, query.true_loc_id AS loc_id
FROM
(
SELECT DISTINCT
 COUNT(bom_objectid) AS countref
 , tew_component.com_id  AS true_com_id
 , -1  AS true_loc_id
 , tew_component.com_id AS com_id
 , tew_component.com_tagpath AS com_tagpath
  , tew_buildofmaterial.bom_reference AS bom_reference
 , tew_buildofmaterial.bom_manufacturer AS bom_manufacturer
, tew_location.loc_tagpath AS loc_tagpath
 FROM 
    tew_buildofmaterial  
     LEFT JOIN tew_component ON (tew_component.com_id = tew_buildofmaterial.bom_objectid)
     LEFT JOIN tew_location ON (tew_location.loc_id = tew_component.com_loc_id)
  WHERE  (bom_objectid = com_id)
  GROUP BY tew_location.loc_tagpath, tew_component.com_id,  bom_manufacturer, bom_reference, tew_component.com_tagpath
UNION ALL
SELECT DISTINCT
 COUNT(bom_objectid) AS countref
 , -1  AS true_com_id
 , tew_location.loc_id  AS true_loc_id
 , tew_location.loc_id  AS com_id
 , null AS com_tagpath
  , tew_buildofmaterial.bom_reference AS bom_reference
 , tew_buildofmaterial.bom_manufacturer AS bom_manufacturer
, tew_location.loc_tagpath AS loc_tagpath
 FROM 
    tew_buildofmaterial  
     LEFT JOIN tew_location ON (tew_location.loc_id = tew_buildofmaterial.bom_objectid)
  WHERE (bom_objectid = tew_location.loc_id)
  GROUP BY  tew_location.loc_tagpath, tew_location.loc_id,  bom_manufacturer, bom_reference, tew_location.loc_tagpath
) AS query
WHERE countref &gt; 5
		</SQLQuery>
		<BreakFormula/>
		<ORDERS>
		</ORDERS>
		<ObjectType>1</ObjectType>
	</QUERY>
	<LAYOUT>
		<HeadingFormula>[AUTO]""</HeadingFormula>
		<IsHeadingVisible>1</IsHeadingVisible>
		<IsTitleVisible>1</IsTitleVisible>
		<IsHorzSeparationVisible>1</IsHorzSeparationVisible>
		<IsTotalVisible>0</IsTotalVisible>
		<COLUMNS>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Umístění/lokace</LANGUAGE>
					<LANGUAGE xml:lang="de">Montageort</LANGUAGE>
					<LANGUAGE xml:lang="en">Location</LANGUAGE>
					<LANGUAGE xml:lang="es">Situación</LANGUAGE>
					<LANGUAGE xml:lang="fr">Localisation</LANGUAGE>
					<LANGUAGE xml:lang="it">Ubicazione</LANGUAGE>
					<LANGUAGE xml:lang="ja">ロケーション</LANGUAGE>
					<LANGUAGE xml:lang="ko">위치</LANGUAGE>
					<LANGUAGE xml:lang="pl">Lokalizacja</LANGUAGE>
					<LANGUAGE xml:lang="pt">Localização</LANGUAGE>
					<LANGUAGE xml:lang="ru">Местоположение</LANGUAGE>
					<LANGUAGE xml:lang="tr">Konum</LANGUAGE>
					<LANGUAGE xml:lang="zh">位置</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">位置</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>0</columnIndex>
				<ContentFormula>loc_tagpath</ContentFormula>
				<GotoId>loc_id</GotoId>
				<GotoType>9</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>50.000000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Značka součásti</LANGUAGE>
					<LANGUAGE xml:lang="de">Bauteilkennzeichen</LANGUAGE>
					<LANGUAGE xml:lang="en">Component mark</LANGUAGE>
					<LANGUAGE xml:lang="es">Numeración de componente</LANGUAGE>
					<LANGUAGE xml:lang="fr">Repère de composant</LANGUAGE>
					<LANGUAGE xml:lang="it">Contrassegno componente</LANGUAGE>
					<LANGUAGE xml:lang="ja">コンポーネント マーク</LANGUAGE>
					<LANGUAGE xml:lang="ko">부품 표시</LANGUAGE>
					<LANGUAGE xml:lang="pl">Oznaczenie komponentu</LANGUAGE>
					<LANGUAGE xml:lang="pt">Tag do componente</LANGUAGE>
					<LANGUAGE xml:lang="ru">составляющий указатель</LANGUAGE>
					<LANGUAGE xml:lang="tr">Bileşen işareti</LANGUAGE>
					<LANGUAGE xml:lang="zh">设备标注</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">元件標注</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>1</columnIndex>
				<ContentFormula>com_tagpath</ContentFormula>
				<GotoId>com_id</GotoId>
				<GotoType>3</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>50.000000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Výrobce</LANGUAGE>
					<LANGUAGE xml:lang="de">Hersteller</LANGUAGE>
					<LANGUAGE xml:lang="en">Manufacturer</LANGUAGE>
					<LANGUAGE xml:lang="es">Fabricante</LANGUAGE>
					<LANGUAGE xml:lang="fr">Constructeur</LANGUAGE>
					<LANGUAGE xml:lang="it">Costruttore</LANGUAGE>
					<LANGUAGE xml:lang="ja">ﾒｰｶｰ</LANGUAGE>
					<LANGUAGE xml:lang="ko">제조업체</LANGUAGE>
					<LANGUAGE xml:lang="pl">Producent</LANGUAGE>
					<LANGUAGE xml:lang="pt">Fabricante</LANGUAGE>
					<LANGUAGE xml:lang="ru">Производитель</LANGUAGE>
					<LANGUAGE xml:lang="tr">Üretici</LANGUAGE>
					<LANGUAGE xml:lang="zh">制造商</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">製造商</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>2</columnIndex>
				<ContentFormula>bom_manufacturer</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>60.000000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Reference</LANGUAGE>
					<LANGUAGE xml:lang="de">Teilenummer</LANGUAGE>
					<LANGUAGE xml:lang="en">Reference</LANGUAGE>
					<LANGUAGE xml:lang="es">Referencia</LANGUAGE>
					<LANGUAGE xml:lang="fr">Référence</LANGUAGE>
					<LANGUAGE xml:lang="it">Riferimento</LANGUAGE>
					<LANGUAGE xml:lang="ja">参照</LANGUAGE>
					<LANGUAGE xml:lang="ko">참고</LANGUAGE>
					<LANGUAGE xml:lang="pl">Odniesienie</LANGUAGE>
					<LANGUAGE xml:lang="pt">Peça</LANGUAGE>
					<LANGUAGE xml:lang="ru">Образец</LANGUAGE>
					<LANGUAGE xml:lang="tr">Referans</LANGUAGE>
					<LANGUAGE xml:lang="zh">型号</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">參考</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>3</columnIndex>
				<ContentFormula>bom_reference</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>60.000000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Počet dílů výrobce</LANGUAGE>
					<LANGUAGE xml:lang="de">Anzahl der Hersteller-Teile</LANGUAGE>
					<LANGUAGE xml:lang="en">Number of manufacturer parts</LANGUAGE>
					<LANGUAGE xml:lang="es">Número de referencias del fabricante</LANGUAGE>
					<LANGUAGE xml:lang="fr">Nombre de références constructeur</LANGUAGE>
					<LANGUAGE xml:lang="it">Numero pezzi costruttore</LANGUAGE>
					<LANGUAGE xml:lang="ja">ﾒｰｶｰ部品の数</LANGUAGE>
					<LANGUAGE xml:lang="ko">제조업체 파트의 수</LANGUAGE>
					<LANGUAGE xml:lang="pl">Liczba części producenta</LANGUAGE>
					<LANGUAGE xml:lang="pt">Número de peças do fabricante</LANGUAGE>
					<LANGUAGE xml:lang="ru">Количество деталей производителя</LANGUAGE>
					<LANGUAGE xml:lang="tr">Üretici parçası sayısı</LANGUAGE>
					<LANGUAGE xml:lang="zh">设备型号数量</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">製造商設備型號數量</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>4</columnIndex>
				<ContentFormula>countref</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>30.000000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<BreakColumn>1</BreakColumn>
				<columnIndex>5</columnIndex>
				<ContentFormula>""</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter>,</EnumerationDelimiter>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>400.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>0</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
		</COLUMNS>
		<DefaultCodeLg>
		</DefaultCodeLg>
		<DefaultGoto/>
		<HorizontalCellMargin>-1</HorizontalCellMargin>
		<VerticalCellMargin>0</VerticalCellMargin>
	</LAYOUT>
	<VARIABLES/>
	<FONT>
		<HeadingFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>6.000000</RowHeight>
		</HeadingFont>
		<TitleFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
		</TitleFont>
		<ContentFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>7</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>6.000000</RowHeight>
		</ContentFont>
		<TotalFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>1</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>1</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>6.000000</RowHeight>
		</TotalFont>
	</FONT>
	<OPTIONS>
		<IsTxtOneArrayPerPage>1</IsTxtOneArrayPerPage>
		<DwgBOMHeight>245.000000</DwgBOMHeight>
		<DwgBOMWidth>380.000000</DwgBOMWidth>
		<IsReverseOrder>0</IsReverseOrder>
		<XDwgBOMOrigine>25.000000</XDwgBOMOrigine>
		<YDwgBOMOrigine>40.000000</YDwgBOMOrigine>
		<DwgHorzOffset>10.000000</DwgHorzOffset>
		<DwgVertOffset>10.000000</DwgVertOffset>
		<IsDwgOneArrayPerPage>0</IsDwgOneArrayPerPage>
		<IsDwgFollowingOnSameSheet>0</IsDwgFollowingOnSameSheet>
		<IsDwgOneArrayPerColumn>0</IsDwgOneArrayPerColumn>
		<TITLEBLOCK_NAME/>
		<OneArrayPerBundle>1</OneArrayPerBundle>
		<TakeIntoGeneratedFile>0</TakeIntoGeneratedFile>
		<MargeBetweenLabelAndTable>2.000000</MargeBetweenLabelAndTable>
		<UsePipeCharacter>1</UsePipeCharacter>
		<BreakTextIntoGeneratedFile>0</BreakTextIntoGeneratedFile>
	</OPTIONS>
	<FILTERS/>
</SECTIONS>
