Centurio Documentația sistemului
🔍
🏛️ Arhitectura de platformă
🇩🇪 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
🏠 Toate modurile / supply_chain / Logistica de croșare
🔁

Logistica de croșare

crossdock supply_chain 🛡️ RLS Protected

Întoarcerea directă a mărfurilor de la intrarea în ieșire a mărfurilor fără depozitare în depozitul de pe suprafață.

Fachliche Bestimmung: Optitul de livrare logistică optimă. livrările respective rezervate pentru comenzile existente sau pentru clienții sunt comisionate direct la locul de înfășurare (zona staging) și încărcate pentru transportul de mai departe, reducând astfel costurile de depozitare și de manipulare.
⚡ Fluxuri de lucru (21) 🗄️ Modele de date & câmpuri (16) 🔌 Puncte de inițiere (UI & API) (102) 🛡️ Reglementări și respectare

⚡ Fluxuri de lucru

Kundenauftrag → Abwicklung cascade:business.customer_order.fulfill

Cascade (review_gated).

1. order
Verkaufsauftrag anlegen / bestätigen
sales
Aktionen: sales.create
2. issue
Înregistrarea în formă de proiect a ieșirii
Inventare
Aktionen: - Nu , nu , nu .
3. tour
Planificarea unei vizite de livrare
logistică
Aktionen: create_tour
4. project
proiect / atribuirea de
Proiecte
Aktionen: link_project
5. task
În cazul în care se aplică cerințele de bază, se aplică:
sarcini
Aktionen: create_task

aviz de expediție prelucrare completă cascade:business.delivery_note.intake

Cascade (review_gated).

1. stock
Comentariile de intrare în contul _GT20_0__
Inventare
Aktionen: post_goods_receipt
2. tour
Planul de tur/transport
logistică
Aktionen: create_tour
3. task
Verificarea / comparația de intrare a mărfurilor
sarcini
Aktionen: create_task
4. qc
Verificarea calității în cazul suspectării de defecte
Inventare
Aktionen: calitate.check.create
5. ticket
Biletele pentru reclamații în caz de defecte
bilete
Aktionen: create_ticket

Încadrarea în programă a controlului calității cascade_target:business.quality.check

Cascade (review_gated).

1. cascade
Încadrarea în programă a controlului calității

Comentariile de intrare în contul _GT20_0__ cascade_target:business.stock.inbound

Cascade (review_gated).

1. cascade
Comentariile de intrare în contul _GT20_0__

Expunerea de la mărfuri / primirea de materiale (proiect) cascade_target:business.stock.issue

Cascade (review_gated).

1. cascade
Expunerea de la mărfuri / primirea de materiale (proiect)

Instrucțiunea de utilizare: agent de la biletul de livrare plan:command_delivery_note_agent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. delivery_note_agent
delivery_note_agent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "delivery_note_agent", "condition_fact": null}
Aktionen: delivery_note_agent

Oferta de utilizare: agent de captare a materialelor plan:command_material_capture_agent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. material_capture_agent
material_capture_agent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "material_capture_agent", "condition_fact": null}
Aktionen: material_capture_agent

Ordonanța de utilizare: agent general de depozit plan:command_warehouse_general_agent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_general_agent
warehouse_general_agent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_general_agent", "condition_fact": null}
Aktionen: warehouse_general_agent

Ordonanța de utilizare: subpagent de inventar de depozit plan:command_warehouse_inventory_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_inventory_subagent
warehouse_inventory_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_inventory_subagent", "condition_fact": null}
Aktionen: warehouse_inventory_subagent

Instrucțiuni de utilizare: etichetă de depozit plan:command_warehouse_label_print_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_label_print_subagent
warehouse_label_print_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_label_print_subagent", "condition_fact": null}
Aktionen: warehouse_label_print_subagent

Instrucțiune de utilizare: locație de depozit plan:command_warehouse_location_crud_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_location_crud_subagent
warehouse_location_crud_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_location_crud_subagent", "condition_fact": null}
Aktionen: warehouse_location_crud_subagent

Benutzerbefehl: warehouse partial withdrawal subagent plan:command_warehouse_partial_withdrawal_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_partial_withdrawal_subagent
warehouse_partial_withdrawal_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_partial_withdrawal_subagent", "condition_fact": null}
Aktionen: warehouse_partial_withdrawal_subagent

Oferta de utilizare: sub-agente de colectare a depozitelor plan:command_warehouse_picking_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_picking_subagent
warehouse_picking_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_picking_subagent", "condition_fact": null}
Aktionen: warehouse_picking_subagent

Instrucțiuni de utilizare: stoc de depozitare plan:command_warehouse_stock_count_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_stock_count_subagent
warehouse_stock_count_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_stock_count_subagent", "condition_fact": null}
Aktionen: warehouse_stock_count_subagent

Instrucțiune de utilizare: stoc de depozit subbagent plan:command_warehouse_stock_inbound_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_stock_inbound_subagent
warehouse_stock_inbound_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_stock_inbound_subagent", "condition_fact": null}
Aktionen: warehouse_stock_inbound_subagent

