query
RESULTSET
query
  ASSIGNEDREPFIRSTNAME ASSIGNEDREPID ASSIGNEDREPLASTNAME AUTOCASEAMT AUTOINCOMEAMT AUTOQUANTITYAMT AUTOWEIGHTAMT AVAILABLEDATE BASEQUANTITYAMT CAMPAIGNID CAMPAIGNNAME CASEAMT CDRCONTACTID CDRDISTRIBUTORID CDR_DSTNAME CDR_RECORDID CLASSIFICATIONNAME CMCCOMPANYNAME CMCFSLCOMPANYNAME COMMISSIONAMT COMMISSIONMETHOD COMPANYADDRESS COMPANYCITY COMPANYNAME COMPANYNBR COMPANYPHONE COMPANYPHONE COMPANYSTATE COMPANYZIP COMPETITIVECOMMENT COMPETITORID CONTACTCELLPHONE CONTACTEMAIL CONTACTFIRSTNAME CONTACTID CONTACTLASTNAME CONTACTPHONE CONTACTSALUTATION CONTACTTITLE CREATEDATE CREATEUSERID CSTMCODEAPPROVEDDATE CUISINEID DATECLOSED DAYSAGED DAYSSINCELASTUPDATE DISTCODE DURATIONAMT DURATIONUNIT FINMARGINAMT FIRSTACTIVEDATE FISCALYEAR FOCUSACCOUNT FSEACCTTERRITORYID FSEPLANTERRITORYID FSESEGMENTID GENERAL_NOSALEREASON GENERAL_SALEREASON GPOCOMPANYNAME GPOFSLCOMPANYNAME INCOMEAMT INTERNAL LAUNCHDATE LIKELIHOODPERCENT MFRFISCALYEARENDMONTH MFRFISCALYEARSTARTMONTH MFRID MFRNAME MFRPLANWEEKS MFRUNITOFMEASURE MFRUNITOFMEASUREPLURAL MFR_BSR_ID MFR_BSR_ID2 NEWCUSTOMCODE NOSALEREASONID NUM_UNITS_THISYR ONEFSID OPERATORID OPPORTUNITYDESCRIPTION OPPORTUNITYID OPPORTUNITYIDTK OPPORTUNITYNAME OWNERID OWNERTYPE PARTNERID PARTNERNAME PARTNERTYPE PLANENDDATE PLANSTARTDATE PORTIONAMTOZ PORTIONSPERDAY PRICEAMT PRICECOMMENT PRICETYPE PRICEUOM PRIORITY PROJECTNBR PROJECTNOTES QUANTITYAMT QUANTITYUNIT RAWSALESPERSONUSERID RCDR_RECORDID REASONCODE REASONNAME REASONORDER RECYCLEDATE REFERENCECODE REPTITLE SALEREASONCODE SALEREASONID SALEREASONNAME SALEREASONORDER SALESPERSONACKNOWLEDGED SALESPERSONEMAIL SALESPERSONFIRSTNAME SALESPERSONLASTNAME SALESPERSONOWNERID SALESPERSONOWNERTYPE SALESPERSONPHONE SALESPERSONPHONEEXT SALESPERSONUSERID SAMPLECOMMENTS SAMPLESTATUS SEQUENCE SORTCDR_DSTNAME SORTCDR_RECORDID SOURCEOWNERID SOURCEOWNERTYPE STAGEABBRV STAGEAPPROVEDDATE STAGEID STAGENAME STATECODE STATUSCODE SUBJECTID SUBJECTTYPE TERRITORYID TERRITORYNAME TERRITORYNUMBER TRADEREQUESTID TRADESPENDAMT TYPECODE TYPENAME TYPESORTRANK UNITPRICE UNITSTOSERVE UPDATEDATE UPDATEUSERID WEIGHTAMT XREFDATA YEARCLOSED YEARINITIATED caseImpact foodserviceSegment impactDays impactRate residual totalDays valueImpact volumeImpact weeksRemaining weightImpact
CACHED false
EXECUTIONTIME 0
SQL select * from qmd_opportunities where salesPersonUserId in ( 2459500 )