Legacy YAML / Detail

unitize / unitize_iwm_articles_variants

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
iwm_articles_variants 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: importEngine
Target_Config: unitizeEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: iwm_articles_new
Source_Primary_Key: [TAB_KEY]
Target_Primary_Key: [ordernumber, firma]
Datapool: iwm_articles_variants

Add_Indices:
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_tab_key_aa01
      Fields: tab_key_AA01
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_tab_key_aa02
      Fields: tab_key_AA02
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_tab_key_aa03
      Fields: tab_key_AA03
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_aiaa01
      Fields: AIAA01
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_aiaa02
      Fields: AIAA02
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_aiaa03
      Fields: AIAA03
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_arte_auspr
      Fields: ARTE, AUSPRAEGUNGSNUMMER
  - Add_Index:
      Datapool: iwm_atab00
      Index_Name: idx_tab_key
      Fields: TAB_KEY
  - Add_Index:
      Datapool: dynamic_mapping_variant_dimensions_AA01
      Index_Name: idx_dimension_id
      Fields: dimension_id
  - Add_Index:
      Datapool: dynamic_mapping_variant_dimensions_AA02
      Index_Name: idx_dimension_id
      Fields: dimension_id
  - Add_Index:
      Datapool: dynamic_mapping_variant_dimensions_AA03
      Index_Name: idx_dimension_id
      Fields: dimension_id


Read_Conditions:
 - iwm_articles_new.ordernumber like '%-%'

Joins:
 - Left_Join:
   Datapool: iwm_atab00 ia1
   Join_Condition: ia1.TAB_KEY = iwm_articles_new.tab_key_AA01
 - Left_Join:
   Datapool: iwm_atab00 ia2
   Join_Condition: ia2.TAB_KEY = iwm_articles_new.tab_key_AA02
 - Left_Join:
   Datapool: iwm_atab00 ia3
   Join_Condition: ia3.TAB_KEY = iwm_articles_new.tab_key_AA03
 - Left_Join:
   Datapool: dynamic_mapping_variant_dimensions_AA01
   Join_Condition:  iwm_articles_new.AIAA01 = dynamic_mapping_variant_dimensions_AA01.dimension_id
 - Left_Join:
   Datapool: dynamic_mapping_variant_dimensions_AA02
   Join_Condition:  iwm_articles_new.AIAA02 = dynamic_mapping_variant_dimensions_AA02.dimension_id
 - Left_Join:
   Datapool: dynamic_mapping_variant_dimensions_AA03
   Join_Condition:  iwm_articles_new.AIAA03 = dynamic_mapping_variant_dimensions_AA03.dimension_id



Datapool_Definition:
    ordernumber: VARCHAR(255) NOT NULL
    mainnumber: VARCHAR(255) DEFAULT NULL
    arte: VARCHAR(255) DEFAULT NULL
    firma: INT(11) NOT NULL
    lieferantennummer: VARCHAR(50) DEFAULT NULL
    systemnummer: VARCHAR(50) DEFAULT NULL
    ATAFNR: VARCHAR(50) DEFAULT NULL
    ATKUBZ: VARCHAR(50) DEFAULT NULL
    ATLABZ: VARCHAR(50) DEFAULT NULL
    ATZUBZ: VARCHAR(50) DEFAULT NULL
    ATPGRP: VARCHAR(50) DEFAULT NULL
    variant_dimension_1: VARCHAR(50) DEFAULT NULL
    variant_dimension_2: VARCHAR(50) DEFAULT NULL
    variant_dimension_3: VARCHAR(50) DEFAULT NULL
    variant_dimension_1_value: VARCHAR(50) DEFAULT NULL
    variant_dimension_2_value: VARCHAR(50) DEFAULT NULL
    variant_dimension_3_value: VARCHAR(50) DEFAULT NULL
    variant_kurzbezeichnung: VARCHAR(50) DEFAULT NULL
    variant_langbezeichnung: VARCHAR(50) DEFAULT NULL
    configuratorOptions: VARCHAR(255) DEFAULT NULL



Mapping:
    ordernumber:
      Source: IF(iwm_articles_new.AUSPRAEGUNGSNUMMER = 0, iwm_articles_new.ARTE, CONCAT(iwm_articles_new.ARTE,'-',iwm_articles_new.AUSPRAEGUNGSNUMMER)) AS ordernumber
    mainnumber:
      Source: IF(iwm_articles_new.AUSPRAEGUNGSNUMMER = 0, iwm_articles_new.ARTE, CONCAT(iwm_articles_new.ARTE,'-1')) AS mainnumber
    arte: iwm_articles_new.ARTE
    firma: iwm_articles_new.firma
    lieferantennummer: iwm_articles_new.lieferantennummer
    systemnummer: iwm_articles_new.systemnummer
    ATAFNR: ia1.ATAFNR
    ATKUBZ: ia1.ATKUBZ
    ATLABZ: ia1.ATLABZ
    ATZUBZ: ia1.ATZUBZ
    ATPGRP: ia1.ATPGRP
    variant_dimension_1: dynamic_mapping_variant_dimensions_AA01.dimension_name_AA01
    variant_dimension_2: dynamic_mapping_variant_dimensions_AA02.dimension_name_AA02
    variant_dimension_3: dynamic_mapping_variant_dimensions_AA03.dimension_name_AA03
    variant_dimension_1_value: IF (ia1.ATZUBZ = '', ia1.ATLABZ, ia1.ATZUBZ) as variant_dimension_1_value
    variant_dimension_2_value: IF (ia2.ATZUBZ = '', ia2.ATLABZ, ia2.ATZUBZ) as variant_dimension_2_value
    variant_dimension_3_value: IF (ia3.ATZUBZ = '', ia3.ATLABZ, ia3.ATZUBZ) as variant_dimension_3_value
    variant_kurzbezeichnung: iwm_articles_new.variant_kurzbezeichnung
    variant_langbezeichnung: iwm_articles_new.variant_langbezeichnung
    configuratorOptions: ()

Metadata

Erkannte Konfiguration

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

Engine Unitize
Source_Config importEngine
Target_Config unitizeEngine
Mysql_Engine InnoDB
Default_Charset latin1
Source_Connection_Type database
Source_Database_Connection_Service DatabaseConnectionService
Source_Datapool iwm_articles_new
Source_Primary_Key [ "TAB_KEY" ]
Target_Primary_Key [ "ordernumber", "firma" ]
Datapool iwm_articles_variants
Add_Indices [ { "Add_Index": { "Datapool": "iwm_articles_new", "Index_Name": "idx_tab_key_aa01", "Fields": "tab_key_AA01" } }, { "Add_Index": { "Datapool": "iwm_articles_new", "Index_Name": "idx_tab_key_aa02", "Fields": "tab_key_AA02" } }, { "Add_Index": { "Datapool": "iwm_articles_new", "Index_Name": "idx_tab_key_aa03", "Fields": "tab_key_AA03" } }, { "Add_Index": { "Datapool": "iwm_articles_new", "Index_Name": "idx_aiaa01", "Fields": "AIAA01" } }, { "Add_Index": { "Datapool": "iwm_articles_new", "Index_Name": "idx_aiaa02", "Fields": "AIAA02" } }, { "Add_Index": { "Datapool": "iwm_articles_new", "Index_Name": "idx_aiaa03", "Fields": "AIAA03" } }, { "Add_Index": { "Datapool": "iwm_articles_new", "Index_Name": "idx_arte_auspr", "Fields": "ARTE, AUSPRAEGUNGSNUMMER" } }, { "Add_Index": { "Datapool": "iwm_atab00", "Index_Name": "idx_tab_key", "Fields": "TAB_KEY" } }, { "Add_Index": { "Datapool": "dynamic_mapping_variant_dimensions_AA01", "Index_Name": "idx_dimension_id", "Fields": "dimension_id" } }, { "Add_Index": { "Datapool": "dynamic_mapping_variant_dimensions_AA02", "Index_Name": "idx_dimension_id", "Fields": "dimension_id" } }, { "Add_Index": { "Datapool": "dynamic_mapping_variant_dimensions_AA03", "Index_Name": "idx_dimension_id", "Fields": "dimension_id" } } ]
Read_Conditions [ "iwm_articles_new.ordernumber like '%-%'" ]
Joins [ { "Left_Join": null, "Datapool": "iwm_atab00 ia1", "Join_Condition": "ia1.TAB_KEY = iwm_articles_new.tab_key_AA01" }, { "Left_Join": null, "Datapool": "iwm_atab00 ia2", "Join_Condition": "ia2.TAB_KEY = iwm_articles_new.tab_key_AA02" }, { "Left_Join": null, "Datapool": "iwm_atab00 ia3", "Join_Condition": "ia3.TAB_KEY = iwm_articles_new.tab_key_AA03" }, { "Left_Join": null, "Datapool": "dynamic_mapping_variant_dimensions_AA01", "Join_Condition": "iwm_articles_new.AIAA01 = dynamic_mapping_variant_dimensions_AA01.dimension_id" }, { "Left_Join": null, "Datapool": "dynamic_mapping_variant_dimensions_AA02", "Join_Condition": "iwm_articles_new.AIAA02 = dynamic_mapping_variant_dimensions_AA02.dimension_id" }, { "Left_Join": null, "Datapool": "dynamic_mapping_variant_dimensions_AA03", "Join_Condition": "iwm_articles_new.AIAA03 = dynamic_mapping_variant_dimensions_AA03.dimension_id" } ]
Datapool_Definition { "ordernumber": "VARCHAR(255) NOT NULL", "mainnumber": "VARCHAR(255) DEFAULT NULL", "arte": "VARCHAR(255) DEFAULT NULL", "firma": "INT(11) NOT NULL", "lieferantennummer": "VARCHAR(50) DEFAULT NULL", "systemnummer": "VARCHAR(50) DEFAULT NULL", "ATAFNR": "VARCHAR(50) DEFAULT NULL", "ATKUBZ": "VARCHAR(50) DEFAULT NULL", "ATLABZ": "VARCHAR(50) DEFAULT NULL", "ATZUBZ": "VARCHAR(50) DEFAULT NULL", "ATPGRP": "VARCHAR(50) DEFAULT NULL", "variant_dimension_1": "VARCHAR(50) DEFAULT NULL", "variant_dimension_2": "VARCHAR(50) DEFAULT NULL", "variant_dimension_3": "VARCHAR(50) DEFAULT NULL", "variant_dimension_1_value": "VARCHAR(50) DEFAULT NULL", "variant_dimension_2_value": "VARCHAR(50) DEFAULT NULL", "variant_dimension_3_value": "VARCHAR(50) DEFAULT NULL", "variant_kurzbezeichnung": "VARCHAR(50) DEFAULT NULL", "variant_langbezeichnung": "VARCHAR(50) DEFAULT NULL", "configuratorOptions": "VARCHAR(255) DEFAULT NULL" }
Mapping { "ordernumber": { "Source": "IF(iwm_articles_new.AUSPRAEGUNGSNUMMER = 0, iwm_articles_new.ARTE, CONCAT(iwm_articles_new.ARTE,'-',iwm_articles_new.AUSPRAEGUNGSNUMMER)) AS ordernumber" }, "mainnumber": { "Source": "IF(iwm_articles_new.AUSPRAEGUNGSNUMMER = 0, iwm_articles_new.ARTE, CONCAT(iwm_articles_new.ARTE,'-1')) AS mainnumber" }, "arte": "iwm_articles_new.ARTE", "firma": "iwm_articles_new.firma", "lieferantennummer": "iwm_articles_new.lieferantennummer", "systemnummer": "iwm_articles_new.systemnummer", "ATAFNR": "ia1.ATAFNR", "ATKUBZ": "ia1.ATKUBZ", "ATLABZ": "ia1.ATLABZ", "ATZUBZ": "ia1.ATZUBZ", "ATPGRP": "ia1.ATPGRP", "variant_dimension_1": "dynamic_mapping_variant_dimensions_AA01.dimension_name_AA01", "variant_dimension_2": "dynamic_mapping_variant_dimensions_AA02.dimension_name_AA02", "variant_dimension_3": "dynamic_mapping_variant_dimensions_AA03.dimension_name_AA03", "variant_dimension_1_value": "IF (ia1.ATZUBZ = '', ia1.ATLABZ, ia1.ATZUBZ) as variant_dimension_1_value", "variant_dimension_2_value": "IF (ia2.ATZUBZ = '', ia2.ATLABZ, ia2.ATZUBZ) as variant_dimension_2_value", "variant_dimension_3_value": "IF (ia3.ATZUBZ = '', ia3.ATLABZ, ia3.ATZUBZ) as variant_dimension_3_value", "variant_kurzbezeichnung": "iwm_articles_new.variant_kurzbezeichnung", "variant_langbezeichnung": "iwm_articles_new.variant_langbezeichnung", "configuratorOptions": "()" }