📘
El importe de la ayuda será igual a la de la ayuda.
suppliers
supply_chain
🛡️ RLS Protected
Los datos de los proveedores se basan en los datos de los proveedores.
Fachliche Bestimmung: El código de suministro de datos de los proveedores <unk> documentación de procesos y API derivada del código.
⚡ Flujos de trabajo y ciclos de vida (1)
🗄️ Modelos de datos y campos (3)
🔌 Puntos de inicio (UI y API) (7)
🛡️ Regulación y cumplimiento
⚡ Flujos de trabajo y ciclos de vida
En el caso de los productos de la industria de la Unión, el producto de la industria de la Unión debe ser exportado a la Unión.
plan:command_supplier_crud_subagent
Plan durable comprobado (durable_plan), inicio: manual_command.
1. supplier_crud_subagent
supplier_crud_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: supplier_crud_subagent
🗄️ Modelos de datos y campos
SupplierQuoteLines
supplier_quote_lines
RLS Aktiv
12 Cálculos y columnas
Tabelle supplier_quote_lines
| Feldname | Tipo de datos | Obligado | Schlüssel | Importancia profesional |
|---|---|---|---|---|
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 Cálculos y columnas
Tabelle supplier_quotes
| Feldname | Tipo de datos | Obligado | Schlüssel | Importancia profesional |
|---|---|---|---|---|
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 Cálculos y columnas
Tabelle suppliers
| Feldname | Tipo de datos | Obligado | Schlüssel | Importancia profesional |
|---|---|---|---|---|
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 |
🔌 Puntos de inicio (UI y API)
| Art | El método | Punto final / camino | Titel & Zweck | Reacción |
|---|---|---|---|---|
| ⚡ 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
|
🛡️ Regulación y cumplimiento
Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:
- La Comisión ha adoptado una decisión en el marco de la cual se ha adoptado una decisión.
- El sistema de gestión de los datos de los clientes (postgreSQL RLS)