Account Query
Account queryunknown
apex
a year ago
11 kB
10
Indexable
Select Accidental__c, AccountNumber, AccountSource, Account_Category__c, Account_Current_Type__c, Account_Source_Other__c, Account_Type__c, Account__c, Accounts_Payable_Email__c, Active_Ads__c, Active_Inventory_Hold_Back_Applicable__c, Active_Listings__c, Active_Package_Current_Month__c, Actividad_Economia__c, Ad_Price__c, Ad_id__c, Additional_Services__c, Advance_Receipt_Amount__c, Advance_Receipt_ID__c, Agent_Name__c, Alternate_Email__c, AnnualRevenue, Atlastock_Expiry_Date__c, Atlastock_Invite_Date__c, Atlastock_Registration_Date__c, Authorized_Dealer__c, Average_ARPU__c, BI_Unique_Key__c, BPDB_Status__c, BPS_Integration_Error__c, BPS_Integration_Status__c, BPS_Update_Ids__c, BPS_UserID__c, Bank_Account_Number__c, Bank_Name__c, BillingAddress, BillingCity, BillingCountry, BillingCountryCode, BillingGeocodeAccuracy, BillingLatitude, BillingLongitude, BillingPostalCode, BillingState, BillingStateCode, BillingStreet, Billing_City_1__c, Billing_City_2__c, Billing_Email__c, Billing_Name__c, Billing_State_Province_1__c, Billing_State_Province_2__c, Billing_Street_1__c, Billing_Street_2__c, Billing_Zip_Postal_Code_1__c, Billing_Zip_Postal_Code_2__c, Birthday__c, Block_Account__c, Broker_Email__c, BusinessCategoryBackend__c, Business_Category__c, Business_Establishment_Type__c, Business_Partner_Type__c, Buying_and_Selling_Dealer__c, CF_Status__c, CLIENT_ID__c, CMC_City_Mapping__c, CPL__c, CTx_Cars_Won_Icon__c, Call_M0__c, Call_Status__c, Call_priority__c, Campaign__c, Car_Ageing_Years__c, Car_Dealer_Type__c, Car_Type__c, Category_Creation__c, Category__c, Channel__c, Chat_Response__c, Check_For_Duplicates__c, Check_In_time__c, City_Cars__c, City_Name__c, Client_Status__c, Client_Type_Others__c, Client_Type__c, Collection_M_1__c, Collection_This_Mon__c, Collections_M_0__c, Commercial_Register_Name__c, Commercial_Register_Number__c, Commercial_Registery_Uploaded__c, Condicion_local_IIBB__c, Consumer_Financing__c, Copy_Billing_Address_to_Shipping_Address__c, Country__c, CreatedById, CreatedDate, Created_From_Lead__c, Credits__c, CurrencyIsoCode, Current_Package_Duration__c, Current_Package_End_Date__c, Current_Wallet_balance__c, Customer_LS_Status__c, DSM_Assigned__c, Date_Started__c, Date_of_last_post__c, Dealer_Assignment__c, Dealer_Bidding_Status__c, Dealer_Category__c, Dealer_City__c, Dealer_Current_Car_Limit__c, Dealer_Feature_Flag__c, Dealer_Features__c, Dealer_Financing_Eligible__c, Dealer_Financing_Rec__c, Dealer_Financing_Rejection_Reason__c, Dealer_Financing__c, Dealer_Inventory_More_Than_90_Days__c, Dealer_Max_Car_Limit__c, Dealer_Onboarding_Activated__c, Dealer_Onboarding_Activated_by__c, Dealer_Onboarding__c, Dealer_Sales_Manager__c, Dealer_Sales_Relationship_Manager_2__c, Dealer_Status__c, Dealer_Type__c, Dealer_financing_Enrollment_date__c, Dealing_In_Secondary__c, Dealing_in__c, Description, Digito_de_Verificacion__c, Disable_BI_Unique_Key__c, Dormant_Account_All_Category__c, Dormant_Account__c, DupeCheck_Email__c, DupeCheck_Name__c, Dupe_Check_User_Id__c, Dupecheck_Primary_Mobile__c, Duplicate_Found__c, Eligible_for_Free_trial__c, Eligible_in_TCS__c, Eligible_in_TDS__c, Email_For_Userids__c, Email_Received_From_UserService__c, Email__c, Expected_Closure_Date__c, Expected_Collection_Amount__c, Expected_Conversion_Date__c, External_Reference_ID__c, FCGPwdSent__c, FCG_Deactivation_Reason__c, FCG_Email__c, FCG_Id__c, FCG_Integration_Error__c, FCG_Integration_Status__c, FCG_Password__c, FCG_Status__c, FCG_Username__c, Fax, First_Payment_Date__c, Fiscal_Partnership__c, Flood__c, Follow_Up_Date_Time__c, Forfeiture_Applicable_New__c, Forfeiture_Applicable__c, Fuel_Type__c, GNL__c, GST_Applicable__c, GST_City__c, GST_Country__c, GST_Number__c, GST_Postal_Code__c, GST_Run_check__c, GST_State_Code__c, GST_State__c, GST_Street__c, GST_Validated__c, Generate_Virtual_Account_Number__c, Get_FCG_Id__c, Get_OLX_Id__c, GstDeleted__c, Gst_Interface_Response__c, Gst_Tax_Id_BPS__c, Hierarchy__c, Highest_Rank_Product_Current_Month__c, Highest_Rank_Product_Last_2_Months__c, Id, Inauguration__c, Industry, Interested_VAS_Products__c, Inventory__c, IsDeleted, IsMaster__c, IsPersonAccount, Is_Excluded__c, Is_Valid_Email__c, Is_Warehouse__c, Jigsaw, JigsawCompanyId, KMs_Driven__c, KTP_Applicable__c, KTP_No__c, KTP_Proof_Uploaded__c, Kecamatan__c, Key_Account__c, Koh__c, L1_Category_Others__c, L1_Category__c, L2_Category__c, L3_Category__c, Last_Activity_Date_Time__c, Last_Activity_Date__c, Last_Activity_Type__c, Last_Ad_Post_Date__c, Last_Bid_Date__c, Last_Connected_Dispo_Date__c, Last_Connected_Dispo__c, Last_Contact_Disposition__c, Last_Dialed_Date__c, Last_Dispo__c, Last_Meeting_Date__c, Last_Meeting_Outcome__c, Last_Meeting_Verified__c, Last_Paid_Date__c, Last_Reload_Amount__c, Last_Reload_Platform__c, Last_Remarks__c, Last_Stock_Update__c, Last_Subscription_Package_Duration__c, Last_Subscription_Package_End_Date__c, Last_Task_Date__c, Last_Transaction_Date__c, Last_Update_Date__c, Last_Usage_Platform__c, Last_User_Segment__c, Last_Visit_Sentiment__c, Last_Wallet_Top_Up_Balance__c, Last_Wallet_Topup_Date__c, Legal_Name__c, Lifetime_Value__c, Limited_Listings__c, Live_Listings__c, Locality_Cars__c, Locality__c, Location__Latitude__s, Location__Longitude__s, Location__c, MTD_Ad_Views__c, MTD_Listings__c, MTD_NNL__c, MTD_Rate_Feature_Ads__c, MTD_Replies__c, MTD_Revenue__c, Mask_Number__c, MasterRecordId, Max_Amount_Bid__c, Max_Expiry_Date_of_Listings__c, Max_Expiry_Date_of_VAS__c, Meeting_Calls_done_in_Last_30_days__c, Min_Expiry_Date_of_Listings__c, Min_Expiry_Date_of_VAS__c, MobileNo_Received_From_UserService__c, Mobile_2__c, Moderation__c, NNL_30days__c, NPWP_Applicable__c, NPWP_No__c, NPWP_Proof_Uploaded__c, Name, Neighborhoods_Districts__c, New_Campaign_Status__c, Next_Birthday__c, Next_Inauguration_Date__c, Next_Month_Type_Insert_Date__c, Next_Month_Type__c, Next_Payment_Due_Date__c, Next_Payment__c, No_of_Dials_Available__c, No_of_Dials__c, NumberOfEmployees, Number_of_Active_Listings__c, Number_of_Pending_RC_Cases__c, Number_of_Total_Car_Delivered_to_Dealer__c, Number_of_contacts_MTD__c, Number_of_moderated_ads__c, OEM_Company_Name__c, Old_Customer_LS_Status__c, Onboarding_Agent__c, Onboarding_Consultant__c, Onboarding_Reactivation_Agent__c, Onboarding_Status__c, Opted_for_WhatsApp__c, Other_Deactivation_Reason__c, OwnerId, Owner_Pays_LF__c, Owner_Pays_PF__c, Owner_Type__c, Ownership, P24_User_ID__c, PF__c, Package_Expiry_Date__c, Package_Purchase_Date__c, Package_Usage__c, ParentId, Password_and_Username_Check__c, Pending_RC_Transfer_Reg_no__c, PersonAssistantName, PersonAssistantPhone, PersonBirthdate, PersonContactId, PersonDepartment, PersonEmail, PersonEmailBouncedDate, PersonEmailBouncedReason, PersonHomePhone, PersonIndividualId, PersonLastCURequestDate, PersonLastCUUpdateDate, PersonLeadSource, PersonMailingAddress, PersonMailingCity, PersonMailingCountry, PersonMailingCountryCode, PersonMailingGeocodeAccuracy, PersonMailingLatitude, PersonMailingLongitude, PersonMailingPostalCode, PersonMailingState, PersonMailingStateCode, PersonMailingStreet, PersonMobilePhone, PersonOtherAddress, PersonOtherCity, PersonOtherCountry, PersonOtherCountryCode, PersonOtherGeocodeAccuracy, PersonOtherLatitude, PersonOtherLongitude, PersonOtherPhone, PersonOtherPostalCode, PersonOtherState, PersonOtherStateCode, PersonOtherStreet, PersonTitle, Phone, PhotoUrl, Pincode_Cars__c, Pipeline_Status__c, Plot_Building_No__c, Post_date__c, Preferred_Car_Brands__c, Preferred_Email__c, Preferred_Name__c, Previous_User_Segment_CTx__c, Previous_User_Segment__c, Price_Range_Preference__c, Primary_Category__c, Primary_Contact__c, Primary_Mobile_ExternalId__c, Primary_Mobile__c, Priority_From_CSV__c, Priority_Logic_Last_run_at__c, Priority__c, Product_Pitched_to_Lead__c, Product__c, Propensity_Level__c, Propensity_Score__c, Prorated_Package_Usage__c, Purchase_Package_Name__c, RC_Transfer_Count_Post_90_Days_Delivery__c, RC_Transfer_Ratio__c, RSD_Applicable__c, Rating, Reactivation_Date__c, Reactivation_by_User__c, RecordTypeId, Record__c, Recordtype_Name__c, Region_Lebanon__c, Region__c, Registration_No__c, Registration_Type__c, Regular_SMS_Sent__c, Remaining_Quota__c, Remaining_Quota_of_Listings__c, Remaining_Quota_of_VAS__c, Remove_Business_Category_Backend__c, Renewal_Date__c, Renewal_Segment__c, Replies_30days__c, Reply_Per_Listing_Total__c, Reply_Total__c, Require_Verification__c, Reset_Birthday_Email_System__c, Reset_Inauguration_Email_System__c, SKU_No__c, SKU_Proof_Uploaded__c, Sales_Channel__c, Sales_ID__c, Salutation, Same_Address__c, Scheme_Validity__c, Segment__c, Segmentation__c, SendEmail__c, Send_To_User_Service__c, Send_to_BPS__c, Send_to_FCG__c, Shared_Date__c, ShippingAddress, ShippingCity, ShippingCountry, ShippingCountryCode, ShippingGeocodeAccuracy, ShippingLatitude, ShippingLongitude, ShippingPostalCode, ShippingState, ShippingStateCode, ShippingStreet, Showroom_Group_Showroom_Code__c, Showroom__c, Sic, SicDesc, Site, Size_of_Business__c, Sobek_Account_Number__c, Source_Level_2__c, Startegic_Call__c, State_Cars__c, State_Name__c, Status__c, Stockars_Client_ID__c, Stockyard_Pin_Code__c, Stop_Bid_Reason__c, SystemModstamp, System_Client_ID__c, System_L1_Category__c, System_email__c, System_phone__c, TAN_Is_Applicable__c, TAN__c, TDS_Approved_Date__c, TOTAL_JUMLAH_CABANG__c, Tama_o_Inventario_Real__c, Tax_Card_Number__c, Tax_Card_Uploaded__c, Tax_City__c, Tax_Condition_Uploaded__c, Tax_Condition__c, Tax_Country__c, Tax_Id_Uploaded__c, Tax_Id__c, Tax_No_Applicable__c, Tax_No_Type__c, Tax_Pincode__c, Tax_State__c, Tax_Street_Name__c, Tax_Sub_Type__c, Tax_Subtype_Formula__c, TickerSymbol, Tipo_Contribuyente__c, Title__c, Tl_Name__c, Total_Calls__c, Total_Chats__c, Total_Collection__c, Total_Inventory_Value__c, Total_Payment_Received__c, Total_Payment_Received_for_Onboarding__c, Total_Replies__c, Total_Usage__c, Total_Won_Deals__c, Trade_Offering__c, Type, Type_Of_Shhowroom__c, Type_of_Business__c, Type_of_User__c, Upload_Date__c, Upload_Documents__c, UserService_Integration_Status__c, User_Atlastock__c, User_Id__c, User_Segment_CTx__c, User_Segment_UI__c, User_Service_Integration_Error__c, User_Service_Status__c, User_Status__c, User_Usage_Current_Month__c, User_id_Type__c, User_segment_2__c, User_segment_3__c, User_segment__c, VAT_Type__c, Vendor__c, Vertical__c, Violation_Date__c, Virtual_Account_Number__c, Website, X6_Digit_FCG_Id__c, cat_l1_expiry__c, cat_l2_expiry__c, country_name__c, currency_code__c, dealer_auto_buy__c, dealer_auto_sell__c, drop_off__c, expiry__c, isValidation__c, last6_avg_sales__c, last_logged_in__c FROM Account WHERE LastModifiedDate >= 2023-12-28T10:00:00.000+0000
Editor is loading...
Leave a Comment