Xactly

Explore the interactive ERD

Table & Field Reference

payment

Column	Type	Keys
`payment_id`	String	PK
`amount_unit_type_id`	String	FK
`bus_amount_unit_type_id`	String	FK
`bus_group_amount_unit_type_id`	String	FK
`credit_id`	String	FK
`eff_participant_id`	String	FK
`eff_position_id`	String	FK
`item_pay_curr_unit_type_id`	String	FK
`local_currency_unit_type_id`	String	FK
`order_item_id`	String	FK
`participant_id`	String	FK
`payment_curr_unit_type_id`	String	FK
`period_id`	String	FK
`position_id`	String	FK
`amount_display_symbol`	Unknown
`conversion_rate`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`customer_id`	Unknown
`earning_group_id`	Unknown
`geography_id`	Unknown
`is_active`	Unknown
`item_code`	Unknown
`mgr_eff_part_id`	Unknown
`mgr_eff_pos_id`	Unknown
`modified_by_id`	Unknown
`modified_date`	Instant
`name`	Unknown
`order_code`	Unknown
`payment_flag`	Unknown
`product_id`	Unknown
`run_id`	Unknown
`trans_id`	Unknown

credit

Column	Type	Keys
`credit_id`	String	PK
`amount_unit_type_id`	String	FK
`business_group_id`	String	FK
`credit_type_id`	String	FK
`eff_participant_id`	String	FK
`eff_position_id`	String	FK
`order_item_id`	String	FK
`participant_id`	String	FK
`period_id`	String	FK
`plan_id`	String	FK
`position_id`	String	FK
`rule_id`	String	FK
`source_credit_id`	String	FK
`source_position_id`	String	FK
`src_pos_relation_type_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`customer_id`	Unknown
`geography_id`	Unknown
`is_active`	Unknown
`item_code`	Unknown
`modified_by_id`	Unknown
`modified_date`	Instant
`name`	Unknown
`order_code`	Unknown
`product_id`	Unknown
`reason_code_id`	Unknown
`release_group_id`	Unknown
`run_id`	Unknown
`trans_id`	Unknown

title_category

Column	Type	Keys
`category_name`	String	PK
`ui_category_name`	Unknown

commission_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`amount_unit_type_id`	String	FK
`as_of_period_id`	String	FK
`business_group_id`	String	FK
`participant_id`	String	FK
`period_id`	String	FK
`earning_group_name`	Unknown
`ever_on_hold`	Unknown
`held_amount`	Unknown
`is_held`	Unknown
`name`	Unknown
`released_amount`	Unknown
`total_amount`	Unknown

commission

Column	Type	Keys
`commission_id`	String	PK
`amount_unit_type_id`	String	FK
`attainment_value_unit_type_id`	String	FK
`business_group_id`	String	FK
`credit_id`	String	FK
`credit_type_id`	String	FK
`credit_unit_type_id`	String	FK
`eff_participant_id`	String	FK
`eff_position_id`	String	FK
`measure_value_unit_type_id`	String	FK
`order_item_id`	String	FK
`participant_id`	String	FK
`period_id`	String	FK
`plan_id`	String	FK
`position_id`	String	FK
`quota_id`	String	FK
`quota_period_type_id`	String	FK
`rate_amount_unit_type_id`	String	FK
`rule_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`customer_id`	Unknown
`earning_group_id`	Unknown
`geography_id`	Unknown
`is_active`	Unknown
`item_code`	Unknown
`modified_by_id`	Unknown
`modified_date`	Instant
`name`	Unknown
`order_code`	Unknown
`product_id`	Unknown
`rate_table_id`	Unknown
`reason_code_id`	Unknown
`run_id`	Unknown
`source`	Unknown
`trans_id`	Unknown

credit_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`amount_unit_type_id`	String	FK
`as_of_period_id`	String	FK
`business_group_id`	String	FK
`eff_position_id`	String	FK
`participant_id`	String	FK
`period_id`	String	FK
`position_id`	String	FK
`credit_type_name`	Unknown
`ever_on_hold`	Unknown
`is_held`	Unknown
`name`	Unknown
`total_amount`	Unknown

quota_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`amount_unit_type_id`	String	FK
`as_of_period_id`	String	FK
`business_group_id`	String	FK
`eff_position_id`	String	FK
`participant_id`	String	FK
`period_id`	String	FK
`position_id`	String	FK
`quota_id`	String	FK
`name`	Unknown
`total_amount`	Unknown

