Index: DB_PROJ_PDW_Reporting.sqlproj
===================================================================
diff -u -re48384d64dd6dfce15c087b85ad4533d3e66edba -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- DB_PROJ_PDW_Reporting.sqlproj	(.../DB_PROJ_PDW_Reporting.sqlproj)	(revision e48384d64dd6dfce15c087b85ad4533d3e66edba)
+++ DB_PROJ_PDW_Reporting.sqlproj	(.../DB_PROJ_PDW_Reporting.sqlproj)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -355,80 +355,83 @@
     <Build Include="dbo\Stored Procedures\spSetDateSwitches.sql" />
     <Build Include="dbo\Tables\MissingPartsConversion_1.sql" />
     <Build Include="dbo\Tables\factGlsInvoiceLineCharges_1.sql" />
-    <Build Include="dbo\Views\vwMonthlyDateRange_1.sql" />
-    <Build Include="Logistics\Views\UpsInvoiceLineCharges_1.sql" />
-    <Build Include="Logistics\Views\Gls Invoice Line Charges_1.sql" />
-    <Build Include="Logistics\Views\UpsInvoiceDate_1.sql" />
-    <Build Include="Logistics\Views\UpsSenderAddress_1.sql" />
-    <Build Include="Logistics\Views\UpsReceiverAddress_1.sql" />
-    <Build Include="Logistics\Views\UpsMisc_1.sql" />
-    <Build Include="Logistics\Views\Item_1.sql" />
-    <Build Include="Logistics\Views\UpsPublishedRates_1.sql" />
-    <Build Include="Logistics\Views\Discount_1.sql" />
-    <Build Include="Logistics\Views\DateShipped_1.sql" />
-    <Build Include="Logistics\Views\UpsAccount_1.sql" />
-    <Build Include="Logistics\Views\Dealer_1.sql" />
     <Build Include="dbo\Functions\usf_tv_tariffBody_1.sql" />
     <Build Include="dbo\Functions\usf_tv_ProformaInvoiceLevelTariffBody_1.sql" />
     <Build Include="dbo\Functions\fnRetrieveItemsFromCriteriaXml_OLD_20220824_1.sql" />
     <Build Include="dbo\Functions\fnRetrieveItemsFromCriteriaXml_1.sql" />
     <Build Include="ReportSubscriptions\Stored Procedures\BackorderReportByValueSummaryRunJob_1.sql" />
     <Build Include="ReportSubscriptions\Stored Procedures\BackorderReportByValueRunJob_1.sql" />
