ProdOrderComponent

Tabelle: prod_order_component
Domain: ProdOrderComponent · com.reybex.domain.wws.production
Modul: PRD

Partner-Hinweise

• Daten liegen mandantengetrennt – bei SELECT fast immer tenant_id = :mandant setzen (Spalte ggf. TenantId in älteren Tabellen).
• Schreibende SQL (INSERT/UPDATE/DELETE) nur in abgestimmten Export-/Report-Jobs (Transaktion BAS23) und nie ohne Freigabe durch reybex.
• Für API-Integrationen bevorzugt die API statt direkter DB-Zugriffe.

→ Beispiel-SQLs (BAS23)

Primärschlüssel

• id

Spalten

Spalte	SQL-Typ	NULL	Default	Beschreibung
id	bigint	Nein	—	Primärschlüssel (Domain: id)
tenant_id	bigint	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
prod_order_id	bigint	Nein	—	Fremdschlüssel → prod order
parent_component_id	bigint	Ja	—	Fremdschlüssel → parent component
prod_order_operation_id	bigint	Ja	—	Fremdschlüssel → prod order operation
item_number	bigint	Ja	—	Domain-Feld itemNumber
short_description	varchar(500)	Ja	—	Domain-Feld shortDescription
component_id	bigint	Nein	—	Fremdschlüssel → component
base_quantity	double	Nein	—	Domain-Feld baseQuantity
target_quantity	double	Nein	—	Domain-Feld targetQuantity
ref_target_quantity	double	Ja	—	Domain-Feld refTargetQuantity
reserved_quantity	decimal(20, 8)	Ja	0.00000000	reserved quantity
issued_quantity	decimal(20, 8)	Ja	0.00000000	Boolean: sued Quantity
required_date	datetime	Ja	—	Domain-Feld requiredDate
stock_status	smallint	Ja	—	Domain-Feld stockStatus
unit_id	bigint	Nein	—	Fremdschlüssel → unit
warehouse_id	bigint	Ja	—	Fremdschlüssel → warehouse
stockplace_id	bigint	Ja	—	Fremdschlüssel → stockplace
specialstock	varchar(255)	Ja	—	Domain-Feld specialstock
batchnum	varchar(255)	Ja	—	Domain-Feld batchnum
variant_code	varchar(1000)	Ja	—	Domain-Feld variantCode
attribute_code	varchar(5000) collate utf8mb4_general_ci	Ja	—	Domain-Feld attributeCode
issue_single_parts	tinyint(1)	Ja	0	Boolean: sue Single Parts
just_in_time_production	tinyint(1)	Ja	0	just in time production
always_delivered	tinyint(1)	Ja	0	always delivered
vendor_provision	tinyint(1)	Ja	0	vendor provision
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
date_created	datetime	Nein	—	Anlagezeitpunkt
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
warehouse_unit_quantity	decimal(30, 8)	Ja	0.00000000	warehouse unit quantity
warehouse_unit_id	bigint	Ja	—	Fremdschlüssel → warehouse unit
warehouse_unit_exchange_ratio	decimal(40, 8)	Ja	1.00000000	warehouse unit exchange ratio
pick_start_date	datetime	Ja	—	Domain-Feld pickStartDate
picked_by_id	bigint	Ja	—	Fremdschlüssel → picked by
pick_open_quantity	decimal(20, 8)	Ja	—	Domain-Feld pickOpenQuantity
is_pick_skipped	smallint	Ja	0	Boolean: Pick Skipped
type	smallint	Ja	—	type
is_delete	smallint	Nein	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
reserved_unit_id	bigint	Ja	—	Fremdschlüssel → reserved unit
reject_quantity	double	Ja	0	reject quantity
fix_quantity	double	Ja	0	fix quantity
bom_quantity_exchange_ratio	double	Ja	—	bom quantity exchange ratio
is_calculate_qty_from_attribute	smallint	Ja	0	Boolean: Calculate Qty From Attribute
attribute_code_for_qty_calculation	varchar(200)	Ja	—	Domain-Feld attributeCodeForQtyCalculation

Fremdschlüssel

Spalte(n)	Referenz
warehouse_unit_id	ltt_warehouse (id)
picked_by_id	user (id)
tenant_id	company (tenant_id)
prod_order_id	prod_order (id)
reserved_unit_id	ltt_unit (id)