Comparar texto

Encuentra la diferencia entre dos archivos de texto

Real-time diff

Unified diff

Collapse lines

Highlight change

Syntax highlighting

Herramientas

Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

Comparing sensitive data, confidential files or internal emails?

Most legal and privacy policies prohibit uploading sensitive data online. Diffchecker Desktop ensures your confidential information never leaves your computer. Work offline and compare documents securely.

Download Diffchecker Desktop Learn more

MethodVsQueryJoinsKinetic2023

Created about a year agoDiff never expires

0 removals

465 lines

0 additions

465 lines

SELECT [Project2].[C1] AS [C1],

[Project2].[PartDescription] AS [PartDescription],

[Project2].[AccountCoordinator_c] AS [AccountCoordinator_c],

[Project2].[C2] AS [C2],

[Project2].[VoidLine] AS [VoidLine],

[Project2].[OpenLine] AS [OpenLine],

[Project2].[Company] AS [Company],

[Project2].[OrderNum] AS [OrderNum],

[Project2].[OrderLine] AS [OrderLine],

[Project2].[LineType] AS [LineType],

[Project2].[PartNum] AS [PartNum],

[Project2].[LineDesc] AS [LineDesc],

[Project2].[Reference] AS [Reference],

[Project2].[IUM] AS [IUM],

[Project2].[RevisionNum] AS [RevisionNum],

[Project2].[POLine] AS [POLine],

[Project2].[Commissionable] AS [Commissionable],

[Project2].[DiscountPercent] AS [DiscountPercent],

[Project2].[UnitPrice] AS [UnitPrice],

[Project2].[DocUnitPrice] AS [DocUnitPrice],

[Project2].[OrderQty] AS [OrderQty],

[Project2].[Discount] AS [Discount],

[Project2].[DocDiscount] AS [DocDiscount],

[Project2].[RequestDate] AS [RequestDate],

[Project2].[ProdCode] AS [ProdCode],

[Project2].[XPartNum] AS [XPartNum],

[Project2].[XRevisionNum] AS [XRevisionNum],

[Project2].[PricePerCode] AS [PricePerCode],

[Project2].[OrderComment] AS [OrderComment],

[Project2].[ShipComment] AS [ShipComment],

[Project2].[InvoiceComment] AS [InvoiceComment],

[Project2].[PickListComment] AS [PickListComment],

[Project2].[TaxCatID] AS [TaxCatID],

[Project2].[AdvanceBillBal] AS [AdvanceBillBal],

[Project2].[DocAdvanceBillBal] AS [DocAdvanceBillBal],

[Project2].[QuoteNum] AS [QuoteNum],

[Project2].[QuoteLine] AS [QuoteLine],

[Project2].[TMBilling] AS [TMBilling],

[Project2].[OrigWhyNoTax] AS [OrigWhyNoTax],

[Project2].[NeedByDate] AS [NeedByDate],

[Project2].[CustNum] AS [CustNum],

[Project2].[Rework] AS [Rework],

[Project2].[RMANum] AS [RMANum],

[Project2].[RMALine] AS [RMALine],

[Project2].[ProjectID] AS [ProjectID],

[Project2].[ContractNum] AS [ContractNum],

[Project2].[ContractCode] AS [ContractCode],

[Project2].[BasePartNum] AS [BasePartNum],

[Project2].[Warranty] AS [Warranty],

[Project2].[WarrantyCode] AS [WarrantyCode],

[Project2].[MaterialDuration] AS [MaterialDuration],

[Project2].[LaborDuration] AS [LaborDuration],

[Project2].[MiscDuration] AS [MiscDuration],

[Project2].[MaterialMod] AS [MaterialMod],

[Project2].[LaborMod] AS [LaborMod],

[Project2].[WarrantyComment] AS [WarrantyComment],

[Project2].[Onsite] AS [Onsite],

[Project2].[MatCovered] AS [MatCovered],

[Project2].[LabCovered] AS [LabCovered],

[Project2].[MiscCovered] AS [MiscCovered],

[Project2].[SalesUM] AS [SalesUM],

[Project2].[SellingFactor] AS [SellingFactor],

[Project2].[SellingQuantity] AS [SellingQuantity],

[Project2].[SalesCatID] AS [SalesCatID],

[Project2].[ShipLineComplete] AS [ShipLineComplete],

[Project2].[CumeQty] AS [CumeQty],

[Project2].[CumeDate] AS [CumeDate],

[Project2].[MktgCampaignID] AS [MktgCampaignID],

[Project2].[MktgEvntSeq] AS [MktgEvntSeq],

[Project2].[LockQty] AS [LockQty],

[Project2].[Linked] AS [Linked],

[Project2].[ICPONum] AS [ICPONum],

[Project2].[ICPOLine] AS [ICPOLine],

[Project2].[ExtCompany] AS [ExtCompany],

[Project2].[LastConfigDate] AS [LastConfigDate],

[Project2].[LastConfigTime] AS [LastConfigTime],

[Project2].[LastConfigUserID] AS [LastConfigUserID],

[Project2].[ConfigUnitPrice] AS [ConfigUnitPrice],

[Project2].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],

[Project2].[PriceListCode] AS [PriceListCode],

[Project2].[BreakListCode] AS [BreakListCode],

[Project2].[PricingQty] AS [PricingQty],

[Project2].[LockPrice] AS [LockPrice],

[Project2].[ListPrice] AS [ListPrice],

[Project2].[DocListPrice] AS [DocListPrice],

[Project2].[OrdBasedPrice] AS [OrdBasedPrice],

[Project2].[DocOrdBasedPrice] AS [DocOrdBasedPrice],

[Project2].[PriceGroupCode] AS [PriceGroupCode],

[Project2].[OverridePriceList] AS [OverridePriceList],

[Project2].[BaseRevisionNum] AS [BaseRevisionNum],

[Project2].[PricingValue] AS [PricingValue],

[Project2].[DisplaySeq] AS [DisplaySeq],

[Project2].[KitParentLine] AS [KitParentLine],

[Project2].[KitAllowUpdate] AS [KitAllowUpdate],

[Project2].[KitShipComplete] AS [KitShipComplete],

[Project2].[KitBackFlush] AS [KitBackFlush],

[Project2].[KitPrintCompsPS] AS [KitPrintCompsPS],

[Project2].[KitPrintCompsInv] AS [KitPrintCompsInv],

[Project2].[KitPricing] AS [KitPricing],

[Project2].[KitQtyPer] AS [KitQtyPer],

[Project2].[SellingFactorDirection] AS [SellingFactorDirection],

[Project2].[RepRate1] AS [RepRate1],

[Project2].[RepRate2] AS [RepRate2],

[Project2].[RepRate3] AS [RepRate3],

[Project2].[RepRate4] AS [RepRate4],

[Project2].[RepRate5] AS [RepRate5],

[Project2].[RepSplit1] AS [RepSplit1],

[Project2].[RepSplit2] AS [RepSplit2],

[Project2].[RepSplit3] AS [RepSplit3],

[Project2].[RepSplit4] AS [RepSplit4],

[Project2].[RepSplit5] AS [RepSplit5],

[Project2].[DemandContractLine] AS [DemandContractLine],

[Project2].[CreateNewJob] AS [CreateNewJob],

[Project2].[DoNotShipBeforeDate] AS [DoNotShipBeforeDate],

[Project2].[GetDtls] AS [GetDtls],

[Project2].[DoNotShipAfterDate] AS [DoNotShipAfterDate],

[Project2].[SchedJob] AS [SchedJob],

[Project2].[RelJob] AS [RelJob],

[Project2].[EnableCreateNewJob] AS [EnableCreateNewJob],

[Project2].[EnableGetDtls] AS [EnableGetDtls],

[Project2].[EnableSchedJob] AS [EnableSchedJob],

[Project2].[EnableRelJob] AS [EnableRelJob],

[Project2].[CounterSaleWarehouse] AS [CounterSaleWarehouse],

[Project2].[CounterSaleBinNum] AS [CounterSaleBinNum],

[Project2].[CounterSaleLotNum] AS [CounterSaleLotNum],

[Project2].[CounterSaleDimCode] AS [CounterSaleDimCode],

[Project2].[DemandDtlRejected] AS [DemandDtlRejected],

[Project2].[KitFlag] AS [KitFlag],

[Project2].[KitsLoaded] AS [KitsLoaded],

[Project2].[DemandContractNum] AS [DemandContractNum],

[Project2].[DemandHeadSeq] AS [DemandHeadSeq],

[Project2].[DemandDtlSeq] AS [DemandDtlSeq],

[Project2].[ChangedBy] AS [ChangedBy],

[Project2].[ChangeDate] AS [ChangeDate],

[Project2].[ChangeTime] AS [ChangeTime],

[Project2].[ReverseCharge] AS [ReverseCharge],

[Project2].[TotalReleases] AS [TotalReleases],

[Project2].[Rpt1UnitPrice] AS [Rpt1UnitPrice],

[Project2].[Rpt2UnitPrice] AS [Rpt2UnitPrice],

[Project2].[Rpt3UnitPrice] AS [Rpt3UnitPrice],

[Project2].[Rpt1Discount] AS [Rpt1Discount],

[Project2].[Rpt2Discount] AS [Rpt2Discount],

[Project2].[Rpt3Discount] AS [Rpt3Discount],

[Project2].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],

[Project2].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],

[Project2].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],

[Project2].[Rpt1ListPrice] AS [Rpt1ListPrice],

[Project2].[Rpt2ListPrice] AS [Rpt2ListPrice],

[Project2].[Rpt3ListPrice] AS [Rpt3ListPrice],

[Project2].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],

[Project2].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],

[Project2].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],

[Project2].[ExtPriceDtl] AS [ExtPriceDtl],

[Project2].[DocExtPriceDtl] AS [DocExtPriceDtl],

[Project2].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],

[Project2].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],

[Project2].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],

[Project2].[LineStatus] AS [LineStatus],

[Project2].[InUnitPrice] AS [InUnitPrice],

[Project2].[DocInUnitPrice] AS [DocInUnitPrice],

[Project2].[InDiscount] AS [InDiscount],

[Project2].[DocInDiscount] AS [DocInDiscount],

[Project2].[InListPrice] AS [InListPrice],

[Project2].[DocInListPrice] AS [DocInListPrice],

[Project2].[InOrdBasedPrice] AS [InOrdBasedPrice],

[Project2].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],

[Project2].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],

[Project2].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],

[Project2].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],

[Project2].[Rpt1InDiscount] AS [Rpt1InDiscount],

[Project2].[Rpt2InDiscount] AS [Rpt2InDiscount],

[Project2].[Rpt3InDiscount] AS [Rpt3InDiscount],

[Project2].[Rpt1InListPrice] AS [Rpt1InListPrice],

[Project2].[Rpt2InListPrice] AS [Rpt2InListPrice],

[Project2].[Rpt3InListPrice] AS [Rpt3InListPrice],

[Project2].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],

[Project2].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],

[Project2].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],

[Project2].[InExtPriceDtl] AS [InExtPriceDtl],

[Project2].[DocInExtPriceDtl] AS [DocInExtPriceDtl],

[Project2].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],

[Project2].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],

[Project2].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],

[Project2].[OldOurOpenQty] AS [OldOurOpenQty],

[Project2].[OldSellingOpenQty] AS [OldSellingOpenQty],

[Project2].[OldOpenValue] AS [OldOpenValue],

[Project2].[OldProdCode] AS [OldProdCode],

[Project2].[PrevSellQty] AS [PrevSellQty],

[Project2].[PrevPartNum] AS [PrevPartNum],

[Project2].[PrevXPartNum] AS [PrevXPartNum],

[Project2].[KitCompOrigSeq] AS [KitCompOrigSeq],

[Project2].[KitCompOrigPart] AS [KitCompOrigPart],

[Project2].[SmartStringProcessed] AS [SmartStringProcessed],

[Project2].[SmartString] AS [SmartString],

[Project2].[RenewalNbr] AS [RenewalNbr],

[Project2].[DiscBreakListCode] AS [DiscBreakListCode],

[Project2].[DiscListPrice] AS [DiscListPrice],

[Project2].[LockDisc] AS [LockDisc],

[Project2].[OverrideDiscPriceList] AS [OverrideDiscPriceList],

[Project2].[GroupSeq] AS [GroupSeq],

[Project2].[ECCOrderNum] AS [ECCOrderNum],

[Project2].[ECCOrderLine] AS [ECCOrderLine],

[Project2].[DupOnJobCrt] AS [DupOnJobCrt],

[Project2].[UndersPct] AS [UndersPct],

[Project2].[Overs] AS [Overs],

[Project2].[Unders] AS [Unders],

[Project2].[OversUnitPrice] AS [OversUnitPrice],

[Project2].[PlanUserID] AS [PlanUserID],

[Project2].[PlanGUID] AS [PlanGUID],

[Project2].[MOMsourceType] AS [MOMsourceType],

[Project2].[MOMsourceEst] AS [MOMsourceEst],

[Project2].[DefaultOversPricing] AS [DefaultOversPricing],

[Project2].[ECCPlant] AS [ECCPlant],

[Project2].[ECCQuoteNum] AS [ECCQuoteNum],

[Project2].[ECCQuoteLine] AS [ECCQuoteLine],

[Project2].[SysRevID] AS [SysRevID],

[Project2].[ForeignSysRowID] AS [ForeignSysRowID],

[Project2].[MfgJobType] AS [MfgJobType],

[Project2].[ProFormaInvComment] AS [ProFormaInvComment],

[Project2].[CreateJob] AS [CreateJob],

[Project2].[ContractID] AS [ContractID],

[Project2].[LinkToContract] AS [LinkToContract],

[Project2].[DocInAdvanceBillBal] AS [DocInAdvanceBillBal],

[Project2].[InAdvanceBillBal] AS [InAdvanceBillBal],

[Project2].[Rpt1InAdvanceBillBal] AS [Rpt1InAdvanceBillBal],

[Project2].[Rpt2InAdvanceBillBal] AS [Rpt2InAdvanceBillBal],

[Project2].[Rpt3InAdvanceBillBal] AS [Rpt3InAdvanceBillBal],

[Project2].[PCLinkRemoved] AS [PCLinkRemoved],

[Project2].[CommodityCode] AS [CommodityCode],

[Project2].[MSRP] AS [MSRP],

[Project2].[DocMSRP] AS [DocMSRP],

[Project2].[Rpt1MSRP] AS [Rpt1MSRP],

[Project2].[Rpt2MSRP] AS [Rpt2MSRP],

[Project2].[Rpt3MSRP] AS [Rpt3MSRP],

[Project2].[EndCustomerPrice] AS [EndCustomerPrice],

[Project2].[DocEndCustomerPrice] AS [DocEndCustomerPrice],

[Project2].[Rpt1EndCustomerPrice] AS [Rpt1EndCustomerPrice],

[Project2].[Rpt2EndCustomerPrice] AS [Rpt2EndCustomerPrice],

[Project2].[Rpt3EndCustomerPrice] AS [Rpt3EndCustomerPrice],

[Project2].[PromotionalPrice] AS [PromotionalPrice],

[Project2].[DocPromotionalPrice] AS [DocPromotionalPrice],

[Project2].[Rpt1PromotionalPrice] AS [Rpt1PromotionalPrice],

[Project2].[Rpt2PromotionalPrice] AS [Rpt2PromotionalPrice],

[Project2].[Rpt3PromotionalPrice] AS [Rpt3PromotionalPrice],

[Project2].[OrderLineStatusCode] AS [OrderLineStatusCode],

[Project2].[AttributeSetID] AS [AttributeSetID],

[Project2].[KBConfigProdID] AS [KBConfigProdID],

[Project2].[KBOriginalConfigProdID] AS [KBOriginalConfigProdID],

[Project2].[UD_SysRevID] AS [UD_SysRevID],

[Project2].[sgcCloseReason_c] AS [sgcCloseReason_c],

[Project2].[EstUnitCost_c] AS [EstUnitCost_c],

[Project2].[SalesAgentReviewed_c] AS [SalesAgentReviewed_c],

[Project2].[ManagerReviewed_c] AS [ManagerReviewed_c],

[Project2].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],

[Project2].[Branch0DollarComments_c] AS [Branch0DollarComments_c],

[Project2].[sgc3PLRef_c] AS [sgc3PLRef_c]

FROM

(

SELECT [Distinct1].[PartDescription] AS [PartDescription],

[Distinct1].[AccountCoordinator_c] AS [AccountCoordinator_c],

1 AS [C1],

[Join14].[ForeignSysRowID1] AS [ForeignSysRowID],

[Join14].[UD_SysRevID1] AS [UD_SysRevID],

[Join14].[sgcCloseReason_c1] AS [sgcCloseReason_c],

[Join14].[EstUnitCost_c] AS [EstUnitCost_c],

[Join14].[SalesAgentReviewed_c1] AS [SalesAgentReviewed_c],

[Join14].[ManagerReviewed_c1] AS [ManagerReviewed_c],

[Join14].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],

[Join14].[Branch0DollarComments_c] AS [Branch0DollarComments_c],

[Join14].[sgc3PLRef_c1] AS [sgc3PLRef_c],

[Join14].[VoidLine] AS [VoidLine],

[Join14].[OpenLine] AS [OpenLine],

[Join14].[Company1] AS [Company],

[Join14].[OrderNum1] AS [OrderNum],

[Join14].[OrderLine] AS [OrderLine],

[Join14].[LineType] AS [LineType],

[Join14].[PartNum1] AS [PartNum],

[Join14].[LineDesc] AS [LineDesc],

[Join14].[Reference] AS [Reference],

[Join14].[IUM1] AS [IUM],

[Join14].[RevisionNum] AS [RevisionNum],

[Join14].[POLine] AS [POLine],

[Join14].[Commissionable] AS [Commissionable],

[Join14].[DiscountPercent1] AS [DiscountPercent],

[Join14].[UnitPrice1] AS [UnitPrice],

[Join14].[DocUnitPrice] AS [DocUnitPrice],

[Join14].[OrderQty] AS [OrderQty],

[Join14].[Discount] AS [Discount],

[Join14].[DocDiscount] AS [DocDiscount],

[Join14].[RequestDate1] AS [RequestDate],

[Join14].[ProdCode1] AS [ProdCode],

[Join14].[XPartNum] AS [XPartNum],

[Join14].[XRevisionNum] AS [XRevisionNum],

[Join14].[PricePerCode1] AS [PricePerCode],

[Join14].[OrderComment1] AS [OrderComment],

[Join14].[ShipComment1] AS [ShipComment],

[Join14].[InvoiceComment1] AS [InvoiceComment],

[Join14].[PickListComment1] AS [PickListComment],

[Join14].[TaxCatID1] AS [TaxCatID],

[Join14].[AdvanceBillBal] AS [AdvanceBillBal],

[Join14].[DocAdvanceBillBal] AS [DocAdvanceBillBal],

[Join14].[QuoteNum] AS [QuoteNum],

[Join14].[QuoteLine] AS [QuoteLine],

[Join14].[TMBilling] AS [TMBilling],

[Join14].[OrigWhyNoTax] AS [OrigWhyNoTax],

[Join14].[NeedByDate1] AS [NeedByDate],

[Join14].[CustNum1] AS [CustNum],

[Join14].[Rework] AS [Rework],

[Join14].[RMANum] AS [RMANum],

[Join14].[RMALine] AS [RMALine],

[Join14].[ProjectID] AS [ProjectID],

[Join14].[ContractNum] AS [ContractNum],

[Join14].[ContractCode] AS [ContractCode],

[Join14].[BasePartNum1] AS [BasePartNum],

[Join14].[Warranty] AS [Warranty],

[Join14].[WarrantyCode1] AS [WarrantyCode],

[Join14].[MaterialDuration] AS [MaterialDuration],

[Join14].[LaborDuration] AS [LaborDuration],

[Join14].[MiscDuration] AS [MiscDuration],

[Join14].[MaterialMod] AS [MaterialMod],

[Join14].[LaborMod] AS [LaborMod],

[Join14].[WarrantyComment] AS [WarrantyComment],

[Join14].[Onsite] AS [Onsite],

[Join14].[MatCovered] AS [MatCovered],

[Join14].[LabCovered] AS [LabCovered],

[Join14].[MiscCovered] AS [MiscCovered],

[Join14].[SalesUM1] AS [SalesUM],

[Join14].[SellingFactor1] AS [SellingFactor],

[Join14].[SellingQuantity] AS [SellingQuantity],

[Join14].[SalesCatID] AS [SalesCatID],

[Join14].[ShipLineComplete] AS [ShipLineComplete],

[Join14].[CumeQty] AS [CumeQty],

[Join14].[CumeDate] AS [CumeDate],

[Join14].[MktgCampaignID] AS [MktgCampaignID],

[Join14].[MktgEvntSeq] AS [MktgEvntSeq],

[Join14].[LockQty1] AS [LockQty],

[Join14].[Linked1] AS [Linked],

[Join14].[ICPONum1] AS [ICPONum],

[Join14].[ICPOLine] AS [ICPOLine],

[Join14].[ExtCompany1] AS [ExtCompany],

[Join14].[LastConfigDate] AS [LastConfigDate],

[Join14].[LastConfigTime] AS [LastConfigTime],

[Join14].[LastConfigUserID] AS [LastConfigUserID],

[Join14].[ConfigUnitPrice] AS [ConfigUnitPrice],

[Join14].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],

[Join14].[PriceListCode] AS [PriceListCode],

[Join14].[BreakListCode] AS [BreakListCode],

[Join14].[PricingQty] AS [PricingQty],

[Join14].[LockPrice] AS [LockPrice],

[Join14].[ListPrice] AS [ListPrice],

[Join14].[DocListPrice] AS [DocListPrice],

[Join14].[OrdBasedPrice] AS [OrdBasedPrice],

[Join14].[DocOrdBasedPrice] AS [DocOrdBasedPrice],

[Join14].[PriceGroupCode] AS [PriceGroupCode],

[Join14].[OverridePriceList] AS [OverridePriceList],

[Join14].[BaseRevisionNum] AS [BaseRevisionNum],

[Join14].[PricingValue] AS [PricingValue],

[Join14].[DisplaySeq] AS [DisplaySeq],

[Join14].[KitParentLine] AS [KitParentLine],

[Join14].[KitAllowUpdate] AS [KitAllowUpdate],

[Join14].[KitShipComplete] AS [KitShipComplete],

[Join14].[KitBackFlush] AS [KitBackFlush],

[Join14].[KitPrintCompsPS] AS [KitPrintCompsPS],

[Join14].[KitPrintCompsInv] AS [KitPrintCompsInv],

[Join14].[KitPricing] AS [KitPricing],

[Join14].[KitQtyPer] AS [KitQtyPer],

[Join14].[SellingFactorDirection1] AS [SellingFactorDirection],

[Join14].[RepRate11] AS [RepRate1],

[Join14].[RepRate21] AS [RepRate2],

[Join14].[RepRate31] AS [RepRate3],

[Join14].[RepRate41] AS [RepRate4],

[Join14].[RepRate51] AS [RepRate5],

[Join14].[RepSplit11] AS [RepSplit1],

[Join14].[RepSplit21] AS [RepSplit2],

[Join14].[RepSplit31] AS [RepSplit3],

[Join14].[RepSplit41] AS [RepSplit4],

[Join14].[RepSplit51] AS [RepSplit5],

[Join14].[DemandContractLine] AS [DemandContractLine],

[Join14].[CreateNewJob] AS [CreateNewJob],

[Join14].[DoNotShipBeforeDate1] AS [DoNotShipBeforeDate],

[Join14].[GetDtls] AS [GetDtls],

[Join14].[DoNotShipAfterDate1] AS [DoNotShipAfterDate],

[Join14].[SchedJob] AS [SchedJob],

[Join14].[RelJob] AS [RelJob],

[Join14].[EnableCreateNewJob] AS [EnableCreateNewJob],

[Join14].[EnableGetDtls] AS [EnableGetDtls],

[Join14].[EnableSchedJob] AS [EnableSchedJob],

[Join14].[EnableRelJob] AS [EnableRelJob],

[Join14].[CounterSaleWarehouse] AS [CounterSaleWarehouse],

[Join14].[CounterSaleBinNum] AS [CounterSaleBinNum],

[Join14].[CounterSaleLotNum] AS [CounterSaleLotNum],

[Join14].[CounterSaleDimCode] AS [CounterSaleDimCode],

[Join14].[DemandDtlRejected] AS [DemandDtlRejected],

[Join14].[KitFlag] AS [KitFlag],

[Join14].[KitsLoaded] AS [KitsLoaded],

[Join14].[DemandContractNum1] AS [DemandContractNum],

[Join14].[DemandHeadSeq1] AS [DemandHeadSeq],

[Join14].[DemandDtlSeq] AS [DemandDtlSeq],

[Join14].[ChangedBy1] AS [ChangedBy],

[Join14].[ChangeDate1] AS [ChangeDate],

[Join14].[ChangeTime1] AS [ChangeTime],

[Join14].[ReverseCharge] AS [ReverseCharge],

[Join14].[TotalReleases1] AS [TotalReleases],

[Join14].[Rpt1UnitPrice] AS [Rpt1UnitPrice],

[Join14].[Rpt2UnitPrice] AS [Rpt2UnitPrice],

[Join14].[Rpt3UnitPrice] AS [Rpt3UnitPrice],

[Join14].[Rpt1Discount] AS [Rpt1Discount],

[Join14].[Rpt2Discount] AS [Rpt2Discount],

[Join14].[Rpt3Discount] AS [Rpt3Discount],

[Join14].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],

[Join14].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],

[Join14].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],

[Join14].[Rpt1ListPrice] AS [Rpt1ListPrice],

[Join14].[Rpt2ListPrice] AS [Rpt2ListPrice],

[Join14].[Rpt3ListPrice] AS [Rpt3ListPrice],

[Join14].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],

[Join14].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],

[Join14].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],

[Join14].[ExtPriceDtl] AS [ExtPriceDtl],

[Join14].[DocExtPriceDtl] AS [DocExtPriceDtl],

[Join14].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],

[Join14].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],

[Join14].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],

[Join14].[LineStatus] AS [LineStatus],

[Join14].[InUnitPrice] AS [InUnitPrice],

[Join14].[DocInUnitPrice] AS [DocInUnitPrice],

[Join14].[InDiscount] AS [InDiscount],

[Join14].[DocInDiscount] AS [DocInDiscount],

[Join14].[InListPrice] AS [InListPrice],

[Join14].[DocInListPrice] AS [DocInListPrice],

[Join14].[InOrdBasedPrice] AS [InOrdBasedPrice],

[Join14].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],

[Join14].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],

[Join14].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],

[Join14].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],

[Join14].[Rpt1InDiscount] AS [Rpt1InDiscount],

[Join14].[Rpt2InDiscount] AS [Rpt2InDiscount],

[Join14].[Rpt3InDiscount] AS [Rpt3InDiscount],

[Join14].[Rpt1InListPrice] AS [Rpt1InListPrice],

[Join14].[Rpt2InListPrice] AS [Rpt2InListPrice],

[Join14].[Rpt3InListPrice] AS [Rpt3InListPrice],

[Join14].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],

[Join14].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],

[Join14].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],

[Join14].[InExtPriceDtl] AS [InExtPriceDtl],

[Join14].[DocInExtPriceDtl] AS [DocInExtPriceDtl],

[Join14].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],

[Join14].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],

[Join14].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],

[Join14].[OldOurOpenQty] AS [OldOurOpenQty],

[Join14].[OldSellingOpenQty] AS [OldSellingOpenQty],

[Join14].[OldOpenValue] AS [OldOpenValue],

[Join14].[OldProdCode] AS [OldProdCode],

[Join14].[PrevSellQty] AS [PrevSellQty],

[Join14].[PrevPartNum] AS [PrevPartNum],

[Join14].[PrevXPartNum] AS [PrevXPartNum],

[Join14].[KitCompOrigSeq] AS [KitCompOrigSeq],

[Join14].[KitCompOrigPart] AS [KitCompOrigPart],

[Join14].[SmartStringProcessed] AS [SmartStringProcessed],

[Join14].[SmartString] AS [SmartString],

[Join14].[RenewalNbr] AS [RenewalNbr],

[Join14].[DiscBreakListCode] AS [DiscBreakListCode],

[Join14].[DiscListPrice] AS [DiscListPrice],

[Join14].[LockDisc] AS [LockDisc],

[Join14].[OverrideDiscPriceL

Diffs guardadas

Texto original

Open file

SELECT [Project2].[C1] AS [C1],
       [Project2].[PartDescription] AS [PartDescription],
       [Project2].[AccountCoordinator_c] AS [AccountCoordinator_c],
       [Project2].[C2] AS [C2],
       [Project2].[VoidLine] AS [VoidLine],
       [Project2].[OpenLine] AS [OpenLine],
       [Project2].[Company] AS [Company],
       [Project2].[OrderNum] AS [OrderNum],
       [Project2].[OrderLine] AS [OrderLine],
       [Project2].[LineType] AS [LineType],
       [Project2].[PartNum] AS [PartNum],
       [Project2].[LineDesc] AS [LineDesc],
       [Project2].[Reference] AS [Reference],
       [Project2].[IUM] AS [IUM],
       [Project2].[RevisionNum] AS [RevisionNum],
       [Project2].[POLine] AS [POLine],
       [Project2].[Commissionable] AS [Commissionable],
       [Project2].[DiscountPercent] AS [DiscountPercent],
       [Project2].[UnitPrice] AS [UnitPrice],
       [Project2].[DocUnitPrice] AS [DocUnitPrice],
       [Project2].[OrderQty] AS [OrderQty],
       [Project2].[Discount] AS [Discount],
       [Project2].[DocDiscount] AS [DocDiscount],
       [Project2].[RequestDate] AS [RequestDate],
       [Project2].[ProdCode] AS [ProdCode],
       [Project2].[XPartNum] AS [XPartNum],
       [Project2].[XRevisionNum] AS [XRevisionNum],
       [Project2].[PricePerCode] AS [PricePerCode],
       [Project2].[OrderComment] AS [OrderComment],
       [Project2].[ShipComment] AS [ShipComment],
       [Project2].[InvoiceComment] AS [InvoiceComment],
       [Project2].[PickListComment] AS [PickListComment],
       [Project2].[TaxCatID] AS [TaxCatID],
       [Project2].[AdvanceBillBal] AS [AdvanceBillBal],
       [Project2].[DocAdvanceBillBal] AS [DocAdvanceBillBal],
       [Project2].[QuoteNum] AS [QuoteNum],
       [Project2].[QuoteLine] AS [QuoteLine],
       [Project2].[TMBilling] AS [TMBilling],
       [Project2].[OrigWhyNoTax] AS [OrigWhyNoTax],
       [Project2].[NeedByDate] AS [NeedByDate],
       [Project2].[CustNum] AS [CustNum],
       [Project2].[Rework] AS [Rework],
       [Project2].[RMANum] AS [RMANum],
       [Project2].[RMALine] AS [RMALine],
       [Project2].[ProjectID] AS [ProjectID],
       [Project2].[ContractNum] AS [ContractNum],
       [Project2].[ContractCode] AS [ContractCode],
       [Project2].[BasePartNum] AS [BasePartNum],
       [Project2].[Warranty] AS [Warranty],
       [Project2].[WarrantyCode] AS [WarrantyCode],
       [Project2].[MaterialDuration] AS [MaterialDuration],
       [Project2].[LaborDuration] AS [LaborDuration],
       [Project2].[MiscDuration] AS [MiscDuration],
       [Project2].[MaterialMod] AS [MaterialMod],
       [Project2].[LaborMod] AS [LaborMod],
       [Project2].[WarrantyComment] AS [WarrantyComment],
       [Project2].[Onsite] AS [Onsite],
       [Project2].[MatCovered] AS [MatCovered],
       [Project2].[LabCovered] AS [LabCovered],
       [Project2].[MiscCovered] AS [MiscCovered],
       [Project2].[SalesUM] AS [SalesUM],
       [Project2].[SellingFactor] AS [SellingFactor],
       [Project2].[SellingQuantity] AS [SellingQuantity],
       [Project2].[SalesCatID] AS [SalesCatID],
       [Project2].[ShipLineComplete] AS [ShipLineComplete],
       [Project2].[CumeQty] AS [CumeQty],
       [Project2].[CumeDate] AS [CumeDate],
       [Project2].[MktgCampaignID] AS [MktgCampaignID],
       [Project2].[MktgEvntSeq] AS [MktgEvntSeq],
       [Project2].[LockQty] AS [LockQty],
       [Project2].[Linked] AS [Linked],
       [Project2].[ICPONum] AS [ICPONum],
       [Project2].[ICPOLine] AS [ICPOLine],
       [Project2].[ExtCompany] AS [ExtCompany],
       [Project2].[LastConfigDate] AS [LastConfigDate],
       [Project2].[LastConfigTime] AS [LastConfigTime],
       [Project2].[LastConfigUserID] AS [LastConfigUserID],
       [Project2].[ConfigUnitPrice] AS [ConfigUnitPrice],
       [Project2].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],
       [Project2].[PriceListCode] AS [PriceListCode],
       [Project2].[BreakListCode] AS [BreakListCode],
       [Project2].[PricingQty] AS [PricingQty],
       [Project2].[LockPrice] AS [LockPrice],
       [Project2].[ListPrice] AS [ListPrice],
       [Project2].[DocListPrice] AS [DocListPrice],
       [Project2].[OrdBasedPrice] AS [OrdBasedPrice],
       [Project2].[DocOrdBasedPrice] AS [DocOrdBasedPrice],
       [Project2].[PriceGroupCode] AS [PriceGroupCode],
       [Project2].[OverridePriceList] AS [OverridePriceList],
       [Project2].[BaseRevisionNum] AS [BaseRevisionNum],
       [Project2].[PricingValue] AS [PricingValue],
       [Project2].[DisplaySeq] AS [DisplaySeq],
       [Project2].[KitParentLine] AS [KitParentLine],
       [Project2].[KitAllowUpdate] AS [KitAllowUpdate],
       [Project2].[KitShipComplete] AS [KitShipComplete],
       [Project2].[KitBackFlush] AS [KitBackFlush],
       [Project2].[KitPrintCompsPS] AS [KitPrintCompsPS],
       [Project2].[KitPrintCompsInv] AS [KitPrintCompsInv],
       [Project2].[KitPricing] AS [KitPricing],
       [Project2].[KitQtyPer] AS [KitQtyPer],
       [Project2].[SellingFactorDirection] AS [SellingFactorDirection],
       [Project2].[RepRate1] AS [RepRate1],
       [Project2].[RepRate2] AS [RepRate2],
       [Project2].[RepRate3] AS [RepRate3],
       [Project2].[RepRate4] AS [RepRate4],
       [Project2].[RepRate5] AS [RepRate5],
       [Project2].[RepSplit1] AS [RepSplit1],
       [Project2].[RepSplit2] AS [RepSplit2],
       [Project2].[RepSplit3] AS [RepSplit3],
       [Project2].[RepSplit4] AS [RepSplit4],
       [Project2].[RepSplit5] AS [RepSplit5],
       [Project2].[DemandContractLine] AS [DemandContractLine],
       [Project2].[CreateNewJob] AS [CreateNewJob],
       [Project2].[DoNotShipBeforeDate] AS [DoNotShipBeforeDate],
       [Project2].[GetDtls] AS [GetDtls],
       [Project2].[DoNotShipAfterDate] AS [DoNotShipAfterDate],
       [Project2].[SchedJob] AS [SchedJob],
       [Project2].[RelJob] AS [RelJob],
       [Project2].[EnableCreateNewJob] AS [EnableCreateNewJob],
       [Project2].[EnableGetDtls] AS [EnableGetDtls],
       [Project2].[EnableSchedJob] AS [EnableSchedJob],
       [Project2].[EnableRelJob] AS [EnableRelJob],
       [Project2].[CounterSaleWarehouse] AS [CounterSaleWarehouse],
       [Project2].[CounterSaleBinNum] AS [CounterSaleBinNum],
       [Project2].[CounterSaleLotNum] AS [CounterSaleLotNum],
       [Project2].[CounterSaleDimCode] AS [CounterSaleDimCode],
       [Project2].[DemandDtlRejected] AS [DemandDtlRejected],
       [Project2].[KitFlag] AS [KitFlag],
       [Project2].[KitsLoaded] AS [KitsLoaded],
       [Project2].[DemandContractNum] AS [DemandContractNum],
       [Project2].[DemandHeadSeq] AS [DemandHeadSeq],
       [Project2].[DemandDtlSeq] AS [DemandDtlSeq],
       [Project2].[ChangedBy] AS [ChangedBy],
       [Project2].[ChangeDate] AS [ChangeDate],
       [Project2].[ChangeTime] AS [ChangeTime],
       [Project2].[ReverseCharge] AS [ReverseCharge],
       [Project2].[TotalReleases] AS [TotalReleases],
       [Project2].[Rpt1UnitPrice] AS [Rpt1UnitPrice],
       [Project2].[Rpt2UnitPrice] AS [Rpt2UnitPrice],
       [Project2].[Rpt3UnitPrice] AS [Rpt3UnitPrice],
       [Project2].[Rpt1Discount] AS [Rpt1Discount],
       [Project2].[Rpt2Discount] AS [Rpt2Discount],
       [Project2].[Rpt3Discount] AS [Rpt3Discount],
       [Project2].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],
       [Project2].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],
       [Project2].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],
       [Project2].[Rpt1ListPrice] AS [Rpt1ListPrice],
       [Project2].[Rpt2ListPrice] AS [Rpt2ListPrice],
       [Project2].[Rpt3ListPrice] AS [Rpt3ListPrice],
       [Project2].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],
       [Project2].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],
       [Project2].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],
       [Project2].[ExtPriceDtl] AS [ExtPriceDtl],
       [Project2].[DocExtPriceDtl] AS [DocExtPriceDtl],
       [Project2].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],
       [Project2].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],
       [Project2].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],
       [Project2].[LineStatus] AS [LineStatus],
       [Project2].[InUnitPrice] AS [InUnitPrice],
       [Project2].[DocInUnitPrice] AS [DocInUnitPrice],
       [Project2].[InDiscount] AS [InDiscount],
       [Project2].[DocInDiscount] AS [DocInDiscount],
       [Project2].[InListPrice] AS [InListPrice],
       [Project2].[DocInListPrice] AS [DocInListPrice],
       [Project2].[InOrdBasedPrice] AS [InOrdBasedPrice],
       [Project2].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],
       [Project2].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],
       [Project2].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],
       [Project2].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],
       [Project2].[Rpt1InDiscount] AS [Rpt1InDiscount],
       [Project2].[Rpt2InDiscount] AS [Rpt2InDiscount],
       [Project2].[Rpt3InDiscount] AS [Rpt3InDiscount],
       [Project2].[Rpt1InListPrice] AS [Rpt1InListPrice],
       [Project2].[Rpt2InListPrice] AS [Rpt2InListPrice],
       [Project2].[Rpt3InListPrice] AS [Rpt3InListPrice],
       [Project2].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],
       [Project2].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],
       [Project2].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],
       [Project2].[InExtPriceDtl] AS [InExtPriceDtl],
       [Project2].[DocInExtPriceDtl] AS [DocInExtPriceDtl],
       [Project2].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],
       [Project2].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],
       [Project2].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],
       [Project2].[OldOurOpenQty] AS [OldOurOpenQty],
       [Project2].[OldSellingOpenQty] AS [OldSellingOpenQty],
       [Project2].[OldOpenValue] AS [OldOpenValue],
       [Project2].[OldProdCode] AS [OldProdCode],
       [Project2].[PrevSellQty] AS [PrevSellQty],
       [Project2].[PrevPartNum] AS [PrevPartNum],
       [Project2].[PrevXPartNum] AS [PrevXPartNum],
       [Project2].[KitCompOrigSeq] AS [KitCompOrigSeq],
       [Project2].[KitCompOrigPart] AS [KitCompOrigPart],
       [Project2].[SmartStringProcessed] AS [SmartStringProcessed],
       [Project2].[SmartString] AS [SmartString],
       [Project2].[RenewalNbr] AS [RenewalNbr],
       [Project2].[DiscBreakListCode] AS [DiscBreakListCode],
       [Project2].[DiscListPrice] AS [DiscListPrice],
       [Project2].[LockDisc] AS [LockDisc],
       [Project2].[OverrideDiscPriceList] AS [OverrideDiscPriceList],
       [Project2].[GroupSeq] AS [GroupSeq],
       [Project2].[ECCOrderNum] AS [ECCOrderNum],
       [Project2].[ECCOrderLine] AS [ECCOrderLine],
       [Project2].[DupOnJobCrt] AS [DupOnJobCrt],
       [Project2].[UndersPct] AS [UndersPct],
       [Project2].[Overs] AS [Overs],
       [Project2].[Unders] AS [Unders],
       [Project2].[OversUnitPrice] AS [OversUnitPrice],
       [Project2].[PlanUserID] AS [PlanUserID],
       [Project2].[PlanGUID] AS [PlanGUID],
       [Project2].[MOMsourceType] AS [MOMsourceType],
       [Project2].[MOMsourceEst] AS [MOMsourceEst],
       [Project2].[DefaultOversPricing] AS [DefaultOversPricing],
       [Project2].[ECCPlant] AS [ECCPlant],
       [Project2].[ECCQuoteNum] AS [ECCQuoteNum],
       [Project2].[ECCQuoteLine] AS [ECCQuoteLine],
       [Project2].[SysRevID] AS [SysRevID],
       [Project2].[ForeignSysRowID] AS [ForeignSysRowID],
       [Project2].[MfgJobType] AS [MfgJobType],
       [Project2].[ProFormaInvComment] AS [ProFormaInvComment],
       [Project2].[CreateJob] AS [CreateJob],
       [Project2].[ContractID] AS [ContractID],
       [Project2].[LinkToContract] AS [LinkToContract],
       [Project2].[DocInAdvanceBillBal] AS [DocInAdvanceBillBal],
       [Project2].[InAdvanceBillBal] AS [InAdvanceBillBal],
       [Project2].[Rpt1InAdvanceBillBal] AS [Rpt1InAdvanceBillBal],
       [Project2].[Rpt2InAdvanceBillBal] AS [Rpt2InAdvanceBillBal],
       [Project2].[Rpt3InAdvanceBillBal] AS [Rpt3InAdvanceBillBal],
       [Project2].[PCLinkRemoved] AS [PCLinkRemoved],
       [Project2].[CommodityCode] AS [CommodityCode],
       [Project2].[MSRP] AS [MSRP],
       [Project2].[DocMSRP] AS [DocMSRP],
       [Project2].[Rpt1MSRP] AS [Rpt1MSRP],
       [Project2].[Rpt2MSRP] AS [Rpt2MSRP],
       [Project2].[Rpt3MSRP] AS [Rpt3MSRP],
       [Project2].[EndCustomerPrice] AS [EndCustomerPrice],
       [Project2].[DocEndCustomerPrice] AS [DocEndCustomerPrice],
       [Project2].[Rpt1EndCustomerPrice] AS [Rpt1EndCustomerPrice],
       [Project2].[Rpt2EndCustomerPrice] AS [Rpt2EndCustomerPrice],
       [Project2].[Rpt3EndCustomerPrice] AS [Rpt3EndCustomerPrice],
       [Project2].[PromotionalPrice] AS [PromotionalPrice],
       [Project2].[DocPromotionalPrice] AS [DocPromotionalPrice],
       [Project2].[Rpt1PromotionalPrice] AS [Rpt1PromotionalPrice],
       [Project2].[Rpt2PromotionalPrice] AS [Rpt2PromotionalPrice],
       [Project2].[Rpt3PromotionalPrice] AS [Rpt3PromotionalPrice],
       [Project2].[OrderLineStatusCode] AS [OrderLineStatusCode],
       [Project2].[AttributeSetID] AS [AttributeSetID],
       [Project2].[KBConfigProdID] AS [KBConfigProdID],
       [Project2].[KBOriginalConfigProdID] AS [KBOriginalConfigProdID],
       [Project2].[UD_SysRevID] AS [UD_SysRevID],
       [Project2].[sgcCloseReason_c] AS [sgcCloseReason_c],
       [Project2].[EstUnitCost_c] AS [EstUnitCost_c],
       [Project2].[SalesAgentReviewed_c] AS [SalesAgentReviewed_c],
       [Project2].[ManagerReviewed_c] AS [ManagerReviewed_c],
       [Project2].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],
       [Project2].[Branch0DollarComments_c] AS [Branch0DollarComments_c],
       [Project2].[sgc3PLRef_c] AS [sgc3PLRef_c]
FROM
(
    SELECT [Distinct1].[PartDescription] AS [PartDescription],
           [Distinct1].[AccountCoordinator_c] AS [AccountCoordinator_c],
           1 AS [C1],
           [Join14].[ForeignSysRowID1] AS [ForeignSysRowID],
           [Join14].[UD_SysRevID1] AS [UD_SysRevID],
           [Join14].[sgcCloseReason_c1] AS [sgcCloseReason_c],
           [Join14].[EstUnitCost_c] AS [EstUnitCost_c],
           [Join14].[SalesAgentReviewed_c1] AS [SalesAgentReviewed_c],
           [Join14].[ManagerReviewed_c1] AS [ManagerReviewed_c],
           [Join14].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],
           [Join14].[Branch0DollarComments_c] AS [Branch0DollarComments_c],
           [Join14].[sgc3PLRef_c1] AS [sgc3PLRef_c],
           [Join14].[VoidLine] AS [VoidLine],
           [Join14].[OpenLine] AS [OpenLine],
           [Join14].[Company1] AS [Company],
           [Join14].[OrderNum1] AS [OrderNum],
           [Join14].[OrderLine] AS [OrderLine],
           [Join14].[LineType] AS [LineType],
           [Join14].[PartNum1] AS [PartNum],
           [Join14].[LineDesc] AS [LineDesc],
           [Join14].[Reference] AS [Reference],
           [Join14].[IUM1] AS [IUM],
           [Join14].[RevisionNum] AS [RevisionNum],
           [Join14].[POLine] AS [POLine],
           [Join14].[Commissionable] AS [Commissionable],
           [Join14].[DiscountPercent1] AS [DiscountPercent],
           [Join14].[UnitPrice1] AS [UnitPrice],
           [Join14].[DocUnitPrice] AS [DocUnitPrice],
           [Join14].[OrderQty] AS [OrderQty],
           [Join14].[Discount] AS [Discount],
           [Join14].[DocDiscount] AS [DocDiscount],
           [Join14].[RequestDate1] AS [RequestDate],
           [Join14].[ProdCode1] AS [ProdCode],
           [Join14].[XPartNum] AS [XPartNum],
           [Join14].[XRevisionNum] AS [XRevisionNum],
           [Join14].[PricePerCode1] AS [PricePerCode],
           [Join14].[OrderComment1] AS [OrderComment],
           [Join14].[ShipComment1] AS [ShipComment],
           [Join14].[InvoiceComment1] AS [InvoiceComment],
           [Join14].[PickListComment1] AS [PickListComment],
           [Join14].[TaxCatID1] AS [TaxCatID],
           [Join14].[AdvanceBillBal] AS [AdvanceBillBal],
           [Join14].[DocAdvanceBillBal] AS [DocAdvanceBillBal],
           [Join14].[QuoteNum] AS [QuoteNum],
           [Join14].[QuoteLine] AS [QuoteLine],
           [Join14].[TMBilling] AS [TMBilling],
           [Join14].[OrigWhyNoTax] AS [OrigWhyNoTax],
           [Join14].[NeedByDate1] AS [NeedByDate],
           [Join14].[CustNum1] AS [CustNum],
           [Join14].[Rework] AS [Rework],
           [Join14].[RMANum] AS [RMANum],
           [Join14].[RMALine] AS [RMALine],
           [Join14].[ProjectID] AS [ProjectID],
           [Join14].[ContractNum] AS [ContractNum],
           [Join14].[ContractCode] AS [ContractCode],
           [Join14].[BasePartNum1] AS [BasePartNum],
           [Join14].[Warranty] AS [Warranty],
           [Join14].[WarrantyCode1] AS [WarrantyCode],
           [Join14].[MaterialDuration] AS [MaterialDuration],
           [Join14].[LaborDuration] AS [LaborDuration],
           [Join14].[MiscDuration] AS [MiscDuration],
           [Join14].[MaterialMod] AS [MaterialMod],
           [Join14].[LaborMod] AS [LaborMod],
           [Join14].[WarrantyComment] AS [WarrantyComment],
           [Join14].[Onsite] AS [Onsite],
           [Join14].[MatCovered] AS [MatCovered],
           [Join14].[LabCovered] AS [LabCovered],
           [Join14].[MiscCovered] AS [MiscCovered],
           [Join14].[SalesUM1] AS [SalesUM],
           [Join14].[SellingFactor1] AS [SellingFactor],
           [Join14].[SellingQuantity] AS [SellingQuantity],
           [Join14].[SalesCatID] AS [SalesCatID],
           [Join14].[ShipLineComplete] AS [ShipLineComplete],
           [Join14].[CumeQty] AS [CumeQty],
           [Join14].[CumeDate] AS [CumeDate],
           [Join14].[MktgCampaignID] AS [MktgCampaignID],
           [Join14].[MktgEvntSeq] AS [MktgEvntSeq],
           [Join14].[LockQty1] AS [LockQty],
           [Join14].[Linked1] AS [Linked],
           [Join14].[ICPONum1] AS [ICPONum],
           [Join14].[ICPOLine] AS [ICPOLine],
           [Join14].[ExtCompany1] AS [ExtCompany],
           [Join14].[LastConfigDate] AS [LastConfigDate],
           [Join14].[LastConfigTime] AS [LastConfigTime],
           [Join14].[LastConfigUserID] AS [LastConfigUserID],
           [Join14].[ConfigUnitPrice] AS [ConfigUnitPrice],
           [Join14].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],
           [Join14].[PriceListCode] AS [PriceListCode],
           [Join14].[BreakListCode] AS [BreakListCode],
           [Join14].[PricingQty] AS [PricingQty],
           [Join14].[LockPrice] AS [LockPrice],
           [Join14].[ListPrice] AS [ListPrice],
           [Join14].[DocListPrice] AS [DocListPrice],
           [Join14].[OrdBasedPrice] AS [OrdBasedPrice],
           [Join14].[DocOrdBasedPrice] AS [DocOrdBasedPrice],
           [Join14].[PriceGroupCode] AS [PriceGroupCode],
           [Join14].[OverridePriceList] AS [OverridePriceList],
           [Join14].[BaseRevisionNum] AS [BaseRevisionNum],
           [Join14].[PricingValue] AS [PricingValue],
           [Join14].[DisplaySeq] AS [DisplaySeq],
           [Join14].[KitParentLine] AS [KitParentLine],
           [Join14].[KitAllowUpdate] AS [KitAllowUpdate],
           [Join14].[KitShipComplete] AS [KitShipComplete],
           [Join14].[KitBackFlush] AS [KitBackFlush],
           [Join14].[KitPrintCompsPS] AS [KitPrintCompsPS],
           [Join14].[KitPrintCompsInv] AS [KitPrintCompsInv],
           [Join14].[KitPricing] AS [KitPricing],
           [Join14].[KitQtyPer] AS [KitQtyPer],
           [Join14].[SellingFactorDirection1] AS [SellingFactorDirection],
           [Join14].[RepRate11] AS [RepRate1],
           [Join14].[RepRate21] AS [RepRate2],
           [Join14].[RepRate31] AS [RepRate3],
           [Join14].[RepRate41] AS [RepRate4],
           [Join14].[RepRate51] AS [RepRate5],
           [Join14].[RepSplit11] AS [RepSplit1],
           [Join14].[RepSplit21] AS [RepSplit2],
           [Join14].[RepSplit31] AS [RepSplit3],
           [Join14].[RepSplit41] AS [RepSplit4],
           [Join14].[RepSplit51] AS [RepSplit5],
           [Join14].[DemandContractLine] AS [DemandContractLine],
           [Join14].[CreateNewJob] AS [CreateNewJob],
           [Join14].[DoNotShipBeforeDate1] AS [DoNotShipBeforeDate],
           [Join14].[GetDtls] AS [GetDtls],
           [Join14].[DoNotShipAfterDate1] AS [DoNotShipAfterDate],
           [Join14].[SchedJob] AS [SchedJob],
           [Join14].[RelJob] AS [RelJob],
           [Join14].[EnableCreateNewJob] AS [EnableCreateNewJob],
           [Join14].[EnableGetDtls] AS [EnableGetDtls],
           [Join14].[EnableSchedJob] AS [EnableSchedJob],
           [Join14].[EnableRelJob] AS [EnableRelJob],
           [Join14].[CounterSaleWarehouse] AS [CounterSaleWarehouse],
           [Join14].[CounterSaleBinNum] AS [CounterSaleBinNum],
           [Join14].[CounterSaleLotNum] AS [CounterSaleLotNum],
           [Join14].[CounterSaleDimCode] AS [CounterSaleDimCode],
           [Join14].[DemandDtlRejected] AS [DemandDtlRejected],
           [Join14].[KitFlag] AS [KitFlag],
           [Join14].[KitsLoaded] AS [KitsLoaded],
           [Join14].[DemandContractNum1] AS [DemandContractNum],
           [Join14].[DemandHeadSeq1] AS [DemandHeadSeq],
           [Join14].[DemandDtlSeq] AS [DemandDtlSeq],
           [Join14].[ChangedBy1] AS [ChangedBy],
           [Join14].[ChangeDate1] AS [ChangeDate],
           [Join14].[ChangeTime1] AS [ChangeTime],
           [Join14].[ReverseCharge] AS [ReverseCharge],
           [Join14].[TotalReleases1] AS [TotalReleases],
           [Join14].[Rpt1UnitPrice] AS [Rpt1UnitPrice],
           [Join14].[Rpt2UnitPrice] AS [Rpt2UnitPrice],
           [Join14].[Rpt3UnitPrice] AS [Rpt3UnitPrice],
           [Join14].[Rpt1Discount] AS [Rpt1Discount],
           [Join14].[Rpt2Discount] AS [Rpt2Discount],
           [Join14].[Rpt3Discount] AS [Rpt3Discount],
           [Join14].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],
           [Join14].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],
           [Join14].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],
           [Join14].[Rpt1ListPrice] AS [Rpt1ListPrice],
           [Join14].[Rpt2ListPrice] AS [Rpt2ListPrice],
           [Join14].[Rpt3ListPrice] AS [Rpt3ListPrice],
           [Join14].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],
           [Join14].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],
           [Join14].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],
           [Join14].[ExtPriceDtl] AS [ExtPriceDtl],
           [Join14].[DocExtPriceDtl] AS [DocExtPriceDtl],
           [Join14].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],
           [Join14].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],
           [Join14].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],
           [Join14].[LineStatus] AS [LineStatus],
           [Join14].[InUnitPrice] AS [InUnitPrice],
           [Join14].[DocInUnitPrice] AS [DocInUnitPrice],
           [Join14].[InDiscount] AS [InDiscount],
           [Join14].[DocInDiscount] AS [DocInDiscount],
           [Join14].[InListPrice] AS [InListPrice],
           [Join14].[DocInListPrice] AS [DocInListPrice],
           [Join14].[InOrdBasedPrice] AS [InOrdBasedPrice],
           [Join14].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],
           [Join14].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],
           [Join14].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],
           [Join14].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],
           [Join14].[Rpt1InDiscount] AS [Rpt1InDiscount],
           [Join14].[Rpt2InDiscount] AS [Rpt2InDiscount],
           [Join14].[Rpt3InDiscount] AS [Rpt3InDiscount],
           [Join14].[Rpt1InListPrice] AS [Rpt1InListPrice],
           [Join14].[Rpt2InListPrice] AS [Rpt2InListPrice],
           [Join14].[Rpt3InListPrice] AS [Rpt3InListPrice],
           [Join14].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],
           [Join14].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],
           [Join14].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],
           [Join14].[InExtPriceDtl] AS [InExtPriceDtl],
           [Join14].[DocInExtPriceDtl] AS [DocInExtPriceDtl],
           [Join14].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],
           [Join14].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],
           [Join14].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],
           [Join14].[OldOurOpenQty] AS [OldOurOpenQty],
           [Join14].[OldSellingOpenQty] AS [OldSellingOpenQty],
           [Join14].[OldOpenValue] AS [OldOpenValue],
           [Join14].[OldProdCode] AS [OldProdCode],
           [Join14].[PrevSellQty] AS [PrevSellQty],
           [Join14].[PrevPartNum] AS [PrevPartNum],
           [Join14].[PrevXPartNum] AS [PrevXPartNum],
           [Join14].[KitCompOrigSeq] AS [KitCompOrigSeq],
           [Join14].[KitCompOrigPart] AS [KitCompOrigPart],
           [Join14].[SmartStringProcessed] AS [SmartStringProcessed],
           [Join14].[SmartString] AS [SmartString],
           [Join14].[RenewalNbr] AS [RenewalNbr],
           [Join14].[DiscBreakListCode] AS [DiscBreakListCode],
           [Join14].[DiscListPrice] AS [DiscListPrice],
           [Join14].[LockDisc] AS [LockDisc],
           [Join14].[OverrideDiscPriceList] AS [OverrideDiscPriceList],
           [Join14].[GroupSeq] AS [GroupSeq],
           [Join14].[ECCOrderNum1] AS [ECCOrderNum],
           [Join14].[ECCOrderLine] AS [ECCOrderLine],
           [Join14].[DupOnJobCrt1] AS [DupOnJobCrt],
           [Join14].[UndersPct1] AS [UndersPct],
           [Join14].[Overs] AS [Overs],
           [Join14].[Unders] AS [Unders],
           [Join14].[OversUnitPrice] AS [OversUnitPrice],
           [Join14].[PlanUserID] AS [PlanUserID],
           [Join14].[PlanGUID] AS [PlanGUID],
           [Join14].[MOMsourceType] AS [MOMsourceType],
           [Join14].[MOMsourceEst] AS [MOMsourceEst],
           [Join14].[DefaultOversPricing1] AS [DefaultOversPricing],
           [Join14].[ECCPlant] AS [ECCPlant],
           [Join14].[ECCQuoteNum] AS [ECCQuoteNum],
           [Join14].[ECCQuoteLine] AS [ECCQuoteLine],
           [Join14].[SysRevID1] AS [SysRevID],
           [Join14].[MfgJobType] AS [MfgJobType],
           [Join14].[ProFormaInvComment1] AS [ProFormaInvComment],
           [Join14].[CreateJob] AS [CreateJob],
           [Join14].[ContractID] AS [ContractID],
           [Join14].[LinkToContract1] AS [LinkToContract],
           [Join14].[DocInAdvanceBillBal] AS [DocInAdvanceBillBal],
           [Join14].[InAdvanceBillBal] AS [InAdvanceBillBal],
           [Join14].[Rpt1InAdvanceBillBal] AS [Rpt1InAdvanceBillBal],
           [Join14].[Rpt2InAdvanceBillBal] AS [Rpt2InAdvanceBillBal],
           [Join14].[Rpt3InAdvanceBillBal] AS [Rpt3InAdvanceBillBal],
           [Join14].[PCLinkRemoved] AS [PCLinkRemoved],
           [Join14].[CommodityCode1] AS [CommodityCode],
           [Join14].[MSRP] AS [MSRP],
           [Join14].[DocMSRP] AS [DocMSRP],
           [Join14].[Rpt1MSRP] AS [Rpt1MSRP],
           [Join14].[Rpt2MSRP] AS [Rpt2MSRP],
           [Join14].[Rpt3MSRP] AS [Rpt3MSRP],
           [Join14].[EndCustomerPrice] AS [EndCustomerPrice],
           [Join14].[DocEndCustomerPrice] AS [DocEndCustomerPrice],
           [Join14].[Rpt1EndCustomerPrice] AS [Rpt1EndCustomerPrice],
           [Join14].[Rpt2EndCustomerPrice] AS [Rpt2EndCustomerPrice],
           [Join14].[Rpt3EndCustomerPrice] AS [Rpt3EndCustomerPrice],
           [Join14].[PromotionalPrice] AS [PromotionalPrice],
           [Join14].[DocPromotionalPrice] AS [DocPromotionalPrice],
           [Join14].[Rpt1PromotionalPrice] AS [Rpt1PromotionalPrice],
           [Join14].[Rpt2PromotionalPrice] AS [Rpt2PromotionalPrice],
           [Join14].[Rpt3PromotionalPrice] AS [Rpt3PromotionalPrice],
           [Join14].[OrderLineStatusCode] AS [OrderLineStatusCode],
           [Join14].[AttributeSetID] AS [AttributeSetID],
           [Join14].[KBConfigProdID] AS [KBConfigProdID],
           [Join14].[KBOriginalConfigProdID] AS [KBOriginalConfigProdID],
           CASE
               WHEN ([Join14].[OrderNum2] IS NULL) THEN
                   CAST(NULL AS INT)
               ELSE
                   1
           END AS [C2]
    FROM
    (
        SELECT DISTINCT
               [Join4].[PartDescription] AS [PartDescription],
               [Join6].[AccountCoordinator_c] AS [AccountCoordinator_c]
        FROM [Erp].[OrderHed_UD] AS [Extent1]
            INNER JOIN [Erp].[OrderHed] AS [Extent2]
                ON [Extent1].[ForeignSysRowID] = [Extent2].[SysRowID]
            INNER JOIN
            (
                SELECT [Extent4].[Company] AS [Company],
                       [Extent4].[OrderNum] AS [OrderNum],
                       [Extent4].[PartNum] AS [PartNum]
                FROM [Erp].[OrderDtl_UD] AS [Extent3]
                    INNER JOIN [Erp].[OrderDtl] AS [Extent4]
                        ON [Extent3].[ForeignSysRowID] = [Extent4].[SysRowID]
            ) AS [Join2]
                ON [Extent2].[OrderNum] = [Join2].[OrderNum]
            INNER JOIN
            (
                SELECT [Extent6].[Company] AS [Company],
                       [Extent6].[PartNum] AS [PartNum],
                       [Extent6].[PartDescription] AS [PartDescription]
                FROM [Erp].[Part_UD] AS [Extent5]
                    INNER JOIN [Erp].[Part] AS [Extent6]
                        ON [Extent5].[ForeignSysRowID] = [Extent6].[SysRowID]
            ) AS [Join4]
                ON ([Join2].[Company] = [Join4].[Company])
                   AND ([Join2].[PartNum] = [Join4].[PartNum])
            INNER JOIN
            (
                SELECT [Extent7].[AccountCoordinator_c] AS [AccountCoordinator_c],
                       [Extent8].[Company] AS [Company],
                       [Extent8].[CustNum] AS [CustNum]
                FROM [Erp].[Customer_UD] AS [Extent7]
                    INNER JOIN [Erp].[Customer] AS [Extent8]
                        ON [Extent7].[ForeignSysRowID] = [Extent8].[SysRowID]
            ) AS [Join6]
                ON ([Extent2].[Company] = [Join6].[Company])
                   AND ([Extent2].[CustNum] = [Join6].[CustNum])
        WHERE (1 = [Extent2].[ReadyToCalc])
              AND (N'EPI-LINQ' = [Extent2].[EntryPerson])
    ) AS [Distinct1]
        LEFT OUTER JOIN
        (
            SELECT [Extent10].[OrderNum] AS [OrderNum2],
                   [Extent10].[EntryPerson] AS [EntryPerson],
                   [Extent10].[ReadyToCalc] AS [ReadyToCalc],
                   [Join9].[ForeignSysRowID1],
                   [Join9].[UD_SysRevID1],
                   [Join9].[sgcCloseReason_c1],
                   [Join9].[EstUnitCost_c],
                   [Join9].[SalesAgentReviewed_c1],
                   [Join9].[ManagerReviewed_c1],
                   [Join9].[Branch0DollarReviewd_c],
                   [Join9].[Branch0DollarComments_c],
                   [Join9].[sgc3PLRef_c1],
                   [Join9].[VoidLine],
                   [Join9].[OpenLine],
                   [Join9].[Company1],
                   [Join9].[OrderNum1],
                   [Join9].[OrderLine],
                   [Join9].[LineType],
                   [Join9].[PartNum1],
                   [Join9].[LineDesc],
                   [Join9].[Reference],
                   [Join9].[IUM1],
                   [Join9].[RevisionNum],
                   [Join9].[POLine],
                   [Join9].[Commissionable],
                   [Join9].[DiscountPercent1],
                   [Join9].[UnitPrice1],
                   [Join9].[DocUnitPrice],
                   [Join9].[OrderQty],
                   [Join9].[Discount],
                   [Join9].[DocDiscount],
                   [Join9].[RequestDate1],
                   [Join9].[ProdCode1],
                   [Join9].[XPartNum],
                   [Join9].[XRevisionNum],
                   [Join9].[PricePerCode1],
                   [Join9].[OrderComment1],
                   [Join9].[ShipComment1],
                   [Join9].[InvoiceComment1],
                   [Join9].[PickListComment1],
                   [Join9].[TaxCatID1],
                   [Join9].[AdvanceBillBal],
                   [Join9].[DocAdvanceBillBal],
                   [Join9].[QuoteNum],
                   [Join9].[QuoteLine],
                   [Join9].[TMBilling],
                   [Join9].[OrigWhyNoTax],
                   [Join9].[NeedByDate1],
                   [Join9].[CustNum1],
                   [Join9].[Rework],
                   [Join9].[RMANum],
                   [Join9].[RMALine],
                   [Join9].[ProjectID],
                   [Join9].[ContractNum],
                   [Join9].[ContractCode],
                   [Join9].[BasePartNum1],
                   [Join9].[Warranty],
                   [Join9].[WarrantyCode1],
                   [Join9].[MaterialDuration],
                   [Join9].[LaborDuration],
                   [Join9].[MiscDuration],
                   [Join9].[MaterialMod],
                   [Join9].[LaborMod],
                   [Join9].[WarrantyComment],
                   [Join9].[Onsite],
                   [Join9].[MatCovered],
                   [Join9].[LabCovered],
                   [Join9].[MiscCovered],
                   [Join9].[SalesUM1],
                   [Join9].[SellingFactor1],
                   [Join9].[SellingQuantity],
                   [Join9].[SalesCatID],
                   [Join9].[ShipLineComplete],
                   [Join9].[CumeQty],
                   [Join9].[CumeDate],
                   [Join9].[MktgCampaignID],
                   [Join9].[MktgEvntSeq],
                   [Join9].[LockQty1],
                   [Join9].[Linked1],
                   [Join9].[ICPONum1],
                   [Join9].[ICPOLine],
                   [Join9].[ExtCompany1],
                   [Join9].[LastConfigDate],
                   [Join9].[LastConfigTime],
                   [Join9].[LastConfigUserID],
                   [Join9].[ConfigUnitPrice],
                   [Join9].[ConfigBaseUnitPrice],
                   [Join9].[PriceListCode],
                   [Join9].[BreakListCode],
                   [Join9].[PricingQty],
                   [Join9].[LockPrice],
                   [Join9].[ListPrice],
                   [Join9].[DocListPrice],
                   [Join9].[OrdBasedPrice],
                   [Join9].[DocOrdBasedPrice],
                   [Join9].[PriceGroupCode],
                   [Join9].[OverridePriceList],
                   [Join9].[BaseRevisionNum],
                   [Join9].[PricingValue],
                   [Join9].[DisplaySeq],
                   [Join9].[KitParentLine],
                   [Join9].[KitAllowUpdate],
                   [Join9].[KitShipComplete],
                   [Join9].[KitBackFlush],
                   [Join9].[KitPrintCompsPS],
                   [Join9].[KitPrintCompsInv],
                   [Join9].[KitPricing],
                   [Join9].[KitQtyPer],
                   [Join9].[SellingFactorDirection1],
                   [Join9].[RepRate11],
                   [Join9].[RepRate21],
                   [Join9].[RepRate31],
                   [Join9].[RepRate41],
                   [Join9].[RepRate51],
                   [Join9].[RepSplit11],
                   [Join9].[RepSplit21],
                   [Join9].[RepSplit31],
                   [Join9].[RepSplit41],
                   [Join9].[RepSplit51],
                   [Join9].[DemandContractLine],
                   [Join9].[CreateNewJob],
                   [Join9].[DoNotShipBeforeDate1],
                   [Join9].[GetDtls],
                   [Join9].[DoNotShipAfterDate1],
                   [Join9].[SchedJob],
                   [Join9].[RelJob],
                   [Join9].[EnableCreateNewJob],
                   [Join9].[EnableGetDtls],
                   [Join9].[EnableSchedJob],
                   [Join9].[EnableRelJob],
                   [Join9].[CounterSaleWarehouse],
                   [Join9].[CounterSaleBinNum],
                   [Join9].[CounterSaleLotNum],
                   [Join9].[CounterSaleDimCode],
                   [Join9].[DemandDtlRejected],
                   [Join9].[KitFlag],
                   [Join9].[KitsLoaded],
                   [Join9].[DemandContractNum1],
                   [Join9].[DemandHeadSeq1],
                   [Join9].[DemandDtlSeq],
                   [Join9].[ChangedBy1],
                   [Join9].[ChangeDate1],
                   [Join9].[ChangeTime1],
                   [Join9].[ReverseCharge],
                   [Join9].[TotalReleases1],
                   [Join9].[Rpt1UnitPrice],
                   [Join9].[Rpt2UnitPrice],
                   [Join9].[Rpt3UnitPrice],
                   [Join9].[Rpt1Discount],
                   [Join9].[Rpt2Discount],
                   [Join9].[Rpt3Discount],
                   [Join9].[Rpt1AdvanceBillBal],
                   [Join9].[Rpt2AdvanceBillBal],
                   [Join9].[Rpt3AdvanceBillBal],
                   [Join9].[Rpt1ListPrice],
                   [Join9].[Rpt2ListPrice],
                   [Join9].[Rpt3ListPrice],
                   [Join9].[Rpt1OrdBasedPrice],
                   [Join9].[Rpt2OrdBasedPrice],
                   [Join9].[Rpt3OrdBasedPrice],
                   [Join9].[ExtPriceDtl],
                   [Join9].[DocExtPriceDtl],
                   [Join9].[Rpt1ExtPriceDtl],
                   [Join9].[Rpt2ExtPriceDtl],
                   [Join9].[Rpt3ExtPriceDtl],
                   [Join9].[LineStatus],
                   [Join9].[InUnitPrice],
                   [Join9].[DocInUnitPrice],
                   [Join9].[InDiscount],
                   [Join9].[DocInDiscount],
                   [Join9].[InListPrice],
                   [Join9].[DocInListPrice],
                   [Join9].[InOrdBasedPrice],
                   [Join9].[DocInOrdBasedPrice],
                   [Join9].[Rpt1InUnitPrice],
                   [Join9].[Rpt2InUnitPrice],
                   [Join9].[Rpt3InUnitPrice],
                   [Join9].[Rpt1InDiscount],
                   [Join9].[Rpt2InDiscount],
                   [Join9].[Rpt3InDiscount],
                   [Join9].[Rpt1InListPrice],
                   [Join9].[Rpt2InListPrice],
                   [Join9].[Rpt3InListPrice],
                   [Join9].[Rpt1InOrdBasedPrice],
                   [Join9].[Rpt2InOrdBasedPrice],
                   [Join9].[Rpt3InOrdBasedPrice],
                   [Join9].[InExtPriceDtl],
                   [Join9].[DocInExtPriceDtl],
                   [Join9].[Rpt1InExtPriceDtl],
                   [Join9].[Rpt2InExtPriceDtl],
                   [Join9].[Rpt3InExtPriceDtl],
                   [Join9].[OldOurOpenQty],
                   [Join9].[OldSellingOpenQty],
                   [Join9].[OldOpenValue],
                   [Join9].[OldProdCode],
                   [Join9].[PrevSellQty],
                   [Join9].[PrevPartNum],
                   [Join9].[PrevXPartNum],
                   [Join9].[KitCompOrigSeq],
                   [Join9].[KitCompOrigPart],
                   [Join9].[SmartStringProcessed],
                   [Join9].[SmartString],
                   [Join9].[RenewalNbr],
                   [Join9].[DiscBreakListCode],
                   [Join9].[DiscListPrice],
                   [Join9].[LockDisc],
                   [Join9].[OverrideDiscPriceList],
                   [Join9].[GroupSeq],
                   [Join9].[ECCOrderNum1],
                   [Join9].[ECCOrderLine],
                   [Join9].[DupOnJobCrt1],
                   [Join9].[UndersPct1],
                   [Join9].[Overs],
                   [Join9].[Unders],
                   [Join9].[OversUnitPrice],
                   [Join9].[PlanUserID],
                   [Join9].[PlanGUID],
                   [Join9].[MOMsourceType],
                   [Join9].[MOMsourceEst],
                   [Join9].[DefaultOversPricing1],
                   [Join9].[ECCPlant],
                   [Join9].[ECCQuoteNum],
                   [Join9].[ECCQuoteLine],
                   [Join9].[SysRevID1],
                   [Join9].[MfgJobType],
                   [Join9].[ProFormaInvComment1],
                   [Join9].[CreateJob],
                   [Join9].[ContractID],
                   [Join9].[LinkToContract1],
                   [Join9].[DocInAdvanceBillBal],
                   [Join9].[InAdvanceBillBal],
                   [Join9].[Rpt1InAdvanceBillBal],
                   [Join9].[Rpt2InAdvanceBillBal],
                   [Join9].[Rpt3InAdvanceBillBal],
                   [Join9].[PCLinkRemoved],
                   [Join9].[CommodityCode1],
                   [Join9].[MSRP],
                   [Join9].[DocMSRP],
                   [Join9].[Rpt1MSRP],
                   [Join9].[Rpt2MSRP],
                   [Join9].[Rpt3MSRP],
                   [Join9].[EndCustomerPrice],
                   [Join9].[DocEndCustomerPrice],
                   [Join9].[Rpt1EndCustomerPrice],
                   [Join9].[Rpt2EndCustomerPrice],
                   [Join9].[Rpt3EndCustomerPrice],
                   [Join9].[PromotionalPrice],
                   [Join9].[DocPromotionalPrice],
                   [Join9].[Rpt1PromotionalPrice],
                   [Join9].[Rpt2PromotionalPrice],
                   [Join9].[Rpt3PromotionalPrice],
                   [Join9].[OrderLineStatusCode],
                   [Join9].[AttributeSetID],
                   [Join9].[KBConfigProdID],
                   [Join9].[KBOriginalConfigProdID],
                   [Join11].[Company2],
                   [Join11].[PartNum2],
                   [Join11].[PartDescription],
                   [Join13].[AccountCoordinator_c],
                   [Join13].[Company3],
                   [Join13].[CustNum2]
            FROM [Erp].[OrderHed_UD] AS [Extent9]
                INNER JOIN [Erp].[OrderHed] AS [Extent10]
                    ON [Extent9].[ForeignSysRowID] = [Extent10].[SysRowID]
                INNER JOIN
                (
                    SELECT [Extent11].[ForeignSysRowID] AS [ForeignSysRowID1],
                           [Extent11].[UD_SysRevID] AS [UD_SysRevID1],
                           [Extent11].[sgcCloseReason_c] AS [sgcCloseReason_c1],
                           [Extent11].[EstUnitCost_c] AS [EstUnitCost_c],
                           [Extent11].[SalesAgentReviewed_c] AS [SalesAgentReviewed_c1],
                           [Extent11].[ManagerReviewed_c] AS [ManagerReviewed_c1],
                           [Extent11].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],
                           [Extent11].[Branch0DollarComments_c] AS [Branch0DollarComments_c],
                           [Extent11].[sgc3PLRef_c] AS [sgc3PLRef_c1],
                           [Extent12].[VoidLine] AS [VoidLine],
                           [Extent12].[OpenLine] AS [OpenLine],
                           [Extent12].[Company] AS [Company1],
                           [Extent12].[OrderNum] AS [OrderNum1],
                           [Extent12].[OrderLine] AS [OrderLine],
                           [Extent12].[LineType] AS [LineType],
                           [Extent12].[PartNum] AS [PartNum1],
                           [Extent12].[LineDesc] AS [LineDesc],
                           [Extent12].[Reference] AS [Reference],
                           [Extent12].[IUM] AS [IUM1],
                           [Extent12].[RevisionNum] AS [RevisionNum],
                           [Extent12].[POLine] AS [POLine],
                           [Extent12].[Commissionable] AS [Commissionable],
                           [Extent12].[DiscountPercent] AS [DiscountPercent1],
                           [Extent12].[UnitPrice] AS [UnitPrice1],
                           [Extent12].[DocUnitPrice] AS [DocUnitPrice],
                           [Extent12].[OrderQty] AS [OrderQty],
                           [Extent12].[Discount] AS [Discount],
                           [Extent12].[DocDiscount] AS [DocDiscount],
                           [Extent12].[RequestDate] AS [RequestDate1],
                           [Extent12].[ProdCode] AS [ProdCode1],
                           [Extent12].[XPartNum] AS [XPartNum],
                           [Extent12].[XRevisionNum] AS [XRevisionNum],
                           [Extent12].[PricePerCode] AS [PricePerCode1],
                           [Extent12].[OrderComment] AS [OrderComment1],
                           [Extent12].[ShipComment] AS [ShipComment1],
                           [Extent12].[InvoiceComment] AS [InvoiceComment1],
                           [Extent12].[PickListComment] AS [PickListComment1],
                           [Extent12].[TaxCatID] AS [TaxCatID1],
                           [Extent12].[AdvanceBillBal] AS [AdvanceBillBal],
                           [Extent12].[DocAdvanceBillBal] AS [DocAdvanceBillBal],
                           [Extent12].[QuoteNum] AS [QuoteNum],
                           [Extent12].[QuoteLine] AS [QuoteLine],
                           [Extent12].[TMBilling] AS [TMBilling],
                           [Extent12].[OrigWhyNoTax] AS [OrigWhyNoTax],
                           [Extent12].[NeedByDate] AS [NeedByDate1],
                           [Extent12].[CustNum] AS [CustNum1],
                           [Extent12].[Rework] AS [Rework],
                           [Extent12].[RMANum] AS [RMANum],
                           [Extent12].[RMALine] AS [RMALine],
                           [Extent12].[ProjectID] AS [ProjectID],
                           [Extent12].[ContractNum] AS [ContractNum],
                           [Extent12].[ContractCode] AS [ContractCode],
                           [Extent12].[BasePartNum] AS [BasePartNum1],
                           [Extent12].[Warranty] AS [Warranty],
                           [Extent12].[WarrantyCode] AS [WarrantyCode1],
                           [Extent12].[MaterialDuration] AS [MaterialDuration],
                           [Extent12].[LaborDuration] AS [LaborDuration],
                           [Extent12].[MiscDuration] AS [MiscDuration],
                           [Extent12].[MaterialMod] AS [MaterialMod],
                           [Extent12].[LaborMod] AS [LaborMod],
                           [Extent12].[WarrantyComment] AS [WarrantyComment],
                           [Extent12].[Onsite] AS [Onsite],
                           [Extent12].[MatCovered] AS [MatCovered],
                           [Extent12].[LabCovered] AS [LabCovered],
                           [Extent12].[MiscCovered] AS [MiscCovered],
                           [Extent12].[SalesUM] AS [SalesUM1],
                           [Extent12].[SellingFactor] AS [SellingFactor1],
                           [Extent12].[SellingQuantity] AS [SellingQuantity],
                           [Extent12].[SalesCatID] AS [SalesCatID],
                           [Extent12].[ShipLineComplete] AS [ShipLineComplete],
                           [Extent12].[CumeQty] AS [CumeQty],
                           [Extent12].[CumeDate] AS [CumeDate],
                           [Extent12].[MktgCampaignID] AS [MktgCampaignID],
                           [Extent12].[MktgEvntSeq] AS [MktgEvntSeq],
                           [Extent12].[LockQty] AS [LockQty1],
                           [Extent12].[Linked] AS [Linked1],
                           [Extent12].[ICPONum] AS [ICPONum1],
                           [Extent12].[ICPOLine] AS [ICPOLine],
                           [Extent12].[ExtCompany] AS [ExtCompany1],
                           [Extent12].[LastConfigDate] AS [LastConfigDate],
                           [Extent12].[LastConfigTime] AS [LastConfigTime],
                           [Extent12].[LastConfigUserID] AS [LastConfigUserID],
                           [Extent12].[ConfigUnitPrice] AS [ConfigUnitPrice],
                           [Extent12].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],
                           [Extent12].[PriceListCode] AS [PriceListCode],
                           [Extent12].[BreakListCode] AS [BreakListCode],
                           [Extent12].[PricingQty] AS [PricingQty],
                           [Extent12].[LockPrice] AS [LockPrice],
                           [Extent12].[ListPrice] AS [ListPrice],
                           [Extent12].[DocListPrice] AS [DocListPrice],
                           [Extent12].[OrdBasedPrice] AS [OrdBasedPrice],
                           [Extent12].[DocOrdBasedPrice] AS [DocOrdBasedPrice],
                           [Extent12].[PriceGroupCode] AS [PriceGroupCode],
                           [Extent12].[OverridePriceList] AS [OverridePriceList],
                           [Extent12].[BaseRevisionNum] AS [BaseRevisionNum],
                           [Extent12].[PricingValue] AS [PricingValue],
                           [Extent12].[DisplaySeq] AS [DisplaySeq],
                           [Extent12].[KitParentLine] AS [KitParentLine],
                           [Extent12].[KitAllowUpdate] AS [KitAllowUpdate],
                           [Extent12].[KitShipComplete] AS [KitShipComplete],
                           [Extent12].[KitBackFlush] AS [KitBackFlush],
                           [Extent12].[KitPrintCompsPS] AS [KitPrintCompsPS],
                           [Extent12].[KitPrintCompsInv] AS [KitPrintCompsInv],
                           [Extent12].[KitPricing] AS [KitPricing],
                           [Extent12].[KitQtyPer] AS [KitQtyPer],
                           [Extent12].[SellingFactorDirection] AS [SellingFactorDirection1],
                           [Extent12].[RepRate1] AS [RepRate11],
                           [Extent12].[RepRate2] AS [RepRate21],
                           [Extent12].[RepRate3] AS [RepRate31],
                           [Extent12].[RepRate4] AS [RepRate41],
                           [Extent12].[RepRate5] AS [RepRate51],
                           [Extent12].[RepSplit1] AS [RepSplit11],
                           [Extent12].[RepSplit2] AS [RepSplit21],
                           [Extent12].[RepSplit3] AS [RepSplit31],
                           [Extent12].[RepSplit4] AS [RepSplit41],
                           [Extent12].[RepSplit5] AS [RepSplit51],
                           [Extent12].[DemandContractLine] AS [DemandContractLine],
                           [Extent12].[CreateNewJob] AS [CreateNewJob],
                           [Extent12].[DoNotShipBeforeDate] AS [DoNotShipBeforeDate1],
                           [Extent12].[GetDtls] AS [GetDtls],
                           [Extent12].[DoNotShipAfterDate] AS [DoNotShipAfterDate1],
                           [Extent12].[SchedJob] AS [SchedJob],
                           [Extent12].[RelJob] AS [RelJob],
                           [Extent12].[EnableCreateNewJob] AS [EnableCreateNewJob],
                           [Extent12].[EnableGetDtls] AS [EnableGetDtls],
                           [Extent12].[EnableSchedJob] AS [EnableSchedJob],
                           [Extent12].[EnableRelJob] AS [EnableRelJob],
                           [Extent12].[CounterSaleWarehouse] AS [CounterSaleWarehouse],
                           [Extent12].[CounterSaleBinNum] AS [CounterSaleBinNum],
                           [Extent12].[CounterSaleLotNum] AS [CounterSaleLotNum],
                           [Extent12].[CounterSaleDimCode] AS [CounterSaleDimCode],
                           [Extent12].[DemandDtlRejected] AS [DemandDtlRejected],
                           [Extent12].[KitFlag] AS [KitFlag],
                           [Extent12].[KitsLoaded] AS [KitsLoaded],
                           [Extent12].[DemandContractNum] AS [DemandContractNum1],
                           [Extent12].[DemandHeadSeq] AS [DemandHeadSeq1],
                           [Extent12].[DemandDtlSeq] AS [DemandDtlSeq],
                           [Extent12].[ChangedBy] AS [ChangedBy1],
                           [Extent12].[ChangeDate] AS [ChangeDate1],
                           [Extent12].[ChangeTime] AS [ChangeTime1],
                           [Extent12].[ReverseCharge] AS [ReverseCharge],
                           [Extent12].[TotalReleases] AS [TotalReleases1],
                           [Extent12].[Rpt1UnitPrice] AS [Rpt1UnitPrice],
                           [Extent12].[Rpt2UnitPrice] AS [Rpt2UnitPrice],
                           [Extent12].[Rpt3UnitPrice] AS [Rpt3UnitPrice],
                           [Extent12].[Rpt1Discount] AS [Rpt1Discount],
                           [Extent12].[Rpt2Discount] AS [Rpt2Discount],
                           [Extent12].[Rpt3Discount] AS [Rpt3Discount],
                           [Extent12].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],
                           [Extent12].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],
                           [Extent12].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],
                           [Extent12].[Rpt1ListPrice] AS [Rpt1ListPrice],
                           [Extent12].[Rpt2ListPrice] AS [Rpt2ListPrice],
                           [Extent12].[Rpt3ListPrice] AS [Rpt3ListPrice],
                           [Extent12].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],
                           [Extent12].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],
                           [Extent12].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],
                           [Extent12].[ExtPriceDtl] AS [ExtPriceDtl],
                           [Extent12].[DocExtPriceDtl] AS [DocExtPriceDtl],
                           [Extent12].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],
                           [Extent12].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],
                           [Extent12].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],
                           [Extent12].[LineStatus] AS [LineStatus],
                           [Extent12].[InUnitPrice] AS [InUnitPrice],
                           [Extent12].[DocInUnitPrice] AS [DocInUnitPrice],
                           [Extent12].[InDiscount] AS [InDiscount],
                           [Extent12].[DocInDiscount] AS [DocInDiscount],
                           [Extent12].[InListPrice] AS [InListPrice],
                           [Extent12].[DocInListPrice] AS [DocInListPrice],
                           [Extent12].[InOrdBasedPrice] AS [InOrdBasedPrice],
                           [Extent12].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],
                           [Extent12].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],
                           [Extent12].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],
                           [Extent12].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],
                           [Extent12].[Rpt1InDiscount] AS [Rpt1InDiscount],
                           [Extent12].[Rpt2InDiscount] AS [Rpt2InDiscount],
                           [Extent12].[Rpt3InDiscount] AS [Rpt3InDiscount],
                           [Extent12].[Rpt1InListPrice] AS [Rpt1InListPrice],
                           [Extent12].[Rpt2InListPrice] AS [Rpt2InListPrice],
                           [Extent12].[Rpt3InListPrice] AS [Rpt3InListPrice],
                           [Extent12].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],
                           [Extent12].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],
                           [Extent12].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],
                           [Extent12].[InExtPriceDtl] AS [InExtPriceDtl],
                           [Extent12].[DocInExtPriceDtl] AS [DocInExtPriceDtl],
                           [Extent12].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],
                           [Extent12].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],
                           [Extent12].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],
                           [Extent12].[OldOurOpenQty] AS [OldOurOpenQty],
                           [Extent12].[OldSellingOpenQty] AS [OldSellingOpenQty],
                           [Extent12].[OldOpenValue] AS [OldOpenValue],
                           [Extent12].[OldProdCode] AS [OldProdCode],
                           [Extent12].[PrevSellQty] AS [PrevSellQty],
                           [Extent12].[PrevPartNum] AS [PrevPartNum],
                           [Extent12].[PrevXPartNum] AS [PrevXPartNum],
                           [Extent12].[KitCompOrigSeq] AS [KitCompOrigSeq],
                           [Extent12].[KitCompOrigPart] AS [KitCompOrigPart],
                           [Extent12].[SmartStringProcessed] AS [SmartStringProcessed],
                           [Extent12].[SmartString] AS [SmartString],
                           [Extent12].[RenewalNbr] AS [RenewalNbr],
                           [Extent12].[DiscBreakListCode] AS [DiscBreakListCode],
                           [Extent12].[DiscListPrice] AS [DiscListPrice],
                           [Extent12].[LockDisc] AS [LockDisc],
                           [Extent12].[OverrideDiscPriceList] AS [OverrideDiscPriceList],
                           [Extent12].[GroupSeq] AS [GroupSeq],
                           [Extent12].[ECCOrderNum] AS [ECCOrderNum1],
                           [Extent12].[ECCOrderLine] AS [ECCOrderLine],
                           [Extent12].[DupOnJobCrt] AS [DupOnJobCrt1],
                           [Extent12].[UndersPct] AS [UndersPct1],
                           [Extent12].[Overs] AS [Overs],
                           [Extent12].[Unders] AS [Unders],
                           [Extent12].[OversUnitPrice] AS [OversUnitPrice],
                           [Extent12].[PlanUserID] AS [PlanUserID],
                           [Extent12].[PlanGUID] AS [PlanGUID],
                           [Extent12].[MOMsourceType] AS [MOMsourceType],
                           [Extent12].[MOMsourceEst] AS [MOMsourceEst],
                           [Extent12].[DefaultOversPricing] AS [DefaultOversPricing1],
                           [Extent12].[ECCPlant] AS [ECCPlant],
                           [Extent12].[ECCQuoteNum] AS [ECCQuoteNum],
                           [Extent12].[ECCQuoteLine] AS [ECCQuoteLine],
                           [Extent12].[SysRevID] AS [SysRevID1],
                           [Extent12].[MfgJobType] AS [MfgJobType],
                           [Extent12].[ProFormaInvComment] AS [ProFormaInvComment1],
                           [Extent12].[CreateJob] AS [CreateJob],
                           [Extent12].[ContractID] AS [ContractID],
                           [Extent12].[LinkToContract] AS [LinkToContract1],
                           [Extent12].[DocInAdvanceBillBal] AS [DocInAdvanceBillBal],
                           [Extent12].[InAdvanceBillBal] AS [InAdvanceBillBal],
                           [Extent12].[Rpt1InAdvanceBillBal] AS [Rpt1InAdvanceBillBal],
                           [Extent12].[Rpt2InAdvanceBillBal] AS [Rpt2InAdvanceBillBal],
                           [Extent12].[Rpt3InAdvanceBillBal] AS [Rpt3InAdvanceBillBal],
                           [Extent12].[PCLinkRemoved] AS [PCLinkRemoved],
                           [Extent12].[CommodityCode] AS [CommodityCode1],
                           [Extent12].[MSRP] AS [MSRP],
                           [Extent12].[DocMSRP] AS [DocMSRP],
                           [Extent12].[Rpt1MSRP] AS [Rpt1MSRP],
                           [Extent12].[Rpt2MSRP] AS [Rpt2MSRP],
                           [Extent12].[Rpt3MSRP] AS [Rpt3MSRP],
                           [Extent12].[EndCustomerPrice] AS [EndCustomerPrice],
                           [Extent12].[DocEndCustomerPrice] AS [DocEndCustomerPrice],
                           [Extent12].[Rpt1EndCustomerPrice] AS [Rpt1EndCustomerPrice],
                           [Extent12].[Rpt2EndCustomerPrice] AS [Rpt2EndCustomerPrice],
                           [Extent12].[Rpt3EndCustomerPrice] AS [Rpt3EndCustomerPrice],
                           [Extent12].[PromotionalPrice] AS [PromotionalPrice],
                           [Extent12].[DocPromotionalPrice] AS [DocPromotionalPrice],
                           [Extent12].[Rpt1PromotionalPrice] AS [Rpt1PromotionalPrice],
                           [Extent12].[Rpt2PromotionalPrice] AS [Rpt2PromotionalPrice],
                           [Extent12].[Rpt3PromotionalPrice] AS [Rpt3PromotionalPrice],
                           [Extent12].[OrderLineStatusCode] AS [OrderLineStatusCode],
                           [Extent12].[AttributeSetID] AS [AttributeSetID],
                           [Extent12].[KBConfigProdID] AS [KBConfigProdID],
                           [Extent12].[KBOriginalConfigProdID] AS [KBOriginalConfigProdID]
                    FROM [Erp].[OrderDtl_UD] AS [Extent11]
                        INNER JOIN [Erp].[OrderDtl] AS [Extent12]
                            ON [Extent11].[ForeignSysRowID] = [Extent12].[SysRowID]
                ) AS [Join9]
                    ON [Extent10].[OrderNum] = [Join9].[OrderNum1]
                INNER JOIN
                (
                    SELECT [Extent14].[Company] AS [Company2],
                           [Extent14].[PartNum] AS [PartNum2],
                           [Extent14].[PartDescription] AS [PartDescription]
                    FROM [Erp].[Part_UD] AS [Extent13]
                        INNER JOIN [Erp].[Part] AS [Extent14]
                            ON [Extent13].[ForeignSysRowID] = [Extent14].[SysRowID]
                ) AS [Join11]
                    ON ([Join9].[Company1] = [Join11].[Company2])
                       AND ([Join9].[PartNum1] = [Join11].[PartNum2])
                INNER JOIN
                (
                    SELECT [Extent15].[AccountCoordinator_c] AS [AccountCoordinator_c],
                           [Extent16].[Company] AS [Company3],
                           [Extent16].[CustNum] AS [CustNum2]
                    FROM [Erp].[Customer_UD] AS [Extent15]
                        INNER JOIN [Erp].[Customer] AS [Extent16]
                            ON [Extent15].[ForeignSysRowID] = [Extent16].[SysRowID]
                ) AS [Join13]
                    ON ([Extent10].[Company] = [Join13].[Company3])
                       AND ([Extent10].[CustNum] = [Join13].[CustNum2])
        ) AS [Join14]
            ON (1 = [Join14].[ReadyToCalc])
               AND (N'EPI-LINQ' = [Join14].[EntryPerson])
               AND ([Distinct1].[PartDescription] = [Join14].[PartDescription])
               AND ([Distinct1].[AccountCoordinator_c] = [Join14].[AccountCoordinator_c])
) AS [Project2]
ORDER BY [Project2].[PartDescription] ASC,
         [Project2].[AccountCoordinator_c] ASC,
         [Project2].[C2] ASC;

