Created
December 1, 2016 14:58
-
-
Save jjradha/a968665bf97c5bc1accc110787fa70b2 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.3.1" Build="12.0.5000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="3" StatementEstRows="2.55412" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="120" StatementSubTreeCost="7.96175" StatementText="SELECT o.strBxOrderNo,
 i.sintOrderSeqNo,
 r.decReturnGoodsNetAmount,
 r.decReturnGoodsTaxAmount,
 r.decReturnShippingNetAmount,
 r.decReturnShippingTaxAmount,
 r.decReturnTotalAmount,
 r.decBCReturnGoodsNetAmount,
 r.decBCReturnGoodsTaxAmount,
 r.decBCReturnShippingNetAmount,
 r.decBCReturnShippingTaxAmount,
 r.decBCReturnTotalAmount,
 r.blnManual,
 r.blnExchange,
 r.decReturnPostageDeductionAmount,
 r.decBCReturnPostageDeductionAmount,
 rh.dtmAdded,
 oir.sintReturnReasonId,
 oir.decReturnNetAmount,
 oir.decReturnTaxAmount,
 oir.decReturnFinalAmount,
 oir.decBCReturnNetAmount,
 oir.decBCReturnTaxAmount,
 oir.decBCReturnFinalAmount,
 o.sdtmOrdCreated,
 o.sintMarketID,
 i.decCatItemPrice,
 i.blnChargeShipping,
 i.decBCCatItemPrice,
 o.decShipTax,
 o.decShipFinal,
 o.decShipFullPrice,
 o.decBCShipTax,
 o.decBCShipFinal,
 o.decBCShipFullPrice,
 i.decFinalPrice,
 i.decTaxAmount,
 i.decCostPrice,
 CASE WHEN i.blnChargeShipping = 1 THEN o.decShipFinal
 ELSE 0
 END AS ShipActualPrice,
 CASE WHEN i.blnChargeShipping = 1 THEN o.decShipTax
 ELSE 0
 END AS ShipActualTaxAmount,
 i.decBCFinalPrice,
 i.decBCTaxAmount,
 i.decBCCostPrice,
 CASE WHEN i.blnChargeShipping = 1 THEN o.decBCShipFinal
 ELSE 0
 END AS BCShipActualPrice,
 CASE WHEN i.blnChargeShipping = 1 THEN o.decBCShipTax
 ELSE 0
 END AS BCShipActualTaxAmount,
 i.sintQuantity,
 o.strCurrencyCode,
 o.sintOrderChannelID,
 o.sintOrderTypeID,
 o.strOrderKey,
 i.strItemNo,
 o.lngAccountParticipantID,
 i.decOverrideDiscount,
 i.decOfferDiscount,
 i.decBCOverrideDiscount,
 i.decBCOfferDiscount,
 ap.strAccountCode,
 CAST(rh.dtmAdded AS DATE) AS AddedDateConverted,
 CAST(o.sdtmOrdCreated AS DATE) AS OrderCreatedDateConverted
FROM Bocss2.dbo.tblBReturn AS r

INNER JOIN Bocss2.dbo.tblBReturnHistory AS rh ON r.sintReturnId = rh.sintReturnId
 AND rh.strBxOrderNo = r.strBxOrderNo
 AND rh.sintReturnStatusId = 3 --// Refund Calculated
 AND rh.dtmAdded >= @OrderStartDate
 AND rh.dtmAdded < @OrderEndDate


INNER JOIN Bocss2.dbo.tblBOrderItemReturn AS oir ON rh.sintReturnId = oir.sintReturnID
 AND rh.strBxOrderNo = oir.strBxOrderNo
 AND oir.decReturnFinalAmount > 0

INNER JOIN Bocss2.dbo.tblBOrder AS o ON oir.strBxOrderNo = o.strBxOrderNo
 AND o.sdtmOrdCreated >= @SmallFullLoadStartDate
 AND o.sintOrderChannelID != 3 -- excludes shop

INNER JOIN Bocss2.dbo.tblBOrderItem AS i ON i.strBxOrderNo = oir.strBxOrderNo
 AND i.sintOrderSeqNo = oir.sintOrderSeqNo
 AND i.decCatItemPrice > 0

INNER JOIN Bocss2.dbo.tblBAccountParticipant ap ON o.lngAccountParticipantID = ap.lngParticipantID


UNION --// Now get Shop returns



--DECLARE @SmallFullLoadStartDate SMALLDATETIME,
-- @OrderStartDate DATETIME,
-- @OrderEndDate DATETIME

--SELECT @SmallFullLoadStartDate = '18-NOV-2016'
-- ,@OrderStartDate = '18-NOV-2016'
-- ,@OrderEndDate = '25-NOV-2016'


SELECT o.strBxOrderNo,
 i.sintOrderSeqNo,
 r.decReturnGoodsNetAmount,
 r.decReturnGoodsTaxAmount,
 r.decReturnShippingNetAmount,
 r.decReturnShippingTaxAmount,
 r.decReturnTotalAmount,
 r.decBCReturnGoodsNetAmount,
 r.decBCReturnGoodsTaxAmount,
 r.decBCReturnShippingNetAmount,
 r.decBCReturnShippingTaxAmount,
 r.decBCReturnTotalAmount,
 r.blnManual,
 r.blnExchange,
 r.decReturnPostageDeductionAmount,
 r.decBCReturnPostageDeductionAmount,
 rh.dtmAdded,
 oir.sintReturnReasonId,
 oir.decReturnNetAmount,
 oir.decReturnTaxAmount,
 oir.decReturnFinalAmount,
 oir.decBCReturnNetAmount,
 oir.decBCReturnTaxAmount,
 oir.decBCReturnFinalAmount,
 o.sdtmOrdCreated,
 o.sintMarketID,
 i.decCatItemPrice,
 i.blnChargeShipping,
 i.decBCCatItemPrice,
 o.decShipTax,
 o.decShipFinal,
 o.decShipFullPrice,
 o.d" StatementType="SELECT" QueryHash="0x2303A146EB9B7BF7" QueryPlanHash="0xE0D12A738543BA34" RetrievedFromCache="false"> | |
