--02 Fee Transfer Open Totals.sql -- SE rewrite of BO Fee Transfer Open totals -- View: udv_transaction_detail_34 DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; SELECT COUNT(DISTINCT td.[Invoice Number]) AS InvoiceCount, SUM(CAST(0.00 AS DECIMAL(18, 2))) AS TotalOpenFeeAmount -- OpenFeeAmount — unable to find FROM se_reports.dbo.[udv_transaction_detail_34] td WHERE td.[Invoice Date] >= @StartDate AND td.[Invoice Date] <= @EndDate AND td.[Invoice Number] IS NOT NULL;