Salesforce Field Reference

Sample

The Salesforce connector allows to retrieve Salesforce CRM data from standard and custom objects. It also supports retrieval of custom fields

Important: Custom fields and custom objects are not available on the list below. To make them available go to https://onboard.windsor.ai/app/salesforce and connect your Salesforce CRM account.

https://connectors.windsor.ai/salesforce?api_key=[your API key]&date_preset=last_7d&fields=contact_firstname,contact_lastname,contact_email,contact_phone&_renderer=csv


Fields

IDTypeNameDescriptionObject
account_account_sourceTEXTAccount SourceAccount Sourceaccount
account_annual_revenueNUMERICAccount Annual RevenueAccount Annual Revenueaccount
account_billing_addressTEXTAccount Billing AddressAccount Billing Addressaccount
account_billing_cityCITYAccount Billing CityAccount Billing Cityaccount
account_billing_countryCOUNTRYAccount Billing CountryAccount Billing Countryaccount
account_billing_geocode_accuracyTEXTAccount Billing Geocode AccuracyAccount Billing Geocode Accuracyaccount
account_billing_latitudeNUMERICAccount Billing LatitudeAccount Billing Latitudeaccount
account_billing_longitudeNUMERICAccount Billing LongitudeAccount Billing Longitudeaccount
account_billing_postal_codeTEXTAccount Billing Zip/Postal CodeAccount Billing Zip/Postal Codeaccount
account_billing_stateTEXTAccount Billing State/ProvinceAccount Billing State/Provinceaccount
account_billing_streetTEXTAccount Billing StreetAccount Billing Streetaccount
account_created_by_idTEXTAccount Created By IDAccount Created By IDaccount
account_created_dateDATEAccount Created DateAccount Created dateaccount
account_descriptionTEXTAccount DescriptionAccount Descriptionaccount
account_faxTEXTAccount FaxAccount Faxaccount
account_idTEXTAccount IDAccount IDaccount
account_industryTEXTAccount IndustryAccount Industryaccount
account_is_deletedBOOLEANAccount DeletedAccount Deletedaccount
account_jigsawTEXTAccount Data.com KeyAccount Data.com Keyaccount
account_jigsaw_company_idTEXTAccount Jigsaw Company IDAccount Jigsaw Company IDaccount
account_last_activity_dateDATEAccount Last ActivityAccount Last Activityaccount
account_last_modified_by_idTEXTAccount Last Modified By IDAccount Last Modified By IDaccount
account_last_modified_dateDATEAccount Last Modified DateAccount Last Modified dateaccount
account_last_referenced_dateDATEAccount Last Referenced DateAccount Last Referenced dateaccount
account_last_viewed_dateDATEAccount Last Viewed DateAccount Last Viewed dateaccount
account_master_record_idTEXTAccount Master Record IDAccount Master Record IDaccount
account_nameTEXTAccount NameAccount Nameaccount
account_number_of_employeesNUMERICAccount EmployeesAccount Employeesaccount
account_operating_hours_idTEXTAccount Operating Hour IDAccount Operating Hour IDaccount
account_owner_idTEXTAccount Owner IDAccount Owner IDaccount
account_parent_idTEXTAccount Parent Account IDAccount Parent Account IDaccount
account_phoneTEXTAccount PhoneAccount Phoneaccount
account_photo_urlTEXTAccount Photo URLAccount Photo URLaccount
account_shipping_addressTEXTAccount Shipping AddressAccount Shipping Addressaccount
account_shipping_cityCITYAccount Shipping CityAccount Shipping Cityaccount
account_shipping_countryCOUNTRYAccount Shipping CountryAccount Shipping Countryaccount
account_shipping_geocode_accuracyTEXTAccount Shipping Geocode AccuracyAccount Shipping Geocode Accuracyaccount
account_shipping_latitudeNUMERICAccount Shipping LatitudeAccount Shipping Latitudeaccount
account_shipping_longitudeNUMERICAccount Shipping LongitudeAccount Shipping Longitudeaccount
account_shipping_postal_codeTEXTAccount Shipping Zip/Postal CodeAccount Shipping Zip/Postal Codeaccount
account_shipping_stateTEXTAccount Shipping State/ProvinceAccount Shipping State/Provinceaccount
account_shipping_streetTEXTAccount Shipping StreetAccount Shipping Streetaccount
account_sic_descTEXTAccount SIC DescriptionAccount SIC Descriptionaccount
account_system_modstampTEXTAccount System ModstampAccount System Modstampaccount
account_typeTEXTAccount TypeAccount Typeaccount
account_websiteTEXTAccount WebsiteAccount Websiteaccount
campaign_actual_costNUMERICCampaign Actual Cost in CampaignCampaign Actual Cost in Campaigncampaign
campaign_amount_all_opportunitiesNUMERICCampaign Value Opportunities in CampaignCampaign Value Opportunities in Campaigncampaign
campaign_amount_won_opportunitiesNUMERICCampaign Value Won Opportunities in CampaignCampaign Value Won Opportunities in Campaigncampaign
campaign_budgeted_costNUMERICCampaign Budgeted Cost in CampaignCampaign Budgeted Cost in Campaigncampaign
campaign_campaign_member_record_type_idTEXTCampaign Record Type IDCampaign Record Type IDcampaign
campaign_created_by_idTEXTCampaign Created By IDCampaign Created By IDcampaign
campaign_created_dateDATECampaign Created DateCampaign Created datecampaign
campaign_descriptionTEXTCampaign DescriptionCampaign Descriptioncampaign
campaign_end_dateDATECampaign End DateCampaign End datecampaign
campaign_expected_responseNUMERICCampaign Expected Response (%)Campaign Expected Response (%)campaign
campaign_expected_revenueNUMERICCampaign Expected Revenue in CampaignCampaign Expected Revenue in Campaigncampaign
campaign_idTEXTCampaign IDCampaign IDcampaign
campaign_is_activeBOOLEANCampaign ActiveCampaign Activecampaign
campaign_is_deletedBOOLEANCampaign DeletedCampaign Deletedcampaign
campaign_last_activity_dateDATECampaign Last ActivityCampaign Last Activitycampaign
campaign_last_modified_by_idTEXTCampaign Last Modified By IDCampaign Last Modified By IDcampaign
campaign_last_modified_dateDATECampaign Last Modified DateCampaign Last Modified datecampaign
campaign_last_referenced_dateDATECampaign Last Referenced DateCampaign Last Referenced datecampaign
campaign_last_viewed_dateDATECampaign Last Viewed DateCampaign Last Viewed datecampaign
campaign_nameTEXTCampaign NameCampaign Namecampaign
campaign_number_of_contactsNUMERICCampaign Contacts in CampaignCampaign Contacts in Campaigncampaign
campaign_number_of_converted_leadsNUMERICCampaign Converted Leads in CampaignCampaign Converted Leads in Campaigncampaign
campaign_number_of_leadsNUMERICCampaign Leads in CampaignCampaign Leads in Campaigncampaign
campaign_number_of_opportunitiesNUMERICCampaign Opportunities in CampaignCampaign Opportunities in Campaigncampaign
campaign_number_of_responsesNUMERICCampaign Responses in CampaignCampaign Responses in Campaigncampaign
campaign_number_of_won_opportunitiesNUMERICCampaign Won Opportunities in CampaignCampaign Won Opportunities in Campaigncampaign
campaign_number_sentNUMERICCampaign Num Sent in CampaignCampaign Num Sent in Campaigncampaign
campaign_owner_idTEXTCampaign Owner IDCampaign Owner IDcampaign
campaign_parent_idTEXTCampaign Parent Campaign IDCampaign Parent Campaign IDcampaign
campaign_start_dateDATECampaign Start DateCampaign Start datecampaign
campaign_statusTEXTCampaign StatusCampaign Statuscampaign
campaign_system_modstampTEXTCampaign System ModstampCampaign System Modstampcampaign
campaign_typeTEXTCampaign TypeCampaign Typecampaign
campaignmember_campaign_idTEXTCampaign Member Campaign IDCampaign Member ID of the Campaign to which this Lead or Contact is associated.campaignmember
campaignmember_company_or_accountTEXTCampaign Member CompanyOrAccountCampaign Member The company or account of the lead or contact.campaignmember
campaignmember_contact_idTEXTCampaign Member ContactIdCampaign Member ID of the Contact who is associated with a Campaign.campaignmember
campaignmember_countryCOUNTRYCampaign Member CountryCampaign Member The country for the address of the lead or contact.campaignmember
campaignmember_descriptionTEXTCampaign Member DescriptionCampaign Member The description of the associated lead or contact.campaignmember
campaignmember_do_not_callBOOLEANCampaign Member DoNotCallCampaign Member Indicates that the contact doesn’t wish to be called.campaignmember
campaignmember_faxTEXTCampaign Member FaxCampaign Member Fax number for the contact or lead.campaignmember
campaignmember_first_nameTEXTCampaign Member First NameCampaign Member The first name of the contact or lead.campaignmember
campaignmember_first_responded_dateDATECampaign Member FirstRespondedDateCampaign Member Indicates the date on which the campaign member was first given a responded status.campaignmember
campaignmember_has_opted_out_of_faxBOOLEANCampaign Member HasOptedOutOfFaxCampaign Member Indicates that the contact or lead doesn’t wish to receive faxes.campaignmember
campaignmember_has_respondedBOOLEANCampaign Member HasRespondedCampaign Member Indicates whether the campaign member has responded to the campaign (true) or not (false). Label is Responded.campaignmember
campaignmember_last_nameTEXTCampaign Member LastNameCampaign Member The last name of the contact or lead. Limit is 80 characters.campaignmember
campaignmember_lead_idTEXTCampaign Member LeadIdCampaign Member ID of the Lead who is associated with a Campaign.campaignmember
campaignmember_lead_or_contact_idTEXTCampaign Member LeadOrContactIdCampaign Member The ID of the associated lead or contact.campaignmember
campaignmember_lead_or_contact_owner_idTEXTCampaign Member LeadOrContactOwnerIdCampaign Member The ID of the owner of the associated lead or contact.campaignmember
campaignmember_lead_sourceTEXTCampaign Member LeadSourceCampaign Member The source from which the lead was obtained.campaignmember
campaignmember_nameTEXTCampaign Member NameCampaign Member First and last name of the contact or lead with which the campaign member is associated.campaignmember
campaignmember_postal_codeTEXTCampaign Member PostalCodeCampaign Member The postal code of the lead or contact.campaignmember
campaignmember_salutationTEXTCampaign Member SalutationCampaign Member Salutation for the lead or contact.campaignmember
campaignmember_stateTEXTCampaign Member StateCampaign Member The state for the address of the lead or contact. Limit is 80 characters.campaignmember
campaignmember_statusTEXTCampaign Member StatusCampaign Member Controls the HasResponded flag on this object. You can't directly set the HasResponded flag, as it’s read-only. You can set it indirectly by setting this field in a create or update call. Each predefined value implies a HasResponded flag value. Each time you update this field, you implicitly update the HasResponded flag. In the Salesforce user interface, Marketing users can define valid status values for the Status Text. They can choose one status as the default status. For each Status field value, they can also select which values to count as “Responded,” meaning that the HasResponded flag is set to true for those values. 40 character limit.campaignmember
campaignmember_streetTEXTCampaign Member StreetCampaign Member The street for the address of the lead or contact.campaignmember
campaignmember_titleTEXTCampaign Member TitleCampaign Member Title for the lead or contact.campaignmember
campaignmember_typeTEXTCampaign Member TypeIndicates whether the campaign member is a lead or a contact.campaignmember
contact_accountidTEXTContact Account IDID of the account that’s the parent of this contact.contact
contact_assistantnameTEXTContact Assistants NameThe assistant’s name.contact
contact_assistantphoneTEXTContact Assitants Phone NumberThe assistant’s telephone number.contact
contact_birthdateDATEContact BirthdateThe contact’s birthdate.contact
contact_createdbyTEXTContact Created ByThe user who created the contactcontact
contact_createddateDATEContact Creation DateThe Creation Date (Duplicate)contact
contact_dateDATEContact DateThe Creation Datecontact
contact_departmentTEXTContact DepartmentThe contact’s department.contact
contact_descriptionTEXTContact DescriptionContact's descriptioncontact
contact_emailTEXTContact EmailThe contact’s email address.contact
contact_emailbounceddateTIMESTAMPContact Email Bounced DateIf bounce management is activated and an email sent to the contact bounces, the date and time of the bounce.contact
contact_emailbouncedreasonTEXTContact Email Bounced ReasonIf bounce management is activated and an email sent to the contact bounces, the reason for the bounce.contact
contact_faxTEXTContact FaxThe contact’s fax number (Label is Business Fax).contact
contact_firstnameTEXTContact First NameThe contact’s first name (up to 40 characters).contact
contact_homephoneTEXTContact Home PhoneThe contact’s home telephone number.contact
contact_idTEXTContact IdThe Contact IDcontact
contact_isdeletedTEXTContact Is DeletedIs contact deletedcontact
contact_isemailbouncedTEXTContact Is Email BouncedContact's descriptioncontact
contact_lastactivitydateDATEContact Last Activity DateValue is the most recent of either: Due date of the most recent event logged against the record or due date of the most recently closed task associated with the record.contact
contact_lastmodifieddateTIMESTAMPContact Last Modified DateContact last modified datecontact
contact_lastnameTEXTContact Last NameRequiredLast name of the contact (up to 80 characters).contact
contact_leadsourceTEXTContact Lead SourceThe lead’s source.contact
contact_mailingcityCITYContact Mailing CityMailing address details.contact
contact_mailingcountryCOUNTRYContact Mailing CountryMailing country.contact
contact_mailingpostalcodeTEXTContact Mailing Postal CodeThe zip or postal code in the mailing addresscontact
contact_mailingstateTEXTContact Mailing StateMailing state details.contact
contact_mailingstreetTEXTContact Mailing StreetStreet address for mailing address.contact
contact_mobilephoneTEXTContact Mobile PhoneContact’s mobile phone number.contact
contact_nameTEXTContact NameContact full namecontact
contact_othercityCITYContact Other CityAlternative city details.contact
contact_othercountryCOUNTRYContact Other CountryAlternative country details.contact
contact_otherphoneTEXTContact Other PhoneTelephone for alternate address.contact
contact_otherpostalcodeTEXTContact Other Postal CodeAlternative postal code details.contact
contact_otherstateTEXTContact Other StateAlternate address details (state).contact
contact_otherstreetTEXTContact Other StreetStreet for alternate address.contact
contact_owneridTEXTContact Owner IDThe ID of the owner of the account associated with this contact.contact
contact_phoneTEXTContact Business PhoneTelephone number for the contactcontact
contact_reportstoidTEXTContact Reports to IDID of contact's managercontact
contact_salutationTEXTContact SalutationHonorific abbreviation, word, or phrase to be used in front of name in greetings, such as Dr. or Mrs.contact
contact_titleTEXTContact TitleTitle of the contact, such as CEO or Vice President.contact
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATELast Modified DateThe Last Modified Date of the selected Object
emailTEXTLead EmailLead Emaillead
lead_addressTEXTLead AddressLead Addresslead
lead_annual_revenueNUMERICLead Annual RevenueLead Annual Revenuelead
lead_cityCITYLead CityLead Citylead
lead_companyTEXTLead CompanyLead Companylead
lead_converted_account_idTEXTLead Converted Account IDLead Converted Account IDlead
lead_converted_contact_idTEXTLead Converted Contact IDLead Converted Contact IDlead
lead_converted_dateDATELead Converted DateLead Converted datelead
lead_converted_opportunity_idTEXTLead Converted Opportunity IDLead Converted Opportunity IDlead
lead_countNUMERICTotal number of leadsLeadslead
lead_countryCOUNTRYLead CountryLead Countrylead
lead_created_by_idTEXTLead Created By IDLead Created By IDlead
lead_created_dateDATELead Created DateLead Created datelead
lead_descriptionTEXTLead DescriptionLead Descriptionlead
lead_emailTEXTLead Email (duplicate)Lead Emaillead
lead_email_bounced_dateDATELead Email Bounced DateLead Email Bounced datelead
lead_email_bounced_reasonTEXTLead Email Bounced ReasonLead Email Bounced Reasonlead
lead_first_nameTEXTLead First NameLead First Namelead
lead_geocode_accuracyTEXTLead Geocode AccuracyLead Geocode Accuracylead
lead_idTEXTLead IDLead IDlead
lead_individual_idTEXTLead Individual IDLead Individual IDlead
lead_industryTEXTLead IndustryLead Industrylead
lead_is_convertedBOOLEANLead ConvertedLead Convertedlead
lead_is_deletedBOOLEANLead DeletedLead Deletedlead
lead_is_unread_by_ownerTEXTLead Unread By OwnerLead Unread By Ownerlead
lead_jigsawTEXTLead Data.com KeyLead Data.com Keylead
lead_jigsaw_contact_idTEXTLead Jigsaw Contact IDLead Jigsaw Contact IDlead
lead_last_activity_dateDATELead Last ActivityLead Last Activitylead
lead_last_modified_by_idTEXTLead Last Modified By IDLead Last Modified By IDlead
lead_last_modified_dateDATELead Last Modified DateLead Last Modified datelead
lead_last_nameTEXTLead Last NameLead Last Namelead
lead_last_referenced_dateDATELead Last Referenced DateLead Last Referenced datelead
lead_last_viewed_dateDATELead Last Viewed DateLead Last Viewed datelead
lead_latitudeNUMERICLead LatitudeLead Latitudelead
lead_lead_sourceTEXTLead SourceLead Sourcelead
lead_longitudeNUMERICLead LongitudeLead Longitudelead
lead_master_record_idTEXTLead Master Record IDLead Master Record IDlead
lead_nameTEXTLead Full NameLead Full Namelead
lead_number_of_employeesNUMERICLead EmployeesLead Employeeslead
lead_owner_idTEXTLead Owner IDLead Owner IDlead
lead_phoneTEXTLead PhoneLead Phonelead
lead_photo_urlTEXTLead Photo URLLead Photo URLlead
lead_postal_codeTEXTLead Zip/Postal CodeLead Zip/Postal Codelead
lead_ratingTEXTLead RatingLead Ratinglead
lead_salutationTEXTLead SalutationLead Salutationlead
lead_stateTEXTLead State/ProvinceLead State/Provincelead
lead_statusTEXTLead StatusLead Statuslead
lead_streetTEXTLead StreetLead Streetlead
lead_system_modstampTEXTLead System ModstampLead System Modstamplead
lead_titleTEXTLead TitleLead Titlelead
lead_websiteTEXTLead WebsiteLead Websitelead
opportunity_account_idTEXTOpportunity Account IDOpportunity Account IDopportunity
opportunity_amountNUMERICOpportunity AmountOpportunity Amountopportunity
opportunity_campaign_idTEXTOpportunity Campaign IDOpportunity Campaign IDopportunity
opportunity_close_dateDATEOpportunity Close DateOpportunity Close dateopportunity
opportunity_contact_idTEXTOpportunity Contact IDOpportunity Contact IDopportunity
opportunity_created_by_idTEXTOpportunity Created By IDOpportunity Created By IDopportunity
opportunity_created_dateDATEOpportunity Created DateOpportunity Created dateopportunity
opportunity_descriptionTEXTOpportunity DescriptionOpportunity Descriptionopportunity
opportunity_fiscalTEXTOpportunity Fiscal PeriodOpportunity Fiscal Periodopportunity
opportunity_fiscal_quarterNUMERICOpportunity Fiscal QuarterOpportunity Fiscal Quarteropportunity
opportunity_fiscal_yearNUMERICOpportunity Fiscal YearOpportunity Fiscal Yearopportunity
opportunity_forecast_categoryTEXTOpportunity Forecast CategoryOpportunity Forecast Categoryopportunity
opportunity_forecast_category_nameTEXTOpportunity Forecast Category NameOpportunity Forecast Category Nameopportunity
opportunity_has_open_activityBOOLEANOpportunity Has Open ActivityOpportunity Has Open Activityopportunity
opportunity_has_opportunity_line_itemBOOLEANOpportunity Has Line ItemOpportunity Has Line Itemopportunity
opportunity_has_overdue_taskBOOLEANOpportunity Has Overdue TaskOpportunity Has Overdue Taskopportunity
opportunity_idTEXTOpportunity IDOpportunity IDopportunity
opportunity_is_closedBOOLEANOpportunity ClosedOpportunity Closedopportunity
opportunity_is_deletedBOOLEANOpportunity DeletedOpportunity Deletedopportunity
opportunity_is_wonBOOLEANOpportunity WonOpportunity Wonopportunity
opportunity_last_activity_dateDATEOpportunity Last ActivityOpportunity Last Activityopportunity
opportunity_last_amount_changed_history_idDATEOpportunity Amount Changed History IDLast amount changed history IDopportunity
opportunity_last_close_date_changed_history_idTEXTOpportunity Last Close Date ChangedLast close date changed history Idopportunity
opportunity_last_modified_by_idTEXTOpportunity Last Modified By IDOpportunity Last Modified By IDopportunity
opportunity_last_modified_dateDATEOpportunity Last Modified DateOpportunity Last Modified dateopportunity
opportunity_last_referenced_dateDATEOpportunity Last Referenced DateOpportunity Last Referenced dateopportunity
opportunity_last_viewed_dateDATEOpportunity Last Viewed DateOpportunity Last Viewed dateopportunity
opportunity_lead_sourceTEXTOpportunity Lead SourceOpportunity Lead Sourceopportunity
opportunity_nameTEXTOpportunity NameOpportunity Nameopportunity
opportunity_next_stepTEXTOpportunity Next StepOpportunity Next Stepopportunity
opportunity_owner_idTEXTOpportunity Owner IDOpportunity Owner IDopportunity
opportunity_pricebook2_idTEXTOpportunity Price Book IDOpportunity Price Book IDopportunity
opportunity_probabilityNUMERICOpportunity Probability (%)Opportunity Probability (%)opportunity
opportunity_stage_nameTEXTOpportunity StageOpportunity Stageopportunity
opportunity_system_modstampTEXTOpportunity System ModstampOpportunity System Modstampopportunity
opportunity_typeTEXTOpportunity TypeOpportunity Typeopportunity
sourceTEXTSourceThe name of the Windsor connector returning the row
task_account_idTEXTTask Account IDTask Account IDtask
task_activity_dateDATETask Due Date OnlyTask Due Date Onlytask
task_call_dispositionTEXTTask Call ResultTask Call Resulttask
task_call_duration_in_secondsNUMERICTask Call DurationTask Call Durationtask
task_call_objectTEXTTask Call Object IdentifierTask Call Object Identifiertask
task_call_typeTEXTTask Call TypeTask Call Typetask
task_completed_date_timeDATETask Completed DateTask Completed datetask
task_created_by_idTEXTTask Created By IDTask Created By IDtask
task_created_dateDATETask Created DateTask Created datetask
task_descriptionTEXTTask DescriptionTask Descriptiontask
task_idTEXTTask Activity IDTask Activity IDtask
task_is_archivedBOOLEANTask ArchivedTask Archivedtask
task_is_closedBOOLEANTask ClosedTask Closedtask
task_is_deletedBOOLEANTask DeletedTask Deletedtask
task_is_high_priorityBOOLEANTask High PriorityTask High Prioritytask
task_is_recurrenceBOOLEANTask Create Recurring Series of TasksTask Create Recurring Series of Taskstask
task_is_reminder_setBOOLEANTask Reminder SetTask Reminder Settask
task_last_modified_by_idTEXTTask Last Modified By IDTask Last Modified By IDtask
task_last_modified_dateDATETask Last Modified DateTask Last Modified datetask
task_owner_idTEXTTask Assigned To IDTask Assigned To IDtask
task_priorityTEXTTask PriorityTask Prioritytask
task_recurrence_activity_idTEXTTask Recurrence Activity IDTask Recurrence Activity IDtask
task_recurrence_day_of_monthNUMERICTask Recurrence Day of MonthTask Recurrence Day of Monthtask
task_recurrence_day_of_week_maskNUMERICTask Recurrence Day of Week MaskTask Recurrence Day of Week Masktask
task_recurrence_end_date_onlyTEXTTask Recurrence EndTask Recurrence Endtask
task_recurrence_instanceTEXTTask Recurrence InstanceTask Recurrence Instancetask
task_recurrence_intervalNUMERICTask Recurrence IntervalTask Recurrence Intervaltask
task_recurrence_month_of_yearTEXTTask Recurrence Month of YearTask Recurrence Month of Yeartask
task_recurrence_regenerated_typeTEXTTask Repeat This TaskTask Repeat This Tasktask
task_recurrence_start_date_onlyTEXTTask Recurrence StartTask Recurrence Starttask
task_recurrence_time_zone_sid_keyTEXTTask Recurrence Time ZoneTask Recurrence Time Zonetask
task_recurrence_typeTEXTTask Recurrence TypeTask Recurrence Typetask
task_reminder_date_timeTEXTTask Reminder Date/TimeTask Reminder Date/Timetask
task_statusTEXTTask StatusTask Statustask
task_subjectTEXTTask SubjectTask Subjecttask
task_system_modstampTEXTTask System ModstampTask System Modstamptask
task_task_subtypeTEXTTask SubtypeTask Subtypetask
task_what_idTEXTTask Related To IDTask Related To IDtask
task_who_idTEXTTask Name IDTask Name IDtask
todayDATETodayToday's date