Centurio System and module documentation
🔍
🏛️ Platform architecture
🇩🇪 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
🏠 All modules / inventory_logistics / Other products
📦

Other products

inventory inventory_logistics 🛡️ RLS Protected

The Commission shall adopt delegated acts in accordance with Article 21 of the Treaty on the Functioning of the European Union.

Fachliche Bestimmung: Full-service warehouse management system (LVS) - provides multi-stage warehouse structures (main warehouses, outdoor warehouses, technicians' vehicle warehouses) - provides complete traceability of stock movements (audit trail), supports batch and serial numbers, minimum stock monitoring and automatic stock reservation for manufacturing and customer orders.
⚡ Workflows and life cycles (22) 🗄️ Data models and fields (16) 🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. (102) 🛡️ Regulatory and compliance

⚡ Workflows and life cycles

Movement of stocks & reserves stock_movement_cycle

The physical and accounting process of storage, reservation and exit of goods.

graph TD A[Wareneingang] -->|Einbuchen| B[Physischer Lagerbestand] B -->|Auftragsannahme| C[Bestandsreservierung] C -->|Kommissionierung| D[Warenausgangszone] D -->|Versand / Lieferschein| E[Ausgebuchter Bestand]
1. RECEIVE
Access
The goods are delivered to the warehouse with batch order.
Aktionen: Increase stock
2. RESERVE
Reservation
Customer order reserved specific quantity for commissioning.
Aktionen: Reducing available stocks
3. PICK
Commissioning
The data shall be collected by the operator of the warehouse using a digital picklist.
Aktionen: Booking of storage space
4. DISPATCH
Exit of goods
The physical stock is permanently reduced by the booking of the goods.
Aktionen: Manufacture from materials of heading No 841

Kundenauftrag → Abwicklung cascade:business.customer_order.fulfill

The following information shall be provided:

1. order
Verkaufsauftrag anlegen / bestätigen
sales
Aktionen: sales.create
2. issue
Booking of the outcome of the goods as draft
Inventory
Aktionen: - I 'm not sure .
3. tour
The Commission shall adopt a decision on the following:
Logistics
Aktionen: create_tour
4. project
The Commission shall adopt the following measures:
Projects
Aktionen: link_project
5. task
Exercise / calculate
other tasks
Aktionen: create_task

Other, of a kind used for the manufacture of goods cascade:business.delivery_note.intake

The following information shall be provided:

1. stock
Commodity receipts
Inventory
Aktionen: post_goods_receipt
2. tour
Tour / further transport planning
Logistics
Aktionen: create_tour
3. task
Checking / comparing the entry of goods
other tasks
Aktionen: create_task
4. qc
Quality control in case of suspected defects
Inventory
Aktionen: quality.check.create
5. ticket
Ticket for complaints in case of defects
Tickets
Aktionen: create_ticket

The Commission shall adopt a proposal for a regulation on the cascade_target:business.quality.check

The following information shall be provided:

1. cascade
The Commission shall adopt a proposal for a regulation on the

Commodity receipts cascade_target:business.stock.inbound

The following information shall be provided:

1. cascade
Commodity receipts

The Commission shall adopt the following implementing acts: cascade_target:business.stock.issue

The following information shall be provided:

1. cascade
The Commission shall adopt the following implementing acts:

The following information shall be provided: plan:command_delivery_note_agent

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

1. delivery_note_agent
delivery_note_agent
The following is the list of the products:
Aktionen: delivery_note_agent

The following information shall be provided: plan:command_material_capture_agent

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

1. material_capture_agent
material_capture_agent
The following is the list of the products:
Aktionen: material_capture_agent

User order: general agent of the warehouse plan:command_warehouse_general_agent

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

1. warehouse_general_agent
warehouse_general_agent
The following is the list of the products:
Aktionen: warehouse_general_agent

The following is the list of the products used: plan:command_warehouse_inventory_subagent

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

1. warehouse_inventory_subagent
warehouse_inventory_subagent
The following is the list of the products:
Aktionen: warehouse_inventory_subagent

Manufacture from materials of heading No 7301 plan:command_warehouse_label_print_subagent

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

1. warehouse_label_print_subagent
warehouse_label_print_subagent
The following is the list of the products:
Aktionen: warehouse_label_print_subagent

User's instructions: warehouse location raw subagent plan:command_warehouse_location_crud_subagent

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

1. warehouse_location_crud_subagent
warehouse_location_crud_subagent
The following is the list of the products:
Aktionen: warehouse_location_crud_subagent

The following information is provided for in the Annex to this Regulation: plan:command_warehouse_partial_withdrawal_subagent

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

1. warehouse_partial_withdrawal_subagent
warehouse_partial_withdrawal_subagent
The following is the list of the products:
Aktionen: warehouse_partial_withdrawal_subagent

The following is the list of the products used: plan:command_warehouse_picking_subagent

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

1. warehouse_picking_subagent
warehouse_picking_subagent
The following is the list of the products:
Aktionen: warehouse_picking_subagent

Instructions for use: stock count of warehouse plan:command_warehouse_stock_count_subagent

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

1. warehouse_stock_count_subagent
warehouse_stock_count_subagent
The following is the list of the products:
Aktionen: warehouse_stock_count_subagent

Input sub-agent for storage stock plan:command_warehouse_stock_inbound_subagent

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

1. warehouse_stock_inbound_subagent
warehouse_stock_inbound_subagent
The following is the list of the products:
Aktionen: warehouse_stock_inbound_subagent

Instructions for use: warehouse stock outbound sub-agent plan:command_warehouse_stock_outbound_subagent

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

1. warehouse_stock_outbound_subagent
warehouse_stock_outbound_subagent
The following is the list of the products:
Aktionen: warehouse_stock_outbound_subagent

User order: warehouse stock transfer sub-agent plan:command_warehouse_stock_transfer_subagent

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

1. warehouse_stock_transfer_subagent
warehouse_stock_transfer_subagent
The following is the list of the products:
Aktionen: warehouse_stock_transfer_subagent

Manufacture from materials of heading 810 plan:stock_issue_picking

The following is the list of the types of data that are used for the purpose of the report:

1. stock_issue_dispatch_agent
stock_issue_dispatch_agent
The following is the list of the products:
Aktionen: stock_issue_dispatch_agent

Cross-dock status:crossdock_operation

The following information is provided by the Commission on the basis of the information provided by the Member States:

1. draft
Draft
Status of the cross-dock state machine.
2. planned
planned
Status of the cross-dock state machine.
3. receiving
receiving
Status <unk>receiving <unk> of the cross-dock conditioning machine.
4. staged
Other
Status of the condition machine cross-dock.
5. dispatching
dispatching
Status of the condition machine cross-dock.
6. done
- finished
Status of the cross-dock conditioning machine.
7. cancelled
cancelled
Status of the cross-dock conditioning machine

Exit of goods status:stock_issue

The following information is provided by the Commission on the basis of the information provided by the Member States:

1. draft
Draft
The status of the state machine
2. posted
posted
State of the machine state output.
3. reversed
Other
The condition of the machine is reversed.
4. cancelled
cancelled
Status of the condition machine

Reservation of stocks status:stock_reservation

The following information is provided by the Commission on the basis of the information provided by the Member States:

1. active
active
Status <unk>active<unk> of the state machine stock reserve.
2. fulfilled
(c)
Status <unk> fulfilled<unk> of the condition machine stock reservation.
3. released
released
Status <unk>released<unk> of the state machine stock reservation.
4. expired
expired
Status of the stock reserve of the stock machine.

🗄️ Data models and fields

CrossdockAllocations crossdock_allocations RLS Aktiv
10 Fields and columns

Tabelle crossdock_allocations

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

Tabelle crossdock_inbound_lines

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

Tabelle crossdock_operations

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

Tabelle crossdock_outbound_lines

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

Tabelle crossdock_rules

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

Tabelle ism_assets

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

Tabelle ism_awareness_courses

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

Tabelle ism_awareness_records

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

Tabelle ism_controls

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

Tabelle ism_evidence

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

Tabelle ism_incidents

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

Tabelle ism_measures

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

Tabelle ism_policies

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

Tabelle ism_policy_versions

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

Tabelle ism_risks

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

Tabelle ism_soa_entries

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

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

Art The method Endpoint / path Titel & Zweck The Commission shall adopt the following:
⚡ REST API DELETE /api/v1/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
Other
The following information shall be provided:
 inventory:read
⚡ REST API POST /api/v1/warehouse/movements
Stock keeping
Carries out stock movements
 inventory:write
🖥️ WEB-UI GET /crossdock
Cross-docking control
Overview of the outstanding recycling operations
 inventory:read
⚡ REST API GET /api/v1/crossdock
Other
Management of transfers
 inventory:read
🖥️ WEB-UI GET /ism
The following conditions shall apply:
The Commission shall adopt delegated acts in accordance with Article 21 of Regulation (EC) No 1290/2005.
 compliance:read
⚡ REST API GET /api/v1/ism
The following table is inserted:
Number of persons and listener
 compliance:read
⚡ REST API POST /api/v1/ism/policies
Directive
Directive with audit
 compliance:write
⚡ REST API POST /api/v1/ism/risks
Risk recognition
Risk with score
 compliance:write

🛡️ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • The Commission shall take into account the information provided by the Member States.
  • The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.
  • EU 178/2002 (Chargen-Rückverfolgbarkeit)
Connected modules:
➔ catalog ➔ purchasing ➔ workorders ➔ crossdock