-    <Build Include="dbo\Stored Procedures\spWarehouseCodingReview_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerSubCommodityList_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerRolling36Dynamic_Old_20240807_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerRolling36Dynamic_Old_20210225_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerMTD_Old_20240807_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerMTD_Old_20210225_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerItemStatusSummary_Old_20240807_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerInventorySummary_Old_20240807_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandManagerCommodityList_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerSubCommodityList_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerRolling36Dynamic_Old_20210223_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerRolling36Dynamic_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerMTD_Old_20210223_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerMTD_1.sql" />
-    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerItemStatusSummary_1.sql" />
-    <Build Include="dbo\Stored Procedures\spTotalBackordersVersusInDoorReceivingSummary_20210727_1.sql" />
-    <Build Include="dbo\Stored Procedures\spTotalBackordersVersusInDoorReceivingDetail_20210727_1.sql" />
-    <Build Include="dbo\Stored Procedures\spSalesSourceCodeAnalysis_Detail_1.sql" />
-    <Build Include="dbo\Stored Procedures\spSalesSourceCodeAnalysis_DealerVendor_1.sql" />
-    <Build Include="dbo\Stored Procedures\spSalesPurchaseHistoryMegaDealerByPick_1.sql" />
-    <Build Include="dbo\Stored Procedures\spSalesOrderSourceDetail_1.sql" />
-    <Build Include="dbo\Stored Procedures\spSaDownload_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReturnedMerchandiseByVendor_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportSalesPurchaseHistoryForCumulativePrograms_OLD_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportSalesPurchaseHistoryForCumulativePrograms_NEW_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportSalesPurchaseHistoryForCumulativePrograms_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportSalesByVendorsParameters_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportSalesByVendor_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportDropShip_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportDealerPicks_Summary_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportDealerPickPercentMismatch_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportDealerPickLockInProgramOverlap_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReportDealerPickLevelPickOverlap_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_Summary_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_ByPick_20240923_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_ByPick_1.sql" />
-    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_ByBrand_1.sql" />
-    <Build Include="dbo\Stored Procedures\spRefreshPermissions_1.sql" />
-    <Build Include="dbo\Stored Procedures\spRefreshFlintfoxTradeAgreements_1.sql" />
-    <Build Include="dbo\Stored Procedures\spRefreshFlintfoxDealerPickPromo_NotNeeded_1.sql" />
-    <Build Include="dbo\Stored Procedures\spRefreshDealerPickPromo_1.sql" />
-    <Build Include="dbo\Stored Procedures\spRebuildIndexes_1.sql" />
-    <Build Include="dbo\Stored Procedures\spPurchaseHistoryMacroReport_1.sql" />
-    <Build Include="dbo\Stored Procedures\spPurchaseHistory_24_Months_1.sql" />
-    <Build Include="dbo\Stored Procedures\spLegalItemRecallSalesDetails_1.sql" />
-    <Build Include="dbo\Stored Procedures\spDealerPurchaseHistoryByXML_1.sql" />
-    <Build Include="dbo\Stored Procedures\spDealerPickSavings_1.sql" />
-    <Build Include="dbo\Stored Procedures\spCorporatePerformanceByVendor_20200911_1.sql" />
-    <Build Include="dbo\Stored Procedures\spCorporatePerformance_OLD_1.sql" />
-    <Build Include="dbo\Stored Procedures\spAcctRetailTireSales_1.sql" />
     <Build Include="Security\PDW_Reporting_Read_Only.sql" />
     <Build Include="Security\ReportingReadOnly.sql" />
     <Build Include="Security\dbprod02_user.sql" />
     <Build Include="Security\Logistics.sql" />
     <Build Include="Security\ds_ldw_user.sql" />