rate_tier_value

Column	Type	Keys
`rate_tier_values_id`	String	PK
`effective_end_period_id`	String	FK
`effective_start_period_id`	String	FK
`rate_table_tier_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`element_id`	Unknown
`element_name`	Unknown
`element_type`	Unknown
`formula_expression`	Unknown
`formula_id`	Unknown
`formula_name`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`rate_type`	Unknown
`tier_rate`	Unknown
`version`	Unknown

plan_rule

Column	Type	Keys
`planrules_id`	String	PK
`plan_id`	String	FK
`rule_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

rate_table

Column	Type	Keys
`rate_table_id`	String	PK
`attainment_ut_disp_sym`	Unknown
`attainment_ut_id`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`source_id`	Unknown
`version`	Unknown

pos_part_assignment

Column	Type	Keys
`pos_part_assignment_id`	String	PK
`participant_id`	String	FK
`position_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

pos_relation_history

Column	Type	Keys
`id`	String	PKFK
`from_pos_id`	String	FK
`pos_rel_type_id`	String	FK
`to_pos_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`object_id`	Unknown
`version`	Unknown

participant

Column	Type	Keys
`participant_id`	String	PK
`business_group_id`	String	FK
`native_cur_unit_type_id`	String	FK
`obj_bonus_target_unittype_id`	String	FK
`payment_cur_unit_type_id`	String	FK
`pr_target_unit_type_id`	String	FK
`salary_unit_type_id`	String	FK
`user_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`department`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`emp_status_id`	Unknown
`employee_id`	Unknown
`is_active`	Unknown
`manager_emp_id`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`participant_type`	Unknown
`payroll_id`	Unknown
`source_id`	Unknown
`version_reason_id`	Unknown
`version_sub_reason_id`	Unknown

draw_assignment

Column	Type	Keys
`draw_assignment_id`	String	PK
`business_group_id`	String	FK
`draw_id`	String	FK
`eff_participant_id`	String	FK
`eff_position_id`	String	FK
`participant_id`	String	FK
`period_id`	String	FK
`assignment_id`	Unknown
`assignment_name`	Unknown
`assignment_type`	Unknown
`balance`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`finalized_by`	Unknown
`finalized_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`pay_amount`	Unknown
`person_name`	Unknown
`position_name`	Unknown
`preview_balance`	Unknown
`projected_amount`	Unknown
`recovery_percent`	Unknown
`version`	Unknown

rate_table_tier

Column	Type	Keys
`rate_table_tier_id`	String	PK
`rate_table_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`default_rate`	Unknown
`formula_expression`	Unknown
`formula_name`	Unknown
`high_value`	Unknown
`is_active`	Unknown
`low_value`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`rate_type`	Unknown
`tier_name`	Unknown
`tier_number`	Unknown
`version`	Unknown

quota

Column	Type	Keys
`quota_id`	String	PK
`quota_period_id`	String	FK
`quota_value_unit_type_id`	String	FK
`classification_name`	Unknown
`classification_type`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`quota_interval_id`	Unknown
`quota_value`	Unknown
`source_id`	Unknown
`version`	Unknown

quota_total

Column	Type	Keys
`quota_totals_id`	String	PK
`participant_id`	String	FK
`period_id`	String	FK
`position_id`	String	FK
`unittype_id`	String	FK
`amount`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

plan_approval

Column	Type	Keys
`plan_approval_id`	String	PK
`business_group_id`	String	FK
`plan_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`doc_template_id`	Unknown
`document`	Unknown
`is_active`	Unknown
`manager_id`	Unknown
`mgr_acpt_date`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`per_acpt_date`	Unknown
`person_id`	Unknown
`route_date`	Unknown
`route_id`	Unknown
`status`	Unknown
`version`	Unknown

order_type

Column	Type	Keys
`order_type_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`is_active`	Unknown
`is_ordertype_shown`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

plan

Column	Type	Keys
`plan_id`	String	PK
`period_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

quota_relationship

Column	Type	Keys
`quota_relationship_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`is_active`	Unknown
`label`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

pos_title_assignment

Column	Type	Keys
`pos_title_assignment_id`	String	PK
`position_id`	String	FK
`title_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

period

