Centurio Systemen en modules
🔍
🏛️ Plattformarchitectuur
🇩🇪 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
🏠 Alle modules / inventory_logistics / De Commissie heeft de Commissie verzocht om een aanvullende verordening op te stellen.
📦

De Commissie heeft de Commissie verzocht om een aanvullende verordening op te stellen.

inventory inventory_logistics 🛡️ RLS Protected

Hierarchische behuizing van de opslagplaatsen, zones, rekken, vakken, bewegingen van de bestanden, bestanden en reserveringen.

Fachliche Bestimmung: Volwaardig lagerbeheerstelsel (LVS) - meervoudige lagerstructuren (hoofdlager, buitenlager, voertuiglager van technici) - Behoudbewegingen met volledige terugkeerbaarheid (audit-trail) - ondersteuning van batch- en serie-nummers, minimumbestandtoezicht en automatische reservering van bestanden voor productie- en klantopdrachten.
⚡ Werkstromen en levenscyclus (22) 🗄️ Datamodellen & velden (16) 🔌 Inleidende punten (UI&API's) (102) 🛡️ Reglementarische en compliance

⚡ Werkstromen en levenscyclus

Beheer van stoffen stock_movement_cycle

De fysieke en boekhoudkundige verwerking van de opslag, reservering en uitgang van de goederen.

graph TD A[Wareneingang] -->|Einbuchen| B[Physischer Lagerbestand] B -->|Auftragsannahme| C[Bestandsreservierung] C -->|Kommissionierung| D[Warenausgangszone] D -->|Versand / Lieferschein| E[Ausgebuchter Bestand]
1. RECEIVE
Toegang
De goederen worden in de opslagplaats geplaatst.
Aktionen: Verhoogde bestand
2. RESERVE
Reservering
Opdracht van de klant is een specifiek bedrag voor inrichting.
Aktionen: Vermindering van de beschikbare bestanden
3. PICK
Invoer
Lagerarbeider neemt goederen op met behulp van digitale pickliste.
Aktionen: Boeken van de Lagerplatz
4. DISPATCH
Uitvoer van de goederen
De uitgangsaansluiting van de goederen vermindert de fysieke bestand definitief.
Aktionen: Vervaardiging van produkten van de sector

Opdracht van de klant → Uitgang van de goederen cascade:business.customer_order.fulfill

Cascade (review_gated).

1. issue
Boeken van de uitgang als ontwerp
inventaris
Aktionen: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2. tour
Verzending van de uitlevering
logistiek
Aktionen: create_tour
3. project
project / kostenstellen toe te kennen
Projecten
Aktionen: link_project
4. task
Uitvoeren / afrekenen
taken
Aktionen: create_task

Verwerking van de produkten cascade:business.delivery_note.intake

Cascade (review_gated).

1. stock
Invoer van goederen in de _GT20_0__ boeken
inventaris
Aktionen: post_goods_receipt
2. tour
Reise / voortvervoer plannen
logistiek
Aktionen: create_tour
3. task
Invoer van goederen te controleren / vergelijken
taken
Aktionen: create_task
4. qc
Kwaliteitsactie bij vermoedelijke tekortkomingen
inventaris
Aktionen: - De volgende pagina 's bevatten een link:
5. ticket
Tickets voor klachten bij gebreken
Tickets
Aktionen: create_ticket

In het kader van de cascade_target:business.quality.check

Cascade (review_gated).

1. cascade
In het kader van de

Invoer van goederen in de _GT20_0__ boeken cascade_target:business.stock.inbound

Cascade (review_gated).

1. cascade
Invoer van goederen in de _GT20_0__ boeken

Uitvoer van de goederen / Invrijname van de materialen (ontwerp) cascade_target:business.stock.issue

Cascade (review_gated).

1. cascade
Uitvoer van de goederen / Invrijname van de materialen (ontwerp)

Gebruikersbevel: afleveringsbriefagent plan:command_delivery_note_agent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: materiaalvangende agent plan:command_material_capture_agent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: algemene pakhuisagent plan:command_warehouse_general_agent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: onderdeel voor de inventarisatie van de opslagplaats plan:command_warehouse_inventory_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: onderdeel van de label van de opslagplaats plan:command_warehouse_label_print_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: opslagplaats plan:command_warehouse_location_crud_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: onderdeel van de warehousing plan:command_warehouse_partial_withdrawal_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: pakhuispakken plan:command_warehouse_picking_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: onderdeel voor het opslag van voorraad plan:command_warehouse_stock_count_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: voorraad voor opslag plan:command_warehouse_stock_inbound_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: voorraad voor opslag plan:command_warehouse_stock_outbound_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Gebruikersbevel: voorraadoverdracht plan:command_warehouse_stock_transfer_subagent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

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

Vervoer van goederen plan:stock_issue_picking

Gecontroleerd duurzaam plan (durable_plan), start: domain_event.

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

De volgende punten worden behandeld: status:crossdock_operation

De overgangsregelingen zijn niet verplicht (zie service validatie).

1. draft
Ontwerp
Status <unk>ontwerp <unk> van de standmachine cross-dock.
2. planned
geplanning
Status <unk>planned<unk> van de standmachine cross-dock.
3. receiving
ontvangende
Status <unk>ontvangen <unk> van de standmachine cross-dock.
4. staged
georganiseerd
Status van de standmachine cross-dock.
5. dispatching
uitzending
Status <unk>verzending <unk> van de standmachine cross-dock.
6. done
gehaald
Status van de standmachine cross-dock.
7. cancelled
geannuleerd
Status <unk>Cancelled<unk> van de stand-machine cross-dock.

Uitvoer van de goederen status:stock_issue

De overgangsregelingen zijn niet verplicht (zie service validatie).

1. draft
Ontwerp
Status <unk>ontwerp <unk> van de standmachine uitgang van de goederen.
2. posted
gepost
Status van de standmachine
3. reversed
omgekeerd
Status van de toestand van de machine
4. cancelled
geannuleerd
Status van de standmachine productuitgang

Reservering van stoffen status:stock_reservation

De overgangsregelingen zijn niet verplicht (zie service validatie).

1. active
actief
Status <unk>active<unk> van de staatmachine bestandreservering.
2. fulfilled
Gevuld
Status <unk>voltooid<unk> van de standmachine bestandreservering.
3. released
vrijgegeven
Status <unk>released<unk> van de staatmachine bestandreservering.
4. expired
uiterlijk
Status <unk>expired<unk> van de standbewaaringsmachine.

🗄️ Datamodellen & velden

CrossdockAllocations crossdock_allocations RLS Aktiv
10 Veld / kolom

Tabelle crossdock_allocations

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle crossdock_inbound_lines

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle crossdock_operations

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle crossdock_outbound_lines

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle crossdock_rules

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_assets

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_awareness_courses

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_awareness_records

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_controls

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_evidence

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_incidents

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_measures

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_policies

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_policy_versions

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_risks

Feldname Datatipe Verplichting Schlüssel Gezondheid
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 Veld / kolom

Tabelle ism_soa_entries

Feldname Datatipe Verplichting Schlüssel Gezondheid
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

🔌 Inleidende punten (UI&API's)

Art Metode Eindpunt / pad Titel & Zweck Aanpassing
⚡ 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
Verpakkingsplaatsen
Hierarchie van alle opslagplaatsen
 inventory:read
⚡ REST API POST /api/v1/warehouse/movements
Behoud
Beheer van een bestand
 inventory:write
🖥️ WEB-UI GET /crossdock
Vervoer van de lucht
Overzicht van de openstaande omschakelingsacties
 inventory:read
⚡ REST API GET /api/v1/crossdock
De volgende punten worden beschreven:
Bestuur van omschakeling
 inventory:read
🖥️ WEB-UI GET /ism
ISM-cockpit
Richtlijnen, risico's, maatregelen, bewijs
 compliance:read
⚡ REST API GET /api/v1/ism
ISM-dashboard
Kennis en luister
 compliance:read
⚡ REST API POST /api/v1/ism/policies
Richtlijn van de Raad
Geproduceerde richtlijn met audit
 compliance:write
⚡ REST API POST /api/v1/ism/risks
Risico's opnemen
Risico met score
 compliance:write

🛡️ Reglementarische en compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • HGB § 240 (inventarisplicht)
  • De Commissie heeft de Commissie verzocht om een aanvullende verordening te nemen.
  • EU 178/2002 (vervolgensbaarheid van de lading)
Gecombineerde modules:
➔ catalog ➔ purchasing ➔ workorders ➔ crossdock