Tables installed with Field Service Management

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間:3分
  • Tables are provided with the Field Service Management application.

    表 : 1. Tables installed with Field Service Management
    Table Description
    Work Order

    [wm_order]

    Stores work order records.
    Work Order Flow

    [sf_work_order]

    Stores the work order state flow records.
    Work Order Model

    [cmdb_workorder_product_model]

    Stores the Product Catalog work order model records. This table was modified by the Field Service Management plugin. This table is renamed and part of Service Order Management.
    Work Order Task

    [wm_task]

    Unit of work performed by one person, in one session (one location and one time).
    Work Task Flow

    [sf_work_task]

    Stores the work task state flow records.
    Work Task Model

    [cmdb_servicetask_product_model]

    Stores the Product Catalog work task model records. This table was modified by the Field Service Management plugin. This table is renamed and part of Service Order Management.
    WM Map Filters Config

    [wm_map_filters_config]

    Stores filter configurations for the agent map on the mobile UI.
    Questionnaire

    [wm_questionnaire]

    Stores questionnaires created for work orders and work order tasks.
    Work Type

    [wm_work_type]

    Stores the type of work performed by an agent to complete the work order task.
    Work Order Task Potential Assignment Groups

    [wm_work_order_task_potential_assignment_groups]

    Calculates and stores the potential assignment group if there are multiple assignment groups that can be serviced for a work order task.
    注:
    This is applicable only when:
    • The sn_fsm.update_potential_assignment_groups system property is set to true.
    • More than one assignment group is found for the location.
    • Territory model is inactive.
    Scheduling history

    [wm_task_scheduling_history]

    Stores the history of the scheduling method of how each work order task has been assigned along with date and time.
    Assets

    [alm.asset]

    Stores the inventory along with the cost and stockroom details.
    Resource Schedule Attributes

    [wm_agent_schedule_attribute_plan]

    Stores the attributes like start date, end date, start location, end location, shift hours etc of agents.