+    <Build Include="dbo\Views\vwMonthlyDateRange.sql" />
+    <Build Include="dbo\Views\vwSHOW_CODES.sql" />
+    <Build Include="dbo\Views\vwSHOW_CODES_PRG.sql" />
+    <Build Include="dbo\Views\vwSpecialPricePart.sql" />
+    <Build Include="DrpCube\Views\vwFactShippedOrders.sql" />
+    <Build Include="Logistics\Views\DateShipped.sql" />
+    <Build Include="Logistics\Views\Dealer.sql" />
+    <Build Include="Logistics\Views\Discount.sql" />
+    <Build Include="Logistics\Views\Gls Invoice Line Charges.sql" />
+    <Build Include="Logistics\Views\Item.sql" />
+    <Build Include="Logistics\Views\Package.sql" />
+    <Build Include="Logistics\Views\PackageDetail.sql" />
+    <Build Include="Logistics\Views\ShippedOrders.sql" />
+    <Build Include="Logistics\Views\SpeeDee Invoice Line Charges.sql" />
+    <Build Include="Logistics\Views\UpsAccount.sql" />
+    <Build Include="Logistics\Views\UpsInvoiceDate.sql" />
+    <Build Include="Logistics\Views\UpsInvoiceLineCharges.sql" />
+    <Build Include="Logistics\Views\UpsInvoiceLineCharges_2020_11_19.sql" />
+    <Build Include="Logistics\Views\UpsMisc.sql" />
+    <Build Include="Logistics\Views\UpsPublishedRates.sql" />
+    <Build Include="Logistics\Views\UpsReceiverAddress.sql" />
+    <Build Include="Logistics\Views\UpsSenderAddress.sql" />
+    <Build Include="SalesCube\Views\vwFactDealerReturnLine.sql" />
+    <Build Include="SalesCube\Views\vwFactInventory.sql" />
+    <Build Include="dbo\Stored Procedures\spAcctRetailTireSales.sql" />
+    <Build Include="dbo\Stored Procedures\spCorporatePerformance_OLD.sql" />
+    <Build Include="dbo\Stored Procedures\spCorporatePerformanceByVendor_20200911.sql" />
+    <Build Include="dbo\Stored Procedures\spDealerPickSavings.sql" />
+    <Build Include="dbo\Stored Procedures\spDealerPurchaseHistoryByXML.sql" />
+    <Build Include="dbo\Stored Procedures\spLegalItemRecallSalesDetails.sql" />
+    <Build Include="dbo\Stored Procedures\spPurchaseHistory_24_Months.sql" />
+    <Build Include="dbo\Stored Procedures\spPurchaseHistoryMacroReport.sql" />
+    <Build Include="dbo\Stored Procedures\spRebuildIndexes.sql" />
+    <Build Include="dbo\Stored Procedures\spRefreshDealerPickPromo.sql" />
+    <Build Include="dbo\Stored Procedures\spRefreshFlintfoxDealerPickPromo_NotNeeded.sql" />
+    <Build Include="dbo\Stored Procedures\spRefreshFlintfoxTradeAgreements.sql" />
+    <Build Include="dbo\Stored Procedures\spRefreshPermissions.sql" />
+    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_ByBrand.sql" />
+    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_ByPick.sql" />
+    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_ByPick_20240923.sql" />
+    <Build Include="dbo\Stored Procedures\spReport_Sales_PurchaseHistory_ByMegaDealer_Summary.sql" />
+    <Build Include="dbo\Stored Procedures\spReportDealerPickLevelPickOverlap.sql" />
+    <Build Include="dbo\Stored Procedures\spReportDealerPickLockInProgramOverlap.sql" />
+    <Build Include="dbo\Stored Procedures\spReportDealerPickPercentMismatch.sql" />
+    <Build Include="dbo\Stored Procedures\spReportDealerPicks_Summary.sql" />
+    <Build Include="dbo\Stored Procedures\spReportDropShip.sql" />
+    <Build Include="dbo\Stored Procedures\spReportSalesByVendor.sql" />
+    <Build Include="dbo\Stored Procedures\spReportSalesByVendorsParameters.sql" />
+    <Build Include="dbo\Stored Procedures\spReportSalesPurchaseHistoryForCumulativePrograms.sql" />
+    <Build Include="dbo\Stored Procedures\spReportSalesPurchaseHistoryForCumulativePrograms_NEW.sql" />
+    <Build Include="dbo\Stored Procedures\spReportSalesPurchaseHistoryForCumulativePrograms_OLD.sql" />
+    <Build Include="dbo\Stored Procedures\spReturnedMerchandiseByVendor.sql" />
+    <Build Include="dbo\Stored Procedures\spSaDownload.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerRolling36Dynamic.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerRolling36Dynamic_Old_20210223.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandBuyerSubCommodityList.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerCommodityList.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerInventorySummary_Old_20240807.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerItemStatusSummary_Old_20240807.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerMTD_Old_20210225.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerMTD_Old_20240807.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerRolling36Dynamic_Old_20210225.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerRolling36Dynamic_Old_20240807.sql" />
+    <Build Include="dbo\Stored Procedures\spVendorBrandManagerSubCommodityList.sql" />
+    <Build Include="dbo\Stored Procedures\spWarehouseCodingReview.sql" />
+    <Build Include="Security\dlongstaff.sql" />
   </ItemGroup>
   <ItemGroup>
     <ProjectReference Include="..\DB_PROJ_Master\DB_PROJ_DWH_MASTER.sqlproj">
