/* Expense Processing / Information Audit — ERP detail (ReloAction) BackOffice: frmExpProcAuditRpt (lblReportType = ERP) Crystal: ExpenseProcessingAuditRpt.rpt Pm-TransType = E (Expense Transaction Date) TE universe = DISTINCT TEFileNo from vwTEExpenses in date range (form PopulateTable), then Crystal joins expense lines + tblTmpRptTEDescriptors (Initials). This sample returns expense lines directly from vwTEExpenses (raw descriptors). BO CleanDescriptors remapping via tblCorpREMDefaults is runtime-only and not applied here. Run on ReloAction. */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @CorpCode varchar(15) = NULL; -- NULL / '' = all DECLARE @ParentRollup bit = 0; DECLARE @DomesticIntl varchar(1) = NULL; -- NULL = all; 'D' / 'I' DECLARE @PrimaryContact varchar(4) = NULL; -- NULL / '' = all providers SELECT v.CorpCode, v.ParentCompany, v.TEFileNo, m.TELastName, m.TEFirstName, v.EmpNumber, v.PrimaryContact, v.DivisionName, v.ReloPolicy, v.MoveType, v.DomesticIntl, v.DisplayType, v.Descriptor1, v.Descriptor2, v.Descriptor3, v.Descriptor4, v.Descriptor5, v.ExpDetailID, v.ExpenseSheetID, v.TransactionDate, v.SubmittedForPmt, v.SentToPayroll, v.DueDate, v.DOCDATE, v.AcctgConfirmedDate, v.CategoryID, v.Category, v.ItemID, v.Item, v.OrigCategory, v.Amount, v.IncurredAmount, v.PaidAmount, v.Payee, v.VENDORID AS VendorId, v.PaidTo, v.PaidBy, v.PaymentMethod, v.DOCNUMBR AS DocNumber, v.InvoiceNumber, v.DeniedExpense, v.TrackOnly, v.ExceptionLine, v.ExceptionAppliesTo, v.DenialReason, CONVERT(varchar(max), v.Comment) AS Comment, v.ServiceCode, v.ServiceType FROM dbo.vwTEExpenses v INNER JOIN dbo.tblTEMain1 m ON v.TEFileNo = m.TEFileNo WHERE v.TransactionDate BETWEEN @StartDate AND @EndDate AND ( (@ParentRollup = 0 AND (@CorpCode IS NULL OR @CorpCode = '' OR v.CorpCode = @CorpCode)) OR (@ParentRollup = 1 AND (@CorpCode IS NULL OR @CorpCode = '' OR v.ParentCompany = @CorpCode OR v.CorpCode = @CorpCode)) ) AND (@DomesticIntl IS NULL OR @DomesticIntl = '' OR v.DomesticIntl = @DomesticIntl) AND (@PrimaryContact IS NULL OR @PrimaryContact = '' OR v.PrimaryContact = @PrimaryContact) ORDER BY v.CorpCode, m.TELastName, m.TEFirstName, v.TEFileNo, v.TransactionDate, v.ExpDetailID;