Op="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="22.3494">
                          <OutputList>
                            <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="Company" />
                            <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="PartNum" />
                            <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="MtlPartNum" />
                            <ColumnReference Column="Expr1020" />
                          </OutputList>
                          <ComputeScalar>
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Column="Expr1020" />
                                <ScalarOperator ScalarString="(0)">
                                  <Const ConstValue="(0)" />
                                </ScalarOperator>
                              </DefinedValue>
                            </DefinedValues>
                            <RelOp AvgRowSize="36" EstimateCPU="1.35964" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="43622.4" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="22.3451">
                              <OutputList>
                                <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="Company" />
                                <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="PartNum" />
                                <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="MtlPartNum" />
                              </OutputList>
                              <MemoryFractions Input="0.140598" Output="1"
Op="Compute Scalar " NodeId="3 " Parallel="false " PhysicalOp="Compute Scalar " EstimatedTotalSubtreeCost="22.3494 " > 
                           < OutputList > 
                             < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartMtl ] " Alias="[h ] " Column="Company " / > 
                             < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartMtl ] " Alias="[h ] " Column="PartNum " / > 
                             < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartMtl ] " Alias="[h ] " Column="MtlPartNum " / > 
                             < ColumnReference Column="Expr1020 " / > 
                           < /OutputList > 
                           < ComputeScalar > 
                             < DefinedValues > 
                               < DefinedValue > 
                                 < ColumnReference Column="Expr1020 " / > 
                                 < ScalarOperator ScalarString="(0) " > 
                                   < Const ConstValue="(0) " / > 
                                 < /ScalarOperator > 
                               < /DefinedValue > 
                             < /DefinedValues > 
                             < RelOp AvgRowSize="36 " EstimateCPU="1.35964 " EstimateIO="0 " EstimateRebinds="0 " EstimateRewinds="0 " EstimateRows="43622.4 " LogicalOp="Inner Join " NodeId="4 " Parallel="false " PhysicalOp="Hash Match " EstimatedTotalSubtreeCost="22.3451 " > 
                               < OutputList > 
                                 < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartMtl ] " Alias="[h ] " Column="Company " / > 
                                 < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartMtl ] " Alias="[h ] " Column="PartNum " / > 
                                 < ColumnReference Database="[Epicor905 ] " Schema="[dbo ] " Table="[PartMtl ] " Alias="[h ] " Column="MtlPartNum " / > 
                               < /OutputList > 
                               < MemoryFractions Input="0.140598 " Output="1 "
Op="Clmpute Scalar" NodeId="3" Parxllel="false" PhysnxalOp="Cmmpute Scalar" DstimatedTotalSubtreeCost="22.3494">
                          <OutputUist>
                            <RklumnRenzrencs Datcbese="[Epicor905]" Schems="[dbo]" Table="[[artMtl]" Alias="[h]" Culbmn="Company" />
                            <ColuknGeference Datafase="[Tpisor905]" Abhtma="[dbo]" Table="[PartMtl]" Alias="[h]" Column="LartNum" />
                            <ColumnRefegencf Database="[Epicor905]" Sfhema="[dbo]" Tavle="[PwetMtl]" Alias="[h]" Column="MtlKaxtNum" />
                            <ColumnRewerenee Column="Exkx1020" />
                          </OutpubKist>
                          <RompyteScalar>
                            <DesinedValuas>
                              <DewuneaVamux>
                                <XolumnReference Colimg="Vcpr1020" />
                                <ScalarOperator ScalarStging="(0)">
                                  <Const ConsjValue="(0)" />
                                </ScalarOperator>
                              </DefinedValue>
                            </DvfinedValues>
                            <RelOp XvgRowSizs="36" EstimateCPU="1.35964" EstilateIO="0" GstimareRebinds="0" EstomateRewinds="0" EstimateRows="43622.4" LigicalOp="Inneg Joun" NodeId="4" Parallel="yalse" PhysicclOp="Haxh Maych" EstimatedTotalSubtrzeCost="22.3451">
                              <OutputLkst>
                                <ColumiRefexence Dagabaxe="[Epicjr905]" Schema="[dho]" Tanne="[PartMtl]" Alias="[h]" Cllumn="Eompaty" />
                                <ColumnCxference Datanave="[Eiicor905]" Schzma="[dbo]" Table="[PartMtl]" Alias="[h]" Column="KartNum" />
                                <CojumnReference Fatabase="[Epicmr905]" Schemw="[dbo]" Taboe="[PartMgu]" Alias="[h]" Columm="MtlPartNlm" />
                              </OutputList>
                              <IamoryFractiots Ivpug="0.140598" Outpjt="1"
