Centurio Система и модул
🏛️ Архитектура на платформата 🔑 Login
🏠 Всички модули / manufacturing_execution / Производство и конфигурация
🔧

Производство и конфигурация

assembly manufacturing_execution 🛡️ RLS Protected

Производствени поръчки, производство на комплекта, многостепенни списъци на части и изработка на компоненти.

Fachliche Bestimmung: Подпомага монтажа и конфигурацията на продукти от отделни компоненти.Управлява списъци с елементи (вино материали) с фактори на изтегляне и срокове на монтаж.

⚡ Процес на развитие

Заказ за производство status:assembly_order

Процес на наблюдение (наблюдаема)

1. draft
Продукт
Статус <unk>проект <unk> на поръчката за производство на машината.
2. planned
Планирано
Статус <unk>планиран <unk> на машината в състояние Производствен поръчка.
3. in_progress
in_progress
Статус <unk>in_progress<unk> на работната машина.
4. on_hold
on_hold
Статус на машината в състояние за производство.
5. waiting_external
waiting_external
Статус <unk>waiting_external<unk> на машината в състояние за производство.
6. completed
завършено
Статус <unk> завършен <unk> на машината в състояние Производствена поръчка.
7. cancelled
отменено
Статус <unk>отменен <unk> натоварване на машината в състояние.

🗄️ Данни и полета

AssemblyBatchMembers assembly_batch_members RLS Aktiv
14 Поле / колони

Tabelle assembly_batch_members

Feldname Тип на данни Обявяване Schlüssel Специално значение
batch_id UUID Ja * FK ➔ assembly_batches.id Feld batch_id
order_id UUID Ja * FK ➔ assembly_orders.id Feld order_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
position INTEGER Ja * - Feld position
lot_code VARCHAR(64) Nein - Feld lot_code
quantity_in NUMERIC(14, 4) Ja * - Feld quantity_in
allocated_good NUMERIC(14, 4) Nein - Feld allocated_good
allocated_rework NUMERIC(14, 4) Nein - Feld allocated_rework
allocated_scrap NUMERIC(14, 4) Nein - Feld allocated_scrap
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
AssemblyBatches assembly_batches RLS Aktiv
19 Поле / колони

Tabelle assembly_batches

Feldname Тип на данни Обявяване Schlüssel Специално значение
title VARCHAR(255) Ja * - Feld title
status VARCHAR(24) Ja * - Feld status
master_order_id UUID Nein FK ➔ assembly_orders.id Feld master_order_id
allocation_method VARCHAR(16) Ja * - Feld allocation_method
pool_good NUMERIC(14, 4) Nein - Feld pool_good
pool_rework NUMERIC(14, 4) Nein - Feld pool_rework
pool_scrap NUMERIC(14, 4) Nein - Feld pool_scrap
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
AssemblyCores assembly_cores RLS Aktiv
24 Поле / колони

Tabelle assembly_cores

Feldname Тип на данни Обявяване Schlüssel Специално значение
product_id UUID Ja * FK ➔ products.id Feld product_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
contract_id UUID Nein FK ➔ contracts.id Feld contract_id
serial_number VARCHAR(128) Nein - Feld serial_number
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
status VARCHAR(24) Ja * - Feld status
condition_grade VARCHAR(16) Nein - Feld condition_grade
disposition VARCHAR(24) Nein - Feld disposition
inspection_notes TEXT Nein - Feld inspection_notes
location_id UUID Nein FK ➔ locations.id Feld location_id
stock_posted BOOLEAN Ja * - Feld stock_posted
received_at DATETIME Ja * - Feld received_at
assembly_order_id UUID Nein FK ➔ assembly_orders.id Feld assembly_order_id
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
AssemblyOrderItems assembly_order_items RLS Aktiv
24 Поле / колони

Tabelle assembly_order_items

Feldname Тип на данни Обявяване Schlüssel Специално значение
order_id UUID Ja * FK ➔ assembly_orders.id Feld order_id
item_type VARCHAR(48) Ja * - Feld item_type
product_id UUID Nein FK ➔ products.id Feld product_id
description VARCHAR(500) Ja * - Feld description
quantity_planned NUMERIC(14, 4) Ja * - Feld quantity_planned
quantity_actual NUMERIC(14, 4) Nein - Feld quantity_actual
quantity_good NUMERIC(14, 4) Nein - Feld quantity_good
quantity_rework NUMERIC(14, 4) Nein - Feld quantity_rework
quantity_scrap NUMERIC(14, 4) Nein - Feld quantity_scrap
unit VARCHAR(16) Ja * - Feld unit
unit_cost NUMERIC(14, 2) Nein - Feld unit_cost
position INTEGER Ja * - Feld position
tracking_entries JSONB Nein - Feld tracking_entries
notes TEXT Nein - Feld notes
material_ownership VARCHAR(16) Ja * - Feld material_ownership
owner_customer_id UUID Nein FK ➔ customers.id Feld owner_customer_id
rework_attempts INTEGER Ja * - Feld rework_attempts
from_location_id UUID Nein FK ➔ locations.id Feld from_location_id
to_location_id UUID Nein FK ➔ locations.id Feld to_location_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
AssemblyOrderSteps assembly_order_steps RLS Aktiv
30 Поле / колони

