Centurio Documents de système et de module
🔍
🏛️ Architecture de plateforme
🇩🇪 Deutsch 🇬🇧 English 🇫🇷 Français 🇪🇸 Español 🇮🇹 Italiano 🇳🇱 Nederlands 🇵🇱 Polski 🇵🇹 Português 🇨🇿 Čeština 🇸🇰 Slovenčina 🇭🇺 Magyar 🇷🇴 Română 🇧🇬 Български 🇬🇷 Ελληνικά 🇩🇰 Dansk 🇫🇮 Suomi 🇸🇪 Svenska 🇱🇹 Lietuvių 🇱🇻 Latviešu 🇪🇪 Eesti 🇭🇷 Hrvatski 🇸🇮 Slovenščina 🇲🇹 Malti 🇮🇪 Gaeilge 🇷🇺 Русский 🇺🇦 Українська 🇹🇷 Türkçe 🇳🇴 Norsk bokmål 🇷🇸 Српски 🇮🇸 Íslenska 🇨🇭 Schwiiz/Suisse
🔑 Login
🏠 Tous les modules / inventory_logistics / Les produits de la Communauté
📦

Les produits de la Communauté

inventory inventory_logistics 🛡️ RLS Protected

Administration hiérarchique des entrepôts, zones, étagères, dépôts, mouvements de stocks, lots et réserves.

Fachliche Bestimmung: Système de gestion des stocks (SLS) à part entière: il établit des structures de stock à plusieurs niveaux (entrepôts principaux, entrepôts extérieurs, entrepôts de véhicules des techniciens).
⚡ Flux de travail et cycles de vie (22) 🗄️ Modèles de données (16) 🔌 Les points d'entrée (UI et API) (102) 🛡️ Réglementation et conformité

⚡ Flux de travail et cycles de vie

Mouvement des stocks et réservation stock_movement_cycle

Le processus physique et comptable de stockage, de réservation et de sortie des marchandises.

graph TD A[Wareneingang] -->|Einbuchen| B[Physischer Lagerbestand] B -->|Auftragsannahme| C[Bestandsreservierung] C -->|Kommissionierung| D[Warenausgangszone] D -->|Versand / Lieferschein| E[Ausgebuchter Bestand]
1. RECEIVE
Accès
Les marchandises sont livrées en quantité au lieu de stockage.
Aktionen: augmentation du stock
2. RESERVE
Réservation
Les commandes des clients sont réservées à la mise en service.
Aktionen: Réduction des stocks disponibles
3. PICK
Commission
Les travailleurs des camps prennent marchandises à l'aide d'une liste numérique.
Aktionen: Réservation de la place de stockage
4. DISPATCH
Export de marchandises
La comptabilisation des produits de sortie réduit définitivement le stock physique.
Aktionen: Produits

Commande de client → Expiration des marchandises cascade:business.customer_order.fulfill

Les cascades (réview_gated)

1. issue
Réservation de la sortie des marchandises
les produits
Aktionen: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2. tour
Plan de tournée de livraison
logistique
Aktionen: create_tour
3. project
- les coûts de l'établissement
projets
Aktionen: link_project
4. task
Exécution / calcul
tâches
Aktionen: create_task

- à l'intérieur de la zone de production cascade:business.delivery_note.intake

Les cascades (réview_gated)

1. stock
Commande de marchandises dans les comptes
les produits
Aktionen: post_goods_receipt
2. tour
Plan de tournée / transport
logistique
Aktionen: create_tour
3. task
Examen / comparaison de l'entrée de marchandises
tâches
Aktionen: create_task
4. qc
Contrôle de la qualité en cas de suspectation de défauts
les produits
Aktionen: qualité. vérifier. créer
5. ticket
Tickets de réclamation en cas de défaut
billets
Aktionen: create_ticket

- les programmes de contrôle de la qualité cascade_target:business.quality.check

Les cascades (réview_gated)

1. cascade
- les programmes de contrôle de la qualité

Commande de marchandises dans les comptes cascade_target:business.stock.inbound

Les cascades (réview_gated)

1. cascade
Commande de marchandises dans les comptes

Exemption des marchandises / saisie des matériaux (projet) cascade_target:business.stock.issue

Les cascades (réview_gated)