Index: DrpCube/Views/vwFactShippedOrders.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- DrpCube/Views/vwFactShippedOrders.sql	(.../vwFactShippedOrders.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ DrpCube/Views/vwFactShippedOrders.sql	(.../vwFactShippedOrders.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -10,7 +10,7 @@
 	, '20' AS [Warehouse Code]
 	--, '' AS [Invoice Nunber]
 	, ex.QtyShipped
-	FROM PDW_Reporting.dbo.ExSales ex
+	FROM dbo.ExSales ex
 	JOIN dbo.dimDate dte
 	ON ex.ShipDateID = dte.dateid
 	JOIN dbo.dimItemHistory ih
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `DrpCube/Views/vwFactShippedOrders_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/DateShipped_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/Dealer_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/Discount_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/Gls Invoice Line Charges_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/Item_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: Logistics/Views/Package.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- Logistics/Views/Package.sql	(.../Package.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ Logistics/Views/Package.sql	(.../Package.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -50,7 +50,7 @@
 	, p.DropshipFeePackage
 	--SELECT COUNT(*)
 	FROM dbo.factPackage p
-	JOIN PDW_Staging.HighJump.t_carrier_h c
+	JOIN [$(DB_PROJ_PDW_STAGING)].HighJump.t_carrier_h c
 	ON p.CarrierCode = c.scac_code
 	LEFT JOIN dbo.dimSalesShipToAddress sa
 	ON p.SalesShippingAddressID = sa.SalesShipToAddressID
Index: Logistics/Views/PackageDetail.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- Logistics/Views/PackageDetail.sql	(.../PackageDetail.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ Logistics/Views/PackageDetail.sql	(.../PackageDetail.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -33,8 +33,8 @@
 		END as [Order Type]
 	, ROUND(pd.OrderUnitCost * pd.QtyShipped, 2, 1) AS CostExt
 	, ROUND(pd.OrderDealerPrice * pd.QtyShipped, 2, 1) AS DealerPriceExt
-	FROM PDW_Reporting.dbo.factPackageDetail pd
-	JOIN PDW_Staging.HighJump.t_carrier_h c
+	FROM dbo.factPackageDetail pd
+	JOIN [$(DB_PROJ_PDW_STAGING)].HighJump.t_carrier_h c
 	ON pd.CarrierCode = c.scac_code
 	LEFT JOIN dbo.dimSalesShipToAddress sa
 	ON pd.SalesShippingAddressID = sa.SalesShipToAddressID
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/PackageDetail_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/Package_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: Logistics/Views/ShippedOrders.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- Logistics/Views/ShippedOrders.sql	(.../ShippedOrders.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ Logistics/Views/ShippedOrders.sql	(.../ShippedOrders.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -50,7 +50,7 @@
 	, so.ItemID
 	, CASE WHEN so.ItemID = 1 THEN 'No' ELSE 'Yes' END AS [Single Item Order]
 	FROM dbo.factShippedOrders so
-	LEFT JOIN PDW_Staging.HighJump.t_carrier_h c
+	LEFT JOIN [$(DB_PROJ_PDW_STAGING)].HighJump.t_carrier_h c
 	ON so.CarrierCode = c.scac_code
 	LEFT JOIN dbo.dimSalesShipToAddress sa
 	ON so.SalesShippingAddressID = sa.SalesShipToAddressID
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/ShippedOrders_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: Logistics/Views/SpeeDee Invoice Line Charges.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- Logistics/Views/SpeeDee Invoice Line Charges.sql	(.../SpeeDee Invoice Line Charges.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ Logistics/Views/SpeeDee Invoice Line Charges.sql	(.../SpeeDee Invoice Line Charges.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -39,6 +39,6 @@
 	   END as [LeMans Order Type]
 	, ItemID AS LeMansItemID
 	, CASE WHEN SingleItemPackage = 1 THEN 'Yes' ELSE 'No' END AS [Single Item Package]
-	FROM PDW_Reporting.dbo.factSpeeDeeInvoiceLineCharges ilc
-	LEFT JOIN PDW_Reporting.dbo.dimMisc m
+	FROM dbo.factSpeeDeeInvoiceLineCharges ilc
+	LEFT JOIN dbo.dimMisc m
 	ON ilc.LeMansMiscID = m.MiscID
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/SpeeDee Invoice Line Charges_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsAccount_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsInvoiceDate_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsInvoiceLineCharges_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: Logistics/Views/UpsInvoiceLineCharges_2020_11_19.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- Logistics/Views/UpsInvoiceLineCharges_2020_11_19.sql	(.../UpsInvoiceLineCharges_2020_11_19.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ Logistics/Views/UpsInvoiceLineCharges_2020_11_19.sql	(.../UpsInvoiceLineCharges_2020_11_19.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -5,8 +5,8 @@
 -- for testing
 --, m.ChargeDescription, ilc.UpsZone, ilc.BilledWeight
 , ilc.UpsAccountID
-, ilc.UpsReceiverAddressID
-, ilc.UpsSenderAddressID
+, ilc.ReceiverAddressID
+, ilc.SenderAddressID
 , ilc.UpsInvoiceDateID
 , ilc.UpsInvoiceNumber AS [Ups Invoice Nbr]
 , ilc.UpsTrackingNumber AS [Ups Tracking Nbr]
@@ -78,9 +78,9 @@
 JOIN dbo.dimUpsMisc m
 ON ilc.UpsMiscID = m.UpsMiscID
 JOIN dbo.dimUpsReceiverAddress ra
-ON ilc.UpsReceiverAddressID = ra.UpsReceiverAddressID
+ON ilc.ReceiverAddressID = ra.UpsReceiverAddressID
 JOIN dbo.dimUpsSenderAddress sa
-ON ilc.UpsSenderAddressID = sa.UpsSenderAddressID
+ON ilc.SenderAddressID = sa.UpsSenderAddressID
 JOIN dbo.dimUpsAccount acct
 ON ilc.UpsAccountID = acct.UpsAccountID
 LEFT JOIN dbo.dimMisc misc
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsInvoiceLineCharges_2020_11_19_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsMisc_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsPublishedRates_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsReceiverAddress_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `Logistics/Views/UpsSenderAddress_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `SalesCube/Views/vwDimDealerPickDetails_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `SalesCube/Views/vwFactDealerPicks_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: SalesCube/Views/vwFactDealerReturnLine.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- SalesCube/Views/vwFactDealerReturnLine.sql	(.../vwFactDealerReturnLine.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ SalesCube/Views/vwFactDealerReturnLine.sql	(.../vwFactDealerReturnLine.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -33,7 +33,7 @@
 	, dr.ReturnDealerPrice * dr.AuthorizedQty AS ReturnDealerPrice
 	, 0 AS [Pct Dealer Resp]
 	, dr.ReturnInvoiceNumber AS [Credit Memo Number]
-	FROM PDW_Reporting.dbo.factDealerReturnLine dr
-	JOIN PDW_Reporting.dbo.dimDate dte
+	FROM dbo.factDealerReturnLine dr
+	JOIN dbo.dimDate dte
 	ON dr.FinalDateID = dte.DATEID
 
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `SalesCube/Views/vwFactDealerReturnLine_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: SalesCube/Views/vwFactInventory.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- SalesCube/Views/vwFactInventory.sql	(.../vwFactInventory.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ SalesCube/Views/vwFactInventory.sql	(.../vwFactInventory.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -25,16 +25,16 @@
          THEN 'Yes'
 		 ELSE 'No'
    END AS [On Hand Cost Defaulted]
-FROM PDW_Inventory.dbo.factInventoryMonthly inv
-JOIN PDW_Staging.ItemDim.BuyStatus bs
+FROM[$(DB_PROJ_PDW_Inventory)].dbo.factInventoryMonthly inv
+JOIN [$(DB_PROJ_PDW_STAGING)].ItemDim.BuyStatus bs
 ON inv.BuyStatusCode = bs.BuyStatusCode
-JOIN PDW_Staging.ItemDim.WarehouseStatus ws
+JOIN [$(DB_PROJ_PDW_STAGING)].ItemDim.WarehouseStatus ws
 ON inv.WarehouseStatusCode = ws.WarehouseStatusCode
-JOIN PDW_Staging.ItemDim.Warehouse w
+JOIN [$(DB_PROJ_PDW_STAGING)].ItemDim.Warehouse w
 ON inv.WarehouseCode = w.WarehouseCode
-JOIN PDW_Reporting.dbo.dimItemHistory ih
+JOIN dbo.dimItemHistory ih
 ON inv.ItemHistoryID = ih.ItemHistoryID
-JOIN PDW_Reporting.dbo.dimItem itm
+JOIN dbo.dimItem itm
 ON inv.ItemID = itm.ItemID
 -- Only keep last 24 Months history
 WHERE inv.InventoryDateID >= (SELECT MIN(DATEID) FROM dimDate WHERE IsRolling36 = 1)
@@ -62,15 +62,15 @@
          THEN 'Yes'
 		 ELSE 'No'
    END AS [On Hand Cost Defaulted]
-FROM PDW_Reporting.dbo.factInventory inv
-JOIN PDW_Staging.ItemDim.BuyStatus bs
+FROM dbo.factInventory inv
+JOIN [$(DB_PROJ_PDW_STAGING)].ItemDim.BuyStatus bs
 ON inv.BuyStatusCode = bs.BuyStatusCode
-JOIN PDW_Staging.ItemDim.WarehouseStatus ws
+JOIN [$(DB_PROJ_PDW_STAGING)].ItemDim.WarehouseStatus ws
 ON inv.WarehouseStatusCode = ws.WarehouseStatusCode
-JOIN PDW_Staging.ItemDim.Warehouse w
+JOIN [$(DB_PROJ_PDW_STAGING)].ItemDim.Warehouse w
 ON inv.WarehouseCode = w.WarehouseCode
-JOIN PDW_Reporting.dbo.dimItemHistory ih
+JOIN dbo.dimItemHistory ih
 ON inv.ItemHistoryID = ih.ItemHistoryID
-JOIN PDW_Reporting.dbo.dimItem itm
+JOIN dbo.dimItem itm
 ON inv.ItemID = itm.ItemID
-CROSS JOIN (SELECT MIN(DATEID) AS InventoryDateID FROM PDW_Reporting.dbo.dimDate WHERE IsCurrentMonth = 1) inv_date
+CROSS JOIN (SELECT MIN(DATEID) AS InventoryDateID FROM dbo.dimDate WHERE IsCurrentMonth = 1) inv_date
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `SalesCube/Views/vwFactInventory_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `SalesCube/Views/vwShippedOrders_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: Security/PDW_Reporting_Read_Only.sql
===================================================================
diff -u -re48384d64dd6dfce15c087b85ad4533d3e66edba -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- Security/PDW_Reporting_Read_Only.sql	(.../PDW_Reporting_Read_Only.sql)	(revision e48384d64dd6dfce15c087b85ad4533d3e66edba)
+++ Security/PDW_Reporting_Read_Only.sql	(.../PDW_Reporting_Read_Only.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -1,3 +1,2 @@
 CREATE USER [PDW_Reporting_Read_Only] FOR LOGIN [PDW_Reporting_Read_Only];
---CREATE USER [PDW_Reporting_Read_Only] WITHOUT LOGIN;
 
Index: Security/dbprod02_user.sql
===================================================================
diff -u -re48384d64dd6dfce15c087b85ad4533d3e66edba -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- Security/dbprod02_user.sql	(.../dbprod02_user.sql)	(revision e48384d64dd6dfce15c087b85ad4533d3e66edba)
+++ Security/dbprod02_user.sql	(.../dbprod02_user.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -1,3 +1,2 @@
 CREATE USER [dbprod02_user] FOR LOGIN [dbprod02_user];
---CREATE USER [dbprod02_user] WITHOUT LOGIN;
 
Index: dbo/Functions/udfRemovePunctuation.sql
===================================================================
diff -u -re48384d64dd6dfce15c087b85ad4533d3e66edba -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- dbo/Functions/udfRemovePunctuation.sql	(.../udfRemovePunctuation.sql)	(revision e48384d64dd6dfce15c087b85ad4533d3e66edba)
+++ dbo/Functions/udfRemovePunctuation.sql	(.../udfRemovePunctuation.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -10,7 +10,7 @@
 
 END
 GO
---GRANT EXECUTE
---    ON OBJECT::[dbo].[udfRemovePunctuation] TO [PDW_Reporting_Read_Only]
---    AS [dbo];
+GRANT EXECUTE
+    ON OBJECT::[dbo].[udfRemovePunctuation] TO [PDW_Reporting_Read_Only]
+    AS [dbo];
 
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spAcctRetailTireSales_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spCorporatePerformanceByVendor_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spCorporatePerformanceByVendor_20200911_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spCorporatePerformance_OLD_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spCreateDatesForNextYear_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spDealerPickSavings_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spDealerPurchaseHistoryByXML_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spLegalItemRecallSalesDetails_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spPurchaseHistoryMacroReport_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spPurchaseHistory_24_Months_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spRebuildIndexes_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spRefreshDealerPickPromo_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spRefreshFlintfoxDealerPickPromo_NotNeeded_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spRefreshFlintfoxTradeAgreements_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spRefreshPermissions_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportDealerPickLevelPickOverlap_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportDealerPickLockInProgramOverlap_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportDealerPickPercentMismatch_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportDealerPicks_Summary_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportDropShip_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportSalesByVendor_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportSalesByVendorsParameters_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportSalesPurchaseHistoryForCumulativePrograms_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportSalesPurchaseHistoryForCumulativePrograms_NEW_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReportSalesPurchaseHistoryForCumulativePrograms_OLD_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReport_Sales_PurchaseHistory_ByMegaDealer_ByBrand_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReport_Sales_PurchaseHistory_ByMegaDealer_ByPick_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReport_Sales_PurchaseHistory_ByMegaDealer_ByPick_20240923_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReport_Sales_PurchaseHistory_ByMegaDealer_Summary_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spReturnedMerchandiseByVendor_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spSaDownload_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spSalesOrderSourceDetail_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spSalesPickSummary_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spSalesPurchaseHistoryMegaDealerByPick_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spSalesSourceCodeAnalysis_DealerVendor_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spSalesSourceCodeAnalysis_Detail_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spTotalBackordersVersusInDoorReceivingDetail_20210727_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spTotalBackordersVersusInDoorReceivingSummary_20210727_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandBuyerItemStatusSummary_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandBuyerMTD_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandBuyerMTD_Old_20210223_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandBuyerRolling36Dynamic_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandBuyerRolling36Dynamic_Old_20210223_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandBuyerSubCommodityList_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerCommodityList_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerInventorySummary_Old_20240807_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerItemStatusSummary_Old_20240807_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerMTD_Old_20210225_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerMTD_Old_20240807_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerRolling36Dynamic_Old_20210225_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerRolling36Dynamic_Old_20240807_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spVendorBrandManagerSubCommodityList_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Stored Procedures/spWarehouseCodingReview_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: dbo/Tables/factInventory.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- dbo/Tables/factInventory.sql	(.../factInventory.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ dbo/Tables/factInventory.sql	(.../factInventory.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -16,6 +16,8 @@
     [LastReceiptDate]     DATE            NOT NULL,
     [PoOnOrderQty]        INT             NULL,
     [PoOnOrderCost]       DECIMAL (11, 2) NULL,
+	[TransitQty]          INT             NULL,
+    [TransitCost]         DECIMAL (11, 2) NULL,
     CONSTRAINT [factInventory_PK_D365] PRIMARY KEY CLUSTERED ([InventoryID] ASC),
     CONSTRAINT [factInventory_UNIQ_D365] UNIQUE NONCLUSTERED ([ItemID] ASC, [WarehouseCode] ASC) WITH (FILLFACTOR = 90)
 );
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Views/vwMonthlyDateRange_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: dbo/Views/vwSHOW_CODES.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- dbo/Views/vwSHOW_CODES.sql	(.../vwSHOW_CODES.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ dbo/Views/vwSHOW_CODES.sql	(.../vwSHOW_CODES.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -10,6 +10,6 @@
 	, ShowEndDate AS showEndDate
 	, CONVERT(CHAR(10), DateAdded, 112) AS createDate
 	, CONVERT(CHAR(10), DateUpdated, 112) AS updateDate
-	FROM PDW_Staging.SalesOrderDim.OrderSource
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.OrderSource
 	WHERE OrderSourceType = 'SHOW'
 
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Views/vwSHOW_CODES_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: dbo/Views/vwSHOW_CODES_PRG.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- dbo/Views/vwSHOW_CODES_PRG.sql	(.../vwSHOW_CODES_PRG.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ dbo/Views/vwSHOW_CODES_PRG.sql	(.../vwSHOW_CODES_PRG.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -13,5 +13,5 @@
 	, ShowEndDate AS showEndDate
 	, CONVERT(CHAR(10), DateAdded, 112) AS createDate
 	, CONVERT(CHAR(10), DateUpdated, 112) AS updateDate
-	FROM PDW_Staging.SalesOrderDim.OrderSource
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.OrderSource
 	WHERE OrderSourceType IN ( 'SHOW', 'PROGRAM' )
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Views/vwSHOW_CODES_PRG_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: dbo/Views/vwSpecialPricePart.sql
===================================================================
diff -u -r641896f98bd6ca7db70bf5bedee6589bc28f1318 -rc1aa0dca2509ec23ad1ad5182f9efb7871e9b641
--- dbo/Views/vwSpecialPricePart.sql	(.../vwSpecialPricePart.sql)	(revision 641896f98bd6ca7db70bf5bedee6589bc28f1318)
+++ dbo/Views/vwSpecialPricePart.sql	(.../vwSpecialPricePart.sql)	(revision c1aa0dca2509ec23ad1ad5182f9efb7871e9b641)
@@ -17,15 +17,15 @@
 	, sp.Locked
 	, sp.Exclude
 	, sp.EntityType
-	FROM PDW_Staging.SalesOrderDim.SpecialPricing sp
-	JOIN PDW_Reporting.dbo.dimItem itm
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing sp
+	JOIN dbo.dimItem itm
 	ON sp.PrimaryVendorCode = itm.PrimaryVendorCode
 	AND itm.InCurrentErpSystem = 1
 	WHERE sp.EntityType = 'V'
 	AND sp.BrandCode IS NULL
 	AND NOT EXISTS (  -- Item Level Pricing overrides Vendor Pricing
 			SELECT *
-			FROM PDW_Staging.SalesOrderDim.SpecialPricing v1
+			FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing v1
 			WHERE sp.SpecialPricingCode = v1.SpecialPricingCode
 				AND v1.EntityType = 'I'
 				AND v1.ItemNumber = itm.ItemNumber
@@ -44,16 +44,16 @@
 	, sp.Locked
 	, sp.Exclude
 	, sp.EntityType
-	FROM PDW_Staging.SalesOrderDim.SpecialPricing sp
-	JOIN PDW_Reporting.dbo.dimItem itm
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing sp
+	JOIN dbo.dimItem itm
 	ON sp.PrimaryVendorCode = itm.PrimaryVendorCode
 	AND sp.BrandCode = itm.BrandCode
 	AND itm.InCurrentErpSystem = 1
 	WHERE sp.EntityType = 'V'
 	AND sp.BrandCode IS NOT NULL
 	AND NOT EXISTS (  -- Item Level Pricing overrides Vendor Pricing
 			SELECT *
-			FROM PDW_Staging.SalesOrderDim.SpecialPricing v1
+			FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing v1
 			WHERE sp.SpecialPricingCode = v1.SpecialPricingCode
 				AND v1.EntityType = 'I'
 				AND v1.ItemNumber = itm.ItemNumber
@@ -71,8 +71,8 @@
 	, sp.Locked
 	, sp.Exclude
 	, sp.EntityType
-	FROM PDW_Staging.SalesOrderDim.SpecialPricing sp
-	JOIN PDW_Reporting.dbo.dimItem itm
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing sp
+	JOIN dbo.dimItem itm
 	ON sp.ItemNumber = itm.ItemNumber
 	AND itm.InCurrentErpSystem = 1
 	WHERE sp.EntityType = 'I'
@@ -90,8 +90,8 @@
 	, sp.Locked
 	, sp.Exclude
 	, sp.EntityType
-	FROM PDW_Staging.SalesOrderDim.SpecialPricing sp
-	JOIN PDW_Reporting.dbo.dimItem itm
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing sp
+	JOIN dbo.dimItem itm
 	ON sp.SubCommodityCode = itm.SubCommodityCode
 	AND itm.InCurrentErpSystem = 1
 	WHERE sp.EntityType = 'C'
@@ -109,8 +109,8 @@
 	, sp.Locked
 	, sp.Exclude
 	, sp.EntityType
-	FROM PDW_Staging.SalesOrderDim.SpecialPricing sp
-	JOIN PDW_Reporting.dbo.dimItem itm
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing sp
+	JOIN dbo.dimItem itm
 	ON sp.SubCommodityCode = itm.SubCommodityCode
 	AND sp.PrimaryVendorCode = itm.PrimaryVendorCode
 	AND itm.InCurrentErpSystem = 1
@@ -129,8 +129,8 @@
 	, sp.Locked
 	, sp.Exclude
 	, sp.EntityType
-	FROM PDW_Staging.SalesOrderDim.SpecialPricing sp
-	JOIN PDW_Reporting.dbo.dimItem itm
+	FROM [$(DB_PROJ_PDW_STAGING)].SalesOrderDim.SpecialPricing sp
+	JOIN dbo.dimItem itm
 	ON sp.ProductCode = itm.ProductCode
 	AND itm.InCurrentErpSystem = 1
 	WHERE sp.EntityType = 'P'
Fisheye: Tag c1aa0dca2509ec23ad1ad5182f9efb7871e9b641 refers to a dead (removed) revision in file `dbo/Views/vwSpecialPricePart_1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?