Oracle Fusion Cloud Applications - CRM

Explore the interactive ERD

Table & Field Reference

earning_history_extract_pvo

Column	Type	Keys
`earning_history_id`	Long	PK
`additional_data_`	String

opportunity_time_based_snapshot_extract_pvo

Column	Type	Keys
`opportunity_time_based_snapshot_id`	Long	PK
`additional_data_`	String

srp_form_metric_extract_pvo

Column	Type	Keys
`srp_form_metric_id`	Long	PK
`additional_data_`	String

pay_group_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`pay_group_translation_id`	Long

comp_plan_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`comp_plan_translation_id`	Long

plan_component_formula_extract_pvo

Column	Type	Keys
`plan_component_formula_id`	Long	PK
`additional_data_`	String

web_activity_extract_pvo

Column	Type	Keys
`web_activity_id`	Long	PK
`additional_data_`	String

formula_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`formula_translation_id`	Long

comp_role_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`comp_role_translation_id`	Long

sales_account_territory_extract_pvo

Column	Type	Keys
`sales_account_territory_id`	Long	PK
`additional_data_`	String

opportunity_competitor_extract_pvo

Column	Type	Keys
`opty_competitor_id`	Long	PK
`additional_data_`	String
`cmpt_party_id`	Long
`opty_id`	Long

lead_tc_member_extract_pvo

Column	Type	Keys
`lead_tc_member_id`	Long	PK
`additional_data_`	String

participant_role_extract_pvo

Column	Type	Keys
`participant_role_id`	Long	PK
`additional_data_`	String

payment_plan_extract_pvo

Column	Type	Keys
`payment_plan_id`	Long	PK
`additional_data_`	String

revenue_territory_extract_pvo

Column	Type	Keys
`revenue_territory_id`	Long	PK
`additional_data_`	String

lead_item_assoc_extract_pvo

Column	Type	Keys
`lead_item_assoc_id`	Long	PK
`additional_data_`	String

participant_detail_extract_pvo

Column	Type	Keys
`participant_detail_id`	Long	PK
`additional_data_`	String

paysheet_extract_pvo

Column	Type	Keys
`paysheet_id`	Long	PK
`additional_data_`	String

sales_stage_extract_pvo

Column	Type	Keys
`stg_id`	Long	PK
`additional_data_`	String
`sales_method_id`	Long
`sales_stage_trnsltn_stg_id`	Long

credit_history_extract_pvo

Column	Type	Keys
`credit_history_id`	Long	PK
`additional_data_`	String

opportunity_resource_extract_pvo

Column	Type	Keys
`opty_resource_id`	Long	PK
`additional_data_`	String
`asgn_territory_version_id`	Long
`opty_id`	Long
`partner_org_id`	Long
`resource_id`	Long

channel_via_extract_pvo

Column	Type	Keys
`channel_via_id`	Long	PK
`additional_data_`	String

revenue_time_based_snapshot_extract_pvo

Column	Type	Keys
`revenue_time_based_snapshot_id`	Long	PK
`additional_data_`	String

opportunity_extract_pvo

Column	Type	Keys
`opty_id`	Long	PK
`additional_data_`	String
`asset_id`	Long
`bu_org_id`	Long
`curr_stg_id`	Long
`cust_account_id`	Long
`cust_party_id`	Long
`deal_horizon_code_set_id`	Long
`decision_lvl_code_set_id`	Long
`group_space_id`	Long
`ibasset_id`	Long
`opty_party_site_id`	Long
`owner_resource_id`	Long
`par_opty_id`	Long
`pr_cmpt_party_id`	Long
`pr_con_party_id`	Long
`pr_con_relationship_id`	Long
`primary_campaign_id`	Long
`primary_partner_id`	Long
`reason_won_lost_cd_set_id`	Long
`risk_lvl_code_set_id`	Long
`sales_account_id`	Long
`sales_method_id`	Long
`status_cd_set_id`	Long
`strategic_value_code_set_id`	Long
`sum_revn_id`	Long

