> ## 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. # Stock handed to a person, a project, a department, a cost centre or an asset, with how much of each issue is still out. > Stock handed to a person, a project, a department, a cost centre or an asset, with how much of each issue is still out. `quantity_outstanding` is the issue less every return that names it and less whatever was used up, so it falls as stock comes back or is written off as consumed without anything having to close the row. Stock issued as used up is never outstanding. Issues against a work order, a booking or a purchase request are not here: each belongs to the record it was raised from. ## OpenAPI ````yaml /api-reference/openapi.json get /stock_issues 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: My work - name: Sites and locations - name: Assets - name: Asset lifecycle - name: Asset components - name: Work lifecycle - name: Work order execution - name: Work sequencing - name: Maintenance - name: Inspections - name: Checklists - name: Verification - name: Self verification - name: Inventory - name: Inventory detail - name: Parts demand - name: Procurement - name: Vendors and contracts - name: Contracts - name: Amendments - name: Vendor spend forecast - name: Workforce - name: Workforce detail - name: Capacity - name: Dispatch - name: Shutdown - name: Permits - name: Tools - name: Tools on jobs - name: Bookings - name: Calibration history - name: Reliability - name: Sensors and meters - name: Readers - name: Trackers - name: Real-time location - name: Feeds - name: Energy - name: IT assets - name: IT asset software - name: IT asset topology - name: Map - name: Floor plans - name: Labels - name: Lost and found - name: Visitors - name: Root cause analysis - name: Costing - name: Finance - name: Budgets - name: Capex plans - name: FF&E plans - name: Documents - name: Document control - name: Document folders - name: Document tree - name: Knowledge - name: Reports - name: Dashboards - name: Extracts - name: Data exports - name: Audit center - name: Audit feed - name: Activity - name: Conversations - name: Notifications - name: Date reminders - name: Channels - name: Search - name: Copilot - name: Import - name: Bulk jobs - name: File exchange - name: Filing exceptions - name: Files - name: Sync - name: Support - name: API keys - name: Webhooks - name: MCP connections - name: MCP sign-in - name: SCIM provisioning - name: Directory sync - name: Security streams - name: Single sign-on - name: Two-factor sign-in - name: Admin - name: Access - name: Lookups - name: Read models - name: Reference - name: Reference columns - name: Reference entry - name: List views - name: Mapping - name: Numbering - name: Branding - name: Custom fields - name: Form studio - name: Workflows - name: Workflow studio - name: Rules - name: Statuses and transitions - name: Currencies and locales - name: Today - 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: Setup - name: Features - name: Billing - name: Licence - name: Welcome - name: Tray - name: Tenant switch - name: Release - name: Telegram - name: Inbound mail - name: Platform externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /stock_issues: get: tags: - Inventory detail summary: >- Stock handed to a person, a project, a department, a cost centre or an asset, with how much of each issue is still out. description: >- Stock handed to a person, a project, a department, a cost centre or an asset, with how much of each issue is still out. `quantity_outstanding` is the issue less every return that names it and less whatever was used up, so it falls as stock comes back or is written off as consumed without anything having to close the row. Stock issued as used up is never outstanding. Issues against a work order, a booking or a purchase request are not here: each belongs to the record it was raised from. parameters: - $ref: '#/components/parameters/rowFilter.stock_issues.id' - $ref: '#/components/parameters/rowFilter.stock_issues.part_id' - $ref: '#/components/parameters/rowFilter.stock_issues.part_number' - $ref: '#/components/parameters/rowFilter.stock_issues.part_name' - $ref: '#/components/parameters/rowFilter.stock_issues.unit_of_measure' - $ref: '#/components/parameters/rowFilter.stock_issues.warehouse_id' - $ref: '#/components/parameters/rowFilter.stock_issues.warehouse_code' - $ref: '#/components/parameters/rowFilter.stock_issues.warehouse_name' - $ref: '#/components/parameters/rowFilter.stock_issues.site_id' - $ref: '#/components/parameters/rowFilter.stock_issues.issued_to_kind' - $ref: '#/components/parameters/rowFilter.stock_issues.issued_to_name' - $ref: '#/components/parameters/rowFilter.stock_issues.issued_to_code' - $ref: '#/components/parameters/rowFilter.stock_issues.issued_to_worker_id' - $ref: '#/components/parameters/rowFilter.stock_issues.project_id' - $ref: '#/components/parameters/rowFilter.stock_issues.department_id' - $ref: '#/components/parameters/rowFilter.stock_issues.cost_center_id' - $ref: '#/components/parameters/rowFilter.stock_issues.asset_id' - $ref: '#/components/parameters/rowFilter.stock_issues.quantity_issued' - $ref: '#/components/parameters/rowFilter.stock_issues.quantity_returned' - $ref: '#/components/parameters/rowFilter.stock_issues.quantity_used_up' - $ref: '#/components/parameters/rowFilter.stock_issues.used_up_at_issue' - $ref: '#/components/parameters/rowFilter.stock_issues.quantity_outstanding' - $ref: '#/components/parameters/rowFilter.stock_issues.unit_cost' - $ref: '#/components/parameters/rowFilter.stock_issues.unit_cost_currency_id' - $ref: '#/components/parameters/rowFilter.stock_issues.reason_code' - $ref: '#/components/parameters/rowFilter.stock_issues.notes' - $ref: '#/components/parameters/rowFilter.stock_issues.occurred_at' - $ref: '#/components/parameters/rowFilter.stock_issues.worker_id' - $ref: '#/components/parameters/rowFilter.stock_issues.issued_by_name' - $ref: '#/components/parameters/rowFilter.stock_issues.created_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/stock_issues' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/stock_issues' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/stock_issues' type: array text/csv: schema: items: $ref: '#/components/schemas/stock_issues' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.stock_issues.id: in: query name: id required: false schema: type: string rowFilter.stock_issues.part_id: in: query name: part_id required: false schema: type: string rowFilter.stock_issues.part_number: in: query name: part_number required: false schema: type: string rowFilter.stock_issues.part_name: in: query name: part_name required: false schema: type: string rowFilter.stock_issues.unit_of_measure: in: query name: unit_of_measure required: false schema: type: string rowFilter.stock_issues.warehouse_id: in: query name: warehouse_id required: false schema: type: string rowFilter.stock_issues.warehouse_code: in: query name: warehouse_code required: false schema: type: string rowFilter.stock_issues.warehouse_name: in: query name: warehouse_name required: false schema: type: string rowFilter.stock_issues.site_id: in: query name: site_id required: false schema: type: string rowFilter.stock_issues.issued_to_kind: in: query name: issued_to_kind required: false schema: type: string rowFilter.stock_issues.issued_to_name: in: query name: issued_to_name required: false schema: type: string rowFilter.stock_issues.issued_to_code: in: query name: issued_to_code required: false schema: type: string rowFilter.stock_issues.issued_to_worker_id: in: query name: issued_to_worker_id required: false schema: type: string rowFilter.stock_issues.project_id: in: query name: project_id required: false schema: type: string rowFilter.stock_issues.department_id: in: query name: department_id required: false schema: type: string rowFilter.stock_issues.cost_center_id: in: query name: cost_center_id required: false schema: type: string rowFilter.stock_issues.asset_id: in: query name: asset_id required: false schema: type: string rowFilter.stock_issues.quantity_issued: in: query name: quantity_issued required: false schema: type: string rowFilter.stock_issues.quantity_returned: in: query name: quantity_returned required: false schema: type: string rowFilter.stock_issues.quantity_used_up: in: query name: quantity_used_up required: false schema: type: string rowFilter.stock_issues.used_up_at_issue: in: query name: used_up_at_issue required: false schema: type: string rowFilter.stock_issues.quantity_outstanding: in: query name: quantity_outstanding required: false schema: type: string rowFilter.stock_issues.unit_cost: in: query name: unit_cost required: false schema: type: string rowFilter.stock_issues.unit_cost_currency_id: in: query name: unit_cost_currency_id required: false schema: type: string rowFilter.stock_issues.reason_code: in: query name: reason_code required: false schema: type: string rowFilter.stock_issues.notes: in: query name: notes required: false schema: type: string rowFilter.stock_issues.occurred_at: in: query name: occurred_at required: false schema: type: string rowFilter.stock_issues.worker_id: in: query name: worker_id required: false schema: type: string rowFilter.stock_issues.issued_by_name: in: query name: issued_by_name required: false schema: type: string rowFilter.stock_issues.created_at: in: query name: created_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: stock_issues: description: >- Stock handed to a person, a project, a department, a cost centre or an asset, with how much of each issue is still out. `quantity_outstanding` is the issue less every return that names it and less whatever was used up, so it falls as stock comes back or is written off as consumed without anything having to close the row. Stock issued as used up is never outstanding. Issues against a work order, a booking or a purchase request are not here: each belongs to the record it was raised from. properties: asset_id: description: >- Note: This is a Foreign Key to `asset_contracts.asset_id`. format: uuid type: string cost_center_id: description: >- Note: This is a Foreign Key to `cost_centre_settings.id`. format: uuid type: string created_at: format: timestamp with time zone type: string department_id: description: >- Note: This is a Foreign Key to `department_settings.id`. format: uuid type: string id: description: |- Note: This is a Primary Key. format: uuid type: string issued_by_name: format: character varying maxLength: 200 type: string issued_to_code: format: character varying type: string issued_to_kind: format: text type: string issued_to_name: format: character varying type: string issued_to_worker_id: description: >- Note: This is a Foreign Key to `assignable_workers.id`. format: uuid type: string notes: format: text type: string occurred_at: description: |- Note: This is a Primary Key. format: timestamp with time zone type: string part_id: description: >- Note: This is a Foreign Key to `inventory_available.part_id`. format: uuid type: string part_name: format: character varying maxLength: 250 type: string part_number: format: character varying maxLength: 80 type: string project_id: description: >- Note: This is a Foreign Key to `project_settings.id`. format: uuid type: string quantity_issued: format: numeric type: number quantity_outstanding: format: numeric type: number quantity_returned: format: numeric type: number quantity_used_up: format: numeric type: number reason_code: format: character varying maxLength: 60 type: string site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string unit_cost: format: numeric type: number unit_cost_currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string unit_of_measure: format: character varying maxLength: 30 type: string used_up_at_issue: format: boolean type: boolean warehouse_code: format: character varying maxLength: 60 type: string warehouse_id: description: >- Note: This is a Foreign Key to `warehouse_settings.id`. format: uuid type: string warehouse_name: format: character varying maxLength: 200 type: string worker_id: description: >- Note: This is a Foreign Key to `assignable_workers.id`. format: uuid type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.