ShippingConfig

Tabelle: ltt_shipping_config
Domain: ShippingConfig · com.reybex.domain.wws.pick
Modul: SMP

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)
name	varchar(100)	Nein	—	Bezeichnung / Name (Domain: name)
doc_type1_id	bigint	Nein	—	Fremdschlüssel → doc type1
doc_type2_id	bigint	Ja	—	Fremdschlüssel → doc type2
doc_type3_id	bigint	Ja	—	Fremdschlüssel → doc type3
layout	int	Ja	—	Domain-Feld layout
doc_type_for_different_invoice_address1_id	bigint	Ja	—	Fremdschlüssel → doc type for different invoice address1
doc_type_for_different_invoice_address2_id	bigint	Ja	—	Fremdschlüssel → doc type for different invoice address2
layout_for_different_invoice_address	int	Ja	—	Domain-Feld layoutForDifferentInvoiceAddress
uses_doc_type_for_foreign_delivery1	smallint	Nein	0	uses doc type for foreign delivery1
uses_doc_type_for_foreign_delivery2	smallint	Nein	0	uses doc type for foreign delivery2
is_return_of_goods_printed	smallint	Nein	0	Boolean: Return Of Goods Printed
number_of_printed_foreign_delivery_documents	int	Nein	3	number of printed foreign delivery documents
print_document1	smallint	Ja	1	print document1
print_document2	smallint	Ja	1	print document2
create_label	smallint	Ja	1	create label
print_label	smallint	Ja	1	print label
show_only_complete_paid_orders	smallint	Ja	1	show only complete paid orders
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)
is_set_all_quantity	smallint	Ja	0	Boolean: Set All Quantity
advanced_package_mode	smallint	Ja	0	advanced package mode
show_picture	smallint	Ja	0	show picture
show_popup_if_order_completed	smallint	Ja	0	show popup if order completed
dont_show_third_party_items	smallint	Ja	1	dont show third party items
is_oversold_filter_used	smallint	Ja	0	Boolean: Oversold Filter Used
is_oversold_purchase_specific	smallint	Ja	0	Boolean: Oversold Purchase Specific
is_sales_head_partly_delivery_filtered	smallint	Ja	0	Boolean: Sales Head Partly Delivery Filtered
is_net_weight_used_in_packing_table	smallint	Ja	0	Boolean: Net Weight Used In Packing Table
is_packing_table_only_closed_when_complete	smallint	Ja	0	Domain-Feld isPackingTableOnlyClosedWhenComplete
packing_table_order_by_clause	text	Ja	—	Domain-Feld packingTableOrderByClause
is_picking_list_created_by_warehouse	smallint	Ja	0	Boolean: Picking List Created By Warehouse
is_sound_enabled	smallint	Ja	0	Boolean: Sound Enabled
use_einvoice_document	smallint	Ja	—	use einvoice document
process_after_box_full	smallint	Ja	1	process after box full
use_pick_boxes	smallint	Ja	0	use pick boxes
show_only_picked_orders	smallint	Ja	0	show only picked orders
source_order_type_id	bigint	Ja	—	Fremdschlüssel → source order type
is_pack_all_enabled	smallint	Ja	0	Boolean: Pack All Enabled
is_pick_quantity_double_checked	smallint	Ja	0	Boolean: Pick Quantity Double Checked
dont_refresh_order_list_after_save	smallint	Ja	0	dont refresh order list after save
open_first_order_after_search	smallint	Ja	0	open first order after search
is_auto_ship_after_scanned_all_items	smallint	Ja	0	Boolean: Auto Ship After Scanned All Items
barcode_configuration_id	bigint	Ja	—	Fremdschlüssel → barcode configuration
picking_profile_ids	varchar(300)	Ja	—	Domain-Feld pickingProfileIds
sys_printer_id	bigint	Ja	—	Fremdschlüssel → sys printer
allow_material_scan	smallint	Ja	0	allow material scan
send_barcode	varchar(50)	Ja	—	Domain-Feld sendBarcode
pack_all_barcode	varchar(50)	Ja	—	Domain-Feld packAllBarcode
is_generating_gs1_label	smallint	Ja	0	Boolean: Generating Gs1 Label
history_shipping_config_ids	varchar(255)	Ja	—	Domain-Feld historyShippingConfigIds

Fremdschlüssel

Spalte(n)	Referenz
tenant_id	company (tenant_id)
doc_type3_id	ltt_sales_doc_type (id)
barcode_configuration_id	ltt_barcode_configuration (id)
doc_type1_id	ltt_sales_doc_type (id)
doc_type2_id	ltt_sales_doc_type (id)
doc_type_for_different_invoice_address1_id	ltt_sales_doc_type (id)
doc_type_for_different_invoice_address2_id	ltt_sales_doc_type (id)
source_order_type_id	ltt_sales_doc_type (id)