> ## 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. # Purchase requisitions with every field of the records each row points at: asset, cost centre, department, maintenance plan, requested by, site, 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 /purchase_requisitions_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: Assets - name: Asset lifecycle - name: Work lifecycle - name: Maintenance - name: Inventory - name: Inventory detail - name: Procurement - name: Contracts - name: Workforce - name: Capacity - name: Dispatch - name: Tools - name: Inspections - name: Verification - name: Reliability - name: Parts demand - name: Sensors and meters - name: Map - name: Floor plans - name: Labels - name: Lost and found - name: Root cause analysis - name: Reports - name: Audit center - name: Activity - name: Notifications - name: Channels - name: Search - name: Copilot - name: Import - name: Files - name: Sync - name: Support - name: Admin - name: Access - name: Lookups - name: Read models - name: Branding - name: Custom fields - name: Form studio - name: Workflows - name: Workflow studio - name: Rules - name: Statuses and transitions - name: Currencies and locales - 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: Platform - name: Amendments - name: Asset clone - name: Asset components - name: Asset register - name: Asset transfer - name: Audit feed - name: Billing - name: Bookings - name: Budgets - name: Bulk jobs - name: Calibration history - name: Capex plans - name: Conversations - name: Costing - name: Currency - name: Dashboards - name: Directory sync - name: Document control - name: Document folders - name: Document tree - name: Documents - name: Energy - name: Extracts - name: Features - name: Feeds - name: File exchange - name: Filing exceptions - name: Finance - name: Inbound mail - name: Keys - name: Knowledge - name: Licence - name: List views - name: Locations - name: Mapping - name: Mcp - name: Mcp oauth - name: Mfa - name: Numbering - name: Permits - name: Readers - name: Reference - name: Reference columns - name: Reference entry - name: Release - name: Scim - name: Security streams - name: Self verification - name: Setup - name: Shutdown - name: Sso - name: Telegram - name: Tenant switch - name: The caller's own work - name: The checklist library - name: Tools on a job, and who has them out - name: Tray - name: Vendor spend forecast - name: Vendors and contracts - name: Visitors - name: Work order execution - name: Work sequencing - name: Workforce detail externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /purchase_requisitions_expanded: get: tags: - purchase_requisitions_expanded summary: >- Purchase requisitions with every field of the records each row points at: asset, cost centre, department, maintenance plan, requested by, site, 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.purchase_requisitions_expanded.id' - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requisition_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.title - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.description - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.status - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.status_label - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.status_category - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.origin - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.priority - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.purchase_recommendation_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cost_center_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.budget_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.budget_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.budget_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.budget_available - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by_user_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.required_by - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.justification - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.estimated_total - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.estimated_total_currency_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.currency_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.submitted_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.approved_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.approved_by - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.rejected_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.rejection_reason - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cancelled_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cancellation_reason - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.line_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.awaiting_permission - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.approvals_outstanding - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.purchase_order_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.custom_fields - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.row_version - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.created_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.created_by_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.created_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.created_source - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.updated_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.updated_by_id - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.updated_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__serial_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_category_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_category - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_category_ancestor_ids - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_category_path - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_category_root_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_category_root - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_class_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_class - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__asset_class_is_default - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__status - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__status_label - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__status_category - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__criticality - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__criticality_rank - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__criticality_response_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__site_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__site_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__location_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__latitude - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__longitude - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__parent_asset_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__manufacturer - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__model_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__model_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__purchase_date - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__installation_date - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__commissioning_date - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__warranty_expires_on - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__health_score - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__is_retired - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__custodian - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__custodian_email - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__custody_since - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__custom_fields - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__created_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__created_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__updated_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.asset__updated_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cost_centre__code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cost_centre__name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cost_centre__company_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cost_centre__is_active - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.cost_centre__departments - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__business_unit_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__cost_centre_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__manager_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__maintenance_manager_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__is_active - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__workers - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.department__assets - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__inspection_template_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__inspection_template_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__raises_inspection - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__plan_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__description - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__maintenance_type - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__maintenance_type_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__status - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__status_label - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__status_category - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__site_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__priority_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__priority_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__criticality - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__trigger_combination - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__estimated_duration_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__lead_time_days - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__tolerance_days - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__sla_response_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__sla_resolution_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__assigned_team_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__preferred_worker_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__preferred_vendor_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__assigned_to_user_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__end_date - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__reminder_days - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__use_contract_visits - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__requires_permit - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__requires_shutdown - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__safety_instructions - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__instructions - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__auto_generate_work_order - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__current_version_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__last_generated_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__is_active - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_category_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__place_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__scope_names - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_category_codes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_category_names - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_names - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__place_names - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__task_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__requirement_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__trigger_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__frequency - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__next_due_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__work_orders_generated - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__custom_fields - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__created_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__created_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__updated_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.maintenance_plan__updated_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__email - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__username - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__sign_in_handle - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__phone - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__status - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__last_login_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__worker_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__worker_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__worker_type - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__worker_is_active - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.requested_by__worker_teams - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__timezone - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__is_active - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__company_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__business_unit_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__business_unit_parent_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.site__asset_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__site_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__site_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__warehouse_type - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__keeper_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__allows_negative_stock - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__is_active - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__bins - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__parts_stocked - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__units_on_hand - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.warehouse__negative_rows - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__work_order_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__title - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__description - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__remarks - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__work_order_type - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__work_order_type_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__is_planned - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__is_emergency - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__priority - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__priority_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__priority_rank - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__status - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__status_label - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__status_category - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__is_open - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__allows_technician_edit - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__allows_parts_consumption - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__allows_labour_entry - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__allows_sla_extension - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__origin - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__reported_by_user_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__asset_number - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__asset_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__site_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__planned_start_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__planned_end_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__due_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__response_due_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__resolution_due_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__actual_start_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__actual_end_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__actual_duration_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__closed_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__readiness_score - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__is_ready - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__requires_permit - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__permit_required - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__safety_instructions - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__safety_briefing - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__problem_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__failure_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__resolution_code - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__resolution_code_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__resolution_notes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__is_warranty_covered - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__sla_breached - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__estimated_duration_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__total_cost - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__labour_cost - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__parts_cost - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__vendor_cost - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__status_is_terminal - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__assigned_vendor_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__assigned_team_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__vendor_technician - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__vendor_technician_phone - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__assignees - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__cc - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__task_count - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__mandatory_tasks_outstanding - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__custom_fields - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__is_unassigned - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__age_days - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__turnaround_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__turnaround_running - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__checked_in_minutes - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__checked_in_since - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__is_overdue - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__sla_breached_now - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__created_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__created_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__updated_at - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.work_order__updated_by_name - $ref: >- #/components/parameters/rowFilter.purchase_requisitions_expanded.reference_records - $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/purchase_requisitions_expanded' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/purchase_requisitions_expanded' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/purchase_requisitions_expanded' type: array text/csv: schema: items: $ref: '#/components/schemas/purchase_requisitions_expanded' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.purchase_requisitions_expanded.id: in: query name: id required: false schema: type: string rowFilter.purchase_requisitions_expanded.requisition_number: in: query name: requisition_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.title: in: query name: title required: false schema: type: string rowFilter.purchase_requisitions_expanded.description: in: query name: description required: false schema: type: string rowFilter.purchase_requisitions_expanded.status: in: query name: status required: false schema: type: string rowFilter.purchase_requisitions_expanded.status_label: in: query name: status_label required: false schema: type: string rowFilter.purchase_requisitions_expanded.status_category: in: query name: status_category required: false schema: type: string rowFilter.purchase_requisitions_expanded.origin: in: query name: origin required: false schema: type: string rowFilter.purchase_requisitions_expanded.priority: in: query name: priority required: false schema: type: string rowFilter.purchase_requisitions_expanded.site_id: in: query name: site_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.site_code: in: query name: site_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.site_name: in: query name: site_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset_id: in: query name: asset_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset_number: in: query name: asset_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order_id: in: query name: work_order_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order_number: in: query name: work_order_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan_id: in: query name: maintenance_plan_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan_number: in: query name: maintenance_plan_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan_name: in: query name: maintenance_plan_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.purchase_recommendation_id: in: query name: purchase_recommendation_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse_id: in: query name: warehouse_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse_name: in: query name: warehouse_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.department_id: in: query name: department_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.cost_center_id: in: query name: cost_center_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.budget_id: in: query name: budget_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.budget_code: in: query name: budget_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.budget_name: in: query name: budget_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.budget_available: in: query name: budget_available required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by_user_id: in: query name: requested_by_user_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by: in: query name: requested_by required: false schema: type: string rowFilter.purchase_requisitions_expanded.required_by: in: query name: required_by required: false schema: type: string rowFilter.purchase_requisitions_expanded.justification: in: query name: justification required: false schema: type: string rowFilter.purchase_requisitions_expanded.estimated_total: in: query name: estimated_total required: false schema: type: string rowFilter.purchase_requisitions_expanded.estimated_total_currency_id: in: query name: estimated_total_currency_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.currency_code: in: query name: currency_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.submitted_at: in: query name: submitted_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.approved_at: in: query name: approved_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.approved_by: in: query name: approved_by required: false schema: type: string rowFilter.purchase_requisitions_expanded.rejected_at: in: query name: rejected_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.rejection_reason: in: query name: rejection_reason required: false schema: type: string rowFilter.purchase_requisitions_expanded.cancelled_at: in: query name: cancelled_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.cancellation_reason: in: query name: cancellation_reason required: false schema: type: string rowFilter.purchase_requisitions_expanded.line_count: in: query name: line_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.awaiting_permission: in: query name: awaiting_permission required: false schema: type: string rowFilter.purchase_requisitions_expanded.approvals_outstanding: in: query name: approvals_outstanding required: false schema: type: string rowFilter.purchase_requisitions_expanded.purchase_order_count: in: query name: purchase_order_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.custom_fields: in: query name: custom_fields required: false schema: type: string rowFilter.purchase_requisitions_expanded.row_version: in: query name: row_version required: false schema: type: string rowFilter.purchase_requisitions_expanded.created_at: in: query name: created_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.created_source: in: query name: created_source required: false schema: type: string rowFilter.purchase_requisitions_expanded.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.purchase_requisitions_expanded.updated_by_name: in: query name: updated_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_number: in: query name: asset__asset_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__name: in: query name: asset__name required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__serial_number: in: query name: asset__serial_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_category_code: in: query name: asset__asset_category_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_category: in: query name: asset__asset_category required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_category_ancestor_ids: in: query name: asset__asset_category_ancestor_ids required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_category_path: in: query name: asset__asset_category_path required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_category_root_code: in: query name: asset__asset_category_root_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_category_root: in: query name: asset__asset_category_root required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_class_code: in: query name: asset__asset_class_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_class: in: query name: asset__asset_class required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__asset_class_is_default: in: query name: asset__asset_class_is_default required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__status: in: query name: asset__status required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__status_label: in: query name: asset__status_label required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__status_category: in: query name: asset__status_category required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__criticality: in: query name: asset__criticality required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__criticality_rank: in: query name: asset__criticality_rank required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__criticality_response_minutes: in: query name: asset__criticality_response_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__site_code: in: query name: asset__site_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__site_name: in: query name: asset__site_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__location_name: in: query name: asset__location_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__latitude: in: query name: asset__latitude required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__longitude: in: query name: asset__longitude required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__parent_asset_number: in: query name: asset__parent_asset_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__manufacturer: in: query name: asset__manufacturer required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__model_code: in: query name: asset__model_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__model_name: in: query name: asset__model_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__purchase_date: in: query name: asset__purchase_date required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__installation_date: in: query name: asset__installation_date required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__commissioning_date: in: query name: asset__commissioning_date required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__warranty_expires_on: in: query name: asset__warranty_expires_on required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__health_score: in: query name: asset__health_score required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__is_retired: in: query name: asset__is_retired required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__custodian: in: query name: asset__custodian required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__custodian_email: in: query name: asset__custodian_email required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__custody_since: in: query name: asset__custody_since required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__custom_fields: in: query name: asset__custom_fields required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__created_at: in: query name: asset__created_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__created_by_name: in: query name: asset__created_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__updated_at: in: query name: asset__updated_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.asset__updated_by_name: in: query name: asset__updated_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.cost_centre__code: in: query name: cost_centre__code required: false schema: type: string rowFilter.purchase_requisitions_expanded.cost_centre__name: in: query name: cost_centre__name required: false schema: type: string rowFilter.purchase_requisitions_expanded.cost_centre__company_name: in: query name: cost_centre__company_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.cost_centre__is_active: in: query name: cost_centre__is_active required: false schema: type: string rowFilter.purchase_requisitions_expanded.cost_centre__departments: in: query name: cost_centre__departments required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__code: in: query name: department__code required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__name: in: query name: department__name required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__business_unit_name: in: query name: department__business_unit_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__cost_centre_name: in: query name: department__cost_centre_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__manager_name: in: query name: department__manager_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__maintenance_manager_name: in: query name: department__maintenance_manager_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__is_active: in: query name: department__is_active required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__workers: in: query name: department__workers required: false schema: type: string rowFilter.purchase_requisitions_expanded.department__assets: in: query name: department__assets required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__inspection_template_code: in: query name: maintenance_plan__inspection_template_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__inspection_template_name: in: query name: maintenance_plan__inspection_template_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__raises_inspection: in: query name: maintenance_plan__raises_inspection required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__plan_number: in: query name: maintenance_plan__plan_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__name: in: query name: maintenance_plan__name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__description: in: query name: maintenance_plan__description required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__maintenance_type: in: query name: maintenance_plan__maintenance_type required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__maintenance_type_name: in: query name: maintenance_plan__maintenance_type_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__status: in: query name: maintenance_plan__status required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__status_label: in: query name: maintenance_plan__status_label required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__status_category: in: query name: maintenance_plan__status_category required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__site_code: in: query name: maintenance_plan__site_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__priority_code: in: query name: maintenance_plan__priority_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__priority_name: in: query name: maintenance_plan__priority_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__criticality: in: query name: maintenance_plan__criticality required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__trigger_combination: in: query name: maintenance_plan__trigger_combination required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__estimated_duration_minutes: in: query name: maintenance_plan__estimated_duration_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__lead_time_days: in: query name: maintenance_plan__lead_time_days required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__tolerance_days: in: query name: maintenance_plan__tolerance_days required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__sla_response_minutes: in: query name: maintenance_plan__sla_response_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__sla_resolution_minutes: in: query name: maintenance_plan__sla_resolution_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__assigned_team_name: in: query name: maintenance_plan__assigned_team_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__preferred_worker_name: in: query name: maintenance_plan__preferred_worker_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__preferred_vendor_name: in: query name: maintenance_plan__preferred_vendor_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__assigned_to_user_name: in: query name: maintenance_plan__assigned_to_user_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__end_date: in: query name: maintenance_plan__end_date required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__reminder_days: in: query name: maintenance_plan__reminder_days required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__use_contract_visits: in: query name: maintenance_plan__use_contract_visits required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__requires_permit: in: query name: maintenance_plan__requires_permit required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__requires_shutdown: in: query name: maintenance_plan__requires_shutdown required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__safety_instructions: in: query name: maintenance_plan__safety_instructions required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__instructions: in: query name: maintenance_plan__instructions required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__auto_generate_work_order: in: query name: maintenance_plan__auto_generate_work_order required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__current_version_number: in: query name: maintenance_plan__current_version_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__last_generated_at: in: query name: maintenance_plan__last_generated_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__is_active: in: query name: maintenance_plan__is_active required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_count: in: query name: maintenance_plan__asset_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_category_count: in: query name: maintenance_plan__asset_category_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__place_count: in: query name: maintenance_plan__place_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__scope_names: in: query name: maintenance_plan__scope_names required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_category_codes: in: query name: maintenance_plan__asset_category_codes required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_category_names: in: query name: maintenance_plan__asset_category_names required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__asset_names: in: query name: maintenance_plan__asset_names required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__place_names: in: query name: maintenance_plan__place_names required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__task_count: in: query name: maintenance_plan__task_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__requirement_count: in: query name: maintenance_plan__requirement_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__trigger_count: in: query name: maintenance_plan__trigger_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__frequency: in: query name: maintenance_plan__frequency required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__next_due_at: in: query name: maintenance_plan__next_due_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__work_orders_generated: in: query name: maintenance_plan__work_orders_generated required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__custom_fields: in: query name: maintenance_plan__custom_fields required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__created_at: in: query name: maintenance_plan__created_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__created_by_name: in: query name: maintenance_plan__created_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__updated_at: in: query name: maintenance_plan__updated_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.maintenance_plan__updated_by_name: in: query name: maintenance_plan__updated_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__email: in: query name: requested_by__email required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__username: in: query name: requested_by__username required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__sign_in_handle: in: query name: requested_by__sign_in_handle required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__name: in: query name: requested_by__name required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__phone: in: query name: requested_by__phone required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__status: in: query name: requested_by__status required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__last_login_at: in: query name: requested_by__last_login_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__worker_number: in: query name: requested_by__worker_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__worker_name: in: query name: requested_by__worker_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__worker_type: in: query name: requested_by__worker_type required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__worker_is_active: in: query name: requested_by__worker_is_active required: false schema: type: string rowFilter.purchase_requisitions_expanded.requested_by__worker_teams: in: query name: requested_by__worker_teams required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__code: in: query name: site__code required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__name: in: query name: site__name required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__timezone: in: query name: site__timezone required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__is_active: in: query name: site__is_active required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__company_name: in: query name: site__company_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__business_unit_name: in: query name: site__business_unit_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__business_unit_parent_name: in: query name: site__business_unit_parent_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.site__asset_count: in: query name: site__asset_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__code: in: query name: warehouse__code required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__name: in: query name: warehouse__name required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__site_code: in: query name: warehouse__site_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__site_name: in: query name: warehouse__site_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__warehouse_type: in: query name: warehouse__warehouse_type required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__keeper_name: in: query name: warehouse__keeper_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__allows_negative_stock: in: query name: warehouse__allows_negative_stock required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__is_active: in: query name: warehouse__is_active required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__bins: in: query name: warehouse__bins required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__parts_stocked: in: query name: warehouse__parts_stocked required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__units_on_hand: in: query name: warehouse__units_on_hand required: false schema: type: string rowFilter.purchase_requisitions_expanded.warehouse__negative_rows: in: query name: warehouse__negative_rows required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__work_order_number: in: query name: work_order__work_order_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__title: in: query name: work_order__title required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__description: in: query name: work_order__description required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__remarks: in: query name: work_order__remarks required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__work_order_type: in: query name: work_order__work_order_type required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__work_order_type_name: in: query name: work_order__work_order_type_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__is_planned: in: query name: work_order__is_planned required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__is_emergency: in: query name: work_order__is_emergency required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__priority: in: query name: work_order__priority required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__priority_name: in: query name: work_order__priority_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__priority_rank: in: query name: work_order__priority_rank required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__status: in: query name: work_order__status required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__status_label: in: query name: work_order__status_label required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__status_category: in: query name: work_order__status_category required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__is_open: in: query name: work_order__is_open required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__allows_technician_edit: in: query name: work_order__allows_technician_edit required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__allows_parts_consumption: in: query name: work_order__allows_parts_consumption required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__allows_labour_entry: in: query name: work_order__allows_labour_entry required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__allows_sla_extension: in: query name: work_order__allows_sla_extension required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__origin: in: query name: work_order__origin required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__reported_by_user_name: in: query name: work_order__reported_by_user_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__asset_number: in: query name: work_order__asset_number required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__asset_name: in: query name: work_order__asset_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__site_code: in: query name: work_order__site_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__planned_start_at: in: query name: work_order__planned_start_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__planned_end_at: in: query name: work_order__planned_end_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__due_at: in: query name: work_order__due_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__response_due_at: in: query name: work_order__response_due_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__resolution_due_at: in: query name: work_order__resolution_due_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__actual_start_at: in: query name: work_order__actual_start_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__actual_end_at: in: query name: work_order__actual_end_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__actual_duration_minutes: in: query name: work_order__actual_duration_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__closed_at: in: query name: work_order__closed_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__readiness_score: in: query name: work_order__readiness_score required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__is_ready: in: query name: work_order__is_ready required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__requires_permit: in: query name: work_order__requires_permit required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__permit_required: in: query name: work_order__permit_required required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__safety_instructions: in: query name: work_order__safety_instructions required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__safety_briefing: in: query name: work_order__safety_briefing required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__problem_code: in: query name: work_order__problem_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__failure_code: in: query name: work_order__failure_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__resolution_code: in: query name: work_order__resolution_code required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__resolution_code_name: in: query name: work_order__resolution_code_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__resolution_notes: in: query name: work_order__resolution_notes required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__is_warranty_covered: in: query name: work_order__is_warranty_covered required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__sla_breached: in: query name: work_order__sla_breached required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__estimated_duration_minutes: in: query name: work_order__estimated_duration_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__total_cost: in: query name: work_order__total_cost required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__labour_cost: in: query name: work_order__labour_cost required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__parts_cost: in: query name: work_order__parts_cost required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__vendor_cost: in: query name: work_order__vendor_cost required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__status_is_terminal: in: query name: work_order__status_is_terminal required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__assigned_vendor_name: in: query name: work_order__assigned_vendor_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__assigned_team_name: in: query name: work_order__assigned_team_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__vendor_technician: in: query name: work_order__vendor_technician required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__vendor_technician_phone: in: query name: work_order__vendor_technician_phone required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__assignees: in: query name: work_order__assignees required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__cc: in: query name: work_order__cc required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__task_count: in: query name: work_order__task_count required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__mandatory_tasks_outstanding: in: query name: work_order__mandatory_tasks_outstanding required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__custom_fields: in: query name: work_order__custom_fields required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__is_unassigned: in: query name: work_order__is_unassigned required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__age_days: in: query name: work_order__age_days required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__turnaround_minutes: in: query name: work_order__turnaround_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__turnaround_running: in: query name: work_order__turnaround_running required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__checked_in_minutes: in: query name: work_order__checked_in_minutes required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__checked_in_since: in: query name: work_order__checked_in_since required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__is_overdue: in: query name: work_order__is_overdue required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__sla_breached_now: in: query name: work_order__sla_breached_now required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__created_at: in: query name: work_order__created_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__created_by_name: in: query name: work_order__created_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__updated_at: in: query name: work_order__updated_at required: false schema: type: string rowFilter.purchase_requisitions_expanded.work_order__updated_by_name: in: query name: work_order__updated_by_name required: false schema: type: string rowFilter.purchase_requisitions_expanded.reference_records: in: query name: reference_records 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: purchase_requisitions_expanded: description: >- Purchase requisitions with every field of the records each row points at: asset, cost centre, department, maintenance plan, requested by, site, 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: approvals_outstanding: format: bigint type: integer approved_at: format: timestamp with time zone type: string approved_by: format: character varying maxLength: 200 type: string asset__asset_category: format: character varying maxLength: 200 type: string asset__asset_category_ancestor_ids: format: uuid[] items: type: string type: array asset__asset_category_code: format: character varying maxLength: 60 type: string asset__asset_category_path: format: text type: string asset__asset_category_root: format: character varying maxLength: 200 type: string asset__asset_category_root_code: format: character varying maxLength: 60 type: string asset__asset_class: format: character varying type: string asset__asset_class_code: format: character varying type: string asset__asset_class_is_default: format: boolean type: boolean asset__asset_number: format: character varying maxLength: 80 type: string asset__commissioning_date: format: date type: string asset__created_at: format: timestamp with time zone type: string asset__created_by_name: format: character varying maxLength: 200 type: string asset__criticality: format: character varying maxLength: 40 type: string asset__criticality_rank: format: smallint type: integer asset__criticality_response_minutes: format: integer type: integer asset__custodian: format: character varying type: string asset__custodian_email: format: public.citext type: string asset__custody_since: format: date type: string asset__custom_fields: format: jsonb asset__health_score: format: numeric type: number asset__installation_date: format: date type: string asset__is_retired: format: boolean type: boolean asset__latitude: format: numeric type: number asset__location_name: format: character varying maxLength: 200 type: string asset__longitude: format: numeric type: number asset__manufacturer: format: character varying maxLength: 200 type: string asset__model_code: format: character varying maxLength: 80 type: string asset__model_name: format: character varying maxLength: 200 type: string asset__name: format: character varying maxLength: 250 type: string asset__parent_asset_number: format: character varying maxLength: 80 type: string asset__purchase_date: format: date type: string asset__serial_number: format: character varying maxLength: 120 type: string asset__site_code: format: character varying maxLength: 50 type: string asset__site_name: format: character varying maxLength: 200 type: string asset__status: format: character varying maxLength: 60 type: string asset__status_category: format: character varying maxLength: 20 type: string asset__status_label: format: text type: string asset__updated_at: format: timestamp with time zone type: string asset__updated_by_name: format: character varying maxLength: 200 type: string asset__warranty_expires_on: format: date type: string asset_id: description: >- Note: This is a Foreign Key to `asset_contracts.asset_id`. format: uuid type: string asset_number: format: character varying maxLength: 80 type: string awaiting_permission: format: character varying maxLength: 120 type: string budget_available: format: numeric type: number budget_code: format: character varying maxLength: 60 type: string budget_id: description: |- Note: This is a Primary Key. format: uuid type: string budget_name: format: character varying maxLength: 200 type: string cancellation_reason: format: text type: string cancelled_at: format: timestamp with time zone type: string cost_center_id: description: >- Note: This is a Foreign Key to `cost_centre_settings.id`. format: uuid type: string cost_centre__code: format: character varying maxLength: 50 type: string cost_centre__company_name: format: character varying maxLength: 200 type: string cost_centre__departments: format: bigint type: integer cost_centre__is_active: format: boolean type: boolean cost_centre__name: format: character varying maxLength: 200 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 currency_code: format: character varying maxLength: 3 type: string custom_fields: format: jsonb department__assets: format: bigint type: integer department__business_unit_name: format: character varying maxLength: 200 type: string department__code: format: character varying maxLength: 50 type: string department__cost_centre_name: format: character varying maxLength: 200 type: string department__is_active: format: boolean type: boolean department__maintenance_manager_name: format: character varying maxLength: 200 type: string department__manager_name: format: character varying maxLength: 200 type: string department__name: format: character varying maxLength: 200 type: string department__workers: format: bigint type: integer department_id: description: >- Note: This is a Foreign Key to `department_settings.id`. format: uuid type: string description: format: text type: string estimated_total: format: numeric type: number estimated_total_currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string id: description: |- Note: This is a Primary Key. format: uuid type: string justification: format: text type: string line_count: format: bigint type: integer maintenance_plan__asset_category_codes: format: text[] items: type: string type: array maintenance_plan__asset_category_count: format: bigint type: integer maintenance_plan__asset_category_names: format: text type: string maintenance_plan__asset_count: format: bigint type: integer maintenance_plan__asset_names: format: text type: string maintenance_plan__assigned_team_name: format: character varying maxLength: 200 type: string maintenance_plan__assigned_to_user_name: format: character varying maxLength: 200 type: string maintenance_plan__auto_generate_work_order: format: boolean type: boolean maintenance_plan__created_at: format: timestamp with time zone type: string maintenance_plan__created_by_name: format: character varying maxLength: 200 type: string maintenance_plan__criticality: format: character varying maxLength: 40 type: string maintenance_plan__current_version_number: format: integer type: integer maintenance_plan__custom_fields: format: jsonb maintenance_plan__description: format: text type: string maintenance_plan__end_date: format: date type: string maintenance_plan__estimated_duration_minutes: format: integer type: integer maintenance_plan__frequency: format: text type: string maintenance_plan__inspection_template_code: format: character varying maxLength: 60 type: string maintenance_plan__inspection_template_name: format: character varying maxLength: 250 type: string maintenance_plan__instructions: format: text type: string maintenance_plan__is_active: format: boolean type: boolean maintenance_plan__last_generated_at: format: timestamp with time zone type: string maintenance_plan__lead_time_days: format: integer type: integer maintenance_plan__maintenance_type: format: character varying maxLength: 40 type: string maintenance_plan__maintenance_type_name: format: character varying maxLength: 150 type: string maintenance_plan__name: format: character varying maxLength: 250 type: string maintenance_plan__next_due_at: format: timestamp with time zone type: string maintenance_plan__place_count: format: bigint type: integer maintenance_plan__place_names: format: text type: string maintenance_plan__plan_number: format: character varying maxLength: 60 type: string maintenance_plan__preferred_vendor_name: format: character varying maxLength: 200 type: string maintenance_plan__preferred_worker_name: format: character varying maxLength: 200 type: string maintenance_plan__priority_code: format: character varying maxLength: 40 type: string maintenance_plan__priority_name: format: character varying maxLength: 150 type: string maintenance_plan__raises_inspection: format: boolean type: boolean maintenance_plan__reminder_days: format: integer type: integer maintenance_plan__requirement_count: format: bigint type: integer maintenance_plan__requires_permit: format: boolean type: boolean maintenance_plan__requires_shutdown: format: boolean type: boolean maintenance_plan__safety_instructions: format: text type: string maintenance_plan__scope_names: format: text[] items: type: string type: array maintenance_plan__site_code: format: character varying maxLength: 50 type: string maintenance_plan__sla_resolution_minutes: format: integer type: integer maintenance_plan__sla_response_minutes: format: integer type: integer maintenance_plan__status: format: character varying maxLength: 60 type: string maintenance_plan__status_category: format: character varying maxLength: 20 type: string maintenance_plan__status_label: format: text type: string maintenance_plan__task_count: format: bigint type: integer maintenance_plan__tolerance_days: format: integer type: integer maintenance_plan__trigger_combination: format: character varying maxLength: 10 type: string maintenance_plan__trigger_count: format: bigint type: integer maintenance_plan__updated_at: format: timestamp with time zone type: string maintenance_plan__updated_by_name: format: character varying maxLength: 200 type: string maintenance_plan__use_contract_visits: format: boolean type: boolean maintenance_plan__work_orders_generated: format: bigint type: integer maintenance_plan_id: description: >- Note: This is a Foreign Key to `maintenance_due.maintenance_plan_id`. format: uuid type: string maintenance_plan_name: format: character varying maxLength: 250 type: string maintenance_plan_number: format: character varying maxLength: 60 type: string origin: format: character varying maxLength: 30 type: string priority: format: character varying maxLength: 20 type: string purchase_order_count: format: bigint type: integer purchase_recommendation_id: description: >- Note: This is a Foreign Key to `purchase_recommendations.id`. format: uuid type: string reference_records: format: jsonb rejected_at: format: timestamp with time zone type: string rejection_reason: format: text type: string requested_by: format: character varying maxLength: 200 type: string requested_by__email: format: public.citext type: string requested_by__last_login_at: format: timestamp with time zone type: string requested_by__name: format: character varying maxLength: 200 type: string requested_by__phone: format: character varying maxLength: 40 type: string requested_by__sign_in_handle: format: text type: string requested_by__status: format: character varying maxLength: 30 type: string requested_by__username: format: public.citext type: string requested_by__worker_is_active: format: boolean type: boolean requested_by__worker_name: format: character varying maxLength: 200 type: string requested_by__worker_number: format: character varying maxLength: 60 type: string requested_by__worker_teams: format: jsonb requested_by__worker_type: format: character varying maxLength: 150 type: string requested_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string required_by: format: date type: string requisition_number: format: character varying maxLength: 60 type: string row_version: format: bigint type: integer site__asset_count: format: bigint type: integer site__business_unit_name: format: character varying maxLength: 200 type: string site__business_unit_parent_name: format: character varying maxLength: 200 type: string site__code: format: character varying maxLength: 50 type: string site__company_name: format: character varying maxLength: 200 type: string site__is_active: format: boolean type: boolean site__name: format: character varying maxLength: 200 type: string site__timezone: format: character varying maxLength: 100 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 site_name: format: character varying maxLength: 200 type: string status: format: character varying maxLength: 60 type: string status_category: format: character varying maxLength: 20 type: string status_label: format: text type: string submitted_at: format: timestamp with time zone type: string title: format: character varying maxLength: 250 type: string 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 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_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__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 work_order_number: format: character varying maxLength: 60 type: string type: object ````