Column	Type	Keys
`period_id`	String	PK
`parent_period_id`	String	FK
`period_type_id_fk`	String	FK
`calendar_id`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`end_date`	Unknown
`is_active`	Unknown
`is_calc_period`	Unknown
`is_etl_excluded`	Unknown
`is_hidden`	Unknown
`is_open`	Unknown
`is_published`	Unknown
`is_visible`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`order_number`	Unknown
`start_date`	Unknown
`version`	Unknown

attainment_measure

Column	Type	Keys
`attainment_measure_id`	String	PK
`effective_end_period_id`	String	FK
`effective_start_period_id`	String	FK
`master_attainment_measure_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`history_uuid`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`period_type`	Unknown
`version`	Unknown

co_item_assignment

Column	Type	Keys
`comp_order_assignment_id`	String	PK
`comp_order_item_id`	String	FK
`order_type_id`	String	FK
`participant_id`	String	FK
`period_id`	String	FK
`split_amount_unit_type_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`split_amount`	Unknown
`split_amount_pct`	Unknown
`upload_id`	Unknown
`version`	Unknown

credit_type

Column	Type	Keys
`credit_type_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

users

Column	Type	Keys
`user_id`	String	PK
`business_group_id`	String	FK
`accepted_contract`	Unknown
`activated_date`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_date`	Unknown
`email`	Unknown
`enabled`	Unknown
`eu_migration_status`	Unknown
`ip_addresses`	Unknown
`is_active`	Unknown
`is_internal_user`	Unknown
`is_passwd_reset`	Unknown
`locale`	Unknown
`modified_by_id`	Unknown
`modified_by_name`	Unknown
`modified_date`	Unknown
`name`	Unknown
`passwd_chg_dt`	Unknown
`passwd_exp_dt`	Unknown
`primary_role_type`	Unknown
`source_id`	Unknown
`user_uuid`	Unknown
`version`	Unknown

plan_assignment

Column	Type	Keys
`plan_assignment_id`	String	PK
`plan_id`	String	FK
`active_end_date`	Unknown
`active_start_date`	Unknown
`assignment_id`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

pos_rel_type

Column	Type	Keys
`pos_rel_type_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`is_active`	Unknown
`is_master`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

emp_status_code

Column	Type	Keys
`emp_status_code_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`emp_status_code`	Unknown
`emp_status_color`	Unknown
`is_active`	Unknown
`is_included_in_ranking`	Unknown
`is_sort_by`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

position

Column	Type	Keys
`position_id`	String	PK
`business_group_id`	String	FK
`master_position_id`	String	FK
`parent_position_id`	String	FK
`participant_id`	String	FK
`title_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`incent_end_date`	Unknown
`incent_st_date`	Unknown
`is_active`	Unknown
`is_master`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`parent_record_id`	Unknown
`pos_group_id`	Unknown
`version`	Unknown

pos_title_assignment_history

Column	Type	Keys
`pos_title_assignment_id`	String	PK
`id`	Unknown	FK
`position_id`	String	FK
`title_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`object_id`	Unknown
`version`	Unknown

period_type

Column	Type	Keys
`period_type_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

pos_relation

Column	Type	Keys
`id`	String	PK
`from_pos_id`	String	FK
`pos_rel_type_id`	String	FK
`to_pos_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

credit_adjustment

Column	Type	Keys
`credit_adjustment_id`	String	PK
`amount_unit_type_id`	String	FK
`credit_id`	String	FK
`period_id`	String	FK
`amount`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`reason_id`	Unknown

pos_hierarchy_history

Column	Type	Keys
`pos_hierarchy_id`	String	PK
`from_pos_id`	String	FK
`id`	Unknown	FK
`pos_hierarchy_type_id`	String	FK
`to_pos_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`object_id`	Unknown
`version`	Unknown

role

Column	Type	Keys
`role_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`role_type`	Unknown
`version`	Unknown

business_group

Column	Type	Keys
`business_group_id`	String	PK
`finalize_start_period_id`	String	FK
`group_unit_type_id`	String	FK
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_date`	Unknown
`descr`	Unknown
`is_active`	Unknown
`locale`	Unknown
`modified_by_id`	Unknown
`modified_by_name`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

pos_hierarchy_type

Column	Type	Keys
`pos_hierarchy_type_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`is_active`	Unknown
`is_master`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`pos_hierarchy_type_disp_name`	Unknown
`pos_hierarchy_type_name`	Unknown
`version`	Unknown

