Опис, який API дає про себе. Тримається в памʼяті десять хвилин.
показати запит і відповідь
GET /api/v1/queries
{
"headers": {
"authorization": "Bearer <ключ>"
}
}{
"queries": [
{
"name": "dashboard_stats",
"params": [],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"account"
]
},
{
"name": "party_role_counts",
"params": [],
"roles": [
"accountant"
],
"tables": [
"party_role"
]
},
{
"name": "trial_balance",
"params": [],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"account"
]
},
{
"name": "accounts",
"params": [],
"roles": [
"viewer",
"storekeeper",
"sales",
"purchaser",
"production",
"accountant"
],
"tables": [
"account"
]
},
{
"name": "journal",
"params": [],
"roles": [
"accountant"
],
"tables": [
"journal_line",
"document",
"journal_entry",
"economic_event",
"rule_snapshot",
"party"
]
},
{
"name": "journal_latest",
"params": [],
"roles": [
"accountant"
],
"tables": [
"journal_line",
"document",
"journal_entry",
"economic_event",
"rule_snapshot",
"party"
]
},
{
"name": "entry",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"party",
"app_user",
"api_key",
"journal_entry",
"economic_event",
"period",
"rule_snapshot"
]
},
{
"name": "entry_lines",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"document",
"journal_line",
"account",
"party"
]
},
{
"name": "periods",
"params": [],
"roles": [
"viewer",
"storekeeper",
"sales",
"purchaser",
"production",
"accountant"
],
"tables": [
"journal_entry",
"period"
]
},
{
"name": "rule_snapshots",
"params": [],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"rule_snapshot"
]
},
{
"name": "parties_by_role",
"params": [
"role"
],
"roles": [
"sales",
"purchaser",
"accountant"
],
"tables": [
"party_identifier",
"party",
"party_role"
]
},
{
"name": "parties",
"params": [],
"roles": [
"accountant"
],
"tables": [
"party_role",
"party_identifier",
"party"
]
},
{
"name": "party",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"party"
]
},
{
"name": "party_roles_for",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"party_role"
]
},
{
"name": "party_by_identifier",
"params": [
"scheme",
"value"
],
"roles": [
"accountant"
],
"tables": [
"party_identifier",
"party"
]
},
{
"name": "parties_by_scheme",
"params": [
"scheme",
"kind",
"date"
],
"roles": [
"accountant"
],
"tables": [
"agreement",
"party_identifier",
"party"
]
},
{
"name": "agreements_by_scheme",
"params": [
"scheme",
"kind",
"role"
],
"roles": [
"accountant"
],
"tables": [
"party_role",
"party_identifier",
"party",
"agreement"
]
},
{
"name": "party_identifiers_for",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"party_identifier"
]
},
{
"name": "party_requisites",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"party_identifier",
"party"
]
},
{
"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": "agreements_for_party",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"agreement"
]
},
{
"name": "ledger_for_party",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"document",
"ledger_line",
"account"
]
},
{
"name": "party_balances",
"params": [
"role",
"account"
],
"roles": [
"accountant"
],
"tables": [
"party",
"party_role",
"ledger_line"
]
},
{
"name": "documents_open",
"params": [
"kind",
"account"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"document",
"economic_event",
"party",
"open_item"
]
},
{
"name": "open_items_for_party",
"params": [
"account",
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"open_item"
]
},
{
"name": "events_by_kind",
"params": [
"kind"
],
"roles": [
"accountant"
],
"tables": [
"journal_line",
"document",
"event_number",
"journal_entry",
"economic_event",
"party",
"rule_snapshot"
]
},
{
"name": "events_by_kind_page",
"params": [
"kind",
"offset"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event",
"party",
"rule_snapshot"
]
},
{
"name": "event",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event"
]
},
{
"name": "agreements_on",
"params": [
"kind",
"date"
],
"roles": [
"accountant"
],
"tables": [
"agreement",
"party"
]
},
{
"name": "agreements_between",
"params": [
"kind",
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"agreement",
"party"
]
},
{
"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": "item_purchase_lines",
"params": [
"item_id"
],
"roles": [
"accountant"
],
"tables": [
"po_line",
"purchase_order",
"party",
"po_line_received"
]
},
{
"name": "item_sales_lines",
"params": [
"item_id"
],
"roles": [
"accountant"
],
"tables": [
"so_line",
"sales_order",
"party",
"so_line_shipped"
]
},
{
"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": "delivery_receipts",
"params": [
"event_id"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event"
]
},
{
"name": "receipts_for_order",
"params": [
"id"
],
"roles": [
"storekeeper",
"sales",
"purchaser",
"production",
"accountant"
],
"tables": [
"event_number",
"journal_entry",
"economic_event"
]
},
{
"name": "open_advances",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"open_item"
]
},
{
"name": "bank_accounts",
"params": [],
"roles": [
"accountant"
],
"tables": [
"bank_account"
]
},
{
"name": "bank_lines",
"params": [
"status"
],
"roles": [
"accountant"
],
"tables": [
"bank_statement_line",
"bank_account"
]
},
{
"name": "parties_for_matching",
"params": [],
"roles": [
"accountant"
],
"tables": [
"party_identifier",
"party_role",
"party"
]
},
{
"name": "open_documents",
"params": [
"account"
],
"roles": [
"accountant"
],
"tables": [
"open_item",
"document",
"economic_event"
]
},
{
"name": "bank_feed",
"params": [
"status"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"bank_statement_line",
"bank_account",
"payment_order",
"bank_line_link"
]
},
{
"name": "bank_posted_lines",
"params": [
"account",
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"bank_line_link",
"bank_account",
"economic_event",
"journal_entry",
"journal_line",
"bank_statement_line"
]
},
{
"name": "bank_unreconciled",
"params": [
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"journal_entry",
"journal_line",
"bank_statement_line",
"bank_account",
"bank_line_link",
"document",
"party"
]
},
{
"name": "payment_orders",
"params": [
"status"
],
"roles": [
"accountant"
],
"tables": [
"bank_account",
"ledger_line",
"bank_statement_line",
"payment_order",
"document",
"journal_entry",
"party"
]
},
{
"name": "payment_order",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"bank_account",
"ledger_line",
"bank_statement_line",
"payment_order",
"document",
"journal_entry",
"party"
]
},
{
"name": "payment_batches",
"params": [
"status"
],
"roles": [
"accountant"
],
"tables": [
"payment_order"
]
},
{
"name": "outbox",
"params": [
"kind",
"status"
],
"roles": [
"accountant"
],
"tables": [
"payment_order",
"outbox"
]
},
{
"name": "payment_orders_by_step",
"params": [
"key"
],
"roles": [
"accountant"
],
"tables": [
"payment_order_step",
"payment_order"
]
},
{
"name": "payment_order_steps",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"payment_order_step"
]
},
{
"name": "payables_open",
"params": [
"account",
"measure"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"economic_event",
"open_item",
"document",
"payment_order",
"party_identifier",
"party"
]
},
{
"name": "payables_by_spec",
"params": [
"spec",
"measure"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"economic_event",
"journal_entry",
"payment_order",
"payment_receiver"
]
},
{
"name": "payment_receivers",
"params": [],
"roles": [
"accountant"
],
"tables": [
"payment_receiver"
]
},
{
"name": "party_payment_requisites",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"party_identifier",
"party"
]
},
{
"name": "receivers",
"params": [
"role"
],
"roles": [
"accountant"
],
"tables": [
"party_identifier",
"party_role",
"party"
]
},
{
"name": "cash_book",
"params": [],
"roles": [
"accountant"
],
"tables": [
"document",
"ledger_line",
"journal_entry"
]
},
{
"name": "trial_balance_period",
"params": [
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"account"
]
},
{
"name": "account_turnovers",
"params": [
"from",
"to",
"exclude_kinds"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event",
"ledger_line",
"account"
]
},
{
"name": "account_turnovers_of",
"params": [
"from",
"to",
"exclude_kinds",
"account"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event",
"journal_line",
"account"
]
},
{
"name": "account_party_turnovers",
"params": [
"from",
"to",
"exclude_kinds"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event",
"ledger_line",
"account",
"party"
]
},
{
"name": "account_party_turnovers_of",
"params": [
"from",
"to",
"exclude_kinds",
"account"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event",
"journal_line",
"account",
"party"
]
},
{
"name": "account_month_turnovers",
"params": [
"from",
"to",
"exclude_kinds"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event",
"ledger_line"
]
},
{
"name": "account_card",
"params": [
"account",
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"document",
"journal_line",
"journal_entry",
"economic_event",
"party"
]
},
{
"name": "account_card_page",
"params": [
"account",
"from",
"to",
"limit",
"offset"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"journal_line",
"document",
"economic_event",
"party"
]
},
{
"name": "account_card_sums",
"params": [
"account",
"from",
"to",
"offset"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"journal_line"
]
},
{
"name": "account_card_pages",
"params": [
"account",
"from",
"to",
"size"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"journal_line"
]
},
{
"name": "cash_movements",
"params": [
"from",
"to",
"accounts"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event",
"ledger_line",
"document",
"account",
"party"
]
},
{
"name": "events_in_period",
"params": [
"kind",
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"document",
"journal_entry",
"economic_event",
"party"
]
},
{
"name": "financial_statement",
"params": [
"form",
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"journal_entry",
"journal_line",
"report_map",
"report_line"
]
},
{
"name": "balance_check",
"params": [
"as_of"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"report_map",
"report_line"
]
},
{
"name": "unmapped_accounts",
"params": [
"as_of"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"account",
"report_map"
]
},
{
"name": "aging",
"params": [
"account",
"as_of"
],
"roles": [
"accountant"
],
"tables": [
"open_item",
"party"
]
},
{
"name": "stock_reconciliation",
"params": [],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"stock_account"
]
},
{
"name": "stock_balance_drift",
"params": [],
"roles": [
"accountant"
],
"tables": [
"stock_balance",
"journal_line",
"journal_entry",
"stock_account",
"item",
"location"
]
},
{
"name": "reservation_balance_drift",
"params": [],
"roles": [
"accountant"
],
"tables": [
"reservation_balance",
"reservation_move",
"production_order",
"item"
]
},
{
"name": "production_order_made_drift",
"params": [],
"roles": [
"accountant"
],
"tables": [
"production_order_made",
"economic_event",
"journal_entry",
"production_order"
]
},
{
"name": "stock_balance_check",
"params": [],
"roles": [
"accountant"
],
"tables": [
"stock_balance",
"journal_line",
"journal_entry",
"stock_account",
"item",
"location",
"reservation_balance",
"reservation_move",
"production_order",
"production_order_made",
"economic_event"
]
},
{
"name": "fixed_assets",
"params": [],
"roles": [
"accountant"
],
"tables": [
"depreciation_run",
"fixed_asset"
]
},
{
"name": "income_expense_balances",
"params": [
"to"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line"
]
},
{
"name": "currency_balances",
"params": [
"as_of"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line"
]
},
{
"name": "rate_on",
"params": [
"currency",
"date"
],
"roles": [
"accountant"
],
"tables": [
"exchange_rate"
]
},
{
"name": "exchange_rates",
"params": [],
"roles": [
"accountant"
],
"tables": [
"exchange_rate"
]
},
{
"name": "account_balances_by_party",
"params": [
"account"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"journal_entry",
"party"
]
},
{
"name": "receipt_lines",
"params": [
"event_id"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"journal_line",
"stock_account",
"item",
"location"
]
},
{
"name": "receipt_trace",
"params": [
"event_id"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"journal_line",
"item",
"stock_account"
]
},
{
"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": "instrument_asset_options",
"params": [
"equipment_id"
],
"roles": [
"production",
"accountant"
],
"tables": [
"fixed_asset",
"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": "sequence_last",
"params": [
"series",
"year"
],
"roles": [
"accountant"
],
"tables": [
"sequence"
]
},
{
"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_move_values",
"params": [
"item_id"
],
"roles": [
"accountant"
],
"tables": [
"journal_line",
"item",
"journal_entry",
"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": "trace_events",
"params": [
"from",
"to",
"kind",
"actor",
"party"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"document",
"economic_event",
"incoming_tax_invoice",
"journal_line",
"item",
"party"
]
},
{
"name": "trace_event_kinds",
"params": [
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"economic_event"
]
},
{
"name": "trace_months",
"params": [
"actor",
"party"
],
"roles": [
"accountant"
],
"tables": [
"economic_event"
]
},
{
"name": "trace_actors",
"params": [],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"change_log"
]
},
{
"name": "trace_actor_counts",
"params": [
"actor"
],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"change_log"
]
},
{
"name": "trace_changes",
"params": [
"from",
"to",
"actor",
"table"
],
"roles": [
"accountant"
],
"tables": [
"party",
"item",
"location",
"site",
"purchase_request",
"purchase_order",
"sales_order",
"production_order",
"bom",
"change_order",
"agreement",
"tax_invoice",
"incoming_tax_invoice",
"fixed_asset",
"change_log"
]
},
{
"name": "trace_employees",
"params": [],
"roles": [
"accountant"
],
"tables": [
"party_role",
"party"
]
},
{
"name": "trace_payroll_lines",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event"
]
},
{
"name": "trace_party_items",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"journal_line",
"item",
"journal_entry",
"economic_event",
"stock_account"
]
},
{
"name": "trace_documents",
"params": [],
"roles": [
"accountant"
],
"tables": [
"document",
"economic_event",
"party"
]
},
{
"name": "trace_chain",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"po_line",
"economic_event",
"production_order",
"sales_order",
"journal_line",
"journal_entry",
"document",
"tax_invoice",
"incoming_tax_invoice",
"purchase_request",
"purchase_order",
"item",
"so_line",
"purchase_request_line",
"party"
]
},
{
"name": "trace_chain_links",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"po_line",
"economic_event",
"production_order",
"sales_order",
"journal_line",
"journal_entry",
"document",
"tax_invoice",
"incoming_tax_invoice",
"purchase_request",
"purchase_order"
]
},
{
"name": "accountable_balances",
"params": [],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"party"
]
},
{
"name": "overhead_balance",
"params": [
"period"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line"
]
},
{
"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": "company_settings",
"params": [],
"roles": [
"accountant"
],
"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": "payment_offer",
"params": [
"document_id"
],
"roles": [
"accountant"
],
"tables": [
"open_item",
"sales_order",
"document",
"party"
]
},
{
"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": "sales_order_dated",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order"
]
},
{
"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": "print_document",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"journal_line",
"journal_entry",
"document",
"economic_event"
]
},
{
"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": "supplier_payable_open",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line"
]
},
{
"name": "supplier_advance_open",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line"
]
},
{
"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": "company_profile_history",
"params": [],
"roles": [
"accountant"
],
"tables": [
"company_profile"
]
},
{
"name": "parameters",
"params": [
"area"
],
"roles": [
"accountant"
],
"tables": [
"parameter"
]
},
{
"name": "proposals_by_module",
"params": [
"module",
"status"
],
"roles": [
"accountant"
],
"tables": [
"proposal"
]
},
{
"name": "proposal",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"proposal"
]
},
{
"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_assignments",
"params": [
"date"
],
"roles": [
"production",
"accountant"
],
"tables": [
"work_center_assignment",
"party",
"work_center"
]
},
{
"name": "floor_assignments_between",
"params": [
"from",
"to"
],
"roles": [
"production",
"accountant"
],
"tables": [
"agreement",
"work_center_assignment",
"party",
"work_center"
]
},
{
"name": "floor_person_assignments",
"params": [
"party_id"
],
"roles": [
"production",
"accountant"
],
"tables": [
"work_center_assignment",
"work_center"
]
},
{
"name": "floor_leave",
"params": [
"from",
"to"
],
"roles": [
"production",
"accountant"
],
"tables": [
"economic_event"
]
},
{
"name": "floor_records",
"params": [
"party_id",
"work_center_id",
"from",
"to"
],
"roles": [
"production",
"accountant"
],
"tables": [
"operation_live",
"work_center",
"production_order",
"item",
"serial_number",
"bom_operation",
"party"
]
},
{
"name": "floor_outputs",
"params": [
"from",
"to"
],
"roles": [
"production",
"accountant"
],
"tables": [
"economic_event",
"journal_entry",
"operation_live",
"production_order",
"item",
"bom_operation",
"work_center"
]
},
{
"name": "floor_person_documents",
"params": [
"party_id",
"from",
"to"
],
"roles": [
"production",
"accountant"
],
"tables": [
"document",
"economic_event",
"app_user",
"change_log"
]
},
{
"name": "floor_people",
"params": [
"date"
],
"roles": [
"production",
"accountant"
],
"tables": [
"work_center_assignment",
"work_center",
"party",
"agreement"
]
},
{
"name": "floor_person",
"params": [
"party_id"
],
"roles": [
"production",
"accountant"
],
"tables": [
"party"
]
},
{
"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": "deal_trail_examples",
"params": [],
"roles": [
"accountant"
],
"tables": [
"document",
"journal_entry",
"production_order",
"so_line",
"sales_order",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party"
]
},
{
"name": "deal_trail",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"change_log",
"request"
]
},
{
"name": "deal_trail_items",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration"
]
},
{
"name": "deal_trail_production",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"change_log",
"reservation_move",
"location",
"production_order_release"
]
},
{
"name": "deal_trail_work",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"bom_operation",
"operation_work",
"work_center"
]
},
{
"name": "deal_trail_units",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"serial_number",
"qc_protocol"
]
},
{
"name": "deal_trail_papers",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"document_step",
"tax_invoice",
"bank_statement_line",
"bank_line_link"
]
},
{
"name": "deal_trail_supply",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"change_log",
"purchase_request",
"purchase_order"
]
},
{
"name": "deal_trail_events",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"incoming_tax_invoice"
]
},
{
"name": "deal_trail_ledger",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"account",
"location"
]
},
{
"name": "deal_trail_moves",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration",
"location"
]
},
{
"name": "deal_trail_state",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"sales_order",
"document",
"journal_entry",
"production_order",
"so_line",
"request_outcome",
"journal_line",
"economic_event",
"import_declaration_line",
"item",
"party",
"po_line",
"stock_account",
"import_declaration"
]
},
{
"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"
]
},
{
"name": "tax_invoices",
"params": [],
"roles": [
"accountant"
],
"tables": [
"tax_invoice",
"party"
]
},
{
"name": "tax_invoices_waiting",
"params": [],
"roles": [
"accountant"
],
"tables": [
"tax_invoice"
]
},
{
"name": "tax_invoice",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"document",
"tax_invoice",
"economic_event"
]
},
{
"name": "vat_events_without_tax_invoice",
"params": [],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"journal_entry",
"tax_invoice"
]
},
{
"name": "vat_summary",
"params": [
"period"
],
"roles": [
"accountant"
],
"tables": [
"import_declaration",
"economic_event",
"ledger_line",
"tax_invoice"
]
},
{
"name": "vat_declaration",
"params": [
"period"
],
"roles": [
"accountant"
],
"tables": [
"tax_invoice",
"incoming_tax_invoice",
"import_tax_register",
"ledger_line",
"economic_event"
]
},
{
"name": "vat_check",
"params": [
"period"
],
"roles": [
"accountant"
],
"tables": [
"import_declaration",
"economic_event",
"ledger_line",
"tax_invoice",
"incoming_tax_invoice",
"import_tax_register"
]
},
{
"name": "month_close_checklist",
"params": [
"period"
],
"roles": [
"accountant"
],
"tables": [
"bank_statement_line",
"economic_event",
"journal_entry",
"tax_invoice",
"fixed_asset",
"depreciation_run",
"stock_account",
"ledger_line"
]
},
{
"name": "month_close_more",
"params": [
"period",
"pay_accounts",
"monetary"
],
"roles": [
"accountant"
],
"tables": [
"payment_order",
"economic_event",
"journal_entry",
"agreement",
"ledger_line",
"exchange_rate",
"journal_line",
"bank_statement_line",
"bank_account",
"bank_line_link"
]
},
{
"name": "import_receipts_open",
"params": [],
"roles": [
"accountant"
],
"tables": [
"journal_line",
"stock_account",
"economic_event",
"journal_entry",
"party",
"import_declaration"
]
},
{
"name": "import_declarations",
"params": [],
"roles": [
"accountant"
],
"tables": [
"document",
"economic_event",
"import_declaration",
"party",
"journal_entry",
"import_declaration_line",
"import_cost_line"
]
},
{
"name": "customs_offices",
"params": [
"kind"
],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"import_declaration"
]
},
{
"name": "import_declaration_of_event",
"params": [
"event_id"
],
"roles": [
"accountant"
],
"tables": [
"import_declaration"
]
},
{
"name": "import_declarations_standing",
"params": [],
"roles": [
"accountant"
],
"tables": [
"document",
"economic_event",
"import_declaration",
"party",
"journal_entry",
"import_declaration_line",
"import_cost_line"
]
},
{
"name": "import_declaration",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"document",
"economic_event",
"import_declaration",
"party",
"journal_entry",
"import_declaration_line",
"import_cost_line"
]
},
{
"name": "import_declaration_of_receipt",
"params": [
"event_id"
],
"roles": [
"accountant"
],
"tables": [
"document",
"economic_event",
"import_declaration",
"party",
"journal_entry",
"import_declaration_line",
"import_cost_line"
]
},
{
"name": "import_declaration_lines",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"import_declaration_line",
"item",
"location",
"import_cost_line"
]
},
{
"name": "import_declaration_costs",
"params": [
"id"
],
"roles": [
"accountant"
],
"tables": [
"import_declaration",
"economic_event",
"journal_entry",
"party"
]
},
{
"name": "supplier_vat_status",
"params": [],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"party"
]
},
{
"name": "tax_invoices_in_period",
"params": [
"period"
],
"roles": [
"accountant"
],
"tables": [
"tax_invoice",
"party"
]
},
{
"name": "incoming_tax_invoices_in_period",
"params": [
"period"
],
"roles": [
"accountant"
],
"tables": [
"incoming_tax_invoice",
"party"
]
},
{
"name": "incoming_tax_invoices",
"params": [],
"roles": [
"accountant"
],
"tables": [
"incoming_tax_invoice",
"party"
]
},
{
"name": "last_tax_invoice_for_party",
"params": [
"party_id"
],
"roles": [
"accountant"
],
"tables": [
"tax_invoice"
]
},
{
"name": "tax_profile",
"params": [
"as_of"
],
"roles": [
"accountant"
],
"tables": [
"economic_event"
]
},
{
"name": "tax_profiles",
"params": [],
"roles": [
"accountant"
],
"tables": [
"economic_event"
]
},
{
"name": "party_tax",
"params": [
"as_of"
],
"roles": [
"accountant"
],
"tables": [
"party",
"economic_event"
]
},
{
"name": "tax_base",
"params": [
"from",
"to"
],
"roles": [
"accountant"
],
"tables": [
"ledger_line",
"economic_event"
]
},
{
"name": "tax_accruals",
"params": [],
"roles": [
"accountant"
],
"tables": [
"journal_entry",
"economic_event"
]
},
{
"name": "tax_warnings",
"params": [
"as_of"
],
"roles": [
"accountant"
],
"tables": [
"economic_event",
"ledger_line",
"party",
"document",
"journal_entry"
]
},
{
"name": "month_close_checklist_closing",
"params": [],
"roles": [
"accountant"
],
"tables": [
"period",
"bank_statement_line",
"economic_event",
"journal_entry",
"tax_invoice",
"fixed_asset",
"depreciation_run",
"stock_account",
"ledger_line"
]
}
]
}