Legacy YAML / Detail

unitize / unitize_articles_suggestions_beny

Unveränderter Legacy-Dateistand mit sicherem Importpfad in die Workbench und direkter Sicht auf Roh-YAML, Metadaten und erkannte Features.

RLS aktiv Host ortho-live
Zurück zum Browser
Managed Definition öffnen

Legacy-Definition sicher vergleichen

Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.

Zum Raw YAML Zu den Metadaten
engine Typ
valid Parse-Status
Managed Status
draft
articles_suggestions_beny Kurzinfo

Raw YAML

Dateiinhalt

Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.

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

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

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" ]
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": null, "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" }
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" }