1. cascade
Exemption des marchandises / saisie des matériaux (projet)

Commandement d'utilisation: agent de la note de livraison plan:command_delivery_note_agent

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

1. delivery_note_agent
delivery_note_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: delivery_note_agent

Commandement d'utilisation: agent de capture des matières plan:command_material_capture_agent

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

1. material_capture_agent
material_capture_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: material_capture_agent

Commandement d'utilisation: agent général de l'entrepôt plan:command_warehouse_general_agent

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

1. warehouse_general_agent
warehouse_general_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_general_agent

Commandement d'utilisation: sous-élément stockage plan:command_warehouse_inventory_subagent

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

1. warehouse_inventory_subagent
warehouse_inventory_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_inventory_subagent

Direction d'utilisation: sous-produit imprimé sur l'étiquette de stock plan:command_warehouse_label_print_subagent

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

1. warehouse_label_print_subagent
warehouse_label_print_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_label_print_subagent

Règlement d'utilisation: emplacement de stockage plan:command_warehouse_location_crud_subagent

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

1. warehouse_location_crud_subagent
warehouse_location_crud_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_location_crud_subagent

Règlement d'utilisation: sous-agent de retrait partiel de stock plan:command_warehouse_partial_withdrawal_subagent

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

1. warehouse_partial_withdrawal_subagent
warehouse_partial_withdrawal_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_partial_withdrawal_subagent

Commande d'utilisation: sous-agent de sélection de stock plan:command_warehouse_picking_subagent

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

1. warehouse_picking_subagent
warehouse_picking_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_picking_subagent

Commande d'utilisation: sous-compte de stock de stock plan:command_warehouse_stock_count_subagent

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

1. warehouse_stock_count_subagent
warehouse_stock_count_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_stock_count_subagent

Benutzerbefehl: warehouse stock inbound subagent plan:command_warehouse_stock_inbound_subagent

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

1. warehouse_stock_inbound_subagent
warehouse_stock_inbound_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_stock_inbound_subagent

Benutzerbefehl: warehouse stock outbound subagent plan:command_warehouse_stock_outbound_subagent

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

1. warehouse_stock_outbound_subagent
warehouse_stock_outbound_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_stock_outbound_subagent

Règlement d'utilisation: sous-agent de transfert de stock de stock plan:command_warehouse_stock_transfer_subagent

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

1. warehouse_stock_transfer_subagent
warehouse_stock_transfer_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: warehouse_stock_transfer_subagent

Export de marchandises plan:stock_issue_picking

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

1. stock_issue_dispatch_agent
stock_issue_dispatch_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: stock_issue_dispatch_agent

Le débit de l'eau status:crossdock_operation

Les transitions ne sont pas obligatoires <unk> voir validation de service.

1. draft
projet
Statut du projet de la machine de condition à croix-dock.
2. planned
plan
Status «planned» der Zustandsmaschine Cross-Dock.
3. receiving
réception
Statut de réception de la machine de condition à travers le pont.
4. staged
à la main
Le niveau de l'appareil de conditionnement à travers le pont.
5. dispatching
dépêche
Statut <unk>expédition <unk> de la machine de condition à quai.
6. done
à l'heure
Le système de contrôle de la machine de contrôle de l'état de l'équipement est effectué à travers le pont.
7. cancelled
annulé
Le statut de la machine de condition à travers le pont.

Export de marchandises status:stock_issue

Les transitions ne sont pas obligatoires <unk> voir validation de service.

1. draft
projet
Statut de la machine à condition Exit de marchandise.
2. posted
déposé
Statut <unk>posté <unk> de la machine de condition sortie des marchandises.
3. reversed
à l'inverse
Statut de la machine à condition de sortie des marchandises.
4. cancelled
annulé
Statut de la machine de condition de sortie des marchandises.

Réservation des stocks status:stock_reservation

Les transitions ne sont pas obligatoires <unk> voir validation de service.

1. active
actives
Statut <unk>active<unk> de la machine de l'état réservation de stock.
2. fulfilled
réalisé
Statut <unk>completé<unk> de la machine de condition stock réservation.
3. released
dégagé
Statut <unk>délié<unk> de la machine de condition stock réservation.
4. expired
épuisée
Statut <unk>expiré <unk> de la machine de l'état réservation de stock.

