VerificationHead

Tabelle: verification_head
Domain: VerificationHead · com.reybex.domain.wws.verification
Modul: QLT

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)
ref_verification_head_id	bigint	Ja	—	Fremdschlüssel → ref verification head
verification_doc_type_id	bigint	Nein	—	Belegart (Domain: docType)
doc_number	varchar(50)	Ja	—	Belegnummer (Domain: docNumber)
doc_date	date	Nein	—	Belegdatum
post_date	date	Nein	—	post date
valuta_date	date	Ja	—	valuta date
external_invoice_num	varchar(50)	Ja	—	Domain-Feld externalInvoiceNum
verification_status_id	bigint	Ja	—	0=Geparkt, 1=Gebucht
finance_document_id	bigint	Ja	—	Fremdschlüssel → finance document
post_key_id	bigint	Ja	—	Fremdschlüssel → post key
vat_key_id	bigint	Ja	—	Fremdschlüssel → vat key
net_amount	decimal(21, 10)	Ja	0.0000000000	net amount
vat_amount	decimal(21, 10)	Ja	0.0000000000	vat amount
brut_amount	decimal(21, 10)	Ja	0.0000000000	brut amount
currency_id	bigint	Ja	—	Fremdschlüssel → currency
exchange_rate	decimal(30, 20)	Ja	0.00000000000000000000	exchange rate
currency_date	datetime	Ja	—	currency date
vendor_id	bigint	Ja	—	Fremdschlüssel → vendor
payment_condition_id	bigint	Ja	—	Fremdschlüssel → payment condition
payment_type_id	bigint	Ja	—	Fremdschlüssel → payment type
profit_center_id	bigint	Ja	—	Fremdschlüssel → profit center
notes	mediumtext	Ja	—	Interne Notizen (Domain: notes)
cash_discount	decimal(21, 10)	Ja	0.0000000000	cash discount
dun_level	smallint	Ja	0	dun level
dun_amount	decimal(21, 10)	Ja	0.0000000000	dun amount
payment_until	date	Ja	—	payment until
invoice_date	date	Ja	—	invoice date
due_date	date	Ja	—	Domain-Feld dueDate
is_quick	smallint	Ja	0	Boolean: Quick
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
date_created	datetime	Ja	—	Anlagezeitpunkt
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
is_delete	smallint	Ja	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
cost_center_id	bigint	Ja	—	Fremdschlüssel → cost center
is_email_send	smallint	Ja	0	Boolean: Email Send
is_posted	smallint	Ja	0	Boolean: Posted
from_tenant_id	bigint	Ja	—	Domain-Feld fromTenantId
comm_message_id	bigint	Ja	—	Domain-Feld commMessageId
cs_total_kwh	decimal(20, 8)	Ja	—	cs total kwh
confirming_person_id	bigint	Ja	—	Fremdschlüssel → confirming person
is_from_api	smallint	Ja	0	Boolean: From Api
is_gross_price	smallint	Ja	0	Boolean: Gross Price
esr_code	varchar(50)	Ja	—	Domain-Feld esrCode
decline_title_id	bigint	Ja	—	Fremdschlüssel → decline title
is_archived	smallint	Ja	0	Boolean: Archived
einvoice_type	varchar(50)	Ja	—	Domain-Feld einvoiceType
remote_reference_number	varchar(50)	Ja	—	Domain-Feld remoteReferenceNumber
einvoice_preview_url	varchar(300)	Ja	—	Domain-Feld einvoicePreviewUrl
delivery_date	date	Ja	—	Domain-Feld deliveryDate
xml	longtext	Ja	—	Domain-Feld xml
alternative_currency_id	bigint	Ja	—	Fremdschlüssel → alternative currency
alternative_exchange_rate_to_doc_currency	decimal(30, 20)	Ja	0.00000000000000000000	Domain-Feld alternativeExchangeRateToDocCurrency
custom_fields	longtext	Ja	—	Domain-Feld customFields
swiss_payment_type	varchar(10)	Ja	—	Domain-Feld swissPaymentType
swiss_payment_reference	varchar(100)	Ja	—	Domain-Feld swissPaymentReference
iban	varchar(40)	Ja	—	Domain-Feld iban
paid_amount	decimal(21, 10)	Ja	0.0000000000	paid amount
vendor_bank_id	bigint	Ja	—	Fremdschlüssel → vendor bank
is_reduced_type	smallint	Ja	0	Boolean: Reduced Type

Fremdschlüssel

Spalte(n)	Referenz
decline_title_id	ltt_confirmation_decline_title (id)
tenant_id	company (tenant_id)
cost_center_id	cost_center (id)
verification_doc_type_id	ltt_verification_doc_type (id)
vendor_bank_id	customer_bank (id)
verification_status_id	lt_verification_status (id)
finance_document_id	ltt_fin_doc_type (id)
vat_key_id	ltt_vat_key (id)
currency_id	ltt_currency (id)
vendor_id	customer (id)
payment_condition_id	ltt_paymcond (id)
payment_type_id	ltt_payment_type (id)
profit_center_id	ltt_profit_center (id)
confirming_person_id	user (id)