📘
Сток поставщиков
suppliers
supply_chain
🛡️ RLS Protected
Стектор поставщиков <unk> процессуальная и API-документация, полученная из кода.
Fachliche Bestimmung: Стектор поставщиков <unk> процессовая и API-документация, полученная из кода.
⚡ Рабочие процессы и жизненные циклы (1)
🗄️ Модели данных & поля (3)
🔌 Входные пункты (UI & API) (7)
🛡️ Регуляторство и соответствие
⚡ Рабочие процессы и жизненные циклы
Приказ пользователя: поставщик сырьевой субгент
plan:command_supplier_crud_subagent
Проверенный план длительности (durable_plan), старт: manual_command.
1. supplier_crud_subagent
supplier_crud_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "supplier_crud_subagent", "condition_fact": null}
Aktionen: supplier_crud_subagent
🗄️ Модели данных & поля
SupplierQuoteLines
supplier_quote_lines
RLS Aktiv
12 Поле / столбцы
Tabelle supplier_quote_lines
| Feldname | Тип данных | Обязательность | Schlüssel | Профессиональное значение |
|---|---|---|---|---|
quote_id
|
UUID |
Ja * | FK ➔ supplier_quotes.id | Feld quote_id |
rfq_line_id
|
UUID |
Nein | FK ➔ purchase_rfq_lines.id | Feld rfq_line_id |
description
|
TEXT |
Ja * | - | Feld description |
quantity
|
NUMERIC(14, 4) |
Ja * | - | Feld quantity |
unit_price
|
NUMERIC(14, 2) |
Ja * | - | Feld unit_price |
tax_rate
|
NUMERIC(6, 4) |
Nein | - | Feld tax_rate |
lead_time_days
|
INTEGER |
Nein | - | Feld lead_time_days |
id
|
UUID |
Nein | PK | Feld id |
tenant_id
|
UUID |
Ja * | FK ➔ organizations.id | Feld tenant_id |
created_at
|
DATETIME |
Ja * | - | Feld created_at |
updated_at
|
DATETIME |
Ja * | - | Feld updated_at |
metadata
|
JSONB |
Ja * | - | Feld metadata |
SupplierQuotes
supplier_quotes
RLS Aktiv
16 Поле / столбцы
Tabelle supplier_quotes
| Feldname | Тип данных | Обязательность | Schlüssel | Профессиональное значение |
|---|---|---|---|---|
rfq_id
|
UUID |
Ja * | FK ➔ purchase_rfqs.id | Feld rfq_id |
supplier_id
|
UUID |
Ja * | FK ➔ suppliers.id | Feld supplier_id |
status
|
VARCHAR(48) |
Ja * | - | Feld status |
quote_number_external
|
VARCHAR(128) |
Nein | - | Feld quote_number_external |
currency
|
VARCHAR(3) |
Ja * | - | Feld currency |
valid_until
|
DATE |
Nein | - | Feld valid_until |
notes
|
TEXT |
Nein | - | Feld notes |
id
|
UUID |
Nein | PK | Feld id |
tenant_id
|
UUID |
Ja * | FK ➔ organizations.id | Feld tenant_id |
created_at
|
DATETIME |
Ja * | - | Feld created_at |
updated_at
|
DATETIME |
Ja * | - | Feld updated_at |
created_by
|
UUID |
Nein | - | Feld created_by |
updated_by
|
UUID |
Nein | - | Feld updated_by |
source_type
|
VARCHAR(32) |
Nein | - | Feld source_type |
source_id
|
UUID |
Nein | - | Feld source_id |
metadata
|
JSONB |
Ja * | - | Feld metadata |
Suppliers
suppliers
RLS Aktiv
35 Поле / столбцы
Tabelle suppliers
| Feldname | Тип данных | Обязательность | Schlüssel | Профессиональное значение |
|---|---|---|---|---|
name
|
VARCHAR(255) |
Ja * | - | Feld name |
supplier_number
|
VARCHAR(64) |
Nein | - | Feld supplier_number |
normalized_name
|
VARCHAR(255) |
Ja * | - | Feld normalized_name |
vat_id
|
VARCHAR(32) |
Nein | - | Feld vat_id |
tax_id
|
VARCHAR(32) |
Nein | - | Feld tax_id |
iban
|
VARCHAR(34) |
Nein | - | Feld iban |
email
|
VARCHAR(320) |
Nein | - | Feld email |
phone
|
VARCHAR(64) |
Nein | - | Feld phone |
website
|
VARCHAR(255) |
Nein | - | Feld website |
street
|
VARCHAR(255) |
Nein | - | Feld street |
postal_code
|
VARCHAR(16) |
Nein | - | Feld postal_code |
city
|
VARCHAR(128) |
Nein | - | Feld city |
country_code
|
VARCHAR(2) |
Nein | - | Feld country_code |
latitude
|
NUMERIC(9, 6) |
Nein | - | Feld latitude |
longitude
|
NUMERIC(9, 6) |
Nein | - | Feld longitude |
default_expense_category
|
VARCHAR(64) |
Nein | - | Feld default_expense_category |
payable_account_code
|
VARCHAR(32) |
Nein | - | Feld payable_account_code |
peppol_endpoint_id
|
VARCHAR(64) |
Nein | - | Feld peppol_endpoint_id |
peppol_endpoint_scheme
|
VARCHAR(16) |
Nein | - | Feld peppol_endpoint_scheme |
external_reference
|
VARCHAR(128) |
Nein | - | Feld external_reference |
adr_certified
|
BOOLEAN |
Ja * | - | Feld adr_certified |
purchase_grouping_mode
|
VARCHAR(32) |
Ja * | - | Feld purchase_grouping_mode |
status
|
VARCHAR(48) |
Ja * | - | Feld status |
detection_confidence
|
NUMERIC(4, 3) |
Nein | - | Feld detection_confidence |
notes
|
TEXT |
Nein | - | Feld notes |
id
|
UUID |
Nein | PK | Feld id |
tenant_id
|
UUID |
Ja * | FK ➔ organizations.id | Feld tenant_id |
created_at
|
DATETIME |
Ja * | - | Feld created_at |
updated_at
|
DATETIME |
Ja * | - | Feld updated_at |
created_by
|
UUID |
Nein | - | Feld created_by |
updated_by
|
UUID |
Nein | - | Feld updated_by |
source_type
|
VARCHAR(32) |
Nein | - | Feld source_type |
source_id
|
UUID |
Nein | - | Feld source_id |
metadata
|
JSONB |
Ja * | - | Feld metadata |
deleted_at
|
DATETIME |
Nein | - | Feld deleted_at |
🔌 Входные пункты (UI & API)
| Art | Метод | Конечный пункт / путь | Titel & Zweck | Право на |
|---|---|---|---|---|
| ⚡ REST API | DELETE | /api/v1/suppliers/{supplier_id} |
delete_supplier
Semantic binding: not_evaluated; mutation=True
|
suppliers
|
| ⚡ REST API | GET | /api/v1/suppliers |
list_suppliers
Semantic binding: not_evaluated; mutation=False
|
suppliers
|
| ⚡ REST API | GET | /api/v1/suppliers/matches |
match_suppliers
Semantic binding: not_evaluated; mutation=False
|
suppliers
|
| ⚡ REST API | GET | /api/v1/suppliers/{supplier_id} |
get_supplier
Semantic binding: not_evaluated; mutation=False
|
suppliers
|
| ⚡ REST API | GET | /suppliers/{supplier_id} |
supplier_detail_page
Semantic binding: not_evaluated; mutation=False
|
suppliers
|
| ⚡ REST API | PATCH | /api/v1/suppliers/{supplier_id} |
update_supplier
Semantic binding: not_evaluated; mutation=True
|
suppliers
|
| ⚡ REST API | POST | /api/v1/suppliers |
create_supplier
Semantic binding: not_evaluated; mutation=True
|
suppliers
|
🛡️ Регуляторство и соответствие
Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:
- Проверяемость
- Изоляция клиентов (PostgreSQL RLS)