<?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>AssignedPartNotUsed_Imperial</FILENAME>
		<DESCRIPTION>
			<LANGUAGE xml:lang="en">Manufacturer parts assigned to component but not used</LANGUAGE>
			<LANGUAGE xml:lang="fr">Références constructeur affectées au composant mais inutilisées</LANGUAGE>
			<LANGUAGE xml:lang="cs">Díly výrobce přiřazené k součásti, ale nepoužité</LANGUAGE>
			<LANGUAGE xml:lang="de">Hersteller-Teile sind Bauteil zugewiesen, werden aber nicht verwendet</LANGUAGE>
			<LANGUAGE xml:lang="it">Pezzi costruttore assegnati al componente ma non utilizzati</LANGUAGE>
			<LANGUAGE xml:lang="ja">ｺﾝﾎﾟｰﾈﾝﾄに割り当てられていても使用されていないﾒｰｶｰ部品</LANGUAGE>
			<LANGUAGE xml:lang="ko">부품에 할당되었으나 사용되지 않는 제조업체 파트</LANGUAGE>
			<LANGUAGE xml:lang="pl">Cześć producenta jest przypisana do komponentu, ale nie jest wykorzystana</LANGUAGE>
			<LANGUAGE xml:lang="zh">已分配至设备但未使用的制造商部件</LANGUAGE>
			<LANGUAGE xml:lang="pt">Peças do fabricante atribuídas ao componente, mas não utilizadas</LANGUAGE>
			<LANGUAGE xml:lang="ru">Детали производителя, назначенные компоненту, но не использованные</LANGUAGE>
			<LANGUAGE xml:lang="es">Las referencias de fabricante están asignadas al componente pero no se utilizan</LANGUAGE>
			<LANGUAGE xml:lang="tr">Bileşene atanan ancak kullanılmayan üretici parçaları</LANGUAGE>
			<LANGUAGE xml:lang="zh-tw">製造商設備型號已指定給設備但未使用</LANGUAGE>
		</DESCRIPTION>
		<FILE_TYPE>10</FILE_TYPE>
		<OBJECT_TYPE>2</OBJECT_TYPE>
		<MEASURMENT>0</MEASURMENT>
		<Datatype>0</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_2.com_tagpath AS com_tagpath 
