Legacy YAML / Detail

unitize / unitize_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_atab00
Source_Primary_Key: [TAB_KEY]
Target_Primary_Key: [ordernumber, firma] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: iwm_articles_variants

Add_Indices:
  - 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_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

Joins:
 - Left_Join:
   Datapool: iwm_articles_new
   Join_Condition: iwm_atab00.TAB_KEY = CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(iwm_articles_new.FIRMA,'-'),iwm_articles_new.LIEFERANTENNUMMER),'-'),iwm_articles_new.SYSTEMNUMMER),'-'),iwm_articles_new.AIAA01),'-'),iwm_articles_new.AIAFN1)
 - 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: iwm_atab00.ATLINR
    systemnummer: iwm_atab00.ATSYSN
    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
    configuratorOptions: VARCHAR(255) DEFAULT NULL





Mapping:
    ordernumber:
      Source: IF(iwm_articles_new.AIAPNR = 0, iwm_articles_new.ARARTE, CONCAT(iwm_articles_new.ARARTE,'-',iwm_articles_new.AIAPNR)) AS ordernumber
    mainnumber:
      Source: IF(iwm_articles_new.AIAPNR = 0, iwm_articles_new.ARARTE, CONCAT(iwm_articles_new.ARARTE,'-1')) AS mainnumber
    arte: iwm_articles_new.ARARTE
    firma: iwm_articles_new.ARFIRM
    lieferantennummer: iwm_atab00.ATLINR
    systemnummer: iwm_atab00.ATSYSN
    ATAFNR: iwm_atab00.ATAFNR
    ATKUBZ: iwm_atab00.ATKUBZ
    ATLABZ: iwm_atab00.ATLABZ
    ATZUBZ: iwm_atab00.ATZUBZ
    ATPGRP: iwm_atab00.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: ()
    variant_dimension_2_value: ()
    variant_dimension_3_value: ()
    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_atab00
Source_Primary_Key [ "TAB_KEY" ]
Target_Primary_Key [ "ordernumber", "firma" ]
Datapool iwm_articles_variants
Add_Indices [ { "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_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" } } ]
Joins [ { "Left_Join": null, "Datapool": "iwm_articles_new", "Join_Condition": "iwm_atab00.TAB_KEY = CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(iwm_articles_new.FIRMA,'-'),iwm_articles_new.LIEFERANTENNUMMER),'-'),iwm_articles_new.SYSTEMNUMMER),'-'),iwm_articles_new.AIAA01),'-'),iwm_articles_new.AIAFN1)" }, { "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": "iwm_atab00.ATLINR", "systemnummer": "iwm_atab00.ATSYSN", "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", "configuratorOptions": "VARCHAR(255) DEFAULT NULL" }
Mapping { "ordernumber": { "Source": "IF(iwm_articles_new.AIAPNR = 0, iwm_articles_new.ARARTE, CONCAT(iwm_articles_new.ARARTE,'-',iwm_articles_new.AIAPNR)) AS ordernumber" }, "mainnumber": { "Source": "IF(iwm_articles_new.AIAPNR = 0, iwm_articles_new.ARARTE, CONCAT(iwm_articles_new.ARARTE,'-1')) AS mainnumber" }, "arte": "iwm_articles_new.ARARTE", "firma": "iwm_articles_new.ARFIRM", "lieferantennummer": "iwm_atab00.ATLINR", "systemnummer": "iwm_atab00.ATSYSN", "ATAFNR": "iwm_atab00.ATAFNR", "ATKUBZ": "iwm_atab00.ATKUBZ", "ATLABZ": "iwm_atab00.ATLABZ", "ATZUBZ": "iwm_atab00.ATZUBZ", "ATPGRP": "iwm_atab00.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": "()", "variant_dimension_2_value": "()", "variant_dimension_3_value": "()", "configuratorOptions": "()" }