> ## 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 totals, receipt and invoice progress, and whether delivery is overdue.



## OpenAPI

````yaml /api-reference/openapi.json get /purchase_orders
openapi: 3.0.0
info:
  description: ''
  title: >-
    The only schema PostgREST exposes (ADR-014). 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: Routing
  - 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: Self verification
  - name: Setup
  - name: Tools on a job, and who has them out
  - name: Vendors and contracts
  - name: Work order execution
  - name: Workforce detail
externalDocs:
  description: PostgREST Documentation
  url: https://postgrest.org/en/v12/references/api.html
paths:
  /purchase_orders:
    get:
      tags:
        - Procurement
      summary: >-
        Purchase orders with totals, receipt and invoice progress, and whether
        delivery is overdue.
      parameters:
        - $ref: '#/components/parameters/rowFilter.purchase_orders.id'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders.purchase_order_number
        - $ref: '#/components/parameters/rowFilter.purchase_orders.title'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.description'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.status'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.status_label'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.status_category'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.vendor_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.vendor_number'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.vendor_name'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders.purchase_requisition_id
        - $ref: '#/components/parameters/rowFilter.purchase_orders.requisition_number'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.vendor_quote_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.contract_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.site_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.site_code'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.site_name'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.warehouse_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.warehouse_name'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.cost_center_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.currency_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.currency_code'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.order_date'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.promised_date'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.payment_terms_days'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.delivery_terms'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.ship_to_address'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.vendor_reference'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.subtotal_amount'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.tax_amount'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.shipping_amount'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.total_amount'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.receipt_status'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.invoice_status'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.issued_at'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.issued_by'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.acknowledged_at'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.closed_at'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.closed_reason'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.cancelled_at'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders.cancellation_reason
        - $ref: '#/components/parameters/rowFilter.purchase_orders.notes'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.created_by_user_id'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.created_by'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.line_count'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders.quantity_outstanding
        - $ref: '#/components/parameters/rowFilter.purchase_orders.receipt_count'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.invoice_count'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.delivery_overdue'
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders.awaiting_permission
        - $ref: >-
            #/components/parameters/rowFilter.purchase_orders.approvals_outstanding
        - $ref: '#/components/parameters/rowFilter.purchase_orders.custom_fields'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.row_version'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.created_at'
        - $ref: '#/components/parameters/rowFilter.purchase_orders.updated_at'
        - $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'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/purchase_orders'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/purchase_orders'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/purchase_orders'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.purchase_orders.id:
      in: query
      name: id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.purchase_order_number:
      in: query
      name: purchase_order_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.title:
      in: query
      name: title
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.description:
      in: query
      name: description
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.status:
      in: query
      name: status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.status_label:
      in: query
      name: status_label
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.status_category:
      in: query
      name: status_category
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.vendor_id:
      in: query
      name: vendor_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.vendor_number:
      in: query
      name: vendor_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.vendor_name:
      in: query
      name: vendor_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.purchase_requisition_id:
      in: query
      name: purchase_requisition_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.requisition_number:
      in: query
      name: requisition_number
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.vendor_quote_id:
      in: query
      name: vendor_quote_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.contract_id:
      in: query
      name: contract_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.site_id:
      in: query
      name: site_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.site_code:
      in: query
      name: site_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.site_name:
      in: query
      name: site_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.warehouse_id:
      in: query
      name: warehouse_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.warehouse_name:
      in: query
      name: warehouse_name
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.cost_center_id:
      in: query
      name: cost_center_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.currency_id:
      in: query
      name: currency_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.currency_code:
      in: query
      name: currency_code
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.order_date:
      in: query
      name: order_date
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.promised_date:
      in: query
      name: promised_date
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.payment_terms_days:
      in: query
      name: payment_terms_days
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.delivery_terms:
      in: query
      name: delivery_terms
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.ship_to_address:
      in: query
      name: ship_to_address
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.vendor_reference:
      in: query
      name: vendor_reference
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.subtotal_amount:
      in: query
      name: subtotal_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.tax_amount:
      in: query
      name: tax_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.shipping_amount:
      in: query
      name: shipping_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.total_amount:
      in: query
      name: total_amount
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.receipt_status:
      in: query
      name: receipt_status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.invoice_status:
      in: query
      name: invoice_status
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.issued_at:
      in: query
      name: issued_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.issued_by:
      in: query
      name: issued_by
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.acknowledged_at:
      in: query
      name: acknowledged_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.closed_at:
      in: query
      name: closed_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.closed_reason:
      in: query
      name: closed_reason
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.cancelled_at:
      in: query
      name: cancelled_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.cancellation_reason:
      in: query
      name: cancellation_reason
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.notes:
      in: query
      name: notes
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.created_by_user_id:
      in: query
      name: created_by_user_id
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.created_by:
      in: query
      name: created_by
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.line_count:
      in: query
      name: line_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.quantity_outstanding:
      in: query
      name: quantity_outstanding
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.receipt_count:
      in: query
      name: receipt_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.invoice_count:
      in: query
      name: invoice_count
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.delivery_overdue:
      in: query
      name: delivery_overdue
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.awaiting_permission:
      in: query
      name: awaiting_permission
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.approvals_outstanding:
      in: query
      name: approvals_outstanding
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.custom_fields:
      in: query
      name: custom_fields
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.row_version:
      in: query
      name: row_version
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.created_at:
      in: query
      name: created_at
      required: false
      schema:
        type: string
    rowFilter.purchase_orders.updated_at:
      in: query
      name: updated_at
      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:
      description: >-
        Purchase orders with totals, receipt and invoice progress, and whether
        delivery is overdue.
      properties:
        acknowledged_at:
          format: timestamp with time zone
          type: string
        approvals_outstanding:
          format: bigint
          type: integer
        awaiting_permission:
          format: character varying
          maxLength: 120
          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_id:
          description: >-
            Note:

            This is a Foreign Key to `contracts.id`.<fk table='contracts'
            column='id'/>
          format: uuid
          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
        created_at:
          format: timestamp with time zone
          type: string
        created_by:
          format: character varying
          maxLength: 200
          type: string
        created_by_user_id:
          description: >-
            Note:

            This is a Foreign Key to `my_profile.user_id`.<fk table='my_profile'
            column='user_id'/>
          format: uuid
          type: string
        currency_code:
          format: character varying
          maxLength: 3
          type: string
        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_requisitions.id`.<fk
            table='purchase_requisitions' column='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
        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_code:
          format: character varying
          maxLength: 50
          type: string
        site_id:
          description: >-
            Note:

            This is a Foreign Key to `site_settings.id`.<fk
            table='site_settings' column='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: character varying
          maxLength: 150
          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
        vendor_id:
          description: >-
            Note:

            This is a Foreign Key to `vendor_directory.vendor_id`.<fk
            table='vendor_directory' column='vendor_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_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
      type: object

````

## Related topics

- [Purchase orders](/commercial/purchase-orders.md)
- [Awaiting Delivery](/commercial/receiving.md)
- [Requests for quotation](/commercial/rfqs.md)
- [Purchase requests](/commercial/purchase-requests.md)
- [The work order lifecycle](/work/lifecycle.md)