Change Log
2024-11-18
- Added new mart resource_skills_v1
- Added the following fields to contact_notes_v1 mart:
- completion_details
- _person_id
- _parent_contact_note_id
- _parent_job_note_id
- _parent_stock_item_note_id
- _parent_resource_note_id
- _parent_vehicle_note_id
- _parent_sales_opportunity_note_id
- _parent_contract_note_id
- Added the following fields to contract_notes_v1 mart:
- completion_details
- _person_id
- _parent_contact_note_id
- _parent_job_note_id
- _parent_stock_item_note_id
- _parent_resource_note_id
- _parent_vehicle_note_id
- _parent_sales_opportunity_note_id
- _parent_contract_note_id
- Added the following fields to job_notes_v1 mart:
- completion_details
- _person_id
- _parent_contact_note_id
- _parent_job_note_id
- _parent_stock_item_note_id
- _parent_resource_note_id
- _parent_vehicle_note_id
- _parent_sales_opportunity_note_id
- _parent_contract_note_id
- Added the following fields to resource_notes_v1 mart:
- completion_details
- _person_id
- _parent_contact_note_id
- _parent_job_note_id
- _parent_stock_item_note_id
- _parent_resource_note_id
- _parent_vehicle_note_id
- _parent_sales_opportunity_note_id
- _parent_contract_note_id
- Added the following fields to sales_opportunity_notes_v1 mart:
- completion_details
- _person_id
- _parent_contact_note_id
- _parent_job_note_id
- _parent_stock_item_note_id
- _parent_resource_note_id
- _parent_vehicle_note_id
- _parent_sales_opportunity_note_id
- _parent_contract_note_id
- Added the following fields to stock_item_notes_v1 mart:
- completion_details
- _person_id
- _parent_contact_note_id
- _parent_job_note_id
- _parent_stock_item_note_id
- _parent_resource_note_id
- _parent_vehicle_note_id
- _parent_sales_opportunity_note_id
- _parent_contract_note_id
- Added the following fields to vehicle_notes_v1 mart:
- completion_details
- _person_id
- _parent_contact_note_id
- _parent_job_note_id
- _parent_stock_item_note_id
- _parent_resource_note_id
- _parent_vehicle_note_id
- _parent_sales_opportunity_note_id
- _parent_contract_note_id
2024-11-13
- Added new mart job_constraints_v1
2024-11-05
- Added the following fields to sales_opportunities_v1 mart:
- due_at (due_at field is intended to replace closed_at field, and closed_at field is now considered deprecated and will be removed from the next mart version.)
2024-11-04
- Added the following fields to resource_working_hours_v1 mart:
- resource_deleted_at
2024-10-30
- Added the following fields to contacts_v1 mart:
- account_reference
- is_contact_flagged
- on_stop_reason
- is_on_stop_applied_to_sub_contacts
- Added new mart sales_opportunity_notes_v1
2024-10-21
- Added the following fields to jobs_v1 mart:
- flag_colour
- flag_comment
- flag_date
- flag_owner
- Added the following fields to invoices_v1 mart:
- flag
- flag_colour
- flag_comment
- flag_date
- flag_owner
- Added the following fields to purchase_orders_v1 mart:
- flag
- flag_colour
- flag_comment
- flag_date
- flag_owner
- Added the following fields to quotes_v1.md mart:
- flag
- flag_colour
- flag_comment
- flag_date
- flag_owner
- Added the following fields to sales_opportunities_v1.md mart:
- flag
- flag_colour
- flag_comment
- flag_date
- flag_owner
2024-10-17
- Added new mart stock_items_to_contracts_v1:
2024-10-07
- Added the following fields to jobs_v1 mart:
- secondary_persons
- secondary_persons_at_parent
- result_resource_notes
- result_customer_name
- result_customer_notes
- result_backoffice_notes
- is_result_actioned
- result_actioned_at
- result_actioned_by
- Added the following fields to job_lines_v1 mart:
- job_group_reference
- type
- tracking_code_1
- tracking_code_2
- tax_code
2024-10-04
- Added the following fields to invoice_lines_v1 mart:
- job_group_reference
- type
- tracking_code_1
- tracking_code_2
- tax_code
- Added the following fields to invoices_v1 mart:
- notes
- internal_notes
- job_group_reference
- sales_opportunity_reference
- contract_reference
- nominal_code
- nominal_code_description
- department_code
- department_code_description
- delivery_site_name
- tracking_code_1
- tracking_code_2
- first_line_of_correspondence
- Added the following fields to purchase_orders_v1 mart:
- first_line_of_correspondence
- Added the following fields to quote_lines_v1 mart:
- job_group_reference
- type
- tracking_code_1
- tracking_code_2
- tax_code
- Added the following fields to quotes_v1 mart:
- notes
- internal_notes
- job_group_reference
- sales_opportunity_reference
- contract_reference
- nominal_code
- nominal_code_description
- department_code
- department_code_description
- delivery_site_name
- tracking_code_1
- tracking_code_2
- first_line_of_correspondence
2024-09-23
- Added the following fields to invoice_lines_v1 mart:
- _invoice_id
- _contract_id
- _contact_id
- Added the following fields to invoices_v1 mart:
- _job_id
- _job_group_id
- _contact_id
- _delivery_site_contact_id
- _contract_id
- _sales_opportunity_id
- Added the following fields to job_groups_v1 mart:
- _vehicle_id
- _contract_id
- Added the following fields to job_lines_v1 mart:
- _contract_id
- _contact_id
- Added the following field to jobs_v1 mart:
- _vehicle_id
- Added the following fields to quote_lines_v1 mart:
- _quote_id
- _contract_id
- _contact_id
- Added the following fields to quotes_v1 mart:
- _job_id
- _job_group_id
- _contact_id
- _delivery_site_contact_id
- _contract_id
- _sales_opportunity_id
- Added the following field to sales_opportunities_v1 mart:
- _contact_id
- Added the following field to stock_items_v1 mart:
- _stock_id
- Added the following fields to vehicle_checks_and_defects_v1 mart:
- _vehicle_id
- _resource_id
2024-09-18
- Added new mart purchase_orders_v1
- Added new mart purchase_order_lines_v1
2024-08-26
- Added the following field to resource_activities_v1 mart:
- absence_type
2024-08-12
- Added new mart resource_working_hours_v1
- Added new mart resource_journeys_v1
2024-08-07
- Added the following field to contract_financial_lines_v1 mart:
- deleted_at
- Added the following field to invoice_lines_v1 mart:
- deleted_at
- Added the following field to invoices_v1 mart:
- deleted_at
- Added the following field to job_groups_v1 mart:
- deleted_at
- Added the following field to job_lines_v1 mart:
- deleted_at
- Added the following field to quote_lines_v1 mart:
- deleted_at
- Added the following field to quotes_v1 mart:
- deleted_at
2024-07-24
- Added new mart person_custom_fields_v1
- Added the following field to contacts_v1 mart:
- deleted_at
- Added the following field to resources_v1 mart:
- deleted_at
2024-07-11
- Added new mart persons_v1
- Added new mart resource_absences_v1
2024-07-02
- Added new mart contract_financial_lines_v1
- Added new mart resource_journeys_v1
2024-06-17
- Added new mart timesheet_worksheet_answers_v1
2024-05-21
- Added new mart contact_note_workflow_answers_v1
2024-05-06
- Added new mart stock_worksheet_answers_v1
2024-04-23
- Added new mart stock_v1
- Added new mart stock_reorder_levels_v1
- Added new mart vehicle_checks_and_defects_v1
2024-04-18
- Added new mart job_notes_v1
- Added new mart stock_item_notes_v1
2024-04-09
- Added new mart job_worksheet_answers_v1
2024-04-08
- Added new mart stock_movements_v1
- Added new mart stock_planned_usage_v1
2024-03-27
- Added new mart vehicle_attributes_v1
2024-03-21
- Added new mart contract_notes_v1
- Added new mart stock_suppliers_v1
- Added new mart stock_item_custom_fields_v1
2024-03-12
- Added new mart resource_notes_v1
- Added new mart vehicle_notes_v1
- Added the following fields to contact_notes_v1 mart:
- deleted_at
- flag
- priority
- description
2024-03-11
- Added new mart contract_custom_fields_v1
- Added new mart stock_items_v1
2024-03-04
- Added new mart contracts_v1
2024-02-26
- Added new mart vehicles_v1
- Added new mart vehicle_custom_fields_v1
2024-01-09
- Added new mart sales_opportunity_custom_fields_v1
2023-11-29
- Added the following fields to resource_day_summaries_v1 mart:
- job_duration_in_minutes_as_resource
- job_duration_in_hours_as_resource
- job_duration_within_wh_in_minutes_as_resource
- job_duration_within_wh_in_hours_as_resource
- job_duration_outside_wh_in_minutes_as_resource
- job_duration_outside_wh_in_hours_as_resource
- job_duration_in_minutes_as_assistant
- job_duration_in_hours_as_assistant
- job_duration_within_wh_in_minutes_as_assistant
- job_duration_within_wh_in_hours_as_assistant
- job_duration_outside_wh_in_minutes_as_assistant
- job_duration_outside_wh_in_hours_as_assistant
2023-11-10
- Added the following field to resource_activities_v1 mart:
- is_within_working_hours
- assistant_start_at
- assistant_end_at
2023-11-07
- Added the following field to resource_activities_v1 mart:
- is_assistant
2023-10-25
- Added the following fields to resource_day_summaries_v1 mart:
- driving_duration_within_wh_in_minutes
- driving_duration_within_wh_in_hours
- driving_duration_outside_wh_in_minutes
- driving_duration_outside_wh_in_hours
- job_duration_within_wh_in_minutes
- job_duration_within_wh_in_hours
- job_duration_outside_wh_in_minutes
- job_duration_outside_wh_in_hours
- driving_and_job_duration_within_wh_in_minutes
- driving_and_job_duration_within_wh_in_hours
- driving_and_job_duration_outside_wh_in_minutes
- driving_and_job_duration_outside_wh_in_hours
2023-10-02
- Initial release of Data as a Service (DaaS)