--01 Fee Transfer Open Detail.sql -- SE rewrite of BO Fee Transfer Open (FactFeeTransferOpen) -- View: udv_transaction_detail_34 DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; SELECT td.[Invoice Number] AS InvoiceNo, td.[Invoice Date] AS InvoiceDate, NULL AS 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 ORDER BY td.[Invoice Date], td.[Invoice Number];