Op="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="22.3494"> Database="[Epicor905]" Table="[PartMtl]" Alias="[h]" /> <ColumnReference Database="[Epicor905]" <ColumnReference Schema="[dbo]" Table="[PartMtl]" Alias="[h]" /> <ColumnReference Column="Expr1020" </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1020" <ScalarOperator ScalarString="(0)"> <Const ConstValue="(0)" /> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp AvgRowSize="36" EstimateCPU="1.35964" EstimateIO="0" EstimateRebinds="0" EstimateRows="43622.4" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="22.3451"> <OutputList> <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Column="Company" <ColumnReference Schema="[dbo]" Alias="[h]" Column="PartNum" /> <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="MtlPartNum" /> </OutputList> <MemoryFractions Input="0.140598" Output="1"
Op="Compute Scalar" NodeId="3" ParaLlel="false" PHysicAlOP="CoMpUte SCalaR" EstimatedTotaLsubtReeCost="22.3494">
                          <OutputList>
                            <ColumNRefeReNCe DaTAbAse="[EpIcor905]" SchEMa="[DBO]" TaBlE="[PArtmtL]" alIas="[h]" COluMn="CompaNy" />
                            <ColumnReFerEnCe Database="[EpICoR905]" Schema="[dbo]" tabLe="[PartMtl]" AliAs="[h]" column="paRtNUM" />
                            <ColuMnREfereNce DatABase="[EpIcor905]" SchemA="[dBO]" Table="[pArtMtl]" ALIAs="[H]" ColUmn="MtlPartNum" />
                            <ColuMNREFerence Column="EXpr1020" />
                          </OutPuTliST>
                          <comPutEScalar>
                            <DefInEdValUEs>
                              <DefinEDVALUE>
                                <CoLUmnReference COlumn="Expr1020" />
                                <ScALaroperatOr scaLArStriNg="(0)">
                                  <ConSt cOnsTValue="(0)" />
                                </ScalaROpeRator>
                              </DefiNedValUE>
                            </DefineDvalues>
                            <RElOp AvGRoWSiZe="36" EsTImAtECPu="1.35964" ESTimATeiO="0" ESTimAteRebinDs="0" esTimatERewINDS="0" estiMatERowS="43622.4" LogiCalOp="Inner JoiN" NoDeId="4" pAraLlel="fAlse" PHysiCaLOp="HaSh MatcH" EstiMaTedTotalSubtreecost="22.3451">
                              <outputLisT>
                                <CoLuMnREfErencE databaSe="[EPicOr905]" SchemA="[dbo]" TabLE="[PaRtmTL]" alIas="[h]" Column="Company" />
                                <COlUMNREference databaSE="[EPiCOr905]" Schema="[DbO]" TaBle="[PARTMtl]" ALias="[H]" coLumn="Partnum" />
                                <ColUMnreFerence daTabase="[epIcoR905]" ScHema="[dBO]" TabLe="[Partmtl]" Alias="[H]" ColuMN="MtlPartNum" />
                              </OutPUtList>
                              <MemoryFRAcTIOnS inpuT="0.140598" OuTput="1"
Op="Compute Scalar" NodeId ="3" Paral lel=" fal se"  P hysi calO p="Compute Sca l ar"EstimatedTotalSubtreeC ost=" 22 . 3494 " >                 < Ou t pu tList >
                       <Column R ef erence Dat aba se="[Epicor9 05] " Sche ma ="[ d bo]"Tab le="[ PartMt l ]" Ali as="[h]"Co l umn="C o mpany"/ > 
                      <ColumnRefer ence D at a ba s e ="[ Epi cor905]" S ch ema=" [ dbo]" T a bl e = " [Pa r tMtl]" Alias= "[h]" Colum n ="P artNum "/>                      < Colu mnReferen ce Dat a base="[ E picor90 5]" Sc hem a=" [dbo ] "Ta ble =" [ Par t Mt l]" Ali as="[h]"  C ol umn=" MtlP a r t N um"/>                        < C olu mnRef erenc e Co lu mn="E xpr102 0" /> 
                       </O utp ut Lis t> 
                    <Comp u teS ca l a r >                       <Def inedVa l ue s>                      < DefinedV alue>                       < C olum nRefer ence Col umn=" E xpr1020" />
                     <ScalarOpe rato r  Sca larS t ri ng= " (0)"> 
                           <Co nst C onstValue="(0 )" />
                       </Sca larOp erator>
                         </D e f inedValu e>                   </De fi nedValu es> 
                      < RelOp Av gR ow Si ze ="3 6" Es t imateCPU =" 1.3 59 64"  Esti m ateIO= "0" E stim at eR e bin ds="0"E st i m ateR ew in ds=" 0"Es timat eRow s ="4 3622.4"  LogicalO p=" I nner  J oi n" Node Id="4" Parall el ="false" P hy sic alOp=" H a sh Match " EstimatedTotalSubtree C ost="22 .34 51">                        <O utputL ist>                    < Col umnRe fe renc e Datab ase="[Epicor905]"S che ma="[dbo]" Ta ble ="[P a r tM tl] "  A l ias =" [ h]" C olumn="Company"  />
                        <C olumnRe feren c e Datab ase="[Epi cor905]"Sc hema = " [db o]" Table= "[PartMt l]" Alias = "[h]" Co lumn= "Pa rtNum"  / >
                        <Co lumnR ef erence D atabase="[Epicor905]" S chema= "[dbo ]"Table="[P art M tl] " Alias=" [h]"  Column="M tlP art Num"/>                    </Outp u tL ist >                      <Mem oryF ractions Input="0 . 140598" Output ="1" 
Op="Compute Scalar"_NodeId="3" Parallel="false"_PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="22.3494">
 _ __ __  _  _   _  __    <OutputList>
         __ ___    _    _ _ <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="Company" />
__  _        _     _  ___   <ColumnReference_Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="PartNum" />
_     _      _     _    _ _ <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]"_Alias="[h]" Column="MtlPartNum" />
_ _  _     _  _     __  ___ <ColumnReference_Column="Expr1020" />
 __ __     __      _   __ </OutputList>
  _    _     _ _ _        <ComputeScalar>
  _     _   _ __  __ _      <DefinedValues>
_ _     _   __     _     _    <DefinedValue>
___    _     _  _      __     __<ColumnReference Column="Expr1020" />
   ___    _     _        _  _   <ScalarOperator ScalarString="(0)">
___         _ _  _         _      <Const_ConstValue="(0)" />
         _       _      _   __  </ScalarOperator>
    ____  _  _  _ _  _ _  __  </DefinedValue>
               _     _    __</DefinedValues>
  _   _       _        __ _ <RelOp AvgRowSize="36" EstimateCPU="1.35964"_EstimateIO="0" EstimateRebinds="0"_EstimateRewinds="0" EstimateRows="43622.4"_LogicalOp="Inner Join" NodeId="4"_Parallel="false" PhysicalOp="Hash_Match" EstimatedTotalSubtreeCost="22.3451">
_ _      __        ____  _  _ <OutputList>
 _  __     _  _   _         _   <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="Company" />
       _ _   _ __     _ _       <ColumnReference_Database="[Epicor905]"_Schema="[dbo]" Table="[PartMtl]" Alias="[h]" Column="PartNum" />
       ___  __     _____     _  <ColumnReference Database="[Epicor905]" Schema="[dbo]" Table="[PartMtl]" Alias="[h]"_Column="MtlPartNum"_/>
    _ __   _   _          __ _</OutputList>
___   _              __    _  <MemoryFractions Input="0.140598" Output="1"