Engine / Editor
unitize_articles_suggestions_beny
Mandant default
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
unitize
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
Engine: Unitize Source_Config: unitizeEngine Target_Config: unitizeEngine Mysql_Engine: InnoDB Default_Charset: latin1 Source_Connection_Type: database Source_Database_Connection_Service: DatabaseConnectionService Source_Datapool: beny_suggestions_all_marketplaces Source_Primary_Key: [ID, SHOP, RANKING, MARKETPLACE] Target_Primary_Key: [Firm, No, Asnr, RANKING, MARKETPLACE, ItemEAN] #always primary key for target datapool. primary key of source pool can be read from the pool itself. Datapool: articles_suggestions_beny Add_Indices: - Add_Index: Datapool: articles_new Index_Name: idx_ordernumber_attr1 Fields: ordernumber, attr1 - Add_Index: Datapool: beny_suggestions_all_marketplaces Index_Name: idx_ORDERNUMBER_FIRMA Fields: ORDERNUMBER, FIRMA Joins: - Join: Datapool: dg_supplierdata_enhanced.articles_new Join_Condition: articles_new.ordernumber = beny_suggestions_all_marketplaces.ORDERNUMBER AND articles_new.attr1 = beny_suggestions_all_marketplaces.FIRMA Datapool_Definition: Firm: VARCHAR(10) NOT NULL Hwg: VARCHAR(10) NOT NULL Uwg: VARCHAR(10) DEFAULT NULL Sys: VARCHAR(10) DEFAULT NULL Pool: VARCHAR(10) DEFAULT NULL ItemEAN: VARCHAR(20) NOT NULL No: VARCHAR(50) NOT NULL Asnr: VARCHAR(50) NOT NULL ordernumber: VARCHAR(50) NOT NULL LiefNo: VARCHAR(50) DEFAULT NULL LiefName: VARCHAR(150) NOT NULL Name: TEXT DEFAULT NULL Hsbn: VARCHAR(50) NOT NULL EK300: VARCHAR(50) DEFAULT NULL VK: VARCHAR(50) DEFAULT NULL Kalk300: VARCHAR(50) DEFAULT NULL VKVorschlag: VARCHAR(50) DEFAULT NULL KalkVorschlag: VARCHAR(50) DEFAULT NULL Dif: VARCHAR(100) DEFAULT NULL Anbieter1: VARCHAR(100) DEFAULT NULL Preis1: VARCHAR(50) DEFAULT NULL Anbieter2: VARCHAR(100) DEFAULT NULL Preis2: VARCHAR(50) DEFAULT NULL Anbieter3: VARCHAR(100) DEFAULT NULL Preis3: VARCHAR(50) DEFAULT NULL AbsatzMenge3M: VARCHAR(50) DEFAULT NULL Werbepreis: VARCHAR(50) DEFAULT NULL changed_7_days: VARCHAR(50) DEFAULT NULL MARKETPLACE: VARCHAR(50) NOT NULL RANKING: VARCHAR(50) NOT NULL AnbieterPreis: TEXT DEFAULT NULL # SHOP: VARCHAR(50) NOT NULL Mapping: Firm: articles_new.attr1 Hwg: articles_new.attr2 Uwg: articles_new.attr3 Sys: articles_new.attr4 Pool: articles_new.attr5 ItemEAN: articles_new.ean No: articles_new.ARTE Asnr: beny_suggestions_all_marketplaces.APNR ordernumber: Source: articles_new.ARTE File_Field_Adapter: File: articles_suggestions_beny.ordernumber LiefNo: articles_new.suppliernumber_original LiefName: beny_suggestions_all_marketplaces.MANUFACTURER Name: articles_new.name_ost Hsbn: beny_suggestions_all_marketplaces.MPN EK300: articles_new.LBNTEK VK: articles_new.price_oms Kalk300: articles_new.LBKALK VKVorschlag: beny_suggestions_all_marketplaces.NEWPRICE KalkVorschlag: () Dif: () Anbieter1: () Preis1: () Anbieter2: () Preis2: () Anbieter3: () Preis3: () AbsatzMenge3M: articles_new.AbsatzMenge3M Werbepreis: () changed_7_days: () MARKETPLACE: beny_suggestions_all_marketplaces.MARKETPLACE RANKING: beny_suggestions_all_marketplaces.RANKING AnbieterPreis: beny_suggestions_all_marketplaces.AnbieterPreis # SHOP: beny_suggestions_all_marketplaces.SHOP
Definition aktualisieren