Engine / Editor
unitize_variant_properties
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: enhanceEngine Target_Config: unitizeEngine Mysql_Engine: InnoDB Default_Charset: latin1 Source_Connection_Type: database Source_Database_Connection_Service: DatabaseConnectionService Source_Datapool: articles Source_Primary_Key: [ordernumber, ItemFirm] Target_Primary_Key: [ordernumber, attr1] #always primary key for target datapool. primary key of source pool can be read from the pool itself. Datapool: variant_properties Joins: - Left_Join: Datapool: iwm_properties_3 Join_Condition: articles.attr1 = iwm_properties_3.firma and articles.ordernumber = iwm_properties_3.ordernumber Datapool_Definition: ordernumber: VARCHAR(255) NOT NULL mainnumber: VARCHAR(255) DEFAULT NULL name_ost: VARCHAR(255) DEFAULT NULL name_tre: VARCHAR(255) DEFAULT NULL name_oms: VARCHAR(255) DEFAULT NULL supplier_ost: VARCHAR(255) DEFAULT NULL supplier_tre: VARCHAR(255) DEFAULT NULL supplier_oms: VARCHAR(255) DEFAULT NULL description_long_ost: MEDIUMTEXT DEFAULT NULL description_long_tre: MEDIUMTEXT DEFAULT NULL description_long_oms: MEDIUMTEXT DEFAULT NULL configuratorType: VARCHAR(255) DEFAULT NULL configuratorOptions: VARCHAR(255) DEFAULT NULL kind: VARCHAR(255) DEFAULT NULL suppliernumber: VARCHAR(255) DEFAULT NULL propertyGroupName: VARCHAR(255) DEFAULT NULL propertyValueName: MEDIUMTEXT DEFAULT NULL attr1: VARCHAR(255) NOT NULL attr2: VARCHAR(255) DEFAULT NULL attr3: VARCHAR(255) DEFAULT NULL main_properties: MEDIUMTEXT DEFAULT NULL prop1: VARCHAR(255) DEFAULT NULL prop2: VARCHAR(255) DEFAULT NULL prop3: VARCHAR(255) DEFAULT NULL prop4: VARCHAR(255) DEFAULT NULL prop5: VARCHAR(255) DEFAULT NULL prop10: VARCHAR(255) DEFAULT NULL prop11: VARCHAR(255) DEFAULT NULL prop12: VARCHAR(255) DEFAULT NULL prop50: VARCHAR(255) DEFAULT NULL prop51: VARCHAR(255) DEFAULT NULL prop52: VARCHAR(255) DEFAULT NULL prop53: VARCHAR(255) DEFAULT NULL prop60: VARCHAR(255) DEFAULT NULL prop61: VARCHAR(255) DEFAULT NULL prop62: VARCHAR(255) DEFAULT NULL prop63: VARCHAR(255) DEFAULT NULL prop64: VARCHAR(255) DEFAULT NULL Mapping: ordernumber: articles.ordernumber mainnumber: articles.mainnumber name_ost: articles.name_ost name_tre: articles.name_tre name_oms: articles.name_oms supplier_ost: articles.supplier_ost supplier_tre: articles.supplier_tre supplier_oms: articles.supplier_oms configuratorType: articles.configuratorType configuratorOptions: articles.configuratorOptions kind: articles.kind suppliernumber: articles.suppliernumber propertyGroupName: articles.propertyGroupName propertyValueName: articles.propertyValueName attr1: articles.attr1 attr2: articles.attr2 attr3: articles.attr3 main_properties: iwm_properties_3.propertyValueName prop1: () #Farbe prop2: () #Breite prop3: () #Länge prop4: () #Höhe prop5: () #Abmessung prop10: () #Modell prop11: () #Material prop12: () #Raum prop50: () #Matratze Größe prop51: () #Matratze Härtegrad prop52: () #Matratze Bezugsmaterial prop53: () #Matratze Matratzenart prop60: () #Teppich Flächengewicht prop61: () #Teppich Florhöhe prop62: () #Teppich Fußbodenheizung prop63: () #Teppich Form prop64: () #Teppich Muster
Definition aktualisieren