Centurio Documentación de sistemas y módulos
🏛️ Arquitectura de la plataforma 🔑 Login
🏠 Todos los módulos / supply_chain / Logística de acoplamiento
🔁

Logística de acoplamiento

crossdock supply_chain 🛡️ RLS Protected

Envases directos de mercancías desde la entrada de las mercancías hasta la salida de las mercancías sin almacenamiento en el almacén superior.

Fachliche Bestimmung: Optimiza los tiempos de transcursión logística: las entregas correspondientes reservadas para los contratos o clientes existentes se encargan directamente en el lugar de recabado (espacio de estagnación) y se cargan para el transporte posterior, lo que reduce los costes de almacenamiento y la carga de manejo.

⚡ Flujos de trabajo y ciclos de vida

Encomenda de los clientes → Salida de mercancías cascade:business.customer_order.fulfill

Cascada (review_gated)

1. issue
Reservar la salida de la mercancía como proyecto
Inventario
Aktionen: - ¿Qué es esto ?
2. tour
Plan de viaje de entrega
Servicios de transporte
Aktionen: create_tour
3. project
- la asignación de las cuotas de trabajo
proyectos
Aktionen: link_project
4. task
Exercer / calcular
tareas
Aktionen: create_task

Tratamiento completo cascade:business.delivery_note.intake

Cascada (review_gated)

1. stock
Entradas de mercancías en las cuentas de la
Inventario
Aktionen: post_goods_receipt
2. tour
Plan de viaje / transporte
Servicios de transporte
Aktionen: create_tour
3. task
Verificación / comparación de las entradas de mercancías
tareas
Aktionen: create_task
4. qc
Verificación de calidad en caso de sospecha de defectos
Inventario
Aktionen: calidad.check.create
5. ticket
Tickets de reclamación en caso de defectos
Tickets
Aktionen: create_ticket

La evaluación de la calidad cascade_target:business.quality.check

Cascada (review_gated)

1. cascade
La evaluación de la calidad

Entradas de mercancías en las cuentas de la cascade_target:business.stock.inbound

Cascada (review_gated)

1. cascade
Entradas de mercancías en las cuentas de la

Despacho de mercancías / adquisición de materiales (proyecto) cascade_target:business.stock.issue

Cascada (review_gated)

1. cascade
Despacho de mercancías / adquisición de materiales (proyecto)

Otros servicios de transporte plan:command_delivery_note_agent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

Otros productos y servicios de transporte plan:command_material_capture_agent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

En el caso de los productos de la industria de la Unión, el importe de los productos de la industria de la Unión debe ser igual a la de los productos de la Unión. plan:command_warehouse_general_agent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

En el caso de los productos de la industria de la Unión, el importe de los productos de la industria de la Unión debe ser el de la industria de la Unión. plan:command_warehouse_inventory_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

Indicación de uso: subagento de etiqueta de almacén plan:command_warehouse_label_print_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

Benutzerbefehl: warehouse location crud subagent plan:command_warehouse_location_crud_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

En el caso de los productos de la industria de la Unión, el importe de los productos de la industria de la Unión debe ser el de la industria de la Unión. plan:command_warehouse_partial_withdrawal_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

En el caso de los productos de la industria de la Unión, el producto de la industria de la Unión debe ser utilizado en el mercado de la Unión. plan:command_warehouse_picking_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

Benutzerbefehl: warehouse stock count subagent plan:command_warehouse_stock_count_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

En el caso de los productos de la industria de la Unión, el importe de los productos de la industria de la Unión debe ser el de la industria de la Unión. plan:command_warehouse_stock_inbound_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

En el caso de los productos de la industria de la Unión, el importe de los productos de la industria de la Unión debe ser el de la industria de la Unión. plan:command_warehouse_stock_outbound_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

En el caso de los productos de la industria de la Unión, el importe de los productos de la industria de la Unión debe ser igual a la de los productos de la industria de la Unión. plan:command_warehouse_stock_transfer_subagent

