> ## 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 orders with every field of the records each row points at: contract, cost centre, requisition, site, vendor, warehouse.

> 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_orders_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_orders_expanded:
    get:
      tags:
        - purchase_orders_expanded
      summary: >-
        Purchase orders with every field of the records each row points at:
        contract, cost centre, requisition, site, vendor, warehouse.
      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_orders_expanded.id'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.purchase_order_number
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.title'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.description
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.status'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.status_label
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.status_category
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.vendor_id'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor_number
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.purchase_requisition_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.requisition_number
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.work_order_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.work_order_number
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.work_order_title
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.asset_id'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.asset_number
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.asset_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor_quote_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract_id
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.site_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.site_code'
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.site_name'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_center_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_center_code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_center_name
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.budget_id'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.budget_code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.budget_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.budget_available
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.budget_committed
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.currency_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.currency_code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.order_date
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.promised_date
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.payment_terms_days
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.delivery_terms
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.ship_to_address
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor_reference
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.subtotal_amount
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.tax_amount
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.shipping_amount
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.total_amount
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.receipt_status
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.invoice_status
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.issued_at'
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.issued_by'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.acknowledged_at
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.closed_at'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.closed_reason
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cancelled_at
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cancellation_reason
        - $ref: '#/components/parameters/rowFilter.purchase_orders_expanded.notes'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.line_count
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.quantity_outstanding
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.receipt_count
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.invoice_count
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.delivery_overdue
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.awaiting_permission
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.approvals_outstanding
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.custom_fields
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.row_version
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.created_at
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.created_by_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.created_by_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.created_source
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.updated_at
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.updated_by_id
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.updated_by_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__contract_number
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__contract_type
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__contract_type_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__contract_category
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__status
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__status_label
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__status_category
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__vendor_number
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__vendor_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__site_code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__site_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__start_date
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__end_date
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__signed_on
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__auto_renew
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__renewal_notice_days
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__contract_value
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__covers_parts
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__covers_labour
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__covers_travel
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__requires_authorized_vendor
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__scope
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__exclusions_summary
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__owner_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__external_reference
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__notes
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__is_live
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__has_expired
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__days_remaining
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__in_renewal_window
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__named_assets
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__covered_asset_categories
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__visits_included
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__visits_used
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__claims
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__custom_fields
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__created_at
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__created_by_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__updated_at
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.contract__updated_by_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_centre__code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_centre__name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_centre__company_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_centre__is_active
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.cost_centre__departments
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__timezone
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__is_active
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__company_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__business_unit_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__business_unit_parent_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.site__asset_count
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__vendor_number
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__legal_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__vendor_type
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__is_oem
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__status
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__status_label
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__status_category
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__email
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__phone
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__website
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__payment_terms_days
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__onboarded_on
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__approved_on
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__performance_score
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__usable
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__categories
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__site_count
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__active_contracts
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__best_response_minutes
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__average_rating
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__rating_count
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__open_work_orders
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__warranty_work_orders
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__open_claims
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__is_assignable
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__compliance_expiring
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__warranty_authorisations
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__custom_fields
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__created_at
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__created_by_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__updated_at
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.vendor__updated_by_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__site_code
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__site_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__warehouse_type
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__keeper_name
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__allows_negative_stock
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__is_active
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__bins
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__parts_stocked
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__units_on_hand
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_expanded.warehouse__negative_rows
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders_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_orders_expanded'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/purchase_orders_expanded'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/purchase_orders_expanded'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/purchase_orders_expanded'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.purchase_orders_expanded.id:
      in: query
      name: id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.purchase_order_number:
      in: query
      name: purchase_order_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.title:
      in: query
      name: title
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.description:
      in: query
      name: description
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.status:
      in: query
      name: status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.status_label:
      in: query
      name: status_label
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.status_category:
      in: query
      name: status_category
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor_id:
      in: query
      name: vendor_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor_number:
      in: query
      name: vendor_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor_name:
      in: query
      name: vendor_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.purchase_requisition_id:
      in: query
      name: purchase_requisition_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.requisition_number:
      in: query
      name: requisition_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.work_order_id:
      in: query
      name: work_order_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.work_order_number:
      in: query
      name: work_order_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.work_order_title:
      in: query
      name: work_order_title
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.asset_id:
      in: query
      name: asset_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.asset_number:
      in: query
      name: asset_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.asset_name:
      in: query
      name: asset_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor_quote_id:
      in: query
      name: vendor_quote_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract_id:
      in: query
      name: contract_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site_id:
      in: query
      name: site_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site_code:
      in: query
      name: site_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site_name:
      in: query
      name: site_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse_id:
      in: query
      name: warehouse_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse_name:
      in: query
      name: warehouse_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_center_id:
      in: query
      name: cost_center_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_center_code:
      in: query
      name: cost_center_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_center_name:
      in: query
      name: cost_center_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.budget_id:
      in: query
      name: budget_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.budget_code:
      in: query
      name: budget_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.budget_name:
      in: query
      name: budget_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.budget_available:
      in: query
      name: budget_available
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.budget_committed:
      in: query
      name: budget_committed
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.currency_id:
      in: query
      name: currency_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.currency_code:
      in: query
      name: currency_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.order_date:
      in: query
      name: order_date
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.promised_date:
      in: query
      name: promised_date
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.payment_terms_days:
      in: query
      name: payment_terms_days
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.delivery_terms:
      in: query
      name: delivery_terms
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.ship_to_address:
      in: query
      name: ship_to_address
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor_reference:
      in: query
      name: vendor_reference
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.subtotal_amount:
      in: query
      name: subtotal_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.tax_amount:
      in: query
      name: tax_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.shipping_amount:
      in: query
      name: shipping_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.total_amount:
      in: query
      name: total_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.receipt_status:
      in: query
      name: receipt_status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.invoice_status:
      in: query
      name: invoice_status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.issued_at:
      in: query
      name: issued_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.issued_by:
      in: query
      name: issued_by
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.acknowledged_at:
      in: query
      name: acknowledged_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.closed_at:
      in: query
      name: closed_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.closed_reason:
      in: query
      name: closed_reason
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cancelled_at:
      in: query
      name: cancelled_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cancellation_reason:
      in: query
      name: cancellation_reason
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.notes:
      in: query
      name: notes
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.line_count:
      in: query
      name: line_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.quantity_outstanding:
      in: query
      name: quantity_outstanding
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.receipt_count:
      in: query
      name: receipt_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.invoice_count:
      in: query
      name: invoice_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.delivery_overdue:
      in: query
      name: delivery_overdue
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.awaiting_permission:
      in: query
      name: awaiting_permission
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.approvals_outstanding:
      in: query
      name: approvals_outstanding
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.custom_fields:
      in: query
      name: custom_fields
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.row_version:
      in: query
      name: row_version
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.created_at:
      in: query
      name: created_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.created_by_id:
      in: query
      name: created_by_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.created_by_name:
      in: query
      name: created_by_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.created_source:
      in: query
      name: created_source
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.updated_at:
      in: query
      name: updated_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.updated_by_id:
      in: query
      name: updated_by_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.updated_by_name:
      in: query
      name: updated_by_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__contract_number:
      in: query
      name: contract__contract_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__name:
      in: query
      name: contract__name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__contract_type:
      in: query
      name: contract__contract_type
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__contract_type_name:
      in: query
      name: contract__contract_type_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__contract_category:
      in: query
      name: contract__contract_category
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__status:
      in: query
      name: contract__status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__status_label:
      in: query
      name: contract__status_label
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__status_category:
      in: query
      name: contract__status_category
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__vendor_number:
      in: query
      name: contract__vendor_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__vendor_name:
      in: query
      name: contract__vendor_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__site_code:
      in: query
      name: contract__site_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__site_name:
      in: query
      name: contract__site_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__start_date:
      in: query
      name: contract__start_date
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__end_date:
      in: query
      name: contract__end_date
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__signed_on:
      in: query
      name: contract__signed_on
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__auto_renew:
      in: query
      name: contract__auto_renew
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__renewal_notice_days:
      in: query
      name: contract__renewal_notice_days
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__contract_value:
      in: query
      name: contract__contract_value
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__covers_parts:
      in: query
      name: contract__covers_parts
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__covers_labour:
      in: query
      name: contract__covers_labour
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__covers_travel:
      in: query
      name: contract__covers_travel
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__requires_authorized_vendor:
      in: query
      name: contract__requires_authorized_vendor
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__scope:
      in: query
      name: contract__scope
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__exclusions_summary:
      in: query
      name: contract__exclusions_summary
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__owner_name:
      in: query
      name: contract__owner_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__external_reference:
      in: query
      name: contract__external_reference
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__notes:
      in: query
      name: contract__notes
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__is_live:
      in: query
      name: contract__is_live
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__has_expired:
      in: query
      name: contract__has_expired
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__days_remaining:
      in: query
      name: contract__days_remaining
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__in_renewal_window:
      in: query
      name: contract__in_renewal_window
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__named_assets:
      in: query
      name: contract__named_assets
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__covered_asset_categories:
      in: query
      name: contract__covered_asset_categories
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__visits_included:
      in: query
      name: contract__visits_included
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__visits_used:
      in: query
      name: contract__visits_used
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__claims:
      in: query
      name: contract__claims
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__custom_fields:
      in: query
      name: contract__custom_fields
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__created_at:
      in: query
      name: contract__created_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__created_by_name:
      in: query
      name: contract__created_by_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__updated_at:
      in: query
      name: contract__updated_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.contract__updated_by_name:
      in: query
      name: contract__updated_by_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_centre__code:
      in: query
      name: cost_centre__code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_centre__name:
      in: query
      name: cost_centre__name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_centre__company_name:
      in: query
      name: cost_centre__company_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_centre__is_active:
      in: query
      name: cost_centre__is_active
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.cost_centre__departments:
      in: query
      name: cost_centre__departments
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__code:
      in: query
      name: site__code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__name:
      in: query
      name: site__name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__timezone:
      in: query
      name: site__timezone
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__is_active:
      in: query
      name: site__is_active
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__company_name:
      in: query
      name: site__company_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__business_unit_name:
      in: query
      name: site__business_unit_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__business_unit_parent_name:
      in: query
      name: site__business_unit_parent_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.site__asset_count:
      in: query
      name: site__asset_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__vendor_number:
      in: query
      name: vendor__vendor_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__name:
      in: query
      name: vendor__name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__legal_name:
      in: query
      name: vendor__legal_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__vendor_type:
      in: query
      name: vendor__vendor_type
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__is_oem:
      in: query
      name: vendor__is_oem
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__status:
      in: query
      name: vendor__status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__status_label:
      in: query
      name: vendor__status_label
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__status_category:
      in: query
      name: vendor__status_category
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__email:
      in: query
      name: vendor__email
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__phone:
      in: query
      name: vendor__phone
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__website:
      in: query
      name: vendor__website
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__payment_terms_days:
      in: query
      name: vendor__payment_terms_days
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__onboarded_on:
      in: query
      name: vendor__onboarded_on
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__approved_on:
      in: query
      name: vendor__approved_on
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__performance_score:
      in: query
      name: vendor__performance_score
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__usable:
      in: query
      name: vendor__usable
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__categories:
      in: query
      name: vendor__categories
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__site_count:
      in: query
      name: vendor__site_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__active_contracts:
      in: query
      name: vendor__active_contracts
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__best_response_minutes:
      in: query
      name: vendor__best_response_minutes
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__average_rating:
      in: query
      name: vendor__average_rating
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__rating_count:
      in: query
      name: vendor__rating_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__open_work_orders:
      in: query
      name: vendor__open_work_orders
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__warranty_work_orders:
      in: query
      name: vendor__warranty_work_orders
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__open_claims:
      in: query
      name: vendor__open_claims
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__is_assignable:
      in: query
      name: vendor__is_assignable
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__compliance_expiring:
      in: query
      name: vendor__compliance_expiring
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__warranty_authorisations:
      in: query
      name: vendor__warranty_authorisations
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__custom_fields:
      in: query
      name: vendor__custom_fields
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__created_at:
      in: query
      name: vendor__created_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__created_by_name:
      in: query
      name: vendor__created_by_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__updated_at:
      in: query
      name: vendor__updated_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.vendor__updated_by_name:
      in: query
      name: vendor__updated_by_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__code:
      in: query
      name: warehouse__code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__name:
      in: query
      name: warehouse__name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__site_code:
      in: query
      name: warehouse__site_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__site_name:
      in: query
      name: warehouse__site_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__warehouse_type:
      in: query
      name: warehouse__warehouse_type
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__keeper_name:
      in: query
      name: warehouse__keeper_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__allows_negative_stock:
      in: query
      name: warehouse__allows_negative_stock
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__is_active:
      in: query
      name: warehouse__is_active
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__bins:
      in: query
      name: warehouse__bins
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__parts_stocked:
      in: query
      name: warehouse__parts_stocked
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__units_on_hand:
      in: query
      name: warehouse__units_on_hand
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_expanded.warehouse__negative_rows:
      in: query
      name: warehouse__negative_rows
      required: false
      schema:
        type: string
    rowFilter.purchase_orders_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_orders_expanded:
      description: >-
        Purchase orders with every field of the records each row points at:
        contract, cost centre, requisition, site, vendor, warehouse.


        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:
        acknowledged_at:
          format: timestamp with time zone
          type: string
        approvals_outstanding:
          format: bigint
          type: integer
        asset_id:
          description: >-
            Note:

            This is a Foreign Key to `asset_contracts.asset_id`.<fk
            table='asset_contracts' column='asset_id'/>
          format: uuid
          type: string
        asset_name:
          format: character varying
          maxLength: 250
          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_committed:
          format: numeric
          type: number
        budget_id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          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
        closed_at:
          format: timestamp with time zone
          type: string
        closed_reason:
          format: text
          type: string
        contract__auto_renew:
          format: boolean
          type: boolean
        contract__claims:
          format: bigint
          type: integer
        contract__contract_category:
          format: character varying
          maxLength: 30
          type: string
        contract__contract_number:
          format: character varying
          maxLength: 60
          type: string
        contract__contract_type:
          format: character varying
          maxLength: 40
          type: string
        contract__contract_type_name:
          format: character varying
          maxLength: 150
          type: string
        contract__contract_value:
          format: numeric
          type: number
        contract__covered_asset_categories:
          format: bigint
          type: integer
        contract__covers_labour:
          format: boolean
          type: boolean
        contract__covers_parts:
          format: boolean
          type: boolean
        contract__covers_travel:
          format: boolean
          type: boolean
        contract__created_at:
          format: timestamp with time zone
          type: string
        contract__created_by_name:
          format: character varying
          maxLength: 200
          type: string
        contract__custom_fields:
          format: jsonb
        contract__days_remaining:
          format: integer
          type: integer
        contract__end_date:
          format: date
          type: string
        contract__exclusions_summary:
          format: text
          type: string
        contract__external_reference:
          format: character varying
          maxLength: 120
          type: string
        contract__has_expired:
          format: boolean
          type: boolean
        contract__in_renewal_window:
          format: boolean
          type: boolean
        contract__is_live:
          format: boolean
          type: boolean
        contract__name:
          format: character varying
          maxLength: 200
          type: string
        contract__named_assets:
          format: bigint
          type: integer
        contract__notes:
          format: text
          type: string
        contract__owner_name:
          format: character varying
          maxLength: 200
          type: string
        contract__renewal_notice_days:
          format: integer
          type: integer
        contract__requires_authorized_vendor:
          format: boolean
          type: boolean
        contract__scope:
          format: text
          type: string
        contract__signed_on:
          format: date
          type: string
        contract__site_code:
          format: character varying
          maxLength: 50
          type: string
        contract__site_name:
          format: character varying
          maxLength: 200
          type: string
        contract__start_date:
          format: date
          type: string
        contract__status:
          format: character varying
          maxLength: 60
          type: string
        contract__status_category:
          format: character varying
          maxLength: 20
          type: string
        contract__status_label:
          format: text
          type: string
        contract__updated_at:
          format: timestamp with time zone
          type: string
        contract__updated_by_name:
          format: character varying
          maxLength: 200
          type: string
        contract__vendor_name:
          format: character varying
          maxLength: 200
          type: string
        contract__vendor_number:
          format: character varying
          maxLength: 60
          type: string
        contract__visits_included:
          format: bigint
          type: integer
        contract__visits_used:
          format: bigint
          type: integer
        contract_id:
          description: >-
            Note:

            This is a Foreign Key to `contract_cover.contract_id`.<fk
            table='contract_cover' column='contract_id'/>
          format: uuid
          type: string
        cost_center_code:
          format: character varying
          maxLength: 50
          type: string
        cost_center_id:
          description: >-
            Note:

            This is a Foreign Key to `cost_centre_settings.id`.<fk
            table='cost_centre_settings' column='id'/>
          format: uuid
          type: string
        cost_center_name:
          format: character varying
          maxLength: 200
          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`.<fk
            table='capex_invite_candidates' column='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
        currency_id:
          description: >-
            Note:

            This is a Foreign Key to `asset_cost_to_keep.currency_id`.<fk
            table='asset_cost_to_keep' column='currency_id'/>
          format: uuid
          type: string
        custom_fields:
          format: jsonb
        delivery_overdue:
          format: boolean
          type: boolean
        delivery_terms:
          format: character varying
          maxLength: 120
          type: string
        description:
          format: text
          type: string
        id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        invoice_count:
          format: bigint
          type: integer
        invoice_status:
          format: character varying
          maxLength: 20
          type: string
        issued_at:
          format: timestamp with time zone
          type: string
        issued_by:
          format: character varying
          maxLength: 200
          type: string
        line_count:
          format: bigint
          type: integer
        notes:
          format: text
          type: string
        order_date:
          format: date
          type: string
        payment_terms_days:
          format: integer
          type: integer
        promised_date:
          format: date
          type: string
        purchase_order_number:
          format: character varying
          maxLength: 60
          type: string
        purchase_requisition_id:
          description: >-
            Note:

            This is a Foreign Key to
            `purchase_recommendations.purchase_requisition_id`.<fk
            table='purchase_recommendations' column='purchase_requisition_id'/>
          format: uuid
          type: string
        quantity_outstanding:
          format: numeric
          type: number
        receipt_count:
          format: bigint
          type: integer
        receipt_status:
          format: character varying
          maxLength: 20
          type: string
        reference_records:
          format: jsonb
        requisition_number:
          format: character varying
          maxLength: 60
          type: string
        row_version:
          format: bigint
          type: integer
        ship_to_address:
          format: text
          type: string
        shipping_amount:
          format: numeric
          type: number
        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`.<fk
            table='entry_currencies' column='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
        subtotal_amount:
          format: numeric
          type: number
        tax_amount:
          format: numeric
          type: number
        title:
          format: character varying
          maxLength: 250
          type: string
        total_amount:
          format: numeric
          type: number
        updated_at:
          format: timestamp with time zone
          type: string
        updated_by_id:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        updated_by_name:
          format: character varying
          maxLength: 200
          type: string
        vendor__active_contracts:
          format: bigint
          type: integer
        vendor__approved_on:
          format: date
          type: string
        vendor__average_rating:
          format: numeric
          type: number
        vendor__best_response_minutes:
          format: integer
          type: integer
        vendor__categories:
          format: jsonb
        vendor__compliance_expiring:
          format: bigint
          type: integer
        vendor__created_at:
          format: timestamp with time zone
          type: string
        vendor__created_by_name:
          format: character varying
          maxLength: 200
          type: string
        vendor__custom_fields:
          format: jsonb
        vendor__email:
          format: public.citext
          type: string
        vendor__is_assignable:
          format: boolean
          type: boolean
        vendor__is_oem:
          format: boolean
          type: boolean
        vendor__legal_name:
          format: character varying
          maxLength: 250
          type: string
        vendor__name:
          format: character varying
          maxLength: 200
          type: string
        vendor__onboarded_on:
          format: date
          type: string
        vendor__open_claims:
          format: bigint
          type: integer
        vendor__open_work_orders:
          format: bigint
          type: integer
        vendor__payment_terms_days:
          format: integer
          type: integer
        vendor__performance_score:
          format: numeric
          type: number
        vendor__phone:
          format: character varying
          maxLength: 40
          type: string
        vendor__rating_count:
          format: bigint
          type: integer
        vendor__site_count:
          format: bigint
          type: integer
        vendor__status:
          format: character varying
          maxLength: 60
          type: string
        vendor__status_category:
          format: character varying
          maxLength: 20
          type: string
        vendor__status_label:
          format: text
          type: string
        vendor__updated_at:
          format: timestamp with time zone
          type: string
        vendor__updated_by_name:
          format: character varying
          maxLength: 200
          type: string
        vendor__usable:
          format: boolean
          type: boolean
        vendor__vendor_number:
          format: character varying
          maxLength: 60
          type: string
        vendor__vendor_type:
          format: character varying
          maxLength: 40
          type: string
        vendor__warranty_authorisations:
          format: bigint
          type: integer
        vendor__warranty_work_orders:
          format: bigint
          type: integer
        vendor__website:
          format: character varying
          maxLength: 250
          type: string
        vendor_id:
          description: >-
            Note:

            This is a Foreign Key to `assignable_vendors.id`.<fk
            table='assignable_vendors' column='id'/>
          format: uuid
          type: string
        vendor_name:
          format: character varying
          maxLength: 200
          type: string
        vendor_number:
          format: character varying
          maxLength: 60
          type: string
        vendor_quote_id:
          description: >-
            Note:

            This is a Foreign Key to `rfq_quote_comparison.vendor_quote_id`.<fk
            table='rfq_quote_comparison' column='vendor_quote_id'/>
          format: uuid
          type: string
        vendor_reference:
          format: character varying
          maxLength: 120
          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`.<fk
            table='warehouse_settings' column='id'/>
          format: uuid
          type: string
        warehouse_name:
          format: character varying
          maxLength: 200
          type: string
        work_order_id:
          description: >-
            Note:

            This is a Foreign Key to
            `asset_maintenance_plans.next_work_order_id`.<fk
            table='asset_maintenance_plans' column='next_work_order_id'/>
          format: uuid
          type: string
        work_order_number:
          format: character varying
          maxLength: 60
          type: string
        work_order_title:
          format: character varying
          maxLength: 250
          type: string
      type: object

````