> ## 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. # Work order parts with every field of the records each row points at: part, substituted part, warehouse, work order. > Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. ## OpenAPI ````yaml /api-reference/openapi.json get /work_order_parts_expanded openapi: 3.0.0 info: description: '' title: >- The only schema PostgREST exposes. Reads are security_invoker views; writes are SECURITY DEFINER functions. Rebuilt wholesale on every deploy — it holds no data. version: 12.2.3 servers: - url: https://app.assetinfinity.ai/api security: [] tags: - name: Signing in - name: Profile - name: My work - name: Sites and locations - name: Assets - name: Asset lifecycle - name: Asset components - name: Work lifecycle - name: Work order execution - name: Work sequencing - name: Maintenance - name: Inspections - name: Checklists - name: Verification - name: Self verification - name: Inventory - name: Inventory detail - name: Parts demand - name: Procurement - name: Vendors and contracts - name: Contracts - name: Amendments - name: Vendor spend forecast - name: Workforce - name: Workforce detail - name: Capacity - name: Dispatch - name: Shutdown - name: Permits - name: Tools - name: Tools on jobs - name: Bookings - name: Calibration history - name: Reliability - name: Sensors and meters - name: Readers - name: Trackers - name: Real-time location - name: Feeds - name: Energy - name: IT assets - name: IT asset software - name: IT asset topology - name: Map - name: Floor plans - name: Labels - name: Lost and found - name: Visitors - name: Root cause analysis - name: Costing - name: Finance - name: Budgets - name: Capex plans - name: FF&E plans - name: Documents - name: Document control - name: Document folders - name: Document tree - name: Knowledge - name: Reports - name: Dashboards - name: Extracts - name: Data exports - name: Audit center - name: Audit feed - name: Activity - name: Conversations - name: Notifications - name: Date reminders - name: Channels - name: Search - name: Copilot - name: Import - name: Bulk jobs - name: File exchange - name: Filing exceptions - name: Files - name: Sync - name: Support - name: API keys - name: Webhooks - name: MCP connections - name: MCP sign-in - name: SCIM provisioning - name: Directory sync - name: Security streams - name: Single sign-on - name: Two-factor sign-in - name: Admin - name: Access - name: Lookups - name: Read models - name: Reference - name: Reference columns - name: Reference entry - name: List views - name: Mapping - name: Numbering - name: Branding - name: Custom fields - name: Form studio - name: Workflows - name: Workflow studio - name: Rules - name: Statuses and transitions - name: Currencies and locales - name: Today - name: Work configuration - name: Asset configuration - name: Inventory configuration - name: Tool configuration - name: Workforce configuration - name: Vendor and contract configuration - name: Document configuration - name: Inspection configuration - name: Sites, locations and the organisation - name: Setup - name: Features - name: Billing - name: Licence - name: Welcome - name: Tray - name: Tenant switch - name: Release - name: Telegram - name: Inbound mail - name: Platform externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /work_order_parts_expanded: get: tags: - Work order execution summary: >- Work order parts with every field of the records each row points at: part, substituted part, warehouse, work order. description: >- Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. parameters: - $ref: '#/components/parameters/rowFilter.work_order_parts_expanded.id' - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order_id - $ref: '#/components/parameters/rowFilter.work_order_parts_expanded.part_id' - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part_number - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse_id - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse_code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part_id - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part_number - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_required - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_reserved - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_issued - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_consumed - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_returned - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_shortfall - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_used - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.quantity_outstanding - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.unit_cost - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.unit_cost_currency_id - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.currency_code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.line_cost - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.is_warranty_covered - $ref: '#/components/parameters/rowFilter.work_order_parts_expanded.notes' - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.row_version - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__part_number - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__description - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__part_category - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__unit_of_measure - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__criticality - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__tracking_mode - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__is_stocked - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__is_consumable - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__is_active - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__on_hand_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__reserved_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__available_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__on_order_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__reorder_point - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__at_or_below_reorder_point - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__lead_time_days - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__open_recommendations - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__shortages_12m - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__shortages_that_stopped_work - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__created_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__created_by_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__updated_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.part__updated_by_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__part_number - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__description - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__part_category - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__unit_of_measure - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__criticality - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__tracking_mode - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__is_stocked - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__is_consumable - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__is_active - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__on_hand_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__reserved_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__available_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__on_order_quantity - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__reorder_point - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__at_or_below_reorder_point - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__lead_time_days - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__open_recommendations - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__shortages_12m - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__shortages_that_stopped_work - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__created_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__created_by_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__updated_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.substituted_part__updated_by_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__site_code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__site_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__warehouse_type - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__keeper_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__allows_negative_stock - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__is_active - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__bins - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__parts_stocked - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__units_on_hand - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.warehouse__negative_rows - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__work_order_number - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__title - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__description - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__remarks - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__work_order_type - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__work_order_type_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__is_planned - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__is_emergency - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__priority - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__priority_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__priority_rank - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__status - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__status_label - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__status_category - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__is_open - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__allows_technician_edit - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__allows_parts_consumption - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__allows_labour_entry - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__allows_sla_extension - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__origin - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__reported_by_user_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__asset_number - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__asset_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__site_code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__planned_start_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__planned_end_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__due_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__response_due_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__resolution_due_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__actual_start_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__actual_end_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__actual_duration_minutes - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__closed_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__readiness_score - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__is_ready - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__requires_permit - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__permit_required - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__safety_instructions - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__safety_briefing - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__problem_code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__failure_code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__resolution_code - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__resolution_code_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__resolution_notes - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__is_warranty_covered - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__sla_breached - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__sla_source - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__sla_target_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__estimated_duration_minutes - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__total_cost - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__labour_cost - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__parts_cost - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__vendor_cost - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__status_is_terminal - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__assigned_vendor_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__assigned_team_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__vendor_technician - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__vendor_technician_phone - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__assignees - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__cc - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__task_count - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__mandatory_tasks_outstanding - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__custom_fields - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__is_unassigned - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__age_days - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__turnaround_minutes - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__turnaround_running - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__checked_in_minutes - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__checked_in_since - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__is_overdue - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__sla_breached_now - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__created_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__created_by_name - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__updated_at - $ref: >- #/components/parameters/rowFilter.work_order_parts_expanded.work_order__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/work_order_parts_expanded' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/work_order_parts_expanded' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/work_order_parts_expanded' type: array text/csv: schema: items: $ref: '#/components/schemas/work_order_parts_expanded' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.work_order_parts_expanded.id: in: query name: id required: false schema: type: string rowFilter.work_order_parts_expanded.work_order_id: in: query name: work_order_id required: false schema: type: string rowFilter.work_order_parts_expanded.part_id: in: query name: part_id required: false schema: type: string rowFilter.work_order_parts_expanded.part_number: in: query name: part_number required: false schema: type: string rowFilter.work_order_parts_expanded.part_name: in: query name: part_name required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse_id: in: query name: warehouse_id required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse_code: in: query name: warehouse_code required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse_name: in: query name: warehouse_name required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part_id: in: query name: substituted_part_id required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part_number: in: query name: substituted_part_number required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_required: in: query name: quantity_required required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_reserved: in: query name: quantity_reserved required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_issued: in: query name: quantity_issued required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_consumed: in: query name: quantity_consumed required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_returned: in: query name: quantity_returned required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_shortfall: in: query name: quantity_shortfall required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_used: in: query name: quantity_used required: false schema: type: string rowFilter.work_order_parts_expanded.quantity_outstanding: in: query name: quantity_outstanding required: false schema: type: string rowFilter.work_order_parts_expanded.unit_cost: in: query name: unit_cost required: false schema: type: string rowFilter.work_order_parts_expanded.unit_cost_currency_id: in: query name: unit_cost_currency_id required: false schema: type: string rowFilter.work_order_parts_expanded.currency_code: in: query name: currency_code required: false schema: type: string rowFilter.work_order_parts_expanded.line_cost: in: query name: line_cost required: false schema: type: string rowFilter.work_order_parts_expanded.is_warranty_covered: in: query name: is_warranty_covered required: false schema: type: string rowFilter.work_order_parts_expanded.notes: in: query name: notes required: false schema: type: string rowFilter.work_order_parts_expanded.row_version: in: query name: row_version required: false schema: type: string rowFilter.work_order_parts_expanded.part__part_number: in: query name: part__part_number required: false schema: type: string rowFilter.work_order_parts_expanded.part__name: in: query name: part__name required: false schema: type: string rowFilter.work_order_parts_expanded.part__description: in: query name: part__description required: false schema: type: string rowFilter.work_order_parts_expanded.part__part_category: in: query name: part__part_category required: false schema: type: string rowFilter.work_order_parts_expanded.part__unit_of_measure: in: query name: part__unit_of_measure required: false schema: type: string rowFilter.work_order_parts_expanded.part__criticality: in: query name: part__criticality required: false schema: type: string rowFilter.work_order_parts_expanded.part__tracking_mode: in: query name: part__tracking_mode required: false schema: type: string rowFilter.work_order_parts_expanded.part__is_stocked: in: query name: part__is_stocked required: false schema: type: string rowFilter.work_order_parts_expanded.part__is_consumable: in: query name: part__is_consumable required: false schema: type: string rowFilter.work_order_parts_expanded.part__is_active: in: query name: part__is_active required: false schema: type: string rowFilter.work_order_parts_expanded.part__on_hand_quantity: in: query name: part__on_hand_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.part__reserved_quantity: in: query name: part__reserved_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.part__available_quantity: in: query name: part__available_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.part__on_order_quantity: in: query name: part__on_order_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.part__reorder_point: in: query name: part__reorder_point required: false schema: type: string rowFilter.work_order_parts_expanded.part__at_or_below_reorder_point: in: query name: part__at_or_below_reorder_point required: false schema: type: string rowFilter.work_order_parts_expanded.part__lead_time_days: in: query name: part__lead_time_days required: false schema: type: string rowFilter.work_order_parts_expanded.part__open_recommendations: in: query name: part__open_recommendations required: false schema: type: string rowFilter.work_order_parts_expanded.part__shortages_12m: in: query name: part__shortages_12m required: false schema: type: string rowFilter.work_order_parts_expanded.part__shortages_that_stopped_work: in: query name: part__shortages_that_stopped_work required: false schema: type: string rowFilter.work_order_parts_expanded.part__created_at: in: query name: part__created_at required: false schema: type: string rowFilter.work_order_parts_expanded.part__created_by_name: in: query name: part__created_by_name required: false schema: type: string rowFilter.work_order_parts_expanded.part__updated_at: in: query name: part__updated_at required: false schema: type: string rowFilter.work_order_parts_expanded.part__updated_by_name: in: query name: part__updated_by_name required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__part_number: in: query name: substituted_part__part_number required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__name: in: query name: substituted_part__name required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__description: in: query name: substituted_part__description required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__part_category: in: query name: substituted_part__part_category required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__unit_of_measure: in: query name: substituted_part__unit_of_measure required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__criticality: in: query name: substituted_part__criticality required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__tracking_mode: in: query name: substituted_part__tracking_mode required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__is_stocked: in: query name: substituted_part__is_stocked required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__is_consumable: in: query name: substituted_part__is_consumable required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__is_active: in: query name: substituted_part__is_active required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__on_hand_quantity: in: query name: substituted_part__on_hand_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__reserved_quantity: in: query name: substituted_part__reserved_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__available_quantity: in: query name: substituted_part__available_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__on_order_quantity: in: query name: substituted_part__on_order_quantity required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__reorder_point: in: query name: substituted_part__reorder_point required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__at_or_below_reorder_point: in: query name: substituted_part__at_or_below_reorder_point required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__lead_time_days: in: query name: substituted_part__lead_time_days required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__open_recommendations: in: query name: substituted_part__open_recommendations required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__shortages_12m: in: query name: substituted_part__shortages_12m required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__shortages_that_stopped_work: in: query name: substituted_part__shortages_that_stopped_work required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__created_at: in: query name: substituted_part__created_at required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__created_by_name: in: query name: substituted_part__created_by_name required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__updated_at: in: query name: substituted_part__updated_at required: false schema: type: string rowFilter.work_order_parts_expanded.substituted_part__updated_by_name: in: query name: substituted_part__updated_by_name required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__code: in: query name: warehouse__code required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__name: in: query name: warehouse__name required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__site_code: in: query name: warehouse__site_code required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__site_name: in: query name: warehouse__site_name required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__warehouse_type: in: query name: warehouse__warehouse_type required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__keeper_name: in: query name: warehouse__keeper_name required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__allows_negative_stock: in: query name: warehouse__allows_negative_stock required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__is_active: in: query name: warehouse__is_active required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__bins: in: query name: warehouse__bins required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__parts_stocked: in: query name: warehouse__parts_stocked required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__units_on_hand: in: query name: warehouse__units_on_hand required: false schema: type: string rowFilter.work_order_parts_expanded.warehouse__negative_rows: in: query name: warehouse__negative_rows required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__work_order_number: in: query name: work_order__work_order_number required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__title: in: query name: work_order__title required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__description: in: query name: work_order__description required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__remarks: in: query name: work_order__remarks required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__work_order_type: in: query name: work_order__work_order_type required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__work_order_type_name: in: query name: work_order__work_order_type_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__is_planned: in: query name: work_order__is_planned required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__is_emergency: in: query name: work_order__is_emergency required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__priority: in: query name: work_order__priority required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__priority_name: in: query name: work_order__priority_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__priority_rank: in: query name: work_order__priority_rank required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__status: in: query name: work_order__status required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__status_label: in: query name: work_order__status_label required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__status_category: in: query name: work_order__status_category required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__is_open: in: query name: work_order__is_open required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__allows_technician_edit: in: query name: work_order__allows_technician_edit required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__allows_parts_consumption: in: query name: work_order__allows_parts_consumption required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__allows_labour_entry: in: query name: work_order__allows_labour_entry required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__allows_sla_extension: in: query name: work_order__allows_sla_extension required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__origin: in: query name: work_order__origin required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__reported_by_user_name: in: query name: work_order__reported_by_user_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__asset_number: in: query name: work_order__asset_number required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__asset_name: in: query name: work_order__asset_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__site_code: in: query name: work_order__site_code required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__planned_start_at: in: query name: work_order__planned_start_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__planned_end_at: in: query name: work_order__planned_end_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__due_at: in: query name: work_order__due_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__response_due_at: in: query name: work_order__response_due_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__resolution_due_at: in: query name: work_order__resolution_due_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__actual_start_at: in: query name: work_order__actual_start_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__actual_end_at: in: query name: work_order__actual_end_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__actual_duration_minutes: in: query name: work_order__actual_duration_minutes required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__closed_at: in: query name: work_order__closed_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__readiness_score: in: query name: work_order__readiness_score required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__is_ready: in: query name: work_order__is_ready required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__requires_permit: in: query name: work_order__requires_permit required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__permit_required: in: query name: work_order__permit_required required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__safety_instructions: in: query name: work_order__safety_instructions required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__safety_briefing: in: query name: work_order__safety_briefing required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__problem_code: in: query name: work_order__problem_code required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__failure_code: in: query name: work_order__failure_code required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__resolution_code: in: query name: work_order__resolution_code required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__resolution_code_name: in: query name: work_order__resolution_code_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__resolution_notes: in: query name: work_order__resolution_notes required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__is_warranty_covered: in: query name: work_order__is_warranty_covered required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__sla_breached: in: query name: work_order__sla_breached required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__sla_source: in: query name: work_order__sla_source required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__sla_target_name: in: query name: work_order__sla_target_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__estimated_duration_minutes: in: query name: work_order__estimated_duration_minutes required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__total_cost: in: query name: work_order__total_cost required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__labour_cost: in: query name: work_order__labour_cost required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__parts_cost: in: query name: work_order__parts_cost required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__vendor_cost: in: query name: work_order__vendor_cost required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__status_is_terminal: in: query name: work_order__status_is_terminal required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__assigned_vendor_name: in: query name: work_order__assigned_vendor_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__assigned_team_name: in: query name: work_order__assigned_team_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__vendor_technician: in: query name: work_order__vendor_technician required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__vendor_technician_phone: in: query name: work_order__vendor_technician_phone required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__assignees: in: query name: work_order__assignees required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__cc: in: query name: work_order__cc required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__task_count: in: query name: work_order__task_count required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__mandatory_tasks_outstanding: in: query name: work_order__mandatory_tasks_outstanding required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__custom_fields: in: query name: work_order__custom_fields required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__is_unassigned: in: query name: work_order__is_unassigned required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__age_days: in: query name: work_order__age_days required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__turnaround_minutes: in: query name: work_order__turnaround_minutes required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__turnaround_running: in: query name: work_order__turnaround_running required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__checked_in_minutes: in: query name: work_order__checked_in_minutes required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__checked_in_since: in: query name: work_order__checked_in_since required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__is_overdue: in: query name: work_order__is_overdue required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__sla_breached_now: in: query name: work_order__sla_breached_now required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__created_at: in: query name: work_order__created_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__created_by_name: in: query name: work_order__created_by_name required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__updated_at: in: query name: work_order__updated_at required: false schema: type: string rowFilter.work_order_parts_expanded.work_order__updated_by_name: in: query name: work_order__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: work_order_parts_expanded: description: >- Work order parts with every field of the records each row points at: part, substituted part, warehouse, work order. Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. properties: currency_code: format: character varying maxLength: 3 type: string id: description: |- Note: This is a Primary Key. format: uuid type: string is_warranty_covered: format: boolean type: boolean line_cost: format: numeric type: number notes: format: text type: string part__at_or_below_reorder_point: format: boolean type: boolean part__available_quantity: format: numeric type: number part__created_at: format: timestamp with time zone type: string part__created_by_name: format: character varying maxLength: 200 type: string part__criticality: format: character varying maxLength: 20 type: string part__description: format: text type: string part__is_active: format: boolean type: boolean part__is_consumable: format: boolean type: boolean part__is_stocked: format: boolean type: boolean part__lead_time_days: format: integer type: integer part__name: format: character varying maxLength: 250 type: string part__on_hand_quantity: format: numeric type: number part__on_order_quantity: format: numeric type: number part__open_recommendations: format: bigint type: integer part__part_category: format: character varying maxLength: 60 type: string part__part_number: format: character varying maxLength: 80 type: string part__reorder_point: format: numeric type: number part__reserved_quantity: format: numeric type: number part__shortages_12m: format: bigint type: integer part__shortages_that_stopped_work: format: bigint type: integer part__tracking_mode: format: character varying maxLength: 20 type: string part__unit_of_measure: format: character varying maxLength: 30 type: string part__updated_at: format: timestamp with time zone type: string part__updated_by_name: format: character varying maxLength: 200 type: string part_id: description: >- Note: This is a Foreign Key to `inventory_available.part_id`. format: uuid type: string part_name: format: character varying maxLength: 250 type: string part_number: format: character varying maxLength: 80 type: string quantity_consumed: format: numeric type: number quantity_issued: format: numeric type: number quantity_outstanding: format: numeric type: number quantity_required: format: numeric type: number quantity_reserved: format: numeric type: number quantity_returned: format: numeric type: number quantity_shortfall: format: numeric type: number quantity_used: format: numeric type: number row_version: format: bigint type: integer substituted_part__at_or_below_reorder_point: format: boolean type: boolean substituted_part__available_quantity: format: numeric type: number substituted_part__created_at: format: timestamp with time zone type: string substituted_part__created_by_name: format: character varying maxLength: 200 type: string substituted_part__criticality: format: character varying maxLength: 20 type: string substituted_part__description: format: text type: string substituted_part__is_active: format: boolean type: boolean substituted_part__is_consumable: format: boolean type: boolean substituted_part__is_stocked: format: boolean type: boolean substituted_part__lead_time_days: format: integer type: integer substituted_part__name: format: character varying maxLength: 250 type: string substituted_part__on_hand_quantity: format: numeric type: number substituted_part__on_order_quantity: format: numeric type: number substituted_part__open_recommendations: format: bigint type: integer substituted_part__part_category: format: character varying maxLength: 60 type: string substituted_part__part_number: format: character varying maxLength: 80 type: string substituted_part__reorder_point: format: numeric type: number substituted_part__reserved_quantity: format: numeric type: number substituted_part__shortages_12m: format: bigint type: integer substituted_part__shortages_that_stopped_work: format: bigint type: integer substituted_part__tracking_mode: format: character varying maxLength: 20 type: string substituted_part__unit_of_measure: format: character varying maxLength: 30 type: string substituted_part__updated_at: format: timestamp with time zone type: string substituted_part__updated_by_name: format: character varying maxLength: 200 type: string substituted_part_id: description: >- Note: This is a Foreign Key to `inventory_available.part_id`. format: uuid type: string substituted_part_number: format: character varying maxLength: 80 type: string unit_cost: format: numeric type: number unit_cost_currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string warehouse__allows_negative_stock: format: boolean type: boolean warehouse__bins: format: bigint type: integer warehouse__code: format: character varying maxLength: 60 type: string warehouse__is_active: format: boolean type: boolean warehouse__keeper_name: format: character varying maxLength: 200 type: string warehouse__name: format: character varying maxLength: 200 type: string warehouse__negative_rows: format: bigint type: integer warehouse__parts_stocked: format: bigint type: integer warehouse__site_code: format: character varying maxLength: 50 type: string warehouse__site_name: format: character varying maxLength: 200 type: string warehouse__units_on_hand: format: numeric type: number warehouse__warehouse_type: format: character varying maxLength: 30 type: string warehouse_code: format: character varying maxLength: 60 type: string warehouse_id: description: >- Note: This is a Foreign Key to `warehouse_settings.id`. format: uuid type: string warehouse_name: format: character varying maxLength: 200 type: string work_order__actual_duration_minutes: format: integer type: integer work_order__actual_end_at: format: timestamp with time zone type: string work_order__actual_start_at: format: timestamp with time zone type: string work_order__age_days: format: integer type: integer work_order__allows_labour_entry: format: boolean type: boolean work_order__allows_parts_consumption: format: boolean type: boolean work_order__allows_sla_extension: format: boolean type: boolean work_order__allows_technician_edit: format: boolean type: boolean work_order__asset_name: format: character varying maxLength: 250 type: string work_order__asset_number: format: character varying maxLength: 80 type: string work_order__assigned_team_name: format: character varying maxLength: 200 type: string work_order__assigned_vendor_name: format: character varying maxLength: 200 type: string work_order__assignees: format: jsonb work_order__cc: format: jsonb work_order__checked_in_minutes: format: integer type: integer work_order__checked_in_since: format: timestamp with time zone type: string work_order__closed_at: format: timestamp with time zone type: string work_order__created_at: format: timestamp with time zone type: string work_order__created_by_name: format: character varying maxLength: 200 type: string work_order__custom_fields: format: jsonb work_order__description: format: text type: string work_order__due_at: format: timestamp with time zone type: string work_order__estimated_duration_minutes: format: integer type: integer work_order__failure_code: format: character varying maxLength: 80 type: string work_order__is_emergency: format: boolean type: boolean work_order__is_open: format: boolean type: boolean work_order__is_overdue: format: boolean type: boolean work_order__is_planned: format: boolean type: boolean work_order__is_ready: format: boolean type: boolean work_order__is_unassigned: format: boolean type: boolean work_order__is_warranty_covered: format: boolean type: boolean work_order__labour_cost: format: numeric type: number work_order__mandatory_tasks_outstanding: format: bigint type: integer work_order__origin: format: character varying maxLength: 30 type: string work_order__parts_cost: format: numeric type: number work_order__permit_required: format: boolean type: boolean work_order__planned_end_at: format: timestamp with time zone type: string work_order__planned_start_at: format: timestamp with time zone type: string work_order__priority: format: character varying maxLength: 40 type: string work_order__priority_name: format: character varying maxLength: 150 type: string work_order__priority_rank: format: smallint type: integer work_order__problem_code: format: character varying maxLength: 80 type: string work_order__readiness_score: format: numeric type: number work_order__remarks: format: text type: string work_order__reported_by_user_name: format: character varying maxLength: 200 type: string work_order__requires_permit: format: boolean type: boolean work_order__resolution_code: format: character varying maxLength: 60 type: string work_order__resolution_code_name: format: character varying maxLength: 200 type: string work_order__resolution_due_at: format: timestamp with time zone type: string work_order__resolution_notes: format: text type: string work_order__response_due_at: format: timestamp with time zone type: string work_order__safety_briefing: format: text type: string work_order__safety_instructions: format: text type: string work_order__site_code: format: character varying maxLength: 50 type: string work_order__sla_breached: format: boolean type: boolean work_order__sla_breached_now: format: boolean type: boolean work_order__sla_source: format: character varying maxLength: 20 type: string work_order__sla_target_name: format: character varying maxLength: 150 type: string work_order__status: format: character varying maxLength: 60 type: string work_order__status_category: format: character varying maxLength: 20 type: string work_order__status_is_terminal: format: boolean type: boolean work_order__status_label: format: text type: string work_order__task_count: format: bigint type: integer work_order__title: format: character varying maxLength: 250 type: string work_order__total_cost: format: numeric type: number work_order__turnaround_minutes: format: integer type: integer work_order__turnaround_running: format: boolean type: boolean work_order__updated_at: format: timestamp with time zone type: string work_order__updated_by_name: format: character varying maxLength: 200 type: string work_order__vendor_cost: format: numeric type: number work_order__vendor_technician: format: character varying maxLength: 120 type: string work_order__vendor_technician_phone: format: character varying maxLength: 40 type: string work_order__work_order_number: format: character varying maxLength: 60 type: string work_order__work_order_type: format: character varying maxLength: 40 type: string work_order__work_order_type_name: format: character varying maxLength: 150 type: string work_order_id: description: >- Note: This is a Foreign Key to `asset_maintenance_plans.next_work_order_id`. format: uuid type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.