FinItem

Tabelle: fin_item
Domain: FinItem · com.reybex.domain.wws.fin
Modul: FIN

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)
profit_center_id	bigint	Ja	—	Fremdschlüssel → profit center
fin_doc_type_id	bigint	Ja	—	Fremdschlüssel → fin doc type
fin_head_id	bigint	Nein	—	Fremdschlüssel → fin head
doc_number	varchar(50)	Ja	—	Belegnummer (Domain: docNumber)
position	int	Ja	0	position
doc_date	date	Ja	—	Belegdatum
post_date	date	Ja	—	post date
is_split	smallint	Ja	0	Boolean: Split
split_position	int	Ja	0	split position
postway	smallint	Ja	0	Domain-Feld postway
post_key_id	bigint	Ja	—	Fremdschlüssel → post key
account_type_id	bigint	Ja	—	Fremdschlüssel → account type
account_id	bigint	Ja	—	Konto
gl_account_type_id	bigint	Ja	—	Fremdschlüssel → gl account type
gl_account_id	bigint	Ja	—	Gegenkonto. bei Personenkonten steht hier das Mitbuchkonto
offset_account_type_id	bigint	Ja	—	Fremdschlüssel → offset account type
offset_account_id	bigint	Ja	—	Gegenkonto. hier muss das Personenkonto stehen
gl_offset_account_id	bigint	Ja	—	#### Deprecated ####
amount	decimal(20, 2)	Ja	0.00	amount
currency_id	bigint	Ja	—	Fremdschlüssel → currency
vat_key_id	bigint	Ja	—	Fremdschlüssel → vat key
vat_account_id	bigint	Ja	—	Fremdschlüssel → vat account
vat_rate	decimal(12, 2)	Ja	0.00	vat rate
vat_amount	decimal(20, 2)	Ja	0.00	vat amount
vat_key_rc_id	bigint	Ja	—	For EU steuer
vat_account_rc_id	bigint	Ja	—	For EU steuer
vat_rate_rc	decimal(20, 2)	Ja	—	For EU steuer
vat_amount_rc	decimal(20, 2)	Ja	—	For EU steuer
description	varchar(1000)	Ja	—	Beschreibung (Domain: description)
description2	varchar(1000)	Ja	—	Domain-Feld description2
fc_currency_id	bigint	Ja	—	Fremdschlüssel → fc currency
fc_amount	decimal(20, 2)	Ja	0.00	fc amount
fc_vat_amount	decimal(20, 2)	Ja	—	fc vat amount
fc_exchange_rate	decimal(30, 20)	Ja	0.00000000000000000000	fc exchange rate
fin_period	int	Ja	0	Domain-Feld finPeriod
fin_year	int	Ja	0	Domain-Feld finYear
cost_center_id	bigint	Ja	—	Fremdschlüssel → cost center
pur_item_id	bigint	Ja	—	Fremdschlüssel → pur item
verification_head_id	bigint	Ja	—	Fremdschlüssel → verification head
verification_item_id	bigint	Ja	—	Fremdschlüssel → verification item
sales_item_id	bigint	Ja	—	Fremdschlüssel → sales item
sales_head_id	bigint	Ja	—	Fremdschlüssel → sales head
external_invoice_no	varchar(1000)	Ja	—	Domain-Feld externalInvoiceNo
cash_disc_amount1	decimal(20, 2)	Ja	0.00	cash disc amount1
cash_disc_date1	date	Ja	—	Domain-Feld cashDiscDate1
cash_disc_amount2	decimal(20, 2)	Ja	0.00	cash disc amount2
cash_disc_date2	date	Ja	—	Domain-Feld cashDiscDate2
cash_disc_amount3	decimal(20, 2)	Ja	0.00	cash disc amount3
cash_disc_date3	date	Ja	—	Domain-Feld cashDiscDate3
bank_account_id	bigint	Ja	—	Fremdschlüssel → bank account
bank_code	varchar(50)	Ja	—	Domain-Feld bankCode
blz	varchar(50)	Ja	—	Domain-Feld blz
iban	varchar(50)	Ja	—	Domain-Feld iban
bic	varchar(20)	Ja	—	Domain-Feld bic
bank_account_no	varchar(20)	Ja	—	Domain-Feld bankAccountNo
bank_country	varchar(2)	Ja	—	Domain-Feld bankCountry
paymcond_id	bigint	Ja	—	Fremdschlüssel → paymcond
payment_type_id	bigint	Ja	—	Fremdschlüssel → payment type
due_date	date	Ja	—	Domain-Feld dueDate
dunning_date	date	Ja	—	Domain-Feld dunningDate
customer_id	bigint	Ja	—	Fremdschlüssel → customer
fin_open_item_id	bigint	Ja	—	Fremdschlüssel → fin open item
is_canceled	smallint	Ja	0	Boolean: Canceled
fin_page_id	bigint	Ja	—	Fremdschlüssel → fin page
statement_number	varchar(100)	Ja	—	Domain-Feld statementNumber
date_created	datetime	Ja	—	Anlagezeitpunkt
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
invoice_number	varchar(20)	Ja	—	Domain-Feld invoiceNumber
transaction_code	varchar(20)	Ja	—	Domain-Feld transactionCode
is_fee	smallint	Ja	0	Boolean: Fee
is_cash_discount	smallint	Ja	0	Boolean: Cash Discount
cash_close_id	bigint	Ja	—	Fremdschlüssel → cash close
customer_ustdid	varchar(50)	Ja	—	Domain-Feld customerUstdid
customer_country_id	bigint	Ja	—	Fremdschlüssel → customer country
is_datev_exported	smallint	Ja	0	Boolean: Datev Exported
fin_payment_head_id	bigint	Ja	—	Fremdschlüssel → fin payment head
fin_payment_item_id	bigint	Ja	—	Fremdschlüssel → fin payment item
is_currency_difference	smallint	Ja	0	Boolean: Currency Difference
transaction_id	varchar(500)	Ja	—	Domain-Feld transactionId
project_id	bigint	Ja	—	Fremdschlüssel → project
is_fin_post	smallint	Ja	0	Boolean: Fin Post
account_type_main_fin_open_item_id	bigint	Ja	—	Fremdschlüssel → account type main fin open item
external_code	varchar(200)	Ja	—	Domain-Feld externalCode
material_id	bigint	Ja	—	Fremdschlüssel → material
variant_code	varchar(1000)	Ja	—	Domain-Feld variantCode
warehouse_id	bigint	Ja	—	Fremdschlüssel → warehouse
stock_history_quantity	decimal(30, 8)	Ja	—	Domain-Feld stockHistoryQuantity
sales_invoice_id	bigint	Ja	—	Fremdschlüssel → sales invoice

