--03 Fee Transfer Paid Detail.sql -- SE rewrite of BO Fee Transfer Paid detail (FactFeeTransferPaid) -- View: udv_transaction_detail_34 -- Note: BO RowSource Paid/CM/CMHistory split is not in SEViews; Paid Amount used as Amount. DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @PaidInvoices TABLE (InvoiceNo varchar(50) PRIMARY KEY); INSERT INTO @PaidInvoices (InvoiceNo) SELECT DISTINCT CAST(td.[Invoice Number] AS varchar(50)) FROM se_reports.dbo.[udv_transaction_detail_34] td WHERE td.[Invoice Number] IS NOT NULL AND td.[Paid Amount] IS NOT NULL AND td.[Paid Amount] <> 0 AND td.[Transaction Date] >= @StartDate AND td.[Transaction Date] <= @EndDate; SELECT td.[Invoice Number] AS InvoiceNo, td.[Transaction Date] AS TrxDate, NULL AS CodeId, -- unable to find td.[Service] AS ServiceCode, -- description, not code td.[Paid Amount] AS Amount, CAST('Paid' AS varchar(20)) AS RowSource -- BO Paid/CM/CMHistory FROM se_reports.dbo.[udv_transaction_detail_34] td INNER JOIN @PaidInvoices p ON p.InvoiceNo = CAST(td.[Invoice Number] AS varchar(50)) ORDER BY td.[Invoice Number], td.[Transaction Date], td.[Service];