Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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.5" Build="14.0.304.496" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="1000" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="130" StatementSubTreeCost="1037.7" StatementText="SELECT *
 FROM [SPENDBY].[FactInvoiceDetail]
 ORder by id
 offset 1000000 rows fetch next 1000 rows only" StatementType="SELECT" QueryHash="0x750F5423A7CC6EF9" QueryPlanHash="0x9C1E9EABA9315041" RetrievedFromCache="true" StatementSqlHandle="0x0900A56F96C2D020EF6AA1F742A9230656000000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="10" ParentObjectId="0" StatementParameterizationType="0" SecurityPolicyApplied="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 CachedPlanSize="128" CompileTime="5" CompileCPU="5" CompileMemory="760">
- <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="5872010" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="10198080" />
- <RelOp AvgRowSize="4725" EstimateCPU="0.1001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="1037.7">
- <OutputList>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Description" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="TaxValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="GrossValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="CurrencyCode" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInUSD" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInGBP" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInEUR" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Included" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="ETLLineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VendorParentID" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SystemDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="DueDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="InvoiceDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SupplierNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="EntryDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="PaymentDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SourceSystemId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LoadCycleId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Checksum" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherDistributionLineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="POUnitPrice" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="_IsLobApplied" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimChartOfAccountId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCostCentreId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCompanyCodeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimTaxCodeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimDocumentTypeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialGroupId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialNumberId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPaymentTermId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPlantId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimProfitCentreId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimSupplierId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUnspscCategorisationId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBusinessUnitId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimInvoiceHeaderId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBuyingChannelsId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimContractIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCatalogueIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined1Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined2Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined3Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined4Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined5Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined6Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined7Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined8Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined9Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined10Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined11Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined12Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined13Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined14Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined15Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined16Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined17Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined18Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined19Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined20Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined21Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined22Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined23Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined24Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined25Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined26Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined27Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined28Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined29Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined30Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined31Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined32Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined33Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined34Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined35Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined36Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined37Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined38Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined39Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined40Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined41Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined42Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined43Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined44Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined45Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined46Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined47Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined48Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined49Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined50Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredbusinessnameId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredparentnameId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimLineofbusinessId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_Dim88Id" />
- </OutputList>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <OffsetExpression>
- <ScalarOperator ScalarString="(1000000)">
- <Const ConstValue="(1000000)" />
- </ScalarOperator>
- </OffsetExpression>
- <TopExpression>
- <ScalarOperator ScalarString="(1000)">
- <Const ConstValue="(1000)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="4725" EstimateCPU="148.963" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1001000" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1037.6">
- <OutputList>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Description" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="TaxValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="GrossValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="CurrencyCode" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInUSD" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInGBP" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInEUR" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Included" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="ETLLineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VendorParentID" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SystemDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="DueDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="InvoiceDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SupplierNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="EntryDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="PaymentDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SourceSystemId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LoadCycleId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Checksum" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherDistributionLineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="POUnitPrice" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="_IsLobApplied" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimChartOfAccountId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCostCentreId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCompanyCodeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimTaxCodeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimDocumentTypeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialGroupId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialNumberId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPaymentTermId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPlantId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimProfitCentreId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimSupplierId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUnspscCategorisationId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBusinessUnitId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimInvoiceHeaderId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBuyingChannelsId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimContractIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCatalogueIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined1Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined2Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined3Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined4Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined5Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined6Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined7Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined8Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined9Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined10Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined11Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined12Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined13Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined14Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined15Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined16Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined17Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined18Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined19Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined20Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined21Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined22Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined23Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined24Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined25Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined26Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined27Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined28Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined29Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined30Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined31Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined32Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined33Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined34Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined35Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined36Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined37Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined38Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined39Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined40Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined41Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined42Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined43Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined44Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined45Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined46Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined47Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined48Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined49Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined50Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredbusinessnameId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredparentnameId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimLineofbusinessId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_Dim88Id" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Column="ColStoreLoc1000" />
- </OuterReferences>
- <RelOp AvgRowSize="23" EstimateCPU="39.2008" EstimateIO="97.8979" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1001000" EstimatedRowsRead="35637000" LogicalOp="Index Scan" NodeId="2" Parallel="false" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="3.85413" TableCardinality="35637000">
- <OutputList>
- <ColumnReference Column="ColStoreLoc1000" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Id" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="ColStoreLoc1000" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Index="[pk_SPENDBY_FactInvoiceDetail]" IndexKind="NonClustered" Storage="RowStore" />
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="4717" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1001000" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1029.57" TableCardinality="35637000">
- <OutputList>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Description" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="TaxValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="GrossValue" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="CurrencyCode" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInUSD" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInGBP" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInEUR" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Included" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="ETLLineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VendorParentID" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SystemDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="DueDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="InvoiceDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SupplierNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="EntryDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="PaymentDate" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SourceSystemId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LoadCycleId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Checksum" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherDistributionLineNumber" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="POUnitPrice" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="_IsLobApplied" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimChartOfAccountId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCostCentreId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCompanyCodeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimTaxCodeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimDocumentTypeId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialGroupId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialNumberId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPaymentTermId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPlantId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimProfitCentreId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimSupplierId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUnspscCategorisationId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBusinessUnitId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimInvoiceHeaderId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBuyingChannelsId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimContractIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCatalogueIndicatorId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined1Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined2Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined3Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined4Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined5Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined6Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined7Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined8Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined9Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined10Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined11Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined12Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined13Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined14Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined15Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined16Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined17Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined18Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined19Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined20Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined21Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined22Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined23Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined24Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined25Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined26Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined27Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined28Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined29Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined30Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined31Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined32Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined33Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined34Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined35Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined36Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined37Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined38Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined39Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined40Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined41Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined42Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined43Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined44Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined45Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined46Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined47Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined48Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined49Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined50Id" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredbusinessnameId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredparentnameId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimLineofbusinessId" />
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_Dim88Id" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="ColumnStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LineNumber" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Description" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValue" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="TaxValue" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="GrossValue" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="CurrencyCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInUSD" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInGBP" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="NetValueInEUR" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Included" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="ETLLineNumber" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VendorParentID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SystemDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="DueDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="InvoiceDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SupplierNumber" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="EntryDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherNumber" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="PaymentDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="SourceSystemId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="LoadCycleId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="Checksum" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="VoucherDistributionLineNumber" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="POUnitPrice" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="_IsLobApplied" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimChartOfAccountId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCostCentreId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCompanyCodeId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimTaxCodeId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimDocumentTypeId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialGroupId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimMaterialNumberId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPaymentTermId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPlantId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimProfitCentreId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimSupplierId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUnspscCategorisationId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBusinessUnitId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimInvoiceHeaderId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimPurchaseOrderIndicatorId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimBuyingChannelsId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimContractIndicatorId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimCatalogueIndicatorId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined1Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined2Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined3Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined4Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined5Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined6Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined7Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined8Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined9Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined10Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined11Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined12Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined13Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined14Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined15Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined16Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined17Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined18Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined19Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined20Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined21Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined22Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined23Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined24Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined25Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined26Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined27Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined28Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined29Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined30Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined31Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined32Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined33Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined34Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined35Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined36Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined37Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined38Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined39Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined40Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined41Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined42Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined43Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined44Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined45Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined46Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined47Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined48Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined49Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimUserDefined50Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredbusinessnameId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimRegisteredparentnameId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_DimLineofbusinessId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Column="FK_Dim88Id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[V8_AzureAdmin_NBCUTest_1249_v4]" Schema="[SPENDBY]" Table="[FactInvoiceDetail]" Index="[cci_SPENDBY_FactInvoiceDetail]" TableReferenceId="-1" IndexKind="Clustered" Storage="ColumnStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Column="ColStoreLoc1000" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[ColStoreLoc1000]">
- <Identifier>
- <ColumnReference Column="ColStoreLoc1000" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement