List Work Orders With Detailed Responsible
Obtains work orders with their detailed managers.
General information:
| Module | Category |
|---|---|
Work Order |
Read |
Molecule details
Input schema:
| Field | Type | Required | Description | Default value | Examples |
|---|---|---|---|---|---|
description |
Optional[str] | ❌ | Description. | None |
- |
id_work_order |
Optional[int] | ❌ | OT ID. | None |
- |
id_work_orders_tasks |
Optional[int] | ❌ | OT task ID. | None |
- |
id_task |
Optional[int] | ❌ | Task ID. | None |
- |
id_item |
Optional[int] | ❌ | Item/asset ID. | None |
- |
id_status_work_order |
Optional[int] | ❌ | OT status ID. | None |
- |
wo_folio |
Optional[str] | ❌ | Folio of the OT. | None |
- |
creation_date |
Optional[str] | ❌ | Creation date. | None |
- |
duration |
Optional[int] | ❌ | Estimated duration. | None |
- |
initial_date |
Optional[str] | ❌ | Initial date. | None |
- |
id_priorities |
Optional[int] | ❌ | Priority ID. | None |
- |
priorities_description |
Optional[str] | ❌ | Priority description. | None |
- |
final_date |
Optional[str] | ❌ | End date. | None |
- |
completed_percentage |
Optional[int] | ❌ | Percentage completed. | None |
- |
created_by |
Optional[str] | ❌ | Created by. | None |
- |
signature |
Optional[str] | ❌ | Signature. | None |
- |
personnel_description |
Optional[str] | ❌ | Staff description. | None |
- |
personnel_path_image |
Optional[str] | ❌ | Staff image path. | None |
- |
code |
Optional[str] | ❌ | Code. | None |
- |
items_log_description |
Optional[str] | ❌ | Description of the item log. | None |
- |
done |
Optional[bool] | ❌ | Indicates if it is completed. | None |
- |
id_request |
Optional[str] | ❌ | Request ID. | None |
- |
stop_assets |
Optional[bool] | ❌ | Asset stoppage. | None |
- |
stop_assets_sec |
Optional[int] | ❌ | Stop seconds. | None |
- |
tasks_log_task_type_main |
Optional[str] | ❌ | Main type of log task. | None |
- |
parent_description |
Optional[str] | ❌ | Description of the father. | None |
- |
trigger_description |
Optional[str] | ❌ | Trigger description. | None |
- |
resources_hours |
Optional[str] | ❌ | Hour resources. | None |
- |
resources_inventory |
Optional[str] | ❌ | Inventory resources. | None |
- |
resources_human_resources |
Optional[str] | ❌ | Human resources. | None |
- |
resources_services |
Optional[str] | ❌ | Service resources. | None |
- |
cal_date_maintenance |
Optional[str] | ❌ | Calculated maintenance date. | None |
- |
real_duration |
Optional[str] | ❌ | Actual duration. | None |
- |
date_maintenance |
Optional[str] | ❌ | Maintenance date. | None |
- |
user_assigned |
Optional[str] | ❌ | Assigned user. | None |
- |
note |
Optional[str] | ❌ | Note. | None |
- |
details_signature |
Optional[str] | ❌ | Signature details. | None |
- |
responsible_path_signature |
Optional[str] | ❌ | Route signature of the person in charge. | None |
- |
validator_path_signature |
Optional[str] | ❌ | Validator signature path. | None |
- |
first_date_task |
Optional[str] | ❌ | First task date. | None |
- |
costs_center_description |
Optional[str] | ❌ | Description of the cost center. | None |
- |
tasks_duration |
Optional[int] | ❌ | Duration of tasks. | None |
- |
total_cost_task |
Union[int, float, NoneType] | ❌ | Total task cost. | None |
- |
requested_by |
Optional[str] | ❌ | Requested by. | None |
- |
groups_description |
Optional[str] | ❌ | Group description. | None |
- |
groups_1_description |
Optional[str] | ❌ | Group description 1. | None |
- |
groups_2_description |
Optional[str] | ❌ | Group description 2. | None |
- |
task_note |
Optional[str] | ❌ | Homework note. | None |
- |
id_parent_wo |
Optional[str] | ❌ | Parent OT ID. | None |
- |
has_children |
Optional[bool] | ❌ | He has children. | None |
- |
real_stop_assets_sec |
Optional[int] | ❌ | Actual stop seconds. | None |
- |
wo_final_date |
Optional[str] | ❌ | OT end date. | None |
- |
is_offline |
Optional[str] | ❌ | It's offline. | None |
- |
tasks_log_types_description |
Optional[str] | ❌ | Description of log types. | None |
- |
tasks_log_types_2_description |
Optional[str] | ❌ | Description of log types 2. | None |
- |
code_create_by |
Optional[str] | ❌ | Creator code. | None |
- |
event_date |
Optional[str] | ❌ | Event date. | None |
- |
rating |
Optional[int] | ❌ | Qualification. | None |
- |
enable_budget |
Optional[bool] | ❌ | Enable budget. | None |
- |
work_orders_status_custom_description |
Optional[str] | ❌ | Custom status description. | None |
- |
review_date |
Optional[str] | ❌ | Review date. | None |
- |
code_responsible |
Optional[str] | ❌ | Responsible code. | None |
- |
id_parent |
Optional[int] | ❌ | Father ID. | None |
- |
id_failure_type |
Optional[str] | ❌ | Failure type ID. | None |
- |
types_description |
Optional[str] | ❌ | Description of types. | None |
- |
id_failure_cause |
Optional[str] | ❌ | Failure cause ID. | None |
- |
causes_description |
Optional[str] | ❌ | Description of causes. | None |
- |
id_failure_detection_method |
Optional[str] | ❌ | ID fault detection method. | None |
- |
detection_method_description |
Optional[str] | ❌ | Description of the detection method. | None |
- |
id_failure_severity |
Optional[str] | ❌ | Failure severity ID. | None |
- |
severiry_description |
Optional[str] | ❌ | Description of severity. | None |
- |
id_damage_type |
Optional[str] | ❌ | Damage type ID. | None |
- |
damages_types_description |
Optional[str] | ❌ | Description of types of damage. | None |
- |
caused_damage |
Optional[str] | ❌ | Damage caused. | None |
- |
id_group_task |
Optional[int] | ❌ | Task group ID. | None |
- |
id_items_availability |
Optional[str] | ❌ | Item availability ID. | None |
- |
validated_by_description |
Optional[str] | ❌ | Description of the validator. | None |
- |
id_personnel_log |
Optional[int] | ❌ | Personnel log ID. | None |
- |
id_contacts_log |
Optional[str] | ❌ | Contact log ID. | None |
- |
id_personnel |
Optional[int] | ❌ | Personnel ID. | None |
- |
id_contact |
Optional[str] | ❌ | Contact ID. | None |
- |
task_status |
Optional[str] | ❌ | Task status. | None |
- |
id_status_work_order_task |
Optional[int] | ❌ | OT task status ID. | None |
- |
id_company |
Optional[int] | ❌ | Company ID. | None |
- |
item_id |
Optional[int] | ❌ | Item ID. | None |
- |
item_active |
Optional[bool] | ❌ | Active state. | None |
- |
item_code |
Optional[str] | ❌ | Item code. | None |
- |
item_description |
Optional[str] | ❌ | Item description. | None |
- |
item_id_type_item |
Optional[int] | ❌ | Item type ID. | None |
- |
item_barcode |
Optional[str] | ❌ | Bar-code. | None |
- |
item_field_1 |
Optional[str] | ❌ | Custom field 1. | None |
- |
item_field_2 |
Optional[str] | ❌ | Custom field 2. | None |
- |
item_field_3 |
Optional[str] | ❌ | Custom field 3. | None |
- |
item_field_4 |
Optional[str] | ❌ | Custom field 4. | None |
- |
item_field_5 |
Optional[str] | ❌ | Custom field 5. | None |
- |
item_field_6 |
Optional[str] | ❌ | Custom field 6. | None |
- |
item_notes |
Optional[str] | ❌ | Item notes. | None |
- |
item_min_stock_warning |
Optional[str] | ❌ | Minimum stock warning. | None |
- |
item_weight |
Optional[str] | ❌ | Weight. | None |
- |
item_is_serial_control |
Optional[bool] | ❌ | Standard control. | None |
- |
item_lead_time |
Optional[str] | ❌ | Delivery time. | None |
- |
item_items_types_description |
Optional[str] | ❌ | Description of the item type. | None |
- |
item_groups_description |
Optional[str] | ❌ | Group description. | None |
- |
item_groups_1_description |
Optional[str] | ❌ | Description of group 1. | None |
- |
item_groups_2_description |
Optional[str] | ❌ | Description of group 2. | None |
- |
item_custom_fields_groups_description |
Optional[str] | ❌ | Description of the custom field group. | None |
- |
item_units_description |
Optional[str] | ❌ | Description of units. | None |
- |
item_priorities_description |
Optional[str] | ❌ | Priority description. | None |
- |
item_parent_description |
Optional[str] | ❌ | Description of the father. | None |
- |
item_purchase_date |
Optional[str] | ❌ | Purchase date. | None |
- |
item_total_cost |
Optional[int] | ❌ | Total cost. | None |
- |
item_anual_depreciation |
Optional[str] | ❌ | Annual depreciation. | None |
- |
item_startup_date |
Optional[str] | ❌ | Startup date. | None |
- |
item_total_replacement_cost |
Optional[int] | ❌ | Total replacement cost. | None |
- |
item_salvage_value |
Optional[int] | ❌ | Salvage value. | None |
- |
item_costs_center_description |
Optional[str] | ❌ | Description of the cost center. | None |
- |
item_budgets_description |
Optional[str] | ❌ | Budget description. | None |
- |
item_cost_average |
Optional[str] | ❌ | Average cost. | None |
- |
item_latitude |
Optional[str] | ❌ | Latitude. | None |
- |
item_longitud |
Optional[str] | ❌ | Length. | None |
- |
item_id_group_task |
Optional[int] | ❌ | Task group ID. | None |
- |
item_groups_tasks_description |
Optional[str] | ❌ | Description of the task group. | None |
- |
item_units_code |
Optional[str] | ❌ | Units code. | None |
- |
item_custom_fields_values |
Optional[str] | ❌ | Custom field values. | None |
- |
item_third_parties_name |
Optional[str] | ❌ | Name of the third party. | None |
- |
item_id_parent |
Optional[int] | ❌ | Father ID. | None |
- |
item_visible_to_all |
Optional[bool] | ❌ | Visible to everyone. | None |
- |
item_hours_average_daily_use |
Optional[int] | ❌ | Average hours of daily use. | None |
- |
item_available |
Optional[bool] | ❌ | Available. | None |
- |
item_initial_date_out_of_service |
Optional[str] | ❌ | Initial date out of service. | None |
- |
item_last_final_date_available |
Optional[str] | ❌ | Last available end date. | None |
- |
item_item_url |
Optional[str] | ❌ | Item URL. | None |
- |
item_id_company |
Optional[int] | ❌ | Company ID of the item. | None |
- |
personnel_name |
Optional[str] | ❌ | Staff name. | None |
- |
personnel_description_work_shifts |
Optional[str] | ❌ | Description of work shifts. | None |
- |
personnel_full_name |
Optional[str] | ❌ | Full name. | None |
- |
personnel_custom_fields_groups_description |
Optional[str] | ❌ | Custom field group description. | None |
- |
personnel_code |
Optional[str] | ❌ | Staff code. | None |
- |
personnel_first_name |
Optional[str] | ❌ | First name. | None |
- |
personnel_last_name |
Optional[str] | ❌ | Last name. | None |
- |
personnel_email |
Optional[str] | ❌ | E-mail. | None |
- |
personnel_saved_configuration_table |
Optional[bool] | ❌ | Saved table settings. | None |
- |
personnel_active |
Optional[bool] | ❌ | Asset. | None |
- |
personnel_creation_date |
Optional[str] | ❌ | Creation date. | None |
- |
personnel_address |
Optional[str] | ❌ | Address. | None |
- |
personnel_city |
Optional[str] | ❌ | City. | None |
- |
personnel_state |
Optional[str] | ❌ | State/Province. | None |
- |
personnel_zip_code |
Optional[str] | ❌ | Zip code. | None |
- |
personnel_country |
Optional[str] | ❌ | Country. | None |
- |
personnel_latitude |
Optional[str] | ❌ | Latitude. | None |
- |
personnel_longitud |
Optional[str] | ❌ | Length. | None |
- |
personnel_telephone |
Optional[str] | ❌ | Phone. | None |
- |
personnel_telephone_2 |
Optional[str] | ❌ | Telephone 2. | None |
- |
personnel_sms |
Optional[str] | ❌ | SMS. | None |
- |
personnel_asset_location_description |
Optional[str] | ❌ | Asset location description. | None |
- |
personnel_hourly_rates_description |
Optional[str] | ❌ | Description of hourly rates. | None |
- |
personnel_groups_1_description |
Optional[str] | ❌ | Group description 1. | None |
- |
personnel_groups_2_description |
Optional[str] | ❌ | Group description 2. | None |
- |
personnel_account_item_description |
Optional[str] | ❌ | Item account description. | None |
- |
personnel_account_email |
Optional[str] | ❌ | Account email. | None |
- |
personnel_only_request |
Optional[bool] | ❌ | Requests only. | None |
- |
personnel_groups_permissions_description |
Optional[str] | ❌ | Description of group permissions. | None |
- |
personnel_account_active |
Optional[bool] | ❌ | Active account. | None |
- |
personnel_belongs |
Optional[str] | ❌ | It belongs to. | None |
- |
personnel_id_personnel |
Optional[int] | ❌ | Personnel ID. | None |
- |
personnel_id_company |
Optional[int] | ❌ | Company ID of the staff. | None |
- |
Notes:
All fields are optional.