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

# Inventory available with every field of the records each row points at: location, part, 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 /inventory_available_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:
  /inventory_available_expanded:
    get:
      tags:
        - inventory_available_expanded
      summary: >-
        Inventory available with every field of the records each row points at:
        location, part, 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.inventory_available_expanded.stock_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part_number
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part_category
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.unit_of_measure
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse_code
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.site_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.inventory_location_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.on_hand_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.reserved_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.available_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.on_order_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.in_transit_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.average_unit_cost
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.average_unit_cost_currency_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.minimum_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.reorder_point
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.maximum_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.safety_stock
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.at_or_below_reorder_point
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.criticality
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.tracking_mode
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.is_consumable
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.last_movement_at
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.last_counted_at
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.primary_image_file_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.custom_fields
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.row_version
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.created_at
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.created_by_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.created_by_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.created_source
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.updated_at
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.updated_by_id
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.updated_by_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__site_code
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__parent_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__location_type
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__level_hint
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__code
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__path
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__depth
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__latitude
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__longitude
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__is_active
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__allows_direct_filing
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__takes_filing
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__primary_location_head_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__alternate_location_heads
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__children
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__assets
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.location__assets_in_branch
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__part_number
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__description
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__part_category
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__unit_of_measure
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__criticality
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__tracking_mode
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__is_stocked
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__is_consumable
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__is_active
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__on_hand_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__reserved_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__available_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__on_order_quantity
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__reorder_point
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__at_or_below_reorder_point
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__lead_time_days
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__open_recommendations
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__shortages_12m
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__shortages_that_stopped_work
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__created_at
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__created_by_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__updated_at
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.part__updated_by_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__code
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__site_code
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__site_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__warehouse_type
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__keeper_name
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__allows_negative_stock
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__is_active
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__bins
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__parts_stocked
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__units_on_hand
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_expanded.warehouse__negative_rows
        - $ref: >-
            #/components/parameters/rowFilter.inventory_available_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/inventory_available_expanded'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/inventory_available_expanded'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/inventory_available_expanded'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/inventory_available_expanded'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.inventory_available_expanded.stock_id:
      in: query
      name: stock_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part_id:
      in: query
      name: part_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part_number:
      in: query
      name: part_number
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part_name:
      in: query
      name: part_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part_category:
      in: query
      name: part_category
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.unit_of_measure:
      in: query
      name: unit_of_measure
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse_id:
      in: query
      name: warehouse_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse_code:
      in: query
      name: warehouse_code
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse_name:
      in: query
      name: warehouse_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.site_id:
      in: query
      name: site_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.inventory_location_id:
      in: query
      name: inventory_location_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.on_hand_quantity:
      in: query
      name: on_hand_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.reserved_quantity:
      in: query
      name: reserved_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.available_quantity:
      in: query
      name: available_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.on_order_quantity:
      in: query
      name: on_order_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.in_transit_quantity:
      in: query
      name: in_transit_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.average_unit_cost:
      in: query
      name: average_unit_cost
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.average_unit_cost_currency_id:
      in: query
      name: average_unit_cost_currency_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.minimum_quantity:
      in: query
      name: minimum_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.reorder_point:
      in: query
      name: reorder_point
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.maximum_quantity:
      in: query
      name: maximum_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.safety_stock:
      in: query
      name: safety_stock
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.at_or_below_reorder_point:
      in: query
      name: at_or_below_reorder_point
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.criticality:
      in: query
      name: criticality
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.tracking_mode:
      in: query
      name: tracking_mode
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.is_consumable:
      in: query
      name: is_consumable
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.last_movement_at:
      in: query
      name: last_movement_at
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.last_counted_at:
      in: query
      name: last_counted_at
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.primary_image_file_id:
      in: query
      name: primary_image_file_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.custom_fields:
      in: query
      name: custom_fields
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.row_version:
      in: query
      name: row_version
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.created_at:
      in: query
      name: created_at
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.created_by_id:
      in: query
      name: created_by_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.created_by_name:
      in: query
      name: created_by_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.created_source:
      in: query
      name: created_source
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.updated_at:
      in: query
      name: updated_at
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.updated_by_id:
      in: query
      name: updated_by_id
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.updated_by_name:
      in: query
      name: updated_by_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__site_code:
      in: query
      name: location__site_code
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__parent_name:
      in: query
      name: location__parent_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__location_type:
      in: query
      name: location__location_type
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__level_hint:
      in: query
      name: location__level_hint
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__code:
      in: query
      name: location__code
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__name:
      in: query
      name: location__name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__path:
      in: query
      name: location__path
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__depth:
      in: query
      name: location__depth
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__latitude:
      in: query
      name: location__latitude
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__longitude:
      in: query
      name: location__longitude
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__is_active:
      in: query
      name: location__is_active
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__allows_direct_filing:
      in: query
      name: location__allows_direct_filing
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__takes_filing:
      in: query
      name: location__takes_filing
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__primary_location_head_name:
      in: query
      name: location__primary_location_head_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__alternate_location_heads:
      in: query
      name: location__alternate_location_heads
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__children:
      in: query
      name: location__children
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__assets:
      in: query
      name: location__assets
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.location__assets_in_branch:
      in: query
      name: location__assets_in_branch
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__part_number:
      in: query
      name: part__part_number
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__name:
      in: query
      name: part__name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__description:
      in: query
      name: part__description
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__part_category:
      in: query
      name: part__part_category
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__unit_of_measure:
      in: query
      name: part__unit_of_measure
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__criticality:
      in: query
      name: part__criticality
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__tracking_mode:
      in: query
      name: part__tracking_mode
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__is_stocked:
      in: query
      name: part__is_stocked
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__is_consumable:
      in: query
      name: part__is_consumable
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__is_active:
      in: query
      name: part__is_active
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__on_hand_quantity:
      in: query
      name: part__on_hand_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__reserved_quantity:
      in: query
      name: part__reserved_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__available_quantity:
      in: query
      name: part__available_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__on_order_quantity:
      in: query
      name: part__on_order_quantity
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__reorder_point:
      in: query
      name: part__reorder_point
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__at_or_below_reorder_point:
      in: query
      name: part__at_or_below_reorder_point
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__lead_time_days:
      in: query
      name: part__lead_time_days
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__open_recommendations:
      in: query
      name: part__open_recommendations
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__shortages_12m:
      in: query
      name: part__shortages_12m
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__shortages_that_stopped_work:
      in: query
      name: part__shortages_that_stopped_work
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__created_at:
      in: query
      name: part__created_at
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__created_by_name:
      in: query
      name: part__created_by_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__updated_at:
      in: query
      name: part__updated_at
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.part__updated_by_name:
      in: query
      name: part__updated_by_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__code:
      in: query
      name: warehouse__code
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__name:
      in: query
      name: warehouse__name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__site_code:
      in: query
      name: warehouse__site_code
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__site_name:
      in: query
      name: warehouse__site_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__warehouse_type:
      in: query
      name: warehouse__warehouse_type
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__keeper_name:
      in: query
      name: warehouse__keeper_name
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__allows_negative_stock:
      in: query
      name: warehouse__allows_negative_stock
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__is_active:
      in: query
      name: warehouse__is_active
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__bins:
      in: query
      name: warehouse__bins
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__parts_stocked:
      in: query
      name: warehouse__parts_stocked
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__units_on_hand:
      in: query
      name: warehouse__units_on_hand
      required: false
      schema:
        type: string
    rowFilter.inventory_available_expanded.warehouse__negative_rows:
      in: query
      name: warehouse__negative_rows
      required: false
      schema:
        type: string
    rowFilter.inventory_available_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:
    inventory_available_expanded:
      description: >-
        Inventory available with every field of the records each row points at:
        location, part, 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:
        at_or_below_reorder_point:
          format: boolean
          type: boolean
        available_quantity:
          format: numeric
          type: number
        average_unit_cost:
          format: numeric
          type: number
        average_unit_cost_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
        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
        criticality:
          format: character varying
          maxLength: 20
          type: string
        custom_fields:
          format: jsonb
        in_transit_quantity:
          format: numeric
          type: number
        inventory_location_id:
          description: >-
            Note:

            This is a Foreign Key to `bin_settings.id`.<fk table='bin_settings'
            column='id'/>
          format: uuid
          type: string
        is_consumable:
          format: boolean
          type: boolean
        last_counted_at:
          format: timestamp with time zone
          type: string
        last_movement_at:
          format: timestamp with time zone
          type: string
        location__allows_direct_filing:
          format: boolean
          type: boolean
        location__alternate_location_heads:
          format: jsonb
        location__assets:
          format: bigint
          type: integer
        location__assets_in_branch:
          format: bigint
          type: integer
        location__children:
          format: bigint
          type: integer
        location__code:
          format: character varying
          maxLength: 80
          type: string
        location__depth:
          format: smallint
          type: integer
        location__is_active:
          format: boolean
          type: boolean
        location__latitude:
          format: numeric
          type: number
        location__level_hint:
          format: smallint
          type: integer
        location__location_type:
          format: character varying
          maxLength: 150
          type: string
        location__longitude:
          format: numeric
          type: number
        location__name:
          format: character varying
          maxLength: 200
          type: string
        location__parent_name:
          format: character varying
          maxLength: 200
          type: string
        location__path:
          format: text
          type: string
        location__primary_location_head_name:
          format: character varying
          maxLength: 200
          type: string
        location__site_code:
          format: character varying
          maxLength: 50
          type: string
        location__takes_filing:
          format: boolean
          type: boolean
        maximum_quantity:
          format: numeric
          type: number
        minimum_quantity:
          format: numeric
          type: number
        on_hand_quantity:
          format: numeric
          type: number
        on_order_quantity:
          format: numeric
          type: number
        part__at_or_below_reorder_point:
          format: boolean
          type: boolean
        part__available_quantity:
          format: numeric
          type: number
        part__created_at:
          format: timestamp with time zone
          type: string
        part__created_by_name:
          format: character varying
          maxLength: 200
          type: string
        part__criticality:
          format: character varying
          maxLength: 20
          type: string
        part__description:
          format: text
          type: string
        part__is_active:
          format: boolean
          type: boolean
        part__is_consumable:
          format: boolean
          type: boolean
        part__is_stocked:
          format: boolean
          type: boolean
        part__lead_time_days:
          format: integer
          type: integer
        part__name:
          format: character varying
          maxLength: 250
          type: string
        part__on_hand_quantity:
          format: numeric
          type: number
        part__on_order_quantity:
          format: numeric
          type: number
        part__open_recommendations:
          format: bigint
          type: integer
        part__part_category:
          format: character varying
          maxLength: 60
          type: string
        part__part_number:
          format: character varying
          maxLength: 80
          type: string
        part__reorder_point:
          format: numeric
          type: number
        part__reserved_quantity:
          format: numeric
          type: number
        part__shortages_12m:
          format: bigint
          type: integer
        part__shortages_that_stopped_work:
          format: bigint
          type: integer
        part__tracking_mode:
          format: character varying
          maxLength: 20
          type: string
        part__unit_of_measure:
          format: character varying
          maxLength: 30
          type: string
        part__updated_at:
          format: timestamp with time zone
          type: string
        part__updated_by_name:
          format: character varying
          maxLength: 200
          type: string
        part_category:
          format: character varying
          maxLength: 60
          type: string
        part_id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        part_name:
          format: character varying
          maxLength: 250
          type: string
        part_number:
          format: character varying
          maxLength: 80
          type: string
        primary_image_file_id:
          format: uuid
          type: string
        reference_records:
          format: jsonb
        reorder_point:
          format: numeric
          type: number
        reserved_quantity:
          format: numeric
          type: number
        row_version:
          format: bigint
          type: integer
        safety_stock:
          format: numeric
          type: number
        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
        stock_id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        tracking_mode:
          format: character varying
          maxLength: 20
          type: string
        unit_of_measure:
          format: character varying
          maxLength: 30
          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
        warehouse__allows_negative_stock:
          format: boolean
          type: boolean
        warehouse__bins:
          format: bigint
          type: integer
        warehouse__code:
          format: character varying
          maxLength: 60
          type: string
        warehouse__is_active:
          format: boolean
          type: boolean
        warehouse__keeper_name:
          format: character varying
          maxLength: 200
          type: string
        warehouse__name:
          format: character varying
          maxLength: 200
          type: string
        warehouse__negative_rows:
          format: bigint
          type: integer
        warehouse__parts_stocked:
          format: bigint
          type: integer
        warehouse__site_code:
          format: character varying
          maxLength: 50
          type: string
        warehouse__site_name:
          format: character varying
          maxLength: 200
          type: string
        warehouse__units_on_hand:
          format: numeric
          type: number
        warehouse__warehouse_type:
          format: character varying
          maxLength: 30
          type: string
        warehouse_code:
          format: character varying
          maxLength: 60
          type: string
        warehouse_id:
          description: >-
            Note:

            This is a Foreign Key to `warehouse_settings.id`.<fk
            table='warehouse_settings' column='id'/>
          format: uuid
          type: string
        warehouse_name:
          format: character varying
          maxLength: 200
          type: string
      type: object

````