Configuration

Tabelle: configuration
Domain: Configuration · com.reybex.domain.core
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
• tenant_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)
is_logging_active	smallint	Nein	1	Boolean: Logging Active
is_instantly_editable	smallint	Nein	0	Boolean: Instantly Editable
is_semantic_zoom_search_active	smallint	Nein	0	1 heißt, dass anhand der Eingabe die Tabellenspalte für das Setzen des Filters ausgewählt wird.
calculate_acquisition_price_on_verification	smallint	Nein	0	calculate acquisition price on verification
create_purchasing_info_record	smallint	Ja	0	create purchasing info record
source_field_for_acquisition_calculation	varchar(20)	Ja	'lastPurPrice'	source field for acquisition calculation
renew_purchasing_info_record	smallint	Ja	1	renew purchasing info record
batchnum_format	varchar(30)	Ja	—	Domain-Feld batchnumFormat
is_batchnum_required	smallint	Nein	0	Boolean: Batchnum Required
is_batchnum_preallocated	smallint	Nein	1	Boolean: Batchnum Preallocated
is_batchnum_numeric	smallint	Nein	0	Boolean: Batchnum Numeric
are_batchnums_selected_on_warehouse_level	smallint	Ja	0	are batchnums selected on warehouse level
is_mat_code_numeric	smallint	Nein	0	Boolean: Mat Code Numeric
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)
active_canias_profile_id	bigint	Ja	—	Fremdschlüssel → active canias profile
is_imported_without_default_house_no	smallint	Ja	0	Boolean: Imported Without Default House No
does_remote_call_on_finishing_sending	smallint	Ja	0	does remote call on finishing sending
does_remote_call_on_reversing_sending	smallint	Ja	0	does remote call on reversing sending
does_remote_call_on_saving_pack	smallint	Ja	0	does remote call on saving pack
does_reversal_deletes_sending	smallint	Ja	0	does reversal deletes sending
is_packaging_weight_considered	smallint	Ja	0	Boolean: Packaging Weight Considered
is_main_collectible_weight_displayed	smallint	Ja	0	Boolean: Main Collectible Weight Displayed
is_main_collectible_measure_displayed	smallint	Ja	0	Boolean: Main Collectible Measure Displayed
is_sub_package_displayed	smallint	Ja	0	Boolean: Sub Package Displayed
is_weight_computed_automatically	smallint	Ja	0	Boolean: Weight Computed Automatically
parse_previuos_sales_item_delivery_date	smallint	Ja	0	parse previuos sales item delivery date
verification_vat_deviation	decimal(21, 2)	Ja	0.00	Domain-Feld verificationVatDeviation
is_finance_taxation_at_discount_enabled	smallint	Ja	1	Boolean: Finance Taxation At Discount Enabled
show_price_is_retrieved_from_sales_price_info	smallint	Ja	1	show price is retrieved from sales price info
datev_export_belegtfeld	varchar(50)	Ja	—	datev export belegtfeld
is_partial_delivery_standard	smallint	Ja	1	Boolean: Partial Delivery Standard
is_partly_delivery_requested	smallint	Ja	0	Boolean: Partly Delivery Requested
show_credit_notes_in_payments	smallint	Ja	1	show credit notes in payments
credit_note_warehouse_id	bigint	Ja	—	Fremdschlüssel → credit note warehouse
credit_note_stock_place_id	bigint	Ja	—	Fremdschlüssel → credit note stock place
type_for_percentual_margin	varchar(20)	Ja	'purchase'	type for percentual margin
type_for_percentual_margin2	varchar(20)	Ja	'purchase'	type for percentual margin2
type_for_percentual_margin3	varchar(20)	Ja	'purchase'	type for percentual margin3
is_license_key_used	smallint	Ja	0	Boolean: License Key Used
is_batchnum_used	smallint	Ja	0	Boolean: Batchnum Used
is_expiry_date_preallocated_with_batchnum	smallint	Ja	0	Boolean: Expiry Date Preallocated With Batchnum
is_auto_serial_number_booking_active	smallint	Ja	0	Boolean: Auto Serial Number Booking Active
is_auto_batch_number_booking_active	smallint	Ja	0	Boolean: Auto Batch Number Booking Active
is_serial_number_not_assigned_during_order_import	smallint	Ja	0	Boolean: Serial Number Not Assigned During Order Import
sales_head_type_for_file_document_name	varchar(255)	Ja	—	Domain-Feld salesHeadTypeForFileDocumentName
pur_head_type_for_file_document_name	varchar(255)	Ja	—	Domain-Feld purHeadTypeForFileDocumentName
is_gross_price	smallint	Ja	0	Boolean: Gross Price
is_sales_head_split_by_vendor	smallint	Ja	0	Boolean: Sales Head Split By Vendor
calculate_prices_from_surcharge	smallint	Ja	0	calculate prices from surcharge
margin_calculation	varchar(35)	Ja	—	margin calculation
margin_calculation2	varchar(35)	Ja	—	margin calculation2
margin_calculation3	varchar(35)	Ja	—	margin calculation3
currency_exchange_profit_id	bigint	Ja	—	Fremdschlüssel → currency exchange profit
currency_exchange_loss_id	bigint	Ja	—	Fremdschlüssel → currency exchange loss
money_transfer_account_id	bigint	Ja	—	Fremdschlüssel → money transfer account
surcharge_on_net	smallint	Ja	0	surcharge on net
type_for_file_document_name	varchar(100)	Ja	—	type for file document name
pick_list_stock	tinyint(1)	Ja	0	pick list stock
default_vat_key_id	bigint	Ja	—	Fremdschlüssel → default vat key
show_vendor_mat_code_in_arrival_booking	smallint	Ja	0	show vendor mat code in arrival booking
show_all_dunnings	smallint	Ja	0	show all dunnings
is_shipping_cost_dutied	smallint	Ja	0	Boolean: Shipping Cost Dutied
duty_shipping_option	smallint	Ja	0	Domain-Feld dutyShippingOption
fin_open_item_sort_type	smallint	Ja	0	fin open item sort type
is_avis_if_phone_exists	smallint	Ja	0	Boolean: Avis If Phone Exists
is_email_address_send_to_carriers	smallint	Ja	0	Boolean: Email Address Send To Carriers
is_return_label_added_to_shipping	smallint	Ja	0	Boolean: Return Label Added To Shipping
book_set_positions	smallint	Ja	0	book set positions
is_fin_payment_iban_required_disabled	smallint	Ja	0	Boolean: Fin Payment Iban Required Disabled
currency_exchange_rate_api_type	smallint	Ja	0	currency exchange rate api type
send_emails_from_current_user	smallint	Ja	0	send emails from current user
add_current_user_to_mail_bcc	smallint	Ja	0	add current user to mail bcc
is_datev_connect_active	smallint	Ja	0	Boolean: Datev Connect Active
sticker_template	varchar(35)	Ja	—	Domain-Feld stickerTemplate
material_label3language_id	bigint	Ja	—	Fremdschlüssel → material label3language
material_import_mode	smallint	Ja	1	material import mode
download_documents_seperately	smallint	Ja	0	download documents seperately
stock_post_price_type	varchar(200)	Ja	'purPrice'	stock post price type
deposit_account_id	bigint	Ja	—	Fremdschlüssel → deposit account
save_surcharge_as_sales_item	smallint	Ja	0	save surcharge as sales item
export_all_data	smallint	Ja	0	export all data
export_all_fields	smallint	Ja	0	export all fields
send_daily_stock_to_marketplaces	smallint	Ja	0	send daily stock to marketplaces
show_op_search_field	smallint	Ja	0	show op search field
is_new_page_for_picking_area	smallint	Ja	0	Boolean: New Page For Picking Area
picking_list_sort_type	smallint	Ja	0	picking list sort type
packing_list_sort_type	smallint	Ja	0	packing list sort type
picking_item_sort_type	smallint	Ja	0	picking item sort type
is_send_payment_advice_automatic	smallint	Ja	0	Boolean: Send Payment Advice Automatic
batchnum_number_range_id	bigint	Ja	—	Fremdschlüssel → batchnum number range
nve_number_range_id	bigint	Ja	—	Fremdschlüssel → nve number range
nve_type	smallint	Ja	0	Domain-Feld nveType
ignore_material_variant_ean_validation	smallint	Ja	0	ignore material variant ean validation
is_bom_uploaded_with_combined_skus	smallint	Ja	0	Boolean: Bom Uploaded With Combined Skus
prevent_blocked_delivery_unlock_on_paid	smallint	Ja	0	prevent blocked delivery unlock on paid
ean_number_range_id	bigint	Ja	—	Fremdschlüssel → ean number range
ean_type	smallint	Ja	0	ean type
minimum_profit	decimal(21, 2)	Ja	20.00	minimum profit
print_qr_code_on_invoice	smallint	Ja	0	print qr code on invoice
use_bpm	smallint	Ja	0	use bpm
time_based_reservation	smallint	Ja	0	time based reservation
is_all_fin_open_items	smallint	Ja	0	Boolean: All Fin Open Items
picking_order_sort_by	varchar(200)	Ja	—	picking order sort by
picking_order_group_by	varchar(200)	Ja	—	picking order group by
optimize_images	smallint	Ja	1	optimize images
cost_invoice_material_type	smallint	Ja	0	cost invoice material type
scale_image_by_size	smallint	Ja	0	scale image by size
use_variant_search	smallint	Ja	0	use variant search
words_for_address_search	varchar(1000)	Ja	—	words for address search
show_reason_dialog_after_change_delivery_date	smallint	Ja	0	show reason dialog after change delivery date
re_set_ref_sal_item_batch_num_when_booking	smallint	Ja	0	re set ref sal item batch num when booking
default_delimiter	varchar(1)	Ja	';'	Domain-Feld defaultDelimiter
material_xml_import_size	bigint	Ja	1000	material xml import size
use_picking_for_production	smallint	Ja	0	use picking for production
use_collective_picking_process	smallint	Ja	0	use collective picking process
using_old_frontend	smallint	Ja	0	using old frontend
is_scan_pickboxes	smallint	Ja	0	Boolean: Scan Pickboxes
is_stock_list_meta_data_enabled	smallint	Ja	0	Boolean: Stock List Meta Data Enabled
is_chat_enabled	smallint	Ja	0	Boolean: Chat Enabled
allow_low_price_cost_confirmation	smallint	Ja	0	allow low price cost confirmation
is_sales_set_separated	smallint	Ja	0	Boolean: Sales Set Separated
is_domain_locker_active	smallint	Ja	0	Boolean: Domain Locker Active
dont_send_return_of_fulfillment	smallint	Ja	1	dont send return of fulfillment
check_returned_quantity_manually	smallint	Ja	0	check returned quantity manually
match_payments_automatically	smallint	Ja	1	match payments automatically
match_invoices_automatically	smallint	Ja	1	match invoices automatically
calculate_sold_material	smallint	Ja	0	calculate sold material
calculate_pur_price_from_pur_item	smallint	Ja	0	calculate pur price from pur item
audit_proof_archiving	smallint	Nein	0	audit proof archiving
picking_list_check_incoming_data	smallint	Ja	0	picking list check incoming data
only_enable_delivery_stop_at_open_payments	smallint	Ja	0	only enable delivery stop at open payments
is_multi_order_picking	smallint	Ja	0	Boolean: Multi Order Picking
autom_set_quantity	smallint	Ja	0	autom set quantity
warn_if_quantity_greater_than_one	smallint	Ja	0	warn if quantity greater than one
show_only_pickplace_from_material_stock	smallint	Ja	0	show only pickplace from material stock
cancel_user_session_expiry_time	int	Ja	—	cancel user session expiry time
is_price_only_for_quantity	smallint	Ja	0	Boolean: Price Only For Quantity
is_credit_limit_exceedable	smallint	Ja	0	Boolean: Credit Limit Exceedable
estimated_inv_months	smallint	Ja	0	estimated inv months
pick_num_number_range_id	bigint	Ja	—	Fremdschlüssel → pick num number range
show_purchase_in_sales_discount	smallint	Ja	0	show purchase in sales discount
ksv	decimal(20, 8)	Ja	—	Domain-Feld ksv
do_sum_equal_materials	smallint	Ja	0	do sum equal materials
is_print_pallet_label	smallint	Ja	0	Boolean: Print Pallet Label
should_print_goods_receipt_report	smallint	Ja	0	should print goods receipt report
use_scanner_for_incoming_goods	smallint	Ja	0	use scanner for incoming goods
is_exchange_rate_reversed	smallint	Ja	0	Boolean: Exchange Rate Reversed
alternative_currency_id	bigint	Ja	—	Fremdschlüssel → alternative currency
is_pack_all_enabled	smallint	Ja	0	Boolean: Pack All Enabled
calculate_material_units_in_m3	smallint	Ja	0	calculate material units in m3
notify_on_no_valid_purchase_record	smallint	Ja	0	notify on no valid purchase record
dont_collect_units_in_picking	smallint	Ja	0	dont collect units in picking
terminal_configuration	text	Ja	—	Domain-Feld terminalConfiguration
crm_opportunity_number_range_id	bigint	Ja	—	Fremdschlüssel → crm opportunity number range
ask_for_pick_open_quantity_reset	smallint	Ja	0	ask for pick open quantity reset
is_volume_calculation_enabled	smallint	Ja	0	Boolean: Volume Calculation Enabled
is_generate_automatic_transfer_orders	smallint	Ja	0	Boolean: Generate Automatic Transfer Orders
crm_opportunity_default_customer_id	bigint	Ja	—	Fremdschlüssel → crm opportunity default customer
is_batchnum_from_order	smallint	Ja	0	Boolean: Batchnum From Order
book_return_without_return_head	smallint	Ja	0	book return without return head
is_total_units_displayed	smallint	Ja	0	Boolean: Total Units Displayed
is_main_collectible_units_displayed	smallint	Ja	0	Boolean: Main Collectible Units Displayed
contact_person_number_range_id	bigint	Ja	—	Fremdschlüssel → contact person number range
update_total_stock_list	smallint	Ja	0	update total stock list
shipping_config_id	bigint	Ja	—	Fremdschlüssel → shipping config
is_send_third_party_automatically	smallint	Ja	0	Boolean: Send Third Party Automatically
is_calculate_disposal_fee_on_customer_level	smallint	Ja	0	Boolean: Calculate Disposal Fee On Customer Level
do_not_replace_container_number	smallint	Ja	0	do not replace container number
default_variant_sku_separator	varchar(1)	Ja	—	Domain-Feld defaultVariantSkuSeparator
is_warn_on_closing_undercut	tinyint(1)	Ja	0	Boolean: Warn On Closing Undercut
show_material_picture_in_sales	smallint	Ja	0	show material picture in sales
show_material_picture_in_reports	smallint	Ja	0	show material picture in reports
display_booking_notes	smallint	Ja	—	display booking notes
packlist_number_range_id	bigint	Ja	—	Fremdschlüssel → packlist number range
share_vendor_data_as_manufacturer	smallint	Ja	0	share vendor data as manufacturer
book_even_serial_number_def_is_not_valid	smallint	Ja	0	book even serial number def is not valid
bbs_group_by_batchnum	smallint	Ja	0	bbs group by batchnum
bank_book_tolerance	decimal(10, 2)	Ja	—	bank book tolerance
is_req_quantity_hide	smallint	Ja	0	Boolean: Req Quantity Hide
is_ordered_quantity_hide	smallint	Ja	0	Boolean: Ordered Quantity Hide
is_over_sold_item_hide	smallint	Ja	0	Boolean: Over Sold Item Hide
is_ai_enabled	smallint	Ja	0	Boolean: Ai Enabled
recommend_discounts_in_payment_run	smallint	Ja	0	recommend discounts in payment run
auto_focus_inputs_in_mobile	smallint	Ja	0	auto focus inputs in mobile
group_by_doc_num_in_picking	smallint	Ja	0	group by doc num in picking
is_new_error_reporter_enabled	smallint	Ja	0	Boolean: New Error Reporter Enabled
only_show_not_canceled_fin_items	smallint	Ja	0	only show not canceled fin items
is_shipping_locker_active	smallint	Ja	0	Boolean: Shipping Locker Active
is_order_load_skipped_for_shipping	smallint	Ja	0	Boolean: Order Load Skipped For Shipping
is_auto_cross_tenant_material_copy_active	smallint	Ja	0	Boolean: Auto Cross Tenant Material Copy Active
is_material_price_attributes_enabled	smallint	Ja	0	Boolean: Material Price Attributes Enabled
skip_reason_required_on_packaging	smallint	Ja	0	skip reason required on packaging
update_third_party_purchase_on_finance_book	smallint	Ja	0	update third party purchase on finance book
is_post_invoice_to_finance_job_active	smallint	Ja	0	Boolean: Post Invoice To Finance Job Active
ignore_check_imported_verification_items	smallint	Ja	0	ignore check imported verification items
transfer_deliver_date_to_marketplace	smallint	Ja	0	transfer deliver date to marketplace
no_auto_attributes_on_items	smallint	Ja	1	no auto attributes on items
use_reybex_ai_extraction	smallint	Ja	0	use reybex ai extraction
show_customer_notes_popup	smallint	Ja	0	show customer notes popup
use_disposal_fee_special_surcharge_calculation	smallint	Ja	0	use disposal fee special surcharge calculation
do_weight_check	smallint	Ja	0	do weight check
wcheck_threshold1	decimal(10, 2)	Ja	—	Domain-Feld wcheckThreshold1
wcheck_threshold2	decimal(10, 2)	Ja	—	Domain-Feld wcheckThreshold2
is_bom_change_comment_required	smallint	Ja	0	Boolean: Bom Change Comment Required
stock_reservation_list_sync	smallint	Ja	0	stock reservation list sync
dont_update_stock_list	smallint	Ja	0	dont update stock list
count_list_sort_type	smallint	Ja	0	count list sort type
use_new_mrp_plan	smallint	Ja	0	use new mrp plan
use_seperate_gln_finding	smallint	Ja	0	use seperate gln finding
activate_release_for_purchase_orders	smallint	Ja	0	activate release for purchase orders
activate_release_for_production_orders	smallint	Ja	0	activate release for production orders

Fremdschlüssel

Spalte(n)	Referenz
pick_num_number_range_id	number_ranges (id)
tenant_id	company (tenant_id)
crm_opportunity_default_customer_id	customer (id)
contact_person_number_range_id	number_ranges (id)
currency_exchange_profit_id	account (id)
currency_exchange_loss_id	account (id)
default_vat_key_id	ltt_vat_key (id)
money_transfer_account_id	account (id)
deposit_account_id	account (id)
crm_opportunity_number_range_id	number_ranges (id)
ean_number_range_id	number_ranges (id)
packlist_number_range_id	number_ranges (id)