PurDocType

Tabelle: ltt_pur_doc_type
Domain: PurDocType · com.reybex.domain.wws
Modul: PUR

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)
number_range_id	bigint	Nein	—	Fremdschlüssel → number range
name	varchar(50)	Ja	—	Bezeichnung / Name (Domain: name)
type	int	Ja	0	0=Anfrage, 1=Rahmenkontrakt/Mengenkontrakt ,2=Bestellung, 3=Abruf
report_id	bigint	Ja	—	Fremdschlüssel → report
inv_doc_type_id	bigint	Ja	—	Fremdschlüssel → inv doc type
date_created	datetime	Ja	—	Anlagezeitpunkt
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
unique_name	varchar(20)	Ja	—	unique name
is_customer_specific	smallint	Ja	0	Boolean: Customer Specific
closing_gap	float(4, 2)	Ja	—	Domain-Feld closingGap
lower_delivery_tolerance	decimal(20, 2)	Ja	—	Domain-Feld lowerDeliveryTolerance
upper_delivery_tolerance	decimal(20, 2)	Ja	—	Domain-Feld upperDeliveryTolerance
show_print_logo	smallint	Ja	0	show print logo
show_print_footer	smallint	Ja	1	show print footer
show_email_logo	smallint	Ja	1	show email logo
show_email_footer	smallint	Ja	1	show email footer
is_disabled	smallint	Ja	0	Boolean: Disabled
sort_order	int	Ja	—	sort order
email_template_id	bigint	Ja	—	Fremdschlüssel → email template
check_open_order_to_add_materials	smallint	Ja	0	check open order to add materials
show_fulfillment_button	smallint	Ja	0	show fulfillment button
print_delivery_date	smallint	Ja	0	print delivery date
is_transfer	smallint	Ja	—	Boolean: Transfer
print_material_attributes	smallint	Ja	0	print material attributes
use_in_mrp	smallint	Ja	—	use in mrp
automatic_order_send_mail	smallint	Ja	0	automatic order send mail
automatic_order_set_confirmed	smallint	Ja	0	automatic order set confirmed
is_pur_order_closed_after_first_inbound	smallint	Ja	0	Boolean: Pur Order Closed After First Inbound
archive_retention_time_in_month	smallint	Ja	0	Domain-Feld archiveRetentionTimeInMonth
report2_id	bigint	Ja	—	Fremdschlüssel → report2
scan_product	smallint	Ja	0	scan product
print_relation_based_report	smallint	Ja	0	print relation based report

Fremdschlüssel

Spalte(n)	Referenz
email_template_id	email_template (id)
tenant_id	company (tenant_id)
inv_doc_type_id	ltt_inv_doc_type (id)
number_range_id	number_ranges (id)
report_id	ltt_report (id)