participant_extract_pvo

Column	Type	Keys
`participant_id`	Long	PK
`additional_data_`	String

pay_run_extract_pvo

Column	Type	Keys
`pay_run_id`	Long	PK
`additional_data_`	String

interval_type_extract_pvo

Column	Type	Keys
`interval_type_id`	Long	PK
`additional_data_`	String

sales_method_extract_pvo

Column	Type	Keys
`sales_method_id`	Long	PK
`additional_data_`	String

snapshot_extract_pvo

Column	Type	Keys
`snapshot_id`	Long	PK
`additional_data_`	String

territory_extract_pvo

Column	Type	Keys
`territory_id`	Long	PK
`additional_data_`	String

measure_result_extract_pvo

Column	Type	Keys
`measure_result_id`	Long	PK
`additional_data_`	String

formula_extract_pvo

Column	Type	Keys
`formula_id`	Long	PK
`additional_data_`	String

channel_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`channel_translation_id`	Long

participant_comp_plan_extract_pvo

Column	Type	Keys
`participant_comp_plan_id`	Long	PK
`additional_data_`	String

revenue_extract_pvo

Column	Type	Keys
`revn_id`	Long	PK
`additional_data_`	String
`bu_org_id`	Long
`close_reason_code_set_id`	Long
`cr_rcpt_part_org_party_id`	Long
`cust_account_id`	Long
`cust_party_id`	Long
`inventory_item_id`	Long
`inventory_org_id`	Long
`opty_id`	Long
`opty_lead_id`	Long
`owner_resource_id`	Long
`parent_revn_id`	Long
`pr_cmpt_party_id`	Long
`pr_cmpt_product_id`	Long
`pr_part_org_party_id`	Long
`pr_territory_updated_by_id`	Long
`pr_territory_version_id`	Long
`prod_group_id`	Long
`recur_parent_revn_id`	Long
`sales_account_id`	Long
`split_parent_revn_id`	Long
`status_code_set_id`	Long
`type_code_set_id`	Long

credit_extract_pvo

Column	Type	Keys
`credit_id`	Long	PK
`additional_data_`	String

srp_period_goal_extract_pvo

Column	Type	Keys
`srp_period_goal_id`	Long	PK
`additional_data_`	String

lead_resource_extract_pvo

Column	Type	Keys
`lead_resource_id`	Long	PK
`additional_data_`	String

campaign_member_extract_pvo

Column	Type	Keys
`campaign_member_id`	Long	PK
`additional_data_`	String

sales_stage_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`sales_stage_translation_id`	Long

transaction_history_extract_pvo

Column	Type	Keys
`transaction_history_id`	Long	PK
`additional_data_`	String

lead_territory_assoc_extract_pvo

Column	Type	Keys
`lead_territory_assoc_id`	Long	PK
`additional_data_`	String

srp_interval_goal_extract_pvo

Column	Type	Keys
`srp_interval_goal_id`	Long	PK
`additional_data_`	String

transaction_extract_pvo

Column	Type	Keys
`transaction_id`	Long	PK
`additional_data_`	String

territory_coverage_extract_pvo

Column	Type	Keys
`territory_coverage_id`	Long	PK
`additional_data_`	String

participant_subledger_extract_pvo

Column	Type	Keys
`participant_subledger_id`	Long	PK
`additional_data_`	String

channel_extract_pvo

Column	Type	Keys
`additional_data_`	String

territory_hierarchy_column_flatten_extract_pvo

Column	Type	Keys
`territory_hierarchy_column_flatten_id`	Long	PK
`additional_data_`	String

participant_plan_component_extract_pvo

Column	Type	Keys
`participant_plan_component_id`	Long	PK
`additional_data_`	String

category_hierarchy_flatten_extract_pvo

Column	Type	Keys
`category_hierarchy_flatten_id`	Long	PK
`additional_data_`	String

opty_stg_snapshot_extract_pvo

