Centurio Documents de système et de module
🏛️ Architecture de plateforme 🔑 Login
🏠 Tous les modules / supply_chain / L'équipement de transport à travers le port
🔁

L'équipement de transport à travers le port

crossdock supply_chain 🛡️ RLS Protected

Enveloppe directe des marchandises de l'entrée à la sortie des marchandises sans dépôt dans le stockage à haute plage.

Fachliche Bestimmung: Optimiser les délais de livraison logistique. Les livraisons correspondantes réservées aux commandes existantes ou aux clients sont mises en service directement au lieu de conversion (zone de staging) et chargées pour le transport ultérieur, ce qui réduit les coûts de stockage et les coûts de manutention.

⚡ Flux de travail et cycles de vie

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: not_evaluated; mutation=True
inventory
⚡ REST API DELETE /api/v1/warehouse/routes/{route_id}
delete_route
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API DELETE /api/v1/warehouse/settings/overrides/{settings_id}
delete_warehouse_settings_override
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API DELETE /api/v1/warehouse/storage-categories/{cat_id}
delete_storage_category
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API DELETE /api/v1/warehouse/zones/{zone_id}
delete_zone
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API GET /api/v1/warehouse/abc-analysis
abc_analysis
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/docks
list_warehouse_docks
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/docks/{dock_id}/slots
list_warehouse_dock_slots
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/operation-types
list_operation_types
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/overview
warehouse_overview
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/pick-aids/lookup
lookup_pick_aid
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/pick-carts
list_pick_carts
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/pick-totes
list_pick_totes
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/pickings
list_pickings
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/pickings/my
list_my_pickings
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/pickings/{picking_id}
get_picking
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/process-intents
list_process_intents
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/putaway-rules
list_putaway_rules
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/putaway-suggestion
putaway_suggestion
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/quality/held
list_quality_held
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/replenish/suggestions
list_pickface_replenish_suggestions
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/routes
list_routes
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/settings
get_warehouse_settings
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/settings/all
list_warehouse_settings
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/stock-counts
list_stock_counts
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/stock-counts/{session_id}
get_stock_count
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/storage-categories
list_storage_categories
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/warehouses
list_warehouses
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/waves
list_waves
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/waves/{wave_id}
get_wave
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /api/v1/warehouse/zones
list_zones
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory
inventory_page
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/meine-picks
inventory_meine_picks
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/movements/export.csv
inventory_movements_export
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/pickings/{picking_id}
inventory_picking_guide
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/stock-counts/{session_id}
inventory_stock_count_detail_page
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/abc
inventory_tab_abc
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/bestand
inventory_tab_bestand
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/bewegungen
inventory_tab_bewegungen
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/bewertung
inventory_tab_bewertung
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/chargen
inventory_tab_chargen
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/inventur
inventory_tab_inventur
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/meldebestand
inventory_tab_meldebestand
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/produkte
inventory_tab_produkte
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /inventory/tab/standorte
inventory_tab_standorte
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API GET /portal/{slug}/lagerware
stored_goods_page
Semantic binding: not_evaluated; mutation=False
inventory
⚡ REST API PATCH /api/v1/warehouse/operation-types/{op_id}
update_operation_type
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API PATCH /api/v1/warehouse/putaway-rules/{rule_id}
update_putaway_rule
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API PATCH /api/v1/warehouse/routes/{route_id}
update_route
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API PATCH /api/v1/warehouse/storage-categories/{cat_id}
update_storage_category
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API PATCH /api/v1/warehouse/zones/{zone_id}
update_zone
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/dock-slots/{slot_id}/cancel
cancel_warehouse_dock_slot
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/dock-slots/{slot_id}/check-in
check_in_warehouse_dock_slot
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/dock-slots/{slot_id}/complete
complete_warehouse_dock_slot
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/docks
create_warehouse_dock
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/docks/{dock_id}/slots
book_warehouse_dock_slot
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/operation-types
create_operation_type
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/partial-deliveries/from-quote/{quote_id}
prepare_partial_delivery_from_quote
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/partial-deliveries/{picking_id}/cancel
cancel_partial_delivery
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pick-carts
create_pick_cart
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pick-carts/ensure-defaults
ensure_default_pick_carts
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pick-totes
create_pick_tote
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pickings
create_picking
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/assign-aids
assign_picking_aids
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/cancel
cancel_picking
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/complete
complete_picking
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/reserve
reserve_picking
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/pickings/{picking_id}/start
start_picking
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/process-zones/ensure
ensure_process_zones
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/putaway-rules
create_putaway_rule
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/quality/reject
reject_quality_hold
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/quality/release
release_quality_hold
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/replenish/create
create_pickface_replenish_pickings
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/routes
create_route
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/settings/overrides
create_warehouse_settings_override
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/stock-counts
create_stock_count
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/cancel
cancel_stock_count
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/lines/{line_id}/count
record_stock_count_line
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/release
release_stock_count
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/stock-counts/{session_id}/submit
submit_stock_count
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/storage-categories
create_storage_category
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/waves
create_wave
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/waves/{wave_id}/cancel
cancel_wave
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/waves/{wave_id}/release
release_wave
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /api/v1/warehouse/zones
create_zone
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /inventory/stock-counts
inventory_stock_count_create
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/cancel
inventory_stock_count_cancel
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/count
inventory_stock_count_record
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/release
inventory_stock_count_release
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /inventory/stock-counts/{session_id}/submit
inventory_stock_count_submit
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /portal/{slug}/lagerware/mengen/anfordern
customer_stock_request
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API POST /portal/{slug}/lagerware/{asset_id}/anfordern
stored_goods_request
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API PUT /api/v1/warehouse/settings
update_warehouse_settings
Semantic binding: not_evaluated; mutation=True
inventory
⚡ REST API PUT /api/v1/warehouse/settings/overrides/{settings_id}
update_warehouse_settings_override
Semantic binding: not_evaluated; 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:

  • Régimes de contrôle
  • RAD / documentation de transport
Modules liés:
➔ inventory ➔ purchasing ➔ workorders