Analytics - Data Change Log

project_granular_permissions:

• tool_bidding_create_bid_note

• tool_bidding_delete_bid_note

• tool_bidding_update_bid_note

bid_form:

• audit_transaction_timestamp

bid_item:

• audit_transaction_timestamp

bid_package:

• audit_transaction_timestamp

estimate_budget_item_wbs_value:

• procore_project_id

estimate_layer_group_wbs_values:

• procore_project_id

estimate_layer_wbs_values:

• procore_project_id

equipment_rate:

• value

equipment_timecard_entry_with_rates:

• idle_cost

• idle_quantity

• idle_rate

• operating_cost

• operating_quantity

• operating_rate

materials_requirement:

• audit_transaction_timestamp

• company_id

• created_at

• date_required_on_site

• material_id

• material_project_id

• materials_requirement_id

• project_id

• required_quantity

• requirement_description

• requirement_line_item_uuid

• requirement_name

• requirement_state

• requirement_uuid

• scope_end_date

• scope_start_date

• updated_by

tax_bridge:

• applied_amount

• audit_transaction_timestamp

• basis_amount

• change_order_id

• company_id

• finance_object_id

• finance_object_type

• markup_id

• project_id

• tax_bridge_id

• tax_code_rate_id

• tax_finance_object_id

time_and_material_equipment_with_rates:

• audit_transaction_timestamp

• company_id

• created_at

• currency_iso_code

• deleted_at

• equipment_id

• equipment_rate

• idle_quantity

• idle_rate

• idle_revenue

• is_deleted

• operating_quantity

• operating_revenue

• project_id

• rate

• rate_value_id

• time_and_material_entry_id

• time_and_material_equipment_with_rates_id

• time_material_equipment_id

• updated_at

time_and_material_equipments:

• idle_hours

• operating_hours

time_and_material_labors:

• timecard_entry_id

time_and_material_labors_with_rates:

• audit_transaction_timestamp

• company_id

• created_at

• currency_iso_code

• deleted_at

• employee_id

• is_deleted

• labor_revenue

• project_id

• rate

• rate_value_id

• time_and_material_entry_id

• time_and_material_labor_id

• time_and_material_labors_with_rates_id

• updated_at

timecard_entries:

• pay_period

• pay_period_end_date

• pay_period_id

• pay_period_start_date

• pay_period_status

project_role_memberships:

• vendor_id

assignments:

• percent_allocation

owner_invoice_adjustments:

• materials_retainage

• materials_retainage_company_currency

• materials_retainage_project_currency

• work_retainage_this_period

• work_retainage_this_period_company_currency

• work_retainage_this_period_project_currency

prime_contracts:

• draft_change_orders_project_currency

subcontractor_invoice_line_items_relations:

• budget_change_adjustment_line_item_id

• budget_change_id

• change_event_line_item_id

• change_event_line_item_with_markup_id

• prime_contract_change_order_id

• prime_contract_change_order_line_item_id

• prime_contract_change_order_request_id

• prime_contract_id

• prime_contract_line_item_id

• prime_contract_potential_change_order_id

coordination_issue:

• created_by_company

• workflows_instance_id

• workflow_name

correspondence_workflow_responses:

• correspondence_id

correspondence_workflow_steps:

• correspondence_id

daily_hazard_analysis:

• attachment_count

• controls

• hazards_list

• risk_assessment_code

• scope_of_work

daily_hazard_analysis_assignees:

• assignee_id

• assignee_name

• company_id

• daily_hazard_analysis_assignee_id

• daily_hazard_analysis_id

• project_id

daily_hazard_analysis_steps:

• daily_hazard_analysis_step_id

incident_record:

• estimated_cost_impact_company_currency

• estimated_cost_impact_project_currency

incident_workflow_responses:

• assignee

• assignee_id

• assignment_duration

• audit_transaction_timestamp

• company_id

• current_step_response

• incident_workflow_response_id

• incident_workflow_step_id

• project_id

• workflowable_object_id

• workflowable_object_type

• workflows_instance_id

inspection_items:

• inspection_template_item_id

observation_workflow_responses:

• observation_workflow_response_id

• observation_workflow_step_id

• workflowable_object_id

• workflows_instance_id

observation_workflow_steps:

• observation_workflow_step_id

• workflowable_object_id

• workflows_instance_id

field_productivity:

• company_type

• partition_company_id

punch_item:

• manager_notified_at

commitments:

• percentage_paid_company_currency

• percentage_paid_project_currency

prime_contracts:

• percentage_paid_company_currency

• percentage_paid_project_currency

punch_item_assignee:

• status

commitment_line_items:

• tax_code

commitment_change_order_line_items:

• tax_code

prime_contract_line_items:

• tax_code

prime_contract_change_order_line_items:

• tax_code

subcontractor_invoices:

• total_tax

• total_tax_project_currency

• total_tax_company_currency

• early_pay_fee_rate

materials_shipment:

• commitment_change_order_id

• commitment_change_order_line_item_id

• commitment_id

• commitment_line_item_id

materials_receipt:

• commitment_change_order_id

• commitment_change_order_line_item_id

• commitment_id

• commitment_line_item_id

materials_purchase_order:

• commitment_change_order_id

• commitment_change_order_line_item_id

• commitment_id

• commitment_line_item_id

project_permissions:

• tool_assets

projects:

• project_message

• project_message_title

• project_logo_url

locations:

• geometry_type

company_vendor_insurances:

• provider_id

• provider_type

owner_invoice_adjustments:

• audit_transaction_timestamp

• company_id

• currency_code

• financial_object_to_project_exchange_rate

• materials_stored

• materials_stored_company_currency

• materials_stored_project_currency

• new_materials

• new_materials_company_currency

• new_materials_project_currency

• owner_invoice_id

• owner_invoice_line_item_id

• work_completed_retainage_released_this_period

• work_completed_retainage_released_this_period_company_currency

• work_completed_retainage_released_this_period_project_currency

• work_completed_this_period_company_currency

• work_completed_this_period_project_currency

subcontractor_invoice_line_items:

• materials_previously_stored

subcontractor_invoice_line_items_relations:

• owner_invoice_line_item_with_markup_id

bid_item:

• bid_section_type

daily_hazard_analysis:

• assignee_list

• company_id

• created_at

• created_by

• created_by_id

• daily_hazard_analysis_id

• date_prepared

• description

• emergency_contact_id

• emergency_contact

• emergency_contact_phone_number

• evacuation_route

• eye_wash_location

• first_aid_location

• item_number

• item_status

• item_title

• location_id

• project_id

• required_permits_procedures

• required_ppe

• updated_at

daily_hazard_analysis_signers:

• company_id

• daily_hazard_analysis_id

• daily_hazard_analysis_signer_id

• is_signed

• project_id

• signed_at

• signed_by_logged_in_user_email_id

• signer_id

• signer_name

• signer_user_type

daily_hazard_analysis_steps:

• company_id

• control_measures

• daily_hazard_analysis_id

• hazard_types

• project_id

• risk_assessment_code

• scope_of_work

• work_step_number

assignments:

• equipment_id

• resource_type

equipment_timecard_entry_with_rates:

• wbs_code_id

maintenance_record:

• service_duration

• service_type

timecard_entry_with_rates:

• wbs_code_id

company_granular_permissions:

• tool_timecard_can_create_clock_in_out_time_for_my_time_timecard_entries

• tool_timecard_can_edit_previously_created_my_time_timecard_entry

• tool_timecard_can_manually_create_my_time_timecard_entries

• tool_workflows_can_assign_company_templates

• tool_workflows_can_bulk_manage_assignees

• tool_workflows_can_create_company_templates

• tool_workflows_can_destroy_company_templates

• tool_workflows_can_see_company_templates

coordination_issue:

• workflow_members

daily_log_delay:

• cost_code_id

• cost_code_name

direct_cost_workflow_responses:

• assignee

• assignment_duration

• audit_transaction_timestamp

• company_id

• current_step_response

• direct_cost_workflow_response_id

• direct_cost_workflow_step_id

• project_id

• workflowable_object_id

• workflowable_object_type

• workflows_instance_id

direct_cost_workflow_steps:

• audit_transaction_timestamp

• company_id

• current_step_due_date

• current_step_name

• direct_cost_workflow_step_id

• project_id

• workflowable_object_id

• workflowable_object_type

• workflows_instance_id

incident_workflow_steps:

• assignee_id_list

• audit_transaction_timestamp

• company_id

• current_step_due_date

• current_step_name

• incident_workflow_step_id

• project_id

• workflowable_object_id

• workflowable_object_type

• workflows_instance_id

observation_workflow_steps:

• key

• company_type

• current_step_name_sort

• instance_id

• object_id

• partition_company_id

observation_workflow_responses:

• key

• assignee_sort

• assignment_duration_sort

• company_type

• current_step_response_sort

• instance_id

• instances_step_occurrence_id

• object_id

• partition_company_id

requests:

• resource_type

• type_id

scheduling_activity:

• approvers

• assignees

asset:

• parent_asset

timecard_entries:

• clock_in_onsite

• clock_out_onsite

• lunch_clock_in_onsite

• lunch_clock_out_onsite

document_management_placeholder:

• audit_transaction_timestamp

• company_id

• created_at

• created_by

• deleted_at

• deleted_by

• discipline

• document_management_placeholder_id

• document_management_revision_id

• document_management_upload_id

• name

• originator

• overdue_by

• partition_company_id

• placeholder_assignee

• placeholder_due_date

• placeholder_overdue

• placeholder_status

• placeholder_type

• project_id

• reason_for_deletion

• recycled

• revision

• submitted_at

equipment_rate:

• audit_transaction_timestamp

• column_type

• company_id

• created_at

• created_by

• created_by_id

• description

• equipment_category

• equipment_rate_id

• equipment_type

• name

• rate_category

• rate_table_id

• rate_value

• resource_category

• unit_of_measure

• updated_at

• updated_by

• updated_by_id

equipment_timecard_entry_with_rates:

• audit_transaction_timestamp

• company_id

• created_at

• currency_iso_code

• deleted_at

• equipment_cost

• equipment_timecard_entry_id

• equipment_timecard_entry_with_rates_id

• is_deleted

• project_id

• quantity

• rate

• rate_value_id

• updated_at

incident_root_cause_analysis_custom_fields:

• audit_transaction_timestamp

• company_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• incident_root_cause_analysis_custom_field_id

• incident_root_cause_analysis_id

• project_id

incident_root_cause_analysis:

• attachment_count

• audit_transaction_timestamp

• company_id

• contributing_behavior

• contributing_condition

• created_at

• hazard

• incident_assignee_ids

• incident_created_by_id

• incident_id

• incident_is_private

• incident_root_cause_analysis_id

• investigation_details

• location_id

• project_id

• root_cause_analysis_description

• updated_at

• work_activity

labor_rate:

• audit_transaction_timestamp

• class_code

• classification

• column_type

• company_id

• created_at

• created_by

• created_by_id

• description

• labor_rate_id

• name

• rate_category

• rate_table_id

• rate_value

• resource_category

• unit_of_measure

• updated_at

• updated_by

• updated_by_id

• value

rate_table:

• audit_transaction_timestamp

• company_id

• created_at

• created_by

• created_by_id

• description

• effective_date

• expiration_date

• is_active

• name

• project_id

• rate_table_id

• resource_category

• updated_at

• updated_by

• updated_by_id

timecard_entry_with_rates:

• audit_transaction_timestamp

• company_id

• created_at

• currency_iso_code

• deleted_at

• is_deleted

• labor_cost

• project_id

• rate

• rate_value_id

• timecard_entry_id

• timecard_entry_with_rates_id

• updated_at

locations:

• geo_json

• geo_json_wkt

direct_cost_line_items:

• is_billable

• prefilled_to_owner_invoice_id

• prefilled_to_owner_invoice_line_item_id

owner_invoice_adjustments:

• owner_invoice_adjustment_id

• work_completed_this_period

• description

• created_at

• updated_at

• company_id

• project id

owner_invoice_custom_fields:

• audit_transaction_timestamp

• company_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• owner_invoice_custom_field_id

• owner_invoice_id

• project_id

owner_invoice_line_item_with_markups_relations:

• owner_invoice_custom_field_id

subcontractor_invoice_line_items:

• is_billable

• prefilled_to_owner_invoice_id

• prefilled_to_owner_invoice_line_item_id

subcontractor_invoice_line_items_relations:

• owner_invoice_id

• owner_invoice_line_item_id

incident_witness_statement:

• signature_captured_at

• signature_captured_by

• signature_captured_by_id

• signed

materials_receipt:

• commitment_change_order_id

• commitment_change_order_line_item_id

• commitment_id

• commitment_line_item_id

certificates:

• certificate_id

• company_id

• company_name

• procore_zone

• user_id

• course_enrollment_id

• published_course_id

• email

• student_name

• contact_full_name

• contact_first_name

• contact_last_name

• contact_job_title

• contact_is_active

• title

• content_type

• domain

• channel

• tags

• group_memberships

• live_event

• sku

• credits

• registered_at

• latest_activity

• due_at

• certificate_expiration

• days_to_expiration

• course_score

• complete_pct

• is_completed

• progress_status

• snapshot_date

• snapshot_ts

incident:

• type_id

• type

inspection_templates:

• inspection_template_id

• company_id

• project_id

• origin_id

• name

• origin_template_name

• description

• inspection_type_id

• inspection_type

• inspection_type_group

• trade_id

• trade

• alternative_response_set_id

• created_by_id

• created_by_name

• is_project_level

• is_synced_from_company

• is_active

• project_count

• assigned_projects

• created_at

• updated_at

inspection_template_items:

• inspection_template_item_id

• inspection_template_id

• company_id

• project_id

• section_id

• section_name

• section_position

• name

• position

• position_number

• response_set_id

• response_set_name

• response_type

• has_observation_requirement

• has_photo_requirement

• created_at

• updated_at

inspection_response_sets:

• inspection_response_set_id

• company_id

• name

• is_custom

• created_at

• updated_at

inspection_template_projects:

• inspection_template_project_id

• company_id

• project_id

• inspection_template_id

• created_at

• updated_at

subcontractor_invoices:

• early_pay_fee_amount_calculated_company_currency

• early_pay_fee_amount_calculated_project_currency

• early_pay_fee_rate_calculated

bid:

• distribution_member_id_list

bid_item:

• bid_item_description

bid_package:

• distribution_member_id_list

• manager_id

asset_attachment:

• asset_type_id

scheduling_activity:

• parent_activity_name

equipment_rate:

• audit_transaction_timestamp

• column_type (Deferred)

• company_id

• created_at (Deferred)

• created_by (Deferred)

• created_by_id

• description (Deferred)

• equipment_category (Deferred)

• equipment_rate_id (Deferred)

• equipment_type (Deferred)

• name (Deferred)

• rate_category (Deferred)

• rate_table_id

• resource_category (Deferred)

• unit_of_measure (Deferred)

• updated_at (Deferred)

• updated_by (Deferred)

• updated_by_id

• value (Deferred)

labor_rate:

• audit_transaction_timestamp

• class_code (Deferred)

• classification (Deferred)

• column_type (Deferred)

• company_id

• created_at (Deferred)

• created_by (Deferred)

• created_by_id

• description (Deferred)

• labor_rate_id (Deferred)

• name (Deferred)

• rate_category (Deferred)

• rate_table_id

• resource_category (Deferred)

• unit_of_measure (Deferred)

• updated_at (Deferred)

• updated_by (Deferred)

• updated_by_id

• value (Deferred)

rate_table:

• audit_transaction_timestamp

• company_id

• created_at (Deferred)

• created_by (Deferred)

• created_by_id

• description (Deferred)

• effective_date (Deferred)

• expiration_date (Deferred)

• is_active (Deferred)

• name (Deferred)

• project_id

• rate_table_id (Deferred)

• resource_category (Deferred)

• updated_at (Deferred)

• updated_by (Deferred)

• updated_by_id

time_and_material_labors:

• employee_system_id

worker_certification_gaps:

• active_projects

• days_until_expiry

• full_name

app_activity:

• activity_type

• api_call_count

• app_activity_id

• app_type

• application_id

• application_name

• company_id

• date

• day_id

• embedded_usage

• http_method

• project_id

• tool_category

pay_requirement_settings:

• first_tier_unconditional_lien_waiver_previous_invoice_signed

payments_requirements:

• unconditional_lien_waiver_previous_invoice_signed

owner_invoice_custom_fields:

• audit_transaction_timestamp

• company_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• owner_invoice_custom_field_id

• owner_invoice_id

• project_id

user_adoption_metrics:

• snapshot_date

• company_id

• project_id

• user_adoption_metric_id

• created_by_id

• created_by

• created_by_login

• tool

• metric_name

• metric_value

• created_at

• metric_definition

coordination_issue:

• is_private

subcontractor_invoice_line_items:

• materials_previously_stored

estimates:

• discount

• discount_percentage

• bonding

• bonding_percentage

• overhead

• overhead_percentage

observation_custom_fields:

• type_id from int to bigint

• observation_type_id from int to bigint

observation_custom_field_configs:

• type_id from int to bigint

• observation_type_id from int to bigint

commitments:

• approved_date from Date to Timestamp

prime_contracts:

• approved_date from Date to Timestamp

commitment_potential_change_orders:

• approved_date from Date to Timestamp

commitment_change_orders:

• approved_date from Date to Timestamp

prime_contract_change_orders:

• approved_date from Date to Timestamp

prime_contract_potential_change_orders:

• approved_date from Date to Timestamp

assembly_part:

• procore_project_id

asset:

• asset_code

• asset_id

• asset_name

• asset_status_id

• asset_system_state_id

• asset_type_code

• asset_type_id

• asset_type_name

• audit_transaction_timestamp

• company_id

• created_at

• created_by

• description

• latitude

• location

• location_id

• longitude

• note

• project_id

• scope

• status

• trade

• trade_id

• updated_at

• updated_by

asset_attachment:

• asset_attachment_id

• asset_attachment_type

• asset_id

• attachment_source

• attachment_type_id

• audit_transaction_timestamp

• company_id

• created_at

• created_by

• description

• file_name

• project_id

• updated_at

• updated_by

asset_custom_fields:

• asset_custom_field_id

• asset_id

• audit_transaction_timestamp

• company_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• project_id

crew_memberships:

• wp_people_id

crew_memberships_equipment:

• company_id

• created_at

• crew_id

• crew_lead_name

• crew_name

• equipment_crew_membership_id

• equipment_id

• equipment_identification_number

• equipment_name

• project_id

• updated_at

equipment_project_association:

• audit_transaction_timestamp

• company_id

• created_by

• created_by_id

• created_date

• deleted_by

• deleted_by_id

• deleted_date

• equipment_id

• equipment_identification_number

• equipment_project_association_id

• project_id

• project_name

equipment_timecard_entry:

• operator_id

materials_purchase_order:

• material_id

materials_receipt:

• material_id

materials_shipment:

• material_id

time_and_material_labors:

• user_id

• wp_people_id

planned_vs_actual_summary:

• planned_vs_actual_summary_id

• company_id

• project_id

• wbs_code_id

• cost_code_id

• project

• cost_code

• week_start_date

• week_end_date

• work_week

• total_actual_hours

• total_planned_hours

• variance_hours

• variance_pct

• timecard_entry_count

• contributing_employee_count

materials:

• material_project_id

materials_shipment:

• material_project_id

materials_receipt:

• material_project_id

materials_purchase_order:

• material_project_id

direct_costs:

• wp_people_id

direct_costs_line_items:

• wp_people_id

worker_certification_gaps:

• worker_certification_id

• wp_people_id

• tag_id

• tag_name

• effective_date

• expire_date

• gap_type

• company_id

workflow_instances:

• workflow_instance_id

• company_id

• project_id

• workflows_templates_version_id

• current_step_occurrence_id

• item_tool

• workflowable_object_id

• workflowable_object_identifier

• template_name

• template_version

• status

• duration

• created_by_id

• created_by

• updated_by_id

• updated_by

• started_at

• date_completed

• created_at

• updated_at

• audit_transaction_timestamp

workflow_steps:

• workflow_step_id

• company_id

• project_id

• workflowable_object_id

• workflowable_object_identifier

• name

• due_date

• created_at

• updated_at

• date_completed

• completion_duration

• decision

• decision_type

• is_current_step

• is_overdue

• condition_value

• condition_actual_value

• workflow_instance_id

• selected_response_option_id

• step_uuid

• selected_response_uuid

• audit_transaction_timestamp

• step_type

workflow_step_assignees:

• workflow_step_assignee_id

• company_id

• project_id

• workflow_instance_id

• workflows_instances_step_occurrence_id

• workflow_step_id

• workflowable_object_id

• workflowable_object_identifier

• assignee_id

• aligned_to_decision

• completion_duration

• created_at

• invited_by

• required_to_respond

• response

• response_comment

• response_submitted_date

• role

• updated_at

• audit_transaction_timestamp

• name

• created_by

• created_by_id

• item_tool

• original_assignee_name

• reason_for_invitation

• responded_on_behalf_of

• updated_by

• updated_by_id

commitment_change_order_workflow_responses:

• name

• vendor_id

commitment_change_order_workflow_steps:

• name

• source

• vendor_id

prime_contracts:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

subcontractor_invoice_line_items:

• materials_retainage_retained_this_period

• materials_retainage_retained_this_period_company_currency

• materials_retainage_retained_this_period_project_currency

subcontractor_invoice_line_items_relations:

• tax_bridge_id

• tax_id

subcontractor_sov:

• vendor_id

connected_rfis:

• rfi_header_id

incident_action:

• incident_root_cause_analysis_id

incident_alert:

• incident_root_cause_analysis_id

incident_assignee:

• incident_root_cause_analysis_id

incident_distribution_member:

• incident_root_cause_analysis_id

incident_injury_body_part:

• incident_root_cause_analysis_id

incident_record:

• incident_root_cause_analysis_id

incident_witness_statement:

• incident_root_cause_analysis_id

rfi_external_rfis:

• audit_transaction_timestamp

• company_id

• connected_rfi_id

• created_at

• external_rfi_subject

• project_id

• rfi_external_rfi_id

• rfi_header_id

• updated_at

commitment_change_orders:

• contract_private

• contract_created_by_id

• contract_user_id_list

commitment_change_order_requests:

• contract_private

• contract_created_by_id

• contract_user_id_list

commitment_potential_change_orders:

• contract_private

• contract_created_by_id

• contract_user_id_list

• designated_reviewer_id

prime_contract_change_orders:

• contract_private

• contract_created_by_id

• contract_user_id_list

prime_contract_change_order_requests:

• contract_private

• contract_created_by_id

• contract_user_id_list

prime_contract_potential_change_orders:

• contract_type

• contract_private

• contract_created_by_id

• contract_user_id_list

owner_invoices:

• contract_type

• contract_private

• contract_created_by_id

• contract_user_id_list

owner_invoice_line_item_with_markups:

• contract_type

• contract_private

• contract_created_by_id

• allow_these_users_to_see_sov_items

• contract_user_id_list

subcontractor_invoices:

• contract_private

• contract_created_by_id

• contract_user_id_list

payments_received:

• prime_contract_id

payments_requirements:

• subcontractor_invoice_id

app_activity:

• app_activity_id

• day_id

• date

• application_id

• application_name

• activity_type

• app_type

• tool_category

• http_method

• api_call_count

• embedded_usage

• company_id

• project_id

commitment_change_order_workflow_steps:

• commitment_id

• commitment_change_order_id

• commitment_potential_change_order_id

commitment_change_order_workflow_responses:

• commitment_id

• commitment_change_order_id

• commitment_potential_change_order_id

projects:

• estimated_budget

• estimated_budget_project_currency

• estimated_budget_company_currency

• priority

prime_contract_change_order_line_items:

• vendor_id

subcontractor_invoice_line_items_relations:

• subcontractor_sov_id

document_management:

• audit_transaction_timestamp

• authored_by

• authored_by_id

• classification

• company_id

• created_at

• date_authored

• description

• discipline

• document_management_id

• document_stage

• file_size

• format

• in_active_workflow

• location

• location_id

• name

• number

• original_filename

• originator

• originator_id

• project_id

• project_stage

• recycled

• recycled_at

• recycled_by

• recycled_reason

• revision

• status

• submitted_into_drawings

• submitted_into_drawings_at

• submitted_into_drawings_by

• type

• updated_at

• updated_by

• updated_by_id

• uploaded_at

• uploaded_by

• uploaded_by_id

• version

• volume

document_management_custom_fields:

• audit_transaction_timestamp

• company_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• document_management_custom_field_id

• document_management_id

• project_id

observation_assignees:

• assignee_company_name

• assignee_login

• assignee_name

• assignee_user_id

• audit_transaction_timestamp

• company_id

• created_at

• location_id

• observation_assignee_id

• observation_id

• project_id

• updated_at

task:

• is_origin

• meeting_item_id

daily_timecards_and_assignments:

• assignments

• employee_name

• party_id

• project

• work_week

equipment_project_log:

• deleted_by_id

• ended_by

• equipment_identification_number

• project_name

• started_by

rfis:

• company_name

rfis_bic:

• company_name

subcontractor_invoices:

• payments_beneficiary_id

• payments_project_control_id

document_management_workflow_steps:

• audit_transaction_timestamp

• workflows_instance_id

• company_id

• project_id

• workflowable_object_type

• workflowable_object_id

• document_management_workflow_step_id

• current_step_name

• current_step_due_date

document_management_workflow_responses:

• audit_transaction_timestamp

• workflows_instance_id

• company_id

• project_id

• workflowable_object_type

• workflowable_object_id

• document_management_workflow_step_id

• document_management_workflow_response_id

• assignee

• assignment_duration

• current_step_response

wp_person_groups_relations:

• group_people_project_id

• group_id

• company_id

• wp_people_id

• wp_project_id

• project_id

• employee_id

• audit_transaction_timestamp

direct_costs:

• accounting_date

• payment_due_date

• discount_date

• payment_status

• billed_amount

• billed_amount_project_currency

• billed_amount_company_currency

• erp_latest_status

• erp_updated_at

• erp_user_name

• tool_origin

commitment_change_order_line_items:

• estimated_tax

• estimated_tax_company_currency

• estimated_tax_project_currency

• finance_object_id

• tax_codes

commitment_change_order_requests:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

commitment_change_orders:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

commitment_line_items:

• estimated_tax

• estimated_tax_company_currency

• estimated_tax_project_currency

• finance_object_id

• tax_codes

commitment_potential_change_orders:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

commitments:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

owner_invoice_line_item_with_markups:

• finance_object_id

• gross_amount_plus_tax

• gross_amount_plus_tax_company_currency

• gross_amount_plus_tax_project_currency

• net_amount_plus_tax

• net_amount_plus_tax_company_currency

• net_amount_plus_tax_project_currency

• tax_amount

• tax_amount_company_currency

• tax_amount_project_currency

• tax_codes

owner_invoice_line_item_with_markups_relations:

• rel_owner_invoice_line_item_id

• tax_bridge_id

• tax_id

owner_invoice_line_items:

• finance_object_id

• gross_amount_plus_tax

• gross_amount_plus_tax_company_currency

• gross_amount_plus_tax_project_currency

• net_amount_plus_tax

• net_amount_plus_tax_company_currency

• net_amount_plus_tax_project_currency

• tax_amount

• tax_amount_company_currency

• tax_amount_project_currency

• tax_codes

owner_invoices:

• gross_amount_plus_tax

• gross_amount_plus_tax_company_currency

• gross_amount_plus_tax_project_currency

• net_amount_plus_tax

• net_amount_plus_tax_company_currency

• net_amount_plus_tax_project_currency

• tax_total

• tax_total_company_currency

• tax_total_project_currency

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

prime_contract_change_order_line_items:

• estimated_tax

• estimated_tax_company_currency

• estimated_tax_project_currency

• finance_object_id

• tax_codes

prime_contract_change_order_requests:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

prime_contract_change_orders:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

prime_contract_line_items:

• estimated_tax

• estimated_tax_company_currency

• estimated_tax_project_currency

• finance_object_id

• tax_codes

prime_contract_potential_change_orders:

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

• total_estimated_tax

• total_estimated_tax_company_currency

• total_estimated_tax_project_currency

subcontractor_invoice_line_items:

• finance_object_id

• gross_amount_plus_tax

• gross_amount_plus_tax_company_currency

• gross_amount_plus_tax_project_currency

• net_amount_plus_tax

• net_amount_plus_tax_company_currency

• net_amount_plus_tax_project_currency

• subcontractor_sov_id

• tax_amount

• tax_amount_company_currency

• tax_amount_project_currency

• tax_codes

subcontractor_invoices:

• gross_amount_plus_tax

• gross_amount_plus_tax_company_currency

• gross_amount_plus_tax_project_currency

• net_amount_plus_tax

• net_amount_plus_tax_company_currency

• net_amount_plus_tax_project_currency

• tax_total

• tax_total_company_currency

• tax_total_project_currency

• taxable_amount

• taxable_amount_company_currency

• taxable_amount_project_currency

subcontractor_sov:

• amount

• amount_company_currency

• amount_project_currency

• audit_transaction_timestamp

• commitment_id

• commitment_line_item_id

• company_id

• created_at

• description

• project_id

• sov_position_number

• subcontractor_sov_id

• updated_at

• wbs_code_id

tax:

• active_date_range

• audit_transaction_timestamp

• company_id

• created_by

• created_by_id

• created_on

• description

• invoice_tax_application

• rate

• status

• tax_code

• tax_code_id

• tax_code_rate_id

• tax_id

estimate_layer_groups:

• group_multiplier

• total_quantity

• unit_of_measure

estimate_layers:

• catalog_number

• cost_catalog_item

• manufacturer

• supplier

• total_cost_per_square_feet

• total_equipment_cost

• total_material_cost

• total_quantity

• total_subcontractor_cost

• total_travel_cost

• uom_labor_time

• uom_quantity

coordination_issue_watcher:

• audit_transaction_timestamp

• company_id

• company_name

• coordination_issue_id

• coordination_issue_watcher_id

• created_at

• login_information_id

• name

• project_id

incident_action:

• incident_created_by

• incident_created_by_login

• incident_private

incident_alert:

• incident_created_by

• incident_created_by_login

• incident_private

incident_injury_body_part:

• incident_created_by

• incident_created_by_login

• incident_private

incident_record:

• incident_created_by

• incident_created_by_login

• incident_private

incident_witness_statement:

• incident_created_by

• incident_created_by_login

• incident_private

observation:

• assignee_user_id_list

scheduling_activity:

• activity_id

scheduling_relationship:

• updated_by

scheduling_type:

• updated_by

assignments:

• created_by_id

daily_timecards_and_assignments:

• assignment_count

• company_id

• daily_assignment_hours

• daily_timecard_hours

• daily_timecards_and_assignments_id

• date

• employee_id

• is_current_week

• is_missing_timecards

• missing_hours

• project_id

• week_end_date

• week_number

• week_start_date

labor_equipment_productivity:

• total_percent_completion

maintenance_record:

• start_date_iso

timecard_entries:

• employee_name

pay_requirement_settings:

• invoice_signed

payments_requirements:

• invoice_signed

materials:

• company_id

• project_id

• item_name

• item_description

• item_uom

• total_required_quantity

• total_shipped_quantity

• total_ordered_quantity

• total_received_quantity

• total_available_quantity

• total_issued_quantity

• material_id

• audit_transaction_timestamp

• created_at

• updated_by

materials_shipment:

• company_id

• project_id

• shipment_number

• shipment_line_number

• shipped_quantity

• shipment_line_uom

• shipment_forecast_delivery_date

• shipment_state

• shipment_final_date

• materials_shipment_id

• shipment_line_item_uuid

• materials_shipment_id

• shipment_line_link

• shipment_refdoc_link

• audit_transaction_timestamp

• created_at

• updated_by

materials_receipt:

• company_id

• project_id

• receipt_number

• receipt_line_number

• receipt_line_condition

• received_date

• received_quantity

• receipt_line_uom

• receipt_document_status

• receipt_posted_date

• receipt_location

• receipt_uuid

• materials_receipt_id

• receipt_line_item_uuid

• receipt_line_link

• receipt_refdoc_link

• audit_transaction_timestamp

• created_at

• updated_by 

materials_purchase_order:

• company_id

• project_id

• po_number

• vendor

• po_line_number

• po_line_ordered_quantity

• po_line_uom

• po_final_date

• po_document_state

• contract_delivery_date

• estimated_delivery_date

• materials_purchase_order_id

• po_line_item_uuid

• po_line_link

• audit_transaction_timestamp

• created_at

• updated_by

project_dates:

• actual_date

• audit_transaction_timestamp

contacts:

• job_title

project_contacts:

• job_title

projects:

• store_number

commitments:

• invoice_contacts_list

payments_manual_holds:

• vendor_id

daily_log_accident:

• location_id

• vendor_id

daily_log_construction_reports:

• location_id

daily_log_delay:

• vendor_id

• vendor_name

daily_log_delivery:

• location_id

• vendor_id

• vendor_name

daily_log_dumpster:

• location_id

daily_log_equipment:

• vendor_id

• vendor_name

daily_log_inspection:

• vendor_id

• vendor_name

daily_log_note:

• vendor_id

• vendor_name

daily_log_observed_weather_condition:

• location_id

• vendor_id

• vendor_name

daily_log_phone_call:

• location_id

• vendor_id

• vendor_name

daily_log_plan_revision:

• location_id

• vendor_id

• vendor_name

daily_log_productivity:

• location_id

daily_log_quantity:

• vendor_id

• vendor_name

daily_log_safety_violation:

• location_id

• vendor_id

daily_log_scheduled_work:

• location_id

• vendor_id

• vendor_name

daily_log_visitor:

• location_id

• vendor_id

• vendor_name

daily_log_waste:

• location_id

scheduling_activity:

• audit_transaction_timestamp

• calendar_id

• calendar_name

• category_data

• company_id

• constraint_date

• constraint_type

• created_at

• created_by

• deadline_date

• deadline_variance

• duration

• duration_display_unit

• duration_unit

• finish_date

• is_actual_finish

• is_actual_start

• is_critical

• is_placeholder

• note

• sibling_position

• parent_id

• percent_done

• project_id

• resource_data

• crew_size

• schedule_activity_id

• schedule_id

• start_date

• activity_name

• total_float

• updated_at

• vendor_id

• vendor_name

scheduling_activity_custom_fields:

• activity_category_assignment_id

• alias_project_custom_field_id

• company_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• project_id

• schedule_activity_id

• schedule_id

• scheduling_activity_custom_field_id

scheduling_relationship:

• audit_transaction_timestamp

• company_id

• created_at

• created_by

• dependency_type

• from_activity

• is_active

• lag

• lag_display_unit

• project_id

• schedule_id

• schedule_relationship_id

• to_activity

• updated_at

scheduling_type:

• audit_transaction_timestamp

• calendar_id

• company_id

• created_at

• created_by

• imported_data_date

• is_active

• name

• parent_schedule_id

• project_id

• schedule_id

• start_date

• type

• updated_at

employees:

• contact_id

labor_allocations:

• audit_transaction_timestamp

• created_by

scheduling_activity:

• display_id

budget_view_standard_columns:

• original_budget_amount_project_currency

• original_budget_amount_company_currency

• budget_modifications_project_currency

• budget_modifications_company_currency

• forecast_to_complete_automatic_sum_project_currency

• forecast_to_complete_automatic_sum_company_currency

• forecast_to_complete_manual_sum_project_currency

• forecast_to_complete_manual_sum_company_currency

• forecast_to_complete_aggregate_sum_project_currency

• forecast_to_complete_aggregate_sum_company_currency

• approved_co_amount_sum_project_currency

• approved_co_amount_sum_company_currency

• approved_budget_changes_amount_sum_project_currency

• approved_budget_changes_amount_sum_company_currency

• committed_costs_sum_project_currency

• committed_costs_sum_company_currency

• direct_cost_total_amount_sum_project_currency

• direct_cost_total_amount_sum_company_currency

• pending_cost_changes_sum_project_currency

• pending_cost_changes_sum_company_currency

• subcontractor_invoice_sum_project_currency

• subcontractor_invoice_sum_company_currency

• projected_costs_sum_project_currency

• projected_costs_sum_company_currency

• estimated_cost_at_completion_project_currency

• estimated_cost_at_completion_company_currency

• job_to_date_costs_sum_project_currency

• job_to_date_costs_sum_company_currency

• pending_co_sum_project_currency

• pending_co_sum_company_currency

• revised_budget_sum_project_currency

• revised_budget_sum_company_currency

• projected_budget_sum_project_currency

• projected_budget_sum_company_currency

• projected_over_under_sum_project_currency

• projected_over_under_sum_company_currency

contract

Estimates:

• other_adjustment1

• other_adjustment1_amount

• other_adjustment1_name

• other_adjustment1_percentage

• other_adjustment2

• other_adjustment2_amount

• other_adjustment2_name

• other_adjustment2_percentage

• other_adjustment3

• other_adjustment3_amount

• other_adjustment3_name

• other_adjustment3_percentage

• other_adjustment4

• other_adjustment4_amount

• other_adjustment4_name

• other_adjustment4_percentage

field_productivity:

• is_budgeted

requests:

• job_title_id_2

incident_record_custom_fields:

• custom_field_definitions_id from bigint to string

incident_record_custom_field_configs:

• custom_field_definition_id from bigint to string

budget_change_adjustment_line_items:

• unit_cost_project_currency from decimal(23,4) to decimal(38,5)

• unit_cost_company_currency from decimal(30,4) to decimal(38,5)

• amount_project_currency from decimal(21,2) to decimal(38,5)

• amount_company_currency from decimal(28,2) to decimal(38,5)

• budget_changes_approved_amount_project_currency from decimal(21,2) to decimal(38,5)

• budget_changes_approved_amount_company_currency from decimal(28,2) to decimal(38,5)

• budget_changes_under_review_amount_project_currency from decimal(21,2) to decimal(38,5)

• budget_changes_under_review_amount_company_currency from decimal(28,2) to decimal(38,5)

• budget_changes_draft_amount_project_currency from decimal(21,2) to decimal(38,5)

• budget_changes_draft_amount_company_currency from decimal(28,2) to decimal(38,5)

• changes_to_budgeted_amount_project_currency from decimal(21,2) to decimal(38,5)

• changes_to_budgeted_amount_company_currency from decimal(28,2) to decimal(38,5)

• pending_changes_to_budgeted_amount_project_currency from decimal(21,2) to decimal(38,5)

• pending_changes_to_budgeted_amount_company_currency from decimal(28,2) to decimal(38,5)

budget_forecast_line_items:

• amount_project_currency from decimal(21,2) to decimal(38,5)

• amount_company_currency from decimal(28,2) to decimal(38,5)

• unit_cost_project_currency from decimal(21,2) to decimal(38,5)

• unit_cost_company_currency from decimal(28,2) to decimal(38,5)

• forecast_to_complete_project_currency from decimal(21,2) to decimal(38,5)

• forecast_to_complete_company_currency from decimal(28,2) to decimal(38,5)

budget_line_items:

• original_budget_amount_project_currency from decimal(21,2) to decimal(38,5)

• original_budget_amount_company_currency from decimal(28,2) to decimal(38,5)

• unit_cost_project_currency from decimal(23,4) to decimal(38,5)

• unit_cost_company_currency from decimal(30,4) to decimal(38,5)

budget_modifications:

• transfer_amount_project_currency from decimal(23,2) to decimal(38,5)

• transfer_amount_company_currency from decimal(30,2) to decimal(38,5)

change_event_line_item_with_markups:

• cost_rom_project_currency from decimal(22,2) to decimal(38,5)

• cost_rom_company_currency from decimal(28,2) to decimal(38,5)

• cost_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)

• cost_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)

• revenue_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)

• revenue_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)

change_event_line_items:

• cost_rom_project_currency from decimal(22,2) to decimal(38,5)

• cost_rom_company_currency from decimal(28,2) to decimal(38,5)

• cost_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)

• cost_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)

• revenue_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)

• revenue_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)

commitment_change_order_line_items:

• unit_cost_project_currency from decimal(29,4) to decimal(38,5)

• unit_cost_company_currency from decimal(36,4) to decimal(38,5)

• manual_amount_project_currency from decimal(27,2) to decimal(38,5)

• manual_amount_company_currency from decimal(34,2) to decimal(38,5)

• total_amount_project_currency from decimal(27,2) to decimal(38,5)

• total_amount_company_currency from decimal(34,2) to decimal(38,5)

• approximate_bottom_line_amount_project_currency from decimal(27,2) to decimal(38,5)

• approximate_bottom_line_amount_company_currency from decimal(34,2) to decimal(38,5)

• extended_amount_project_currency from decimal(27,2) to decimal(38,5)

• extended_amount_company_currency from decimal(34,2) to decimal(38,5)

• amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• change_order_committed_amount_project_currency from decimal(27,2) to decimal(38,5)

• change_order_committed_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pendings_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pendings_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_approved_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_approved_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_draft_amount_project_currency from decimal(27,2) to decimal(38,5)>>>

• potential_change_order_draft_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_not_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_not_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pending_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pending_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_revised_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_revised_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_not_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_not_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_no_charge_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_no_charge_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_rejected_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_rejected_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_void_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_void_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pending_billable_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pending_billable_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pendings_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_pendings_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_approved_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_approved_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_draft_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_draft_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_not_pricing_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_not_pricing_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_pricing_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_pricing_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_pending_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_pending_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_revised_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_revised_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_proceeding_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_proceeding_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_not_proceeding_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_not_proceeding_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_no_charge_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_no_charge_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_rejected_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_rejected_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_void_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_void_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_pending_billable_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)

• potential_change_order_pending_billable_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)

commitment_change_order_requests:

• amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)

• amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)

• grand_total_project_currency from decimal(37,2) to decimal(38,5)

• grand_total_company_currency from decimal(38,2) to decimal(38,5)

commitment_change_orders:

• amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)

• amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)

• grand_total_project_currency from decimal(37,2) to decimal(38,5)

• grand_total_company_currency from decimal(38,2) to decimal(38,5)

commitment_line_items:

• unit_cost_project_currency from decimal(29,4) to decimal(38,5)

• unit_cost_company_currency from decimal(36,4) to decimal(38,5)

• manual_amount_project_currency from decimal(27,2) to decimal(38,5)

• manual_amount_company_currency from decimal(34,2) to decimal(38,5)

• total_amount_project_currency from decimal(27,2) to decimal(38,5)

• total_amount_company_currency from decimal(34,2) to decimal(38,5)

• approximate_bottom_line_amount_project_currency from decimal(27,2) to decimal(38,5)

• approximate_bottom_line_amount_company_currency from decimal(34,2) to decimal(38,5)

• extended_amount_project_currency from decimal(27,2) to decimal(38,5)

• extended_amount_company_currency from decimal(34,2) to decimal(38,5)

• contracts_approved_amount_project_currency from decimal(27,2) to decimal(38,5)

• contracts_approved_amount_company_currency from decimal(34,2) to decimal(38,5)

• contracts_draft_amount_project_currency from decimal(27,2) to decimal(38,5)

• contracts_draft_amount_company_currency from decimal(34,2) to decimal(38,5)

• contracts_out_for_signature_amount_project_currency from decimal(27,2) to decimal(38,5)

• contracts_out_for_signature_amount_company_currency from decimal(34,2) to decimal(38,5)

• contracts_complete_amount_project_currency from decimal(27,2) to decimal(38,5)

• contracts_complete_amount_company_currency from decimal(34,2) to decimal(38,5)

commitment_potential_change_orders:

• extended_total_project_currency from decimal(27,2) to decimal(38,5)

• extended_total_company_currency from decimal(34,2) to decimal(38,5)

• grand_total_project_currency from decimal(27,2) to decimal(38,5)

• grand_total_company_currency from decimal(34,2) to decimal(38,5)

commitments:

• total_payments_project_currency from decimal(27,2) to decimal(38,5)

• total_payments_company_currency from decimal(34,2) to decimal(38,5)

• line_items_total_project_currency from decimal(27,2) to decimal(38,5)

• line_items_total_company_currency from decimal(34,2) to decimal(38,5)

• line_items_extended_total_project_currency from decimal(27,2) to decimal(38,5)

• line_items_extended_total_company_currency from decimal(34,2) to decimal(38,5)

• grand_total_project_currency from decimal(27,2) to decimal(38,5)

• grand_total_company_currency from decimal(34,2) to decimal(38,5)

• revised_contract_amount_project_currency from decimal(35,2) to decimal(38,5)

• revised_contract_amount_company_currency from decimal(35,2) to decimal(38,5)

• remaining_balance_project_currency from decimal(35,2) to decimal(38,5)

• remaining_balance_company_currency from decimal(35,2) to decimal(38,5)

• pending_change_orders_project_currency from decimal(35,2) to decimal(38,5)

• pending_change_orders_company_currency from decimal(35,2) to decimal(38,5)

• approved_change_orders_project_currency from decimal(35,2) to decimal(38,5)

• approved_change_orders_company_currency from decimal(35,2) to decimal(38,5)

• draft_change_orders_project_currency from decimal(35,2) to decimal(38,5)

• draft_change_orders_company_currency from decimal(35,2) to decimal(38,5)

• invoiced_project_currency from decimal(29,2) to decimal(38,5)

• invoiced_company_currency from decimal(35,2) to decimal(38,5)

• pending_revised_contract_amount_project_currency from decimal(35,2) to decimal(38,5)

• pending_revised_contract_amount_company_currency from decimal(35,2) to decimal(38,5)

direct_cost_line_items:

• unit_cost_project_currency from decimal(29,4) to decimal(38,5)

• unit_cost_company_currency from decimal(36,4) to decimal(38,5)

• manual_amount_project_currency from decimal(27,2) to decimal(38,5)

• manual_amount_company_currency from decimal(34,2) to decimal(38,5)

• extended_amount_project_currency from decimal(27,2) to decimal(38,5)

• extended_amount_company_currency from decimal(34,2) to decimal(38,5)

• approved_total_amount_project_currency from decimal(27,2) to decimal(38,5)

• approved_total_amount_company_currency from decimal(34,2) to decimal(38,5)

• payroll_unit_cost_project_currency from decimal(29,4) to decimal(38,5)

• payroll_unit_cost_company_currency from decimal(36,4) to decimal(38,5)

• amount_total_project_currency from decimal(27,2) to decimal(38,5)

• amount_total_company_currency from decimal(34,2) to decimal(38,5)

• amount_grand_total_project_currency from decimal(27,2) to decimal(38,5)

• amount_grand_total_company_currency from decimal(34,2) to decimal(38,5)

erp_job_costs:

• job_to_date_cost_project_currency from decimal(19,2) to decimal(38,5)

• job_to_date_cost_company_currency from decimal(26,2) to decimal(38,5)

• commitment_invoiced_project_currency from decimal(19,2) to decimal(38,5)

• commitment_invoiced_company_currency from decimal(26,2) to decimal(38,5)

direct_costs:

• amount_total_project_currency from decimal(27,2) to decimal(38,5)

• amount_total_company_currency from decimal(34,2) to decimal(38,5)

• amount_grand_total_project_currency from decimal(27,2) to decimal(38,5)

• amount_grand_total_company_currency from decimal(34,2) to decimal(38,5)

monitoring_resources:

• unit_cost_project_currency from decimal(23,4) to decimal(38,5)

• unit_cost_company_currency from decimal(30,4) to decimal(38,5)

owner_invoice_line_item_with_markups:

• previous_materials_retainage_project_currency from decimal(38,2) to decimal(38,5)

• scheduled_value_project_currency from decimal(27,2) to decimal(38,5)

• scheduled_value_company_currency from decimal(34,2) to decimal(38,5)

• approved_changes from decimal(20,2) to decimal(38,5)

• approved_changes_project_currency from decimal(27,2) to decimal(38,5)

• approved_changes_company_currency from decimal(34,2) to decimal(38,5)

• unit_price_project_currency from decimal(29,4) to decimal(38,5)

• unit_price_company_currency from decimal(36,4) to decimal(38,5)

• previous_work_completed_value_project_currency from decimal(38,2) to decimal(38,5)

• previous_work_completed_value_company_currency from decimal(35,2) to decimal(38,5)

• work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_completed_this_period_company_currency from decimal(35,2) to decimal(38,5)

• gross_amount_project_currency from decimal(29,2) to decimal(38,5)

• gross_amount_company_currency from decimal(35,2) to decimal(38,5)

• materials_presently_stored_project_currency from decimal(28,2) to decimal(38,5)

• materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)

• total_completed_and_stored_to_date_project_currency from decimal(37,2) to decimal(38,5)

• total_completed_and_stored_to_date_company_currency from decimal(35,2) to decimal(38,5)

• balance_to_finish_project_currency from decimal(38,2) to decimal(38,5)

• balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)

• work_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• work_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• total_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• total_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• work_retainage_retained_this_period_project_currency from decimal(35,2) to decimal(38,5)

• work_retainage_retained_this_period_company_currency from decimal(36,2) to decimal(38,5)

• materials_retainage_retained_this_period_project_currency from decimal(20,2) to decimal(38,5)

• materials_retainage_retained_this_period_company_currency from decimal(28,2) to decimal(38,5)

• work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• total_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• total_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• work_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• work_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)

• materials_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• materials_retainage_currently_retained_company_currency from decimal(35,2) to decimal(38,5)

• total_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• total_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)

• from_previous_application_total_project_currency from decimal(38,2) to decimal(38,5)

• from_previous_application_total_company_currency from decimal(35,2) to decimal(38,5)

• work_retainage_this_period_project_currency from decimal(34,2) to decimal(38,5)

• work_retainage_this_period_company_currency from decimal(35,2) to decimal(38,5)

• materials_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• materials_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• materials_previously_stored_project_currency from decimal(29,2) to decimal(38,5)

• materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)

• materials_retainage_released_this_period_project_currency from decimal(10,0) to decimal(38,5)

• materials_retainage_released_this_period_company_currency from decimal(10,0) to decimal(38,5)

• new_materials_project_currency from decimal(27,2) to decimal(38,5)

• new_materials_company_currency from decimal(34,2) to decimal(38,5)

owner_invoice_line_items:

• previous_materials_retainage_project_currency from decimal(38,2) to decimal(38,5)

• scheduled_value_project_currency from decimal(27,2) to decimal(38,5)

• scheduled_value_company_currency from decimal(34,2) to decimal(38,5)

• approved_changes from decimal(20,2) to decimal(38,5)

• approved_changes_project_currency from decimal(27,2) to decimal(38,5)

• approved_changes_company_currency from decimal(34,2) to decimal(38,5)

• unit_price_project_currency from decimal(29,4) to decimal(38,5)

• unit_price_company_currency from decimal(36,4) to decimal(38,5)

• previous_work_completed_value_project_currency from decimal(38,2) to decimal(38,5)

• previous_work_completed_value_company_currency from decimal(35,2) to decimal(38,5)

• work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_completed_this_period_company_currency from decimal(35,2) to decimal(38,5)

• gross_amount_project_currency from decimal(29,2) to decimal(38,5)

• gross_amount_company_currency from decimal(35,2) to decimal(38,5)

• materials_presently_stored_project_currency from decimal(28,2) to decimal(38,5)

• materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)

• total_completed_and_stored_to_date_project_currency from decimal(37,2) to decimal(38,5)

• total_completed_and_stored_to_date_company_currency from decimal(35,2) to decimal(38,5)

• balance_to_finish_project_currency from decimal(38,2) to decimal(38,5)

• balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)

• work_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• work_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• total_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• total_retainage_from_previous_application_company_currency from decimal(35,2)>>> to decimal(38,5)

• work_retainage_retained_this_period_project_currency from decimal(35,2) to decimal(38,5)

• work_retainage_retained_this_period_company_currency from decimal(36,2) to decimal(38,5)

• materials_retainage_retained_this_period_project_currency from decimal(20,2) to decimal(38,5)

• materials_retainage_retained_this_period_company_currency from decimal(28,2) to decimal(38,5)

• work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• total_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• total_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• work_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• work_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)

• materials_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• materials_retainage_currently_retained_company_currency from decimal(35,2) to decimal(38,5)

• total_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• total_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)

• from_previous_application_total_project_currency from decimal(38,2) to decimal(38,5)

• from_previous_application_total_company_currency from decimal(35,2) to decimal(38,5)

• work_retainage_this_period_project_currency from decimal(34,2) to decimal(38,5)

• work_retainage_this_period_company_currency from decimal(35,2) to decimal(38,5)

• materials_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• materials_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• materials_previously_stored_project_currency from decimal(29,2) to decimal(38,5)

• materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)

• materials_retainage_released_this_period_project_currency from decimal(10,0) to decimal(38,5)

• materials_retainage_released_this_period_company_currency from decimal(10,0) to decimal(38,5)

• new_materials_project_currency from decimal(27,2) to decimal(38,5)

• new_materials_company_currency from decimal(34,2) to decimal(38,5)

owner_invoice_markup_line_items:

• previous_materials_retainage_project_currency from decimal(38,2) to decimal(38,5)

• scheduled_value_project_currency from decimal(27,2) to decimal(38,5)

• scheduled_value_company_currency from decimal(34,2) to decimal(38,5)

• approved_changes from decimal(20,2) to decimal(38,5)

• approved_changes_project_currency from decimal(27,2) to decimal(38,5)

• approved_changes_company_currency from decimal(34,2) to decimal(38,5)

• unit_price_project_currency from decimal(29,4) to decimal(38,5)

• unit_price_company_currency from decimal(36,4) to decimal(38,5)

• previous_work_completed_value_project_currency from decimal(38,2) to decimal(38,5)

• previous_work_completed_value_company_currency from decimal(35,2) to decimal(38,5)

• work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_completed_this_period_company_currency from decimal(35,2) to decimal(38,5)

• gross_amount_project_currency from decimal(29,2) to decimal(38,5)

• gross_amount_company_currency from decimal(35,2) to decimal(38,5)

• materials_presently_stored_project_currency from decimal(28,2) to decimal(38,5)

• materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)

• total_completed_and_stored_to_date_project_currency from decimal(37,2) to decimal(38,5)

• total_completed_and_stored_to_date_company_currency from decimal(35,2) to decimal(38,5)

• balance_to_finish_project_currency from decimal(38,2) to decimal(38,5)

• balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)

• work_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• work_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• total_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• total_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• work_retainage_retained_this_period_project_currency from decimal(35,2) to decimal(38,5)

• work_retainage_retained_this_period_company_currency from decimal(36,2) to decimal(38,5)

• materials_retainage_retained_this_period_project_currency from decimal(20,2) to decimal(38,5)

• materials_retainage_retained_this_period_company_currency from decimal(28,2) to decimal(38,5)

• work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• total_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• total_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• work_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• work_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)

• materials_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• materials_retainage_currently_retained_company_currency from decimal(35,2) to decimal(38,5)

• total_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)

• total_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)

• from_previous_application_total_project_currency from decimal(38,2) to decimal(38,5)

• from_previous_application_total_company_currency from decimal(35,2) to decimal(38,5)

• work_retainage_this_period_project_currency from decimal(34,2) to decimal(38,5)

• work_retainage_this_period_company_currency from decimal(35,2) to decimal(38,5)

• materials_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)

• materials_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)

• materials_previously_stored_project_currency from decimal(29,2) to decimal(38,5)

• materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)

• materials_retainage_released_this_period_project_currency from decimal(10,0) to decimal(38,5)

• materials_retainage_released_this_period_company_currency from decimal(10,0) to decimal(38,5)

• new_materials_project_currency from decimal(27,2) to decimal(38,5)

• new_materials_company_currency from decimal(34,2) to decimal(38,5)

owner_invoices:

• tax_applicable_to_this_payment_project_currency from decimal(36,2) to decimal(38,5)

• tax_applicable_to_this_payment_company_currency from decimal(36,2) to decimal(38,5)

• taxable_amount_project_currency from decimal(35,2) to decimal(38,5)

• taxable_amount_company_currency from decimal(35,2) to decimal(38,5)

• net_change_by_change_orders_project_currency from decimal(37,2) to decimal(38,5)

• net_change_by_change_orders_company_currency from decimal(38,2) to decimal(38,5)

• contract_sum_to_date_project_currency from decimal(37,2) to decimal(38,5)

• contract_sum_to_date_company_currency from decimal(38,2) to decimal(38,5)

• total_completed_and_stored_to_date_project_currency from decimal(38,2) to decimal(38,5)

• total_completed_and_stored_to_date_company_currency from decimal(38,2) to decimal(38,5)

• total_retainage_project_currency from decimal(38,2) to decimal(38,5)

• less_previous_certificates_for_payment_project_currency from decimal(38,2) to decimal(38,5)

• less_previous_certificates_for_payment_company_currency from decimal(38,2) to decimal(38,5)

• net_amount_project_currency from decimal(38,2) to decimal(38,5)

• net_amount_company_currency from decimal(38,2) to decimal(38,5)

• gross_amount_project_currency from decimal(38,2) to decimal(38,5)

• gross_amount_company_currency from decimal(38,2) to decimal(38,5)

• total_changes_approved_previous_months_by_owner_client_additions_project_currency from decimal(36,2) to decimal(38,5)

• total_changes_approved_previous_months_by_owner_client_additions_company_currency from decimal(36,2) to decimal(38,5)

• total_changes_approved_previous_months_by_owner_client_deductions_project_currency from decimal(36,2) to decimal(38,5)

• total_changes_approved_previous_months_by_owner_client_deductions_company_currency from decimal(36,2) to decimal(38,5)

• total_approved_this_month_additions_project_currency from decimal(37,2) to decimal(38,5)

• total_approved_this_month_additions_company_currency from decimal(38,2) to decimal(38,5)

• total_approved_this_month_deductions_project_currency from decimal(37,2) to decimal(38,5)

• total_approved_this_month_deductions_company_currency from decimal(38,2) to decimal(38,5)

• total_changes_approved_additions_project_currency from decimal(37,2) to decimal(38,5)

• total_changes_approved_additions_company_currency from decimal(38,2) to decimal(38,5)

• total_changes_approved_deductions_project_currency from decimal(37,2) to decimal(38,5)

• total_changes_approved_deductions_company_currency from decimal(38,2) to decimal(38,5)

• retainage_work_completed_to_date_project_currency from decimal(38,2) to decimal(38,5)

• retainage_work_completed_to_date_company_currency from decimal(38,2) to decimal(38,5)

• retainage_materials_presently_stored_project_currency from decimal(38,2) to decimal(38,5)

• retainage_materials_presently_stored_company_currency from decimal(38,2) to decimal(38,5)

• materials_presently_stored_project_currency from decimal(30,2) to decimal(38,5)

• materials_presently_stored_company_currency from decimal(38,2) to decimal(38,5)

• paid_amount_project_currency from decimal(35,2) to decimal(38,5)

• paid_amount_company_currency from decimal(35,2) to decimal(38,5)

payments_issued:

• amount_project_currency from decimal(27,2) to decimal(38,5)

• amount_company_currency from decimal(34,2) to decimal(38,5)

payments_received:

• amount_project_currency from decimal(27,2) to decimal(38,5)

• amount_company_currency from decimal(34,2) to decimal(38,5)

prime_contract_change_order_line_items:

• unit_cost_project_currency from decimal(29,4) to decimal(38,5)

• unit_cost_company_currency from decimal(36,4) to decimal(38,5)

• manual_amount_project_currency from decimal(27,2) to decimal(38,5)

• manual_amount_company_currency from decimal(34,2) to decimal(38,5)

• extended_amount_project_currency from decimal(27,2) to decimal(38,5)

• extended_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_approved_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_approved_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_draft_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_draft_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_not_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_not_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pending_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pending_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_revised_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_revised_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_not_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_not_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_no_charge_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_no_charge_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_rejected_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_rejected_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_void_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_void_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pending_billable_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pending_billable_amount_company_currency from decimal(34,2) to decimal(38,5)

• potential_change_order_pendings_amount_project_currency from decimal(27,2) to decimal(38,5)

• potential_change_order_pendings_amount_company_currency from decimal(34,2) to decimal(38,5)

prime_contract_change_order_requests:

• amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)

• amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)

• grand_total_project_currency from decimal(37,2) to decimal(38,5)

• grand_total_company_currency from decimal(38,2) to decimal(38,5)

prime_contract_change_orders:

• amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)

• amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)

• grand_total_project_currency from decimal(37,2) to decimal(38,5)

• grand_total_company_currency from decimal(38,2) to decimal(38,5)

prime_contract_line_items:

• unit_cost_project_currency from decimal(29,4) to decimal(38,5)

• unit_cost_company_currency from decimal(36,4) to decimal(38,5)

• amount_project_currency from decimal(27,2) to decimal(38,5)

• amount_company_currency from decimal(34,2) to decimal(38,5)

prime_contract_potential_change_orders:

• extended_total_project_currency from decimal(27,2) to decimal(38,5)

• extended_total_company_currency from decimal(34,2) to decimal(38,5)

• grand_total_project_currency from decimal(27,2) to decimal(38,5)

• grand_total_company_currency from decimal(34,2) to decimal(38,5)

prime_contracts:

• line_items_total_project_currency from decimal(27,2) to decimal(38,5)

• line_items_total_company_currency from decimal(34,2) to decimal(38,5)

• line_item_amount_project_currency from decimal(27,2) to decimal(38,5)

• line_item_amount_company_currency from decimal(34,2) to decimal(38,5)

• total_payments_project_currency from decimal(27,2) to decimal(38,5)

• total_payments_company_currency from decimal(34,2) to decimal(38,5)

• grand_total_project_currency from decimal(27,2) to decimal(38,5)

• grand_total_company_currency from decimal(34,2) to decimal(38,5)

• approved_change_orders_grand_total_project_currency from decimal(37,2) to decimal(38,5)

• approved_change_orders_grand_total_company_currency from decimal(38,2) to decimal(38,5)

request_for_quote_quotes:

• cost_project_currency from decimal(35,2) to decimal(38,5)

• cost_company_currency from decimal(35,2) to decimal(38,5)

request_for_quotes:

• estimated_amount_project_currency from decimal(27,2) to decimal(38,5)

• estimated_amount_company_currency from decimal(34,2) to decimal(38,5)

• original_quote_project_currency from decimal(27,2) to decimal(38,5)

• original_quote_company_currency from decimal(34,2) to decimal(38,5)

subcontractor_invoice_line_items:

• unit_price_project_currency from decimal(29,4) to decimal(38,5)

• unit_price_company_currency from decimal(36,4) to decimal(38,5)

• scheduled_value_project_currency from decimal(27,2) to decimal(38,5)

• scheduled_value_company_currency from decimal(34,2) to decimal(38,5)

• work_completed_from_previous_application_project_currency from decimal(20,2) to decimal(38,5)

• work_completed_from_previous_application_company_currency from decimal(28,2) to decimal(38,5)

• work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_completed_this_period_company_currency from decimal(34,2) to decimal(38,5)

• total_completed_and_stored_to_date_value_project_currency from decimal(29,2) to decimal(38,5)

• total_completed_and_stored_to_date_value_company_currency from decimal(36,2) to decimal(38,5)

• balance_to_finish_project_currency from decimal(30,2) to decimal(38,5)

• balance_to_finish_company_currency from decimal(37,2) to decimal(38,5)

• work_retainage_currently_retained_project_currency from decimal(27,2) to decimal(38,5)

• work_retainage_currently_retained_company_currency from decimal(34,2) to decimal(38,5)

• materials_retainage_currently_retained_project_currency from decimal(20,2) to decimal(38,5)

• materials_retainage_currently_retained_company_currency from decimal(28,2) to decimal(38,5)

• total_currently_retained_project_currency from decimal(28,2) to decimal(38,5)

• total_currently_retained_company_currency from decimal(35,2) to decimal(38,5)

• total_retainage_project_currency from decimal(32,2) to decimal(38,5)

• total_retainage_company_currency from decimal(35,2) to decimal(38,5)

• proposed_this_period_project_currency from decimal(27,2) to decimal(38,5)

• proposed_this_period_company_currency from decimal(34,2) to decimal(38,5)

• materials_presently_stored_project_currency from decimal(20,2) to decimal(38,5)

• materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)

• materials_previously_stored_project_currency from decimal(20,2) to decimal(38,5)

• materials_previously_stored_company_currency from decimal(28,2) to decimal(38,5)

• materials_previously_stored_from_project_currency from decimal(20,2) to decimal(38,5)

• materials_previously_stored_from_company_currency from decimal(28,2) to decimal(38,5)

• work_retainage_amount_project_currency from decimal(27,2) to decimal(38,5)

• work_retainage_amount_company_currency from decimal(34,2) to decimal(38,5)

• work_retainage_previous_application_amount_project_currency from decimal(20,2) to decimal(38,5)

• work_retainage_previous_application_amount_company_currency from decimal(28,2) to decimal(38,5)

• materials_retainage_previous_application_amount_project_currency from decimal(20,2) to decimal(38,5)

• materials_retainage_previous_application_amount_company_currency from decimal(28,2) to decimal(38,5)

• total_retainage_previous_application_amount_project_currency from decimal(21,2) to decimal(38,5)

• total_retainage_previous_application_amount_company_currency from decimal(29,2) to decimal(38,5)

• work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• materials_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)

• materials_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)

• new_materials_project_currency from decimal(27,2) to decimal(38,5)

• new_materials_company_currency from decimal(34,2) to decimal(38,5)

• total_completed_and_stored_to_date_from_previous_project_currency from decimal(29,2) to decimal(38,5)

• total_completed_and_stored_to_date_from_previous_company_currency from decimal(35,2) to decimal(38,5)

• net_amount_project_currency from decimal(32,2) to decimal(38,5)

• net_amount_company_currency from decimal(35,2) to decimal(38,5)

• gross_amount_project_currency from decimal(28,2) to decimal(38,5)

• gross_amount_company_currency from decimal(35,2) to decimal(38,5)

• retainage_new_materials_from_percent_project_currency from decimal(34,2) to decimal(38,5)

• retainage_new_materials_from_percent_company_currency from decimal(35,2) to decimal(38,5)

• adjusted_materials_retained_previously_project_currency from decimal(28,2) to decimal(38,5)

• adjusted_materials_retained_previously_company_currency from decimal(35,2) to decimal(38,5)

• adjusted_materials_previously_stored_project_currency from decimal(28,2) to decimal(38,5)

• adjusted_materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)

subcontractor_invoices:

• total_proposed_amount_project_currency from decimal(27,2) to decimal(38,5)

• total_proposed_amount_company_currency from decimal(34,2) to decimal(38,5)

• total_retainage_project_currency from decimal(21,2) to decimal(38,5)

• total_retainage_company_currency from decimal(29,2) to decimal(38,5)

• total_earned_less_retainage_project_currency from decimal(22,2) to decimal(38,5)

• total_earned_less_retainage_company_currency from decimal(30,2) to decimal(38,5)

• current_payment_due_project_currency from decimal(23,2) to decimal(38,5)

• current_payment_due_company_currency from decimal(31,2) to decimal(38,5)

• original_payment_due_project_currency from decimal(23,2) to decimal(38,5)

• original_payment_due_company_currency from decimal(31,2) to decimal(38,5)

• balance_to_finish_project_currency from decimal(29,2) to decimal(38,5)

• balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)

• net_change_by_change_orders_project_currency from decimal(38,2) to decimal(38,5)

• net_change_by_change_orders_company_currency from decimal(28,2) to decimal(38,5)

• contract_sum_to_date_project_currency from decimal(38,2) to decimal(38,5)

• contract_sum_to_date_company_currency from decimal(35,2) to decimal(38,5)

• total_contract_amount_project_currency from decimal(38,2) to decimal(38,5)

• total_contract_amount_company_currency from decimal(35,2) to decimal(38,5)

• total_completed_and_stored_to_date_project_currency from decimal(20,2) to decimal(38,5)

• total_completed_and_stored_to_date_company_currency from decimal(28,2) to decimal(38,5)

• retainage_work_completed_to_date_project_currency from decimal(38,2) to decimal(38,5)

• retainage_work_completed_to_date_company_currency from decimal(28,2) to decimal(38,5)

• retainage_materials_presently_stored_project_currency from decimal(20,2) to decimal(38,5)

• retainage_materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)

• total_changes_approved_in_previous_months_by_owner_client_additions_project_currency from decimal(37,2) to decimal(38,5)

• total_changes_approved_in_previous_months_by_owner_client_additions_company_currency from decimal(35,2) to decimal(38,5)

• total_changes_approved_in_previous_months_by_owner_client_deductions_project_currency from decimal(37,2) to decimal(38,5)

• total_changes_approved_in_previous_months_by_owner_client_deductions_company_currency from decimal(35,2) to decimal(38,5)

• total_changes_approved_this_month_additions_project_currency from decimal(27,2) to decimal(38,5)

• total_changes_approved_this_month_additions_company_currency from decimal(34,2) to decimal(38,5)

• total_changes_approved_this_month_deductions_project_currency from decimal(27,2) to decimal(38,5)

• total_changes_approved_this_month_deductions_company_currency from decimal(34,2) to decimal(38,5)

• total_changes_approved_additions_project_currency from decimal(27,2) to decimal(38,5)

• total_changes_approved_additions_company_currency from decimal(34,2) to decimal(38,5)

• total_changes_approved_deductions_project_currency from decimal(27,2) to decimal(38,5)

• total_changes_approved_deductions_company_currency from decimal(34,2) to decimal(38,5)

• less_certificates_for_payment_project_currency from decimal(20,2) to decimal(38,5)

• less_certificates_for_payment_company_currency from decimal(28,2) to decimal(38,5)

• completed_work_retainage_amount_project_currency from decimal(38,2) to decimal(38,5)

• completed_work_retainage_amount_company_currency from decimal(28,2) to decimal(38,5)

• gross_amount_project_currency from decimal(21,2) to decimal(38,5)

• gross_amount_company_currency from decimal(29,2) to decimal(38,5)

• net_amount_project_currency from decimal(23,2) to decimal(38,5)

• net_amount_company_currency from decimal(31,2) to decimal(38,5)

• paid_amount_project_currency from decimal(35,2) to decimal(38,5)

• paid_amount_company_currency from decimal(35,2) to decimal(38,5)

• total_tax_project_currency from decimal(27,2) to decimal(38,5)

• total_tax_company_currency from decimal(34,2) to decimal(38,5)

• total_payments_amount_project_currency from decimal(35,2) to decimal(38,5)

• total_payments_amount_company_currency from decimal(35,2) to decimal(38,5)

• early_pay_fee_amount_company_currency from decimal(26,2) to decimal(38,5)

wp_roles:

• company_id from string to bigint

• project_id from string to bigint

bid_Package:

• bid_Manager

• bid_submission_notifications

timecard_entries:

• clock_in_gps_onsite

• clock_out_gps_onsite

• lunch_clock_in_gps_onsite

• lunch_clock_out_gps_onsite

equipment_timecard_entry:

• idle_hours

labor_allocations:

• created_at

• updated_at

budget_change_adjustment_line_items:

• change_event_line_item_id

• vendor_id

budget_change_custom_fields:

• audit_transaction_timestamp

• budget_change_custom_field_id

• budget_change_id

• company_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• project_id

budget_forecast_line_items:

• wbs_code_id

commitment_change_order_line_items:

• vendor_id

commitment_line_items:

• prime_contract_line_item_id

• vendor_id

contract_compliance_documents:

• vendor_id

direct_cost_line_items:

• employee_id

• vendor_id

owner_invoices:

• vendor_id

payments_issued:

• disbursement_id

• vendor_id

payments_lien_waivers:

• commitment_id

• vendor_id

payments_received:

• vendor_id

payments_requirements:

• commitment_id

prime_contract_workflow_responses:

• vendor_id

prime_contract_workflow_steps:

• vendor_id

wbs_codes:

• wbs_code_status

submittal_approver_attachments:

• submittal_approver_attachment_id

• company_id

• company_type

• content_type

• submittal_approver_id

• submittal_id

• created_at

• created_by

• created_by_id

• created_by_login

• filename

• name

• project_id

• prostore_file_id

• updated_at

• viewable_type

inspection_item_attachments:

• inspection_item_attachment_id

• company_id

• company_type

• content_type

• inspection_item_id

• created_at

• created_by

• created_by_id

• created_by_login

• filename

• name

• project_id

• prostore_file_id

• updated_at

• viewable_type

invoice_compliance:

• vendor_id

subcontractor_invoices:

• early_pay_fee_amount_company_currency

• early_pay_fee_amount_project_currency

• total_contract_amount_company_currency

• total_contract_amount_project_currency

commitment_line_items:

• allow_these_users_to_see_sov_items

• contract_assignee_id

• contract_created_by_id

• contract_private

• contract_user_id_list

prime_contract_line_items:

• allow_these_users_to_see_sov_items

• contract_assignee_id

• contract_created_by_id

• contract_private

• contract_status

• contract_type

• contract_user_id_list

daily_log_accident:

• area

daily_log_construction_reports:

• area

daily_log_delay:

• area

daily_log_delivery:

• area

action_plan:

• approver_party_id_list

coordination_issue_custom_fields:

• audit_transaction_timestamp

• company_id

• coordination_issue_custom_field_id

• coordination_issue_id

• custom_field_data_type

• custom_field_definitions_id

• custom_field_name

• custom_field_value

• custom_field_value_id

• project_id

daily_log_dumpster:

• area

daily_log_equipment:

• area

daily_log_inspection:

• segment

daily_log_manpower:

• area

daily_log_note:

• area

daily_log_observed_weather_condition:

• area

daily_log_phone_call:

• area

daily_log_plan_revision:

• area

daily_log_productivity:

• area

daily_log_quantity:

• area

daily_log_safety_violation:

• area

daily_log_scheduled_work:

• area

daily_log_visitor:

• area

daily_log_waste:

• area

equipment_telematic:

• provider_name

• provider_id

equipment_telematics_daily_summary:

• active_regeneration_hours

• date

• distance

• equipment_telematics_daily_summary_id

• fuel_used

• fuel_used_last_24

• identification_number

• idle_hours

• idle_non_operating_hours

• load_count

• maximum_speed_last_24

• operating_hours

• power_take_off_hours

• company_id

• equipment_id

incident:

• assignee_id_list

• assignee_list

• global_status

incident_assignee:

• audit_transaction_timestamp

• company_id

• incident_assignee_id

• incident_id

• login

• project_id

• assignee_id

• company_name

• created_at

• name

• updated_at

commitments:

• bid_id

• bid_vendor_id

• bid_package_id

• bid_form_id

punch_item_activities:

• audit_transaction_timestamp

• company_id

• created_by_id

• created_by_login

• project_id

• punch_item_id

• attachments_count

• comment

• created_at

• created_by_name

• punch_item_activity_id

• status

• updated_at

rfi_responses:

• rfi_project_id

site_instruction_attentions:

• user_id

• name

incident_record:

• equipment_identification_number

• equipment_id

• equipment_name

site_instruction_distribution_members:

• user_id

• name

specification_sections:

• created_by_id

bid_package:

• require_nda

labor_equipment_productivity:

• cost_code

• wbs_code_flat_code

• labor_estimated_hours

• labor_reported_hours

• labor_reported_cost

• labor_percent_completion

• equipment_estimated_hours

• equipment_reported_hours

• equipment_reported_cost

• equipment_percent_completion

• total_estimated_hours

• total_reported_hours

• total_reported_cost

• labor_equipment_productivity_id

• company_id

• project_id

• cost_code_id

• wbs_code_id

timecard_entries:

• wp_people_id

labor_allocations:

• labor_allocation_id

• allocation_date

• wbs_code_id

• allocation_hours

• company_id

• project_id

• created_by_id

prime_contract:

• pending_change_orders

• invoiced

• approved_change_orders

• pending_revised_contract_amount

• remaining_balance

• revised_contract_amount

• draft_change_orders

• pending_change_orders_project_currency

• invoiced_project_currency

• approved_change_orders_project_currency

• pending_revised_contract_amount_project_currency

• remaining_balance_project_currency

• revised_contract_amount_project_currency

• draft_change_orders_company_currency

• pending_change_orders_company_currency

• invoiced_company_currency

• approved_change_orders_company_currency

• pending_revised_contract_amount_company_currency

• remaining_balance_company_currency

• revised_contract_amount_company_currency

• draft_change_orders_company_currency

rfis:

• attachment_count

budget_forecasts

submittal_approvers:

• variance_at_end

Bid:

• invitation_first_sent_at

projects:

• budget_locked

• actual_completion_date

form_template:

• company_id

• created_by_id

• prostore_file_id

• audit_transaction_timestamp

• form_template_id

• name

• description

• created_at

• updated_at

• archived_at

commitments:

• draft_change_orders_company_currency

• invoiced_company_currency

• pending_change_orders_company_currency

• pending_revised_contract_amount_company_currency

• approved_change_orders_company_currency

• approved_change_orders_project_currency

• contract_user_id_list

• draft_change_orders_project_currency

• invoiced_project_currency

• pending_change_orders_project_currency

• pending_revised_contract_amount_project_currency

• remaining_balance_project_currency

• revised_contract_amount_project_currency

• workflow_distribution_member_id_list

• workflow_role_user_id_list

• pending_revised_contract_amount_company_currency

commitment_change_order_workflow_responses:

• current_step_response

commitment_pco_workflow_responses:

• current_step_response

correspondence_workflow_responses:

• current_step_response

drawing_revision:

• current_revision

• reviewed_by_id

• status_id

prime_contracts:

• contract_user_id_list

• workflow_distribution_member_id_list

• workflow_role_user_id_list

budget_change_workflow_responses:

• current_step_response

• remaining_balance_company_currency

• revised_contract_amount_company_currency

bid_item:

• bid_vendor_id

bid_vendor:

• bid_form_id

estimate_adjustment:

• procore_project_id

estimate_budget_item:

• procore_project_id

estimate_budget_item_included_item:

• procore_project_id

estimate_layer_groups:

• procore_project_id

estimate_layers:

• procore_project_id

estimates:

• procore_project_id

estimating_project_custom_fields:

• procore_project_id

action_plan:

• assignee_party_id_list

• completed_plan_receiver_party_id_list

correspondence_assignees:

• user_id

correspondence_distributions:

• user_id

correspondences:

• assignee_id_list

• composite_provider_key

• distribution_member_id_list

daily_log_accident:

• created_by_collaborator

• raw_status

daily_log_construction_reports:

• created_by_collaborator

• raw_status

daily_log_delay:

• created_by_collaborator

• raw_status

daily_log_delivery:

• created_by_collaborator

• raw_status

daily_log_dumpster:

• created_by_collaborator

• raw_status

daily_log_equipment:

• created_by_collaborator

• raw_status

daily_log_inspection:

• created_by_collaborator

• raw_status

daily_log_manpower:

• created_by_collaborator

• raw_status

daily_log_note:

• created_by_collaborator

• raw_status

daily_log_observed_weather_condition:

• created_by_collaborator

• raw_status

daily_log_phone_call:

• created_by_collaborator

• raw_status

daily_log_plan_revision:

• created_by_collaborator

• raw_status

daily_log_productivity:

• created_by_collaborator

• raw_status

daily_log_quantity:

• created_by_collaborator

• raw_status

daily_log_safety_violation:

• created_by_collaborator

• raw_status

daily_log_scheduled_work:

• created_by_collaborator

• raw_status

daily_log_visitor:

• created_by_collaborator

• raw_status

daily_log_waste:

• created_by_collaborator

• raw_status

inspection_items:

• date_value_timestamp

incident:

• distribution_member_id_list

• recipient_id_list

incident_alert:

• permission_recipient_id

• recipient_name

site_instruction_attentions:

• member_name

• audit_transaction_timestamp

• company_id

• site_instruction_attention_id

• member_id

• project_id

• site_instruction_id

site_instruction_distribution_members:

• member_name

• site_instruction_distribution_member_id

• audit_transaction_timestamp

• company_id

• member_id

• project_id

• site_instruction_id

site_instructions:

• attention_user_id_list

• distribution_member_id_list

inspections:

• assignee_id_list

• distribution_member_id_list

• signature_id_list

meeting:

• assignee_id_list

meeting_attendee:

• person_id

observation:

• distribution_member_ids

observation_distribution_member:

• user_id

punch_item:

• assignee_id_list

• distribution_member_id_list

• permission_workflow_status

rfi_responses:

• assignee_id_list

• distribution_member_id_list

• rfi_created_by_id

• rfi_draft

• rfi_hidden

• rfi_manager_id

• rfi_private

rfis:

• assignee_id_list

• distribution_member_id_list

schedule_calendar_item:

• assigned_id

schedule_lookahead:

• created_by_id

schedule_lookahead_task:

• created_by_id

schedule_task:

• created_by_id

maintenance_record:

• type

• duration

• start_date

• issue

• notes

• maintenance_record_id

• company_id

• equipment_id

owner_invoice_workflow_responses:

• current_step_response

task:

• assignee_user_id_list

• created_by_id

• task_item_distribution_member_id_list

task_assignee:

• assignee_id

task_distribution_member:

• user_id

prime_contract_workflow_responses:

• current_step_response

prime_contract_change_order_workflow_responses:

• current_step_response

prime_contract_pco_workflow_responses:

• current_step_response

submittals:

• approvers_ids

• distribution_id_list

specification_sections:

• current_revision

• issued_date

• received_date

• revision

Estimate:

• include_in_primary_estimate

equipment_timecard_entry_custom_fields:

• batch_id

• partition_company_id

• equipment_timecard_entry_id

• equipment_timecard_entry_custom_field_id

• custom_field_value

• custom_field_value_id

• custom_field_definitions_id

• custom_field_name

• custom_field_data_type

• company_id

• project_id

estimating_projects:

• primary_contact_full_address

subcontractor_invoice_workflow_responses:

• current_step_response

assignments:

• percent_allocation

wp_wage_overrides:

• wp_project_id

• wp_wage_override_id

• job_title_id

• company_id

• job_title

• wage_override_rate

• project_id

tags:

• wp_people_id

• wp_project_id

commitment_workflow_response_occurrences:

• current_step_response

budget_change_custom_field_configs

change_event_custom_field_configs

commitment_co_custom_field_configs

commitment_custom_field_configs

commitment_pco_custom_field_configs

prime_contract_co_custom_field_configs

prime_contract_pco_custom_field_configs

prime_contract_custom_field_configs

subcontractor_invoice_custom_field_configs

action_plan_custom_field_configs

correspondence_custom_field_configs

daily_log_construction_report_custom_field_configs

daily_log_equipment_custom_field_configs

daily_log_manpower_custom_field_configs

inspection_custom_field_configs

observation_custom_field_configs

punch_item_custom_field_configs

rfi_custom_field_configs

submittal_custom_field_configs

time_and_material_entry_custom_field_configs

time_and_material_equipment_custom_field_configs

time_and_material_labors_custom_field_configs

time_and_material_material_custom_field_configs

time_and_material_entry_subcontractor_field_configs

timecard_entry_custom_field_configs

bid_item:

• bidding_vendor_id

bid_vendor:

• bidding_vendor_id

bid:

• bidding_vendor_id

contracts:

• bidding_vendor_id

wp_people:

• tags

• tag_instance_id

• wp_people_project_tag_id

• wp_project_id

wp_projects:

• tags

• tag_instance_id

• wp_project_tag_id

action_plan_custom_fields:

• custom_field_value_id from int to string

budget_change_custom_fields:

• custom_field_value_id from int to string

change_event_custom_fields:

• custom_field_value_id from int to string

commitment_co_custom_fields:

• custom_field_value_id from int to string

commitment_custom_fields:

• custom_field_value_id from int to string

commitment_pco_custom_fields:

• custom_field_value_id from int to string

company_folder_documents_custom_fields:

• custom_field_value_id from int to string

correspondence_custom_fields:

• custom_field_value_id from int to string

daily_log_accident_custom_fields:

• custom_field_value_id from int to string

daily_log_construction_report_custom_fields:

• custom_field_value_id from int to string

daily_log_delay_custom_fields:

• custom_field_value_id from int to string

daily_log_delivery_custom_fields:

• custom_field_value_id from int to string

daily_log_dumpster_custom_fields:

• custom_field_value_id from int to string

daily_log_equipment_custom_fields:

• custom_field_value_id from int to string

daily_log_inspection_custom_fields:

• custom_field_value_id from int to string

daily_log_manpower_custom_fields:

• custom_field_value_id from int to string

daily_log_note_custom_fields:

• custom_field_value_id from int to string

daily_log_phone_call_custom_fields:

• custom_field_value_id from int to string

daily_log_plan_revision_custom_fields:

• custom_field_value_id from int to string

daily_log_productivity_custom_fields:

• custom_field_value_id from int to string

daily_log_quantity_custom_fields:

• custom_field_value_id from int to string

daily_log_safety_violation_custom_fields:

• custom_field_value_id from int to string

daily_log_scheduled_work_custom_fields:

• custom_field_value_id from int to string

daily_log_visitor_custom_fields:

• custom_field_value_id from int to string

daily_log_waste_custom_fields:

• custom_field_value_id from int to string

drawing_revision_custom_fields:

• custom_field_value_id from int to string

folder_documents_custom_fields:

• custom_field_value_id from int to string

incident_action_custom_fields:

• custom_field_value_id from int to string

incident_custom_fields:

• custom_field_value_id from int to string

incident_record_custom_fields:

• custom_field_value_id from int to string

incident_witness_statement_custom_fields:

• custom_field_value_id from int to string

inspection_custom_fields:

• custom_field_value_id from int to string

observation_custom_fields:

• custom_field_value_id from int to string

prime_contract_co_custom_fields:

• custom_field_value_id from int to string

prime_contract_custom_fields:

• custom_field_value_id from int to string

prime_contract_pco_custom_fields:

• custom_field_value_id from int to string

project_custom_fields:

• custom_field_value_id from int to string

punch_item_custom_fields:

• custom_field_value_id from int to string

rfi_custom_fields:

• custom_field_value_id from int to string

subcontractor_invoice_custom_fields:

• custom_field_value_id from int to string

submittal_custom_fields:

• custom_field_value_id from int to string

inspection_items:

• attachment_count

correspondences_workflow_responses:

• current_step_response

action_plan:

• status_id

actual_production_quantities:

• description

bid_vendor:

• audit_transaction_timestamp

assembly_part:

• difficulty_factor

• labor_margin

• total_cost

• total_labor_sales

• unit_labor_mins

• unit_sales

bid_package:

• require_nda

bid_vendor:

• bid_form_id

• bid_id

• bid_package_id

• bid_vendor_id

• company_id