Fremdschlüssel

Spalte(n)	Referenz
gl_account_type_id	ltt_account_type (id)
offset_account_type_id	ltt_account_type (id)
account_type_id	ltt_account_type (id)
customer_id	customer (id)
sales_head_id	sales_head (id)
tenant_id	company (tenant_id)
fin_head_id	fin_head (id)
cost_center_id	cost_center (id)
sales_item_id	sales_item (id)
pur_item_id	pur_item (id)
paymcond_id	ltt_paymcond (id)
payment_type_id	ltt_payment_type (id)
profit_center_id	ltt_profit_center (id)
fin_doc_type_id	ltt_fin_doc_type (id)
fc_currency_id	ltt_currency (id)
fin_open_item_id	fin_open_item (id)
verification_head_id	verification_head (id)
verification_item_id	verification_item (id)
vat_account_id	account (id)
fin_page_id	fin_page (id)
bank_account_id	account (id)
vat_account_rc_id	account (id)
vat_key_rc_id	ltt_vat_key (id)
cash_close_id	cash_close (id)
customer_country_id	lt_country (id)
currency_id	ltt_currency (id)
fin_payment_head_id	fin_payment_head (id)
fin_payment_item_id	fin_payment_item (id)
account_type_main_fin_open_item_id	fin_open_item (id)
material_id	material (id)
warehouse_id	ltt_warehouse (id)
vat_key_id	ltt_vat_key (id)
account_id	account (id)
offset_account_id	account (id)
offset_account_id	account (id)
gl_offset_account_id	account (id)
gl_account_id	account (id)