📘

Supplier stock

suppliers supply_chain 🛡️ RLS Protected

Supplier stock <unk> process and API documentation derived from code.

Fachliche Bestimmung: Supplier's main source <unk> process and API documentation derived from code. Includes all registered processes, capabilities, state machines, APIs and tables for simulations and reviews.

⚡ Workflows and life cycles (1) 🗄️ Data models and fields (3) 🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. (7) 🛡️ Regulatory and compliance

⚡ Workflows and life cycles

Manufacture from materials of heading No 790 `plan:command_supplier_crud_subagent`

The following is the list of the main functions of the system:

1. supplier_crud_subagent

supplier_crud_subagent

The following is the list of the products:

Aktionen: supplier_crud_subagent

🗄️ Data models and fields

SupplierQuoteLines supplier_quote_lines RLS Aktiv

12 Fields and columns

Tabelle supplier_quote_lines

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle supplier_quotes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle suppliers

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

Art	The method	Endpoint / path	Titel & Zweck	The Commission shall adopt the following:
⚡ 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`

🛡️ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards: