<?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>WireTerminationByType_imperial</FILENAME>
		<DESCRIPTION>
			<LANGUAGE xml:lang="fr">Liste des embouts de fil groupés par type</LANGUAGE>
			<LANGUAGE xml:lang="en">List of wire termination grouped by type</LANGUAGE>
			<LANGUAGE xml:lang="zh">按类型分组的电线端子列表</LANGUAGE>
			<LANGUAGE xml:lang="de">Liste der Kabelabschlüsse nach Typ sortiert</LANGUAGE>
			<LANGUAGE xml:lang="pt">Lista de terminações de fio agrupadas por tipo</LANGUAGE>
			<LANGUAGE xml:lang="es">Listado de bornas de cable agrupadas por tipo</LANGUAGE>
			<LANGUAGE xml:lang="zh-tw">依類型分組的電線終結清單</LANGUAGE>
			<LANGUAGE xml:lang="ko">유형별로 그룹화된 와이어 종료 목록</LANGUAGE>
			<LANGUAGE xml:lang="it">Elenco dei terminali fili raggruppati per tipi</LANGUAGE>
			<LANGUAGE xml:lang="ru">Список наконечников проводов, сгруппированных по типу</LANGUAGE>
			<LANGUAGE xml:lang="ja">ﾀｲﾌﾟ別ﾜｲﾔ端子のﾘｽﾄ</LANGUAGE>
			<LANGUAGE xml:lang="cs">Seznam zakončení vodičů podle typu</LANGUAGE>
			<LANGUAGE xml:lang="pl">Lista zakończeń przewodów pogrupowanych według typu</LANGUAGE>
			<LANGUAGE xml:lang="tr">Tipe göre gruplandırılan tel sonlandırma listesi</LANGUAGE>
		</DESCRIPTION>
		<FILE_TYPE>0</FILE_TYPE>
		<OBJECT_TYPE>2</OBJECT_TYPE>
		<MEASURMENT>0</MEASURMENT>
		<Datatype>0</Datatype>
	</EW_HEADER>
	<QUERY>
		<FileData>
			<TZ_0>
				<LANGUAGE xml:lang="en">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="fr">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pt">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="es">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="de">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh-tw">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ko">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="it">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ru">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ja">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="cs">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pl">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="tr">REP_DESC</LANGUAGE>
			</TZ_0>
			<FileNameFormula/>
			<AutoFilterDesc>1</AutoFilterDesc>
		</FileData>
		<SQLQuery> SELECT 
 %APP_DATA%.tew_translatedtext.tra_objectid AS tra_objectid
 ,%APP_DATA%.tew_translatedtext.tra_0 AS tra_0
 ,tew_componentterminal.cte_cel_id AS cte_cel_id
 ,tew_componentterminal.cte_ttycode AS cte_ttycode
 ,1 AS %ELEMENT_COUNT%
 ,tew_location.loc_text AS loc_text

 FROM 

 tew_componentterminal
INNER JOIN tew_componentelement ON tew_componentelement.cel_id=tew_componentterminal.cte_cel_id
INNER JOIN tew_component ON tew_component.com_id = tew_componentelement.cel_com_id
INNER JOIN tew_location ON tew_location.loc_id =tew_component.com_loc_id
LEFT JOIN tew_wire AS tew_wire_from ON ((tew_componentelement.cel_id=tew_wire_from.wir_cel_idfrom) AND (tew_componentterminal.cte_no=tew_wire_from.wir_cte_nofrom) )
LEFT JOIN tew_wire AS tew_wire_to   ON ((tew_componentelement.cel_id=tew_wire_to.wir_cel_idto)     AND (tew_componentterminal.cte_no=tew_wire_to.wir_cte_noto) )
LEFT JOIN tew_bundle on tew_bundle.bun_id =tew_location.loc_bun_id
INNER JOIN %APP_DATA%.tew_terminationtype ON %APP_DATA%.tew_terminationtype.tty_code = tew_componentterminal.cte_ttycode
LEFT JOIN %APP_DATA%.tew_translatedtext ON %APP_DATA%.tew_translatedtext.tra_objectid =tew_terminationtype.tty_id AND %APP_DATA%.tew_translatedtext.tra_strobjectid = ]]tty[[ AND   %APP_DATA%.tew_translatedtext.tra_lan_strid = ]]%PROJECT_LNG_CODE%[[

WHERE (tew_bundle.bun_id =%CUR_BUNDLE_ID%) AND  ((tew_wire_from.wir_id != -1) or (tew_wire_to.wir_id != -1)) 

		  ORDER BY loc_text ASC,tra_0 ASC</SQLQuery>
		<BreakFormula/>
		<ORDERS>
			<ORDER>
				<No>-1</No>
				<FieldName>loc_text</FieldName>
				<IsBreak>1</IsBreak>
				<SortOrder>-1</SortOrder>
			</ORDER>
			<ORDER>
				<No>0</No>
				<FieldName>loc_text</FieldName>
				<IsBreak>1</IsBreak>
				<SortOrder>0</SortOrder>
			</ORDER>
			<ORDER>
				<No>1</No>
				<FieldName>tra_0</FieldName>
				<IsBreak>0</IsBreak>
				<SortOrder>0</SortOrder>
			</ORDER>
		</ORDERS>
		<FileData/>
		<ObjectType>14</ObjectType>
	</QUERY>
	<LAYOUT>
		<HeadingFormula>[AUTO]loc_text</HeadingFormula>
		<IsHeadingVisible>1</IsHeadingVisible>
		<IsTitleVisible>1</IsTitleVisible>
		<IsHorzSeparationVisible>1</IsHorzSeparationVisible>
		<IsTotalVisible>0</IsTotalVisible>
		<COLUMNS>
			<COLUMN>
				<BreakColumn>0</BreakColumn>
				<columnIndex>0</columnIndex>
				<ContentFormula>REPORT_ROW</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>0.500000</Width>
				<HorzTitleAlignment>2</HorzTitleAlignment>
				<HorzContentAlignment>2</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Název typu zakončení</LANGUAGE>
					<LANGUAGE xml:lang="de">Name des Abschlusstyps</LANGUAGE>
					<LANGUAGE xml:lang="en">Termination type name</LANGUAGE>
					<LANGUAGE xml:lang="es">Nombre de tipo de terminación</LANGUAGE>
					<LANGUAGE xml:lang="fr">Nom du type d'arrêt</LANGUAGE>
					<LANGUAGE xml:lang="it">Nome tipo di morsetto/terminale</LANGUAGE>
					<LANGUAGE xml:lang="ja">端子ﾀｲﾌﾟ名</LANGUAGE>
					<LANGUAGE xml:lang="ko">종료 유형 이름</LANGUAGE>
					<LANGUAGE xml:lang="pl">Nazwa typu zakończenia</LANGUAGE>
					<LANGUAGE xml:lang="pt">Nome do tipo de terminação</LANGUAGE>
					<LANGUAGE xml:lang="ru">Имя типа наконечника</LANGUAGE>
					<LANGUAGE xml:lang="tr">Sonlandırma tipi adı</LANGUAGE>
					<LANGUAGE xml:lang="zh">端子类型名称</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">終結類型名稱</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>1</columnIndex>
				<ContentFormula>cte_ttycode</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>1</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>2</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>1.000000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>0</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Typ zakončení</LANGUAGE>
					<LANGUAGE xml:lang="de">Abschlusstyp</LANGUAGE>
					<LANGUAGE xml:lang="en">Termination type</LANGUAGE>
					<LANGUAGE xml:lang="es">Tipo de terminación</LANGUAGE>
					<LANGUAGE xml:lang="fr">Type d'embout</LANGUAGE>
					<LANGUAGE xml:lang="it">Tipo di morsetto/terminale</LANGUAGE>
					<LANGUAGE xml:lang="ja">端子ﾀｲﾌﾟ</LANGUAGE>
					<LANGUAGE xml:lang="ko">종료 유형</LANGUAGE>
					<LANGUAGE xml:lang="pl">Typ zakończenia</LANGUAGE>
					<LANGUAGE xml:lang="pt">Tipo de terminação</LANGUAGE>
					<LANGUAGE xml:lang="ru">Тип наконечника</LANGUAGE>
					<LANGUAGE xml:lang="tr">Sonlandırma tipi</LANGUAGE>
					<LANGUAGE xml:lang="zh">端子类型</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">終結類型</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>2</columnIndex>
				<ContentFormula>IIF(tra_0!="",tra_0, cte_ttycode)</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>1</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>1</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>1.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">Množství</LANGUAGE>
					<LANGUAGE xml:lang="de">Menge</LANGUAGE>
					<LANGUAGE xml:lang="en">Quantity</LANGUAGE>
					<LANGUAGE xml:lang="es">Cantidad</LANGUAGE>
					<LANGUAGE xml:lang="fr">Quantité</LANGUAGE>
					<LANGUAGE xml:lang="it">Quantità</LANGUAGE>
					<LANGUAGE xml:lang="ja">数量</LANGUAGE>
					<LANGUAGE xml:lang="ko">수량</LANGUAGE>
					<LANGUAGE xml:lang="pl">Ilość</LANGUAGE>
					<LANGUAGE xml:lang="pt">Quantidade</LANGUAGE>
					<LANGUAGE xml:lang="ru">Количество</LANGUAGE>
					<LANGUAGE xml:lang="tr">Miktar</LANGUAGE>
					<LANGUAGE xml:lang="zh">数量</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">數量</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>3</columnIndex>
				<ContentFormula>eltcount</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>1</IsNumerical>
				<EnumerationType>3</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>1.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>4</columnIndex>
				<ContentFormula>loc_text</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter>,</EnumerationDelimiter>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>20.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>0</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
		</COLUMNS>
		<DefaultCodeLg/>
		<DefaultGoto/>
		<HorizontalCellMargin>-1</HorizontalCellMargin>
		<VerticalCellMargin>0</VerticalCellMargin>
	</LAYOUT>
	<VARIABLES/>
	<FONT>
		<HeadingFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Arial</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Arial</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</HeadingFont>
		<TitleFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Arial</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Arial</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
		</TitleFont>
		<ContentFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Arial</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Arial</DwgFontName>
			<DwgColor>7</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</ContentFont>
		<TotalFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Arial</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>1</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Arial</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>15.500000</DwgBOMWidth>
		<IsReverseOrder>0</IsReverseOrder>
		<XDwgBOMOrigine>0.800000</XDwgBOMOrigine>
		<YDwgBOMOrigine>1.300000</YDwgBOMOrigine>
		<DwgHorzOffset>0.700000</DwgHorzOffset>
		<DwgVertOffset>0.500000</DwgVertOffset>
		<IsDwgOneArrayPerPage>0</IsDwgOneArrayPerPage>
		<IsDwgFollowingOnSameSheet>0</IsDwgFollowingOnSameSheet>
		<IsDwgOneArrayPerColumn>0</IsDwgOneArrayPerColumn>
		<TITLEBLOCK_NAME/>
		<OneArrayPerBundle>1</OneArrayPerBundle>
		<TakeIntoGeneratedFile>0</TakeIntoGeneratedFile>
		<MargeBetweenLabelAndTable>0.250000</MargeBetweenLabelAndTable>
		<UsePipeCharacter>1</UsePipeCharacter>
		<BreakTextIntoGeneratedFile>0</BreakTextIntoGeneratedFile>
	</OPTIONS>
	<FILTERS/>
</SECTIONS>
