📘

Les produits de la catégorie "produits"

suppliers supply_chain 🛡️ RLS Protected

Les documents de processus et d'API dérivés du code

Fachliche Bestimmung: Les données relatives aux processus et aux API dérivées du code comprennent tous les processus, capacités, machines d'état, API et tables de simulation et d'examen enregistrés.

⚡ Flux de travail et cycles de vie (1) 🗄️ Modèles de données (3) 🔌 Les points d'entrée (UI et API) (7) 🛡️ Réglementation et conformité

⚡ Flux de travail et cycles de vie

Règlement d'utilisation: fournisseur de subagent brut `plan:command_supplier_crud_subagent`

Plan durable vérifié (durable_plan), démarrage: manuel_command.

1. supplier_crud_subagent

supplier_crud_subagent

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Aktionen: supplier_crud_subagent

🗄️ Modèles de données

SupplierQuoteLines supplier_quote_lines RLS Aktiv

12 Les champs / colonnes

Tabelle supplier_quote_lines

Feldname	Type de données	Le dépôt	Schlüssel	Importance professionnelle
`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 Les champs / colonnes

Tabelle supplier_quotes

Feldname	Type de données	Le dépôt	Schlüssel	Importance professionnelle
`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 Les champs / colonnes

Tabelle suppliers

Feldname	Type de données	Le dépôt	Schlüssel	Importance professionnelle
`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

🔌 Les points d'entrée (UI et API)

Art	Le mode de fonctionnement	Point de fin / parcours	Titel & Zweck	Leur
⚡ REST API	DELETE	`/api/v1/suppliers/{supplier_id}`	delete_supplier Semantic binding: operator_surface; mutation=True	`suppliers`
⚡ REST API	GET	`/api/v1/suppliers`	list_suppliers Semantic binding: inventory_only; mutation=False	`suppliers`
⚡ REST API	GET	`/api/v1/suppliers/matches`	match_suppliers Semantic binding: inventory_only; mutation=False	`suppliers`
⚡ REST API	GET	`/api/v1/suppliers/{supplier_id}`	get_supplier Semantic binding: inventory_only; mutation=False	`suppliers`
⚡ REST API	GET	`/suppliers/{supplier_id}`	supplier_detail_page Semantic binding: inventory_only; mutation=False	`suppliers`
⚡ REST API	PATCH	`/api/v1/suppliers/{supplier_id}`	update_supplier Semantic binding: operator_surface; mutation=True	`suppliers`
⚡ REST API	POST	`/api/v1/suppliers`	create_supplier Semantic binding: operator_surface; mutation=True	`suppliers`

🛡️ Réglementation et conformité

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards: