Skip to main content
GET
Part consumption with every field of the records each row points at: part, warehouse.

Headers

Range
string

Limiting and Pagination

Range-Unit
string
default:items

Limiting and Pagination

Prefer
enum<string>

Preference

Available options:
count=none

Query Parameters

id
string
part_id
string
part_number
string
part_name
string
warehouse_id
string
warehouse_code
string
warehouse_name
string
period_start
string
period_end
string
quantity_consumed
string
planned_quantity
string
unplanned_quantity
string
planned_share
string
issue_count
string
asset_count
string
consumption_cost
string
computed_at
string
part__part_number
string
part__name
string
part__description
string
part__part_category
string
part__unit_of_measure
string
part__criticality
string
part__tracking_mode
string
part__is_stocked
string
part__is_consumable
string
part__is_active
string
part__on_hand_quantity
string
part__reserved_quantity
string
part__available_quantity
string
part__on_order_quantity
string
part__reorder_point
string
part__at_or_below_reorder_point
string
part__lead_time_days
string
part__open_recommendations
string
part__shortages_12m
string
part__shortages_that_stopped_work
string
part__created_at
string
part__created_by_name
string
part__updated_at
string
part__updated_by_name
string
warehouse__code
string
warehouse__name
string
warehouse__site_code
string
warehouse__site_name
string
warehouse__warehouse_type
string
warehouse__keeper_name
string
warehouse__allows_negative_stock
string
warehouse__is_active
string
warehouse__bins
string
warehouse__parts_stocked
string
warehouse__units_on_hand
string
warehouse__negative_rows
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

asset_count
integer<integer>
computed_at
string<timestamp with time zone>
consumption_cost
number<numeric>
id
string<uuid>

Note: This is a Primary Key.

issue_count
integer<integer>
part__at_or_below_reorder_point
boolean<boolean>
part__available_quantity
number<numeric>
part__created_at
string<timestamp with time zone>
part__created_by_name
string<character varying>
Maximum string length: 200
part__criticality
string<character varying>
Maximum string length: 20
part__description
string<text>
part__is_active
boolean<boolean>
part__is_consumable
boolean<boolean>
part__is_stocked
boolean<boolean>
part__lead_time_days
integer<integer>
part__name
string<character varying>
Maximum string length: 250
part__on_hand_quantity
number<numeric>
part__on_order_quantity
number<numeric>
part__open_recommendations
integer<bigint>
part__part_category
string<character varying>
Maximum string length: 60
part__part_number
string<character varying>
Maximum string length: 80
part__reorder_point
number<numeric>
part__reserved_quantity
number<numeric>
part__shortages_12m
integer<bigint>
part__shortages_that_stopped_work
integer<bigint>
part__tracking_mode
string<character varying>
Maximum string length: 20
part__unit_of_measure
string<character varying>
Maximum string length: 30
part__updated_at
string<timestamp with time zone>
part__updated_by_name
string<character varying>
Maximum string length: 200
part_id
string<uuid>

Note: This is a Foreign Key to inventory_available.part_id.

part_name
string<character varying>
Maximum string length: 250
part_number
string<character varying>
Maximum string length: 80
period_end
string<date>
period_start
string<date>
planned_quantity
number<numeric>
planned_share
number<numeric>
quantity_consumed
number<numeric>
unplanned_quantity
number<numeric>
warehouse__allows_negative_stock
boolean<boolean>
warehouse__bins
integer<bigint>
warehouse__code
string<character varying>
Maximum string length: 60
warehouse__is_active
boolean<boolean>
warehouse__keeper_name
string<character varying>
Maximum string length: 200
warehouse__name
string<character varying>
Maximum string length: 200
warehouse__negative_rows
integer<bigint>
warehouse__parts_stocked
integer<bigint>
warehouse__site_code
string<character varying>
Maximum string length: 50
warehouse__site_name
string<character varying>
Maximum string length: 200
warehouse__units_on_hand
number<numeric>
warehouse__warehouse_type
string<character varying>
Maximum string length: 30
warehouse_code
string<character varying>
Maximum string length: 60
warehouse_id
string<uuid>

Note: This is a Foreign Key to warehouse_settings.id.

warehouse_name
string<character varying>
Maximum string length: 200