PickListHead

Tabelle: pick_list_head
Domain: PickListHead · com.reybex.domain.wws.pick
Modul: SMP

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 auto_increment	Ja	—	Primärschlüssel (Domain: id)
tenant_id	bigint	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
doc_number	varchar(50)	Ja	—	Belegnummer (Domain: docNumber)
status_id	bigint	Nein	—	Fremdschlüssel → status
is_box_used	tinyint(1)	Nein	1	Boolean: Box Used
current_picker_id	bigint	Ja	—	Fremdschlüssel → current picker
is_delete	tinyint(1)	Nein	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
is_order_specific	tinyint(1)	Ja	0	Boolean: Order Specific
is_dummy	tinyint(1)	Nein	0	Boolean: Dummy
number_of_orders_filter	int	Ja	—	number of orders filter
order_size_filter	smallint	Ja	—	order size filter
are_boxes_used_filter	tinyint(1)	Ja	—	are boxes used filter
is_single_item_order_filter	tinytext	Ja	—	Boolean: Single Item Order Filter
start_filter	date	Ja	—	start filter
end_filter	date	Ja	—	end filter
payment_statuses_filter	varchar(999)	Ja	—	payment statuses filter
marktplaces_filter	varchar(999)	Ja	—	marktplaces filter
warehouses_filter	varchar(999)	Ja	—	warehouses filter
levels_filter	varchar(999)	Ja	—	levels filter
excluded_stock_places_filter	varchar(999)	Ja	—	excluded stock places filter
carriers_filter	varchar(999)	Ja	—	carriers filter
order_number_filter	varchar(10)	Ja	—	order number filter
date_created	datetime	Ja	—	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)
is_order_related_picking	tinyint(1)	Ja	0	Boolean: Order Related Picking
pick_list_profile_id	bigint	Ja	—	Fremdschlüssel → pick list profile

Fremdschlüssel

Spalte(n)	Referenz
status_id	lt_pick_list_head_status (id)
tenant_id	company (tenant_id)
current_picker_id	user (id)
pick_list_profile_id	pick_list_profile (id)