Texto modificado

Open file

SELECT [Project2].[C1] AS [C1],
       [Project2].[PartDescription] AS [PartDescription],
       [Project2].[AccountCoordinator_c] AS [AccountCoordinator_c],
       [Project2].[C2] AS [C2],
       [Project2].[VoidLine] AS [VoidLine],
       [Project2].[OpenLine] AS [OpenLine],
       [Project2].[Company] AS [Company],
       [Project2].[OrderNum] AS [OrderNum],
       [Project2].[OrderLine] AS [OrderLine],
       [Project2].[LineType] AS [LineType],
       [Project2].[PartNum] AS [PartNum],
       [Project2].[LineDesc] AS [LineDesc],
       [Project2].[Reference] AS [Reference],
       [Project2].[IUM] AS [IUM],
       [Project2].[RevisionNum] AS [RevisionNum],
       [Project2].[POLine] AS [POLine],
       [Project2].[Commissionable] AS [Commissionable],
       [Project2].[DiscountPercent] AS [DiscountPercent],
       [Project2].[UnitPrice] AS [UnitPrice],
       [Project2].[DocUnitPrice] AS [DocUnitPrice],
       [Project2].[OrderQty] AS [OrderQty],
       [Project2].[Discount] AS [Discount],
       [Project2].[DocDiscount] AS [DocDiscount],
       [Project2].[RequestDate] AS [RequestDate],
       [Project2].[ProdCode] AS [ProdCode],
       [Project2].[XPartNum] AS [XPartNum],
       [Project2].[XRevisionNum] AS [XRevisionNum],
       [Project2].[PricePerCode] AS [PricePerCode],
       [Project2].[OrderComment] AS [OrderComment],
       [Project2].[ShipComment] AS [ShipComment],
       [Project2].[InvoiceComment] AS [InvoiceComment],
       [Project2].[PickListComment] AS [PickListComment],
       [Project2].[TaxCatID] AS [TaxCatID],
       [Project2].[AdvanceBillBal] AS [AdvanceBillBal],
       [Project2].[DocAdvanceBillBal] AS [DocAdvanceBillBal],
       [Project2].[QuoteNum] AS [QuoteNum],
       [Project2].[QuoteLine] AS [QuoteLine],
       [Project2].[TMBilling] AS [TMBilling],
       [Project2].[OrigWhyNoTax] AS [OrigWhyNoTax],
       [Project2].[NeedByDate] AS [NeedByDate],
       [Project2].[CustNum] AS [CustNum],
       [Project2].[Rework] AS [Rework],
       [Project2].[RMANum] AS [RMANum],
       [Project2].[RMALine] AS [RMALine],
       [Project2].[ProjectID] AS [ProjectID],
       [Project2].[ContractNum] AS [ContractNum],
       [Project2].[ContractCode] AS [ContractCode],
       [Project2].[BasePartNum] AS [BasePartNum],
       [Project2].[Warranty] AS [Warranty],
       [Project2].[WarrantyCode] AS [WarrantyCode],
       [Project2].[MaterialDuration] AS [MaterialDuration],
       [Project2].[LaborDuration] AS [LaborDuration],
       [Project2].[MiscDuration] AS [MiscDuration],
       [Project2].[MaterialMod] AS [MaterialMod],
       [Project2].[LaborMod] AS [LaborMod],
       [Project2].[WarrantyComment] AS [WarrantyComment],
       [Project2].[Onsite] AS [Onsite],
       [Project2].[MatCovered] AS [MatCovered],
       [Project2].[LabCovered] AS [LabCovered],
       [Project2].[MiscCovered] AS [MiscCovered],
       [Project2].[SalesUM] AS [SalesUM],
       [Project2].[SellingFactor] AS [SellingFactor],
       [Project2].[SellingQuantity] AS [SellingQuantity],
       [Project2].[SalesCatID] AS [SalesCatID],
       [Project2].[ShipLineComplete] AS [ShipLineComplete],
       [Project2].[CumeQty] AS [CumeQty],
       [Project2].[CumeDate] AS [CumeDate],
       [Project2].[MktgCampaignID] AS [MktgCampaignID],
       [Project2].[MktgEvntSeq] AS [MktgEvntSeq],
       [Project2].[LockQty] AS [LockQty],
       [Project2].[Linked] AS [Linked],
       [Project2].[ICPONum] AS [ICPONum],
       [Project2].[ICPOLine] AS [ICPOLine],
       [Project2].[ExtCompany] AS [ExtCompany],
       [Project2].[LastConfigDate] AS [LastConfigDate],
       [Project2].[LastConfigTime] AS [LastConfigTime],
       [Project2].[LastConfigUserID] AS [LastConfigUserID],
       [Project2].[ConfigUnitPrice] AS [ConfigUnitPrice],
       [Project2].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],
       [Project2].[PriceListCode] AS [PriceListCode],
       [Project2].[BreakListCode] AS [BreakListCode],
       [Project2].[PricingQty] AS [PricingQty],
       [Project2].[LockPrice] AS [LockPrice],
       [Project2].[ListPrice] AS [ListPrice],
       [Project2].[DocListPrice] AS [DocListPrice],
       [Project2].[OrdBasedPrice] AS [OrdBasedPrice],
       [Project2].[DocOrdBasedPrice] AS [DocOrdBasedPrice],
       [Project2].[PriceGroupCode] AS [PriceGroupCode],
       [Project2].[OverridePriceList] AS [OverridePriceList],
       [Project2].[BaseRevisionNum] AS [BaseRevisionNum],
       [Project2].[PricingValue] AS [PricingValue],
       [Project2].[DisplaySeq] AS [DisplaySeq],
       [Project2].[KitParentLine] AS [KitParentLine],
       [Project2].[KitAllowUpdate] AS [KitAllowUpdate],
       [Project2].[KitShipComplete] AS [KitShipComplete],
       [Project2].[KitBackFlush] AS [KitBackFlush],
       [Project2].[KitPrintCompsPS] AS [KitPrintCompsPS],
       [Project2].[KitPrintCompsInv] AS [KitPrintCompsInv],
       [Project2].[KitPricing] AS [KitPricing],
       [Project2].[KitQtyPer] AS [KitQtyPer],
       [Project2].[SellingFactorDirection] AS [SellingFactorDirection],
       [Project2].[RepRate1] AS [RepRate1],
       [Project2].[RepRate2] AS [RepRate2],
       [Project2].[RepRate3] AS [RepRate3],
       [Project2].[RepRate4] AS [RepRate4],
       [Project2].[RepRate5] AS [RepRate5],
       [Project2].[RepSplit1] AS [RepSplit1],
       [Project2].[RepSplit2] AS [RepSplit2],
       [Project2].[RepSplit3] AS [RepSplit3],
       [Project2].[RepSplit4] AS [RepSplit4],
       [Project2].[RepSplit5] AS [RepSplit5],
       [Project2].[DemandContractLine] AS [DemandContractLine],
       [Project2].[CreateNewJob] AS [CreateNewJob],
       [Project2].[DoNotShipBeforeDate] AS [DoNotShipBeforeDate],
       [Project2].[GetDtls] AS [GetDtls],
       [Project2].[DoNotShipAfterDate] AS [DoNotShipAfterDate],
       [Project2].[SchedJob] AS [SchedJob],
       [Project2].[RelJob] AS [RelJob],
       [Project2].[EnableCreateNewJob] AS [EnableCreateNewJob],
       [Project2].[EnableGetDtls] AS [EnableGetDtls],
       [Project2].[EnableSchedJob] AS [EnableSchedJob],
       [Project2].[EnableRelJob] AS [EnableRelJob],
       [Project2].[CounterSaleWarehouse] AS [CounterSaleWarehouse],
       [Project2].[CounterSaleBinNum] AS [CounterSaleBinNum],
       [Project2].[CounterSaleLotNum] AS [CounterSaleLotNum],
       [Project2].[CounterSaleDimCode] AS [CounterSaleDimCode],
       [Project2].[DemandDtlRejected] AS [DemandDtlRejected],
       [Project2].[KitFlag] AS [KitFlag],
       [Project2].[KitsLoaded] AS [KitsLoaded],
       [Project2].[DemandContractNum] AS [DemandContractNum],
       [Project2].[DemandHeadSeq] AS [DemandHeadSeq],
       [Project2].[DemandDtlSeq] AS [DemandDtlSeq],
       [Project2].[ChangedBy] AS [ChangedBy],
       [Project2].[ChangeDate] AS [ChangeDate],
       [Project2].[ChangeTime] AS [ChangeTime],
       [Project2].[ReverseCharge] AS [ReverseCharge],
       [Project2].[TotalReleases] AS [TotalReleases],
       [Project2].[Rpt1UnitPrice] AS [Rpt1UnitPrice],
       [Project2].[Rpt2UnitPrice] AS [Rpt2UnitPrice],
       [Project2].[Rpt3UnitPrice] AS [Rpt3UnitPrice],
       [Project2].[Rpt1Discount] AS [Rpt1Discount],
       [Project2].[Rpt2Discount] AS [Rpt2Discount],
       [Project2].[Rpt3Discount] AS [Rpt3Discount],
       [Project2].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],
       [Project2].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],
       [Project2].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],
       [Project2].[Rpt1ListPrice] AS [Rpt1ListPrice],
       [Project2].[Rpt2ListPrice] AS [Rpt2ListPrice],
       [Project2].[Rpt3ListPrice] AS [Rpt3ListPrice],
       [Project2].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],
       [Project2].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],
       [Project2].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],
       [Project2].[ExtPriceDtl] AS [ExtPriceDtl],
       [Project2].[DocExtPriceDtl] AS [DocExtPriceDtl],
       [Project2].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],
       [Project2].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],
       [Project2].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],
       [Project2].[LineStatus] AS [LineStatus],
       [Project2].[InUnitPrice] AS [InUnitPrice],
       [Project2].[DocInUnitPrice] AS [DocInUnitPrice],
       [Project2].[InDiscount] AS [InDiscount],
       [Project2].[DocInDiscount] AS [DocInDiscount],
       [Project2].[InListPrice] AS [InListPrice],
       [Project2].[DocInListPrice] AS [DocInListPrice],
       [Project2].[InOrdBasedPrice] AS [InOrdBasedPrice],
       [Project2].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],
       [Project2].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],
       [Project2].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],
       [Project2].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],
       [Project2].[Rpt1InDiscount] AS [Rpt1InDiscount],
       [Project2].[Rpt2InDiscount] AS [Rpt2InDiscount],
       [Project2].[Rpt3InDiscount] AS [Rpt3InDiscount],
       [Project2].[Rpt1InListPrice] AS [Rpt1InListPrice],
       [Project2].[Rpt2InListPrice] AS [Rpt2InListPrice],
       [Project2].[Rpt3InListPrice] AS [Rpt3InListPrice],
       [Project2].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],
       [Project2].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],
       [Project2].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],
       [Project2].[InExtPriceDtl] AS [InExtPriceDtl],
       [Project2].[DocInExtPriceDtl] AS [DocInExtPriceDtl],
       [Project2].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],
       [Project2].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],
       [Project2].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],
       [Project2].[OldOurOpenQty] AS [OldOurOpenQty],
       [Project2].[OldSellingOpenQty] AS [OldSellingOpenQty],
       [Project2].[OldOpenValue] AS [OldOpenValue],
       [Project2].[OldProdCode] AS [OldProdCode],
       [Project2].[PrevSellQty] AS [PrevSellQty],
       [Project2].[PrevPartNum] AS [PrevPartNum],
       [Project2].[PrevXPartNum] AS [PrevXPartNum],
       [Project2].[KitCompOrigSeq] AS [KitCompOrigSeq],
       [Project2].[KitCompOrigPart] AS [KitCompOrigPart],
       [Project2].[SmartStringProcessed] AS [SmartStringProcessed],
       [Project2].[SmartString] AS [SmartString],
       [Project2].[RenewalNbr] AS [RenewalNbr],
       [Project2].[DiscBreakListCode] AS [DiscBreakListCode],
       [Project2].[DiscListPrice] AS [DiscListPrice],
       [Project2].[LockDisc] AS [LockDisc],
       [Project2].[OverrideDiscPriceList] AS [OverrideDiscPriceList],
       [Project2].[GroupSeq] AS [GroupSeq],
       [Project2].[ECCOrderNum] AS [ECCOrderNum],
       [Project2].[ECCOrderLine] AS [ECCOrderLine],
       [Project2].[DupOnJobCrt] AS [DupOnJobCrt],
       [Project2].[UndersPct] AS [UndersPct],
       [Project2].[Overs] AS [Overs],
       [Project2].[Unders] AS [Unders],
       [Project2].[OversUnitPrice] AS [OversUnitPrice],
       [Project2].[PlanUserID] AS [PlanUserID],
       [Project2].[PlanGUID] AS [PlanGUID],
       [Project2].[MOMsourceType] AS [MOMsourceType],
       [Project2].[MOMsourceEst] AS [MOMsourceEst],
       [Project2].[DefaultOversPricing] AS [DefaultOversPricing],
       [Project2].[ECCPlant] AS [ECCPlant],
       [Project2].[ECCQuoteNum] AS [ECCQuoteNum],
       [Project2].[ECCQuoteLine] AS [ECCQuoteLine],
       [Project2].[SysRevID] AS [SysRevID],
       [Project2].[ForeignSysRowID] AS [ForeignSysRowID],
       [Project2].[MfgJobType] AS [MfgJobType],
       [Project2].[ProFormaInvComment] AS [ProFormaInvComment],
       [Project2].[CreateJob] AS [CreateJob],
       [Project2].[ContractID] AS [ContractID],
       [Project2].[LinkToContract] AS [LinkToContract],
       [Project2].[DocInAdvanceBillBal] AS [DocInAdvanceBillBal],
       [Project2].[InAdvanceBillBal] AS [InAdvanceBillBal],
       [Project2].[Rpt1InAdvanceBillBal] AS [Rpt1InAdvanceBillBal],
       [Project2].[Rpt2InAdvanceBillBal] AS [Rpt2InAdvanceBillBal],
       [Project2].[Rpt3InAdvanceBillBal] AS [Rpt3InAdvanceBillBal],
       [Project2].[PCLinkRemoved] AS [PCLinkRemoved],
       [Project2].[CommodityCode] AS [CommodityCode],
       [Project2].[MSRP] AS [MSRP],
       [Project2].[DocMSRP] AS [DocMSRP],
       [Project2].[Rpt1MSRP] AS [Rpt1MSRP],
       [Project2].[Rpt2MSRP] AS [Rpt2MSRP],
       [Project2].[Rpt3MSRP] AS [Rpt3MSRP],
       [Project2].[EndCustomerPrice] AS [EndCustomerPrice],
       [Project2].[DocEndCustomerPrice] AS [DocEndCustomerPrice],
       [Project2].[Rpt1EndCustomerPrice] AS [Rpt1EndCustomerPrice],
       [Project2].[Rpt2EndCustomerPrice] AS [Rpt2EndCustomerPrice],
       [Project2].[Rpt3EndCustomerPrice] AS [Rpt3EndCustomerPrice],
       [Project2].[PromotionalPrice] AS [PromotionalPrice],
       [Project2].[DocPromotionalPrice] AS [DocPromotionalPrice],
       [Project2].[Rpt1PromotionalPrice] AS [Rpt1PromotionalPrice],
       [Project2].[Rpt2PromotionalPrice] AS [Rpt2PromotionalPrice],
       [Project2].[Rpt3PromotionalPrice] AS [Rpt3PromotionalPrice],
       [Project2].[OrderLineStatusCode] AS [OrderLineStatusCode],
       [Project2].[AttributeSetID] AS [AttributeSetID],
       [Project2].[KBConfigProdID] AS [KBConfigProdID],
       [Project2].[KBOriginalConfigProdID] AS [KBOriginalConfigProdID],
       [Project2].[UD_SysRevID] AS [UD_SysRevID],
       [Project2].[sgcCloseReason_c] AS [sgcCloseReason_c],
       [Project2].[EstUnitCost_c] AS [EstUnitCost_c],
       [Project2].[SalesAgentReviewed_c] AS [SalesAgentReviewed_c],
       [Project2].[ManagerReviewed_c] AS [ManagerReviewed_c],
       [Project2].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],
       [Project2].[Branch0DollarComments_c] AS [Branch0DollarComments_c],
       [Project2].[sgc3PLRef_c] AS [sgc3PLRef_c]
FROM
(
    SELECT [Distinct1].[PartDescription] AS [PartDescription],
           [Distinct1].[AccountCoordinator_c] AS [AccountCoordinator_c],
           1 AS [C1],
           [Join14].[ForeignSysRowID1] AS [ForeignSysRowID],
           [Join14].[UD_SysRevID1] AS [UD_SysRevID],
           [Join14].[sgcCloseReason_c1] AS [sgcCloseReason_c],
           [Join14].[EstUnitCost_c] AS [EstUnitCost_c],
           [Join14].[SalesAgentReviewed_c1] AS [SalesAgentReviewed_c],
           [Join14].[ManagerReviewed_c1] AS [ManagerReviewed_c],
           [Join14].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],
           [Join14].[Branch0DollarComments_c] AS [Branch0DollarComments_c],
           [Join14].[sgc3PLRef_c1] AS [sgc3PLRef_c],
           [Join14].[VoidLine] AS [VoidLine],
           [Join14].[OpenLine] AS [OpenLine],
           [Join14].[Company1] AS [Company],
           [Join14].[OrderNum1] AS [OrderNum],
           [Join14].[OrderLine] AS [OrderLine],
           [Join14].[LineType] AS [LineType],
           [Join14].[PartNum1] AS [PartNum],
           [Join14].[LineDesc] AS [LineDesc],
           [Join14].[Reference] AS [Reference],
           [Join14].[IUM1] AS [IUM],
           [Join14].[RevisionNum] AS [RevisionNum],
           [Join14].[POLine] AS [POLine],
           [Join14].[Commissionable] AS [Commissionable],
           [Join14].[DiscountPercent1] AS [DiscountPercent],
           [Join14].[UnitPrice1] AS [UnitPrice],
           [Join14].[DocUnitPrice] AS [DocUnitPrice],
           [Join14].[OrderQty] AS [OrderQty],
           [Join14].[Discount] AS [Discount],
           [Join14].[DocDiscount] AS [DocDiscount],
           [Join14].[RequestDate1] AS [RequestDate],
           [Join14].[ProdCode1] AS [ProdCode],
           [Join14].[XPartNum] AS [XPartNum],
           [Join14].[XRevisionNum] AS [XRevisionNum],
           [Join14].[PricePerCode1] AS [PricePerCode],
           [Join14].[OrderComment1] AS [OrderComment],
           [Join14].[ShipComment1] AS [ShipComment],
           [Join14].[InvoiceComment1] AS [InvoiceComment],
           [Join14].[PickListComment1] AS [PickListComment],
           [Join14].[TaxCatID1] AS [TaxCatID],
           [Join14].[AdvanceBillBal] AS [AdvanceBillBal],
           [Join14].[DocAdvanceBillBal] AS [DocAdvanceBillBal],
           [Join14].[QuoteNum] AS [QuoteNum],
           [Join14].[QuoteLine] AS [QuoteLine],
           [Join14].[TMBilling] AS [TMBilling],
           [Join14].[OrigWhyNoTax] AS [OrigWhyNoTax],
           [Join14].[NeedByDate1] AS [NeedByDate],
           [Join14].[CustNum1] AS [CustNum],
           [Join14].[Rework] AS [Rework],
           [Join14].[RMANum] AS [RMANum],
           [Join14].[RMALine] AS [RMALine],
           [Join14].[ProjectID] AS [ProjectID],
           [Join14].[ContractNum] AS [ContractNum],
           [Join14].[ContractCode] AS [ContractCode],
           [Join14].[BasePartNum1] AS [BasePartNum],
           [Join14].[Warranty] AS [Warranty],
           [Join14].[WarrantyCode1] AS [WarrantyCode],
           [Join14].[MaterialDuration] AS [MaterialDuration],
           [Join14].[LaborDuration] AS [LaborDuration],
           [Join14].[MiscDuration] AS [MiscDuration],
           [Join14].[MaterialMod] AS [MaterialMod],
           [Join14].[LaborMod] AS [LaborMod],
           [Join14].[WarrantyComment] AS [WarrantyComment],
           [Join14].[Onsite] AS [Onsite],
           [Join14].[MatCovered] AS [MatCovered],
           [Join14].[LabCovered] AS [LabCovered],
           [Join14].[MiscCovered] AS [MiscCovered],
           [Join14].[SalesUM1] AS [SalesUM],
           [Join14].[SellingFactor1] AS [SellingFactor],
           [Join14].[SellingQuantity] AS [SellingQuantity],
           [Join14].[SalesCatID] AS [SalesCatID],
           [Join14].[ShipLineComplete] AS [ShipLineComplete],
           [Join14].[CumeQty] AS [CumeQty],
           [Join14].[CumeDate] AS [CumeDate],
           [Join14].[MktgCampaignID] AS [MktgCampaignID],
           [Join14].[MktgEvntSeq] AS [MktgEvntSeq],
           [Join14].[LockQty1] AS [LockQty],
           [Join14].[Linked1] AS [Linked],
           [Join14].[ICPONum1] AS [ICPONum],
           [Join14].[ICPOLine] AS [ICPOLine],
           [Join14].[ExtCompany1] AS [ExtCompany],
           [Join14].[LastConfigDate] AS [LastConfigDate],
           [Join14].[LastConfigTime] AS [LastConfigTime],
           [Join14].[LastConfigUserID] AS [LastConfigUserID],
           [Join14].[ConfigUnitPrice] AS [ConfigUnitPrice],
           [Join14].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],
           [Join14].[PriceListCode] AS [PriceListCode],
           [Join14].[BreakListCode] AS [BreakListCode],
           [Join14].[PricingQty] AS [PricingQty],
           [Join14].[LockPrice] AS [LockPrice],
           [Join14].[ListPrice] AS [ListPrice],
           [Join14].[DocListPrice] AS [DocListPrice],
           [Join14].[OrdBasedPrice] AS [OrdBasedPrice],
           [Join14].[DocOrdBasedPrice] AS [DocOrdBasedPrice],
           [Join14].[PriceGroupCode] AS [PriceGroupCode],
           [Join14].[OverridePriceList] AS [OverridePriceList],
           [Join14].[BaseRevisionNum] AS [BaseRevisionNum],
           [Join14].[PricingValue] AS [PricingValue],
           [Join14].[DisplaySeq] AS [DisplaySeq],
           [Join14].[KitParentLine] AS [KitParentLine],
           [Join14].[KitAllowUpdate] AS [KitAllowUpdate],
           [Join14].[KitShipComplete] AS [KitShipComplete],
           [Join14].[KitBackFlush] AS [KitBackFlush],
           [Join14].[KitPrintCompsPS] AS [KitPrintCompsPS],
           [Join14].[KitPrintCompsInv] AS [KitPrintCompsInv],
           [Join14].[KitPricing] AS [KitPricing],
           [Join14].[KitQtyPer] AS [KitQtyPer],
           [Join14].[SellingFactorDirection1] AS [SellingFactorDirection],
           [Join14].[RepRate11] AS [RepRate1],
           [Join14].[RepRate21] AS [RepRate2],
           [Join14].[RepRate31] AS [RepRate3],
           [Join14].[RepRate41] AS [RepRate4],
           [Join14].[RepRate51] AS [RepRate5],
           [Join14].[RepSplit11] AS [RepSplit1],
           [Join14].[RepSplit21] AS [RepSplit2],
           [Join14].[RepSplit31] AS [RepSplit3],
           [Join14].[RepSplit41] AS [RepSplit4],
           [Join14].[RepSplit51] AS [RepSplit5],
           [Join14].[DemandContractLine] AS [DemandContractLine],
           [Join14].[CreateNewJob] AS [CreateNewJob],
           [Join14].[DoNotShipBeforeDate1] AS [DoNotShipBeforeDate],
           [Join14].[GetDtls] AS [GetDtls],
           [Join14].[DoNotShipAfterDate1] AS [DoNotShipAfterDate],
           [Join14].[SchedJob] AS [SchedJob],
           [Join14].[RelJob] AS [RelJob],
           [Join14].[EnableCreateNewJob] AS [EnableCreateNewJob],
           [Join14].[EnableGetDtls] AS [EnableGetDtls],
           [Join14].[EnableSchedJob] AS [EnableSchedJob],
           [Join14].[EnableRelJob] AS [EnableRelJob],
           [Join14].[CounterSaleWarehouse] AS [CounterSaleWarehouse],
           [Join14].[CounterSaleBinNum] AS [CounterSaleBinNum],
           [Join14].[CounterSaleLotNum] AS [CounterSaleLotNum],
           [Join14].[CounterSaleDimCode] AS [CounterSaleDimCode],
           [Join14].[DemandDtlRejected] AS [DemandDtlRejected],
           [Join14].[KitFlag] AS [KitFlag],
           [Join14].[KitsLoaded] AS [KitsLoaded],
           [Join14].[DemandContractNum1] AS [DemandContractNum],
           [Join14].[DemandHeadSeq1] AS [DemandHeadSeq],
           [Join14].[DemandDtlSeq] AS [DemandDtlSeq],
           [Join14].[ChangedBy1] AS [ChangedBy],
           [Join14].[ChangeDate1] AS [ChangeDate],
           [Join14].[ChangeTime1] AS [ChangeTime],
           [Join14].[ReverseCharge] AS [ReverseCharge],
           [Join14].[TotalReleases1] AS [TotalReleases],
           [Join14].[Rpt1UnitPrice] AS [Rpt1UnitPrice],
           [Join14].[Rpt2UnitPrice] AS [Rpt2UnitPrice],
           [Join14].[Rpt3UnitPrice] AS [Rpt3UnitPrice],
           [Join14].[Rpt1Discount] AS [Rpt1Discount],
           [Join14].[Rpt2Discount] AS [Rpt2Discount],
           [Join14].[Rpt3Discount] AS [Rpt3Discount],
           [Join14].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],
           [Join14].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],
           [Join14].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],
           [Join14].[Rpt1ListPrice] AS [Rpt1ListPrice],
           [Join14].[Rpt2ListPrice] AS [Rpt2ListPrice],
           [Join14].[Rpt3ListPrice] AS [Rpt3ListPrice],
           [Join14].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],
           [Join14].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],
           [Join14].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],
           [Join14].[ExtPriceDtl] AS [ExtPriceDtl],
           [Join14].[DocExtPriceDtl] AS [DocExtPriceDtl],
           [Join14].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],
           [Join14].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],
           [Join14].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],
           [Join14].[LineStatus] AS [LineStatus],
           [Join14].[InUnitPrice] AS [InUnitPrice],
           [Join14].[DocInUnitPrice] AS [DocInUnitPrice],
           [Join14].[InDiscount] AS [InDiscount],
           [Join14].[DocInDiscount] AS [DocInDiscount],
           [Join14].[InListPrice] AS [InListPrice],
           [Join14].[DocInListPrice] AS [DocInListPrice],
           [Join14].[InOrdBasedPrice] AS [InOrdBasedPrice],
           [Join14].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],
           [Join14].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],
           [Join14].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],
           [Join14].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],
           [Join14].[Rpt1InDiscount] AS [Rpt1InDiscount],
           [Join14].[Rpt2InDiscount] AS [Rpt2InDiscount],
           [Join14].[Rpt3InDiscount] AS [Rpt3InDiscount],
           [Join14].[Rpt1InListPrice] AS [Rpt1InListPrice],
           [Join14].[Rpt2InListPrice] AS [Rpt2InListPrice],
           [Join14].[Rpt3InListPrice] AS [Rpt3InListPrice],
           [Join14].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],
           [Join14].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],
           [Join14].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],
           [Join14].[InExtPriceDtl] AS [InExtPriceDtl],
           [Join14].[DocInExtPriceDtl] AS [DocInExtPriceDtl],
           [Join14].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],
           [Join14].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],
           [Join14].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],
           [Join14].[OldOurOpenQty] AS [OldOurOpenQty],
           [Join14].[OldSellingOpenQty] AS [OldSellingOpenQty],
           [Join14].[OldOpenValue] AS [OldOpenValue],
           [Join14].[OldProdCode] AS [OldProdCode],
           [Join14].[PrevSellQty] AS [PrevSellQty],
           [Join14].[PrevPartNum] AS [PrevPartNum],
           [Join14].[PrevXPartNum] AS [PrevXPartNum],
           [Join14].[KitCompOrigSeq] AS [KitCompOrigSeq],
           [Join14].[KitCompOrigPart] AS [KitCompOrigPart],
           [Join14].[SmartStringProcessed] AS [SmartStringProcessed],
           [Join14].[SmartString] AS [SmartString],
           [Join14].[RenewalNbr] AS [RenewalNbr],
           [Join14].[DiscBreakListCode] AS [DiscBreakListCode],
           [Join14].[DiscListPrice] AS [DiscListPrice],
           [Join14].[LockDisc] AS [LockDisc],
           [Join14].[OverrideDiscPriceList] AS [OverrideDiscPriceList],
           [Join14].[GroupSeq] AS [GroupSeq],
           [Join14].[ECCOrderNum1] AS [ECCOrderNum],
           [Join14].[ECCOrderLine] AS [ECCOrderLine],
           [Join14].[DupOnJobCrt1] AS [DupOnJobCrt],
           [Join14].[UndersPct1] AS [UndersPct],
           [Join14].[Overs] AS [Overs],
           [Join14].[Unders] AS [Unders],
           [Join14].[OversUnitPrice] AS [OversUnitPrice],
           [Join14].[PlanUserID] AS [PlanUserID],
           [Join14].[PlanGUID] AS [PlanGUID],
           [Join14].[MOMsourceType] AS [MOMsourceType],
           [Join14].[MOMsourceEst] AS [MOMsourceEst],
           [Join14].[DefaultOversPricing1] AS [DefaultOversPricing],
           [Join14].[ECCPlant] AS [ECCPlant],
           [Join14].[ECCQuoteNum] AS [ECCQuoteNum],
           [Join14].[ECCQuoteLine] AS [ECCQuoteLine],
           [Join14].[SysRevID1] AS [SysRevID],
           [Join14].[MfgJobType] AS [MfgJobType],
           [Join14].[ProFormaInvComment1] AS [ProFormaInvComment],
           [Join14].[CreateJob] AS [CreateJob],
           [Join14].[ContractID] AS [ContractID],
           [Join14].[LinkToContract1] AS [LinkToContract],
           [Join14].[DocInAdvanceBillBal] AS [DocInAdvanceBillBal],
           [Join14].[InAdvanceBillBal] AS [InAdvanceBillBal],
           [Join14].[Rpt1InAdvanceBillBal] AS [Rpt1InAdvanceBillBal],
           [Join14].[Rpt2InAdvanceBillBal] AS [Rpt2InAdvanceBillBal],
           [Join14].[Rpt3InAdvanceBillBal] AS [Rpt3InAdvanceBillBal],
           [Join14].[PCLinkRemoved] AS [PCLinkRemoved],
           [Join14].[CommodityCode1] AS [CommodityCode],
           [Join14].[MSRP] AS [MSRP],
           [Join14].[DocMSRP] AS [DocMSRP],
           [Join14].[Rpt1MSRP] AS [Rpt1MSRP],
           [Join14].[Rpt2MSRP] AS [Rpt2MSRP],
           [Join14].[Rpt3MSRP] AS [Rpt3MSRP],
           [Join14].[EndCustomerPrice] AS [EndCustomerPrice],
           [Join14].[DocEndCustomerPrice] AS [DocEndCustomerPrice],
           [Join14].[Rpt1EndCustomerPrice] AS [Rpt1EndCustomerPrice],
           [Join14].[Rpt2EndCustomerPrice] AS [Rpt2EndCustomerPrice],
           [Join14].[Rpt3EndCustomerPrice] AS [Rpt3EndCustomerPrice],
           [Join14].[PromotionalPrice] AS [PromotionalPrice],
           [Join14].[DocPromotionalPrice] AS [DocPromotionalPrice],
           [Join14].[Rpt1PromotionalPrice] AS [Rpt1PromotionalPrice],
           [Join14].[Rpt2PromotionalPrice] AS [Rpt2PromotionalPrice],
           [Join14].[Rpt3PromotionalPrice] AS [Rpt3PromotionalPrice],
           [Join14].[OrderLineStatusCode] AS [OrderLineStatusCode],
           [Join14].[AttributeSetID] AS [AttributeSetID],
           [Join14].[KBConfigProdID] AS [KBConfigProdID],
           [Join14].[KBOriginalConfigProdID] AS [KBOriginalConfigProdID],
           CASE
               WHEN ([Join14].[OrderNum2] IS NULL) THEN
                   CAST(NULL AS INT)
               ELSE
                   1
           END AS [C2]
    FROM
    (
        SELECT DISTINCT
               [Join4].[PartDescription] AS [PartDescription],
               [Join6].[AccountCoordinator_c] AS [AccountCoordinator_c]
        FROM [Erp].[OrderHed_UD] AS [Extent1]
            INNER JOIN [Erp].[OrderHed] AS [Extent2]
                ON [Extent1].[ForeignSysRowID] = [Extent2].[SysRowID]
            INNER JOIN
            (
                SELECT [Extent4].[Company] AS [Company],
                       [Extent4].[OrderNum] AS [OrderNum],
                       [Extent4].[PartNum] AS [PartNum]
                FROM [Erp].[OrderDtl_UD] AS [Extent3]
                    INNER JOIN [Erp].[OrderDtl] AS [Extent4]
                        ON [Extent3].[ForeignSysRowID] = [Extent4].[SysRowID]
            ) AS [Join2]
                ON [Extent2].[OrderNum] = [Join2].[OrderNum]
            INNER JOIN
            (
                SELECT [Extent6].[Company] AS [Company],
                       [Extent6].[PartNum] AS [PartNum],
                       [Extent6].[PartDescription] AS [PartDescription]
                FROM [Erp].[Part_UD] AS [Extent5]
                    INNER JOIN [Erp].[Part] AS [Extent6]
                        ON [Extent5].[ForeignSysRowID] = [Extent6].[SysRowID]
            ) AS [Join4]
                ON ([Join2].[Company] = [Join4].[Company])
                   AND ([Join2].[PartNum] = [Join4].[PartNum])
            INNER JOIN
            (
                SELECT [Extent7].[AccountCoordinator_c] AS [AccountCoordinator_c],
                       [Extent8].[Company] AS [Company],
                       [Extent8].[CustNum] AS [CustNum]
                FROM [Erp].[Customer_UD] AS [Extent7]
                    INNER JOIN [Erp].[Customer] AS [Extent8]
                        ON [Extent7].[ForeignSysRowID] = [Extent8].[SysRowID]
            ) AS [Join6]
                ON ([Extent2].[Company] = [Join6].[Company])
                   AND ([Extent2].[CustNum] = [Join6].[CustNum])
        WHERE (1 = [Extent2].[ReadyToCalc])
              AND (N'EPI-METHOD' = [Extent2].[EntryPerson])
    ) AS [Distinct1]
        LEFT OUTER JOIN
        (
            SELECT [Extent10].[OrderNum] AS [OrderNum2],
                   [Extent10].[EntryPerson] AS [EntryPerson],
                   [Extent10].[ReadyToCalc] AS [ReadyToCalc],
                   [Join9].[ForeignSysRowID1],
                   [Join9].[UD_SysRevID1],
                   [Join9].[sgcCloseReason_c1],
                   [Join9].[EstUnitCost_c],
                   [Join9].[SalesAgentReviewed_c1],
                   [Join9].[ManagerReviewed_c1],
                   [Join9].[Branch0DollarReviewd_c],
                   [Join9].[Branch0DollarComments_c],
                   [Join9].[sgc3PLRef_c1],
                   [Join9].[VoidLine],
                   [Join9].[OpenLine],
                   [Join9].[Company1],
                   [Join9].[OrderNum1],
                   [Join9].[OrderLine],
                   [Join9].[LineType],
                   [Join9].[PartNum1],
                   [Join9].[LineDesc],
                   [Join9].[Reference],
                   [Join9].[IUM1],
                   [Join9].[RevisionNum],
                   [Join9].[POLine],
                   [Join9].[Commissionable],
                   [Join9].[DiscountPercent1],
                   [Join9].[UnitPrice1],
                   [Join9].[DocUnitPrice],
                   [Join9].[OrderQty],
                   [Join9].[Discount],
                   [Join9].[DocDiscount],
                   [Join9].[RequestDate1],
                   [Join9].[ProdCode1],
                   [Join9].[XPartNum],
                   [Join9].[XRevisionNum],
                   [Join9].[PricePerCode1],
                   [Join9].[OrderComment1],
                   [Join9].[ShipComment1],
                   [Join9].[InvoiceComment1],
                   [Join9].[PickListComment1],
                   [Join9].[TaxCatID1],
                   [Join9].[AdvanceBillBal],
                   [Join9].[DocAdvanceBillBal],
                   [Join9].[QuoteNum],
                   [Join9].[QuoteLine],
                   [Join9].[TMBilling],
                   [Join9].[OrigWhyNoTax],
                   [Join9].[NeedByDate1],
                   [Join9].[CustNum1],
                   [Join9].[Rework],
                   [Join9].[RMANum],
                   [Join9].[RMALine],
                   [Join9].[ProjectID],
                   [Join9].[ContractNum],
                   [Join9].[ContractCode],
                   [Join9].[BasePartNum1],
                   [Join9].[Warranty],
                   [Join9].[WarrantyCode1],
                   [Join9].[MaterialDuration],
                   [Join9].[LaborDuration],
                   [Join9].[MiscDuration],
                   [Join9].[MaterialMod],
                   [Join9].[LaborMod],
                   [Join9].[WarrantyComment],
                   [Join9].[Onsite],
                   [Join9].[MatCovered],
                   [Join9].[LabCovered],
                   [Join9].[MiscCovered],
                   [Join9].[SalesUM1],
                   [Join9].[SellingFactor1],
                   [Join9].[SellingQuantity],
                   [Join9].[SalesCatID],
                   [Join9].[ShipLineComplete],
                   [Join9].[CumeQty],
                   [Join9].[CumeDate],
                   [Join9].[MktgCampaignID],
                   [Join9].[MktgEvntSeq],
                   [Join9].[LockQty1],
                   [Join9].[Linked1],
                   [Join9].[ICPONum1],
                   [Join9].[ICPOLine],
                   [Join9].[ExtCompany1],
                   [Join9].[LastConfigDate],
                   [Join9].[LastConfigTime],
                   [Join9].[LastConfigUserID],
                   [Join9].[ConfigUnitPrice],
                   [Join9].[ConfigBaseUnitPrice],
                   [Join9].[PriceListCode],
                   [Join9].[BreakListCode],
                   [Join9].[PricingQty],
                   [Join9].[LockPrice],
                   [Join9].[ListPrice],
                   [Join9].[DocListPrice],
                   [Join9].[OrdBasedPrice],
                   [Join9].[DocOrdBasedPrice],
                   [Join9].[PriceGroupCode],
                   [Join9].[OverridePriceList],
                   [Join9].[BaseRevisionNum],
                   [Join9].[PricingValue],
                   [Join9].[DisplaySeq],
                   [Join9].[KitParentLine],
                   [Join9].[KitAllowUpdate],
                   [Join9].[KitShipComplete],
                   [Join9].[KitBackFlush],
                   [Join9].[KitPrintCompsPS],
                   [Join9].[KitPrintCompsInv],
                   [Join9].[KitPricing],
                   [Join9].[KitQtyPer],
                   [Join9].[SellingFactorDirection1],
                   [Join9].[RepRate11],
                   [Join9].[RepRate21],
                   [Join9].[RepRate31],
                   [Join9].[RepRate41],
                   [Join9].[RepRate51],
                   [Join9].[RepSplit11],
                   [Join9].[RepSplit21],
                   [Join9].[RepSplit31],
                   [Join9].[RepSplit41],
                   [Join9].[RepSplit51],
                   [Join9].[DemandContractLine],
                   [Join9].[CreateNewJob],
                   [Join9].[DoNotShipBeforeDate1],
                   [Join9].[GetDtls],
                   [Join9].[DoNotShipAfterDate1],
                   [Join9].[SchedJob],
                   [Join9].[RelJob],
                   [Join9].[EnableCreateNewJob],
                   [Join9].[EnableGetDtls],
                   [Join9].[EnableSchedJob],
                   [Join9].[EnableRelJob],
                   [Join9].[CounterSaleWarehouse],
                   [Join9].[CounterSaleBinNum],
                   [Join9].[CounterSaleLotNum],
                   [Join9].[CounterSaleDimCode],
                   [Join9].[DemandDtlRejected],
                   [Join9].[KitFlag],
                   [Join9].[KitsLoaded],
                   [Join9].[DemandContractNum1],
                   [Join9].[DemandHeadSeq1],
                   [Join9].[DemandDtlSeq],
                   [Join9].[ChangedBy1],
                   [Join9].[ChangeDate1],
                   [Join9].[ChangeTime1],
                   [Join9].[ReverseCharge],
                   [Join9].[TotalReleases1],
                   [Join9].[Rpt1UnitPrice],
                   [Join9].[Rpt2UnitPrice],
                   [Join9].[Rpt3UnitPrice],
                   [Join9].[Rpt1Discount],
                   [Join9].[Rpt2Discount],
                   [Join9].[Rpt3Discount],
                   [Join9].[Rpt1AdvanceBillBal],
                   [Join9].[Rpt2AdvanceBillBal],
                   [Join9].[Rpt3AdvanceBillBal],
                   [Join9].[Rpt1ListPrice],
                   [Join9].[Rpt2ListPrice],
                   [Join9].[Rpt3ListPrice],
                   [Join9].[Rpt1OrdBasedPrice],
                   [Join9].[Rpt2OrdBasedPrice],
                   [Join9].[Rpt3OrdBasedPrice],
                   [Join9].[ExtPriceDtl],
                   [Join9].[DocExtPriceDtl],
                   [Join9].[Rpt1ExtPriceDtl],
                   [Join9].[Rpt2ExtPriceDtl],
                   [Join9].[Rpt3ExtPriceDtl],
                   [Join9].[LineStatus],
                   [Join9].[InUnitPrice],
                   [Join9].[DocInUnitPrice],
                   [Join9].[InDiscount],
                   [Join9].[DocInDiscount],
                   [Join9].[InListPrice],
                   [Join9].[DocInListPrice],
                   [Join9].[InOrdBasedPrice],
                   [Join9].[DocInOrdBasedPrice],
                   [Join9].[Rpt1InUnitPrice],
                   [Join9].[Rpt2InUnitPrice],
                   [Join9].[Rpt3InUnitPrice],
                   [Join9].[Rpt1InDiscount],
                   [Join9].[Rpt2InDiscount],
                   [Join9].[Rpt3InDiscount],
                   [Join9].[Rpt1InListPrice],
                   [Join9].[Rpt2InListPrice],
                   [Join9].[Rpt3InListPrice],
                   [Join9].[Rpt1InOrdBasedPrice],
                   [Join9].[Rpt2InOrdBasedPrice],
                   [Join9].[Rpt3InOrdBasedPrice],
                   [Join9].[InExtPriceDtl],
                   [Join9].[DocInExtPriceDtl],
                   [Join9].[Rpt1InExtPriceDtl],
                   [Join9].[Rpt2InExtPriceDtl],
                   [Join9].[Rpt3InExtPriceDtl],
                   [Join9].[OldOurOpenQty],
                   [Join9].[OldSellingOpenQty],
                   [Join9].[OldOpenValue],
                   [Join9].[OldProdCode],
                   [Join9].[PrevSellQty],
                   [Join9].[PrevPartNum],
                   [Join9].[PrevXPartNum],
                   [Join9].[KitCompOrigSeq],
                   [Join9].[KitCompOrigPart],
                   [Join9].[SmartStringProcessed],
                   [Join9].[SmartString],
                   [Join9].[RenewalNbr],
                   [Join9].[DiscBreakListCode],
                   [Join9].[DiscListPrice],
                   [Join9].[LockDisc],
                   [Join9].[OverrideDiscPriceList],
                   [Join9].[GroupSeq],
                   [Join9].[ECCOrderNum1],
                   [Join9].[ECCOrderLine],
                   [Join9].[DupOnJobCrt1],
                   [Join9].[UndersPct1],
                   [Join9].[Overs],
                   [Join9].[Unders],
                   [Join9].[OversUnitPrice],
                   [Join9].[PlanUserID],
                   [Join9].[PlanGUID],
                   [Join9].[MOMsourceType],
                   [Join9].[MOMsourceEst],
                   [Join9].[DefaultOversPricing1],
                   [Join9].[ECCPlant],
                   [Join9].[ECCQuoteNum],
                   [Join9].[ECCQuoteLine],
                   [Join9].[SysRevID1],
                   [Join9].[MfgJobType],
                   [Join9].[ProFormaInvComment1],
                   [Join9].[CreateJob],
                   [Join9].[ContractID],
                   [Join9].[LinkToContract1],
                   [Join9].[DocInAdvanceBillBal],
                   [Join9].[InAdvanceBillBal],
                   [Join9].[Rpt1InAdvanceBillBal],
                   [Join9].[Rpt2InAdvanceBillBal],
                   [Join9].[Rpt3InAdvanceBillBal],
                   [Join9].[PCLinkRemoved],
                   [Join9].[CommodityCode1],
                   [Join9].[MSRP],
                   [Join9].[DocMSRP],
                   [Join9].[Rpt1MSRP],
                   [Join9].[Rpt2MSRP],
                   [Join9].[Rpt3MSRP],
                   [Join9].[EndCustomerPrice],
                   [Join9].[DocEndCustomerPrice],
                   [Join9].[Rpt1EndCustomerPrice],
                   [Join9].[Rpt2EndCustomerPrice],
                   [Join9].[Rpt3EndCustomerPrice],
                   [Join9].[PromotionalPrice],
                   [Join9].[DocPromotionalPrice],
                   [Join9].[Rpt1PromotionalPrice],
                   [Join9].[Rpt2PromotionalPrice],
                   [Join9].[Rpt3PromotionalPrice],
                   [Join9].[OrderLineStatusCode],
                   [Join9].[AttributeSetID],
                   [Join9].[KBConfigProdID],
                   [Join9].[KBOriginalConfigProdID],
                   [Join11].[Company2],
                   [Join11].[PartNum2],
                   [Join11].[PartDescription],
                   [Join13].[AccountCoordinator_c],
                   [Join13].[Company3],
                   [Join13].[CustNum2]
            FROM [Erp].[OrderHed_UD] AS [Extent9]
                INNER JOIN [Erp].[OrderHed] AS [Extent10]
                    ON [Extent9].[ForeignSysRowID] = [Extent10].[SysRowID]
                INNER JOIN
                (
                    SELECT [Extent11].[ForeignSysRowID] AS [ForeignSysRowID1],
                           [Extent11].[UD_SysRevID] AS [UD_SysRevID1],
                           [Extent11].[sgcCloseReason_c] AS [sgcCloseReason_c1],
                           [Extent11].[EstUnitCost_c] AS [EstUnitCost_c],
                           [Extent11].[SalesAgentReviewed_c] AS [SalesAgentReviewed_c1],
                           [Extent11].[ManagerReviewed_c] AS [ManagerReviewed_c1],
                           [Extent11].[Branch0DollarReviewd_c] AS [Branch0DollarReviewd_c],
                           [Extent11].[Branch0DollarComments_c] AS [Branch0DollarComments_c],
                           [Extent11].[sgc3PLRef_c] AS [sgc3PLRef_c1],
                           [Extent12].[VoidLine] AS [VoidLine],
                           [Extent12].[OpenLine] AS [OpenLine],
                           [Extent12].[Company] AS [Company1],
                           [Extent12].[OrderNum] AS [OrderNum1],
                           [Extent12].[OrderLine] AS [OrderLine],
                           [Extent12].[LineType] AS [LineType],
                           [Extent12].[PartNum] AS [PartNum1],
                           [Extent12].[LineDesc] AS [LineDesc],
                           [Extent12].[Reference] AS [Reference],
                           [Extent12].[IUM] AS [IUM1],
                           [Extent12].[RevisionNum] AS [RevisionNum],
                           [Extent12].[POLine] AS [POLine],
                           [Extent12].[Commissionable] AS [Commissionable],
                           [Extent12].[DiscountPercent] AS [DiscountPercent1],
                           [Extent12].[UnitPrice] AS [UnitPrice1],
                           [Extent12].[DocUnitPrice] AS [DocUnitPrice],
                           [Extent12].[OrderQty] AS [OrderQty],
                           [Extent12].[Discount] AS [Discount],
                           [Extent12].[DocDiscount] AS [DocDiscount],
                           [Extent12].[RequestDate] AS [RequestDate1],
                           [Extent12].[ProdCode] AS [ProdCode1],
                           [Extent12].[XPartNum] AS [XPartNum],
                           [Extent12].[XRevisionNum] AS [XRevisionNum],
                           [Extent12].[PricePerCode] AS [PricePerCode1],
                           [Extent12].[OrderComment] AS [OrderComment1],
                           [Extent12].[ShipComment] AS [ShipComment1],
                           [Extent12].[InvoiceComment] AS [InvoiceComment1],
                           [Extent12].[PickListComment] AS [PickListComment1],
                           [Extent12].[TaxCatID] AS [TaxCatID1],
                           [Extent12].[AdvanceBillBal] AS [AdvanceBillBal],
                           [Extent12].[DocAdvanceBillBal] AS [DocAdvanceBillBal],
                           [Extent12].[QuoteNum] AS [QuoteNum],
                           [Extent12].[QuoteLine] AS [QuoteLine],
                           [Extent12].[TMBilling] AS [TMBilling],
                           [Extent12].[OrigWhyNoTax] AS [OrigWhyNoTax],
                           [Extent12].[NeedByDate] AS [NeedByDate1],
                           [Extent12].[CustNum] AS [CustNum1],
                           [Extent12].[Rework] AS [Rework],
                           [Extent12].[RMANum] AS [RMANum],
                           [Extent12].[RMALine] AS [RMALine],
                           [Extent12].[ProjectID] AS [ProjectID],
                           [Extent12].[ContractNum] AS [ContractNum],
                           [Extent12].[ContractCode] AS [ContractCode],
                           [Extent12].[BasePartNum] AS [BasePartNum1],
                           [Extent12].[Warranty] AS [Warranty],
                           [Extent12].[WarrantyCode] AS [WarrantyCode1],
                           [Extent12].[MaterialDuration] AS [MaterialDuration],
                           [Extent12].[LaborDuration] AS [LaborDuration],
                           [Extent12].[MiscDuration] AS [MiscDuration],
                           [Extent12].[MaterialMod] AS [MaterialMod],
                           [Extent12].[LaborMod] AS [LaborMod],
                           [Extent12].[WarrantyComment] AS [WarrantyComment],
                           [Extent12].[Onsite] AS [Onsite],
                           [Extent12].[MatCovered] AS [MatCovered],
                           [Extent12].[LabCovered] AS [LabCovered],
                           [Extent12].[MiscCovered] AS [MiscCovered],
                           [Extent12].[SalesUM] AS [SalesUM1],
                           [Extent12].[SellingFactor] AS [SellingFactor1],
                           [Extent12].[SellingQuantity] AS [SellingQuantity],
                           [Extent12].[SalesCatID] AS [SalesCatID],
                           [Extent12].[ShipLineComplete] AS [ShipLineComplete],
                           [Extent12].[CumeQty] AS [CumeQty],
                           [Extent12].[CumeDate] AS [CumeDate],
                           [Extent12].[MktgCampaignID] AS [MktgCampaignID],
                           [Extent12].[MktgEvntSeq] AS [MktgEvntSeq],
                           [Extent12].[LockQty] AS [LockQty1],
                           [Extent12].[Linked] AS [Linked1],
                           [Extent12].[ICPONum] AS [ICPONum1],
                           [Extent12].[ICPOLine] AS [ICPOLine],
                           [Extent12].[ExtCompany] AS [ExtCompany1],
                           [Extent12].[LastConfigDate] AS [LastConfigDate],
                           [Extent12].[LastConfigTime] AS [LastConfigTime],
                           [Extent12].[LastConfigUserID] AS [LastConfigUserID],
                           [Extent12].[ConfigUnitPrice] AS [ConfigUnitPrice],
                           [Extent12].[ConfigBaseUnitPrice] AS [ConfigBaseUnitPrice],
                           [Extent12].[PriceListCode] AS [PriceListCode],
                           [Extent12].[BreakListCode] AS [BreakListCode],
                           [Extent12].[PricingQty] AS [PricingQty],
                           [Extent12].[LockPrice] AS [LockPrice],
                           [Extent12].[ListPrice] AS [ListPrice],
                           [Extent12].[DocListPrice] AS [DocListPrice],
                           [Extent12].[OrdBasedPrice] AS [OrdBasedPrice],
                           [Extent12].[DocOrdBasedPrice] AS [DocOrdBasedPrice],
                           [Extent12].[PriceGroupCode] AS [PriceGroupCode],
                           [Extent12].[OverridePriceList] AS [OverridePriceList],
                           [Extent12].[BaseRevisionNum] AS [BaseRevisionNum],
                           [Extent12].[PricingValue] AS [PricingValue],
                           [Extent12].[DisplaySeq] AS [DisplaySeq],
                           [Extent12].[KitParentLine] AS [KitParentLine],
                           [Extent12].[KitAllowUpdate] AS [KitAllowUpdate],
                           [Extent12].[KitShipComplete] AS [KitShipComplete],
                           [Extent12].[KitBackFlush] AS [KitBackFlush],
                           [Extent12].[KitPrintCompsPS] AS [KitPrintCompsPS],
                           [Extent12].[KitPrintCompsInv] AS [KitPrintCompsInv],
                           [Extent12].[KitPricing] AS [KitPricing],
                           [Extent12].[KitQtyPer] AS [KitQtyPer],
                           [Extent12].[SellingFactorDirection] AS [SellingFactorDirection1],
                           [Extent12].[RepRate1] AS [RepRate11],
                           [Extent12].[RepRate2] AS [RepRate21],
                           [Extent12].[RepRate3] AS [RepRate31],
                           [Extent12].[RepRate4] AS [RepRate41],
                           [Extent12].[RepRate5] AS [RepRate51],
                           [Extent12].[RepSplit1] AS [RepSplit11],
                           [Extent12].[RepSplit2] AS [RepSplit21],
                           [Extent12].[RepSplit3] AS [RepSplit31],
                           [Extent12].[RepSplit4] AS [RepSplit41],
                           [Extent12].[RepSplit5] AS [RepSplit51],
                           [Extent12].[DemandContractLine] AS [DemandContractLine],
                           [Extent12].[CreateNewJob] AS [CreateNewJob],
                           [Extent12].[DoNotShipBeforeDate] AS [DoNotShipBeforeDate1],
                           [Extent12].[GetDtls] AS [GetDtls],
                           [Extent12].[DoNotShipAfterDate] AS [DoNotShipAfterDate1],
                           [Extent12].[SchedJob] AS [SchedJob],
                           [Extent12].[RelJob] AS [RelJob],
                           [Extent12].[EnableCreateNewJob] AS [EnableCreateNewJob],
                           [Extent12].[EnableGetDtls] AS [EnableGetDtls],
                           [Extent12].[EnableSchedJob] AS [EnableSchedJob],
                           [Extent12].[EnableRelJob] AS [EnableRelJob],
                           [Extent12].[CounterSaleWarehouse] AS [CounterSaleWarehouse],
                           [Extent12].[CounterSaleBinNum] AS [CounterSaleBinNum],
                           [Extent12].[CounterSaleLotNum] AS [CounterSaleLotNum],
                           [Extent12].[CounterSaleDimCode] AS [CounterSaleDimCode],
                           [Extent12].[DemandDtlRejected] AS [DemandDtlRejected],
                           [Extent12].[KitFlag] AS [KitFlag],
                           [Extent12].[KitsLoaded] AS [KitsLoaded],
                           [Extent12].[DemandContractNum] AS [DemandContractNum1],
                           [Extent12].[DemandHeadSeq] AS [DemandHeadSeq1],
                           [Extent12].[DemandDtlSeq] AS [DemandDtlSeq],
                           [Extent12].[ChangedBy] AS [ChangedBy1],
                           [Extent12].[ChangeDate] AS [ChangeDate1],
                           [Extent12].[ChangeTime] AS [ChangeTime1],
                           [Extent12].[ReverseCharge] AS [ReverseCharge],
                           [Extent12].[TotalReleases] AS [TotalReleases1],
                           [Extent12].[Rpt1UnitPrice] AS [Rpt1UnitPrice],
                           [Extent12].[Rpt2UnitPrice] AS [Rpt2UnitPrice],
                           [Extent12].[Rpt3UnitPrice] AS [Rpt3UnitPrice],
                           [Extent12].[Rpt1Discount] AS [Rpt1Discount],
                           [Extent12].[Rpt2Discount] AS [Rpt2Discount],
                           [Extent12].[Rpt3Discount] AS [Rpt3Discount],
                           [Extent12].[Rpt1AdvanceBillBal] AS [Rpt1AdvanceBillBal],
                           [Extent12].[Rpt2AdvanceBillBal] AS [Rpt2AdvanceBillBal],
                           [Extent12].[Rpt3AdvanceBillBal] AS [Rpt3AdvanceBillBal],
                           [Extent12].[Rpt1ListPrice] AS [Rpt1ListPrice],
                           [Extent12].[Rpt2ListPrice] AS [Rpt2ListPrice],
                           [Extent12].[Rpt3ListPrice] AS [Rpt3ListPrice],
                           [Extent12].[Rpt1OrdBasedPrice] AS [Rpt1OrdBasedPrice],
                           [Extent12].[Rpt2OrdBasedPrice] AS [Rpt2OrdBasedPrice],
                           [Extent12].[Rpt3OrdBasedPrice] AS [Rpt3OrdBasedPrice],
                           [Extent12].[ExtPriceDtl] AS [ExtPriceDtl],
                           [Extent12].[DocExtPriceDtl] AS [DocExtPriceDtl],
                           [Extent12].[Rpt1ExtPriceDtl] AS [Rpt1ExtPriceDtl],
                           [Extent12].[Rpt2ExtPriceDtl] AS [Rpt2ExtPriceDtl],
                           [Extent12].[Rpt3ExtPriceDtl] AS [Rpt3ExtPriceDtl],
                           [Extent12].[LineStatus] AS [LineStatus],
                           [Extent12].[InUnitPrice] AS [InUnitPrice],
                           [Extent12].[DocInUnitPrice] AS [DocInUnitPrice],
                           [Extent12].[InDiscount] AS [InDiscount],
                           [Extent12].[DocInDiscount] AS [DocInDiscount],
                           [Extent12].[InListPrice] AS [InListPrice],
                           [Extent12].[DocInListPrice] AS [DocInListPrice],
                           [Extent12].[InOrdBasedPrice] AS [InOrdBasedPrice],
                           [Extent12].[DocInOrdBasedPrice] AS [DocInOrdBasedPrice],
                           [Extent12].[Rpt1InUnitPrice] AS [Rpt1InUnitPrice],
                           [Extent12].[Rpt2InUnitPrice] AS [Rpt2InUnitPrice],
                           [Extent12].[Rpt3InUnitPrice] AS [Rpt3InUnitPrice],
                           [Extent12].[Rpt1InDiscount] AS [Rpt1InDiscount],
                           [Extent12].[Rpt2InDiscount] AS [Rpt2InDiscount],
                           [Extent12].[Rpt3InDiscount] AS [Rpt3InDiscount],
                           [Extent12].[Rpt1InListPrice] AS [Rpt1InListPrice],
                           [Extent12].[Rpt2InListPrice] AS [Rpt2InListPrice],
                           [Extent12].[Rpt3InListPrice] AS [Rpt3InListPrice],
                           [Extent12].[Rpt1InOrdBasedPrice] AS [Rpt1InOrdBasedPrice],
                           [Extent12].[Rpt2InOrdBasedPrice] AS [Rpt2InOrdBasedPrice],
                           [Extent12].[Rpt3InOrdBasedPrice] AS [Rpt3InOrdBasedPrice],
                           [Extent12].[InExtPriceDtl] AS [InExtPriceDtl],
                           [Extent12].[DocInExtPriceDtl] AS [DocInExtPriceDtl],
                           [Extent12].[Rpt1InExtPriceDtl] AS [Rpt1InExtPriceDtl],
                           [Extent12].[Rpt2InExtPriceDtl] AS [Rpt2InExtPriceDtl],
                           [Extent12].[Rpt3InExtPriceDtl] AS [Rpt3InExtPriceDtl],
                           [Extent12].[OldOurOpenQty] AS [OldOurOpenQty],
                           [Extent12].[OldSellingOpenQty] AS [OldSellingOpenQty],
                           [Extent12].[OldOpenValue] AS [OldOpenValue],
                           [Extent12].[OldProdCode] AS [OldProdCode],
                           [Extent12].[PrevSellQty] AS [PrevSellQty],
                           [Extent12].[PrevPartNum] AS [PrevPartNum],
                           [Extent12].[PrevXPartNum] AS [PrevXPartNum],
                           [Extent12].[KitCompOrigSeq] AS [KitCompOrigSeq],
                           [Extent12].[KitCompOrigPart] AS [KitCompOrigPart],
                           [Extent12].[SmartStringProcessed] AS [SmartStringProcessed],
                           [Extent12].[SmartString] AS [SmartString],
                           [Extent12].[RenewalNbr] AS [RenewalNbr],
                           [Extent12].[DiscBreakListCode] AS [DiscBreakListCode],
                           [Extent12].[DiscListPrice] AS [DiscListPrice],
                           [Extent12].[LockDisc] AS [LockDisc],
                           [Extent12].[OverrideDiscPriceList] AS [OverrideDiscPriceList],
                           [Extent12].[GroupSeq] AS [GroupSeq],
                           [Extent12].[ECCOrderNum] AS [ECCOrderNum1],
                           [Extent12].[ECCOrderLine] AS [ECCOrderLine],
                           [Extent12].[DupOnJobCrt] AS [DupOnJobCrt1],
                           [Extent12].[UndersPct] AS [UndersPct1],
                           [Extent12].[Overs] AS [Overs],
                           [Extent12].[Unders] AS [Unders],
                           [Extent12].[OversUnitPrice] AS [OversUnitPrice],
                           [Extent12].[PlanUserID] AS [PlanUserID],
                           [Extent12].[PlanGUID] AS [PlanGUID],
                           [Extent12].[MOMsourceType] AS [MOMsourceType],
                           [Extent12].[MOMsourceEst] AS [MOMsourceEst],
                           [Extent12].[DefaultOversPricing] AS [DefaultOversPricing1],
                           [Extent12].[ECCPlant] AS [ECCPlant],
                           [Extent12].[ECCQuoteNum] AS [ECCQuoteNum],
                           [Extent12].[ECCQuoteLine] AS [ECCQuoteLine],
                           [Extent12].[SysRevID] AS [SysRevID1],
                           [Extent12].[MfgJobType] AS [MfgJobType],
                           [Extent12].[ProFormaInvComment] AS [ProFormaInvComment1],
                           [Extent12].[CreateJob] AS [CreateJob],
                           [Extent12].[ContractID] AS [ContractID],
                           [Extent12].[LinkToContract] AS [LinkToContract1],
                           [Extent12].[DocInAdvanceBillBal] AS [DocInAdvanceBillBal],
                           [Extent12].[InAdvanceBillBal] AS [InAdvanceBillBal],
                           [Extent12].[Rpt1InAdvanceBillBal] AS [Rpt1InAdvanceBillBal],
                           [Extent12].[Rpt2InAdvanceBillBal] AS [Rpt2InAdvanceBillBal],
                           [Extent12].[Rpt3InAdvanceBillBal] AS [Rpt3InAdvanceBillBal],
                           [Extent12].[PCLinkRemoved] AS [PCLinkRemoved],
                           [Extent12].[CommodityCode] AS [CommodityCode1],
                           [Extent12].[MSRP] AS [MSRP],
                           [Extent12].[DocMSRP] AS [DocMSRP],
                           [Extent12].[Rpt1MSRP] AS [Rpt1MSRP],
                           [Extent12].[Rpt2MSRP] AS [Rpt2MSRP],
                           [Extent12].[Rpt3MSRP] AS [Rpt3MSRP],
                           [Extent12].[EndCustomerPrice] AS [EndCustomerPrice],
                           [Extent12].[DocEndCustomerPrice] AS [DocEndCustomerPrice],
                           [Extent12].[Rpt1EndCustomerPrice] AS [Rpt1EndCustomerPrice],
                           [Extent12].[Rpt2EndCustomerPrice] AS [Rpt2EndCustomerPrice],
                           [Extent12].[Rpt3EndCustomerPrice] AS [Rpt3EndCustomerPrice],
                           [Extent12].[PromotionalPrice] AS [PromotionalPrice],
                           [Extent12].[DocPromotionalPrice] AS [DocPromotionalPrice],
                           [Extent12].[Rpt1PromotionalPrice] AS [Rpt1PromotionalPrice],
                           [Extent12].[Rpt2PromotionalPrice] AS [Rpt2PromotionalPrice],
                           [Extent12].[Rpt3PromotionalPrice] AS [Rpt3PromotionalPrice],
                           [Extent12].[OrderLineStatusCode] AS [OrderLineStatusCode],
                           [Extent12].[AttributeSetID] AS [AttributeSetID],
                           [Extent12].[KBConfigProdID] AS [KBConfigProdID],
                           [Extent12].[KBOriginalConfigProdID] AS [KBOriginalConfigProdID]
                    FROM [Erp].[OrderDtl_UD] AS [Extent11]
                        INNER JOIN [Erp].[OrderDtl] AS [Extent12]
                            ON [Extent11].[ForeignSysRowID] = [Extent12].[SysRowID]
                ) AS [Join9]
                    ON [Extent10].[OrderNum] = [Join9].[OrderNum1]
                INNER JOIN
                (
                    SELECT [Extent14].[Company] AS [Company2],
                           [Extent14].[PartNum] AS [PartNum2],
                           [Extent14].[PartDescription] AS [PartDescription]
                    FROM [Erp].[Part_UD] AS [Extent13]
                        INNER JOIN [Erp].[Part] AS [Extent14]
                            ON [Extent13].[ForeignSysRowID] = [Extent14].[SysRowID]
                ) AS [Join11]
                    ON ([Join9].[Company1] = [Join11].[Company2])
                       AND ([Join9].[PartNum1] = [Join11].[PartNum2])
                INNER JOIN
                (
                    SELECT [Extent15].[AccountCoordinator_c] AS [AccountCoordinator_c],
                           [Extent16].[Company] AS [Company3],
                           [Extent16].[CustNum] AS [CustNum2]
                    FROM [Erp].[Customer_UD] AS [Extent15]
                        INNER JOIN [Erp].[Customer] AS [Extent16]
                            ON [Extent15].[ForeignSysRowID] = [Extent16].[SysRowID]
                ) AS [Join13]
                    ON ([Extent10].[Company] = [Join13].[Company3])
                       AND ([Extent10].[CustNum] = [Join13].[CustNum2])
        ) AS [Join14]
            ON (1 = [Join14].[ReadyToCalc])
               AND (N'EPI-METHOD' = [Join14].[EntryPerson])
               AND ([Distinct1].[PartDescription] = [Join14].[PartDescription])
               AND ([Distinct1].[AccountCoordinator_c] = [Join14].[AccountCoordinator_c])
) AS [Project2]
ORDER BY [Project2].[PartDescription] ASC,
         [Project2].[AccountCoordinator_c] ASC,
         [Project2].[C2] ASC;