--03 Imprest Account Fact Sample.sql -- SE sample / sanity check (replaces FactImprestAccount sample) SELECT TOP 100 td.[Corp Code] AS CorpCode, td.[Org Name] AS FormalName, td.[File #] AS TEFileNo, td.[Last Name] AS TELastName, td.[First Name] AS TEFirstName, td.[Division] AS DivisionName, td.[Transaction Amount] AS Amount, td.[Transaction Date] AS TrxDate, td.[Service] AS ServiceCode, td.[Invoice Number] AS DocumentNo FROM se_reports.dbo.[udv_transaction_detail_34] td ORDER BY td.[Transaction Date] DESC; SELECT td.[Corp Code] AS CorpCode, COUNT(*) AS [RowCount], SUM(ISNULL(td.[Transaction Amount], 0)) AS Amount FROM se_reports.dbo.[udv_transaction_detail_34] td GROUP BY td.[Corp Code] ORDER BY Amount DESC; SELECT COUNT(*) AS [RowCount], SUM(ISNULL(td.[Transaction Amount], 0)) AS Amount FROM se_reports.dbo.[udv_transaction_detail_34] td; -- Posted balances sample — unable to find in SEViews SELECT CAST(NULL AS varchar(15)) AS CorpCode, CAST(NULL AS datetime) AS BalanceDate, CAST(NULL AS money) AS Balance WHERE 1 = 0;