ProdOrder

Tabelle: prod_order
Domain: ProdOrder · 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)
doc_type_id	bigint	Nein	—	Fremdschlüssel → doc type
doc_number	varchar(50) charset utf8mb4	Ja	—	Belegnummer (Domain: docNumber)
material_id	bigint	Nein	—	Fremdschlüssel → material
alter_num	varchar(255) charset utf8mb4	Ja	—	alter num
batchnum	varchar(255) charset utf8mb4	Ja	—	Domain-Feld batchnum
variant_code	varchar(1000) charset utf8mb4	Ja	—	Domain-Feld variantCode
attribute_code	varchar(5000)	Ja	—	Domain-Feld attributeCode
scheduling_type	smallint	Nein	0	Domain-Feld schedulingType
plan_start	datetime	Nein	—	Domain-Feld planStart
plan_end	datetime	Nein	—	Domain-Feld planEnd
calc_start	datetime	Nein	—	Domain-Feld calcStart
calc_end	datetime	Nein	—	Domain-Feld calcEnd
detail_description	varchar(255) charset utf8mb4	Ja	—	Domain-Feld detailDescription
is_active	bit	Nein	—	Aktiv-Flag
is_delete	bit	Nein	—	Soft-Delete (0 = aktiv, 1 = gelöscht)
quantity	double	Nein	—	Menge
quantity_produced	double	Nein	—	quantity produced
special_stock	varchar(255) charset utf8mb4	Ja	—	Domain-Feld specialStock
status	smallint	Nein	—	Domain-Feld status
stock_place_id	bigint	Ja	—	Fremdschlüssel → stock place
unit_id	bigint	Nein	—	Fremdschlüssel → unit
warehouse_id	bigint	Nein	—	Fremdschlüssel → warehouse
notes	text charset utf8mb4	Ja	—	Interne Notizen (Domain: notes)
is_started	smallint	Nein	—	Domain-Feld isStarted
is_finished	smallint	Nein	—	Domain-Feld isFinished
profit_center_id	bigint	Ja	—	Fremdschlüssel → profit center
main_prod_order_id	bigint	Ja	—	Fremdschlüssel → main prod order
prod_order_levels	varchar(255) charset utf8mb4	Ja	—	Domain-Feld prodOrderLevels
range_number	bigint	Ja	—	Domain-Feld rangeNumber
date_created	datetime	Nein	—	Anlagezeitpunkt
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
order_description	varchar(200) charset utf8mb4	Ja	—	Domain-Feld orderDescription
stock_status	smallint	Ja	—	0: in stock,1:partly stock, 2: no stock
stock_status_message	varchar(5000) charset utf8mb4	Ja	—	Domain-Feld stockStatusMessage
expiry_date	datetime	Ja	—	Domain-Feld expiryDate
final_warehouse_id	bigint	Ja	—	Fremdschlüssel → final warehouse

Fremdschlüssel

Spalte(n)	Referenz
doc_type_id	ltt_prod_doc_type (id)
final_warehouse_id	ltt_warehouse (id)
tenant_id	company (tenant_id)