PurHead

Tabelle: pur_head
Domain: PurHead · com.reybex.domain.wws.purchase
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	Ja	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
profit_center_id	bigint	Ja	—	Fremdschlüssel → profit center
pur_doc_type_id	bigint	Ja	—	Belegart (Domain: docType)
doc_number	varchar(100)	Ja	—	Belegnummer (Domain: docNumber)
vendor_id	bigint	Ja	—	Fremdschlüssel → vendor
doc_date	datetime	Ja	—	Belegdatum
main_address_id	bigint	Ja	—	Fremdschlüssel → main address
delivery_address_id	bigint	Ja	—	Fremdschlüssel → delivery address
invoice_address_id	bigint	Ja	—	Fremdschlüssel → invoice address
is_delete	tinyint(1)	Ja	—	Soft-Delete (0 = aktiv, 1 = gelöscht)
is_send	tinyint(1)	Ja	—	Boolean: Send
is_print	tinyint(1)	Ja	—	Boolean: Print
delivery_status	int	Ja	0	delivery status
invoice_status	int	Ja	0	invoice status
freight_id	bigint	Ja	—	Fremdschlüssel → freight
shipping_id	bigint	Ja	—	Fremdschlüssel → shipping
pur_department_id	bigint	Ja	—	Fremdschlüssel → pur department
currency_id	bigint	Nein	—	Fremdschlüssel → currency
exchange_rate	decimal(30, 20)	Ja	0.00000000000000000000	Domain-Feld exchangeRate
language_id	bigint	Ja	—	Fremdschlüssel → language
contact_person_id	bigint	Ja	—	Fremdschlüssel → contact person
email_contact_person	varchar(100)	Ja	—	Domain-Feld emailContactPerson
vat_key_id	bigint	Ja	—	Fremdschlüssel → vat key
total_amount	decimal(20, 8)	Ja	0.00000000	total amount
total_discount_amount	decimal(20, 8)	Ja	0.00000000	total discount amount
nett_amount	decimal(20, 8)	Ja	0.00000000	nett amount
vat_amount	decimal(20, 8)	Ja	0.00000000	vat amount
gross_amount	decimal(20, 8)	Ja	0.00000000	gross amount
items_discount_amount	decimal(20, 8)	Ja	0.00000000	items discount amount
head_discount_amount	decimal(20, 8)	Ja	0.00000000	head discount amount
description	text	Ja	—	Beschreibung (Domain: description)
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)
delivery_customer_id	bigint	Ja	—	Fremdschlüssel → delivery customer
delivery_addressline1	varchar(255)	Ja	—	Domain-Feld deliveryAddressline1
delivery_addressline2	varchar(255)	Ja	—	Domain-Feld deliveryAddressline2
delivery_street1	varchar(255)	Ja	—	Domain-Feld deliveryStreet1
delivery_street2	varchar(255)	Ja	—	Domain-Feld deliveryStreet2
delivery_city	varchar(150)	Ja	—	Domain-Feld deliveryCity
delivery_province	varchar(50)	Ja	—	Domain-Feld deliveryProvince
delivery_is_pobox	tinyint(1)	Ja	—	Domain-Feld deliveryIsPobox
delivery_pobox_street	varchar(100)	Ja	—	Domain-Feld deliveryPoboxStreet
delivery_zip_pobox	varchar(50)	Ja	—	Domain-Feld deliveryZipPobox
delivery_zip_street	varchar(50)	Ja	—	Domain-Feld deliveryZipStreet
delivery_country_id	bigint	Ja	—	Fremdschlüssel → delivery country
delivery_language_id	bigint	Ja	—	Fremdschlüssel → delivery language
delivery_phone	varchar(50)	Ja	—	Domain-Feld deliveryPhone
delivery_gln	varchar(13)	Ja	—	Domain-Feld deliveryGln
delivery_ustd_id	varchar(14)	Ja	—	Domain-Feld deliveryUstdId
invoice_customer_id	bigint	Ja	—	Fremdschlüssel → invoice customer
invoice_addressline1	varchar(255)	Ja	—	Domain-Feld invoiceAddressline1
invoice_addressline2	varchar(255)	Ja	—	Domain-Feld invoiceAddressline2
invoice_street1	varchar(255)	Ja	—	Domain-Feld invoiceStreet1
invoice_street2	varchar(255)	Ja	—	Domain-Feld invoiceStreet2
invoice_city	varchar(150)	Ja	—	Domain-Feld invoiceCity
invoice_province	varchar(50)	Ja	—	Domain-Feld invoiceProvince
invoice_is_pobox	tinyint(1)	Ja	—	Domain-Feld invoiceIsPobox
invoice_pobox_street	varchar(100)	Ja	—	Domain-Feld invoicePoboxStreet
invoice_zip_pobox	varchar(50)	Ja	—	Domain-Feld invoiceZipPobox
invoice_zip_street	varchar(50)	Ja	—	Domain-Feld invoiceZipStreet
invoice_country_id	bigint	Ja	—	Fremdschlüssel → invoice country
invoice_language_id	bigint	Ja	—	Fremdschlüssel → invoice language
invoice_phone	varchar(50)	Ja	—	Domain-Feld invoicePhone
invoice_gln	varchar(13)	Ja	—	Domain-Feld invoiceGln
invoice_ustd_id	varchar(14)	Ja	—	Domain-Feld invoiceUstdId
main_addressline1	varchar(255)	Ja	—	Domain-Feld mainAddressline1
main_addressline2	varchar(255)	Ja	—	Domain-Feld mainAddressline2
main_street1	varchar(255)	Ja	—	Domain-Feld mainStreet1
main_street2	varchar(255)	Ja	—	Domain-Feld mainStreet2
main_city	varchar(150)	Ja	—	Domain-Feld mainCity
main_province	varchar(50)	Ja	—	Domain-Feld mainProvince
main_is_pobox	tinyint(1)	Ja	—	Domain-Feld mainIsPobox
main_pobox_street	varchar(100)	Ja	—	Domain-Feld mainPoboxStreet
main_zip_pobox	varchar(50)	Ja	—	Domain-Feld mainZipPobox
main_zip_street	varchar(50)	Ja	—	Domain-Feld mainZipStreet
main_country_id	bigint	Ja	—	Fremdschlüssel → main country
main_language_id	bigint	Ja	—	Fremdschlüssel → main language
main_phone	varchar(50)	Ja	—	Domain-Feld mainPhone
main_gln	varchar(13)	Ja	—	Domain-Feld mainGln
main_ustd_id	varchar(14)	Ja	—	Domain-Feld mainUstdId
notes	text	Ja	—	Interne Notizen (Domain: notes)
terms	text	Ja	—	Domain-Feld terms
comment_line	text	Ja	—	Domain-Feld commentLine
paymcond_id	bigint	Ja	—	Fremdschlüssel → paymcond
is_completed_manually	smallint	Ja	0	manuell geschlossen
main_vat_key_id	bigint	Ja	—	Fremdschlüssel → main vat key
delivery_vat_key_id	bigint	Ja	—	Fremdschlüssel → delivery vat key
ref_pur_head_id	bigint	Ja	—	Fremdschlüssel → ref pur head
int_order_num	varchar(50)	Ja	—	Domain-Feld intOrderNum
container_number	varchar(100)	Ja	—	Domain-Feld containerNumber
is_email_send	smallint	Ja	0	Boolean: Email Send
export	smallint	Ja	1	export
is_edi_send	smallint	Ja	0	Boolean: Edi Send
total_volume	decimal(30, 8)	Ja	0.00000000	total volume
pur_order_status_id	bigint	Ja	—	Fremdschlüssel → pur order status
required_date	datetime	Ja	—	Domain-Feld requiredDate
intrastat_profiles_id	bigint	Ja	—	Fremdschlüssel → intrastat profiles
delivery_mail	varchar(200)	Ja	—	Domain-Feld deliveryMail
sub_total	decimal(20, 8)	Ja	0.00000000	sub total
requisition_date	datetime	Ja	—	Domain-Feld requisitionDate
end_date	datetime	Ja	—	Domain-Feld endDate
packaging_id	bigint	Ja	—	Fremdschlüssel → packaging
delivery_date	datetime	Ja	—	Domain-Feld deliveryDate
delivery_email	varchar(200)	Ja	—	Domain-Feld deliveryEmail
invoice_email	varchar(200)	Ja	—	Domain-Feld invoiceEmail
main_email	varchar(200)	Ja	—	Domain-Feld mainEmail
custom_fields	longtext	Ja	—	Domain-Feld customFields
main_iln	varchar(100)	Ja	—	Domain-Feld mainIln
delivery_iln	varchar(100)	Ja	—	Domain-Feld deliveryIln
invoice_iln	varchar(100)	Ja	—	Domain-Feld invoiceIln
cargo_ready_date	date	Ja	—	Domain-Feld cargoReadyDate
estimated_departure_date	date	Ja	—	Domain-Feld estimatedDepartureDate
estimated_arrival_date	date	Ja	—	Domain-Feld estimatedArrivalDate

Fremdschlüssel

Spalte(n)	Referenz
pur_order_status_id	ltt_pur_order_status (id)
pur_doc_type_id	ltt_pur_doc_type (id)
freight_id	ltt_freight (id)
language_id	ltt_language (id)
tenant_id	company (tenant_id)
main_address_id	customer_address (id)
delivery_address_id	customer_address (id)
invoice_address_id	customer_address (id)
shipping_id	ltt_shipping (id)
invoice_language_id	ltt_language (id)
delivery_language_id	ltt_language (id)
invoice_country_id	lt_country (id)
delivery_country_id	lt_country (id)
main_language_id	ltt_language (id)
main_country_id	lt_country (id)
main_vat_key_id	ltt_vat_key (id)
delivery_vat_key_id	ltt_vat_key (id)
ref_pur_head_id	pur_head (id)
packaging_id	ltt_packaging (id)
vat_key_id	ltt_vat_key (id)
pur_department_id	ltt_pur_department (id)
currency_id	ltt_currency (id)
vendor_id	customer (id)
contact_person_id	customer_employee (id)
intrastat_profiles_id	ltt_intrastat_profiles (id)