🗄️ Modèles de données

CrossdockAllocations crossdock_allocations RLS Aktiv
10 Les champs / colonnes

Tabelle crossdock_allocations

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
operation_id UUID Ja * FK ➔ crossdock_operations.id Feld operation_id
inbound_line_id UUID Ja * FK ➔ crossdock_inbound_lines.id Feld inbound_line_id
outbound_line_id UUID Ja * FK ➔ crossdock_outbound_lines.id Feld outbound_line_id
quantity NUMERIC(14, 4) Ja * - Feld quantity
quantity_shipped NUMERIC(14, 4) Ja * - Feld quantity_shipped
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
CrossdockInboundLines crossdock_inbound_lines RLS Aktiv
19 Les champs / colonnes

Tabelle crossdock_inbound_lines

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
operation_id UUID Ja * FK ➔ crossdock_operations.id Feld operation_id
position INTEGER Ja * - Feld position
purchase_id UUID Nein FK ➔ purchases.id Feld purchase_id
purchase_item_id UUID Nein FK ➔ purchase_items.id Feld purchase_item_id
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
product_id UUID Nein FK ➔ products.id Feld product_id
description VARCHAR(255) Ja * - Feld description
unit VARCHAR(16) Ja * - Feld unit
quantity_expected NUMERIC(14, 4) Ja * - Feld quantity_expected
quantity_received NUMERIC(14, 4) Ja * - Feld quantity_received
quantity_putaway NUMERIC(14, 4) Ja * - Feld quantity_putaway
unit_cost NUMERIC(14, 2) Nein - Feld unit_cost
received_at DATETIME Nein - Feld received_at
goods_receipt_id UUID Nein FK ➔ goods_receipts.id Feld goods_receipt_id
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
CrossdockOperations crossdock_operations RLS Aktiv
30 Les champs / colonnes

Tabelle crossdock_operations

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
operation_number VARCHAR(40) Ja * - Feld operation_number
variant VARCHAR(20) Ja * - Feld variant
status VARCHAR(16) Ja * - Feld status
dock_in_location_id UUID Nein FK ➔ locations.id Feld dock_in_location_id
staging_location_id UUID Nein FK ➔ locations.id Feld staging_location_id
dock_out_location_id UUID Nein FK ➔ locations.id Feld dock_out_location_id
inbound_dock_id UUID Nein FK ➔ warehouse_docks.id Feld inbound_dock_id
outbound_dock_id UUID Nein FK ➔ warehouse_docks.id Feld outbound_dock_id
inbound_slot_id UUID Nein FK ➔ warehouse_dock_slots.id Feld inbound_slot_id
outbound_slot_id UUID Nein FK ➔ warehouse_dock_slots.id Feld outbound_slot_id
inbound_carrier VARCHAR(120) Nein - Feld inbound_carrier
inbound_vehicle VARCHAR(64) Nein - Feld inbound_vehicle
outbound_carrier VARCHAR(120) Nein - Feld outbound_carrier
outbound_vehicle VARCHAR(64) Nein - Feld outbound_vehicle
planned_arrival_at DATETIME Nein - Feld planned_arrival_at
cutoff_at DATETIME Nein - Feld cutoff_at
max_dwell_hours INTEGER Nein - Feld max_dwell_hours
rule_id UUID Nein FK ➔ crossdock_rules.id Feld rule_id
started_at DATETIME Nein - Feld started_at
completed_at DATETIME Nein - Feld completed_at
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
CrossdockOutboundLines crossdock_outbound_lines RLS Aktiv
24 Les champs / colonnes

Tabelle crossdock_outbound_lines

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
operation_id UUID Ja * FK ➔ crossdock_operations.id Feld operation_id
position INTEGER Ja * - Feld position
shipment_ref VARCHAR(64) Ja * - Feld shipment_ref
shipment_id UUID Nein FK ➔ logistics_shipments.id Feld shipment_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
quote_id UUID Nein FK ➔ quotes.id Feld quote_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_id
destination_text VARCHAR(255) Nein - Feld destination_text
product_id UUID Nein FK ➔ products.id Feld product_id
description VARCHAR(255) Ja * - Feld description
unit VARCHAR(16) Ja * - Feld unit
quantity_demanded NUMERIC(14, 4) Ja * - Feld quantity_demanded
quantity_allocated NUMERIC(14, 4) Ja * - Feld quantity_allocated
quantity_shipped NUMERIC(14, 4) Ja * - Feld quantity_shipped
due_at DATETIME Nein - Feld due_at
priority INTEGER Ja * - Feld priority
shipped_at DATETIME Nein - Feld shipped_at
stock_issue_id UUID Nein FK ➔ stock_issues.id Feld stock_issue_id
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
CrossdockRules crossdock_rules RLS Aktiv
15 Les champs / colonnes

