SupportedMarktplace

Tabelle: lt_supported_marktplace
Domain: SupportedMarktplace · 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)
name	varchar(50)	Nein	—	Bezeichnung / Name (Domain: name)
endpoint_url	varchar(200)	Ja	—	Domain-Feld endpointUrl
marketplace_url	varchar(200)	Ja	—	Domain-Feld marketplaceUrl
provider	varchar(100)	Nein	—	Domain-Feld provider
seller_id	varchar(100)	Ja	—	Domain-Feld sellerId
developer_number	varchar(100)	Ja	—	Domain-Feld developerNumber
ebay_dev_id	varchar(100)	Ja	—	Domain-Feld ebayDevId
ebay_app_id	varchar(100)	Ja	—	Domain-Feld ebayAppId
ebay_cert_id	varchar(100)	Ja	—	Domain-Feld ebayCertId
ebay_ru_name	varchar(100)	Ja	—	Domain-Feld ebayRuName
accepts_html_description	smallint	Ja	0	accepts html description
site_code	varchar(100)	Ja	—	Domain-Feld siteCode
batch_size	int	Ja	500	batch size
is_upload_response_asynchronous	smallint	Ja	0	Boolean: Upload Response Asynchronous
access_key	varchar(100)	Ja	—	Domain-Feld accessKey
secret_key	varchar(100)	Ja	—	Domain-Feld secretKey
client_id	varchar(100)	Ja	—	Domain-Feld clientId
client_secret	varchar(100)	Ja	—	Domain-Feld clientSecret
amazon_marketplace_id	varchar(50)	Ja	—	Domain-Feld amazonMarketplaceId
language_code	varchar(3)	Ja	'de'	Domain-Feld languageCode
need_image_with_stream	smallint	Ja	0	need image with stream
is_shop	smallint	Ja	0	Boolean: Shop
has_shop_category	smallint	Ja	0	has shop category
is_main_category_select_allowed	smallint	Ja	1	Boolean: Main Category Select Allowed
is_variant_mapping_required	smallint	Nein	0	Boolean: Variant Mapping Required
is_beta	smallint	Ja	0	Boolean: Beta
check_sku_during_upload	smallint	Ja	1	check sku during upload
check_sku_format_during_upload	smallint	Ja	0	check sku format during upload
check_price_during_upload	smallint	Ja	1	check price during upload
check_category_during_upload	smallint	Ja	0	check category during upload
check_variant_category_during_upload	smallint	Ja	0	check variant category during upload
check_description_during_upload	smallint	Ja	0	check description during upload
check_picture_during_upload	smallint	Ja	0	check picture during upload
check_ean_during_upload	smallint	Ja	0	check ean during upload
always_refresh_pictures	smallint	Ja	1	always refresh pictures
has_category_specs	smallint	Ja	0	has category specs
has_category_spec_item_map	smallint	Ja	0	has category spec item map
possible_order_status	varchar(1000)	Ja	—	Domain-Feld possibleOrderStatus
is_import_report_supported	smallint	Ja	0	Boolean: Import Report Supported
is_category_import_enabled	smallint	Ja	0	Boolean: Category Import Enabled
is_material_import_enabled	smallint	Ja	0	Boolean: Material Import Enabled
max_material_count_demo_import	int	Ja	100	max material count demo import
max_order_count_demo_import	int	Ja	100	max order count demo import
default_accepted_payment_types	varchar(100)	Ja	—	Domain-Feld defaultAcceptedPaymentTypes
default_accepted_shipping_types	varchar(100)	Ja	—	default accepted shipping types
default_accepted_shippings	varchar(100)	Ja	—	Domain-Feld defaultAcceptedShippings
default_max_process_days	int	Ja	30	default max process days
default_max_stock	int	Ja	30	default max stock
default_past_days	int	Ja	7	default past days
default_marketplace_order_type_ids	varchar(500)	Ja	—	Domain-Feld defaultMarketplaceOrderTypeIds
default_marketplace_status_imported	varchar(255)	Ja	—	Domain-Feld defaultMarketplaceStatusImported
default_marketplace_status_shipped	varchar(255)	Ja	—	Domain-Feld defaultMarketplaceStatusShipped
default_material_fields_to_export	varchar(500)	Ja	—	Domain-Feld defaultMaterialFieldsToExport
allowed_fields_to_export	varchar(500)	Ja	—	Domain-Feld allowedFieldsToExport
max_material_count_import	int	Ja	100	max material count import
max_order_count_import	int	Ja	100	max order count import
is_variant_sync_separated	smallint	Ja	0	Boolean: Variant Sync Separated
is_disposal_calculated	smallint	Ja	0	Boolean: Disposal Calculated
ftp_client_types	varchar(200)	Ja	—	Domain-Feld ftpClientTypes
commission_rate1	decimal(20, 8)	Ja	—	Domain-Feld commissionRate1
commission_rate2	decimal(20, 8)	Ja	—	Domain-Feld commissionRate2
additional_description_text	mediumtext	Ja	—	Domain-Feld additionalDescriptionText
is_support_same_variant_id	smallint	Ja	0	Boolean: Support Same Variant Id
sales_url	varchar(150)	Ja	—	Domain-Feld salesUrl
category_job_interval	smallint	Ja	0	category job interval
sort_order	int	Ja	0	Domain-Feld sortOrder
channels	mediumtext	Ja	—	Domain-Feld channels
is_orders_cancelable	smallint	Ja	0	Boolean: Orders Cancelable
check_picture_dimensions_during_upload	smallint	Ja	0	check picture dimensions during upload
order_update_batch_size	int	Ja	—	Domain-Feld orderUpdateBatchSize
default_material_import_ignored_fields	varchar(2750) charset utf8mb4	Ja	—	Domain-Feld defaultMaterialImportIgnoredFields
ignored_fields_for_stock_upload	varchar(250)	Ja	—	ignored fields for stock upload