Opportunity Query

Opportunity Query
mail@pastecode.io avatar
unknown
apex
a month ago
5.9 kB
6
Indexable
Never
Select AccountId, Account_Owner_Formula__c, Account_Owner_Truncate__c, Account_Record__c, Account_Source__c, Account_Status__c, Activation_Date__c, Additional_Discount__c, Adhaar_Card_Uploaded__c, Amount, Amount_to_be_Received__c, Amount_to_be_adjusted__c, Approval_Required__c, Approval_Status__c, Approved_by_Finance__c, Automatic_Debit_Order_Form_Uploaded__c, Billing_Entity_Name__c, Billing_Entity__c, Blank_Package_Start_Date_Count__c, Booking_Date__c, Broker_Email__c, CRM_Client_ID__c, CampaignId, Category_L1_Id__c, Category_LATAM__c, Category__c, Channel__c, City__c, Client_Type_LATAM__c, Client_Type__c, CloseDate, ContactId, Contract_End_Date__c, Contract_Start_Date__c, Contract_Uploaded__c, Converted_from_Lead__c, Country_Code__c, Country__c, Create_Renewal_Deal_Manually__c, CreatedById, CreatedDate, Credit_Amount__c, CurrencyIsoCode, Currency__c, Current_Top_Balance__c, Current_Wallet_Balance__c, DB_Competitor__c, DSM_Assigned__c, Days_since_Min_Product_Start_Date__c, Days_since_Wallet_Top_up_Date__c, Deal_Activated_On__c, Deal_Activated_by_User__c, Deal_Activated_on_Date_Time__c, Deal_Close_Date__c, Deal_Deactivation_Date__c, Deal_Expiry_Date__c, Deal_Number__c, Deal_Owner_Id__c, Deal_Signup_Date_Time__c, Deal_Signup_Date__c, Deal_Start_Date__c, Deal_Term__c, Deal_Terminated__c, Deal_id__c, Dealer_Name__c, Deposit_Date__c, Description, Discount_Approval_Doc_Uploaded__c, Discount_Approval_Required__c, Discount_Freebie_Approval_Status__c, Discount_IN__c, Discount_RE__c, Discount_Value__c, Discount__c, Document_Payment_Verified__c, Document_Status__c, Email_ID__c, Evergreen_Contract__c, Exchange_Rate__c, Expected_Close_Date__c, Expected_Collection_Amount__c, Expiration_Date__c, Expiry_In_Days__c, Expiry_Status__c, Feature_Ad_City__c, Finance_comments__c, Finance_verification_date__c, First_Meeting_Date__c, Fiscal, FiscalQuarter, FiscalYear, Follow_Up_Date_and_Time__c, ForecastCategory, ForecastCategoryName, GST_Number__c, HasOpenActivity, HasOpportunityLineItem, HasOverdueTask, Id, Insertion_Order_Uploaded__c, Insertion_Order__c, Instrument_Number_Upload__c, Instrument_Number__c, Invoice_Date__c, Invoice_Number__c, Invoice_Uploaded__c, IsClosed, IsDeleted, IsWon, Is_Adjustment_required__c, L1_Approver__c, L1_Category__c, L2_Approver__c, L3_Approver__c, LATAM_Advertising_Amount__c, LATAM_Amount_after_Tax__c, LATAM_Development_Name__c, LATAM_Execution_Date__c, LATAM_Loan_Amount__c, LATAM_Loan_Bank__c, LATAM_Loan_Commission__c, LATAM_Loan_Period__c, LATAM_Loan_Presented_Date__c, LATAM_Loan_Product_Type__c, LATAM_Loan_Type__c, LATAM_Mailing_Amount__c, LATAM_Property_Price__c, LATAM_Sub_Stage__c, LATAM_Total_Number_of_Invoices__c, LATAM_UGR_Amount__c, LastActivityDate, LastAmountChangedHistoryId, LastCloseDateChangedHistoryId, LastModifiedById, LastModifiedDate, LastReferencedDate, LastStageChangeDate, LastViewedDate, Last_Activity_Date_Cars__c, Last_Activity_Date__c, Last_Meeting_Outcome__c, Last_Subcription_Package_Duration__c, Last_Subscription_Package_End_Date__c, Last_Task_Date__c, Last_Visit_Sentiment__c, Last_Wallet_Top_up_Date__c, Latest_Task_Date__c, LeadSource, Legacy_Deal_Size__c, Legacy_ID__c, Locality__c, Loss_Reason_Others__c, Loss_Reason__c, Max_Discount__c, Media_Order_Uploaded__c, Media_Order__c, Meeting_Report__c, Min_Product_Start_Date_Active_Product__c, Minimum_Expiry_Date__c, Monetizer_Transaction_Id__c, Monetizer_Tx_Id__c, Mudra_Order_Response__c, Multiple_Account_Deal__c, Multiple_State_Province_Deal__c, Name, NextStep, Next_Steps__c, No_of_Active_Offline_Products__c, No_of_Active_Online_Products__c, No_of_FAs__c, No_of_Freebie_Products__c, No_of_Offline_Products__c, No_of_Online_Products__c, No_of_Payments_Document_Proof_Pending__c, No_of_Payments__c, No_of_Pending_Active_prod__c, No_of_Pending_Products__c, No_of_Products__c, No_of_listings__c, Number_of_Credits__c, Number_of_Invoices__c, Objections__c, Office_Address_Proof_Uploaded__c, Offline__c, Order_Creation_Date_Time__c, Order_Error_Response__c, Order_ID_1__c, Order_Id__c, Order_Status__c, OwnerId, Owner_City__c, Owner_Classification__c, Owner_s_Manager_Email__c, Owners_ASM_Email__c, Parent_Opportunity__c, Payment_Amount__c, Payment_Document_Uploaded__c, Payment_Mode__c, Payment_Receipt_Date__c, Payment_Reference_No__c, Payment_Status__c, Payment_Type__c, Payment_Value__c, Payment_Verified__c, Pending_Amount_Freebie__c, Pipeline_Status__c, Platform__c, Previous_User_Segment__c, Pricebook2Id, Pricebook_Unique_Name__c, Probability, Product_Name__c, Product_Pitched__c, Product_Type__c, Product_Type_new__c, Product__c, Promotion__c, PushCount, RSM__c, Reason_for_Freebie__c, RecordTypeId, Record__c, Region_Category__c, Region__c, Renewal_Deal_Created__c, Renewal_Deal_Type__c, SOT_Review__c, SOT_Submission_Count__c, Sales_Order_Form_Uploaded__c, Sales_Price_Before_Tax__c, Security_Cash_Amount__c, StageName, Stage_Number__c, Stockars_Client_ID__c, Sub_User_Id__c, SystemModstamp, TDS__c, Tax_Amount__c, Tax__c, TotalOpportunityQuantity, Total_Activated_Expired_Products_Amount__c, Total_Activated_Pending_Products_Amount__c, Total_Activated_Products_Amount__c, Total_Amount_Freebie__c, Total_Amount__c, Total_Discount__c, Total_Due_Payment__c, Total_List_Price__c, Total_Number_of_Activated_Products__c, Total_Payment_Received__c, Total_Payment__c, Total_Pending_Payment__c, Total_SKU_Activated_Paid__c, Total_TDS__c, Type, Upgraded_Downgraded_Deal__c, User_Id__c, Wallet_Expired_Balance__c, Wallet_Top_Up_Balance__c, Wallet_Utilization_Percentage__c, Wallet_Utilization_age__c, Website__c, Work_Order__c, z_Feature_Ad_City_Id__c, z_Product_Type__c, z_Total_Amount__c FROM Opportunity WHERE LastModifiedDate >= 2023-12-28T10:00:00.000+0000 AND (RecordType.Name = 'Cars - India' OR RecordType.Name = 'Jobs - India' OR RecordType.Name = 'RE - India' OR RecordType.Name = 'Telesales - India' OR RecordType.Name = 'Template')
Leave a Comment