Tabelle crossdock_rules

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
name VARCHAR(120) Ja * - Feld name
strategy VARCHAR(16) Ja * - Feld strategy
max_dwell_hours INTEGER Ja * - Feld max_dwell_hours
customer_id UUID Nein FK ➔ customers.id Feld customer_id
active BOOLEAN Ja * - Feld active
note VARCHAR(255) Nein - Feld note
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
IsmAssets ism_assets RLS Aktiv
17 Les champs / colonnes

Tabelle ism_assets

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
code VARCHAR(32) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
category VARCHAR(32) Ja * - Feld category
criticality VARCHAR(16) Ja * - Feld criticality
owner_user_id UUID Nein FK ➔ organization_users.id Feld owner_user_id
description TEXT Nein - Feld description
retired BOOLEAN Ja * - Feld retired
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
IsmAwarenessCourses ism_awareness_courses
9 Les champs / colonnes

Tabelle ism_awareness_courses

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
code VARCHAR(32) Ja * - Feld code
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
validity_months INTEGER Ja * - Feld validity_months
active BOOLEAN Ja * - Feld active
sort_order INTEGER Ja * - Feld sort_order
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
IsmAwarenessRecords ism_awareness_records RLS Aktiv
14 Les champs / colonnes

Tabelle ism_awareness_records

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
course_id UUID Ja * FK ➔ ism_awareness_courses.id Feld course_id
user_id UUID Ja * FK ➔ organization_users.id Feld user_id
completed_at DATE Ja * - Feld completed_at
expires_at DATE Nein - Feld expires_at
status VARCHAR(16) Ja * - Feld status
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
IsmControls ism_controls
9 Les champs / colonnes

Tabelle ism_controls

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
code VARCHAR(16) Ja * - Feld code
theme VARCHAR(32) Ja * - Feld theme
title VARCHAR(255) Ja * - Feld title
sort_order INTEGER Ja * - Feld sort_order
verified BOOLEAN Ja * - Feld verified
source_note TEXT Nein - Feld source_note
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
IsmEvidence ism_evidence RLS Aktiv
15 Les champs / colonnes

Tabelle ism_evidence

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
title VARCHAR(255) Ja * - Feld title
notes TEXT Nein - Feld notes
recorded_at DATETIME Nein - Feld recorded_at
measure_id UUID Nein FK ➔ ism_measures.id Feld measure_id
document_id UUID Nein FK ➔ documents.id Feld document_id
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
IsmIncidents ism_incidents RLS Aktiv
21 Les champs / colonnes

Tabelle ism_incidents

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
code VARCHAR(32) Ja * - Feld code
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
severity VARCHAR(16) Ja * - Feld severity
status VARCHAR(16) Ja * - Feld status
detected_at DATETIME Ja * - Feld detected_at
notification_deadline DATETIME Nein - Feld notification_deadline
authority_notified_at DATETIME Nein - Feld authority_notified_at
affected_data_categories JSONB Ja * - Feld affected_data_categories
owner_user_id UUID Nein FK ➔ organization_users.id Feld owner_user_id
risk_id UUID Nein FK ➔ ism_risks.id Feld risk_id
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
IsmMeasures ism_measures RLS Aktiv
20 Les champs / colonnes

Tabelle ism_measures

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
code VARCHAR(32) Ja * - Feld code
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
status VARCHAR(16) Ja * - Feld status
due_on DATE Nein - Feld due_on
owner_user_id UUID Nein FK ➔ organization_users.id Feld owner_user_id
risk_id UUID Nein FK ➔ ism_risks.id Feld risk_id
policy_id UUID Nein FK ➔ ism_policies.id Feld policy_id
soa_entry_id UUID Nein FK ➔ ism_soa_entries.id Feld soa_entry_id
incident_id UUID Nein FK ➔ ism_incidents.id Feld incident_id
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
IsmPolicies ism_policies RLS Aktiv
16 Les champs / colonnes

