/* Vendor Usage — Temporary Living Suppliers (transactional / ReloAction) BackOffice: frmRptVendorUsage (cboVendors index 5) Crystal: VendorUsage_TLV.rpt Date filter: tblTETempAccomHousingInfo.DateBooked. Pm-ServiceType: 0=Both, 1=Domestic, 2=International (form radios). */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @CorpCode varchar(15) = ''; DECLARE @ParentRollup bit = 0; DECLARE @SrvcProvider varchar(4) = ''; DECLARE @VendorParentID int = 0; DECLARE @ServiceType smallint = 0; -- 0=Both, 1=Domestic, 2=International SELECT 'TLV' AS UsageReportType, fs.TEFileNo, fs.CorpCode, fs.ParentCompany, fs.FormalName, fs.TELastName, fs.TEFirstName, fs.ServiceType, fs.SrvcProvider, fs.SrvcFirstName, fs.SrvcLastName, th.DateBooked AS OrderDate, vp.VendorParentID, vp.CompanyName, vp.CompanySubName, so.VendorID, fs.ServiceCode, so.TEServiceOrderID FROM dbo.tblTETempAccomHousingInfo th INNER JOIN dbo.tblTEServiceOrders so ON th.TEServiceOrderID = so.TEServiceOrderID INNER JOIN dbo.vwTEFullServiceList fs ON so.TEFileNo = fs.TEFileNo AND fs.ServiceCode IN ('TLV', 'TAD') AND fs.CancelDate IS NULL INNER JOIN dbo.tblVendors v ON so.VendorID = v.VendorID INNER JOIN dbo.tblVendorParent vp ON v.VendorParentID = vp.VendorParentID WHERE so.VendorID <> 0 AND th.DateBooked BETWEEN @StartDate AND @EndDate AND ( (@ParentRollup = 0 AND (@CorpCode = '' OR fs.CorpCode = @CorpCode)) OR (@ParentRollup = 1 AND (@CorpCode = '' OR fs.ParentCompany = @CorpCode OR fs.CorpCode = @CorpCode)) ) AND (@SrvcProvider = '' OR fs.SrvcProvider = @SrvcProvider) AND (@VendorParentID = 0 OR vp.VendorParentID = @VendorParentID) AND (@ServiceType = 0 OR fs.ServiceType = @ServiceType) ORDER BY vp.CompanyName, fs.CorpCode, th.DateBooked, fs.TEFileNo;