Connect Xactly Incent Tables

The following are Xactly tables that  provide read-only access to Incent application tables

Commission

  • xc_commission
  • xc_commission_summary
  • xc_comp_order_item
  • xc_comp_order_item_detail
  • xc_co_item_asgnmt

Commission Release

  • xc_commission_held
  • xc_comm_rel_part
  • xc_comm_totals
  • xc_release_group
  • xc_release_status

Company Data

  • xc_customer
  • xc_geography
  • xc_product

Credit

  • xc_credit
  • xc_credit_asjustment
  • xc_credit_held
  • xc_credit_totals

Document Routing

  • xbpm_order_adjusmtents
  • xbpm_approval_res_instance
  • xbpm_appproval_sub_res_instance
  • xbpm_approval_doc_instance
  • xbpm_approval_document

Draw

  • xc_draw
  • xc_draw_assignment

History

  • xc_participant_hist
  • xc_plan_assignment_hist
  • xc_pos_hierarchy_hist
  • xc_pos_hierarchy_type_hist
  • xc_pos_part_assignment_hist
  • xc_pos_rel_type_hist
  • xc_pos_title_assignment_hist
  • xc_position_hist
  • xc_quota_assignment_hist
  • xc_quota_hist
  • xc_user_hist

Lookup

  • xc_lookup_dimension
  • xc_lookup_dimension_cell_value
  • xc_lookup_dimension_value
  • xc_mdlt
  • xc_mdlt_dimension
  • xc_mdlt_dimension_metadata
  • xc_mdlt_version_data

MISC.

  • xc_batch_type
  • xc_batch_type_Category
  • xc_bonus
  • xc_earning_code
  • xc_finalize_business_group
  • xc_finalize_payment
  • xc_flex_field_asgnment
  • xc_flex_field_asgnment_evv
  • xc_formula
  • xc_participant
  • xc_part_user_asgnment
  • xc_process_status
  • xc_rule
  • xc_rule_references
  • xc_tw_entity_fields

Order

  • xc_order_stage
  • xc_order_stage_asgnment
  • xc_order_stage_errors

Organization

  • xc_pos_part_assignment
  • xc_pos_title_assignment
  • xc_plan_design_asgnmt
  • xc_pos_rel_type
  • xc_pos_relations
  • xc_pos_hierachy_type
  • xc_pos_hierachy

Payment

  • xc_payment
  • xc_payment_balance_trace

Plan

  • xc_plan
  • xc_plan_approval
  • xc_plan_assignment
  • xc_plan_design_asgnment
  • xc_planrules

Quota

  • xc_quota
  • xc_quota_assignment
  • xc_quota_relationship
  • xc_quota_summary
  • xc_quota_totals

Rate Table

  • xc_ratetable
  • xc_rate_table_comments
  • xc_rate_table_tier
  • xc_rate_tier_values

Role/User/Title

  • xc_role
  • xc_user_role
  • xc_title
  • xc_title_category
  • xc_user
  • xc_user_batch
  • xc_version_reason_type

Setup

  • xc_business_group
  • xc_calendar
  • xc_period
  • xc_period_type

Setup – Configure

  • xc_credit_type
  • xc_earning_group
  • xc_emp_status_code
  • xc_order_type
  • xc_reason_code
  • xc_unit_type

Summary

  • xc_order_summary
  • xc_credit_summary
  • xc_payment_summary

 

This is a working page as we are always updating available tables. To retrieve the list of schemas within a given environment, use SHOW SCHEMAS.

show schemas;

show_schemas

If you do not see a  required table, please reach out to Xactly Support to have the table requested.