VerificationItem

Tabelle: verification_item
Domain: VerificationItem · 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)
verification_head_id	bigint	Nein	—	Fremdschlüssel → verification head
ref_verification_item_id	bigint	Ja	—	Fremdschlüssel → ref verification item
position	int	Ja	0	Domain-Feld position
warehouse_id	bigint	Ja	—	Fremdschlüssel → warehouse
stockplace_id	bigint	Ja	—	Fremdschlüssel → stockplace
is_imported_from_stock	smallint	Ja	0	Boolean: Imported From Stock
material_id	bigint	Ja	—	Fremdschlüssel → material
material_text	varchar(300)	Ja	—	Domain-Feld materialText
vat_key_id	bigint	Ja	—	Fremdschlüssel → vat key
quantity	decimal(20, 8)	Ja	0.00000000	Menge (Domain: quantity)
quantity_unit_id	bigint	Ja	—	Fremdschlüssel → quantity unit
price	decimal(20, 8)	Ja	0.00000000	price
alternative_currency_price	decimal(20, 8)	Ja	0.00000000	alternative currency price
price_unit	decimal(20, 2)	Ja	0.00	price unit
post_key_id	bigint	Ja	—	Fremdschlüssel → post key
gross_amount	decimal(21, 2)	Ja	0.00	gross amount
vat_amount	decimal(21, 2)	Ja	0.00	vat amount
disc_amount	decimal(21, 2)	Ja	0.00	disc amount
head_disc_ratio	decimal(21, 8)	Ja	0.00000000	head disc ratio
head_disc_amount	decimal(21, 2)	Ja	0.00	head disc amount
net_amount	decimal(21, 2)	Ja	0.00	net amount
brut_amount	decimal(21, 2)	Ja	0.00	brut amount
pur_item_id	bigint	Ja	—	Fremdschlüssel → pur item
finance_item_id	bigint	Ja	—	Fremdschlüssel → finance item
stock_item_id	bigint	Ja	—	Fremdschlüssel → stock item
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
cost_center_id	bigint	Ja	—	Fremdschlüssel → cost center
is_delete	smallint	Ja	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
account_id	bigint	Ja	—	Fremdschlüssel → account
is_third_party	smallint	Ja	0	Boolean: Third Party
warehouse_unit_id	bigint	Ja	—	Fremdschlüssel → warehouse unit
warehouse_unit_quantity	decimal(30, 8)	Ja	0.00000000	warehouse unit quantity
warehouse_unit_exchange_ratio	decimal(40, 8)	Ja	1.00000000	warehouse unit exchange ratio
discount_input	varchar(20)	Ja	—	Domain-Feld discountInput
project_id	bigint	Ja	—	Fremdschlüssel → project
cs_average_ts	decimal(20, 8)	Ja	—	Domain-Feld csAverageTs
cs_total_quantity	decimal(20, 8)	Ja	—	Domain-Feld csTotalQuantity
cs_vendor_delivery_share	decimal(20, 8)	Ja	—	Domain-Feld csVendorDeliveryShare
variant_name	varchar(500)	Ja	—	Domain-Feld variantName
delivery_date	datetime	Ja	—	Domain-Feld deliveryDate
variant_code	varchar(1000)	Ja	—	Domain-Feld variantCode
long_description	text collate utf8mb4_unicode_ci	Ja	—	Domain-Feld longDescription
short_description	varchar(500)	Ja	—	Domain-Feld shortDescription
freight_cost	decimal(19, 2)	Ja	—	Domain-Feld freightCost
customs_cost	decimal(19, 2)	Ja	—	Domain-Feld customsCost
profit_center_id	bigint	Ja	—	Fremdschlüssel → profit center
cost_type	smallint	Ja	—	Domain-Feld costType
check_group_id	bigint	Ja	—	Fremdschlüssel → check group
asset_id	bigint	Ja	—	Fremdschlüssel → asset
sales_item_id	bigint	Ja	—	Fremdschlüssel → sales item
attribute_code	varchar(5000) collate utf8mb4_general_ci	Ja	—	Domain-Feld attributeCode
aquisition_price	double(20, 8)	Ja	0.00000000	aquisition price
cost_price	double(20, 8)	Ja	0.00000000	cost price
surchage1to_aquisition	double	Ja	0	Domain-Feld surchage1toAquisition
surchage1to_cost	double	Ja	0	Domain-Feld surchage1toCost
commission_number	varchar(50)	Ja	—	Domain-Feld commissionNumber
item_type	smallint	Ja	—	Domain-Feld itemType
prod_order_id	bigint	Ja	—	Fremdschlüssel → prod order
check_valid_from	datetime	Ja	—	Domain-Feld checkValidFrom
check_valid_until	datetime	Ja	—	Domain-Feld checkValidUntil
is_created_externally	smallint	Ja	0	Boolean: Created Externally

Fremdschlüssel

Spalte(n)	Referenz
account_id	account (id)
sales_item_id	sales_item (id)
check_group_id	ltt_verification_check_group (id)
verification_head_id	verification_head (id)
asset_id	asset (id)
prod_order_id	prod_order (id)
warehouse_unit_id	ltt_unit (id)
project_id	project (id)
warehouse_id	ltt_warehouse (id)
tenant_id	company (tenant_id)
pur_item_id	pur_item (id)
stock_item_id	stock_item (id)
material_id	material (id)
profit_center_id	ltt_profit_center (id)