bom_direct_demand

Tabelle: bom_direct_demand
Domain: Keine zugeordnete Domain-Entität (Hilfstabelle, Legacy oder mandantenspezifisch).

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
tenant_id	int	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern)
date_created	datetime	Nein	—	Anlagezeitpunkt
main_alter_num	varchar(10)	Ja	—	main alter num
prod_order_material_id	bigint	Ja	—	Fremdschlüssel → prod order material
prod_order_alter_num	varchar(10)	Ja	—	prod order alter num
prod_order_variant_code	varchar(255)	Ja	—	prod order variant code
prod_order_attribute_code	text	Ja	—	prod order attribute code
prod_order_quantity	double	Ja	—	prod order quantity
prod_order_unit_id	bigint	Ja	—	Fremdschlüssel → prod order unit
material_id	bigint	Ja	—	Fremdschlüssel → material
unit_id	bigint	Ja	—	Fremdschlüssel → unit
bom_quantity_exchange_ratio	double	Ja	—	bom quantity exchange ratio
target_quantity	double	Ja	—	target quantity
fix_quantity	double	Ja	—	fix quantity
attribute_code	text	Ja	—	attribute code
variant_code	varchar(255)	Ja	—	variant code
is_calculate_qty_from_attribute	tinyint(1)	Ja	0	Boolean: Calculate Qty From Attribute
attribute_code_for_qty_calculation	text	Ja	—	attribute code for qty calculation
weight_in_gram	double	Ja	0	weight in gram
warehouse_id	bigint	Ja	—	Fremdschlüssel → warehouse
production_material_id	bigint	Ja	—	Fremdschlüssel → production material
production_material_bom_head_alter_num	varchar(10)	Ja	—	production material bom head alter num
production_material_variant_code	varchar(255)	Ja	—	production material variant code
production_material_bom_head_attribute_code	text	Ja	—	production material bom head attribute code