Opps Histories

CRM entity for original opportunity history records enriched with TrueAI predictive insights.

Fields

Entity	Field Name	Display Name	Data Type	Field Length	Description	Deprecated	Field Name Sfdc	Field Name Msdyn
opps_histories	_sys_as_of	As of Date	DATETIME		The date of the last data request from the platform	false	SystemModstamp
opps_histories	_sys_doc_id	Doc ID	STRING	50	Unique record identifier, based on the ID of the opp in the remote system (such as Salesforce ID) and date	false	Id
opps_histories	_sys_filt_end_date	Filter End Date	DATE		The end date of the record, stripped of time	false
opps_histories	_sys_filt_start_date	Filter Start Date	DATE		The start date of the record, stripped of time	false
opps_histories	crm_booking_amt	CRM Booking Amount	CURRENCY		Opportunity history record's booking amount in the CRM	false	Amount
opps_histories	crm_close_date	CRM Close Date	DATETIME		Opportunity history record's close date in the CRM	false	CloseDate
opps_histories	crm_created_on	CRM Created On	DATETIME		Opportunity history record's creation date in the CRM	false	CreatedDate
opps_histories	crm_creator_id	CRM Creator ID	STRING	50	Opportunity history record's creator's id in the CRM	false	CreatedById
opps_histories	crm_opp_id	CRM Opp ID	STRING	50	Opportunity history record's id in the CRM	false	OpportunityId
opps_histories	crm_pipeline_id	CRM Pipeline ID	STRING	50	CRM pipeline id of the opportunity history record history record	false
opps_histories	crm_pipeline_name	CRM Pipeline Name	STRING	50	CRM pipeline name of the opportunity history record history record	false
opps_histories	crm_stage_id	CRM Stage ID	STRING	50	Opportunity history record's stage ID in the CRM	false	StageName
opps_histories	crm_stage_name	CRM Stage Name	STRING	50	Opportunity history record's stage name in the CRM	false	StageName
opps_histories	crm_stage_num	CRM Stage Num	STRING	50	Opportunity history record's stage number in the CRM	false	Probability
opps_histories	cust_bool1	cust_bool1	BOOLEAN		cust_bool1	false
opps_histories	cust_bool2	cust_bool2	BOOLEAN		cust_bool2	false
opps_histories	cust_num1	cust_num1	FLOAT		cust_num1	false
opps_histories	cust_num2	cust_num2	FLOAT		cust_num2	false
opps_histories	cust_num3	cust_num3	FLOAT		cust_num3	false
opps_histories	cust_num4	cust_num4	FLOAT		cust_num4	false
opps_histories	cust_num5	cust_num5	FLOAT		cust_num5	false
opps_histories	cust_num6	cust_num6	FLOAT		cust_num6	false
opps_histories	cust_num7	cust_num7	FLOAT		cust_num7	false
opps_histories	cust_text1	cust_text1	STRING	50	cust_text1	false
opps_histories	cust_text2	cust_text2	STRING	50	cust_text2	false
opps_histories	cust_text3	cust_text3	STRING	50	cust_text3	false
opps_histories	cust_text4	cust_text4	STRING	50	cust_text4	false
opps_histories	cust_text5	cust_text5	STRING	50	cust_text5	false
opps_histories	trueai_act_adj_dur	Activities Adj Duration	FLOAT		Activities Adj Duration	false
opps_histories	trueai_act_adj_dur_rule	Activities Adj Duration Rule	INTEGER		Activities Adj Duration Rule	false
opps_histories	trueai_act_adj_eng_dur	Activities Adj Engaged Duration	FLOAT		Activities Adj Engaged Duration	false
opps_histories	trueai_act_count	Activities Count	INTEGER		Activities Count	false
opps_histories	trueai_act_dur	Activities Duration	FLOAT		Activities Duration	false
opps_histories	trueai_act_eng_count	Activities Engaged Count	INTEGER		Activities Engaged Count	false
opps_histories	trueai_act_eng_dur	Activities Engaged Duration	FLOAT		Activities Engaged Duration	false
opps_histories	trueai_act_type_auto_email_count	Activities Automated Email Count	INTEGER		Activities Automated Email Count	false
opps_histories	trueai_act_type_auto_email_dur	Activities Automated Email Duration	FLOAT		Activities Automated Email Duration	false
opps_histories	trueai_act_type_auto_email_eng_count	Activities Automated Email Engaged Count	INTEGER		Activities Automated Email Engaged Count	false
opps_histories	trueai_act_type_call_count	Activities Call Count	INTEGER		Activities Call Count	false
opps_histories	trueai_act_type_call_dur	Activities Call Duration	FLOAT		Activities Call Duration	false
opps_histories	trueai_act_type_call_eng_count	Activities Call Engaged Count	INTEGER		Activities Call Engaged Count	false
opps_histories	trueai_act_type_email_count	Activities Email Count	INTEGER		Activities Email Count	false
opps_histories	trueai_act_type_email_dur	Activities Email Duration	FLOAT		Activities Email Duration	false
opps_histories	trueai_act_type_email_eng_count	Activities Email Engaged Count	INTEGER		Activities Email Engaged Count	false
opps_histories	trueai_act_type_meeting_count	Activities Meeting Count	INTEGER		Activities Meeting Count	false
opps_histories	trueai_act_type_meeting_dur	Activities Meeting Durationuratin	FLOAT		Activities Meeting Durationuratin	false
opps_histories	trueai_act_type_meeting_eng_count	Activities Meeting Engaged Count	INTEGER		Activities Meeting Engaged Count	false
opps_histories	trueai_act_type_nd_count	Activities Non Determinable Count	INTEGER		Activities Non Determinable Count	false
opps_histories	trueai_act_type_nd_dur	Activities Non Determinable Duration	FLOAT		Activities Non Determinable Duration	false
opps_histories	trueai_act_type_nd_eng_count	Activities Non Determinable Engaged Count	INTEGER		Activities Non Determinable Engaged Count	false
opps_histories	trueai_act_type_no_interaction_count	Activities No Interaction Count	INTEGER		Activities No Interaction Count	false
opps_histories	trueai_act_type_no_interaction_dur	Activities No Interaction Duration	FLOAT		Activities No Interaction Duration	false
opps_histories	trueai_act_type_no_interaction_eng_count	Activities No Interaction Engaged Count	INTEGER		Activities No Interaction Engaged Count	false
opps_histories	trueai_act_type_social_count	Activities Social Count	INTEGER		Activities Social Count	false
opps_histories	trueai_act_type_social_dur	Activities Social Duration	FLOAT		Activities Social Duration	false
opps_histories	trueai_act_type_social_eng_count	Activities Social Engaged Count	INTEGER		Activities Social Engaged Count	false
opps_histories	trueai_booking_amt	Booking Amount	CURRENCY		Opportunity history record's booking amount	false
opps_histories	trueai_booking_amt_currency_rule	Booking Amount Currency Rule	INTEGER		Opportunity history record's booking amount currency conversion rule	false
opps_histories	trueai_booking_amt_rule	Booking Amount Rule	INTEGER		Opportunity history record's booking amount rule related to the presence or absence of opp line items and custom mappings	false
opps_histories	trueai_can_be_excluded	Can Be Excluded	BOOLEAN		Boolean flag that indicates whether the record is redundant	false
opps_histories	trueai_current_prob_of_win	Current Probability of Win	FLOAT		Current probability of win of the opportunity history record history record	false
opps_histories	trueai_is_closed	Is Closed	BOOLEAN		Boolean flag that indicates whether the opportunity history record history record is closed	false
opps_histories	trueai_is_won	Is Won	BOOLEAN		Boolean flag that indicates whether the opportunity history record history record is won	false
opps_histories	trueai_owner_act_capt_lvl	Stage Owner Activity Capture Level	FLOAT		Stage Owner Activity Capture Level	false
opps_histories	trueai_owner_act_capt_lvl_conf	Stage Owner Activity Capture Level Confidence	FLOAT		Stage Owner Activity Capture Level Confidence	false
opps_histories	trueai_owner_prep_factor	Stage Owner Prep Factor	FLOAT		Stage Owner Prep Factor	false
opps_histories	trueai_pipeline_name	Pipeline Name	STRING	150	Pipeline name of the opportunity history record history record	false
opps_histories	trueai_stage	Normalized Stage	STRING	50	Opportunity history record's normalized stage	false
opps_histories	trueai_stage_id	Stage ID	STRING	150	Opportunity history record's stage ID	false
opps_histories	trueai_stage_name	Stage Name	STRING	150	Opportunity history record's stage name	false
opps_histories	trueai_step_sequence	Step Sequence	INTEGER		Ordinal number based on the position of the step in the sequence	false

Rules

Model	Rule Name	Sys Doc Id	Description	Is Default Rule
OppsHistoryBookingAmt	SCALED_BASED_ON_OPP_FINAL_AMT	139001	Final opp history amount differs from opp booking amount, scaling accordingly	false
OppsHistoryBookingAmt	NO_SCALING_APPLIED	139002	Final opp history amount is the same as the opp booking amount, no scaling applied	true
OppsHistoryBookingAmt	SCALING_NOT_POSSIBLE	139003	Final opp history amount is missing or zero, no scaling applied	false