List Work Orders With Requisitions By Document

Obtains work orders with complete item information, work request, pending tasks and associated requisitions.

---

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	-
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[str]	❌	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	Optional[str]	❌	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[str]	❌	Actual stop seconds.	None	-
wo_final_date	Optional[str]	❌	OT end date.	None	-
is_offline	Optional[bool]	❌	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[str]	❌	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[str]	❌	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[str]	❌	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_company	Optional[int]	❌	Company ID.	None	-
code_wo_related	Optional[str]	❌	Related OT code.	None	-
id_wo_related	Optional[str]	❌	Related OT ID.	None	-
item	Optional[str]	❌	Object with complete information of the item/asset.	None	-
work_request	Optional[str]	❌	Object with information about the job request.	None	-
task_todo	Optional[str]	❌	Object with pending task information.	None	-
requisitions	Optional[list[str]]	❌	List of associated requirements.	None	-

Notes:

All fields are optional.

Related: