/* Expense Processing Audit — by transaction date (DatawarehouseNCM) Fact: dbo.FactExpenseProcessingAudit BackOffice: frmExpProcAuditRpt / Crystal: ExpenseProcessingAuditRpt.rpt Pm-TransType = E (Expense Transaction Date) / RptType ERP */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @CorpCode varchar(15) = NULL; DECLARE @ParentRollup bit = 0; DECLARE @DomesticIntl varchar(1) = NULL; -- NULL = all; 'D' / 'I' DECLARE @PrimaryContact varchar(4) = NULL; -- NULL / '' = all DECLARE @TEFileNo varchar(14) = NULL; SELECT f.CorpCode, f.FormalName, f.ParentCompany, f.TEFileNo, f.TELastName, f.TEFirstName, f.EmpNumber, f.PrimaryContact, f.DivisionName, f.ReloPolicy, f.MoveType, f.DomesticIntl, f.DisplayType, f.AuthDate, f.Descriptor1, f.Descriptor2, f.Descriptor3, f.Descriptor4, f.Descriptor5, f.ExpDetailID, f.ExpenseSheetID, f.TransactionDate, f.SubmittedForPmt, f.SentToPayroll, f.DueDate, f.DocDate, f.AcctgConfirmedDate, f.Category, f.Item, f.OrigCategory, f.Amount, f.IncurredAmount, f.PaidAmount, f.Payee, f.VendorId, f.PaidTo, f.PaidBy, f.PaymentMethod, f.DocNumber, f.InvoiceNumber, f.DeniedExpense, f.TrackOnly, f.ExceptionLine, f.DenialReason, f.Comment, f.ServiceCode, f.ServiceType FROM dbo.FactExpenseProcessingAudit f WHERE f.TransactionDate BETWEEN @StartDate AND @EndDate AND ( (@ParentRollup = 0 AND (@CorpCode IS NULL OR @CorpCode = '' OR f.CorpCode = @CorpCode)) OR (@ParentRollup = 1 AND (@CorpCode IS NULL OR @CorpCode = '' OR f.ParentCompany = @CorpCode OR f.CorpCode = @CorpCode)) ) AND (@DomesticIntl IS NULL OR @DomesticIntl = '' OR f.DomesticIntl = @DomesticIntl) AND (@PrimaryContact IS NULL OR @PrimaryContact = '' OR f.PrimaryContact = @PrimaryContact) AND (@TEFileNo IS NULL OR @TEFileNo = '' OR f.TEFileNo = @TEFileNo) ORDER BY f.CorpCode, f.TELastName, f.TEFirstName, f.TEFileNo, f.TransactionDate, f.ExpDetailID;