Report Data Warehouse revision history
This topic lists the changes to the Data Warehouse schema, starting with the latest release.
Current release
October 4, 2024 (Release 2024.4)
The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
Schema changes for version 2024.4
Previous releases
-
September 27, 2022 (Release 2022.2)
The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
-
April 15, 2022 (Release 2022.1)
The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
-
December 1, 2021 (Release 2021.3)
The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
-
August 20, 2021 (Release 2021.2)
The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
-
April 26, 2021 (Release 2021.1)
The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
-
December 9, 2020 (Release 2020.4)
The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
-
September 11, 2020 (Release 2020.3)
Release information is now available in an easy-to-reference spreadsheet. The following report displays the changes to the Data Warehouse views in Microsoft Excel format.
-
May 27, 2020 (Release 2020.2)
View name Type of update Columns wh_account_location Columns added override_account_tax_settings, bit, NOT NULL
is_tax_exempt, bit, NOT NULL
tax_region_id, int, NULLwh_contract_exclusion_allocation_code New view added contract_exclusion_allocation_code_id, int, NOT NULL
contract_id, int, NOT NULL
allocation_code_id, int, NOT NULLwh_contract_exclusion_role New view added contract_exclusion_role_id, int, NOT NULL
contract_id, int, NOT NULL
role_id, int, NOT NULLwh_note_product New view added note_id, int, NOT NULL
product_id, int, NOT NULLwh_opportunity Columns added created_by_resource_id, int, NULL
owner_resource_id, int, NULLColumn changed
creator_resource_id, int, NULL
wh_opportunity_checklist_item New view added opportunity_checklist_item_id, int, NOT NULL
name, varchar, NOT NULL
sort_order, int, NOT NULL
opportunity_id, int, NOT NULL
completed_time, datetime, NULL
completed_by_resource_id, int, NULL
is_important, bit, NOT NULLwh_task_checklist_item New view added task_checklist_item_id, int, NOT NULL
name, varchar, NOT NULL
sort_order, int, NOT NULL
task_id, int, NOT NULL
completed_time, datetime, NULL
completed_by_resource_id, int, NULL
is_important, bit, NOT NULL -
February 15, 2020 (Release 2020.1)
View name Type of update Columns wh_crm_note_type Column changed Character maximum length changed from 32 to 100 wh_crm_todo_type Column changed Character maximum length changed from 32 to 100 wh_installed_product Column added installed_product_category_id, int, NOT NUL wh_installed_product_category New view added name, varchar, NOT NULL
sort_order,tinyint, NOT NULL
is_system, bit, NOT NULL
is_default, bit, NOT NULL
is_default_in_client_portal, bit, NOT NULL
is_active, bit, NOT NULL
created_by_resource_id, int, NOT NULL
created_time, datetime, NOT NULL
last_modified_by_resource_id, int, NOT NULL
last_modified_time, datetime, NOT NULLwh_opportunity Column added description, varchar, NOT NULL Column removed
projected_live_ship_date
wh_opportunity_category New view added opportunity_category_id, int, NOT NULL
name, varchar, NOT NULL
sort_order,tinyint, NOT NULL
is_system, bit, NOT NULL
is_default, bit, NOT NULL
is_active, bit, NOT NULL
created_by_resource_id, int, NOT NULL
created_time, datetime, NOT NULL
last_modified_by_resource_id, int, NOT NULL
last_modified_time, datetime, NOT NULLwh_product Column added is_eligible_for_rma, bit, NOT NULL wh_project_task_category Columns added project_task_category_id, int, NOT NULL
name, varchar, NOT NULL
sort_order,tinyint, NOT NULL
is_system, bit, NOT NULL
is_default, bit, NOT NULL
is_default_in_client_portal, bit, NOT NULL
is_active, bit, NOT NULL
created_by_resource_id, int, NOT NULL
created_time, datetime, NOT NULL
last_modified_by_resource_id, int, NOT NULL
last_modified_time, datetime, NOT NULLwh_quote Column changed Character maximum length changed from 100 to 128 wh_rma_request New view added rma_request_id, int, NOT NULL
task_id, int, NOT NULL
internal_currency_credit_amount, decimal, NOT NULL
account_currency_credit_amount, decimal, NOT NULL
credit_detail, varchar, NOT NULL
create_charge, bit, NOT NULLNew view added rma_status_id, int, NOT NULL
display_name, varchar, NOT NULL
sort_order, tinyint, NOT NULLNew view added rma_types_id, int, NOT NULL
display_name, varchar, NOT NULL
sort_order, tinyint, NOT NULLColumns added
rma_status_id, int, NULL
rma_type_id, int, NULL
-
October 15, 2019 (Release 2019.3)
View name Type of update Columns wh_billing_item Column removed create_date (this field was replaced by posted_date (the date the user enters during Approve & Post) and create_time (the actual time the posting occured)) wh_billing_item Column removed create_time wh_note_installed_product New view added note_id, int, NOT NULL
installed_product_id, int, NOT NULL
wh_opportunity Column renamed From "create_date" to "start_date" wh_opportunity Column added promised_fulfillment_date
IMPORTANT This column is to replace projected_live_ship_date. Current Data Warehouse users who are using the projected_live_ship_date must update their integrations.
wh_opportunity Column added create_date
IMPORTANT This is the same name that used to refer to the "start_date" column. Current Data Warehouse users who were using the old create_date (now named start_date) must update their integrations.
wh_person New view added person_id, int, NOT NULL
resource_id, int, NULL
account_contact_id, int, NULL
narrative_full_name, varchar, NOT NULL
sorting_full_name, varchar, NOT NULL
narrative_initials, varchar, NOT NULLwh_quote Columns added allow_external_approval_response_in_client_portal, bit, NOT NULL
quote_approval_status_id, int, NOT NULL
approval_status_last_modified_by_resource_id, int, NOT NULL
approval_status_last_modified_time, datetime, NOT NULL
quote_external_approval_status_id, int, NULL
external_approval_signature, varchar, NOT NULL
external_approval_time, datetime, NULLwh_quote_approval_status New view added quote_approval_status_id, int, NOT NULL
name, varchar, NOT NULL
display_name, varchar, NOT NULLwh_quote_external_approval_status New view added quote_external_approval_status_id, int, NOT NULL
name, varchar, NOT NULL
display_name, varchar, NOT NULLwh_task_time_tracking New view added project_task_time_tracking_id, int, NOT NULL
time_subitem_id, int, NOT NULL
action_performed_by_person_id, int, NOT NULL
action_performed_time, datetime, NOT NULL
tracking_action_id, tinyint, NOT NULLwh_task_time_tracking_column New view added project_task_time_tracking_column_id, smallint, NOT NULL
display_name, varchar, NOT NULLwh_task_time_tracking_column_data New view added project_task_time_tracking_column_data_id, bigint, NOT NULL
project_task_time_tracking_id, int, NOT NULL
project_task_time_tracking_column_id, smallint, NOT NULL
old_value, varchar, NULL
new_value, varchar, NULLwh_ticket_time_tracking New view added ticket_time_tracking_id, int, NOT NULL
time_subitem_id, int, NOT NULL
action_performed_by_person_id, int, NOT NULL
action_performed_time, datetime, NOT NULL
tracking_action_id, tinyint, NOT NULLwh_ticket_time_tracking_column New view added ticket_time_tracking_column_id, smallint, NOT NULL
display_name, varchar, NOT NULLwh_ticket_time_tracking_column_data New view added ticket_time_tracking_column_data_id, bigint, NOT NULL
ticket_time_tracking_id, int, NOT NULL
ticket_time_tracking_column_id, smallint, NOT NULL
old_value, varchar, NULL
new_valuewh_tracking_action New view added tracking_action_id, tinyint, NOT NULL
name, varchar, NOT NULL