> ## Documentation Index > Fetch the complete documentation index at: https://docs.assetinfinity.ai/llms.txt > Use this file to discover all available pages before exploring further. # List open work orders > api.work_orders narrowed to states the model counts as open. A filter, nothing more: every column it carries is defined once, on api.work_orders. ## OpenAPI ````yaml /api-reference/integration.json get /open_work_orders openapi: 3.0.0 info: description: >- The calls an integration needs first. Every endpoint the application uses is in the complete reference. title: Asset Infinity integration API version: 12.2.3 servers: - url: https://app.assetinfinity.ai/api security: [] tags: - description: >- Exchange an API key, or an email and password, for a short-lived session token, and send it as `Authorization: Bearer ` on every other call. name: Signing in - description: >- Where assets are and work happens. A location belongs to a site and may sit inside another location. name: Sites and locations - description: >- The asset register: read it, add to it, correct it, move an asset between sites and locations, and change its status. name: Assets - description: >- Report a problem. A request is triaged by a person, who turns it into a work order or turns it down. name: Work requests - description: >- Raise a job, give it to somebody, move it through the organisation's statuses, complete it and close it. name: Work orders - description: >- Send readings in. A meter reading brings the meter forward and raises any maintenance the usage has made due. A sensor reading can open or clear an alert. name: Meters and sensors - description: >- The part catalogue and what is on the shelf in each store, and the three movements an outside system most often records: a delivery in, an issue out and a correction. name: Parts and stock - description: >- Have the product call your system when something happens, instead of asking it on a timer. name: Webhooks - description: >- The calls behind every register that has no call of its own, answers to the organisation's own fields, and the two calls that answer what to send. `list_options` returns the ids a field accepts. `describe_call` returns the fields any call takes. name: Any record externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /open_work_orders: get: tags: - Work orders summary: List open work orders description: >- api.work_orders narrowed to states the model counts as open. A filter, nothing more: every column it carries is defined once, on api.work_orders. parameters: - $ref: '#/components/parameters/rowFilter.open_work_orders.id' - $ref: '#/components/parameters/rowFilter.open_work_orders.work_order_number' - $ref: '#/components/parameters/rowFilter.open_work_orders.title' - $ref: '#/components/parameters/rowFilter.open_work_orders.description' - $ref: '#/components/parameters/rowFilter.open_work_orders.remarks' - $ref: >- #/components/parameters/rowFilter.open_work_orders.work_order_type_id - $ref: '#/components/parameters/rowFilter.open_work_orders.work_order_type' - $ref: >- #/components/parameters/rowFilter.open_work_orders.work_order_type_name - $ref: '#/components/parameters/rowFilter.open_work_orders.is_planned' - $ref: '#/components/parameters/rowFilter.open_work_orders.is_emergency' - $ref: '#/components/parameters/rowFilter.open_work_orders.priority' - $ref: '#/components/parameters/rowFilter.open_work_orders.priority_name' - $ref: '#/components/parameters/rowFilter.open_work_orders.priority_rank' - $ref: '#/components/parameters/rowFilter.open_work_orders.status' - $ref: '#/components/parameters/rowFilter.open_work_orders.status_id' - $ref: >- #/components/parameters/rowFilter.open_work_orders.state_model_version_id - $ref: '#/components/parameters/rowFilter.open_work_orders.status_label' - $ref: '#/components/parameters/rowFilter.open_work_orders.status_category' - $ref: '#/components/parameters/rowFilter.open_work_orders.is_open' - $ref: >- #/components/parameters/rowFilter.open_work_orders.allows_technician_edit - $ref: >- #/components/parameters/rowFilter.open_work_orders.allows_parts_consumption - $ref: >- #/components/parameters/rowFilter.open_work_orders.allows_labour_entry - $ref: >- #/components/parameters/rowFilter.open_work_orders.allows_sla_extension - $ref: '#/components/parameters/rowFilter.open_work_orders.origin' - $ref: >- #/components/parameters/rowFilter.open_work_orders.reported_by_user_id - $ref: >- #/components/parameters/rowFilter.open_work_orders.reported_by_user_name - $ref: '#/components/parameters/rowFilter.open_work_orders.asset_id' - $ref: '#/components/parameters/rowFilter.open_work_orders.asset_number' - $ref: '#/components/parameters/rowFilter.open_work_orders.asset_name' - $ref: '#/components/parameters/rowFilter.open_work_orders.asset_category_id' - $ref: '#/components/parameters/rowFilter.open_work_orders.site_id' - $ref: '#/components/parameters/rowFilter.open_work_orders.site_code' - $ref: '#/components/parameters/rowFilter.open_work_orders.location_id' - $ref: >- #/components/parameters/rowFilter.open_work_orders.work_order_category_id - $ref: >- #/components/parameters/rowFilter.open_work_orders.maintenance_occurrence_id - $ref: '#/components/parameters/rowFilter.open_work_orders.work_request_id' - $ref: '#/components/parameters/rowFilter.open_work_orders.planned_start_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.planned_end_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.due_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.response_due_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.resolution_due_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.actual_start_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.actual_end_at' - $ref: >- #/components/parameters/rowFilter.open_work_orders.actual_duration_minutes - $ref: '#/components/parameters/rowFilter.open_work_orders.closed_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.readiness_score' - $ref: '#/components/parameters/rowFilter.open_work_orders.is_ready' - $ref: '#/components/parameters/rowFilter.open_work_orders.requires_permit' - $ref: '#/components/parameters/rowFilter.open_work_orders.permit_required' - $ref: >- #/components/parameters/rowFilter.open_work_orders.safety_instructions - $ref: '#/components/parameters/rowFilter.open_work_orders.safety_briefing' - $ref: '#/components/parameters/rowFilter.open_work_orders.problem_code' - $ref: '#/components/parameters/rowFilter.open_work_orders.failure_code' - $ref: >- #/components/parameters/rowFilter.open_work_orders.work_order_resolution_code_id - $ref: '#/components/parameters/rowFilter.open_work_orders.resolution_code' - $ref: >- #/components/parameters/rowFilter.open_work_orders.resolution_code_name - $ref: '#/components/parameters/rowFilter.open_work_orders.resolution_notes' - $ref: >- #/components/parameters/rowFilter.open_work_orders.is_warranty_covered - $ref: '#/components/parameters/rowFilter.open_work_orders.contract_id' - $ref: '#/components/parameters/rowFilter.open_work_orders.sla_breached' - $ref: '#/components/parameters/rowFilter.open_work_orders.sla_source' - $ref: >- #/components/parameters/rowFilter.open_work_orders.work_order_sla_target_id - $ref: '#/components/parameters/rowFilter.open_work_orders.sla_target_name' - $ref: >- #/components/parameters/rowFilter.open_work_orders.estimated_duration_minutes - $ref: '#/components/parameters/rowFilter.open_work_orders.total_cost' - $ref: >- #/components/parameters/rowFilter.open_work_orders.total_cost_currency_id - $ref: '#/components/parameters/rowFilter.open_work_orders.labour_cost' - $ref: '#/components/parameters/rowFilter.open_work_orders.parts_cost' - $ref: '#/components/parameters/rowFilter.open_work_orders.vendor_cost' - $ref: >- #/components/parameters/rowFilter.open_work_orders.status_is_terminal - $ref: >- #/components/parameters/rowFilter.open_work_orders.assigned_vendor_id - $ref: >- #/components/parameters/rowFilter.open_work_orders.assigned_vendor_name - $ref: '#/components/parameters/rowFilter.open_work_orders.assigned_team_id' - $ref: >- #/components/parameters/rowFilter.open_work_orders.assigned_team_name - $ref: '#/components/parameters/rowFilter.open_work_orders.vendor_technician' - $ref: >- #/components/parameters/rowFilter.open_work_orders.vendor_technician_phone - $ref: '#/components/parameters/rowFilter.open_work_orders.assignees' - $ref: '#/components/parameters/rowFilter.open_work_orders.cc' - $ref: '#/components/parameters/rowFilter.open_work_orders.task_count' - $ref: >- #/components/parameters/rowFilter.open_work_orders.mandatory_tasks_outstanding - $ref: >- #/components/parameters/rowFilter.open_work_orders.primary_image_file_id - $ref: >- #/components/parameters/rowFilter.open_work_orders.asset_image_file_id - $ref: '#/components/parameters/rowFilter.open_work_orders.custom_fields' - $ref: '#/components/parameters/rowFilter.open_work_orders.is_unassigned' - $ref: '#/components/parameters/rowFilter.open_work_orders.age_days' - $ref: >- #/components/parameters/rowFilter.open_work_orders.turnaround_minutes - $ref: >- #/components/parameters/rowFilter.open_work_orders.turnaround_running - $ref: >- #/components/parameters/rowFilter.open_work_orders.checked_in_minutes - $ref: '#/components/parameters/rowFilter.open_work_orders.checked_in_since' - $ref: '#/components/parameters/rowFilter.open_work_orders.is_overdue' - $ref: '#/components/parameters/rowFilter.open_work_orders.sla_breached_now' - $ref: >- #/components/parameters/rowFilter.open_work_orders.pending_approval_request_id - $ref: >- #/components/parameters/rowFilter.open_work_orders.pending_sla_extension_request_id - $ref: '#/components/parameters/rowFilter.open_work_orders.row_version' - $ref: '#/components/parameters/rowFilter.open_work_orders.created_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.created_by_id' - $ref: '#/components/parameters/rowFilter.open_work_orders.created_by_name' - $ref: '#/components/parameters/rowFilter.open_work_orders.created_source' - $ref: '#/components/parameters/rowFilter.open_work_orders.updated_at' - $ref: '#/components/parameters/rowFilter.open_work_orders.updated_by_id' - $ref: '#/components/parameters/rowFilter.open_work_orders.updated_by_name' - $ref: '#/components/parameters/select' - $ref: '#/components/parameters/order' - $ref: '#/components/parameters/range' - $ref: '#/components/parameters/rangeUnit' - $ref: '#/components/parameters/offset' - $ref: '#/components/parameters/limit' - $ref: '#/components/parameters/preferCount' responses: '200': content: application/json: schema: items: $ref: '#/components/schemas/open_work_orders' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/open_work_orders' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/open_work_orders' type: array text/csv: schema: items: $ref: '#/components/schemas/open_work_orders' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.open_work_orders.id: in: query name: id required: false schema: type: string rowFilter.open_work_orders.work_order_number: in: query name: work_order_number required: false schema: type: string rowFilter.open_work_orders.title: in: query name: title required: false schema: type: string rowFilter.open_work_orders.description: in: query name: description required: false schema: type: string rowFilter.open_work_orders.remarks: in: query name: remarks required: false schema: type: string rowFilter.open_work_orders.work_order_type_id: in: query name: work_order_type_id required: false schema: type: string rowFilter.open_work_orders.work_order_type: in: query name: work_order_type required: false schema: type: string rowFilter.open_work_orders.work_order_type_name: in: query name: work_order_type_name required: false schema: type: string rowFilter.open_work_orders.is_planned: in: query name: is_planned required: false schema: type: string rowFilter.open_work_orders.is_emergency: in: query name: is_emergency required: false schema: type: string rowFilter.open_work_orders.priority: in: query name: priority required: false schema: type: string rowFilter.open_work_orders.priority_name: in: query name: priority_name required: false schema: type: string rowFilter.open_work_orders.priority_rank: in: query name: priority_rank required: false schema: type: string rowFilter.open_work_orders.status: in: query name: status required: false schema: type: string rowFilter.open_work_orders.status_id: in: query name: status_id required: false schema: type: string rowFilter.open_work_orders.state_model_version_id: in: query name: state_model_version_id required: false schema: type: string rowFilter.open_work_orders.status_label: in: query name: status_label required: false schema: type: string rowFilter.open_work_orders.status_category: in: query name: status_category required: false schema: type: string rowFilter.open_work_orders.is_open: in: query name: is_open required: false schema: type: string rowFilter.open_work_orders.allows_technician_edit: in: query name: allows_technician_edit required: false schema: type: string rowFilter.open_work_orders.allows_parts_consumption: in: query name: allows_parts_consumption required: false schema: type: string rowFilter.open_work_orders.allows_labour_entry: in: query name: allows_labour_entry required: false schema: type: string rowFilter.open_work_orders.allows_sla_extension: in: query name: allows_sla_extension required: false schema: type: string rowFilter.open_work_orders.origin: in: query name: origin required: false schema: type: string rowFilter.open_work_orders.reported_by_user_id: in: query name: reported_by_user_id required: false schema: type: string rowFilter.open_work_orders.reported_by_user_name: in: query name: reported_by_user_name required: false schema: type: string rowFilter.open_work_orders.asset_id: in: query name: asset_id required: false schema: type: string rowFilter.open_work_orders.asset_number: in: query name: asset_number required: false schema: type: string rowFilter.open_work_orders.asset_name: in: query name: asset_name required: false schema: type: string rowFilter.open_work_orders.asset_category_id: in: query name: asset_category_id required: false schema: type: string rowFilter.open_work_orders.site_id: in: query name: site_id required: false schema: type: string rowFilter.open_work_orders.site_code: in: query name: site_code required: false schema: type: string rowFilter.open_work_orders.location_id: in: query name: location_id required: false schema: type: string rowFilter.open_work_orders.work_order_category_id: in: query name: work_order_category_id required: false schema: type: string rowFilter.open_work_orders.maintenance_occurrence_id: in: query name: maintenance_occurrence_id required: false schema: type: string rowFilter.open_work_orders.work_request_id: in: query name: work_request_id required: false schema: type: string rowFilter.open_work_orders.planned_start_at: in: query name: planned_start_at required: false schema: type: string rowFilter.open_work_orders.planned_end_at: in: query name: planned_end_at required: false schema: type: string rowFilter.open_work_orders.due_at: in: query name: due_at required: false schema: type: string rowFilter.open_work_orders.response_due_at: in: query name: response_due_at required: false schema: type: string rowFilter.open_work_orders.resolution_due_at: in: query name: resolution_due_at required: false schema: type: string rowFilter.open_work_orders.actual_start_at: in: query name: actual_start_at required: false schema: type: string rowFilter.open_work_orders.actual_end_at: in: query name: actual_end_at required: false schema: type: string rowFilter.open_work_orders.actual_duration_minutes: in: query name: actual_duration_minutes required: false schema: type: string rowFilter.open_work_orders.closed_at: in: query name: closed_at required: false schema: type: string rowFilter.open_work_orders.readiness_score: in: query name: readiness_score required: false schema: type: string rowFilter.open_work_orders.is_ready: in: query name: is_ready required: false schema: type: string rowFilter.open_work_orders.requires_permit: in: query name: requires_permit required: false schema: type: string rowFilter.open_work_orders.permit_required: in: query name: permit_required required: false schema: type: string rowFilter.open_work_orders.safety_instructions: in: query name: safety_instructions required: false schema: type: string rowFilter.open_work_orders.safety_briefing: in: query name: safety_briefing required: false schema: type: string rowFilter.open_work_orders.problem_code: in: query name: problem_code required: false schema: type: string rowFilter.open_work_orders.failure_code: in: query name: failure_code required: false schema: type: string rowFilter.open_work_orders.work_order_resolution_code_id: in: query name: work_order_resolution_code_id required: false schema: type: string rowFilter.open_work_orders.resolution_code: in: query name: resolution_code required: false schema: type: string rowFilter.open_work_orders.resolution_code_name: in: query name: resolution_code_name required: false schema: type: string rowFilter.open_work_orders.resolution_notes: in: query name: resolution_notes required: false schema: type: string rowFilter.open_work_orders.is_warranty_covered: in: query name: is_warranty_covered required: false schema: type: string rowFilter.open_work_orders.contract_id: in: query name: contract_id required: false schema: type: string rowFilter.open_work_orders.sla_breached: in: query name: sla_breached required: false schema: type: string rowFilter.open_work_orders.sla_source: in: query name: sla_source required: false schema: type: string rowFilter.open_work_orders.work_order_sla_target_id: in: query name: work_order_sla_target_id required: false schema: type: string rowFilter.open_work_orders.sla_target_name: in: query name: sla_target_name required: false schema: type: string rowFilter.open_work_orders.estimated_duration_minutes: in: query name: estimated_duration_minutes required: false schema: type: string rowFilter.open_work_orders.total_cost: in: query name: total_cost required: false schema: type: string rowFilter.open_work_orders.total_cost_currency_id: in: query name: total_cost_currency_id required: false schema: type: string rowFilter.open_work_orders.labour_cost: in: query name: labour_cost required: false schema: type: string rowFilter.open_work_orders.parts_cost: in: query name: parts_cost required: false schema: type: string rowFilter.open_work_orders.vendor_cost: in: query name: vendor_cost required: false schema: type: string rowFilter.open_work_orders.status_is_terminal: in: query name: status_is_terminal required: false schema: type: string rowFilter.open_work_orders.assigned_vendor_id: in: query name: assigned_vendor_id required: false schema: type: string rowFilter.open_work_orders.assigned_vendor_name: in: query name: assigned_vendor_name required: false schema: type: string rowFilter.open_work_orders.assigned_team_id: in: query name: assigned_team_id required: false schema: type: string rowFilter.open_work_orders.assigned_team_name: in: query name: assigned_team_name required: false schema: type: string rowFilter.open_work_orders.vendor_technician: in: query name: vendor_technician required: false schema: type: string rowFilter.open_work_orders.vendor_technician_phone: in: query name: vendor_technician_phone required: false schema: type: string rowFilter.open_work_orders.assignees: in: query name: assignees required: false schema: type: string rowFilter.open_work_orders.cc: in: query name: cc required: false schema: type: string rowFilter.open_work_orders.task_count: in: query name: task_count required: false schema: type: string rowFilter.open_work_orders.mandatory_tasks_outstanding: in: query name: mandatory_tasks_outstanding required: false schema: type: string rowFilter.open_work_orders.primary_image_file_id: in: query name: primary_image_file_id required: false schema: type: string rowFilter.open_work_orders.asset_image_file_id: in: query name: asset_image_file_id required: false schema: type: string rowFilter.open_work_orders.custom_fields: in: query name: custom_fields required: false schema: type: string rowFilter.open_work_orders.is_unassigned: in: query name: is_unassigned required: false schema: type: string rowFilter.open_work_orders.age_days: in: query name: age_days required: false schema: type: string rowFilter.open_work_orders.turnaround_minutes: in: query name: turnaround_minutes required: false schema: type: string rowFilter.open_work_orders.turnaround_running: in: query name: turnaround_running required: false schema: type: string rowFilter.open_work_orders.checked_in_minutes: in: query name: checked_in_minutes required: false schema: type: string rowFilter.open_work_orders.checked_in_since: in: query name: checked_in_since required: false schema: type: string rowFilter.open_work_orders.is_overdue: in: query name: is_overdue required: false schema: type: string rowFilter.open_work_orders.sla_breached_now: in: query name: sla_breached_now required: false schema: type: string rowFilter.open_work_orders.pending_approval_request_id: in: query name: pending_approval_request_id required: false schema: type: string rowFilter.open_work_orders.pending_sla_extension_request_id: in: query name: pending_sla_extension_request_id required: false schema: type: string rowFilter.open_work_orders.row_version: in: query name: row_version required: false schema: type: string rowFilter.open_work_orders.created_at: in: query name: created_at required: false schema: type: string rowFilter.open_work_orders.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.open_work_orders.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.open_work_orders.created_source: in: query name: created_source required: false schema: type: string rowFilter.open_work_orders.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.open_work_orders.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.open_work_orders.updated_by_name: in: query name: updated_by_name required: false schema: type: string select: description: Filtering Columns in: query name: select required: false schema: type: string order: description: Ordering in: query name: order required: false schema: type: string range: description: Limiting and Pagination in: header name: Range required: false schema: type: string rangeUnit: description: Limiting and Pagination in: header name: Range-Unit required: false schema: default: items type: string offset: description: Limiting and Pagination in: query name: offset required: false schema: type: string limit: description: Limiting and Pagination in: query name: limit required: false schema: type: string preferCount: description: Preference in: header name: Prefer required: false schema: enum: - count=none type: string schemas: open_work_orders: description: >- api.work_orders narrowed to states the model counts as open. A filter, nothing more: every column it carries is defined once, on api.work_orders. properties: actual_duration_minutes: format: integer type: integer actual_end_at: format: timestamp with time zone type: string actual_start_at: format: timestamp with time zone type: string age_days: format: integer type: integer allows_labour_entry: format: boolean type: boolean allows_parts_consumption: format: boolean type: boolean allows_sla_extension: format: boolean type: boolean allows_technician_edit: format: boolean type: boolean asset_category_id: description: >- Note: This is a Foreign Key to `asset_categories.id`. format: uuid type: string asset_id: description: >- Note: This is a Foreign Key to `asset_contracts.asset_id`. format: uuid type: string asset_image_file_id: format: uuid type: string asset_name: format: character varying maxLength: 250 type: string asset_number: format: character varying maxLength: 80 type: string assigned_team_id: description: |- Note: This is a Foreign Key to `teams.id`. format: uuid type: string assigned_team_name: format: character varying maxLength: 200 type: string assigned_vendor_id: description: >- Note: This is a Foreign Key to `assignable_vendors.id`. format: uuid type: string assigned_vendor_name: format: character varying maxLength: 200 type: string assignees: format: jsonb cc: format: jsonb checked_in_minutes: format: integer type: integer checked_in_since: format: timestamp with time zone type: string closed_at: format: timestamp with time zone type: string contract_id: description: >- Note: This is a Foreign Key to `contract_cover.contract_id`. format: uuid type: string created_at: format: timestamp with time zone type: string created_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string created_by_name: format: character varying maxLength: 200 type: string created_source: format: text type: string custom_fields: format: jsonb description: format: text type: string due_at: format: timestamp with time zone type: string estimated_duration_minutes: format: integer type: integer failure_code: format: character varying maxLength: 80 type: string id: description: |- Note: This is a Primary Key. format: uuid type: string is_emergency: format: boolean type: boolean is_open: format: boolean type: boolean is_overdue: format: boolean type: boolean is_planned: format: boolean type: boolean is_ready: format: boolean type: boolean is_unassigned: format: boolean type: boolean is_warranty_covered: format: boolean type: boolean labour_cost: format: numeric type: number location_id: description: >- Note: This is a Foreign Key to `location_settings.id`. format: uuid type: string maintenance_occurrence_id: description: >- Note: This is a Foreign Key to `asset_maintenance_plans.next_occurrence_id`. format: uuid type: string mandatory_tasks_outstanding: format: bigint type: integer origin: format: character varying maxLength: 30 type: string parts_cost: format: numeric type: number pending_approval_request_id: format: uuid type: string pending_sla_extension_request_id: format: uuid type: string permit_required: format: boolean type: boolean planned_end_at: format: timestamp with time zone type: string planned_start_at: format: timestamp with time zone type: string primary_image_file_id: format: uuid type: string priority: format: character varying maxLength: 40 type: string priority_name: format: character varying maxLength: 150 type: string priority_rank: format: smallint type: integer problem_code: format: character varying maxLength: 80 type: string readiness_score: format: numeric type: number remarks: format: text type: string reported_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string reported_by_user_name: format: character varying maxLength: 200 type: string requires_permit: format: boolean type: boolean resolution_code: format: character varying maxLength: 60 type: string resolution_code_name: format: character varying maxLength: 200 type: string resolution_due_at: format: timestamp with time zone type: string resolution_notes: format: text type: string response_due_at: format: timestamp with time zone type: string row_version: format: bigint type: integer safety_briefing: format: text type: string safety_instructions: format: text type: string site_code: format: character varying maxLength: 50 type: string site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string sla_breached: format: boolean type: boolean sla_breached_now: format: boolean type: boolean sla_source: format: character varying maxLength: 20 type: string sla_target_name: format: character varying maxLength: 150 type: string state_model_version_id: description: >- Note: This is a Foreign Key to `state_models.version_id`. format: uuid type: string status: format: character varying maxLength: 60 type: string status_category: format: character varying maxLength: 20 type: string status_id: description: |- Note: This is a Primary Key. format: uuid type: string status_is_terminal: format: boolean type: boolean status_label: format: text type: string task_count: format: bigint type: integer title: format: character varying maxLength: 250 type: string total_cost: format: numeric type: number total_cost_currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string turnaround_minutes: format: integer type: integer turnaround_running: format: boolean type: boolean updated_at: format: timestamp with time zone type: string updated_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string updated_by_name: format: character varying maxLength: 200 type: string vendor_cost: format: numeric type: number vendor_technician: format: character varying maxLength: 120 type: string vendor_technician_phone: format: character varying maxLength: 40 type: string work_order_category_id: description: >- Note: This is a Foreign Key to `asset_categories.id`. format: uuid type: string work_order_number: format: character varying maxLength: 60 type: string work_order_resolution_code_id: description: >- Note: This is a Foreign Key to `work_order_resolution_codes.id`. format: uuid type: string work_order_sla_target_id: description: >- Note: This is a Foreign Key to `work_order_sla_targets.id`. format: uuid type: string work_order_type: format: character varying maxLength: 40 type: string work_order_type_id: description: >- Note: This is a Foreign Key to `work_order_types.id`. format: uuid type: string work_order_type_name: format: character varying maxLength: 150 type: string work_request_id: description: >- Note: This is a Foreign Key to `work_requests.id`. format: uuid type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.