PaymentType

Tabelle: ltt_payment_type
Domain: PaymentType · com.reybex.domain.pms
Modul: SYS

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)
supported_payment_type_id	bigint	Ja	—	Fremdschlüssel → supported payment type
name	varchar(100)	Ja	—	Bezeichnung / Name (Domain: name)
code	varchar(100)	Ja	—	Code / Kurzkennzeichen (Domain: code)
account_id	bigint	Ja	—	Fremdschlüssel → account
collect_account_id	bigint	Ja	—	Fremdschlüssel → collect account
is_printed	smallint	Nein	1	Boolean: Printed
is_cash_register	smallint	Ja	0	Boolean: Cash Register
blocked_delivery	smallint	Ja	0	blocked delivery
block_delivery_if_no_transaction	smallint	Ja	0	block delivery if no transaction
blocked_delivery_amount	double(20, 2)	Ja	0.00	blocked delivery amount
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
payer_id	varchar(30)	Ja	—	Domain-Feld payerId
bank_iban	varchar(30)	Ja	—	Domain-Feld bankIban
bank_bic	varchar(20)	Ja	—	Domain-Feld bankBic
bank_name	varchar(100)	Ja	—	Domain-Feld bankName
bank_holder	varchar(100)	Ja	—	Domain-Feld bankHolder
description	longtext	Ja	—	Beschreibung (Domain: description)
paymcond_id	bigint	Ja	—	Fremdschlüssel → paymcond
is_cash	smallint	Ja	0	Boolean: Cash
open_cash_drawer	smallint	Ja	0	open cash drawer
create_fin_open_item	smallint	Ja	0	create fin open item
color	varchar(7)	Ja	—	Highlight color for sales documents table
commission_rate	decimal(20, 8)	Ja	—	Domain-Feld commissionRate
commission_abs	decimal(20, 8)	Ja	—	Domain-Feld commissionAbs
einvoice_code	varchar(50)	Ja	—	Domain-Feld einvoiceCode
is_disabled	smallint	Ja	0	Boolean: Disabled
sort_order	int	Ja	—	sort order
text_block_id	bigint	Ja	—	Fremdschlüssel → text block
print_qr_code_on_invoice	smallint	Ja	0	print qr code on invoice
book_directly_payment	smallint	Ja	0	book directly payment
take_over_total	smallint	Ja	0	take over total
is_association	smallint	Ja	0	Boolean: Association
cash_register_id	bigint	Ja	—	Fremdschlüssel → cash register
company_bank_id	bigint	Ja	—	Fremdschlüssel → company bank
use_terminal	smallint	Ja	0	use terminal
lock_dunning	smallint	Ja	0	lock dunning
is_direct_debit	smallint	Ja	0	Boolean: Direct Debit
qr_id	varchar(100)	Ja	—	Domain-Feld qrId
x_invoice_type	varchar(5)	Ja	—	Domain-Feld xInvoiceType

Fremdschlüssel

Spalte(n)	Referenz
tenant_id	company (tenant_id)
account_id	account (id)
collect_account_id	account (id)
cash_register_id	cash_register (id)
supported_payment_type_id	lt_supported_payment_type (id)
paymcond_id	ltt_paymcond (id)
text_block_id	ltt_text_block (id)