Tabelle ism_policies

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
code VARCHAR(32) Ja * - Feld code
title VARCHAR(255) Ja * - Feld title
version VARCHAR(32) Ja * - Feld version
status VARCHAR(16) Ja * - Feld status
summary TEXT Nein - Feld summary
owner_name VARCHAR(128) Nein - Feld owner_name
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
IsmPolicyVersions ism_policy_versions RLS Aktiv
16 Les champs / colonnes

Tabelle ism_policy_versions

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
policy_id UUID Ja * FK ➔ ism_policies.id Feld policy_id
version_number INTEGER Ja * - Feld version_number
title VARCHAR(255) Ja * - Feld title
version_label VARCHAR(32) Ja * - Feld version_label
status VARCHAR(16) Ja * - Feld status
summary TEXT Nein - Feld summary
owner_name VARCHAR(128) Nein - Feld owner_name
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
IsmRisks ism_risks RLS Aktiv
20 Les champs / colonnes

Tabelle ism_risks

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
code VARCHAR(32) Ja * - Feld code
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
likelihood INTEGER Ja * - Feld likelihood
impact INTEGER Ja * - Feld impact
status VARCHAR(16) Ja * - Feld status
treatment TEXT Nein - Feld treatment
owner_user_id UUID Nein FK ➔ organization_users.id Feld owner_user_id
policy_id UUID Nein FK ➔ ism_policies.id Feld policy_id
asset_id UUID Nein FK ➔ ism_assets.id Feld asset_id
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
IsmSoaEntries ism_soa_entries RLS Aktiv
13 Les champs / colonnes

Tabelle ism_soa_entries

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
control_id UUID Ja * FK ➔ ism_controls.id Feld control_id
applicable BOOLEAN Ja * - Feld applicable
status VARCHAR(16) Ja * - Feld status
justification TEXT Nein - Feld justification
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

🔌 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/warehouse/putaway-rules/{rule_id}
delete_putaway_rule
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API DELETE /api/v1/warehouse/routes/{route_id}
delete_route
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API DELETE /api/v1/warehouse/settings/overrides/{settings_id}
delete_warehouse_settings_override
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API DELETE /api/v1/warehouse/storage-categories/{cat_id}
delete_storage_category
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API DELETE /api/v1/warehouse/zones/{zone_id}
delete_zone
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API GET /api/v1/warehouse/abc-analysis
abc_analysis
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/docks
list_warehouse_docks
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/docks/{dock_id}/slots
list_warehouse_dock_slots
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/operation-types
list_operation_types
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/overview
warehouse_overview
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/pick-aids/lookup
lookup_pick_aid
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/pick-carts
list_pick_carts
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/pick-totes
list_pick_totes
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/pickings
list_pickings
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/pickings/my
list_my_pickings
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/pickings/{picking_id}
get_picking
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/process-intents
list_process_intents
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/putaway-rules
list_putaway_rules
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/putaway-suggestion
putaway_suggestion
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/quality/held
list_quality_held
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/replenish/suggestions
list_pickface_replenish_suggestions
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/routes
list_routes
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/settings
get_warehouse_settings
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/settings/all
list_warehouse_settings
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/stock-counts
list_stock_counts
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/stock-counts/{session_id}
get_stock_count
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/storage-categories
list_storage_categories
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/warehouses
list_warehouses
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/waves
list_waves
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/waves/{wave_id}
get_wave
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /api/v1/warehouse/zones
list_zones
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory
inventory_page
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/meine-picks
inventory_meine_picks
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/movements/export.csv
inventory_movements_export
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/pickings/{picking_id}
inventory_picking_guide
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/stock-counts/{session_id}
inventory_stock_count_detail_page
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/abc
inventory_tab_abc
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/bestand
inventory_tab_bestand
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/bewegungen
inventory_tab_bewegungen
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/bewertung
inventory_tab_bewertung
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/chargen
inventory_tab_chargen
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/inventur
inventory_tab_inventur
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/meldebestand
inventory_tab_meldebestand
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/produkte
inventory_tab_produkte
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /inventory/tab/standorte
inventory_tab_standorte
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API GET /portal/{slug}/lagerware
stored_goods_page
Semantic binding: inventory_only; mutation=False
 inventory
