Приклад: приймання поставки поверх API

ERP, з якої всі даніЩо всередині?

Ви - комірник. Приймаєте поставку на склад компанії: ТОВ «Крило і Гвинт».

Яка поставка приїхала

ЗП-2026-00112 · Far East Rotor Parts Co., Ltd8093 штчекали 08.10.2026

що всередині?

Що всередині?

Що відбувається всередині

3 виклики API, запитів до бази: 2, 1316 мс

З чого складається цей екран

  1. Хто ви і чий це складGET /api/v1/q/company_profile?as_of=Назва компанії з її власної картки.
  2. Замовлення, які ще їдутьGET /api/v1/q/purchase_ordersРозміщені замовлення постачальникам; комірник бачить кількості, сум не бачить.
  3. Рядки поставкиGET /api/v1/q/po_lines?id=Що замовлено і скільки ще не прийшло за кожним рядком.
  4. Куди покластиGET /api/v1/q/locationsСклади компанії; дія приймає код місця, не id.
  5. Запас до і післяGET /api/v1/q/stock_on_handЗалишок позиції на всіх місцях. Після проби «після» пораховано; після запису прочитано ще раз.
  6. Кнопка «Перевірити»POST /api/v1/act/zakupka/receiveПробний запуск кожного рядка: "dry_run": true. Дія приймає один рядок, тому рядків - стільки й викликів.
  7. Кнопка «Прийняти»POST /api/v1/act/zakupka/receiveСпершу проба всіх рядків; коли жоден не відмовлено - справжній запис, рядок за рядком, кожен зі своїм Idempotency-Key.

Виклики API цієї сторінки

Назви запитів і таблиць дає сам API. Перевірку ключа і запис у журнал викликів тут не пораховано.

Відкриття сторінки: 2 виклики разом за 527 мс; по черзі це 971 мс.

  1. 1опис queries345 мс200

    GET /api/v1/queries

    Іменовані запити, які читає цей ключ, з таблицями кожного

    Опис, який API дає про себе. Тримається в памʼяті десять хвилин.

    показати запит і відповідь
    GET /api/v1/queries
    {
      "headers": {
        "authorization": "Bearer <ключ>"
      }
    }
    {
      "queries": [
        {
          "name": "accounts",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "account"
          ]
        },
        {
          "name": "periods",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "journal_entry",
            "period"
          ]
        },
        {
          "name": "parties_by_role",
          "params": [
            "role"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "party_identifier",
            "party",
            "party_role"
          ],
          "only": {
            "role": [
              "customer",
              "supplier"
            ]
          }
        },
        {
          "name": "documents_open",
          "params": [
            "kind",
            "account"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "accountant"
          ],
          "tables": [
            "journal_entry",
            "document",
            "economic_event",
            "party",
            "open_item"
          ],
          "only": {
            "kind": [
              "shipment"
            ]
          }
        },
        {
          "name": "events_by_kind",
          "params": [
            "kind"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "journal_line",
            "document",
            "event_number",
            "journal_entry",
            "economic_event",
            "party",
            "rule_snapshot"
          ],
          "only": {
            "kind": [
              "stock_received",
              "stock_moved",
              "produced"
            ]
          }
        },
        {
          "name": "items",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "item"
          ]
        },
        {
          "name": "stock_on_hand",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "stock_balance",
            "item",
            "location"
          ]
        },
        {
          "name": "locations",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item",
            "ledger_line",
            "location"
          ]
        },
        {
          "name": "sites",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "site",
            "location"
          ]
        },
        {
          "name": "warehouses",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "location"
          ]
        },
        {
          "name": "catalog",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "supplier_price",
            "item_mpn",
            "item"
          ]
        },
        {
          "name": "glossary",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "glossary_term"
          ]
        },
        {
          "name": "item_mpns",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item_mpn"
          ]
        },
        {
          "name": "item_analogs",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item_analog",
            "item"
          ]
        },
        {
          "name": "analog_of",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item_analog",
            "item"
          ]
        },
        {
          "name": "analog_groups",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item_analog",
            "item"
          ]
        },
        {
          "name": "supplier_prices",
          "params": [
            "item_id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "supplier_price",
            "party",
            "item_mpn"
          ]
        },
        {
          "name": "find_code",
          "params": [
            "norm"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item",
            "item_mpn",
            "supplier_price",
            "party"
          ]
        },
        {
          "name": "boms",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_line",
            "bom",
            "item"
          ]
        },
        {
          "name": "boms_of_item",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_line",
            "bom",
            "change_order"
          ]
        },
        {
          "name": "bom",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "change_order",
            "bom",
            "item"
          ]
        },
        {
          "name": "bom_lines",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_substitute",
            "item",
            "bom_line"
          ]
        },
        {
          "name": "bom_subsystems",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_line_subsystem",
            "bom_subsystem"
          ]
        },
        {
          "name": "bom_structure",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "bom_line",
            "item",
            "bom_line_subsystem",
            "bom_subsystem"
          ]
        },
        {
          "name": "bom_products",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_line",
            "bom_subsystem",
            "bom_operation",
            "bom_operation_card",
            "bom",
            "item"
          ]
        },
        {
          "name": "bom_pending_analogs",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "bom_line",
            "item_analog",
            "item",
            "bom_substitute"
          ]
        },
        {
          "name": "where_used",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_line",
            "bom",
            "bom_substitute",
            "item"
          ]
        },
        {
          "name": "change_orders",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "item",
            "change_order"
          ]
        },
        {
          "name": "change_order",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "item",
            "change_order"
          ]
        },
        {
          "name": "bom_previous",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom"
          ]
        },
        {
          "name": "bom_versions",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom"
          ]
        },
        {
          "name": "active_boms",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "item"
          ]
        },
        {
          "name": "draft_boms",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "item"
          ]
        },
        {
          "name": "purchase_requests",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "po_line",
            "purchase_order",
            "po_line_received",
            "purchase_request",
            "purchase_request_line"
          ]
        },
        {
          "name": "purchase_request_lines",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "po_line",
            "purchase_order",
            "purchase_request_line",
            "item"
          ]
        },
        {
          "name": "purchase_request",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "purchase_request"
          ]
        },
        {
          "name": "purchase_orders",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "po_line",
            "po_line_received",
            "purchase_order",
            "party"
          ]
        },
        {
          "name": "purchase_order",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "purchase_order",
            "party"
          ]
        },
        {
          "name": "po_lines",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "po_line",
            "item",
            "po_line_received"
          ]
        },
        {
          "name": "receipts_for_order",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "event_number",
            "journal_entry",
            "economic_event"
          ]
        },
        {
          "name": "work_centers",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "work_center"
          ]
        },
        {
          "name": "bom_operations",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "bom_operation",
            "work_center"
          ]
        },
        {
          "name": "bom_route",
          "params": [
            "bom_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_operation_instrument",
            "equipment",
            "qc_point",
            "qc_checklist",
            "bom_operation",
            "bom",
            "work_center",
            "bom_operation_card"
          ]
        },
        {
          "name": "instrument_workplaces",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "equipment_card",
            "work_center",
            "work_center_card"
          ]
        },
        {
          "name": "instrument_workplace",
          "params": [
            "work_center_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "work_center",
            "work_center_card"
          ]
        },
        {
          "name": "route_operations",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "bom_operation",
            "bom",
            "item",
            "work_center"
          ]
        },
        {
          "name": "instrument_workplace_operations",
          "params": [
            "work_center_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "bom_operation",
            "bom",
            "item",
            "bom_operation_card"
          ]
        },
        {
          "name": "instrument_workplace_people",
          "params": [
            "work_center_id",
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_register",
          "params": [
            "as_of",
            "work_center_id",
            "kind",
            "state",
            "holder_id"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_equipment",
          "params": [
            "ref",
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_counts",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "equipment"
          ]
        },
        {
          "name": "instrument_available",
          "params": [
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_custody",
          "params": [
            "equipment_id"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_custody",
            "equipment",
            "party",
            "work_center"
          ]
        },
        {
          "name": "instrument_held_by",
          "params": [
            "party_id",
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_person_history",
          "params": [
            "party_id"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_custody",
            "equipment_card"
          ]
        },
        {
          "name": "instrument_employees",
          "params": [
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "party",
            "agreement",
            "party_role"
          ]
        },
        {
          "name": "instrument_person",
          "params": [
            "party_id",
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "agreement",
            "party_role",
            "equipment_custody",
            "party"
          ]
        },
        {
          "name": "instrument_people",
          "params": [
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card",
            "agreement",
            "party",
            "party_role"
          ]
        },
        {
          "name": "instrument_verifications",
          "params": [
            "equipment_id"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_verification",
            "equipment"
          ]
        },
        {
          "name": "instrument_schedule",
          "params": [
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_due",
          "params": [
            "as_of",
            "days"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_overdue",
          "params": [
            "as_of"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_card"
          ]
        },
        {
          "name": "instrument_maintenance",
          "params": [
            "equipment_id"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "equipment_maintenance",
            "equipment"
          ]
        },
        {
          "name": "instrument_state_log",
          "params": [
            "equipment_id"
          ],
          "roles": [
            "production",
            "storekeeper",
            "accountant"
          ],
          "tables": [
            "change_log",
            "equipment"
          ]
        },
        {
          "name": "production_orders_in_work",
          "params": [
            "date"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "production_order_output",
            "serial_number",
            "production_order",
            "item",
            "bom"
          ]
        },
        {
          "name": "production_orders",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "production_order_output",
            "production_order_need",
            "reservation_held",
            "reservation_move",
            "production_order",
            "item",
            "bom",
            "location"
          ]
        },
        {
          "name": "production_order",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "production_order_output",
            "production_order_need",
            "reservation_held",
            "sales_order",
            "reservation_move",
            "production_order",
            "item",
            "bom",
            "location",
            "stock_pool"
          ]
        },
        {
          "name": "production_order_times",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_operation",
            "bom_operation_card",
            "production_order",
            "item",
            "bom",
            "production_order_output"
          ]
        },
        {
          "name": "order_components",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_substitute",
            "item",
            "production_order",
            "bom_line",
            "production_order_output"
          ]
        },
        {
          "name": "order_pool_stock",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "customer_claim",
            "reservation_held",
            "stock_pool_on_hand",
            "po_line_received",
            "stock_balance",
            "location",
            "stock_pool",
            "po_line",
            "purchase_order",
            "production_order",
            "bom_component_of",
            "item"
          ]
        },
        {
          "name": "order_reservations",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "location",
            "reservation_held",
            "item"
          ]
        },
        {
          "name": "reservation_moves",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "economic_event",
            "reservation_move",
            "item"
          ]
        },
        {
          "name": "order_component_units",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order",
            "bom_line",
            "item",
            "serial_number"
          ]
        },
        {
          "name": "reservation_moves_of_event",
          "params": [
            "event_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "reservation_move",
            "production_order",
            "item"
          ]
        },
        {
          "name": "item_reservations",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "location",
            "reservation_held",
            "production_order",
            "item"
          ]
        },
        {
          "name": "reservations",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "location",
            "reservation_held",
            "production_order",
            "item"
          ]
        },
        {
          "name": "item_availability",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "reservation_held",
            "stock_pool_on_hand",
            "stock_reserved",
            "item"
          ]
        },
        {
          "name": "pool_stock",
          "params": [
            "location_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "customer_claim",
            "reservation_held",
            "stock_pool_on_hand",
            "stock_pool"
          ]
        },
        {
          "name": "pool_holds",
          "params": [
            "location_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "stock_pool",
            "reservation_held",
            "production_order"
          ]
        },
        {
          "name": "production_settings",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_setting"
          ]
        },
        {
          "name": "production_plan",
          "params": [
            "from"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "economic_event",
            "journal_entry",
            "production_order",
            "production_order_output",
            "production_plan",
            "item"
          ]
        },
        {
          "name": "production_outputs",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "event_number",
            "journal_entry",
            "serial_number",
            "economic_event"
          ]
        },
        {
          "name": "mrp_bom_lines",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "bom_line"
          ]
        },
        {
          "name": "mrp_routes",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "bom_operation",
            "bom_operation_card"
          ]
        },
        {
          "name": "promise_routes",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "bom_operation",
            "work_center",
            "bom_operation_card"
          ]
        },
        {
          "name": "promise_lead_days",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "supplier_price"
          ]
        },
        {
          "name": "mrp_demand",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_output",
            "so_line_shipped",
            "so_line",
            "sales_order",
            "production_order",
            "item"
          ]
        },
        {
          "name": "mrp_supply",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "reservation_held",
            "po_line_received",
            "stock_balance",
            "po_line",
            "purchase_order",
            "item"
          ]
        },
        {
          "name": "mrp_analogs",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom",
            "bom_line",
            "bom_substitute",
            "item"
          ]
        },
        {
          "name": "release_rule",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_setting"
          ]
        },
        {
          "name": "plan_open",
          "params": [
            "from"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "economic_event",
            "journal_entry",
            "production_plan",
            "production_order",
            "production_order_output",
            "item"
          ]
        },
        {
          "name": "production_shortages",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "customer_claim",
            "production_order_need",
            "reservation_held",
            "stock_pool_on_hand",
            "po_line_received",
            "production_order",
            "stock_pool",
            "location",
            "po_line",
            "purchase_order",
            "item"
          ]
        },
        {
          "name": "serials_in_stock",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "serial_number",
            "item",
            "production_order"
          ]
        },
        {
          "name": "serial_items",
          "params": [
            "date"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "serial_number",
            "item"
          ]
        },
        {
          "name": "serial_items_stock_on",
          "params": [
            "date"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "serial_number",
            "item",
            "journal_line",
            "journal_entry",
            "location",
            "stock_account"
          ]
        },
        {
          "name": "serials",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "serial_number",
            "item",
            "production_order",
            "party"
          ]
        },
        {
          "name": "serial_trace",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "serial_number",
            "item",
            "economic_event",
            "production_order",
            "bom"
          ]
        },
        {
          "name": "qc_waiting",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "stock_balance",
            "qc_checklist",
            "item",
            "qc_unit",
            "serial_number",
            "production_order"
          ]
        },
        {
          "name": "qc_unnumbered",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "stock_balance",
            "qc_checklist",
            "item",
            "serial_number",
            "qc_back_unnamed",
            "document",
            "party"
          ]
        },
        {
          "name": "qc_back_candidates",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_back_unnamed",
            "qc_checklist",
            "serial_number",
            "item",
            "document"
          ]
        },
        {
          "name": "qc_unit",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_unit",
            "serial_number",
            "item",
            "economic_event",
            "production_order",
            "bom",
            "party"
          ]
        },
        {
          "name": "qc_unit_components",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "serial_number",
            "economic_event",
            "item"
          ]
        },
        {
          "name": "qc_protocols_for_serial",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_protocol",
            "qc_protocol_point",
            "qc_checklist"
          ]
        },
        {
          "name": "qc_protocol_by_key",
          "params": [
            "key"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_protocol",
            "qc_checklist"
          ]
        },
        {
          "name": "qc_protocols_recent",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_protocol",
            "serial_number",
            "item",
            "qc_checklist"
          ]
        },
        {
          "name": "qc_results_for_serial",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_protocol",
            "qc_protocol_point"
          ]
        },
        {
          "name": "qc_checklist_active",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_checklist",
            "qc_point",
            "item"
          ]
        },
        {
          "name": "qc_points_for_serial",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_unit",
            "qc_point"
          ]
        },
        {
          "name": "qc_form_points",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_unit",
            "serial_number",
            "qc_point",
            "production_order",
            "bom_operation",
            "bom",
            "work_center",
            "equipment_card"
          ]
        },
        {
          "name": "qc_checklists",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_point",
            "qc_protocol",
            "qc_checklist",
            "item"
          ]
        },
        {
          "name": "qc_checklist",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_point",
            "qc_protocol",
            "qc_checklist",
            "item"
          ]
        },
        {
          "name": "qc_points",
          "params": [
            "checklist_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_point",
            "qc_checklist",
            "equipment"
          ]
        },
        {
          "name": "qc_items",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item",
            "bom",
            "serial_number"
          ]
        },
        {
          "name": "trace_moves",
          "params": [
            "item_id",
            "event_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "journal_entry",
            "document",
            "journal_line",
            "item",
            "economic_event",
            "location",
            "party",
            "stock_account"
          ]
        },
        {
          "name": "trace_unit",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "journal_entry",
            "serial_number",
            "item",
            "economic_event",
            "production_order",
            "bom",
            "party"
          ]
        },
        {
          "name": "trace_unit_events",
          "params": [
            "serial"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "document",
            "journal_entry",
            "change_log",
            "serial_number",
            "economic_event",
            "party"
          ]
        },
        {
          "name": "presenter_requests",
          "params": [
            "presenter"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "closer"
          ],
          "tables": [
            "document",
            "request_key",
            "economic_event"
          ]
        },
        {
          "name": "install_zone",
          "params": [],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "closer"
          ],
          "tables": [
            "company_setting"
          ]
        },
        {
          "name": "sales_orders",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "accountant"
          ],
          "tables": [
            "so_line_shipped",
            "so_line",
            "sales_order",
            "party"
          ]
        },
        {
          "name": "sales_order",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "accountant"
          ],
          "tables": [
            "sales_order",
            "party",
            "request_outcome",
            "request"
          ]
        },
        {
          "name": "requests",
          "params": [
            "kind"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "request_line",
            "sales_order",
            "purchase_request",
            "economic_event",
            "event_number",
            "request_outcome",
            "request",
            "party"
          ]
        },
        {
          "name": "request",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "request_line",
            "sales_order",
            "purchase_request",
            "economic_event",
            "event_number",
            "request_outcome",
            "request",
            "party"
          ]
        },
        {
          "name": "request_lines",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "request_line",
            "item"
          ]
        },
        {
          "name": "request_outcomes",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "request_outcome",
            "sales_order",
            "purchase_request",
            "economic_event",
            "event_number",
            "journal_entry"
          ]
        },
        {
          "name": "request_of",
          "params": [
            "kind",
            "ref_id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "request_line",
            "sales_order",
            "purchase_request",
            "economic_event",
            "event_number",
            "request_outcome",
            "request",
            "party"
          ]
        },
        {
          "name": "movements_to_link",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "economic_event",
            "journal_entry",
            "request_outcome"
          ]
        },
        {
          "name": "deal_parties",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "party",
            "party_role"
          ]
        },
        {
          "name": "deals",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_need",
            "reservation_held",
            "stock_pool_on_hand",
            "customer_claim",
            "so_line_shipped",
            "document",
            "journal_entry",
            "so_line",
            "production_order",
            "serial_number",
            "qc_unit",
            "document_state",
            "open_item",
            "company_setting",
            "agreement",
            "sales_order",
            "party",
            "request_outcome",
            "request"
          ]
        },
        {
          "name": "deal",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_need",
            "reservation_held",
            "stock_pool_on_hand",
            "customer_claim",
            "so_line_shipped",
            "document",
            "journal_entry",
            "so_line",
            "production_order",
            "serial_number",
            "qc_unit",
            "document_state",
            "open_item",
            "company_setting",
            "agreement",
            "sales_order",
            "party",
            "request_outcome",
            "request"
          ]
        },
        {
          "name": "deals_standing",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_need",
            "reservation_held",
            "stock_pool_on_hand",
            "customer_claim",
            "so_line_shipped",
            "document",
            "journal_entry",
            "so_line",
            "production_order",
            "serial_number",
            "qc_unit",
            "document_state",
            "open_item",
            "company_setting",
            "agreement",
            "sales_order",
            "party",
            "request_outcome",
            "request"
          ]
        },
        {
          "name": "deal_log",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "change_log",
            "request_outcome"
          ]
        },
        {
          "name": "deal_needs",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_output",
            "reservation_held",
            "stock_pool_on_hand",
            "customer_claim",
            "so_line_shipped",
            "production_order",
            "bom",
            "so_line",
            "sales_order",
            "item"
          ]
        },
        {
          "name": "deal_production",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_output",
            "production_order_need",
            "reservation_held",
            "production_order_release",
            "production_order",
            "item"
          ]
        },
        {
          "name": "deal_units",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "qc_unit",
            "serial_number",
            "item",
            "production_order"
          ]
        },
        {
          "name": "deal_documents",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "document",
            "journal_entry",
            "economic_event",
            "tax_invoice",
            "open_item",
            "sales_order",
            "document_state"
          ]
        },
        {
          "name": "papers_open",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "document",
            "journal_entry",
            "sales_order",
            "party",
            "document_state"
          ]
        },
        {
          "name": "document_steps",
          "params": [
            "document_id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "document_step"
          ]
        },
        {
          "name": "order_handovers",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "sales_order",
            "production_order",
            "reservation_handover",
            "item"
          ]
        },
        {
          "name": "order_claims_given",
          "params": [
            "order_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "reservation_handover",
            "customer_claim",
            "sales_order",
            "item"
          ]
        },
        {
          "name": "handover_offer",
          "params": [
            "order_id",
            "item_id",
            "to_kind",
            "to_id",
            "ask"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "reservation_held",
            "sales_order",
            "production_order",
            "item"
          ]
        },
        {
          "name": "customer_claims",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "reservation_handover",
            "production_order",
            "customer_claim",
            "item"
          ]
        },
        {
          "name": "so_lines",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "accountant"
          ],
          "tables": [
            "so_line",
            "item",
            "location",
            "so_line_shipped"
          ]
        },
        {
          "name": "stock_available",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "reservation_held",
            "stock_reserved",
            "stock_balance",
            "item"
          ]
        },
        {
          "name": "shipments",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "accountant"
          ],
          "tables": [
            "document",
            "party"
          ]
        },
        {
          "name": "shipment_document",
          "params": [
            "id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "accountant"
          ],
          "tables": [
            "tax_invoice",
            "document"
          ]
        },
        {
          "name": "event_number",
          "params": [
            "event_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "event_number"
          ]
        },
        {
          "name": "event_series",
          "params": [],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "event_series"
          ]
        },
        {
          "name": "entry_paper",
          "params": [
            "entry_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "tax_invoice",
            "journal_entry",
            "economic_event",
            "document",
            "event_number"
          ]
        },
        {
          "name": "returned_for_shipment",
          "params": [
            "document_id"
          ],
          "roles": [
            "storekeeper",
            "sales",
            "accountant"
          ],
          "tables": [
            "economic_event",
            "journal_entry"
          ]
        },
        {
          "name": "serials_of_item",
          "params": [
            "item_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "serial_number",
            "party"
          ]
        },
        {
          "name": "serials_for_event",
          "params": [
            "event_id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "serial_number",
            "item"
          ]
        },
        {
          "name": "item",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant",
            "shop_worker"
          ],
          "tables": [
            "item"
          ]
        },
        {
          "name": "items_by_ids",
          "params": [
            "ids"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "item"
          ]
        },
        {
          "name": "company_profile",
          "params": [
            "as_of"
          ],
          "roles": [
            "viewer",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "company_profile"
          ]
        },
        {
          "name": "floor_board",
          "params": [
            "as_of"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order",
            "change_log",
            "economic_event",
            "journal_entry",
            "operation_live",
            "bom_operation",
            "item",
            "bom",
            "work_center"
          ]
        },
        {
          "name": "floor_board_then",
          "params": [
            "date",
            "back"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "operation_live",
            "production_order",
            "change_log",
            "economic_event",
            "journal_entry",
            "bom_operation",
            "item",
            "bom",
            "work_center"
          ]
        },
        {
          "name": "floor_open",
          "params": [
            "as_of"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "operation_live",
            "work_center",
            "production_order",
            "item",
            "serial_number",
            "bom_operation",
            "party",
            "change_log"
          ]
        },
        {
          "name": "floor_days",
          "params": [
            "as_of",
            "limit"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "operation_live"
          ]
        },
        {
          "name": "floor_activity",
          "params": [
            "from",
            "to"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "operation_live"
          ]
        },
        {
          "name": "floor_internal",
          "params": [
            "from",
            "to"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "equipment_maintenance",
            "equipment",
            "equipment_verification"
          ]
        },
        {
          "name": "floor_order_parts",
          "params": [],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_need",
            "reservation_held",
            "qc_unit",
            "item"
          ]
        },
        {
          "name": "floor_check_waiting",
          "params": [
            "date"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "bom_operation",
            "qc_protocol",
            "serial_number",
            "item",
            "production_order",
            "qc_checklist"
          ]
        },
        {
          "name": "floor_plan_orders",
          "params": [],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "operation_progress",
            "economic_event",
            "journal_entry",
            "operation_live",
            "production_order",
            "item",
            "bom_operation",
            "work_center"
          ]
        },
        {
          "name": "floor_plan_lines",
          "params": [
            "from"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "economic_event",
            "journal_entry",
            "production_order",
            "production_order_output",
            "production_plan",
            "item",
            "bom",
            "bom_operation",
            "work_center"
          ]
        },
        {
          "name": "floor_order",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "production_order_output",
            "operation_progress",
            "economic_event",
            "journal_entry",
            "operation_live",
            "production_order",
            "item",
            "bom_operation",
            "work_center"
          ]
        },
        {
          "name": "floor_order_records",
          "params": [
            "id"
          ],
          "roles": [
            "viewer",
            "shop_worker",
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "operation_record",
            "work_center",
            "bom_operation",
            "party",
            "production_order"
          ]
        },
        {
          "name": "simulate_offers",
          "params": [],
          "roles": [
            "storekeeper",
            "sales",
            "purchaser",
            "production",
            "accountant"
          ],
          "tables": [
            "po_line_received",
            "so_line_shipped",
            "stock_balance",
            "item",
            "location",
            "reservation_balance",
            "purchase_order",
            "po_line",
            "party",
            "sales_order",
            "so_line",
            "party_role"
          ]
        }
      ]
    }
    curl
    curl 'https://demokrylo.bnp.works/api/v1/queries' \
      -H 'authorization: Bearer <ключ>'
  2. 2запит purchase_orders разом527 мс200

    GET /api/v1/q/purchase_orders

    Читає purchase_orders (po_line, po_line_received, purchase_order, party)

    показати запит і відповідь
    GET /api/v1/q/purchase_orders
    {
      "headers": {
        "authorization": "Bearer <ключ>"
      }
    }
    {
      "rows": [
        {
          "id": "e80665cf-73b1-41ed-b892-b6a76087cb71",
          "number": "ЗП-2026-00116",
          "status": "closed",
          "expected_on": "2026-10-01",
          "created_at": "2026-09-28T07:21:55.427Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 4948,
          "received": 4948
        },
        {
          "id": "600196e9-d9a3-4f62-a5ab-6aa71b1f89c1",
          "number": "ЗП-2026-00115",
          "status": "closed",
          "expected_on": "2026-09-26",
          "created_at": "2026-09-23T07:18:28.407Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 20,
          "received": 20
        },
        {
          "id": "ccfccb59-f0c8-479c-9af4-3b6ef598d685",
          "number": "ЗП-2026-00114",
          "status": "closed",
          "expected_on": "2026-09-27",
          "created_at": "2026-09-21T07:08:34.439Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 24,
          "received": 24
        },
        {
          "id": "5d8d2f0b-caf8-4223-9c46-6287a10790a9",
          "number": "ЗП-2026-00113",
          "status": "closed",
          "expected_on": "2026-09-20",
          "created_at": "2026-09-14T06:44:10.069Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 143,
          "received": 143
        },
        {
          "id": "27dc4acf-4d27-400d-b759-9af9fee1c86e",
          "number": "ЗП-2026-00112",
          "status": "ordered",
          "expected_on": "2026-10-08",
          "created_at": "2026-09-14T06:44:07.179Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 8093,
          "received": 0
        },
        {
          "id": "28071bb9-5df3-4c63-a341-0db738d6b0e9",
          "number": "ЗП-2026-00111",
          "status": "closed",
          "expected_on": "2026-09-19",
          "created_at": "2026-09-14T06:43:57.054Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 76,
          "received": 76
        },
        {
          "id": "aa147014-5bad-4b1e-8a48-92d9fb3e500f",
          "number": "ЗП-2026-00110",
          "status": "cancelled",
          "expected_on": "2026-09-30",
          "created_at": "2026-09-14T06:43:54.216Z",
          "supplier": "Curonian Optics UAB",
          "qty": 125,
          "received": 0
        },
        {
          "id": "51268ecf-7e66-456a-9cad-dd22f74481b3",
          "number": "ЗП-2026-00109",
          "status": "closed",
          "expected_on": "2026-09-17",
          "created_at": "2026-09-14T06:43:51.099Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 98134,
          "received": 98134
        },
        {
          "id": "89faf20b-0e5a-4f48-bbb5-0276c50a9dec",
          "number": "ЗП-2026-00108",
          "status": "closed",
          "expected_on": "2026-09-12",
          "created_at": "2026-09-09T06:39:16.306Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 20,
          "received": 20
        },
        {
          "id": "e7f9a74f-ef64-4164-a291-5e20d2e01261",
          "number": "ЗП-2026-00107",
          "status": "closed",
          "expected_on": "2026-09-13",
          "created_at": "2026-09-07T06:31:04.704Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 6,
          "received": 6
        },
        {
          "id": "a0e3e283-d386-47a8-965e-8ed926a88fa8",
          "number": "ЗП-2026-00106",
          "status": "closed",
          "expected_on": "2026-09-12",
          "created_at": "2026-09-07T06:31:02.080Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 6,
          "received": 6
        },
        {
          "id": "2d2bdf97-b59d-4b77-b844-4c64d9306e74",
          "number": "ЗП-2026-00105",
          "status": "closed",
          "expected_on": "2026-09-10",
          "created_at": "2026-09-07T06:30:59.695Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 1221424,
          "received": 1221424
        },
        {
          "id": "bf08b05b-cb2f-4de8-9036-28fc3741d6de",
          "number": "ЗП-2026-00104",
          "status": "closed",
          "expected_on": "2026-09-11",
          "created_at": "2026-09-07T06:30:56.257Z",
          "supplier": "ТОВ «Схема і Плата»",
          "qty": 2,
          "received": 2
        },
        {
          "id": "b5ff7220-5d25-4b67-8c2d-4f80dcb0b223",
          "number": "ЗП-2026-00103",
          "status": "closed",
          "expected_on": "2026-09-06",
          "created_at": "2026-08-31T06:17:34.710Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 17,
          "received": 17
        },
        {
          "id": "3c59c878-e95f-4dc4-b41b-606402c0cc86",
          "number": "ЗП-2026-00102",
          "status": "closed",
          "expected_on": "2026-09-03",
          "created_at": "2026-08-31T06:17:31.782Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 10200,
          "received": 10200
        },
        {
          "id": "b9404c76-5940-4e41-b3ca-0b6dcc9eeb9e",
          "number": "ЗП-2026-00101",
          "status": "cancelled",
          "expected_on": "2026-09-17",
          "created_at": "2026-08-24T06:13:11.612Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 545,
          "received": 0
        },
        {
          "id": "d3556324-cfb7-4a7a-9d7e-8543373d31eb",
          "number": "ЗП-2026-00100",
          "status": "cancelled",
          "expected_on": "2026-09-17",
          "created_at": "2026-08-24T06:13:05.177Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 4063,
          "received": 0
        },
        {
          "id": "3bb33b4e-3f59-4e0e-bd2f-cca3ae93f0eb",
          "number": "ЗП-2026-00099",
          "status": "cancelled",
          "expected_on": "2026-09-09",
          "created_at": "2026-08-24T06:12:54.572Z",
          "supplier": "Curonian Optics UAB",
          "qty": 83,
          "received": 0
        },
        {
          "id": "b4ef842b-76d2-4134-8517-2a1a97b69882",
          "number": "ЗП-2026-00098",
          "status": "closed",
          "expected_on": "2026-08-22",
          "created_at": "2026-08-17T05:52:53.941Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 2,
          "received": 2
        },
        {
          "id": "e1fefd38-4c22-45aa-aa47-f5a977ab11f9",
          "number": "ЗП-2026-00097",
          "status": "closed",
          "expected_on": "2026-08-20",
          "created_at": "2026-08-17T05:52:50.927Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 311539,
          "received": 311535
        },
        {
          "id": "02d62445-d516-4629-b801-95b42e0fda8e",
          "number": "ЗП-2026-00096",
          "status": "closed",
          "expected_on": "2026-08-14",
          "created_at": "2026-08-11T05:45:35.119Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 20,
          "received": 20
        },
        {
          "id": "c464d496-ad07-4613-ae92-c18377dd4202",
          "number": "ЗП-2026-00095",
          "status": "closed",
          "expected_on": "2026-08-16",
          "created_at": "2026-08-10T05:30:13.868Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 123,
          "received": 123
        },
        {
          "id": "900ad868-2e47-4019-8fa7-4aff88de7759",
          "number": "ЗП-2026-00094",
          "status": "closed",
          "expected_on": "2026-08-15",
          "created_at": "2026-08-10T05:30:10.937Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 170,
          "received": 170
        },
        {
          "id": "3da8ec05-a969-4e91-8750-71cd01a23079",
          "number": "ЗП-2026-00093",
          "status": "closed",
          "expected_on": "2026-08-13",
          "created_at": "2026-08-10T05:30:07.743Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 188817,
          "received": 188817
        },
        {
          "id": "e38859e4-6f63-49f2-9c24-1a7a07836bdf",
          "number": "ЗП-2026-00092",
          "status": "closed",
          "expected_on": "2026-08-09",
          "created_at": "2026-08-03T05:05:56.033Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 18,
          "received": 18
        },
        {
          "id": "c4eb59a8-3075-4fd7-919f-81f39004a410",
          "number": "ЗП-2026-00091",
          "status": "cancelled",
          "expected_on": "2026-08-27",
          "created_at": "2026-08-03T05:05:53.692Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 3253,
          "received": 0
        },
        {
          "id": "1ea40b21-eac8-4f37-a943-ba766f71870e",
          "number": "ЗП-2026-00090",
          "status": "cancelled",
          "expected_on": "2026-08-19",
          "created_at": "2026-08-03T05:05:47.941Z",
          "supplier": "Curonian Optics UAB",
          "qty": 89,
          "received": 0
        },
        {
          "id": "b7038b77-edd5-4d22-92e9-42f3c73a8fea",
          "number": "ЗП-2026-00089",
          "status": "closed",
          "expected_on": "2026-07-30",
          "created_at": "2026-07-27T04:58:39.213Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 8860,
          "received": 8860
        },
        {
          "id": "b107040c-a418-4e87-b80c-dabe83b1f879",
          "number": "ЗП-2026-00088",
          "status": "closed",
          "expected_on": "2026-07-26",
          "created_at": "2026-07-23T04:57:27.083Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 20,
          "received": 20
        },
        {
          "id": "2073c2d6-b545-4af3-8a10-9b7ac80862af",
          "number": "ЗП-2026-00087",
          "status": "closed",
          "expected_on": "2026-07-23",
          "created_at": "2026-07-20T04:46:43.269Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 4367,
          "received": 4367
        },
        {
          "id": "861ed541-3ee4-4238-b52f-a9ac20697193",
          "number": "ЗП-2026-00086",
          "status": "closed",
          "expected_on": "2026-07-19",
          "created_at": "2026-07-13T04:38:27.607Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 67,
          "received": 67
        },
        {
          "id": "d21927a9-6a11-47a5-b018-a84fddbbecea",
          "number": "ЗП-2026-00085",
          "status": "cancelled",
          "expected_on": "2026-08-06",
          "created_at": "2026-07-13T04:38:24.984Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 280,
          "received": 0
        },
        {
          "id": "2909775a-e21c-49fa-9dc2-5fc655e8293a",
          "number": "ЗП-2026-00084",
          "status": "cancelled",
          "expected_on": "2026-08-06",
          "created_at": "2026-07-13T04:38:20.620Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 5371,
          "received": 0
        },
        {
          "id": "7862885a-c852-440a-9479-1d195447be11",
          "number": "ЗП-2026-00083",
          "status": "cancelled",
          "expected_on": "2026-07-29",
          "created_at": "2026-07-13T04:38:10.653Z",
          "supplier": "Curonian Optics UAB",
          "qty": 74,
          "received": 0
        },
        {
          "id": "274cd8ef-e0b1-423e-a067-415d35b70b01",
          "number": "ЗП-2026-00082",
          "status": "closed",
          "expected_on": "2026-07-16",
          "created_at": "2026-07-13T04:38:06.901Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 4440,
          "received": 4440
        },
        {
          "id": "b865adde-f0d3-4882-b02e-f4af3ad0f56c",
          "number": "ЗП-2026-00081",
          "status": "closed",
          "expected_on": "2026-07-12",
          "created_at": "2026-07-09T04:33:55.448Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 20,
          "received": 20
        },
        {
          "id": "d41ff2c2-d37c-40d1-9a25-7c75659af745",
          "number": "ЗП-2026-00080",
          "status": "closed",
          "expected_on": "2026-07-12",
          "created_at": "2026-07-06T04:16:37.873Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 79,
          "received": 79
        },
        {
          "id": "c6bb42d7-ead0-4649-a4aa-f448e49adb23",
          "number": "ЗП-2026-00079",
          "status": "closed",
          "expected_on": "2026-07-11",
          "created_at": "2026-07-06T04:16:35.613Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 83,
          "received": 83
        },
        {
          "id": "e4996bf0-a0e0-4fd3-aa69-f10e7b142c93",
          "number": "ЗП-2026-00078",
          "status": "closed",
          "expected_on": "2026-07-09",
          "created_at": "2026-07-06T04:16:32.881Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 484191,
          "received": 484191
        },
        {
          "id": "b452216b-2627-43fe-b8bf-0797fdb94175",
          "number": "ЗП-2026-00077",
          "status": "closed",
          "expected_on": "2026-06-28",
          "created_at": "2026-06-22T03:45:20.030Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 19,
          "received": 19
        },
        {
          "id": "54bb7188-ca77-4595-b9b8-1c66ad336296",
          "number": "ЗП-2026-00076",
          "status": "cancelled",
          "expected_on": "2026-07-16",
          "created_at": "2026-06-22T03:45:16.769Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 2844,
          "received": 0
        },
        {
          "id": "7cfb1af0-1ff8-4f6f-b433-0093cada562a",
          "number": "ЗП-2026-00075",
          "status": "cancelled",
          "expected_on": "2026-07-08",
          "created_at": "2026-06-22T03:45:10.789Z",
          "supplier": "Curonian Optics UAB",
          "qty": 102,
          "received": 0
        },
        {
          "id": "516a632d-cdb8-43a5-b4f1-f014c82f6c5b",
          "number": "ЗП-2026-00074",
          "status": "cancelled",
          "expected_on": "2026-07-16",
          "created_at": "2026-06-22T03:44:09.379Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 10,
          "received": 0
        },
        {
          "id": "60a4380b-b6b8-4a5c-8c63-eb6f1a3e7eb8",
          "number": "ЗП-2026-00073",
          "status": "closed",
          "expected_on": "2026-06-21",
          "created_at": "2026-06-15T03:34:59.099Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 6,
          "received": 6
        },
        {
          "id": "b6b5e891-b874-4c2a-8048-28ad6eec0194",
          "number": "ЗП-2026-00072",
          "status": "closed",
          "expected_on": "2026-06-18",
          "created_at": "2026-06-15T03:34:56.321Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 1280900,
          "received": 1280900
        },
        {
          "id": "72ca97bf-2e3c-44c3-8d49-aef43d0e6ad5",
          "number": "ЗП-2026-00071",
          "status": "closed",
          "expected_on": "2026-06-12",
          "created_at": "2026-06-09T03:28:23.324Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "7ab3cd6f-802c-4762-bdc4-7b00e84a66de",
          "number": "ЗП-2026-00070",
          "status": "closed",
          "expected_on": "2026-06-14",
          "created_at": "2026-06-08T03:16:31.045Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 50,
          "received": 50
        },
        {
          "id": "a849368a-10d3-4370-968f-7baab00a8f82",
          "number": "ЗП-2026-00069",
          "status": "closed",
          "expected_on": "2026-06-13",
          "created_at": "2026-06-08T03:16:28.101Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 7,
          "received": 7
        },
        {
          "id": "8b33167f-796d-4590-a521-35d1d959ba5f",
          "number": "ЗП-2026-00068",
          "status": "closed",
          "expected_on": "2026-06-11",
          "created_at": "2026-06-08T03:16:25.021Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 54692,
          "received": 54692
        },
        {
          "id": "b5bca09a-d0c2-41e2-bc35-a025b9eb6c89",
          "number": "ЗП-2026-00067",
          "status": "closed",
          "expected_on": "2026-06-07",
          "created_at": "2026-06-01T02:58:54.973Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 68,
          "received": 68
        },
        {
          "id": "4ca08a1c-f056-4381-8e4a-721aebcaef4e",
          "number": "ЗП-2026-00066",
          "status": "cancelled",
          "expected_on": "2026-06-25",
          "created_at": "2026-06-01T02:58:52.037Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 740,
          "received": 0
        },
        {
          "id": "7a31edd4-e9ad-41d4-b831-96407c02bab7",
          "number": "ЗП-2026-00065",
          "status": "cancelled",
          "expected_on": "2026-06-25",
          "created_at": "2026-06-01T02:58:45.435Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 3979,
          "received": 0
        },
        {
          "id": "b05bf9f1-3207-4b6b-8963-9a3b62fbc8c3",
          "number": "ЗП-2026-00064",
          "status": "closed",
          "expected_on": "2026-06-06",
          "created_at": "2026-06-01T02:58:33.425Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 142,
          "received": 142
        },
        {
          "id": "dacf7b9b-572a-4def-be58-2f23ea6ab5e0",
          "number": "ЗП-2026-00063",
          "status": "cancelled",
          "expected_on": "2026-06-17",
          "created_at": "2026-06-01T02:58:29.804Z",
          "supplier": "Curonian Optics UAB",
          "qty": 81,
          "received": 0
        },
        {
          "id": "9c1b81d3-3d32-4c35-b271-3d6cdb2fc893",
          "number": "ЗП-2026-00062",
          "status": "closed",
          "expected_on": "2026-06-04",
          "created_at": "2026-06-01T02:58:25.808Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 130448,
          "received": 130448
        },
        {
          "id": "c744a2e9-3654-4891-998b-ee25593bd3ef",
          "number": "ЗП-2026-00061",
          "status": "closed",
          "expected_on": "2026-05-28",
          "created_at": "2026-05-25T02:43:04.849Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "54ad753e-c9eb-4a29-9a90-3dbee086d623",
          "number": "ЗП-2026-00060",
          "status": "closed",
          "expected_on": "2026-05-31",
          "created_at": "2026-05-25T02:42:37.540Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 18,
          "received": 14
        },
        {
          "id": "5f6dbfca-b13c-4085-b8aa-387aeff741ca",
          "number": "ЗП-2026-00059",
          "status": "closed",
          "expected_on": "2026-05-28",
          "created_at": "2026-05-25T02:42:34.974Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 4452,
          "received": 4452
        },
        {
          "id": "da8347d8-6004-4d1a-878f-30cac9c3db68",
          "number": "ЗП-2026-00058",
          "status": "closed",
          "expected_on": "2026-05-24",
          "created_at": "2026-05-18T02:28:43.542Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 10,
          "received": 10
        },
        {
          "id": "72cb5788-f010-4dc6-9a16-1a7fa36517c3",
          "number": "ЗП-2026-00057",
          "status": "closed",
          "expected_on": "2026-05-23",
          "created_at": "2026-05-18T02:28:40.572Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 11,
          "received": 11
        },
        {
          "id": "c3192990-57e4-495f-91ee-82eb181178a3",
          "number": "ЗП-2026-00056",
          "status": "closed",
          "expected_on": "2026-05-21",
          "created_at": "2026-05-18T02:28:37.625Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 47802,
          "received": 47802
        },
        {
          "id": "198b28d3-2929-446d-a4db-fece3f8c5575",
          "number": "ЗП-2026-00055",
          "status": "closed",
          "expected_on": "2026-05-22",
          "created_at": "2026-05-18T02:28:34.393Z",
          "supplier": "ТОВ «Схема і Плата»",
          "qty": 2,
          "received": 2
        },
        {
          "id": "91b2d913-c0ea-4778-b794-e79de2b274dc",
          "number": "ЗП-2026-00054",
          "status": "closed",
          "expected_on": "2026-05-14",
          "created_at": "2026-05-11T02:09:54.364Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "ab21b041-cb5e-498b-84ea-04277db22ff7",
          "number": "ЗП-2026-00053",
          "status": "closed",
          "expected_on": "2026-05-17",
          "created_at": "2026-05-11T02:07:48.639Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 49,
          "received": 49
        },
        {
          "id": "83b939bc-290e-4147-b4ff-84bf9022ee37",
          "number": "ЗП-2026-00052",
          "status": "cancelled",
          "expected_on": "2026-06-04",
          "created_at": "2026-05-11T02:07:45.786Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 380,
          "received": 0
        },
        {
          "id": "edcbbef9-cf8a-4895-ac25-3b96209b348c",
          "number": "ЗП-2026-00051",
          "status": "cancelled",
          "expected_on": "2026-06-04",
          "created_at": "2026-05-11T02:07:41.745Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 8058,
          "received": 0
        },
        {
          "id": "d54e4dda-d0f1-4016-8126-bf760149cf6c",
          "number": "ЗП-2026-00050",
          "status": "closed",
          "expected_on": "2026-05-16",
          "created_at": "2026-05-11T02:07:30.126Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 8,
          "received": 8
        },
        {
          "id": "2b3838e1-fb92-4934-8e5d-969b97f4cc3b",
          "number": "ЗП-2026-00049",
          "status": "cancelled",
          "expected_on": "2026-05-27",
          "created_at": "2026-05-11T02:07:27.205Z",
          "supplier": "Curonian Optics UAB",
          "qty": 107,
          "received": 0
        },
        {
          "id": "98410d18-b3b1-4290-a02c-dbf9347c76bb",
          "number": "ЗП-2026-00048",
          "status": "closed",
          "expected_on": "2026-05-14",
          "created_at": "2026-05-11T02:07:24.142Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 344558,
          "received": 344558
        },
        {
          "id": "8227d056-ffc2-4b30-ad9b-c735e23d3897",
          "number": "ЗП-2026-00047",
          "status": "cancelled",
          "expected_on": "2026-05-27",
          "created_at": "2026-05-11T02:05:07.282Z",
          "supplier": "Curonian Optics UAB",
          "qty": 15,
          "received": 0
        },
        {
          "id": "211f58b0-b7ca-42f1-9b88-2354ca6d1c88",
          "number": "ЗП-2026-00046",
          "status": "closed",
          "expected_on": "2026-05-07",
          "created_at": "2026-05-04T01:58:15.521Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 10200,
          "received": 10200
        },
        {
          "id": "4bcd37e5-bd6d-4509-ab37-e6930ea925f1",
          "number": "ЗП-2026-00045",
          "status": "closed",
          "expected_on": "2026-05-03",
          "created_at": "2026-04-27T01:41:19.522Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 104,
          "received": 104
        },
        {
          "id": "dc592219-ea3a-49d0-a901-8e0f177d9813",
          "number": "ЗП-2026-00044",
          "status": "closed",
          "expected_on": "2026-05-02",
          "created_at": "2026-04-27T01:41:16.578Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 73,
          "received": 73
        },
        {
          "id": "14f9275e-902a-4013-b4de-d88058b98f07",
          "number": "ЗП-2026-00043",
          "status": "closed",
          "expected_on": "2026-04-30",
          "created_at": "2026-04-27T01:41:13.592Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 4592,
          "received": 4592
        },
        {
          "id": "723d3960-02c1-40b4-b079-3dbea6694b0e",
          "number": "ЗП-2026-00042",
          "status": "closed",
          "expected_on": "2026-04-26",
          "created_at": "2026-04-20T01:34:48.831Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 41,
          "received": 41
        },
        {
          "id": "16fbeb82-ebfe-4c02-ad94-a8ce65eb6b8b",
          "number": "ЗП-2026-00041",
          "status": "cancelled",
          "expected_on": "2026-05-14",
          "created_at": "2026-04-20T01:34:46.076Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 2028,
          "received": 0
        },
        {
          "id": "7b8dcbae-8ed8-47c3-af6d-6a63101264a9",
          "number": "ЗП-2026-00040",
          "status": "cancelled",
          "expected_on": "2026-05-06",
          "created_at": "2026-04-20T01:34:37.018Z",
          "supplier": "Curonian Optics UAB",
          "qty": 67,
          "received": 0
        },
        {
          "id": "9488464e-999b-4122-8345-ead9d1724ca6",
          "number": "ЗП-2026-00039",
          "status": "closed",
          "expected_on": "2026-04-19",
          "created_at": "2026-04-13T01:19:43.401Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 6,
          "received": 6
        },
        {
          "id": "b29658ad-bd3a-49c2-9bfe-3b85c66fdb43",
          "number": "ЗП-2026-00038",
          "status": "closed",
          "expected_on": "2026-04-18",
          "created_at": "2026-04-13T01:19:40.724Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 5,
          "received": 5
        },
        {
          "id": "5ded7332-ba3a-4ae6-974e-bee9dc203b82",
          "number": "ЗП-2026-00037",
          "status": "closed",
          "expected_on": "2026-04-16",
          "created_at": "2026-04-13T01:19:38.047Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 1371814,
          "received": 1371814
        },
        {
          "id": "5d8898a3-601a-4dba-b0d2-bfe87af65022",
          "number": "ЗП-2026-00036",
          "status": "closed",
          "expected_on": "2026-04-12",
          "created_at": "2026-04-09T01:17:39.128Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "0ee0fcd0-1e3a-4e46-b834-f321ce49ba2f",
          "number": "ЗП-2026-00035",
          "status": "closed",
          "expected_on": "2026-04-09",
          "created_at": "2026-04-06T01:08:26.571Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 285910,
          "received": 285910
        },
        {
          "id": "090b7c0c-b4da-43fd-9c3d-434d82ecfa48",
          "number": "ЗП-2026-00034",
          "status": "closed",
          "expected_on": "2026-04-05",
          "created_at": "2026-03-30T00:54:31.968Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 18,
          "received": 14
        },
        {
          "id": "363e197c-d18c-4645-bdba-a12799a5aa72",
          "number": "ЗП-2026-00033",
          "status": "cancelled",
          "expected_on": "2026-04-23",
          "created_at": "2026-03-30T00:54:29.260Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 3276,
          "received": 0
        },
        {
          "id": "ebe8b812-f023-4f3c-a640-792c4d74fe69",
          "number": "ЗП-2026-00032",
          "status": "closed",
          "expected_on": "2026-04-04",
          "created_at": "2026-03-30T00:54:18.280Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 152,
          "received": 152
        },
        {
          "id": "95f45f57-1520-4532-a113-7ab6fac65ee4",
          "number": "ЗП-2026-00031",
          "status": "cancelled",
          "expected_on": "2026-04-15",
          "created_at": "2026-03-30T00:54:15.322Z",
          "supplier": "Curonian Optics UAB",
          "qty": 84,
          "received": 0
        },
        {
          "id": "553e356d-56ce-48f0-bb54-bdd24e9d3d13",
          "number": "ЗП-2026-00030",
          "status": "closed",
          "expected_on": "2026-04-02",
          "created_at": "2026-03-30T00:54:12.578Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 162437,
          "received": 162437
        },
        {
          "id": "14faab23-4458-4a0b-b0b7-7e4afd56257e",
          "number": "ЗП-2026-00029",
          "status": "closed",
          "expected_on": "2026-03-27",
          "created_at": "2026-03-24T01:51:11.858Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "dce0803a-ef36-4b79-9649-c32d07859f95",
          "number": "ЗП-2026-00028",
          "status": "closed",
          "expected_on": "2026-03-29",
          "created_at": "2026-03-23T01:41:26.923Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 117,
          "received": 117
        },
        {
          "id": "1a17a86a-4b70-4d69-9183-521f98d399d1",
          "number": "ЗП-2026-00027",
          "status": "closed",
          "expected_on": "2026-03-28",
          "created_at": "2026-03-23T01:41:23.904Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 9,
          "received": 9
        },
        {
          "id": "3ebecd2c-97dd-47be-b15d-cfb5a75d2ca5",
          "number": "ЗП-2026-00026",
          "status": "closed",
          "expected_on": "2026-03-26",
          "created_at": "2026-03-23T01:41:20.556Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 19472,
          "received": 19472
        },
        {
          "id": "9d4c65d0-8155-4317-ad19-90931539c4cf",
          "number": "ЗП-2026-00025",
          "status": "closed",
          "expected_on": "2026-03-13",
          "created_at": "2026-03-10T01:21:09.288Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "1bdbc9ec-cbbd-4ff9-a35d-27b4cf0460f8",
          "number": "ЗП-2026-00024",
          "status": "closed",
          "expected_on": "2026-03-15",
          "created_at": "2026-03-09T01:15:09.977Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 16,
          "received": 16
        },
        {
          "id": "7d26458c-35d3-4d54-97b2-acbbbb9030cd",
          "number": "ЗП-2026-00023",
          "status": "cancelled",
          "expected_on": "2026-04-02",
          "created_at": "2026-03-09T01:15:07.117Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 6014,
          "received": 0
        },
        {
          "id": "e27d8e6c-94dc-4331-892e-7821a0420cd2",
          "number": "ЗП-2026-00022",
          "status": "closed",
          "expected_on": "2026-03-14",
          "created_at": "2026-03-09T01:14:59.580Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 9,
          "received": 9
        },
        {
          "id": "fb1ce50c-1933-4c19-988d-ae19292b7cfe",
          "number": "ЗП-2026-00021",
          "status": "cancelled",
          "expected_on": "2026-03-25",
          "created_at": "2026-03-09T01:14:56.519Z",
          "supplier": "Curonian Optics UAB",
          "qty": 35,
          "received": 0
        },
        {
          "id": "39360996-fc9d-4538-bc38-f0bee09a7df5",
          "number": "ЗП-2026-00020",
          "status": "closed",
          "expected_on": "2026-03-12",
          "created_at": "2026-03-09T01:14:53.341Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 16200,
          "received": 16200
        },
        {
          "id": "7282778d-bfb0-49fc-97e2-e7e3bff8ba1b",
          "number": "ЗП-2026-00019",
          "status": "closed",
          "expected_on": "2026-02-22",
          "created_at": "2026-02-16T00:42:29.724Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 148,
          "received": 148
        },
        {
          "id": "17175dd3-6f21-436d-baa0-ffa4a36eeeb7",
          "number": "ЗП-2026-00018",
          "status": "cancelled",
          "expected_on": "2026-03-12",
          "created_at": "2026-02-16T00:42:26.864Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 295,
          "received": 0
        },
        {
          "id": "24e98fcd-5a1d-4178-ae6a-ed1c72ff3cbe",
          "number": "ЗП-2026-00017",
          "status": "cancelled",
          "expected_on": "2026-03-12",
          "created_at": "2026-02-16T00:42:23.594Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 3491,
          "received": 0
        },
        {
          "id": "785dcc57-4695-40fe-b777-75c751de37c5",
          "number": "ЗП-2026-00016",
          "status": "closed",
          "expected_on": "2026-02-21",
          "created_at": "2026-02-16T00:42:14.217Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 10,
          "received": 10
        },
        {
          "id": "f69b1855-6262-48e1-ab49-e006be519427",
          "number": "ЗП-2026-00015",
          "status": "cancelled",
          "expected_on": "2026-03-04",
          "created_at": "2026-02-16T00:42:11.534Z",
          "supplier": "Curonian Optics UAB",
          "qty": 124,
          "received": 0
        },
        {
          "id": "06047c59-95e9-4f92-9b94-27d7168c132c",
          "number": "ЗП-2026-00014",
          "status": "closed",
          "expected_on": "2026-02-19",
          "created_at": "2026-02-16T00:42:08.496Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 12,
          "received": 12
        },
        {
          "id": "574d8563-1965-4111-8935-f987eaf7f285",
          "number": "ЗП-2026-00013",
          "status": "closed",
          "expected_on": "2026-02-13",
          "created_at": "2026-02-10T00:39:05.870Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "4a1d0386-b27b-48de-9aee-26f815141e58",
          "number": "ЗП-2026-00012",
          "status": "closed",
          "expected_on": "2026-02-12",
          "created_at": "2026-02-09T00:34:04.402Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 6000,
          "received": 6000
        },
        {
          "id": "41c9f6ea-20a8-4137-a8fb-3be34b556d75",
          "number": "ЗП-2026-00011",
          "status": "cancelled",
          "expected_on": "2026-02-19",
          "created_at": "2026-01-26T00:20:46.018Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 18,
          "received": 0
        },
        {
          "id": "0607f8f1-4916-442e-b84e-691bd32e88c3",
          "number": "ЗП-2026-00010",
          "status": "closed",
          "expected_on": "2026-01-26",
          "created_at": "2026-01-23T00:20:02.231Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "ac49b308-c69d-414c-b6f6-6059611e94f7",
          "number": "ЗП-2026-00009",
          "status": "closed",
          "expected_on": "2026-01-12",
          "created_at": "2026-01-09T00:11:54.058Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 200,
          "received": 200
        },
        {
          "id": "75f48b58-cd02-47c4-bc33-b9e7f270576f",
          "number": "ЗП-2026-00008",
          "status": "closed",
          "expected_on": "2026-01-11",
          "created_at": "2026-01-05T00:10:19.922Z",
          "supplier": "ТОВ «Вольт і Рама»",
          "qty": 256,
          "received": 251
        },
        {
          "id": "e675ca9f-a6c7-405f-8881-5bf489b3a812",
          "number": "ЗП-2026-00007",
          "status": "cancelled",
          "expected_on": "2026-01-16",
          "created_at": "2026-01-05T00:10:16.713Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 536,
          "received": 0
        },
        {
          "id": "1cbb98bf-cbcd-4dda-b4a9-f244722acfe4",
          "number": "ЗП-2026-00006",
          "status": "cancelled",
          "expected_on": "2026-01-16",
          "created_at": "2026-01-05T00:10:13.003Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 15233,
          "received": 0
        },
        {
          "id": "5383bd52-a778-4f93-a936-53c6da5abc6e",
          "number": "ЗП-2026-00005",
          "status": "cancelled",
          "expected_on": "2026-01-16",
          "created_at": "2026-01-05T00:10:03.529Z",
          "supplier": "Far East Rotor Parts Co., Ltd",
          "qty": 4103,
          "received": 0
        },
        {
          "id": "643b4d29-d2b0-4507-930a-60d3c1f2793f",
          "number": "ЗП-2026-00004",
          "status": "closed",
          "expected_on": "2026-01-10",
          "created_at": "2026-01-05T00:09:53.585Z",
          "supplier": "ТОВ «Тара і Кейс»",
          "qty": 306,
          "received": 306
        },
        {
          "id": "0ec0ba58-ecc0-4dd5-8085-e803c0eebcfb",
          "number": "ЗП-2026-00003",
          "status": "cancelled",
          "expected_on": "2026-01-14",
          "created_at": "2026-01-05T00:09:50.067Z",
          "supplier": "Curonian Optics UAB",
          "qty": 305,
          "received": 0
        },
        {
          "id": "0c4c4b48-57f2-457f-a91d-d802998be79b",
          "number": "ЗП-2026-00002",
          "status": "closed",
          "expected_on": "2026-01-08",
          "created_at": "2026-01-05T00:09:46.137Z",
          "supplier": "ТОВ «Гвинт і Гайка»",
          "qty": 2655993,
          "received": 2655993
        },
        {
          "id": "f44c64fa-49c5-4fdc-811d-af6cc0e2ac4a",
          "number": "ЗП-2026-00001",
          "status": "closed",
          "expected_on": "2026-01-09",
          "created_at": "2026-01-05T00:09:38.803Z",
          "supplier": "ТОВ «Схема і Плата»",
          "qty": 2,
          "received": 2
        }
      ]
    }
    curl
    curl 'https://demokrylo.bnp.works/api/v1/q/purchase_orders' \
      -H 'authorization: Bearer <ключ>'
  3. 3запит company_profile разом444 мс200

    GET /api/v1/q/company_profile?as_of=2026-10-07

    Читає company_profile (company_profile)

    показати запит і відповідь
    GET /api/v1/q/company_profile?as_of=2026-10-07
    {
      "headers": {
        "authorization": "Bearer <ключ>"
      }
    }
    {
      "rows": [
        {
          "id": "b6f7fe44-9a92-4274-b446-ddcdb10c82d2",
          "valid_from": "2025-11-03",
          "payload": "{\"legalName\":\"Товариство з обмеженою відповідальністю «Крило і Гвинт»\",\"shortName\":\"ТОВ «Крило і Гвинт»\",\"registrationNumber\":\"99000011\",\"vatNumber\":\"990000113067\",\"legalAddress\":\"79060, м. Львів, вул. Наукова, 7а\",\"iban\":\"UA783999900000002600701045128\",\"bankName\":\"АТ «Перший Прикладний Банк»\",\"directorName\":\"Сидорук Марія Василівна\",\"directorPosition\":\"Директор\",\"accountantName\":\"Луцик Богдан Ігорович\",\"accountantPosition\":\"Головний бухгалтер\",\"phone\":\"+380 32 000 44 10\",\"email\":\"office@krylo-i-hvynt.example\"}",
          "actor_id": "key:4e85ac04-cbc2-4060-bc6b-41006855c12d",
          "created_at": "2026-10-07T18:25:56.542Z"
        }
      ]
    }
    curl
    curl 'https://demokrylo.bnp.works/api/v1/q/company_profile?as_of=2026-10-07' \
      -H 'authorization: Bearer <ключ>'

Як зробити так само

Ця сторінка - окремий Worker без бази. Вона знає адресу ERP і один ключ; усе інше питає через API.