VerificationDocType

Tabelle: ltt_verification_doc_type
Domain: VerificationDocType · 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)
name	varchar(100)	Ja	—	Bezeichnung / Name (Domain: name)
description	varchar(50)	Ja	—	remove after deployen
type	varchar(50)	Nein	—	Domain-Feld type
tenant_id	bigint	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
is_invoice	tinyint(1)	Ja	—	Boolean: Invoice
is_creditnote	tinyint(1)	Ja	—	Boolean: Creditnote
is_reversal	tinyint(1)	Ja	0	Boolean: Reversal
number_range_id	bigint	Nein	—	Fremdschlüssel → number range
finance_doc_type_id	bigint	Ja	—	Fremdschlüssel → finance doc type
finance_postkey_id	bigint	Ja	—	Fremdschlüssel → finance postkey
multiplier	int	Ja	—	multiplier
is_booking_enabled	smallint	Ja	0	Boolean: Booking Enabled
inv_doc_type_id	bigint	Ja	—	Fremdschlüssel → inv doc type
inv_doc_type_for_third_party_id	bigint	Ja	—	Fremdschlüssel → inv doc type for third party
stock_move_type_id	bigint	Ja	—	Fremdschlüssel → stock move 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
is_disabled	smallint	Ja	0	Boolean: Disabled
sort_order	int	Ja	—	sort order
report_id	bigint	Ja	—	Fremdschlüssel → report
check_total_amounts	smallint	Ja	1	check total amounts
is_cost_invoice	smallint	Ja	0	Boolean: Cost Invoice
fin_post_stock_id	bigint	Ja	—	Fremdschlüssel → fin post stock
archive_retention_time_in_month	smallint	Ja	—	Domain-Feld archiveRetentionTimeInMonth
einvoice_doc_type	smallint	Ja	—	Domain-Feld einvoiceDocType
sales_relation_required	smallint	Ja	0	sales relation required
is_automatic_verification_posting	smallint	Ja	0	Boolean: Automatic Verification Posting
automatic_verification_posting_limit	decimal(20, 2)	Ja	—	Domain-Feld automaticVerificationPostingLimit
check_group_id	bigint	Ja	—	Fremdschlüssel → check group
confirm_check_group_id	bigint	Ja	—	Fremdschlüssel → confirm check group
fallback_check_group_id	bigint	Ja	—	Fremdschlüssel → fallback check group
target_warehouse_id	bigint	Ja	—	Fremdschlüssel → target warehouse
item_type	smallint	Ja	0	item type
book_with_differences	smallint	Ja	0	book with differences
max_total_difference	decimal(20, 2)	Ja	—	max total difference
max_percentage_difference	decimal(20, 2)	Ja	—	max percentage difference
is_purchase_import_grouped_by_pur_item	smallint	Ja	0	Boolean: Purchase Import Grouped By Pur Item
use_sales_vat_keys	smallint	Ja	0	use sales vat keys
x_invoice_type	varchar(5)	Ja	—	Domain-Feld xInvoiceType
is_bonus	smallint	Ja	0	Boolean: Bonus
is_reduced_type	smallint	Ja	0	Boolean: Reduced Type
copy_relations_with_pur_item_copy	smallint	Ja	0	copy relations with pur item copy
report2_id	bigint	Ja	—	Fremdschlüssel → report2
is_printed_attachment	smallint	Ja	1	Boolean: Printed Attachment
skip_account_from_material	smallint	Ja	0	skip account from material

Fremdschlüssel

Spalte(n)	Referenz
report_id	ltt_report (id)
finance_doc_type_id	ltt_fin_doc_type (id)
target_warehouse_id	ltt_warehouse (id)
fallback_check_group_id	ltt_verification_check_group (id)
number_range_id	number_ranges (id)
fin_post_stock_id	fin_post_stock (id)
check_group_id	ltt_verification_check_group (id)
confirm_check_group_id	ltt_verification_check_group (id)
report2_id	ltt_report (id)