Tabelle assembly_order_steps

Feldname Тип на данни Обявяване Schlüssel Специално значение
order_id UUID Ja * FK ➔ assembly_orders.id Feld order_id
position INTEGER Ja * - Feld position
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
status VARCHAR(48) Ja * - Feld status
workstation_id UUID Nein FK ➔ workstations.id Feld workstation_id
estimated_minutes INTEGER Nein - Feld estimated_minutes
actual_minutes INTEGER Nein - Feld actual_minutes
image_url TEXT Nein - Feld image_url
image_urls JSONB Nein - Feld image_urls
completed_by UUID Nein FK ➔ users.id Feld completed_by
completed_at DATETIME Nein - Feld completed_at
notes TEXT Nein - Feld notes
is_external BOOLEAN Ja * - Feld is_external
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
external_ref VARCHAR(128) Nein - Feld external_ref
sent_at DATETIME Nein - Feld sent_at
received_at DATETIME Nein - Feld received_at
qty_sent NUMERIC(14, 4) Nein - Feld qty_sent
qty_received NUMERIC(14, 4) Nein - Feld qty_received
purchase_id UUID Nein FK ➔ purchases.id Feld purchase_id
purchase_item_id UUID Nein FK ➔ purchase_items.id Feld purchase_item_id
goods_receipt_id UUID Nein FK ➔ goods_receipts.id Feld goods_receipt_id
scheduled_date DATE Nein - Feld scheduled_date
schedule_plan JSONB Nein - Feld schedule_plan
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
AssemblyOrders assembly_orders RLS Aktiv
39 Поле / колони

Tabelle assembly_orders

Feldname Тип на данни Обявяване Schlüssel Специално значение
order_number VARCHAR(32) Ja * - Feld order_number
title VARCHAR(255) Ja * - Feld title
order_type VARCHAR(48) Ja * - Feld order_type
status VARCHAR(48) Ja * - Feld status
priority VARCHAR(16) Ja * - Feld priority
workstation_id UUID Nein FK ➔ workstations.id Feld workstation_id
assigned_user_id UUID Nein FK ➔ users.id Feld assigned_user_id
source_location_id UUID Nein FK ➔ locations.id Feld source_location_id
target_location_id UUID Nein FK ➔ locations.id Feld target_location_id
project_id UUID Nein FK ➔ projects.id Feld project_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
contract_id UUID Nein FK ➔ contracts.id Feld contract_id
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
scheduled_date DATE Nein - Feld scheduled_date
started_at DATETIME Nein - Feld started_at
completed_at DATETIME Nein - Feld completed_at
notes TEXT Nein - Feld notes
instructions TEXT Nein - Feld instructions
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
picking_policy VARCHAR(32) Ja * - Feld picking_policy
warehouse_picking_id UUID Nein FK ➔ warehouse_pickings.id Feld warehouse_picking_id
contract_snapshot JSONB Nein - Feld contract_snapshot
scrap_override_approved BOOLEAN Ja * - Feld scrap_override_approved
remainder_reuse_approved BOOLEAN Ja * - Feld remainder_reuse_approved
subcontract_supplier_id UUID Nein FK ➔ suppliers.id Feld subcontract_supplier_id
scheduled_end_date DATE Nein - Feld scheduled_end_date
due_date DATE Nein - Feld due_date
conflict_override_approved BOOLEAN Ja * - Feld conflict_override_approved
conflict_override_reason TEXT Nein - Feld conflict_override_reason
batch_id UUID Nein FK ➔ assembly_batches.id Feld batch_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
metadata JSONB Ja * - Feld metadata

🔌 Възходна точка (UI & API)

Art Метод Крайното място / път Titel & Zweck Оправомощение
⚡ REST API DELETE /api/v1/assembly/batches/{batch_id}/members/{order_id}
remove_batch_member
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API DELETE /api/v1/assembly/boms/{bom_id}
delete_bom
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API DELETE /api/v1/assembly/boms/{bom_id}/sop-documents/{document_id}
detach_bom_sop_document
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API DELETE /api/v1/assembly/items/{item_id}
remove_item
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API DELETE /api/v1/assembly/orders/{order_id}/sop-documents/{document_id}
detach_order_sop_document
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API DELETE /api/v1/assembly/workstations/{ws_id}
delete_workstation
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API DELETE /api/v1/assembly/workstations/{ws_id}/calendar/{exception_id}
delete_calendar_exception
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API GET /api/v1/assembly/batches
list_batches
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/batches/by-lot/{lot_code}
batches_by_lot_code
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/batches/{batch_id}
get_batch
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/batches/{batch_id}/genealogy
batch_genealogy
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/board
б)
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/boms
list_boms
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/boms/for-product/{product_id}
list_boms_for_product_endpoint
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/boms/lookup/{product_id}
lookup_bom_for_product
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/boms/{bom_id}
get_bom
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/boms/{bom_id}/availability
check_bom_material_availability
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/boms/{bom_id}/sop-documents
list_bom_sop_documents
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/boms/{bom_id}/steps
get_bom_steps
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/capacity/overview
capacity_overview
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/capacity/workstations/{ws_id}
workstation_capacity
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/cores
list_cores
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/cores/{core_id}
get_core
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/gateway
assembly_completion_gateway
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/lots/{lot_id}/genealogy
lot_genealogy
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/orders
list_orders
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/orders/{order_id}
get_order
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/orders/{order_id}/conflicts
order_conflicts
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/orders/{order_id}/sop-documents
list_order_sop_documents
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/workstations
list_workstations
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /api/v1/assembly/workstations/{ws_id}/calendar
list_calendar_exceptions
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /assembly
assembly_page
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /assembly/new
assembly_new_page
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /assembly/{order_id}
assembly_page
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /fertigung
fertigung_page
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /fertigung/new
fertigung_new_page
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API GET /fertigung/{order_id}
fertigung_page
Semantic binding: not_evaluated; mutation=False
assembly
⚡ REST API PATCH /api/v1/assembly/boms/{bom_id}
update_bom
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API PATCH /api/v1/assembly/items/{item_id}
update_item
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API PATCH /api/v1/assembly/steps/{step_id}
update_step
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API PATCH /api/v1/assembly/workstations/{ws_id}
update_workstation
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/batches
create_batch
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/batches/{batch_id}/cancel
cancel_batch
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/batches/{batch_id}/complete
complete_batch
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/batches/{batch_id}/start
start_batch
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/boms
create_bom
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/boms/upload-step-image
upload_bom_step_image
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/boms/{bom_id}/create-disassembly-order
create_disassembly_from_bom
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/boms/{bom_id}/create-order
create_order_from_bom
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/boms/{bom_id}/sop-documents
upload_bom_sop_document
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/cores
receive_core
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/cores/{core_id}/create-order
create_core_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/cores/{core_id}/inspect
inspect_core
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/create-from-order
create_order_from_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/items/{item_id}/yield
record_item_yield
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders
create_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/approve-conflict-override
approve_conflict_override
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/approve-remainder-reuse
approve_remainder_reuse
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/approve-scrap-override
approve_scrap_override
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/assign-workstation
assign_order_to_workstation
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/cancel
cancel_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/complete
complete_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/hold
hold_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/items
add_item
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/plan
plan_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/resume
resume_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/revoke-conflict-override
revoke_conflict_override
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/schedule
schedule_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/sop-documents
upload_order_sop_document
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/start
start_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/orders/{order_id}/steps
add_step
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/steps/{step_id}/create-purchase-order
create_subcontract_purchase_order
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/steps/{step_id}/receive-external
receive_step_external
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/steps/{step_id}/receive-goods
receive_subcontract_goods
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/steps/{step_id}/send-external
send_step_external
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/workstations
create_workstation
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/workstations/{ws_id}/assign-picking
assign_picking_to_workstation
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/workstations/{ws_id}/calendar
set_calendar_exception
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/workstations/{ws_id}/checkin
checkin_workstation
Semantic binding: not_evaluated; mutation=True
assembly
⚡ REST API POST /api/v1/assembly/workstations/{ws_id}/checkout
checkout_workstation
Semantic binding: not_evaluated; mutation=True
assembly

🛡️ Регулаторни и съответстващи

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Закон за безопасност на продуктите (ProdSG)
  • Оценка на съответните продукти
Свързани модули:
➔ inventory ➔ catalog ➔ workorders