Oferta de utilizare: stoc de depozit plan:command_warehouse_stock_outbound_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_stock_outbound_subagent
warehouse_stock_outbound_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_stock_outbound_subagent", "condition_fact": null}
Aktionen: warehouse_stock_outbound_subagent

Instrucțiune de utilizare: subgenți de transfer de stoc de depozit plan:command_warehouse_stock_transfer_subagent

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. warehouse_stock_transfer_subagent
warehouse_stock_transfer_subagent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "warehouse_stock_transfer_subagent", "condition_fact": null}
Aktionen: warehouse_stock_transfer_subagent

Expunerea produsului plan:stock_issue_picking

Plan durabil verificat (durable_plan), start: domain_event.

1. stock_issue_dispatch_agent
stock_issue_dispatch_agent
{"key": "step_0", "label": "Kommissionier-Bedarf pruefen und Aufgabe erstellen", "adapter": "agent.execute", "agent": "stock_issue_dispatch_agent", "condition_fact": null}
Aktionen: stock_issue_dispatch_agent

În afara portului status:crossdock_operation

În cazul în care se aplică o metodă de verificare a situaţiei, se poate observa o metodă de verificare a situaţiei.

1. draft
proiect
Statutul proiectului de pe cross-dock.
2. planned
planuri
Statutul <unk>planned<unk> al mașinii de stare cross-dock.
3. receiving
înregistrat
Statut <unk>rece­ving<unk> de pe cross-dock.
4. staged
înregistrat
Statutul de stagiere a mașinii de stagiere Cross-dock.
5. dispatching
expediere
Statutul de expediere a mașinii de condiții de croșuare.
6. done
încheiat
Statutul de operațiune a mașinii de funcționare transversală.
7. cancelled
anulate
Statutul de anulare a mașinii de anulare de stat.

Expunerea de mărfuri status:stock_issue

În cazul în care se aplică o metodă de verificare a situaţiei, se poate observa o metodă de verificare a situaţiei.

1. draft
proiect
Statut <unk>proiect <unk> de ieşire a mărfurilor din mașină de stare.
2. posted
publicate
Statutul <unk>postat<unk> al mașinii de stare de ieșire a mărfurilor.
3. reversed
încoace
Statut <unk>reversed<unk> al mașinii de stare de ieșire a mărfurilor.
4. cancelled
anulate
Statut de înregistrare a mașinii de înregistrare

Reservarea stocurilor status:stock_reservation

În cazul în care se aplică o metodă de verificare a situaţiei, se poate observa o metodă de verificare a situaţiei.

1. active
activ
Statutul <unk>active<unk> al mașinii de stare rezervărea stocurilor.
2. fulfilled
înregistrat
Statutul <unk>a fost îndeplinit<unk> de la dispozitivul de stat rezervă de stoc.
3. released
eliberate
Statutul <unk>released<unk> al mașinii de stat rezervă de stocuri.
4. expired
expirat
Statut <unk>expired<unk> al mașinii de stat rezervă de stoc.

🗄️ Modele de date & câmpuri

CrossdockAllocations crossdock_allocations RLS Aktiv
10 Câmpuri / coloane

Tabelle crossdock_allocations

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle crossdock_inbound_lines

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle crossdock_operations

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle crossdock_outbound_lines

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle crossdock_rules

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_assets

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_awareness_courses

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_awareness_records

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_controls

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_evidence

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_incidents

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_measures

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_policies

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_policy_versions

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_risks

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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 Câmpuri / coloane

Tabelle ism_soa_entries

Feldname Tip de date Obligatoriu Schlüssel Importanța profesională
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

🔌 Puncte de inițiere (UI & API)

Art Metoda Punctul de încheiere / traseul Titel & Zweck Asigurarea
⚡ 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
Depozite de depozitare
Recuperarea ierarhiei tuturor locurilor de depozitare
 inventory:read
⚡ REST API POST /api/v1/warehouse/movements
Înregistrarea stocurilor
Foloseste o circulatie de stocuri
 inventory:write
🖥️ WEB-UI GET /crossdock
Părți de conducere cu o suprafață transversalabilă
Oversă a procedurilor de încadrare în circulație
 inventory:read
⚡ REST API GET /api/v1/crossdock
Aplicare de tip
Administrarea operațiunilor de învelope
 inventory:read
🖥️ WEB-UI GET /ism
Cockpit ISM
Directiva, riscurile, măsurile, dovezi
 compliance:read
⚡ REST API GET /api/v1/ism
Tabla de bord ISM
Numerele de identificare și de ascultare
 compliance:read
⚡ REST API POST /api/v1/ism/policies
Directiva
Directiva cu audit
 compliance:write
⚡ REST API POST /api/v1/ism/risks
Identificarea riscurilor
Crează risc cu scor
 compliance:write

🛡️ Reglementări și respectare

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • LVS Retraceabilitate
  • ADR / documentație de transport
Module legate:
➔ inventory ➔ purchasing ➔ workorders