• created_at

• jobsite_proximity_in_miles

• project_id

• updated_at

• vendor_address

• vendor_affirmative_action

• vendor_african_american_business

• vendor_asian_american_business

• vendor_authorized_bidder

• vendor_avg_company_rating

• vendor_business_phone

• vendor_certified_business_enterprise

• vendor_city

• vendor_country

• vendor_disadvantaged_business

• vendor_eight_a_business_enterprise

• vendor_hispanic_business

• vendor_historically_underutlized_business

• vendor_id

• vendor_minority_business_enterprise

• vendor_name

• vendor_native_american_business

• vendor_service_disabled_veteran_owned_small_business

• vendor_small_business

• vendor_state

• vendor_trades

• vendor_womens_business

• vendor_zip

bid:

• bid_vendor_id

• nda_activity

change_event_line_item_with_markups:

• non_committed_cost

• non_committed_cost_company_currency

• non_committed_cost_project_currency

commitment_change_orders:

• change_reason

company_granular_permissions:

• audit_transaction_timestamp

• company_granular_permission_id

• company_id

• login_information_id

• tool_bid_board_can_access_projects_for_all_users

• tool_bid_board_can_add_notes

• tool_bid_board_can_edit_docs

• tool_bid_board_can_edit_project_details

• tool_bid_board_can_export_bid

• tool_directory_add_user_to_project

• tool_directory_assign_to_future_projects

• tool_directory_create_users

• tool_directory_create_vendors

• tool_directory_remove_user_from_project

• tool_directory_view_user_details

• tool_directory_view_vendor_details

company_permissions:

• permission_template_id

contract:

• bid_vendor_id

daily_log_types:

• audit_transaction_timestamp

• company_id

• created_at

• daily_log_type_id

• enabled

• label

• name

• updated_at

equipment:

• daily_logs_count_l7

• engine_hours_changes_count_l7

• inspections_count_l7

• is_idle_last_7_days

• last_activity

• last_activity_date

• last_daily_log_date

• last_engine_hours_activity_date

• last_inspection_date

• last_location_activity_date

• last_timecard_date

• location_changes_count_l7

• timecards_count_l7

form:

• template_archived_date

inspections:

• group

• reinspected_by_id

• reinspected_by_name

• reinspected_from_id

• reinspected_from_name

meeting:

• distributed_at

• distributed_by_id

• distributed_by_name

• last_distributed_event

observation:

• group

project_granular_permissions:

• audit_transaction_timestamp

• company_id

• login_information_id

• pk_user_id

• project_granular_permission_id

• project_id

• tool_action_plans_act_as_approver

• tool_action_plans_act_as_receiver

• tool_action_plans_create_and_edit_plan

• tool_action_plans_create_test_records_as_assignee

• tool_action_plans_delete_plan

• tool_action_plans_edit_due_date

• tool_action_plans_edit_item_notes_as_assignee

• tool_action_plans_edit_item_status_as_assignee

• tool_action_plans_edit_notifications

• tool_action_plans_edit_project_templates

• tool_action_plans_link_record

• tool_action_plans_sign_as_any_assignee

• tool_action_plans_sign_as_same_company_approver

• tool_action_plans_sign_as_same_company_assignee

• tool_action_plans_sign_as_same_company_receiver

• tool_action_plans_sign_as_self_assignee

• tool_action_plans_unlink_record

• tool_admin_manage_locations

• tool_admin_manage_wbs_codes

• tool_admin_update_active_tabs

• tool_admin_update_cost_codes

• tool_admin_update_general_settings

• tool_budget_create_edit_delete_budget_changes

• tool_budget_delete_budget_line_items

• tool_budget_import_line_items_from_csv

• tool_budget_lock_budget

• tool_budget_modify_original_budget_amount

• tool_budget_send_and_retrieve_from_erp

• tool_budget_view_budget_insights

• tool_budget_view_direct_cost_details

• tool_change_events_can_export_to_pdf_or_csv

• tool_change_events_can_view_change_history

• tool_commitments_create_purchase_order_contract

• tool_commitments_create_work_order_contract

• tool_commitments_select_out_of_scope_wbs_codes_on_commitment_change_orders

• tool_commitments_update_contract_currency_exchange_rate

• tool_commitments_update_purchase_order_contract

• tool_commitments_update_work_order_contract

• tool_commitments_view_private_purchase_order_contract

• tool_commitments_view_private_work_order_contract

• tool_daily_log_copy

• tool_daily_log_log_restrictively

• tool_daily_log_update_own_entries

• tool_daily_log_view_company_entries

• tool_data_extracts_can_create

• tool_data_extracts_can_delete_drafts

• tool_data_extracts_can_download

• tool_data_extracts_can_edit_drafts

• tool_data_extracts_can_extract_data

• tool_data_extracts_can_view

• tool_direct_costs_create_direct_cost

• tool_direct_costs_delete_direct_cost

• tool_direct_costs_update_direct_cost

• tool_direct_costs_update_exchange_rate

• tool_directory_add_user

• tool_directory_assign_project_role

• tool_directory_create_distribution_group

• tool_directory_create_person

• tool_directory_create_user

• tool_directory_create_vendor

• tool_directory_manage_permission_templates

• tool_directory_manage_vendor_insurances

• tool_directory_remove_user

• tool_directory_remove_vendor

• tool_directory_request_imports

• tool_directory_see_vendor_insurances

• tool_directory_update_person

• tool_documents_access_private

• tool_documents_destroy_files_and_folders

• tool_documents_move_files_and_folders

• tool_documents_rename_files_and_folders

• tool_documents_see_recycle_bin

• tool_documents_set_permissions

• tool_drawings_upload_and_review_drawings

• tool_drawings_upload_drawings

• tool_inspections_can_bulk_create_inspections

• tool_inspections_can_reinspect

• tool_inspections_create_edit_inspection_schedules

• tool_meetings_add_comment

• tool_meetings_create

• tool_meetings_delete_own_comment

• tool_meetings_distribute

• tool_meetings_edit

• tool_meetings_manage_meeting_categories

• tool_meetings_manage_meeting_items

• tool_meetings_manage_related_items

• tool_meetings_send_emails

• tool_observations_assign_standard_user

• tool_observations_respond_to_vendor_observation_items

• tool_observations_view_vendor_observation_items

• tool_photos_create_photo_album

• tool_photos_delete_photo_album

• tool_photos_reorder_photo_albums

• tool_photos_view_private_photo_album

• tool_prime_contracts_can_import_markups

• tool_prime_contracts_create_prime_contract

• tool_prime_contracts_delete_prime_contract

• tool_prime_contracts_update_contract_currency_exchange_rate

• tool_prime_contracts_update_prime_contract

• tool_prime_contracts_view_payment_application_detail

• tool_punch_list_respond_to_vendor_punch_items

• tool_punch_list_view_vendor_punch_items

• tool_rfis_act_as_rfi_manager

• tool_rfis_mark_official_responses

• tool_rfis_view_private_rfis

• tool_rfis_view_project_rfi_insights

• tool_schedule_lookahead_create

• tool_schedule_lookahead_delete

• tool_schedule_lookahead_task_create

• tool_schedule_lookahead_task_delete

• tool_schedule_lookahead_task_update

• tool_schedule_lookahead_view

• tool_schedule_lookahead_view_change_history

• tool_schedule_task_update_percent_complete

• tool_specifications_can_configure

• tool_specifications_can_create

• tool_specifications_can_create_specification_set

• tool_specifications_can_delete_pending_specification_uploads

• tool_specifications_can_destroy

• tool_specifications_can_download_specification

• tool_specifications_can_email

• tool_specifications_can_export_specification

• tool_specifications_can_manually_create_divisions

• tool_specifications_can_manually_create_spec_sections

• tool_specifications_can_publish

• tool_specifications_can_relate_items

• tool_specifications_can_review

• tool_specifications_can_show

• tool_specifications_can_show_uploads

• tool_specifications_can_update

• tool_specifications_can_view_all_revision

• tool_specifications_can_view_change_history

• tool_specifications_can_view_deleted_specifications

• tool_submittals_apply_submittal_workflow_template

• tool_submittals_create_submittal

• tool_submittals_create_submittal_package

• tool_submittals_view_private_submittals

• tool_submittals_view_project_submittal_insights

• tool_timesheets_review_timesheets

• tool_transmittals_view_private_transmittals"

project_permissions:

• permission_template_id

project_role_memberships:

• updated_at

invoice_compliance:

• invoice_compliance_id

• name

• type

• status

• notes

• attachment_count

• effective_date

• expiration_date

• last_modified_by

• last_modified_date

observation_custom_field_configs:

• Changed the Custom_field_definitions_id format (e.g., 0_60128 to 12345_60128)

observation_custom_fields:

• Changed the Custom_field_definitions_id format (e.g., 0_60128 to 12345_60128)

Estimate_budget_item_included_item:

• wbs_code_id

Estimate_budget_item:

• wbs_code_id

Bid

Bid_form

Bid_item

Bid_package

company_permissions

contact

project_contacts

Project_note

project_permissions

Project_task

Project_document

assembly_part

estimating_project_custom_field_configs

commitment_change_order_line_items:

• quantity

• tax_code

• uom

commitments:

• approved_change_orders

• draft_change_orders

• invoiced

• pending_change_orders

• pending_revised_contract_amount

owner_invoice_line_item_with_markups:

• materials_retainage_released_this_period

• materials_retainage_released_this_period_company_currency

• materials_retainage_released_this_period_project_currency

owner_invoice_line_items:

• materials_retainage_released_this_period

• materials_retainage_released_this_period_company_currency

• materials_retainage_released_this_period_project_currency

owner_invoice_markup_line_items:

• materials_retainage_released_this_period

• materials_retainage_released_this_period_company_currency

• materials_retainage_released_this_period_project_currency

owner_invoices:

• created_by_id

payments_subtier_waivers:

• waiver_required

subcontractor_invoices:

• created_by_id

• total_contract_amount

photo:

• uploaded_by_id

assignments:

• employee_id

time_and_material_equipments:

• equipment_id

• equipment_identification_number

• equipment_name_legacy

time_off:

• employee_id

timecard_entries:

• party_employee_id

• timesheet_id

wp_people:

• party_id

wp_role:

• audit_transaction_timestamp

• employee_id

Vendor:

• avg_company_rating

Estimating Project:

• created_by_id

• primary_contact_full_address

budget_snapshot_line_item_headers:

• line_items

requests:

• status

wp_people:

• customer_employee_id

• user_id

incident_records:

• affected_user_id

observation_custom_fields:

• type_id from int to bigint

payments_subtier_waivers:

• payment_subtier_waiver_id from bigint to string

incident_record:

• incident_environmental_type from boolean to string

company_project_currency_configurations

assignment_custom_fields

request_custom_fields

wp_people_custom_fields

folder_documents_custom_field_configs

folder_documents_custom_fields

task_distribution_member

project_vendors:

• avg_company_rating

• invoice_contact_email_address

• invoice_contact_full_name

vendors:

• avg_company_rating

• invoice_contact_email_address

• invoice_contact_full_name

direct_costs:

• created_by_id

payments_subtiers:

• hired_by_company_name

• tier

• tiering

subcontractor_invoices:

• early_pay_fee_amount_calculated

incident_record:

• affected_party_id

• affected_party_name

inspection_items:

• respondable

inspection_signature_requests:

• requested

• requested_login

submittals:

• source_submittal_id

• specification_area_name

actual_production_quantities:

• created_by_id

budgeted_production_quantities:

• created_by_id

equipment:

• project_id

time_and_material_entries:

• created_by_id

timecard_entries:

• created_by_id

Company_folder_documents

Folder_documents

Folder_watchers

Equipment_telematic

wp_project_custom_fields

estimating_project_custom_field_configs

subcontractor_invoice_line_items:

• adjusted_materials_previously_stored

• adjusted_materials_previously_stored_company_currency

• adjusted_materials_previously_stored_project_currency

• adjusted_materials_retained_previously

• adjusted_materials_retained_previously_company_currency

• adjusted_materials_retained_previously_project_currency

• gross_amount

• gross_amount_company_currency

• gross_amount_project_currency

• net_amount

• net_amount_company_currency

• net_amount_project_currency

• retainage_new_materials_from_percent

• retainage_new_materials_from_percent_company_currency

• retainage_new_materials_from_percent_project_currency

• total_completed_and_stored_to_date_from_previous

• total_completed_and_stored_to_date_from_previous_company_currency

• total_completed_and_stored_to_date_from_previous_project_currency

• commitment_line_item_id

• prime_contract_line_item_id