, query_2.com_tag AS com_tag
, query_2.com_id AS com_id
, query_2.bom_manufacturer AS bom_manufacturer
, query_2.bom_reference AS bom_reference 
, query_2.bom_id AS bom_id 
, query_2.count_1 AS count_1
, query_2.count_2 AS count_2

 FROM
 (
  SELECT 
  query_1.com_tagpath AS com_tagpath
, query_1.com_tag AS com_tag
, query_1.com_id AS com_id
, query_1.bom_manufacturer AS bom_manufacturer
, query_1.bom_reference AS bom_reference
, query_1.count_1 AS count_1 
, query_1.bom_id AS bom_id
, COUNT (*) AS count_2
  FROM
  ( 
    SELECT 
     tew_component.com_tagpath AS com_tagpath
   , tew_component.com_tag AS com_tag
   , tew_component.com_id AS com_id 
   , T1.bom_manufacturer AS bom_manufacturer
   , T1.bom_reference AS bom_reference
   , T1.bom_id AS bom_id 
   , COUNT (*) AS count_1
    FROM 
    tew_buildofmaterial AS T1
    LEFT JOIN  tew_bomelement  ON  (tew_bomelement.bel_bom_id =  T1.bom_id)
    LEFT JOIN tew_component ON  ( T1.bom_objectid = tew_component.com_id)
    LEFT JOIN tew_componentelement AS tew_componentelement_Associate 
	ON   (tew_componentelement_Associate.cel_bom_id = T1.bom_id AND tew_componentelement_Associate.cel_bel_no = tew_bomelement.bel_no )
    WHERE (tew_componentelement_Associate.cel_sym_id = -1)
    GROUP BY  tew_component.com_tagpath, tew_component.com_tag,  tew_component.com_id,  T1.bom_manufacturer,  T1.bom_reference, bom_id )    AS query_1
 LEFT JOIN tew_componentelement AS tew_componentelement_Free ON   (tew_componentelement_Free.cel_bom_id = bom_id )
 GROUP BY com_tagpath, com_tag,com_id, bom_manufacturer,  bom_reference, bom_id, count_1) AS query_2
 WHERE  query_2.count_1 = query_2.count_2
       ORDER BY com_tag</SQLQuery>
		<BreakFormula/>
		<ORDERS>
			<ORDER>
				<No>0</No>
				<FieldName>com_tag</FieldName>
				<IsBreak>0</IsBreak>
			</ORDER>
		</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="en">Full Mark</LANGUAGE>
					<LANGUAGE xml:lang="fr">Repère complet</LANGUAGE>
					<LANGUAGE xml:lang="cs">Úplná značka</LANGUAGE>
					<LANGUAGE xml:lang="de">Vollständiges Bauteil</LANGUAGE>
					<LANGUAGE xml:lang="it">Contrassegno completo</LANGUAGE>
					<LANGUAGE xml:lang="ja">全ﾏｰｸ</LANGUAGE>
					<LANGUAGE xml:lang="ko">전체 기호</LANGUAGE>
					<LANGUAGE xml:lang="zh">完整标注</LANGUAGE>
					<LANGUAGE xml:lang="pl">Pełny znacznik</LANGUAGE>
					<LANGUAGE xml:lang="pt">Marca completa</LANGUAGE>
					<LANGUAGE xml:lang="ru">Полная метка</LANGUAGE>
					<LANGUAGE xml:lang="es">Numeración completa</LANGUAGE>
					<LANGUAGE xml:lang="tr">Tam İşaret</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">完整標注</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>0</columnIndex>
				<ContentFormula>com_tagpath</ContentFormula>
				<GotoId>com_id</GotoId>
				<GotoType>3</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>2.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Značka</LANGUAGE>
					<LANGUAGE xml:lang="de">Beschriftung</LANGUAGE>
					<LANGUAGE xml:lang="en">Mark</LANGUAGE>
					<LANGUAGE xml:lang="es">Etiqueta</LANGUAGE>
					<LANGUAGE xml:lang="fr">Repère</LANGUAGE>
					<LANGUAGE xml:lang="it">Contrassegno</LANGUAGE>
					<LANGUAGE xml:lang="ja">マーク</LANGUAGE>
					<LANGUAGE xml:lang="ko">표시</LANGUAGE>
					<LANGUAGE xml:lang="pl">Znacznik</LANGUAGE>
					<LANGUAGE xml:lang="pt">Tag</LANGUAGE>
					<LANGUAGE xml:lang="ru">Метка</LANGUAGE>
					<LANGUAGE xml:lang="tr">İşaret</LANGUAGE>
					<LANGUAGE xml:lang="zh">标注</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">標注</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>1</columnIndex>
				<ContentFormula>com_tag</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>1.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>0</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>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>2.500000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Díl výrobce</LANGUAGE>
					<LANGUAGE xml:lang="de">Hersteller-Teil</LANGUAGE>
					<LANGUAGE xml:lang="en">Manufacturer part</LANGUAGE>
					<LANGUAGE xml:lang="es">Referencia de fabricante</LANGUAGE>
					<LANGUAGE xml:lang="fr">Référence constructeur</LANGUAGE>
					<LANGUAGE xml:lang="it">Pezzo costruttore</LANGUAGE>
					<LANGUAGE xml:lang="ja">ﾒｰｶｰ部品</LANGUAGE>
					<LANGUAGE xml:lang="ko">제조업체 파트</LANGUAGE>
					<LANGUAGE xml:lang="pl">Część producenta</LANGUAGE>
					<LANGUAGE xml:lang="pt">Peça do fabricante</LANGUAGE>
					<LANGUAGE xml:lang="ru">Деталь производителя</LANGUAGE>
					<LANGUAGE xml:lang="tr">Üretici parçası</LANGUAGE>
					<LANGUAGE xml:lang="zh">制造商部件</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">製造商設備型號</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>3</columnIndex>
				<ContentFormula>bom_reference</ContentFormula>
				<GotoId>bom_id</GotoId>
				<GotoType>2</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>2.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<BreakColumn>1</BreakColumn>
				<columnIndex>4</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>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</HeadingFont>
		<TitleFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
		</TitleFont>
		<ContentFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>7</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</ContentFont>
		<TotalFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>1</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>1</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</TotalFont>
	</FONT>
	<OPTIONS>
		<IsTxtOneArrayPerPage>1</IsTxtOneArrayPerPage>
		<DwgBOMHeight>9.500000</DwgBOMHeight>
		<DwgBOMWidth>16.000000</DwgBOMWidth>
		<IsReverseOrder>0</IsReverseOrder>
		<XDwgBOMOrigine>0.750000</XDwgBOMOrigine>
		<YDwgBOMOrigine>1.400000</YDwgBOMOrigine>
		<DwgHorzOffset>0.500000</DwgHorzOffset>
		<DwgVertOffset>0.500000</DwgVertOffset>
		<IsDwgOneArrayPerPage>0</IsDwgOneArrayPerPage>
		<IsDwgFollowingOnSameSheet>0</IsDwgFollowingOnSameSheet>
		<IsDwgOneArrayPerColumn>0</IsDwgOneArrayPerColumn>
		<TITLEBLOCK_NAME/>
		<OneArrayPerBundle>0</OneArrayPerBundle>
		<TakeIntoGeneratedFile>0</TakeIntoGeneratedFile>
		<MargeBetweenLabelAndTable>0.100000</MargeBetweenLabelAndTable>
		<UsePipeCharacter>1</UsePipeCharacter>
		<BreakTextIntoGeneratedFile>0</BreakTextIntoGeneratedFile>
	</OPTIONS>
	<FILTERS/>
</SECTIONS>