rule

Column	Type	Keys
`rule_id`	String	PK
`attainment_measure_id`	String	FK
`pos_relation_id`	String	FK
`primary_rule_id`	String	FK
`active_end_date`	Unknown
`active_start_date`	Unknown
`bonus_type`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`multiplier`	Unknown
`name`	Unknown
`parse_tree`	Unknown
`rule_content`	Unknown
`rule_type`	Unknown
`version`	Unknown

unit_type

Column	Type	Keys
`unit_type_id`	String	PK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`display_symbol`	Unknown
`group_name`	Unknown
`group_type`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`version`	Unknown

title

Column	Type	Keys
`title_id`	String	PK
`category_name`	String	FK
`category_type`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`function_name`	Unknown
`function_type`	Unknown
`is_active`	Unknown
`market`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`pay_period_type`	Unknown
`title_level`	Unknown
`version`	Unknown

order_stage

Column	Type	Keys
`order_stage_id`	String	PK
`amount_unit_type_id`	String	FK
`order_type_id`	String	FK
`period_id`	String	FK
`related_item_id`	String	FK
`amount`	Unknown
`batch_id`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`customer_id`	Unknown
`discount`	Unknown
`geography_id`	Unknown
`incentive_date`	Unknown
`is_active`	Unknown
`is_promoted`	Unknown
`is_validated`	Unknown
`item_code`	Unknown
`item_status`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`order_code`	Unknown
`order_date`	Unknown
`product_id`	Unknown
`quantity`	Unknown
`source_id`	Unknown
`upload_id`	Unknown
`version`	Unknown

position_history

Column	Type	Keys
`position_id`	String	PK
`business_group_id`	String	FK
`master_position_id`	String	FK
`parent_position_id`	String	FK
`participant_id`	String	FK
`title_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`incent_end_date`	Unknown
`incent_st_date`	Unknown
`is_active`	Unknown
`is_master`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`object_id`	Unknown
`parent_record_id`	Unknown
`pos_group_id`	Unknown
`version`	Unknown

user_role

Column	Type	Keys
`id`	String	PK
`role_id`	String	FK
`user_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

currency_rate

Column	Type	Keys
`currency_rate_id`	String	PK
`base_currency_unit_type_id`	String	FK
`target_currency_unit_type_id`	String	FK
`active_end_date`	Unknown
`active_start_date`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`exchange_rate`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`source_id`	Unknown
`version`	Unknown

part_user_assignment

Column	Type	Keys
`part_user_assignment_id`	String	PK
`participant_id`	String	FK
`user_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`employee_id`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

participant_history

Column	Type	Keys
`version`	Unknown	PK
`participant_id`	String	PKFK
`business_group_id`	Unknown	FK
`native_cur_unit_type_id`	Unknown	FK
`obj_bonus_target_unittype_id`	Unknown	FK
`payment_cur_unit_type_id`	Unknown	FK
`pr_target_unit_type_id`	Unknown	FK
`salary_unit_type_id`	Unknown	FK
`user_id`	Unknown	FK
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_date`	Unknown
`description`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`emp_status_id`	Unknown
`employee_id`	Unknown
`first_name`	Unknown
`hire_date`	Unknown
`is_active`	Unknown
`is_master`	Unknown
`is_obj_active`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`modified_by_id`	Unknown
`modified_by_name`	Unknown
`modified_date`	Unknown
`name`	Unknown
`obj_bonus_target`	Unknown
`obj_payment_cap_percent`	Unknown
`object_id`	Unknown
`participant_type`	Unknown
`personal_target`	Unknown
`prefix`	Unknown
`prorated_personal_target`	Unknown
`prorated_salary`	Unknown
`region`	Unknown
`salary`	Unknown
`source_id`	Unknown
`termination_date`	Unknown
`version_reason_id`	Unknown
`version_sub_reason_id`	Unknown

comp_order_item_detail

Column	Type	Keys
`comp_order_item_detail_id`	String	PK
`amount_unit_type_id`	String	FK
`comp_order_item_id`	String	FK
`order_type_id`	String	FK
`period_id`	String	FK
`related_item_id`	String	FK
`batch_id`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`customer_id`	Unknown
`discount`	Unknown
`geography_id`	Unknown
`incentive_date`	Unknown
`is_active`	Unknown
`item_code`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`order_code`	Unknown
`order_date`	Unknown
`product_id`	Unknown
`quantity`	Unknown
`source_id`	Unknown
`upload_id`	Unknown

credit_held

Column	Type	Keys
`credit_held_id`	String	PK
`credit_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`held_date`	Unknown
`is_active`	Unknown
`is_held`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`release_group_id`	Unknown
`run_id`	Unknown
`trans_id`	Unknown
`version`	Unknown

quota_assignment_history

Column	Type	Keys
`quota_assignment_id`	String	PK
`amount_unit_type_id`	String	FK
`effective_end_period_id`	String	FK
`effective_start_period_id`	String	FK
`id`	Unknown	FK
`period_id`	String	FK
`quota_id`	String	FK
`amount`	Unknown
`assignment_id`	Unknown
`assignment_name`	Unknown
`assignment_type`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`object_id`	Unknown
`version`	Unknown

credit_total

Column	Type	Keys
`credit_totals_id`	String	PK
`participant_id`	String	FK
`period_id`	String	FK
`position_id`	String	FK
`unittype_id`	String	FK
`amount`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

comp_order_item

Column	Type	Keys
`comp_order_item_id`	String	PK
`amount_unit_type_id`	String	FK
`order_type_id`	String	FK
`period_id`	String	FK
`related_item_id`	String	FK
`batch_id`	Unknown
`customer_id`	Unknown
`geography_id`	Unknown
`is_active`	Unknown
`item_code`	Unknown
`line_number`	Unknown
`modified_date`	Unknown
`order_code`	Unknown
`order_date`	Unknown
`product_id`	Unknown
`source_id`	Unknown
`upload_id`	Unknown

pos_hierarchy

Column	Type	Keys
`pos_hierarchy_id`	String	PK
`from_pos_id`	String	FK
`pos_hierarchy_type_id`	String	FK
`to_pos_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

attainment_measure_criteria

Column	Type	Keys
`attainment_measure_criteria_id`	String	PK
`attainment_measure_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`criteria_id`	Unknown
`history_uuid`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`type`	Unknown

pos_part_assignment_history

Column	Type	Keys
`pos_part_assignment_id`	String	PK
`id`	Unknown	FK
`participant_id`	String	FK
`position_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`object_id`	Unknown
`version`	Unknown

draw

Column	Type	Keys
`draw_id`	String	PK
`period_id`	String	FK
`unit_type_id`	String	FK
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`draw_type`	Unknown
`earning_group_id`	Unknown
`earning_group_name`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`recovery_percent`	Unknown
`version`	Unknown

pos_hierarchy_type_history

Column	Type	Keys
`pos_hierarchy_type_id`	String	PK
`id`	Unknown	FK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`is_active`	Unknown
`is_master`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`object_id`	Unknown
`pos_hierarchy_type_disp_name`	Unknown
`pos_hierarchy_type_name`	Unknown
`version`	Unknown

quota_assignment

Column	Type	Keys
`quota_assignment_id`	String	PK
`amount_unit_type_id`	String	FK
`effective_end_period_id`	String	FK
`effective_start_period_id`	String	FK
`period_id`	String	FK
`quota_id`	String	FK
`amount`	Unknown
`assignment_id`	Unknown
`assignment_name`	Unknown
`assignment_type`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`version`	Unknown

quota_history

Column	Type	Keys
`quota_id`	String	PK
`id`	Unknown	FK
`quota_period_id`	String	FK
`quota_value_unit_type_id`	String	FK
`classification_name`	Unknown
`classification_type`	Unknown
`created_by_id`	Unknown
`created_date`	Unknown
`description`	Unknown
`is_active`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`object_id`	Unknown
`quota_interval_id`	Unknown
`quota_value`	Unknown
`source_id`	Unknown
`version`	Unknown

pos_rel_type_history

Column	Type	Keys
`pos_rel_type_id`	String	PK
`id`	Unknown	FK
`created_by_id`	Unknown
`created_date`	Unknown
`descr`	Unknown
`effective_end_date`	Unknown
`effective_start_date`	Unknown
`is_active`	Unknown
`is_master`	Unknown
`modified_by_id`	Unknown
`modified_date`	Unknown
`name`	Unknown
`object_id`	Unknown
`version`	Unknown