Changes to API tables (v11.0)
- Rashmi Likhite
Owned by Rashmi Likhite
Table name | Old Column name | New column/table name |
|---|---|---|
| db_person | ||
| login_name | username | |
| pwd | password_hash | |
| pwd_changed_at | password_changed | |
| last_access | last_accessed | |
| locale_id | locale | |
| time_zone_id | time_zone | |
| db_project_state | ||
| allow_time | is_time_allowed | |
| allow_client | is_client_initiable | |
| db_process_type | ||
| allow_time | is_time_allowed | |
| db_company | ||
| locale_id | locale | |
| time_zone_id | time_zone | |
| db_working_calendar | ||
| time_zone_id | time_zone | |
| db_note | ||
| detail | description | |
| db_message | ||
| detail | description | |
| summary | name | |
| db_baseline | ||
| summary | name | |
| labour_cost | labor_cost | |
| non_labour_cost | non_labor_cost | |
| db_time_entry | ||
| user_comments | comments | |
| hours_worked | hours | |
| db_project | ||
| summary | name | |
| detail | description | |
| charging_model | billing_type | |
| project_category_id | type_id | |
| plan_start | planned_start | |
| plan_finish | planned_finish | |
| percent_complete | actual_percent_complete | |
| fixed_cost | actual_fixed_cost | |
| user_cost | actual_labor_cost | |
| cost | actual_cost | |
| c_expense | actual_costable_expense | |
| nc_expense | actual_non_costable_expense | |
| b_expense | actual_billable_expense | |
| nb_expense | actual_non_billable_expense | |
| est_work | planned_effort | |
| est_labour_billing | planned_labor_revenue | |
| est_labour_cost | planned_labor_cost | |
| est_non_labour_cost | planned_non_labor_cost | |
| est_fixed_cost | planned_fixed_cost | |
| b_time_money | actual_billable_labor_amount | |
| nb_time_money | actual_non_billable_labor_amount | |
| b_time_hours | actual_billable_labor_hours | |
| nb_time_hours | actual_non_billable_labor_hours | |
| c_time_hours | actual_costable_labor_hours | |
| i_expense | invoiced_expense | |
| i_time_money | invoiced_labor_amount | |
| i_time_hours | invoiced_labor_hours | |
| db_process | ||
| summary | name | |
| detail | description | |
| assigned_to_id | assignee_id | |
| my_b_time_money | my_actual_billable_labor_amount | |
| my_b_time_hours | my_actual_billable_labor_hours | |
| my_nb_time_money | my_actual_non_billable_labor_amount | |
| my_nb_time_hours | my_actual_non_billable_labor_hours | |
| my_c_time_hours | my_actual_costable_labor_hours | |
| my_i_time_money | my_invoiced_labor_amount | |
| my_i_time_hours | my_invoiced_labor_hours | |
| my_labour_cost | my_actual_labor_cost | |
| my_cost | my_actual_cost | |
| requestor_name | external_requestor_name | |
| requestor_email | external_requestor_email | |
| db_task | ||
| can_fill_time | is_time_allowed | |
| child_number | tree_index | |
| schedule_type_value | schedule_type | |
| constraint_type_value | constraint_type | |
| duration_type | duration_unit | |
| work_time | planned_effort | |
| last_status_update | last_status_updated | |
| is_dep_solved | are_predecessor_constraints_satisfied | |
| my_b_time_money | my_actual_billable_labor_amount | |
| my_b_time_hours | my_actual_billable_labor_hours | |
| my_nb_time_money | my_actual_non_billable_labor_amount | |
| my_nb_time_hours | my_actual_non_billable_labor_hours | |
| my_c_time_hours | my_actual_costable_labor_hours | |
| my_i_time_money | my_invoiced_labor_amount | |
| my_i_time_hours | my_invoiced_labor_hours | |
| my_labour_cost | my_actual_labor_cost | |
| my_cost | my_actual_cost | |
| ru_b_time_money | ru_actual_billable_labor_amount | |
| ru_b_time_hours | ru_actual_billable_labor_hours | |
| ru_nb_time_money | ru_actual_non_billable_labor_amount | |
| ru_nb_time_hours | ru_actual_non_billable_labor_hours | |
| ru_c_time_hours | ru_actual_costable_labor_hours | |
| ru_i_time_money | ru_invoiced_labor_amount | |
| ru_i_time_hours | ru_invoiced_labor_hours | |
| ru_labour_cost | ru_actual_labor_cost | |
| ru_cost | ru_actual_cost | |
| my_b_expense | my_actual_billable_expense | |
| my_nb_expense | my_actual_non_billable_expense | |
| my_c_expense | my_actual_costable_expense | |
| my_nc_expense | my_actual_non_costable_expense | |
| my_i_expense | my_invoiced_expense | |
| ru_b_expense | ru_actual_billable_expense | |
| ru_nb_expense | ru_actual_non_billable_expense | |
| ru_c_expense | ru_actual_costable_expense | |
| ru_nc_expense | ru_actual_non_costable_expense | |
| ru_i_expense | ru_invoiced_expense | |
| my_est_cost | my_planned_cost | |
| ru_est_cost | ru_planned_cost | |
| my_est_labour_cost | my_planned_labor_cost | |
| ru_est_labour_cost | ru_planned_labor_cost | |
| my_est_labour_billing | my_planned_labor_revenue | |
| ru_est_labour_billing | ru_planned_labor_revenue | |
| plan_start | planned_start | |
| plan_finish | planned_finish | |
| is_manual | is_manually_scheduled | |
| summary | name | |
| detail | description | |
| percent_complete | actual_percent_complete | |
| est_non_labour_cost | planned_non_labor_cost | |
| fixed_cost | planned_fixed_cost | |
| local_key | sn | |
| db_assignment | ||
| unit_type_value | allocation_unit | |
| units | allocation_value | |
| work_time | planned_effort | |
| est_cost | planned_cost | |
| est_labour_billing | planned_labor_revenue | |
| labour_cost | actual_labor_cost | |
| time_hours | actual_labor_hours | |
| time_money | actual_billable_labor_amount | |
| submitted_hours | submitted_labor_hours | |
| db_expense | ||
| summary | name | |
| approval_comments | approver_comments | |
| db_calendar_event | ||
| summary | name | |
| detail | description | |
| owner_id | user_id | |
| db_reminder | ||
| owner_id | user_id | |
| db_project_category | db_project_type | |