MarketplaceConfig

Tabelle: ltt_marketplace_config
Domain: MarketplaceConfig · com.reybex.domain.wws.marktplace
Modul: OMP

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)
token	varchar(5000)	Ja	—	Domain-Feld token
site_code	varchar(20)	Ja	—	Domain-Feld siteCode
template	text	Ja	—	template
description_template_id	bigint	Ja	—	Fremdschlüssel → description template
pay_pal_email_address	varchar(100)	Ja	—	Domain-Feld payPalEmailAddress
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)
is_global_shipping	smallint	Ja	0	Boolean: Global Shipping
unique_name	varchar(20)	Ja	—	unique name
is_customer_specific	smallint	Ja	0	Boolean: Customer Specific
is_policy_used	smallint	Ja	0	Boolean: Policy Used
is_policy_overwrite_existing_material	smallint	Ja	0	Boolean: Policy Overwrite Existing Material
is_ebay_pay_enabled	smallint	Ja	0	Boolean: Ebay Pay Enabled
seller_id	varchar(20)	Ja	—	Domain-Feld sellerId
mws_token	varchar(200)	Ja	—	mws token
doc_date_source	tinyint(1)	Ja	0	doc date source
fba_doc_date_source	smallint	Ja	0	fba doc date source
is_fba_active	smallint	Ja	—	Boolean: Fba Active
is_sp_api	smallint	Ja	0	Boolean: Sp Api
fba_sales_doc_type_id	bigint	Ja	—	Fremdschlüssel → fba sales doc type
is_upload_invoice_active	smallint	Ja	0	Boolean: Upload Invoice Active
fba_stock_move_type_id	bigint	Ja	—	Fremdschlüssel → fba stock move type
use_report_for_import	smallint	Ja	—	use report for import
endpoint_url	varchar(500)	Ja	—	Domain-Feld endpointUrl
username	varchar(500)	Ja	—	Domain-Feld username
PASSWORD	varchar(500)	Ja	—	Domain-Feld password
api_key	varchar(2000)	Ja	—	Domain-Feld apiKey
secret_key	varchar(500)	Ja	—	Domain-Feld secretKey
auth_username	varchar(500)	Ja	—	Domain-Feld authUsername
auth_password	varchar(500)	Ja	—	Domain-Feld authPassword
store_id	varchar(100)	Ja	—	Domain-Feld storeId
store_language	varchar(20)	Ja	—	Domain-Feld storeLanguage
profile_return_policy_id	bigint	Ja	—	Fremdschlüssel → profile return policy
profile_payment_id	bigint	Ja	—	Fremdschlüssel → profile payment
profile_shipping_id	bigint	Ja	—	Fremdschlüssel → profile shipping
is_variant_data_overwritten_by_import	smallint	Ja	0	Boolean: Variant Data Overwritten By Import
ebay_global_site	varchar(100)	Ja	'EBAY-DE'	Domain-Feld ebayGlobalSite
variant_configurator_type	smallint	Ja	0	variant configurator type
inland_shipping_cost	decimal(15, 2)	Ja	0.00	inland shipping cost
foreign_country_shipping_cost	decimal(15, 2)	Ja	0.00	foreign country shipping cost
ftp_order_path	varchar(150)	Ja	—	ftp order path
ftp_list_orders_path	varchar(150)	Ja	—	Domain-Feld ftpListOrdersPath
ftp_move_imported_orders_to_path	varchar(150)	Ja	—	Domain-Feld ftpMoveImportedOrdersToPath
ftp_update_orders_path	varchar(150)	Ja	—	Domain-Feld ftpUpdateOrdersPath
ftp_material_path	varchar(255)	Ja	—	ftp material path
ftp_update_materials_path	varchar(150)	Ja	—	Domain-Feld ftpUpdateMaterialsPath
ftp_set_stocks_path	varchar(150)	Ja	—	Domain-Feld ftpSetStocksPath
main_store_id	varchar(100)	Ja	—	Domain-Feld mainStoreId
sales_url	varchar(150)	Ja	—	Domain-Feld salesUrl
sales_channel	varchar(100)	Ja	—	Domain-Feld salesChannel
import_mode	smallint	Ja	—	import mode
name_import_mode	smallint	Ja	—	name import mode
description_import_mode	smallint	Ja	—	description import mode
stock_import_mode	smallint	Ja	—	stock import mode
price_import_mode	smallint	Ja	—	price import mode
image_import_mode	smallint	Ja	—	image import mode
check_alternative_sku	smallint	Ja	0	check alternative sku
upload_order_data	smallint	Ja	0	upload order data
upload_account_data	smallint	Ja	0	upload account data
upload_customer_data	smallint	Ja	0	upload customer data
upload_portal_customer_data	smallint	Ja	0	upload portal customer data
sales_price_list_id	bigint	Ja	—	Fremdschlüssel → sales price list
spapi_oauth_code	varchar(500)	Ja	—	spapi oauth code
refresh_token	varchar(5000)	Ja	—	Domain-Feld refreshToken
delivery_date1	datetime	Ja	—	Domain-Feld deliveryDate1
delivery_date2	datetime	Ja	—	Domain-Feld deliveryDate2
delivery_date3	datetime	Ja	—	Domain-Feld deliveryDate3
warehouse_id	bigint	Ja	—	Fremdschlüssel → warehouse
stock_place1_id	bigint	Ja	—	Fremdschlüssel → stock place1
stock_place2_id	bigint	Ja	—	Fremdschlüssel → stock place2
stock_place3_id	bigint	Ja	—	Fremdschlüssel → stock place3
pre_order_sales_doc_type_id	bigint	Ja	—	Fremdschlüssel → pre order sales doc type
upload_all_customer_data	smallint	Ja	0	upload all customer data
store_name	varchar(255)	Ja	—	Domain-Feld storeName
upload_material_special_prices	smallint	Ja	0	upload material special prices
fulfillment_id	bigint	Ja	—	Fremdschlüssel → fulfillment
max_order_count_to_import	int	Ja	—	Domain-Feld maxOrderCountToImport
is_ignore_parent_for_variant	smallint	Ja	0	Domain-Feld isIgnoreParentForVariant
is_disposal_calculated	smallint	Ja	1	Domain-Feld isDisposalCalculated
is_vendor_model	smallint	Ja	0	Domain-Feld isVendorModel
shopify_import_order_tags	varchar(150)	Ja	—	Domain-Feld shopifyImportOrderTags
use_external_order_no_fulfillment	smallint	Ja	0	use external order no fulfillment
import_returns_as_return_head	smallint	Ja	0	import returns as return head
is_iba	smallint	Ja	0	Boolean: Iba
import_disabled_items	tinyint(1)	Ja	0	import disabled items
alternative_carrier_name	varchar(50)	Ja	—	Domain-Feld alternativeCarrierName
alternative_shipping_method	varchar(50)	Ja	—	Domain-Feld alternativeShippingMethod
shopify_publications	varchar(200)	Ja	—	Domain-Feld shopifyPublications
calculate_stocks_by_locations	smallint	Ja	0	calculate stocks by locations
import_order_tags	smallint	Ja	0	import order tags
import_closed_gift_card_orders	tinyint(1)	Ja	0	import closed gift card orders
order_import_delay_in_minute	int	Ja	0	Domain-Feld orderImportDelayInMinute
dont_notify_in_days	int	Ja	0	Domain-Feld dontNotifyInDays
catalog_id	varchar(100)	Ja	—	Domain-Feld catalogId
is_main_connection	smallint	Ja	0	Boolean: Main Connection
use_catalog_management	smallint	Ja	0	use catalog management
country_id	bigint	Ja	—	Fremdschlüssel → country

Fremdschlüssel

Spalte(n)	Referenz
fulfillment_id	ltt_fulfillment (id)
profile_return_policy_id	ltt_ebay_seller_profile (id)
profile_payment_id	ltt_ebay_seller_profile (id)
profile_shipping_id	ltt_ebay_seller_profile (id)
description_template_id	ws_description_template (id)
country_id	lt_country (id)