> ## 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.

# Contracts with every field of the records each row points at: owner, site, vendor.

> 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 /contracts_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:
  /contracts_expanded:
    get:
      tags:
        - contracts_expanded
      summary: >-
        Contracts with every field of the records each row points at: owner,
        site, vendor.
      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.contracts_expanded.id'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.contract_number'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.name'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.contract_type'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.contract_type_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.contract_category
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.status'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.status_label'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.status_category'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor_id'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor_number'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor_name'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.site_id'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.site_code'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.site_name'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.start_date'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.end_date'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.signed_on'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.auto_renew'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.renewal_notice_days
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.contract_value'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.contract_value_currency_id
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.covers_parts'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.covers_labour'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.covers_travel'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.requires_authorized_vendor
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.scope'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.exclusions_summary
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.owner_name'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.external_reference
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.notes'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.is_live'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.has_expired'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.days_remaining'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.in_renewal_window
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.named_assets'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.covered_asset_categories
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.visits_included'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.visits_used'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.claims'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.custom_fields'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.row_version'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.created_at'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.created_by_id'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.created_by_name'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.created_source'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.updated_at'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.updated_by_id'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.updated_by_name'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.owner__email'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.owner__username'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.owner__sign_in_handle
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.owner__name'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.owner__phone'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.owner__status'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.owner__last_login_at
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.owner__worker_number
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.owner__worker_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.owner__worker_type
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.owner__worker_is_active
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.owner__worker_teams
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.site__code'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.site__name'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.site__timezone'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.site__is_active'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.site__company_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.site__business_unit_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.site__business_unit_parent_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.site__asset_count
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__vendor_number
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor__name'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__legal_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__vendor_type
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor__is_oem'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor__status'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__status_label
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__status_category
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor__email'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor__phone'
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor__website'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__payment_terms_days
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__onboarded_on
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__approved_on
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__performance_score
        - $ref: '#/components/parameters/rowFilter.contracts_expanded.vendor__usable'
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__categories
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__site_count
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__active_contracts
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__best_response_minutes
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__average_rating
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__rating_count
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__open_work_orders
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__warranty_work_orders
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__open_claims
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__is_assignable
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__compliance_expiring
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__warranty_authorisations
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__custom_fields
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__created_at
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__created_by_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__updated_at
        - $ref: >-
            #/components/parameters/rowFilter.contracts_expanded.vendor__updated_by_name
        - $ref: >-
            #/components/parameters/rowFilter.contracts_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/contracts_expanded'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/contracts_expanded'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/contracts_expanded'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/contracts_expanded'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.contracts_expanded.id:
      in: query
      name: id
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.contract_number:
      in: query
      name: contract_number
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.name:
      in: query
      name: name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.contract_type:
      in: query
      name: contract_type
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.contract_type_name:
      in: query
      name: contract_type_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.contract_category:
      in: query
      name: contract_category
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.status:
      in: query
      name: status
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.status_label:
      in: query
      name: status_label
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.status_category:
      in: query
      name: status_category
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor_id:
      in: query
      name: vendor_id
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor_number:
      in: query
      name: vendor_number
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor_name:
      in: query
      name: vendor_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site_id:
      in: query
      name: site_id
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site_code:
      in: query
      name: site_code
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site_name:
      in: query
      name: site_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.start_date:
      in: query
      name: start_date
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.end_date:
      in: query
      name: end_date
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.signed_on:
      in: query
      name: signed_on
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.auto_renew:
      in: query
      name: auto_renew
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.renewal_notice_days:
      in: query
      name: renewal_notice_days
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.contract_value:
      in: query
      name: contract_value
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.contract_value_currency_id:
      in: query
      name: contract_value_currency_id
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.covers_parts:
      in: query
      name: covers_parts
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.covers_labour:
      in: query
      name: covers_labour
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.covers_travel:
      in: query
      name: covers_travel
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.requires_authorized_vendor:
      in: query
      name: requires_authorized_vendor
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.scope:
      in: query
      name: scope
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.exclusions_summary:
      in: query
      name: exclusions_summary
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner_name:
      in: query
      name: owner_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.external_reference:
      in: query
      name: external_reference
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.notes:
      in: query
      name: notes
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.is_live:
      in: query
      name: is_live
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.has_expired:
      in: query
      name: has_expired
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.days_remaining:
      in: query
      name: days_remaining
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.in_renewal_window:
      in: query
      name: in_renewal_window
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.named_assets:
      in: query
      name: named_assets
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.covered_asset_categories:
      in: query
      name: covered_asset_categories
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.visits_included:
      in: query
      name: visits_included
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.visits_used:
      in: query
      name: visits_used
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.claims:
      in: query
      name: claims
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.custom_fields:
      in: query
      name: custom_fields
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.row_version:
      in: query
      name: row_version
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.created_at:
      in: query
      name: created_at
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.created_by_id:
      in: query
      name: created_by_id
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.created_by_name:
      in: query
      name: created_by_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.created_source:
      in: query
      name: created_source
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.updated_at:
      in: query
      name: updated_at
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.updated_by_id:
      in: query
      name: updated_by_id
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.updated_by_name:
      in: query
      name: updated_by_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__email:
      in: query
      name: owner__email
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__username:
      in: query
      name: owner__username
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__sign_in_handle:
      in: query
      name: owner__sign_in_handle
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__name:
      in: query
      name: owner__name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__phone:
      in: query
      name: owner__phone
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__status:
      in: query
      name: owner__status
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__last_login_at:
      in: query
      name: owner__last_login_at
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__worker_number:
      in: query
      name: owner__worker_number
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__worker_name:
      in: query
      name: owner__worker_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__worker_type:
      in: query
      name: owner__worker_type
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__worker_is_active:
      in: query
      name: owner__worker_is_active
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.owner__worker_teams:
      in: query
      name: owner__worker_teams
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__code:
      in: query
      name: site__code
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__name:
      in: query
      name: site__name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__timezone:
      in: query
      name: site__timezone
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__is_active:
      in: query
      name: site__is_active
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__company_name:
      in: query
      name: site__company_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__business_unit_name:
      in: query
      name: site__business_unit_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__business_unit_parent_name:
      in: query
      name: site__business_unit_parent_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.site__asset_count:
      in: query
      name: site__asset_count
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__vendor_number:
      in: query
      name: vendor__vendor_number
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__name:
      in: query
      name: vendor__name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__legal_name:
      in: query
      name: vendor__legal_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__vendor_type:
      in: query
      name: vendor__vendor_type
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__is_oem:
      in: query
      name: vendor__is_oem
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__status:
      in: query
      name: vendor__status
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__status_label:
      in: query
      name: vendor__status_label
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__status_category:
      in: query
      name: vendor__status_category
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__email:
      in: query
      name: vendor__email
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__phone:
      in: query
      name: vendor__phone
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__website:
      in: query
      name: vendor__website
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__payment_terms_days:
      in: query
      name: vendor__payment_terms_days
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__onboarded_on:
      in: query
      name: vendor__onboarded_on
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__approved_on:
      in: query
      name: vendor__approved_on
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__performance_score:
      in: query
      name: vendor__performance_score
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__usable:
      in: query
      name: vendor__usable
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__categories:
      in: query
      name: vendor__categories
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__site_count:
      in: query
      name: vendor__site_count
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__active_contracts:
      in: query
      name: vendor__active_contracts
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__best_response_minutes:
      in: query
      name: vendor__best_response_minutes
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__average_rating:
      in: query
      name: vendor__average_rating
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__rating_count:
      in: query
      name: vendor__rating_count
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__open_work_orders:
      in: query
      name: vendor__open_work_orders
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__warranty_work_orders:
      in: query
      name: vendor__warranty_work_orders
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__open_claims:
      in: query
      name: vendor__open_claims
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__is_assignable:
      in: query
      name: vendor__is_assignable
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__compliance_expiring:
      in: query
      name: vendor__compliance_expiring
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__warranty_authorisations:
      in: query
      name: vendor__warranty_authorisations
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__custom_fields:
      in: query
      name: vendor__custom_fields
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__created_at:
      in: query
      name: vendor__created_at
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__created_by_name:
      in: query
      name: vendor__created_by_name
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__updated_at:
      in: query
      name: vendor__updated_at
      required: false
      schema:
        type: string
    rowFilter.contracts_expanded.vendor__updated_by_name:
      in: query
      name: vendor__updated_by_name
      required: false
      schema:
        type: string
    rowFilter.contracts_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:
    contracts_expanded:
      description: >-
        Contracts with every field of the records each row points at: owner,
        site, vendor.


        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:
        auto_renew:
          format: boolean
          type: boolean
        claims:
          format: bigint
          type: integer
        contract_category:
          format: character varying
          maxLength: 30
          type: string
        contract_number:
          format: character varying
          maxLength: 60
          type: string
        contract_type:
          format: character varying
          maxLength: 40
          type: string
        contract_type_name:
          format: character varying
          maxLength: 150
          type: string
        contract_value:
          format: numeric
          type: number
        contract_value_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
        covered_asset_categories:
          format: bigint
          type: integer
        covers_labour:
          format: boolean
          type: boolean
        covers_parts:
          format: boolean
          type: boolean
        covers_travel:
          format: boolean
          type: boolean
        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
        custom_fields:
          format: jsonb
        days_remaining:
          format: integer
          type: integer
        end_date:
          format: date
          type: string
        exclusions_summary:
          format: text
          type: string
        external_reference:
          format: character varying
          maxLength: 120
          type: string
        has_expired:
          format: boolean
          type: boolean
        id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        in_renewal_window:
          format: boolean
          type: boolean
        is_live:
          format: boolean
          type: boolean
        name:
          format: character varying
          maxLength: 200
          type: string
        named_assets:
          format: bigint
          type: integer
        notes:
          format: text
          type: string
        owner__email:
          format: public.citext
          type: string
        owner__last_login_at:
          format: timestamp with time zone
          type: string
        owner__name:
          format: character varying
          maxLength: 200
          type: string
        owner__phone:
          format: character varying
          maxLength: 40
          type: string
        owner__sign_in_handle:
          format: text
          type: string
        owner__status:
          format: character varying
          maxLength: 30
          type: string
        owner__username:
          format: public.citext
          type: string
        owner__worker_is_active:
          format: boolean
          type: boolean
        owner__worker_name:
          format: character varying
          maxLength: 200
          type: string
        owner__worker_number:
          format: character varying
          maxLength: 60
          type: string
        owner__worker_teams:
          format: jsonb
        owner__worker_type:
          format: character varying
          maxLength: 150
          type: string
        owner_name:
          format: character varying
          maxLength: 200
          type: string
        reference_records:
          format: jsonb
        renewal_notice_days:
          format: integer
          type: integer
        requires_authorized_vendor:
          format: boolean
          type: boolean
        row_version:
          format: bigint
          type: integer
        scope:
          format: text
          type: string
        signed_on:
          format: date
          type: string
        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
        start_date:
          format: date
          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
        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
        visits_included:
          format: bigint
          type: integer
        visits_used:
          format: bigint
          type: integer
      type: object

````