Column	Type	Keys
`opty_stg_snapshot_id`	Long	PK
`additional_data_`	String

category_extract_pvo

Column	Type	Keys
`category_id`	Long	PK
`additional_data_`	String

opportunity_contact_extract_pvo

Column	Type	Keys
`opty_con_id`	Long	PK
`additional_data_`	String
`opty_id`	Long
`per_party_id`	Long
`relationship_id`	Long

lead_extract_pvo

Column	Type	Keys
`lead_id`	Long	PK
`additional_data_`	String

sales_method_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`sales_method_translation_id`	Long

comp_role_extract_pvo

Column	Type	Keys
`comp_role_id`	Long	PK
`additional_data_`	String

sales_account_extract_pvo

Column	Type	Keys
`sales_account_id`	Long	PK
`account_director_id`	Long
`additional_data_`	String
`location_id`	Long
`party_id`	Long
`pr_con_party_id`	Long
`sell_to_party_site_id`	Long

interaction_ref_extract_pvo

Column	Type	Keys
`interaction_ref_id`	Long	PK
`additional_data_`	String

sales_account_resource_extract_pvo

Column	Type	Keys
`sales_account_resource_id`	Long	PK
`additional_data_`	String

srp_goal_extract_pvo

Column	Type	Keys
`srp_goal_id`	Long	PK
`additional_data_`	String

interval_type_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`interval_type_translation_id`	Long

access_group_member_extract_pvo

Column	Type	Keys
`access_group_member_id`	Long	PK
`additional_data_`	String

service_request_extract_pvo

Column	Type	Keys
`service_request_id`	Long	PK
`additional_data_`	String

category_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`category_translation_id`	Long

interaction_extract_pvo

Column	Type	Keys
`interaction_id`	Long	PK
`additional_data_`	String

participant_pay_extract_pvo

Column	Type	Keys
`participant_pay_id`	Long	PK
`additional_data_`	String

earning_extract_pvo

Column	Type	Keys
`earning_id`	Long	PK
`additional_data_`	String

comp_plan_extract_pvo

Column	Type	Keys
`comp_plan_id`	Long	PK
`additional_data_`	String

pay_group_extract_pvo

Column	Type	Keys
`pay_group_id`	Long	PK
`additional_data_`	String

queue_extract_pvo

Column	Type	Keys
`queue_id`	Long	PK
`additional_data_`	String

interaction_wrapup_extract_pvo

Column	Type	Keys
`interaction_wrapup_id`	Long	PK
`additional_data_`	String

period_dim_extract_pvo

Column	Type	Keys
`period_dim_id`	Long	PK
`additional_data_`	String

srp_period_form_metric_extract_pvo

Column	Type	Keys
`srp_period_form_metric_id`	Long	PK
`additional_data_`	String

opportunity_lead_extract_pvo

Column	Type	Keys
`opty_lead_id`	Long	PK
`additional_data_`	String
`deal_part_program_id`	Long
`opty_id`	Long
`pr_deal_part_org_party_id`	Long
`pr_deal_part_res_party_id`	Long

opportunity_campaign_extract_pvo

Column	Type	Keys
`opportunity_campaign_id`	Long	PK
`additional_data_`	String

account_access_extract_pvo

Column	Type	Keys
`account_access_id`	Long	PK
`additional_data_`	String

campaign_extract_pvo

Column	Type	Keys
`campaign_id`	Long	PK
`additional_data_`	String

payment_plan_translation_extract_pvo

Column	Type	Keys
`additional_data_`	String
`payment_plan_translation_id`	Long

interaction_agg_extract_pvo

Column	Type	Keys
`interaction_agg_id`	Long	PK
`additional_data_`	String

territory_resource_extract_pvo

Column	Type	Keys
`territory_resource_id`	Long	PK
`additional_data_`	String

object_share_extract_pvo

Column	Type	Keys
`object_share_id`	Long	PK
`additional_data_`	String