% PassThrough SqlServer crm1 Adventure_Works_Cycle_MSCRM SSPI false Account AccountNumber View Profile Select * from FilteredAccount where (AccountID LIKE @Accountid) or (Name LIKE @name) or (AccountNumber LIKE @accountnumber) or (AccountCategoryCodeName LIKE @accountcategorycodename) or (TerritoryIDName LIKE @territoryidname) or (IndustryCodeName LIKE @industrycodename) or (OwnershipCodeName LIKE @ownershipcodename) or (Address1_city LIKE @Address1_city) or (EmailAddress1 LIKE @emailaddress1) or (WebsiteUrl LIKE @websiteurl) or (PrimaryContactIDName LIKE @primarycontactidname) or (Telephone1 LIKE @telephone1) Text true % % % % % % % % % % % % Account ID Account Name true Account Number true Modified By true Modified Date true Primary Contact true Shipping method true Address1: Name true Address1: City true Address1: Country true Fax true Main Phone true Email true Website true Category true Territory true Industry true Ownership true Description true Payment Terms true Select * from FilteredAccount where (AccountID LIKE @Accountid) and ((Name LIKE @name) OR (Name IS NULL)) and ((AccountNumber LIKE @accountnumber) OR (AccountNumber IS NULL)) and ((AccountCategoryCodeName LIKE @accountcategorycodename) OR (AccountCategoryCodeName IS NULL)) and ((TerritoryIDName LIKE @territoryidname) OR (TerritoryIDName IS NULL)) and ((IndustryCodeName LIKE @industrycodename) OR (IndustryCodeName IS NULL)) and ((OwnershipCodeName LIKE @ownershipcodename) OR (OwnershipCodeName IS NULL)) and ((Address1_city LIKE @Address1_city) OR (Address1_city IS NULL)) and ((EmailAddress1 LIKE @emailaddress1) OR (EmailAddress1 IS NULL)) and ((WebsiteUrl LIKE @websiteurl) OR (WebsiteUrl IS NULL)) and ((PrimaryContactIDName LIKE @primarycontactidname) OR (PrimaryContactIDName IS NULL)) and ((Telephone1 LIKE @telephone1) OR (Telephone1 IS NULL)) Text true % % % % % % % % % % % % Account ID Account Name true Account Number true Modified By true Modified Date true Primary Contact true Shipping method true Address1: Name true Address1: City true Address1: Country true Fax true Main Phone true Email true Website true Category true Territory true Industry true Ownership true Description true Payment Terms true Text SELECT AccountID FROM FilteredAccount ID Product ProductNumber View Profile Select * from FilteredProduct where (ProductID LIKE @productid) or (Name LIKE @name) or (SubjectIDName LIKE @subjectidname) or (ProductNumber LIKE @productnumber) Text true % % % % Product Id Product Name true Modified By true Modified Date true Subject true Product Type true Product Number true Unit Group true Quantity on hand true Default Unit true Default price list true List Price true Decimals supported true Standard cost true Current cost true Status true Status Reason true Select * from FilteredProduct where (ProductID LIKE @productid) and ((Name LIKE @name) OR ( Name IS NULL)) and ((SubjectIDName LIKE @subjectidname) OR ( SubjectIDName IS NULL)) and ((ProductNumber LIKE @productnumber) OR ( ProductNumber IS NULL)) Text true % % % % Product Id Product Name true Modified By true Modified Date true Subject true Product Type true Product Number true Unit Group true Quantity on hand true Default Unit true Default price list true List Price true Decimals supported true Standard cost true Current cost true Status true Status Reason true Text SELECT ProductID FROM FilteredProduct ID Lead View Profile Select * from FilteredLead where (LeadID LIKE @leadid) or (Subject LIKE @subject) or (FullName LIKE @fullname) or (CompanyName LIKE @companyname) or (EmailAddress1 LIKE @emailaddress1) or (StatusCodeName LIKE @statuscodename) or (TelePhone1 LIKE @telephone1) or (WebsiteUrl LIKE @websiteurl) Text true % % % % % % % % Lead Id Topic true Full Name true Modified By true Modified Date true First Name true Last Name true Salutation true Job Title true Company Name true Rating true Business Phone true E-mail true Web Site true Industry true Lead Source true Owner true Status Reason true Status true Preferred Contact method true Last date included in Campaign true Select * from FilteredLead where (LeadID LIKE @leadid) and ((Subject LIKE @subject) OR (Subject IS NULL)) and ((FullName LIKE @fullname) OR (FullName IS NULL)) and ((CompanyName LIKE @companyname) OR (CompanyName IS NULL)) and ((EmailAddress1 LIKE @emailaddress1) OR (EmailAddress1 IS NULL)) and ((StatusCodeName LIKE @statuscodename) OR (StatusCodeName IS NULL)) and ((TelePhone1 LIKE @telephone1) OR (TelePhone1 IS NULL)) and ((WebsiteUrl LIKE @websiteurl) OR (WebsiteUrl IS NULL)) Text true % % % % % % % % Lead Id Topic true Full Name true Modified By true Modified Date true First Name true Last Name true Salutation true Job Title true Company Name true Rating true Business Phone true E-mail true Web Site true Industry true Lead Source true Owner true Status Reason true Status true Preferred Contact method true Last date included in Campaign true Text SELECT LeadID FROM FilteredLead ID Opportunity View Profile Select * from FilteredOpportunity where (OpportunityID LIKE @opportunityid) or (Name LIKE @name) or (CustomerIDName LIKE @customeridname) or (EstimatedCloseDate LIKE @estimatedclosedate) or (Description LIKE @description) Text true % % % % % Opportunity Id Topic true Modified By true Modified Date true Owner Name true Potential Customer true Probability true Status true Status Reason true Actual Close Date true Description true Created On true Est. Close Date true Select * from FilteredOpportunity where (OpportunityID LIKE @opportunityid) and ((Name LIKE @name) OR (Name IS NULL)) and ((CustomerIDName LIKE @customeridname) OR (CustomerIDName IS NULL)) and ((EstimatedCloseDate LIKE @estimatedclosedate) OR (EstimatedCloseDate IS NULL)) and ((Description LIKE @description) OR (Description IS NULL)) Text true % % % % % Opportunity Id Topic true Modified By true Modified Date true Owner Name true Potential Customer true Probability true Status true Status Reason true Actual Close Date true Description true Created On true Est. Close Date true Text SELECT OpportunityID FROM FilteredOpportunity ID Campaign CodeName View Profile Select * from FilteredCampaign where (CampaignID LIKE @campaignid) or (Name LIKE @name) or (CodeName LIKE @codename) or (Description LIKE @description) Text true % % % % Campaign Id Name true Modified By true Modified Date true Template true Status Reason true Campaign Code true Campaign Type true Expected Response true Price List true Offer true Proposed Begin date true Actual Begin date true Proposed End date true Actual End date true Description true Total Cost of Campaign true Estimated Revenue true Owner true Created On true Created by true Select * from FilteredCampaign where (CampaignID LIKE @campaignid) and ((Name LIKE @name) OR ( Name IS NULL)) and ((CodeName LIKE @codename) OR ( CodeName IS NULL)) and ((Description LIKE @description) OR ( Description IS NULL)) Text true % % % % Campaign Id Name true Modified By true Modified Date true Template true Status Reason true Campaign Code true Campaign Type true Expected Response true Price List true Offer true Proposed Begin date true Actual Begin date true Proposed End date true Actual End date true Description true Total Cost of Campaign true Estimated Revenue true Owner true Created On true Created by true Text SELECT CampaignID FROM FilteredCampaign ID Sales Order OrderNumber View Profile Select * from FilteredSalesOrder where (SalesOrderID LIKE @salesorderid) or (Name LIKE @name) or (OrderNumber LIKE @ordernumber) or (CustomerIDName LIKE @customeridname) or (Description LIKE @description) Text true % % % % % SalesOrder Id Name true Modified By true Modified Date true Order ID true Customer true Price List true Order discount (%) true Order discount ($) true Total Amount ($) true Requested delivery date true Date fulfilled true Shipping Method true Payment terms true Freight Terms true Description true Owner true Status Reason true Select * from FilteredSalesOrder where (SalesOrderID LIKE @salesorderid) and ((Name LIKE @name) OR ( Name IS NULL)) and ((OrderNumber LIKE @ordernumber) OR ( OrderNumber IS NULL)) and ((CustomerIDName LIKE @customeridname) OR ( CustomerIDName IS NULL)) and ((Description LIKE @description) OR (Description IS NULL)) Text true % % % % % SalesOrder Id Name true Modified By true Modified Date true Order ID true Customer true Price List true Order discount (%) true Order discount ($) true Total Amount ($) true Requested delivery date true Date fulfilled true Shipping Method true Payment terms true Freight Terms true Description true Owner true Status Reason true Text SELECT SalesOrderID FROM FilteredSalesOrder ID Contact View Profile Select * from FilteredContact where (ContactID LIKE @contactid) or (FullName LIKE @fullname) or (EmailAddress1 LIKE @emailaddress1) or (Telephone1 LIKE @telephone1) or (ParentcustomerIdName LIKE @parentcustomeridname) Text true % % % % % Contact Id Full Name true Modified By true Modified Date true Job Title true Parent Customer true Address:City true Business Phone true Email true Mobile Phone true Fax true Select * from FilteredContact where (ContactID LIKE @contactid) and ((FullName LIKE @fullname) OR (FullName IS NULL)) and ((EmailAddress1 LIKE @emailaddress1) OR (EmailAddress1 IS NULL)) and ((Telephone1 LIKE @telephone1) OR (Telephone1 IS NULL)) and ((ParentcustomerIdName LIKE @parentcustomeridname) OR (ParentcustomerIdName IS NULL)) Text true % % % % % Contact Id Full Name true Modified By true Modified Date true Job Title true Parent Customer true Address:City true Business Phone true Email true Mobile Phone true Fax true SELECT ContactID FROM FilteredContact Text ID Contract ContractNumber View Profile Select * from FilteredContract where (ContractID LIKE @contractid) or (Title LIKE @title) or (ContractNumber LIKE @contractnumber) or (CustomerIDName LIKE @customeridname) or (Expireson LIKE @expireson) or (ContractTemplateIDName LIKE @contracttemplateidname) Text true % % % % % % Contract ID Contract Title true Modified By true Modified Date true Contract Number true Customer true Contract Start date true Expiration date true Bill To Customer true Billing Frequency true Billing start date true Billing end date true Contract template true Select * from FilteredContract where (ContractID LIKE @contractid) and ((Title LIKE @title) OR (Title IS NULL)) and ((ContractNumber LIKE @contractnumber) OR (ContractNumber IS NULL)) and ((CustomerIDName LIKE @customeridname) OR (CustomerIDName IS NULL)) and ((Expireson LIKE @expireson) OR (Expireson IS NULL)) and ((ContractTemplateIDName LIKE @contracttemplateidname) OR (ContractTemplateIDName IS NULL)) Text true % % % % % % Contract ID Contract Title true Modified By true Modified Date true Contract Number true Customer true Contract Start date true Expiration date true Bill To Customer true Billing Frequency true Billing start date true Billing end date true Contract template true Text SELECT ContractID FROM FilteredContract ID Quote QuoteNumber View Profile Select * from FilteredQuote where (QuoteID LIKE @quoteid) or (Name LIKE @name) or (QuoteNumber LIKE @quotenumber) or (CustomerIDName LIKE @customeridname) Text true % % % % Quote Id Name true Modified By true Modified Date true Quote ID true Potential Customer true Price List true Quote Discount (%) true Quote Discount ($) true Total Amount true Effective from true Effective To true Requested Delivery date true Due By true Shipping method true Payment terms true Freight terms true Owner true Status Reason true Status true Select * from FilteredQuote where (QuoteID LIKE @quoteid) and ((Name LIKE @name) OR ( Name IS NULL)) and ((QuoteNumber LIKE @quotenumber) OR ( QuoteNumber IS NULL)) and ((CustomerIDName LIKE @customeridname) OR ( CustomerIDName IS NULL)) Text true % % % % Quote Id Name true Modified By true Modified Date true Quote ID true Potential Customer true Price List true Quote Discount (%) true Quote Discount ($) true Total Amount true Effective from true Effective To true Requested Delivery date true Due By true Shipping method true Payment terms true Freight terms true Owner true Status Reason true Status true Text SELECT QuoteID FROM FilteredQuote ID Invoice InvoiceNumber View Profile Select * from FilteredInvoice where (InvoiceID LIKE @invoiceid) or (Name LIKE @name) or (InvoiceNumber LIKE @invoicenumber) or (CustomerIDName LIKE @customeridname) or (SalesorderIDName LIKE @salesorderidname) or (StatusCodeName LIKE @statuscodename) Text true % % % % % % Invoice Id Name true Modified By true Modified Date true Invoice Number true Customer true Price List true Invoice Discount (%) true Date Delivered true Due date true Shipping Method true Payment Terms true Owner true Order true Status Reason true Status true Select * from FilteredInvoice where (InvoiceID LIKE @invoiceid) and ((Name LIKE @name) OR (Name IS NULL)) and ((InvoiceNumber LIKE @invoicenumber) OR (InvoiceNumber IS NULL)) and ((CustomerIDName LIKE @customeridname) OR (CustomerIDName IS NULL)) and ((SalesorderIDName LIKE @salesorderidname) OR (SalesorderIDName IS NULL)) and ((StatusCodeName LIKE @statuscodename) OR (StatusCodeName IS NULL)) Text true % % % % % % Invoice Id Name true Modified By true Modified Date true Invoice Number true Customer true Price List true Invoice Discount (%) true Date Delivered true Due date true Shipping Method true Payment Terms true Owner true Order true Status Reason true Status true Text SELECT InvoiceID FROM FilteredInvoice ID Case TicketNumber View Profile Select * from FilteredIncident where (IncidentID LIKE @incidentid) or (Title LIKE @title) or (TicketNumber LIKE @ticketnumber) or (CustomerIdName LIKE @customeridname) Text true % % % % Incident Id Title true Modified By true Modified Date true Case Number true Created On true Customer true Subject true Case Type true Case Origin true Satisfaction true Owner true Status Reason true Status true Priority true Follow Up By true Service Level true Select * from FilteredIncident where (IncidentID LIKE @incidentid) and ((Title LIKE @title) OR (Title IS NULL)) and ((TicketNumber LIKE @ticketnumber) OR (TicketNumber IS NULL)) and ((CustomerIdName LIKE @customeridname) OR (CustomerIdName IS NULL)) Text true % % % % Incident Id Title true Modified By true Modified Date true Case Number true Created On true Customer true Subject true Case Type true Case Origin true Satisfaction true Owner true Status Reason true Status true Priority true Follow Up By true Service Level true Text SELECT IncidentID FROM FilteredIncident ID Service Activity View Profile Select * from FilteredServiceAppointment where (ActivityID LIKE @activityid) or (Subject LIKE @subject) or (ServiceIDName LIKE @serviceidname) or (Description LIKE @description) or (StatusCodeName LIKE @statuscodename) or (ScheduledStart LIKE @scheduledstart) or (ScheduledEnd LIKE @scheduledend) Text true % % % % % % % Activity Id Subject true Modified By true Modified Date true Service true Description true Status Reason true Scheduled Start true Scheduled End true Actual Start true Actual End true Owner true Priority true Select * from FilteredServiceAppointment where (ActivityID LIKE @activityid) and ((Subject LIKE @subject) OR (Subject IS NULL)) and ((ServiceIDName LIKE @serviceidname) OR (ServiceIDName IS NULL)) and ((Description LIKE @description) OR (Description IS NULL)) and ((StatusCodeName LIKE @statuscodename) OR (StatusCodeName IS NULL)) and ((ScheduledStart LIKE @scheduledstart) OR (ScheduledStart IS NULL)) and ((ScheduledEnd LIKE @scheduledend) OR (ScheduledEnd IS NULL)) Text true % % % % % % % Activity Id Subject true Modified By true Modified Date true Service true Description true Status Reason true Scheduled Start true Scheduled End true Actual Start true Actual End true Owner true Priority true Text SELECT ActivityID FROM FilteredServiceAppointment ID Marketing List View Profile Select * from FilteredList where (ListID LIKE @listid) or (ListName LIKE @listname) or (Purpose LIKE @purpose) or (Description LIKE @description) or (LastUsedOn LIKE @lastusedon) Text true % % % % % List Id List Name true Modified By true Modified Date true Member Type true Purpose true Source true Locked true Owner true Last used on true Description true Select * from FilteredList where (ListID LIKE @listid) and ((ListName LIKE @listname) OR (ListName IS NULL)) and ((Purpose LIKE @purpose) OR (Purpose IS NULL)) and ((Description LIKE @description) OR (Description IS NULL)) and ((LastUsedOn LIKE @lastusedon) OR (LastUsedOn IS NULL)) Text true % % % % % List Id List Name true Modified By true Modified Date true Member Type true Purpose true Source true Locked true Owner true Last used on true Description true Text SELECT ListID FROM FilteredList ID Competitor View Profile Select * from FilteredCompetitor where (CompetitorID LIKE @competitorid) or (Name LIKE @name) or (WebsiteUrl LIKE @websiteurl) or (KeyProduct LIKE @keyproduct) or (TickerSymbol LIKE @tickersymbol) Text true % % % % % Competitor Id Name true Modified By true Modified Date true Web Site true Ticker Symbol true Key Product true Overview true Select * from FilteredCompetitor where (CompetitorID LIKE @competitorid) and ((Name LIKE @name) OR (Name IS NULL)) and ((WebsiteUrl LIKE @websiteurl) OR (WebsiteUrl IS NULL)) and ((KeyProduct LIKE @keyproduct) OR (KeyProduct IS NULL)) and ((TickerSymbol LIKE @tickersymbol) OR (TickerSymbol IS NULL)) Text true % % % % % Competitor Id Name true Modified By true Modified Date true Web Site true Ticker Symbol true Key Product true Overview true Text SELECT CompetitorID FROM FilteredCompetitor ID