--03 Expense Audit Fact Sample.sql -- SE sample / sanity check (replaces FactExpenseProcessingAudit sample) SELECT TOP 100 td.[Corp Code] AS CorpCode, td.[File #] AS TEFileNo, td.[Last Name] AS TELastName, td.[First Name] AS TEFirstName, td.[Transaction Date] AS TransactionDate, td.[Expense Category] AS Category, td.[Expense Item] AS Item, td.[Transaction Amount] AS Amount, td.[Paid Amount] AS PaidAmount, td.[Exception] AS ExceptionLine, CASE WHEN td.[Payment Type] = 'Client Already Paid' THEN 1 ELSE 0 END AS TrackOnly, td.[Payables PO Line Number] AS ExpDetailID, td.[Expense Report ID] AS ExpenseSheetID FROM se_reports.dbo.[udv_transaction_detail_34] td ORDER BY td.[Transaction Date] DESC, td.[Payables PO Line Number] DESC; SELECT COUNT(*) AS [RowCount], SUM(ISNULL(td.[Transaction Amount], 0)) AS Amount, SUM(ISNULL(td.[Paid Amount], 0)) AS PaidAmount, SUM(CASE WHEN td.[Payment Type] = 'Client Already Paid' THEN 1 ELSE 0 END) AS TrackOnlyLines FROM se_reports.dbo.[udv_transaction_detail_34] td; 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;