This page was automatically generated from tracezilla’s Swagger API documentation 2026-01-26

GET /inventory

Get inventory status of skus

Description

Returns inventory status

Parameters (query)

Name Required Description Values
id[in] optional Search for specific skus by id. Allowed expression(s): eq, in  
sku_code[ct] optional Search for a specific sku code. Allowed expression(s): ct, eq, in  
global_name[ct] optional Search for the global name. Allowed expression(s): ct  
category[eq] optional Search for SKUs by category. Allowed expression(s): eq raw_material, intermediate_good, finished_good
active[eq] optional Search for . Allowed expression(s): eq  
permission[eq] optional Search for SKUs with a permission. Allowed expression(s): eq, in sales, purchase, consumption, production
partner_relation[eq] optional Search for SKUs that has a a partner relation with the specified partner. Allowed expression(s): eq  
partner_has_sales_price[eq] optional Search for SKUs where the specified partner has a sales price. Allowed expression(s): eq  
has_prices[eq] optional Search for SKUs that has prices in a specified price list. Allowed expression(s): eq, in  
on_order[eq] optional Search for SKUs on a specific order. Allowed expression(s): eq  
tags[eq] optional Search for SKUs with a specific tag. Allowed expression(s): eq, in  
partner_location[eq] optional Search for lots by the partner location it is located at. Allowed expression(s): eq, in  
include optional Resources to include. The resources that can be included in this request, delimited by a comma: sku.  
cutoff_date optional The cutoff date. Will be todays date if not set.  

Responses

200

successful operation

Response content JSON schema 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

{
  "properties": {
    "type": "array",
    "items": {
      "properties": {
        "sku_id": {
          "format": "uuid",
          "example": "be3233c4-c0a2-4f47-a62a-303492c20ba6"
        },
        "sku_code": {
          "format": "string",
          "example": "A1000"
        },
        "traceable_quantity_available": {
          "description": "The disposable quantity available for outbound orders. \n     *                      The following is included in the quantity:\n     *                      - Traceable lot available at the cutoff date where the lot status is not draft\n     *                      The following have been taken out of this quantity\n     *                      - Outbound orders that does not yet have a selected lot regardless of pickup dare. \n     *                      - Outbound orders with a selected lot that has an availability date on the same date or before the cutoff date",
          "format": "int32",
          "example": 100
        },
        "traceable_quantity_on_hand": {
          "description": "The quantity physically on hand. \n     *                      The following is included in the quantity:\n     *                      - Inbound orders that have been marked as delivered with a stock movement date less than or equal to the cutoff date\n     *                      The following have been taken out of this quantity\n     *                      - Outbound orders that have been marked as dispatched with a stock movement date less than or equal to the cutoff date",
          "format": "int32",
          "example": 100
        },
        "none_traceable_quantity_available": {
          "description": "The disposable quantity available for outbound orders. \n     *                      The following is included in the quantity:\n     *                      - None-traceable items where the availability_date is less than or equal the cutoff data and then inbound order does not have a status of request_for_confirmation, request_for_quotation or quote\n     *                      The following have been taken out of this quantity\n     *                      - Outbound orders with a pickup date less than or equal to cutoff date regardless of order status. \n     *                      - Outbound orders with a pickup date after the cutoff date that are not draft",
          "format": "int32",
          "example": 100
        },
        "none_traceable_quantity_on_hand": {
          "description": "The quantity physically on hand. \n     *                      The following is included in the quantity:\n     *                      - Inbound orders that have been marked as delivered with a stock movement date less than or equal to the cutoff date\n     *                      The following have been taken out of this quantity\n     *                      - Outbound orders that have been marked as dispatched with a stock movement date less than or equal to the cutoff date",
          "format": "int32",
          "example": 100
        }
      },
      "type": "object"
    }
  },
  "type": "object"
}

406

not acceptable

500

internal server error