Plan durable comprobado (durable_plan), inicio: manual_command.

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

Exportación de mercancías plan:stock_issue_picking

Plan durable verificado (durable_plan), inicio: dominio_event.

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

Los demás productos status:crossdock_operation

Las operaciones de la máquina de estado observable (solo observable) no se obligan a realizar.

1. draft
proyecto
Estado de la máquina de estado de cruce.
2. planned
Plan de trabajo
Estado <unk>planificado <unk> de la máquina de estado de cruce.
3. receiving
Recibiendo
Estado <unk>recepción <unk> de la máquina de estado de cruce.
4. staged
de la misma
Estado de la máquina de estado de cruce.
5. dispatching
Envío
Estado de la máquina de estado de transbordo.
6. done
hecho
Estado de la máquina de estado de cruce.
7. cancelled
cancelado
Estado de la máquina de estado de cruce.

Exportación de mercancías status:stock_issue

Las operaciones de la máquina de estado observable (solo observable) no se obligan a realizar.

1. draft
proyecto
Estado de la máquina de estado de salida de mercancía.
2. posted
publicado
Estado de la máquina de estado de salida de mercancía.
3. reversed
en el sentido inverso
Estado de la máquina de estado de salida de mercancía.
4. cancelled
cancelado
Estado de la máquina de estado de salida de mercancía.

Reserva de las existencias status:stock_reservation

Las operaciones de la máquina de estado observable (solo observable) no se obligan a realizar.

1. active
de la
Estado <unk>activo<unk> de la máquina de estado reserva de existencias.
2. fulfilled
cumplido
Estado <unk>completado<unk> de la máquina de estado reserva de existencias.
3. released
de la
Estado <unk>released<unk> de la máquina de estado reserva de existencias.
4. expired
Expirado
Estado <unk>expirado<unk> de la máquina de estado reserva de existencias.

🗄️ Modelos de datos y campos

CrossdockAllocations crossdock_allocations RLS Aktiv
10 Cálculos y columnas

Tabelle crossdock_allocations

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle crossdock_inbound_lines

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle crossdock_operations

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle crossdock_outbound_lines

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle crossdock_rules

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_assets

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_awareness_courses

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_awareness_records

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_controls

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_evidence

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_incidents

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_measures

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_policies

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_policy_versions

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_risks

Feldname Tipo de datos Obligado Schlüssel Importancia 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álculos y columnas

Tabelle ism_soa_entries

Feldname Tipo de datos Obligado Schlüssel Importancia 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

🔌 Puntos de inicio (UI y API)

Art El método Punto final / camino Titel & Zweck Reacción
⚡ 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
Los productos de la industria de la industria
Recoger la jerarquía de todos los almacenes
inventory:read
⚡ REST API POST /api/v1/warehouse/movements
Registro de existencias
Realiza un movimiento de stock
inventory:write
🖥️ WEB-UI GET /crossdock
El control de los puntos de contacto
En el caso de los productos de la Unión, el importe de los productos de la Unión se calcula en el importe de los productos de la Unión.
inventory:read
⚡ REST API GET /api/v1/crossdock
Aplicación de las medidas de control
Administración de las operaciones de envase
inventory:read
🖥️ WEB-UI GET /ism
Cockpit de la ISM
Directivas, riesgos, medidas, pruebas
compliance:read
⚡ REST API GET /api/v1/ism
Dispositivo de control de datos
Números de las personas que escuchan
compliance:read
⚡ REST API POST /api/v1/ism/policies
La directiva
Directiva con auditoría
compliance:write
⚡ REST API POST /api/v1/ism/risks
Recoger riesgos
Produce riesgo con puntaje
compliance:write

🛡️ Regulación y cumplimiento

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • El importe de los gastos de la empresa
  • RDA / documentación de transporte
Modulos vinculados:
➔ inventory ➔ purchasing ➔ workorders