| <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> | |
| <QueryPlan DegreeOfParallelism="1" MemoryGrant="10256" CachedPlanSize="472" CompileTime="511" CompileCPU="374" CompileMemory="13208"> | |
| <MissingIndexes> | |
| <MissingIndexGroup Impact="12.0397"> | |
| <MissingIndex Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]"> | |
| <ColumnGroup Usage="EQUALITY"> | |
| <Column Name="[strBxOrderNo]" ColumnId="2" /> | |
| <Column Name="[sintReturnStatusId]" ColumnId="4" /> | |
| </ColumnGroup> | |
| <ColumnGroup Usage="INEQUALITY"> | |
| <Column Name="[dtmAdded]" ColumnId="5" /> | |
| </ColumnGroup> | |
| <ColumnGroup Usage="INCLUDE"> | |
| <Column Name="[sintReturnId]" ColumnId="3" /> | |
| </ColumnGroup> | |
| </MissingIndex> | |
| </MissingIndexGroup> | |
| </MissingIndexes> | |
| <MemoryGrantInfo SerialRequiredMemory="3072" SerialDesiredMemory="10256" RequiredMemory="3072" DesiredMemory="10256" RequestedMemory="10256" GrantWaitTime="0" GrantedMemory="10256" MaxUsedMemory="4296" /> | |
| <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1677721" EstimatedPagesCached="1048576" EstimatedAvailableDegreeOfParallelism="5" /> | |
| <RelOp AvgRowSize="459" EstimateCPU="0.000105849" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.55412" LogicalOp="Distinct Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="7.96175"> | |
| <OutputList> | |
| <ColumnReference Column="Union1026" /> | |
| <ColumnReference Column="Union1027" /> | |
| <ColumnReference Column="Union1028" /> | |
| <ColumnReference Column="Union1029" /> | |
| <ColumnReference Column="Union1030" /> | |
| <ColumnReference Column="Union1031" /> | |
| <ColumnReference Column="Union1032" /> | |
| <ColumnReference Column="Union1033" /> | |
| <ColumnReference Column="Union1034" /> | |
| <ColumnReference Column="Union1035" /> | |
| <ColumnReference Column="Union1036" /> | |
| <ColumnReference Column="Union1037" /> | |
| <ColumnReference Column="Union1038" /> | |
| <ColumnReference Column="Union1039" /> | |
| <ColumnReference Column="Union1040" /> | |
| <ColumnReference Column="Union1041" /> | |
| <ColumnReference Column="Union1042" /> | |
| <ColumnReference Column="Union1043" /> | |
| <ColumnReference Column="Union1044" /> | |
| <ColumnReference Column="Union1045" /> | |
| <ColumnReference Column="Union1046" /> | |
| <ColumnReference Column="Union1047" /> | |
| <ColumnReference Column="Union1048" /> | |
| <ColumnReference Column="Union1049" /> | |
| <ColumnReference Column="Union1050" /> | |
| <ColumnReference Column="Union1051" /> | |
| <ColumnReference Column="Union1052" /> | |
| <ColumnReference Column="Union1053" /> | |
| <ColumnReference Column="Union1054" /> | |
| <ColumnReference Column="Union1055" /> | |
| <ColumnReference Column="Union1056" /> | |
| <ColumnReference Column="Union1057" /> | |
| <ColumnReference Column="Union1058" /> | |
| <ColumnReference Column="Union1059" /> | |
| <ColumnReference Column="Union1060" /> | |
| <ColumnReference Column="Union1061" /> | |
| <ColumnReference Column="Union1062" /> | |
| <ColumnReference Column="Union1063" /> | |
| <ColumnReference Column="Union1064" /> | |
| <ColumnReference Column="Union1065" /> | |
| <ColumnReference Column="Union1066" /> | |
| <ColumnReference Column="Union1067" /> | |
| <ColumnReference Column="Union1068" /> | |
| <ColumnReference Column="Union1069" /> | |
| <ColumnReference Column="Union1070" /> | |
| <ColumnReference Column="Union1071" /> | |
| <ColumnReference Column="Union1072" /> | |
| <ColumnReference Column="Union1073" /> | |
| <ColumnReference Column="Union1074" /> | |
| <ColumnReference Column="Union1075" /> | |
| <ColumnReference Column="Union1076" /> | |
| <ColumnReference Column="Union1077" /> | |
| <ColumnReference Column="Union1078" /> | |
| <ColumnReference Column="Union1079" /> | |
| <ColumnReference Column="Union1080" /> | |
| <ColumnReference Column="Union1081" /> | |
| <ColumnReference Column="Union1082" /> | |
| <ColumnReference Column="Union1083" /> | |
| <ColumnReference Column="Union1084" /> | |
| </OutputList> | |
| <Warnings> | |
| <SpillToTempDb SpillLevel="1" /> | |
| </Warnings> | |
| <MemoryFractions Input="0.00445434" Output="1" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="3087" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="572" ActualCPUms="488" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="182" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <Sort Distinct="true"> | |
| <OrderBy> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1026" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1027" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1028" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1029" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1030" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1031" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1032" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1033" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1034" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1035" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1036" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1037" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1038" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1039" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1040" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1041" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1042" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1043" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1044" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1045" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1046" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1047" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1048" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1049" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1050" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1051" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1052" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1053" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1054" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1055" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1056" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1057" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1058" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1059" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1060" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1061" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1062" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1063" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1064" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1065" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1066" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1067" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1068" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1069" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1070" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1071" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1072" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1073" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1074" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1075" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1076" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1077" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1078" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1079" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1080" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1081" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1082" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1083" /> | |
| </OrderByColumn> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Column="Union1084" /> | |
| </OrderByColumn> | |
| </OrderBy> | |
| <RelOp AvgRowSize="459" EstimateCPU="2.55412E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.55412" LogicalOp="Concatenation" NodeId="1" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="7.95038"> | |
| <OutputList> | |
| <ColumnReference Column="Union1026" /> | |
| <ColumnReference Column="Union1027" /> | |
| <ColumnReference Column="Union1028" /> | |
| <ColumnReference Column="Union1029" /> | |
| <ColumnReference Column="Union1030" /> | |
| <ColumnReference Column="Union1031" /> | |
| <ColumnReference Column="Union1032" /> | |
| <ColumnReference Column="Union1033" /> | |
| <ColumnReference Column="Union1034" /> | |
| <ColumnReference Column="Union1035" /> | |
| <ColumnReference Column="Union1036" /> | |
| <ColumnReference Column="Union1037" /> | |
| <ColumnReference Column="Union1038" /> | |
| <ColumnReference Column="Union1039" /> | |
| <ColumnReference Column="Union1040" /> | |
| <ColumnReference Column="Union1041" /> | |
| <ColumnReference Column="Union1042" /> | |
| <ColumnReference Column="Union1043" /> | |
| <ColumnReference Column="Union1044" /> | |
| <ColumnReference Column="Union1045" /> | |
| <ColumnReference Column="Union1046" /> | |
| <ColumnReference Column="Union1047" /> | |
| <ColumnReference Column="Union1048" /> | |
| <ColumnReference Column="Union1049" /> | |
| <ColumnReference Column="Union1050" /> | |
| <ColumnReference Column="Union1051" /> | |
| <ColumnReference Column="Union1052" /> | |
| <ColumnReference Column="Union1053" /> | |
| <ColumnReference Column="Union1054" /> | |
| <ColumnReference Column="Union1055" /> | |
| <ColumnReference Column="Union1056" /> | |
| <ColumnReference Column="Union1057" /> | |
| <ColumnReference Column="Union1058" /> | |
| <ColumnReference Column="Union1059" /> | |
| <ColumnReference Column="Union1060" /> | |
| <ColumnReference Column="Union1061" /> | |
| <ColumnReference Column="Union1062" /> | |
| <ColumnReference Column="Union1063" /> | |
| <ColumnReference Column="Union1064" /> | |
| <ColumnReference Column="Union1065" /> | |
| <ColumnReference Column="Union1066" /> | |
| <ColumnReference Column="Union1067" /> | |
| <ColumnReference Column="Union1068" /> | |
| <ColumnReference Column="Union1069" /> | |
| <ColumnReference Column="Union1070" /> | |
| <ColumnReference Column="Union1071" /> | |
| <ColumnReference Column="Union1072" /> | |
| <ColumnReference Column="Union1073" /> | |
| <ColumnReference Column="Union1074" /> | |
| <ColumnReference Column="Union1075" /> | |
| <ColumnReference Column="Union1076" /> | |
| <ColumnReference Column="Union1077" /> | |
| <ColumnReference Column="Union1078" /> | |
| <ColumnReference Column="Union1079" /> | |
| <ColumnReference Column="Union1080" /> | |
| <ColumnReference Column="Union1081" /> | |
| <ColumnReference Column="Union1082" /> | |
| <ColumnReference Column="Union1083" /> | |
| <ColumnReference Column="Union1084" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="3087" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="514" ActualCPUms="445" /> | |
| </RunTimeInformation> | |
| <Concat> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1026" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1027" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1028" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1029" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1030" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1031" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1032" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1033" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1034" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1035" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1036" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1037" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1038" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1039" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1040" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1041" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1042" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1043" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1044" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1045" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1046" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1047" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1048" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1049" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1050" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1051" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1052" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1053" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1054" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1055" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1056" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1057" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1058" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1059" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1060" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1061" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1062" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1063" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1064" /> | |
| <ColumnReference Column="Expr1007" /> | |
| <ColumnReference Column="Expr1020" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1065" /> | |
| <ColumnReference Column="Expr1008" /> | |
| <ColumnReference Column="Expr1021" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1066" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1067" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1068" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1069" /> | |
| <ColumnReference Column="Expr1009" /> | |
| <ColumnReference Column="Expr1022" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1070" /> | |
| <ColumnReference Column="Expr1010" /> | |
| <ColumnReference Column="Expr1023" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1071" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1072" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1073" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1074" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1075" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1076" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1077" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1078" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1079" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1080" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1081" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1082" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1083" /> | |
| <ColumnReference Column="Expr1011" /> | |
| <ColumnReference Column="Expr1024" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Union1084" /> | |
| <ColumnReference Column="Expr1012" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="459" EstimateCPU="1.12756E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.12756" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="6.40566"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1007" /> | |
| <ColumnReference Column="Expr1008" /> | |
| <ColumnReference Column="Expr1009" /> | |
| <ColumnReference Column="Expr1010" /> | |
| <ColumnReference Column="Expr1011" /> | |
| <ColumnReference Column="Expr1012" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1007" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decShipFinal] as [o].[decShipFinal] ELSE (0.00) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.00)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1008" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decShipTax] as [o].[decShipTax] ELSE (0.00) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.00)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1009" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decBCShipFinal] as [o].[decBCShipFinal] ELSE (0.0000) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.0000)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1010" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decBCShipTax] as [o].[decBCShipTax] ELSE (0.0000) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.0000)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="422" EstimateCPU="1.08171E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.12756" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.40566"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1011" /> | |
| <ColumnReference Column="Expr1012" /> | |
| </OutputList> | |
| <MemoryFractions Input="0" Output="0.00445434" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="3054" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="447" ActualCPUms="386" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="300" EstimateCPU="0.000164091" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.58783" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.39943"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1011" /> | |
| <ColumnReference Column="Expr1012" /> | |
| </OutputList> | |
| <MemoryFractions Input="0" Output="0.00668151" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="3056" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="337" ActualCPUms="287" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="true" WithUnorderedPrefetch="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Column="Expr1093" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="244" EstimateCPU="0.000164091" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="39.2563" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.27352"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1011" /> | |
| <ColumnReference Column="Expr1012" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1764" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="278" ActualCPUms="235" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="false" WithUnorderedPrefetch="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Column="Expr1092" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="231" EstimateCPU="0.00481174" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="39.2563" LogicalOp="Inner Join" NodeId="10" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.14763"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Column="Expr1011" /> | |
| <ColumnReference Column="Expr1012" /> | |
| </OutputList> | |
| <MemoryFractions Input="0" Output="0.0534521" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1764" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="252" ActualCPUms="219" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="true" WithUnorderedPrefetch="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Column="Expr1091" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="121" EstimateCPU="0.943889" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1151.13" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2.3827"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Column="Expr1011" /> | |
| <ColumnReference Column="Expr1012" /> | |
| </OutputList> | |
| <MemoryFractions Input="1" Output="0.930958" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1764" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="230" ActualCPUms="198" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <Hash> | |
| <DefinedValues /> | |
| <HashKeysBuild> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| </HashKeysBuild> | |
| <HashKeysProbe> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </HashKeysProbe> | |
| <ProbeResidual> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBReturnHistory].[strBxOrderNo] as [rh].[strBxOrderNo]=[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </ProbeResidual> | |
| <RelOp AvgRowSize="33" EstimateCPU="0.0131056" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20421.5" LogicalOp="Compute Scalar" NodeId="14" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.267956"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Column="Expr1011" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1011" /> | |
| <ScalarOperator ScalarString="CONVERT(date,[Bocss2].[dbo].[tblBReturnHistory].[dtmAdded] as [rh].[dtmAdded],0)"> | |
| <Convert DataType="date" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="30" EstimateCPU="0.144318" EstimateIO="0.110532" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="131056" LogicalOp="Index Seek" NodeId="15" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.254851" TableCardinality="75756100"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="43463" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="13" ActualCPUms="13" ActualScans="1" ActualLogicalReads="209" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Index="[FIDX_sintReturnStatusId_3]" Filtered="true" Alias="[rh]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <StartRange ScanType="GE"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'2016-11-24 00:00:00.000'"> | |
| <Const ConstValue="'2016-11-24 00:00:00.000'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </StartRange> | |
| <EndRange ScanType="LT"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'2016-12-02 00:00:00.000'"> | |
| <Const ConstValue="'2016-12-02 00:00:00.000'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </EndRange> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| <RelOp AvgRowSize="107" EstimateCPU="0.00560313" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="56031.3" LogicalOp="Compute Scalar" NodeId="19" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.17085"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Column="Expr1012" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1012" /> | |
| <ScalarOperator ScalarString="CONVERT(date,[Bocss2].[dbo].[tblBOrder].[sdtmOrdCreated] as [o].[sdtmOrdCreated],0)"> | |
| <Convert DataType="date" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="104" EstimateCPU="0.062153" EstimateIO="1.0535" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="56031.3" LogicalOp="Index Seek" NodeId="20" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="1.11565" TableCardinality="45922000"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="152145" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="69" ActualCPUms="69" ActualScans="1" ActualLogicalReads="6495" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Index="[IX_tblBOrder_sdtmOrdCreated_INCL]" Alias="[o]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <StartRange ScanType="GE"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'2016-11-24 00:00:00.000'"> | |
| <Const ConstValue="'2016-11-24 00:00:00.000'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </StartRange> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| <Predicate> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[sintOrderChannelID] as [o].[sintOrderChannelID]<(3) OR [Bocss2].[dbo].[tblBOrder].[sintOrderChannelID] as [o].[sintOrderChannelID]>(3)"> | |
| <Logical Operation="OR"> | |
| <ScalarOperator> | |
| <Compare CompareOp="LT"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(3)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Compare CompareOp="GT"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(3)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Logical> | |
| </ScalarOperator> | |
| </Predicate> | |
| </IndexScan> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| </Hash> | |
| </RelOp> | |
| <RelOp AvgRowSize="130" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1150.13" EstimateRewinds="0.00404092" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="25" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="3.76012" TableCardinality="21847400"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1764" ActualEndOfScans="0" ActualExecutions="1764" ActualElapsedms="17" ActualCPUms="16" ActualScans="0" ActualLogicalReads="6699" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Index="[PK_tblBReturn]" Alias="[r]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="sintReturnId" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBReturnHistory].[sintReturnId] as [rh].[sintReturnId]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| <RelOp AvgRowSize="21" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="38.2563" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="26" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.125721" TableCardinality="15214900"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1764" ActualEndOfScans="0" ActualExecutions="1764" ActualElapsedms="21" ActualCPUms="11" ActualScans="0" ActualLogicalReads="5054" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Index="[PK_tblBAccountParticipants]" Alias="[ap]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="lngParticipantID" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[lngAccountParticipantID] as [o].[lngAccountParticipantID]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| <RelOp AvgRowSize="65" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="38.2563" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="27" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.125752" TableCardinality="42808800"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="3056" ActualEndOfScans="1764" ActualExecutions="1764" ActualElapsedms="33" ActualCPUms="29" ActualScans="1764" ActualLogicalReads="7131" ActualPhysicalReads="2" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Index="[FIDX_decReturnFinalAmount_0]" Filtered="true" Alias="[oir]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="strBxOrderNo" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBReturnHistory].[sintReturnId] as [rh].[sintReturnId]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| <RelOp AvgRowSize="133" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.58783" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="28" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00621143" TableCardinality="179747000"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="3054" ActualEndOfScans="2" ActualExecutions="3056" ActualElapsedms="78" ActualCPUms="73" ActualScans="3056" ActualLogicalReads="12240" ActualPhysicalReads="1" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Index="[IX_tblBOrderItem_decCatItemPrice_INCL]" Filtered="true" Alias="[i]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrderItemReturn].[sintOrderSeqNo] as [oir].[sintOrderSeqNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| <RelOp AvgRowSize="462" EstimateCPU="1.42657E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.42657" LogicalOp="Compute Scalar" NodeId="38" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.54472"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1020" /> | |
| <ColumnReference Column="Expr1021" /> | |
| <ColumnReference Column="Expr1022" /> | |
| <ColumnReference Column="Expr1023" /> | |
| <ColumnReference Column="Expr1024" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1020" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decShipFinal] as [o].[decShipFinal] ELSE (0.00) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.00)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1021" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decShipTax] as [o].[decShipTax] ELSE (0.00) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.00)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1022" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decBCShipFinal] as [o].[decBCShipFinal] ELSE (0.0000) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.0000)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1023" /> | |
| <ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBOrderItem].[blnChargeShipping] as [i].[blnChargeShipping]=(1) THEN [Bocss2].[dbo].[tblBOrder].[decBCShipTax] as [o].[decBCShipTax] ELSE (0.0000) END"> | |
| <IF> | |
| <Condition> | |
| <ScalarOperator> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Condition> | |
| <Then> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Then> | |
| <Else> | |
| <ScalarOperator> | |
| <Const ConstValue="(0.0000)" /> | |
| </ScalarOperator> | |
| </Else> | |
| </IF> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="425" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.42657" LogicalOp="Inner Join" NodeId="39" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.54472"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1024" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </OutputList> | |
| <MemoryFractions Input="0" Output="0.00976025" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="64" ActualCPUms="56" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="301" EstimateCPU="2.09637E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="41" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.54144"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1024" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </OutputList> | |
| <MemoryFractions Input="0" Output="0.00976025" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="58" ActualCPUms="54" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="245" EstimateCPU="2.09637E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5.01523" LogicalOp="Inner Join" NodeId="43" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.52807"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| <ColumnReference Column="Expr1024" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="57" ActualCPUms="53" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="false"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="232" EstimateCPU="0.000614728" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5.01523" LogicalOp="Inner Join" NodeId="44" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.51471"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Column="Expr1024" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </OutputList> | |
| <MemoryFractions Input="0" Output="0.0195205" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="57" ActualCPUms="53" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="true" WithUnorderedPrefetch="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Column="Expr1094" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="122" EstimateCPU="0.635218" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="147.064" LogicalOp="Inner Join" NodeId="47" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.03449"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Column="Expr1024" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </OutputList> | |
| <MemoryFractions Input="0.995546" Output="0.956505" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="22" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="56" ActualCPUms="52" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <Hash> | |
| <DefinedValues /> | |
| <HashKeysBuild> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </HashKeysBuild> | |
| <HashKeysProbe> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| </HashKeysProbe> | |
| <ProbeResidual> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBReturnHistory].[strBxOrderNo] as [rh].[strBxOrderNo]=[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </ProbeResidual> | |
| <RelOp AvgRowSize="108" EstimateCPU="0.000607819" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6078.19" LogicalOp="Compute Scalar" NodeId="48" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0720573"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| <ColumnReference Column="Expr1025" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1025" /> | |
| <ScalarOperator ScalarString="CONVERT(date,[Bocss2].[dbo].[tblBOrder].[sdtmOrdCreated] as [o].[sdtmOrdCreated],0)"> | |
| <Convert DataType="date" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="105" EstimateCPU="0.00684301" EstimateIO="0.0646065" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6078.19" LogicalOp="Index Seek" NodeId="49" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0714495" TableCardinality="45922000"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="465" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="17" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderTypeID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintMarketID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strOrderKey" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strCurrencyCode" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFullPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipFinal" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decShipTax" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFullPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipFinal" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="decBCShipTax" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Index="[IX_tblBOrder__sintOrderChannelID_sdtmOrdCreated_INCL]" Alias="[o]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sintOrderChannelID" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="(3)"> | |
| <Const ConstValue="(3)" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| <StartRange ScanType="GE"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'2016-11-24 00:00:00.000'"> | |
| <Const ConstValue="'2016-11-24 00:00:00.000'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </StartRange> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| <RelOp AvgRowSize="34" EstimateCPU="0.0131056" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="24050.6" LogicalOp="Compute Scalar" NodeId="53" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.327215"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| <ColumnReference Column="Expr1024" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1024" /> | |
| <ScalarOperator ScalarString="CONVERT(date,[Bocss2].[dbo].[tblBReturnHistory].[dtmAdded] as [rh].[dtmAdded],0)"> | |
| <Convert DataType="date" Style="0" Implicit="false"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Convert> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="31" EstimateCPU="0.144318" EstimateIO="0.169792" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="131056" LogicalOp="Index Seek" NodeId="54" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.31411" TableCardinality="75756100"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="41112" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="20" ActualCPUms="20" ActualScans="1" ActualLogicalReads="198" ActualPhysicalReads="0" ActualReadAheads="116" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="strBxOrderNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Index="[FIDX_sintReturnStatusId_6]" Filtered="true" Alias="[rh]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <StartRange ScanType="GE"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'2016-11-24 00:00:00.000'"> | |
| <Const ConstValue="'2016-11-24 00:00:00.000'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </StartRange> | |
| <EndRange ScanType="LT"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="dtmAdded" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'2016-12-02 00:00:00.000'"> | |
| <Const ConstValue="'2016-12-02 00:00:00.000'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </EndRange> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| </Hash> | |
| </RelOp> | |
| <RelOp AvgRowSize="131" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="146.057" EstimateRewinds="0.00686591" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="59" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.479604" TableCardinality="21847400"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="22" ActualEndOfScans="0" ActualExecutions="22" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="64" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnGoodsTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnShippingTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnTotalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnGoodsTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnShippingTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnTotalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnManual" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="blnExchange" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decReturnPostageDeductionAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="decBCReturnPostageDeductionAmount" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Index="[PK_tblBReturn]" Alias="[r]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturn]" Alias="[r]" Column="sintReturnId" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBReturnHistory].[sintReturnId] as [rh].[sintReturnId]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| <RelOp AvgRowSize="21" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="4.01523" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="60" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0133402" TableCardinality="15214900"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="22" ActualEndOfScans="0" ActualExecutions="22" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="66" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="strAccountCode" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Index="[PK_tblBAccountParticipants]" Alias="[ap]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="lngParticipantID" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[lngAccountParticipantID] as [o].[lngAccountParticipantID]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| <RelOp AvgRowSize="65" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="4.01523" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="61" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0133405" TableCardinality="42808800"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="22" ActualExecutions="22" ActualElapsedms="0" ActualCPUms="0" ActualScans="22" ActualLogicalReads="89" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnReasonId" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decReturnFinalAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnNetAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="decBCReturnFinalAmount" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Index="[FIDX_decReturnFinalAmount_0]" Filtered="true" Alias="[oir]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintReturnID" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="strBxOrderNo" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBReturnHistory].[sintReturnId] as [rh].[sintReturnId]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBReturnHistory]" Alias="[rh]" Column="sintReturnId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| <RelOp AvgRowSize="135" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="62" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="179747000"> | |
| <OutputList> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="33" ActualEndOfScans="0" ActualExecutions="33" ActualElapsedms="5" ActualCPUms="1" ActualScans="33" ActualLogicalReads="132" ActualPhysicalReads="5" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strItemNo" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintQuantity" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCostPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decCatItemPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOfferDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decOverrideDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decFinalPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCostPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCCatItemPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOfferDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCOverrideDiscount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCFinalPrice" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="decBCTaxAmount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="blnChargeShipping" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Index="[IX_tblBOrderItem_decCatItemPrice_INCL]" Filtered="true" Alias="[i]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="strBxOrderNo" /> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItem]" Alias="[i]" Column="sintOrderSeqNo" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[strBxOrderNo] as [o].[strBxOrderNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="strBxOrderNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrderItemReturn].[sintOrderSeqNo] as [oir].[sintOrderSeqNo]"> | |
| <Identifier> | |
| <ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrderItemReturn]" Alias="[oir]" Column="sintOrderSeqNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| </Concat> | |
| </RelOp> | |
| </Sort> | |
| </RelOp> | |
| </QueryPlan> | |
| </StmtSimple> | |
| </Statements> | |
| </Batch> | |
| </BatchSequence> | |
| </ShowPlanXML> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment