Опис, який 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": [
"sales",
"purchaser",
"accountant"
],
"tables": [
"party_identifier",
"party",
"party_role"
]
},
{
"name": "party_profile",
"params": [
"party_id",
"as_of"
],
"roles": [
"sales",
"purchaser",
"accountant"
],
"tables": [
"party_profile"
]
},
{
"name": "party_profile_history",
"params": [
"party_id"
],
"roles": [
"sales",
"purchaser",
"accountant"
],
"tables": [
"party_profile"
]
},
{
"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_counts",
"params": [],
"roles": [
"viewer",
"storekeeper",
"sales",
"purchaser",
"production",
"accountant"
],
"tables": [
"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": "sale_offer",
"params": [],
"roles": [
"sales",
"accountant"
],
"tables": [
"bom_line",
"bom_operation",
"item",
"bom",
"so_line",
"sales_order"
]
},
{
"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": "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": "deal_payments",
"params": [
"id"
],
"roles": [
"sales",
"accountant"
],
"tables": [
"document",
"journal_entry",
"ledger_line",
"economic_event"
]
},
{
"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"
]
}
]
}