⚡ REST API PATCH /api/v1/warehouse/operation-types/{op_id}
update_operation_type
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API PATCH /api/v1/warehouse/putaway-rules/{rule_id}
update_putaway_rule
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API PATCH /api/v1/warehouse/routes/{route_id}
update_route
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API PATCH /api/v1/warehouse/storage-categories/{cat_id}
update_storage_category
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API PATCH /api/v1/warehouse/zones/{zone_id}
update_zone
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/dock-slots/{slot_id}/cancel
cancel_warehouse_dock_slot
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/dock-slots/{slot_id}/check-in
check_in_warehouse_dock_slot
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/dock-slots/{slot_id}/complete
complete_warehouse_dock_slot
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/docks
create_warehouse_dock
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/docks/{dock_id}/slots
book_warehouse_dock_slot
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/operation-types
create_operation_type
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/partial-deliveries/from-quote/{quote_id}
prepare_partial_delivery_from_quote
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/partial-deliveries/{picking_id}/cancel
cancel_partial_delivery
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pick-carts
create_pick_cart
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pick-carts/ensure-defaults
ensure_default_pick_carts
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pick-totes
create_pick_tote
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pickings
create_picking
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/assign-aids
assign_picking_aids
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/cancel
cancel_picking
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/complete
complete_picking
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/reserve
reserve_picking
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/start
start_picking
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/process-zones/ensure
ensure_process_zones
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/putaway-rules
create_putaway_rule
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/quality/reject
reject_quality_hold
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/quality/release
release_quality_hold
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/replenish/create
create_pickface_replenish_pickings
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/routes
create_route
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/settings/overrides
create_warehouse_settings_override
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/stock-counts
create_stock_count
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/cancel
cancel_stock_count
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/lines/{line_id}/count
record_stock_count_line
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/release
release_stock_count
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/submit
submit_stock_count
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/storage-categories
create_storage_category
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/waves
create_wave
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/waves/{wave_id}/cancel
cancel_wave
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/waves/{wave_id}/release
release_wave
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /api/v1/warehouse/zones
create_zone
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /inventory/stock-counts
inventory_stock_count_create
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/cancel
inventory_stock_count_cancel
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/count
inventory_stock_count_record
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/release
inventory_stock_count_release
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/submit
inventory_stock_count_submit
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /portal/{slug}/lagerware/mengen/anfordern
customer_stock_request
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API POST /portal/{slug}/lagerware/{asset_id}/anfordern
stored_goods_request
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API PUT /api/v1/warehouse/settings
update_warehouse_settings
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API PUT /api/v1/warehouse/settings/overrides/{settings_id}
update_warehouse_settings_override
Semantic binding: operator_surface; mutation=True
 inventory
⚡ REST API GET /api/v1/warehouse/locations
Appareils de stockage
Récupération de la hiérarchie des entrepôts
 inventory:read
⚡ REST API POST /api/v1/warehouse/movements
Réservation des stocks
Il effectue un mouvement de stock
 inventory:write
🖥️ WEB-UI GET /crossdock
Le support de direction à accès
Le montant des cotisations est fixé à l'article 1er du règlement (CE) no 1272/2005.
 inventory:read
⚡ REST API GET /api/v1/crossdock
Appareils de contrôle
Administration des opérations de recyclage
 inventory:read
🖥️ WEB-UI GET /ism
Cockpit de l'ISS
Directives, risques, mesures, preuve
 compliance:read
⚡ REST API GET /api/v1/ism
Tableau de bord ISM
Numéros de référence et écoutes
 compliance:read
⚡ REST API POST /api/v1/ism/policies
Directives
Élaboration d'une directive avec audit
 compliance:write
⚡ REST API POST /api/v1/ism/risks
Réservation des risques
Résultat de risque
 compliance:write

🛡️ Réglementation et conformité

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • HGB § 240 (obligation d'inventaire)
  • Les mesures de gestion des stocks
  • La Commission a examiné les mesures prises en vue de la mise en œuvre de la directive.
Modules liés:
➔ catalog ➔ purchasing ➔ workorders ➔ crossdock