enhance / enhance_articles

#Connections
Source_Config: unitizeEngine #config - credetials of source connection service
Target_Config: enhanceEngine #config - credentials of target connection service

Enhance_Mode: flexible

#Engine Mode
Engine_Mode: full


#Source
Source_Datapool: iwm_articles  #sql from


Joins:
- Left_Join:
  Datapool: iwm_articles_stock
  Join_Condition: iwm_articles.attr1 = iwm_articles_stock.firma and iwm_articles.ordernumber = iwm_articles_stock.ordernumber
- Left_Join:
  Datapool: dg_supplierdata_enhanced.iwm_articles_properties
  Join_Condition: iwm_articles.ordernumber = iwm_articles_properties.ordernumber and iwm_articles.attr1 = iwm_articles_properties.firma
- Left_Join:
  Datapool: dg_supplierdata_enhanced.iwm_articles_properties_pil
  Join_Condition: iwm_articles.ordernumber = iwm_articles_properties_pil.ordernumber and iwm_articles.attr1 = iwm_articles_properties_pil.firma

#Target
Datapool: articles #sql table
Target_Datapool: articles  #sql from
Primary_Key: [ordernumber, attr1]


#Mapping -> Mappings source fields are detected by Mapping
Mapping:
   arte:
       Source: iwm_articles.arte
   name_oms:
     Source: iwm_articles.name_oms
     Cross_Field_Adapters:
      - Cross_Field_Adapter:
         Config: enhanceEngine
         Cross_Datapool: iwm_articles_names_3
         Cross_Field: name_oms
         Mapping:
           arte: arte
           attr1: firma
   name_tre:
     Source: iwm_articles.name_tre
     Cross_Field_Adapters:
      - Cross_Field_Adapter:
         Config: enhanceEngine
         Cross_Datapool: iwm_articles_names_3
         Cross_Field: name_tre
         Mapping:
           arte: arte
           attr1: firma
   name_ost:
     Source: iwm_articles.name_ost
     Cross_Field_Adapters:
      - Cross_Field_Adapter:
         Config: enhanceEngine
         Cross_Datapool: iwm_articles_names_3
         Cross_Field: name_ost
         Mapping:
           arte: arte
           attr1: firma
   name_bil:
     Source: iwm_articles.name_bil
     Cross_Field_Adapter:
       Config: enhanceEngine
       Cross_Datapool: iwm_articles_names_3
       Cross_Field: name_bil
       Mapping:
         arte: arte
         attr1: firma
   active_ost: iwm_articles.active_ost
   active_tre: iwm_articles.active_tre
   active_oms: iwm_articles.active_oms
   active_bil: iwm_articles.active_bil
   added: iwm_articles.added
   changed: iwm_articles.changed
   unitID: iwm_articles.unitID
   attr9:
     Source: iwm_articles.attr9
     Field_Adapter:
      - addslashes:
   configuratorOptions:
      Source: iwm_articles.configuratorOptions
      Cross_Field_Adapters:
        - Cross_Field_Adapter:
           Config: enhanceEngine
           Cross_Datapool: articles_new #name of cross datapool
           Cross_Field: configuratorOptions #field to select value from in cross datapool
           Mapping: #cross field adapter with more than one key
             attr1: attr1
             ordernumber: ordernumber
   suppliernumber_original:
      Source: iwm_articles.suppliernumber
   suppliernumber:
      Source: iwm_articles.suppliernumber
      File_Field_Adapter:
       Engine: importEngine
       Datapool: static_mapping_suppliernumber
       Identifier: id
       File: articles.suppliernumber
       Fields:
        - id
        - name_ost
        - firma
        - systemnummer
        - lieferantennummer
        - attr9
        - hwg
        - suppliernumber
   ean:
      Source: iwm_articles.ean
      Cross_Field_Adapters:
        - Cross_Field_Adapter:
           Config: enhanceEngine
           Cross_Datapool: articles_new #name of cross datapool
           Cross_Field: ean #field to select value from in cross datapool
           Mapping: #cross field adapter with more than one key
             attr1: attr1
             ordernumber: ordernumber
   categories: iwm_articles.categories
   metaTitle: iwm_articles.metaTitle
   packUnit: iwm_articles.packUnit
   configuratorType: iwm_articles.configuratorType
   weight: iwm_articles.weight
   height: iwm_articles.height
   width: iwm_articles.width
   propertyGroupName: iwm_articles.propertyGroupName
   propertyValueName: iwm_articles.propertyValueName
   accessory: iwm_articles.accessory
   attr2: iwm_articles.attr2
   attr3: iwm_articles.attr3
   attr4: iwm_articles.attr4
   attr5: iwm_articles.attr5
   attr6: iwm_articles.attr6
   attr7: iwm_articles.attr7
   attr8: iwm_articles.attr8
   attr10: iwm_articles.attr10
   attr11: iwm_articles.attr11
   attr17: iwm_articles.attr17
   attr19: iwm_articles.attr19
   attr20: iwm_articles.attr20
   swag_attr23:
      Source: iwm_articles_stock.stock_inventory
      Field_Adapter:
       - replace_empty: 0
       - replace_not_equals: ['0', '1']
   swag_attr21:
      Source: iwm_articles.swag_attr21
      File_Field_Adapter:
       Config: enhanceEngine
       Engine: enhanceEngine
       Datapool: iwm_articles_kojen_per_article
       Identifier: mainnumber
       File: articles.swag_attr21
       Fields:
        - mainnumber
        - firma
        - kojencode
   swag_attr24:
       Source: iwm_articles.swag_attr24
       Cross_Field_Adapters:
        - Cross_Field_Adapter:
           Config: importEngine
           Cross_Datapool: shopware_article_info_oms #name of cross datapool
           Cross_Field: attr24 #field to select value from in cross datapool
           Mapping: #cross field adapter with more than one key
             ordernumber: ordernumber
        - Cross_Field_Adapter:
           Config: importEngine
           Cross_Datapool: iwm_articles_tkz_0 #name of cross datapool
           Cross_Field: PROPERTIES #field to select value from in cross datapool
           Mapping: #cross field adapter with more than one key
             arte: ORDERNUMBER
           Options:
             concat: ' '
   swag_attr25: iwm_articles.swag_attr25
   swag_attr26: #sortierte Ware
     Source: iwm_articles.swag_attr26
     Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_new #name of cross datapool
        Cross_Field: konsigniert #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   swag_attr27: #Produktart
     Source: iwm_articles.name_oms
     Field_Adapter:
       - explode: [' ','0']
   attr30: #local stock -> sum of local stocks without exhibition stocks
      Source: iwm_articles.attr18
      Cross_Field_Adapter:
         Config: enhanceEngine
         Cross_Datapool: iwm_articles_stock #name of cross datapool
         Cross_Field: stock_local #field to select value from in cross datapool
         Local_Key: ordernumber #key for where condition from datapool
         Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
        - replace_empty: 0
   attr31: # ir stock
      Source: iwm_articles.name_oms
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_stock #name of cross datapool
        Cross_Field: stock_inventory #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   stockmin_ost: iwm_articles.stockmin_ost
   stockmin_tre: iwm_articles.stockmin_tre
   stockmin_oms: iwm_articles.stockmin_oms
   stockmin_bil: iwm_articles.stockmin_bil
   AbsatzMenge3M: iwm_articles.AbsatzMenge3M
   referenceUnit: (1)
   attr1: iwm_articles.attr1
   instock:
     Source: iwm_articles.attr18
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_stock #name of cross datapool
        Cross_Field: stock #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace_empty: 0
   stock_witten:
     Source: iwm_articles.attr1
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_stock #name of cross datapool
        Cross_Field: witten #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace_empty: 0
   attr12:
     Source: iwm_articles.attr12
     Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_new #name of cross datapool
        Cross_Field: attr12 #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     File_Field_Adapter:
       Config: enhanceEngine
       Engine: enhanceEngine
       Datapool: iwm_articles_lieferzeit_gesamt_mit_ausfallzeit
       Identifier: ordernumber
       File: articles.attr12
       Fields:
        - ordernumber
        - lieferzeit
        - firma
     Field_Adapter:
       - replace_empty: 0
       - replace_smaller: [0,0]
   attr13:
     Source: iwm_articles.attr13
     File_Field_Adapter:
      File: articles.attr13
   attr14:
     Source: iwm_articles.attr14
     File_Field_Adapter:
       File: articles.attr14
     Field_Adapter:
       - replace_empty: 0
       - replace_smaller: [0,0]
   attr15:
     Source: iwm_articles.attr15
     Field_Adapter:
       - replace_empty: 0
       - replace_smaller: [0,0]
   attr16:
     Source: iwm_articles.attr16
     Field_Adapter:
       - replace_empty: 0
       - replace_smaller: [0,0]
   attr18:
     Source: iwm_articles.attr18
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_prices #name of cross datapool
        Cross_Field: attr18 #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   categoryPath_ost:
     Source: iwm_articles.categoryPath_ost
     Cross_Field_Adapters:
      - Cross_Field_Adapter:
         Config: importEngine
         Cross_Datapool: shopware_article_info_ost
         Cross_Field: category
         Mapping:
           ordernumber: ordernumber
   categoryPath_tre:
     Source: iwm_articles.categoryPath_tre
     Cross_Field_Adapters:
       - Cross_Field_Adapter:
          Config: importEngine
          Cross_Datapool: shopware_article_info_tre
          Cross_Field: category
          Mapping:
            ordernumber: ordernumber
   categoryPath_oms:
     Source: iwm_articles.categoryPath_oms
     Cross_Field_Adapters:
      - Cross_Field_Adapter:
          Config: importEngine
          Cross_Datapool: shopware_article_info_oms
          Cross_Field: category
          Mapping:
            ordernumber: ordernumber
   categoryPath_bil:
     Source: iwm_articles.categoryPath_bil
     File_Field_Adapter:
      File: articles.categoryPath_bil
   cat_google:
     Source: iwm_articles.cat_google
     Cross_Field_Adapter:
        Config: importEngine
        Cross_Datapool: static_mapping_categories #name of cross datapool
        Cross_Field: google_category #field to select value from in cross datapool
        Local_Key: categoryPath_oms #key for where condition from datapool
        Cross_Key: oms_category #key for where condition from cross datapool
#     Cross_Field_Adapters:
#      - Cross_Field_Adapter:
#         Config: importEngine
#         Cross_Datapool: static_mapping_categories
#         Cross_Field: google_category
#         Mapping:
#           categoryPath_oms: oms_category
   cat_ebay:
     Source: iwm_articles.cat_ebay
     Cross_Field_Adapters:
      - Cross_Field_Adapter:
         Config: importEngine
         Cross_Datapool: static_mapping_categories
         Cross_Field: ebay_category
         Mapping:
           categoryPath_oms: oms_category
   cat_amazon:
     Source: iwm_articles.cat_amazon
     Cross_Field_Adapters:
      - Cross_Field_Adapter:
         Config: importEngine
         Cross_Datapool: static_mapping_categories
         Cross_Field: amazon_category
         Mapping:
           categoryPath_oms: oms_category
   description:
     Source: iwm_articles.description
     Field_Adapter:
       - addslashes:
       - replace: ['http://', 'https://']
   description_long_ost:
     Source: iwm_articles.description_long_ost
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: articles_new #name of cross datapool
        Cross_Field: description_long_ost #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: ['http://', 'https://']
   description_long_tre:
     Source: iwm_articles.description_long_tre
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: articles_new #name of cross datapool
        Cross_Field: description_long_tre #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: ['http://', 'https://']
   description_long_oms:
     Source: iwm_articles.description_long_oms
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: articles_new #name of cross datapool
        Cross_Field: description_long_oms #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: ['http://', 'https://']
   description_long_bil:
     Source: iwm_articles.description_long_bil
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: articles_new #name of cross datapool
        Cross_Field: description_long_bil #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: ['http://', 'https://']
   ordernumber: iwm_articles.ordernumber
   mainnumber:
     Source: iwm_articles.mainnumber
     File_Field_Adapter:
      File: articles.mainnumber
   imageUrl:
     Source: iwm_articles.imageUrl
     File_Field_Adapter:
      File: articles.imageUrl
   ItemImageDate:
     Source: iwm_articles.ItemImageDate
     File_Field_Adapter:
      File: articles.ItemImageDate
   kind:
     Source: iwm_articles.kind
     File_Field_Adapter:
      File: articles.kind
   baseprice:
     Source: iwm_articles.baseprice
     Field_Adapter:
      - replace: [',','.']
   configSetId:
      Source: IF(iwm_articles.configSetId = '', 1, 0) AS configSetId
   height:
      Source: iwm_articles.height
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   price_ost:
     Source: iwm_articles.price_ost
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
        - replace: [',','.']
        - float_pricision: 2
   price_tre:
      Source: iwm_articles.price_tre
      Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   price_oms:
      Source: iwm_articles.price_oms
      Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   price_bil:
      Source: iwm_articles.price_oms
      Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_ost:
     Source: iwm_articles.pseudoprice_ost
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
        Cross_Field: pseudoprice_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_tre:
     Source: iwm_articles.pseudoprice_tre
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
        Cross_Field: pseudoprice_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_oms:
     Source: iwm_articles.pseudoprice_oms
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: pseudoprice_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
     Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   pseudoprice_bil:
      Source: iwm_articles.pseudoprice_bil
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   purchaseprice:
      Source: iwm_articles.purchaseprice
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   purchaseUnit:
      Source: iwm_articles.purchaseUnit
      Field_Adapter:
       - replace: [',','.']
       - float_pricision: 2
   referenceUnit: (1)
   supplier_ost:
     Source: iwm_articles.supplier_ost
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
        Cross_Field: supplier_ost #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   supplier_tre:
     Source: iwm_articles.supplier_tre
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
        Cross_Field: supplier_tre #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   supplier_oms:
     Source: iwm_articles.supplier_oms
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
        Cross_Field: supplier_oms #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   supplier_bil:
     Source: iwm_articles.supplier_bil
     Cross_Field_Adapter:
        Config: enhanceEngine
        Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
        Cross_Field: supplier_bil #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   swag_attr29:
     Source: iwm_articles.swag_attr29 #carrier -> e.g. DHL, DPD etc.
     File_Field_Adapter:
       File: articles.swag_attr29
   swag_attr22:
     Source: iwm_articles.swag_attr22
     File_Field_Adapter:
        File: articles.swag_attr22
     Field_Adapter:
      - addslashes:
   tax: (19.00)
   shippingfree:
     Source: iwm_articles.shippingfree
   bestellsperre:
      Source: iwm_articles.name_oms
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
        Cross_Field: bestellsperre #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   auslaufkennzeichen:
      Source: iwm_articles.name_oms
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
        Cross_Field: auslaufkennzeichen #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   textilkennzeichen_text:
      Source: iwm_articles.textilkennzeichen_text
      Cross_Field_Adapter:
        Config: enhanceEngine
        Engine: enhanceEngine
        Cross_Datapool: iwm_articles_textilkennzeichen_8 #name of cross datapool
        Cross_Field: textilkennzeichen #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   AHLZSD:
      Source: iwm_articles.AHLZSD
      Cross_Field_Adapter:
        Config: unitizeEngine
        Engine: unitizeEngine
        Cross_Datapool: iwm_articles_arhp #name of cross datapool
        Cross_Field: AHLZSD #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   ARKMFR:
      Source: iwm_articles.ARKMFR
      Cross_Field_Adapter:
        Config: unitizeEngine
        Engine: unitizeEngine
        Cross_Datapool: iwm_articles_new #name of cross datapool
        Cross_Field: ARKMFR #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   nutschicht:
      Source: iwm_articles.nutschicht
      Cross_Field_Adapter:
        Config: unitizeEngine
        Engine: unitizeEngine
        Cross_Datapool: iwm_articles_new #name of cross datapool
        Cross_Field: nutschicht #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   textilkennzeichen_needed:
     Source: iwm_articles.textilkennzeichen_needed
     File_Field_Adapter:
      Config: importEngine
      Engine: importEngine
      Datapool: static_mapping_textilkennzeichen_flag
      Identifier: id
      File: articles.textilkennzeichen_needed
      Fields:
       - id
       - hwg
       - uwg
       - keyword
       - AHLZSD
       - ARKMFR
       - nutschicht
       - textilkennzeichen_needed
   has_textilkennzeichen:
     Source: iwm_articles.has_textilkennzeichen
     File_Field_Adapter:
      File: articles.has_textilkennzeichen
   pil_needed:
     Source: iwm_articles.pil_needed
     File_Field_Adapter:
      Config: importEngine
      Engine: importEngine
      Datapool: static_mapping_pil_flag
      Identifier: id
      File: articles.pil_needed
      Fields:
       - id
       - hwg
       - uwg
       - keyword
       - ARKMFR
       - pil_needed
   pil_text:
      Source: iwm_articles.pil_text
      Cross_Field_Adapters:
       - Cross_Field_Adapter:
          Config: enhanceEngine
          Cross_Datapool: iwm_articles_properties_pil
          Cross_Field: pil_html_gesamt
          Mapping:
            ordernumber: ordernumber
            attr1: firma
   has_pil:
     Source: iwm_articles.has_pil
     File_Field_Adapter:
      File: articles.has_pil
   stock_ir:
      Source: iwm_articles.name_oms
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_stock #name of cross datapool
        Cross_Field: stock_inventory #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   ahstat:
      Source: iwm_articles.ahstat
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_articles_arhp #name of cross datapool
        Cross_Field: ahstat #field to select value from in cross datapool
        Mapping: #cross field adapter with more than one key
          ordernumber: ordernumber
          attr1: firma
   LBNTEK:
      Source: iwm_articles.LBNTEK
      Cross_Field_Adapter:
        Config: unitizeEngine
        Cross_Datapool: iwm_ek_prices #name of cross datapool
        Cross_Field: A9K300 #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
   LBKALK:
      Source: iwm_articles.LBKALK
      File_Field_Adapter:
         File: articles.LBKALK
   LBMARGE: iwm_articles.LBMARGE
   LBWAEISA: iwm_articles.LBWAEISA
   prop1: iwm_articles_properties.prop1  #Farbe
   prop2: iwm_articles_properties.prop2	#Breite
   prop3: iwm_articles_properties.prop3	#Länge
   prop4: iwm_articles_properties.prop4	#Höhe
   prop5: iwm_articles_properties.prop5	#Abmessung
   prop10: iwm_articles_properties.prop10	#Modell
   prop11: iwm_articles_properties.prop11	#Material
   prop12: iwm_articles_properties.prop12	#Raum
   prop50: iwm_articles_properties.prop50	#Matratze Größe
   prop51: iwm_articles_properties.prop51	#Matratze Härtegrad
   prop52: iwm_articles_properties.prop52	#Matratze Bezugsmaterial
   prop53: iwm_articles_properties.prop53	#Matratze Matratzenart
   prop60: iwm_articles_properties.prop60	#Teppich Flächengewicht
   prop61: iwm_articles_properties.prop61	#Teppich Florhöhe
   prop62: iwm_articles_properties.prop62	#Teppich Fußbodenheizung
   prop63: iwm_articles_properties.prop63	#Teppich Form
   prop64: iwm_articles_properties.prop64	#Teppich Muster
   enev_klasse: iwm_articles_properties_pil.Energieeffizienzklasse1
   enev_color:
     Source: iwm_articles_properties_pil.Energieeffizienzklasse1
     File_Field_Adapter:
       File: articles.enev_color #mapping der Klasse auf die Farbe des Etiketts
   enev_download:
     Source: iwm_articles_properties_pil.Energieeffizienzklasse1
     File_Field_Adapter:
       File: articles.enev_download
   enev_image:
     Source: iwm_articles_properties_pil.Energieeffizienzklasse1
     File_Field_Adapter:
       File: articles.enev_image #mapping der Klasse auf das entsprechende Bild
   enev_spectrumfrom:
     Source: iwm_articles_properties_pil.Energieeffizienzklasse1
     File_Field_Adapter:
       File: articles.enev_spectrumfrom
   enev_spectrum:
     Source: iwm_articles_properties_pil.Energieeffizienzklasse1
     File_Field_Adapter:
       File: articles.enev_spectrum
   enev_active:
     Source: iwm_articles_properties_pil.Energieeffizienzklasse1
     File_Field_Adapter:
       File: articles.enev_active
   swag_attr28:
      Source: iwm_articles.swag_attr28
      Cross_Field_Adapters:
       - Cross_Field_Adapter:
          Config: enhanceEngine
          Cross_Datapool: iwm_articles_tvk_4 #name of cross datapool
          Cross_Field: eek #field to select value from in cross datapool
          Mapping: #cross field adapter with more than one key
            arte: arte
            attr1: firma
      File_Field_Adapter:
        File: articles.swag_attr28
   datenblatt:
     Source: iwm_articles.datenblatt
     File_Field_Adapter:
       File: articles.datenblatt
   has_datenblatt:
          Source: iwm_articles.has_datenblatt
          File_Field_Adapter:
            File: articles.has_datenblatt
   datenblatt_needed:
            Source: iwm_articles.datenblatt_needed
            File_Field_Adapter:
              File: articles.datenblatt_needed


Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: Corona-Problem IR-Bestand
    condition: (stock_witten < 1) AND (stock_ir < 1) AND (attr2 == 91) AND (attr11 == 'B')
    reason: 'Corona-Problem IR-Bestand'
 - Filter:
    name: Corona-Problem IR-Bestand
    condition: (stock_witten == '0') AND (stock_ir == '0') AND (attr2 == '91') AND (attr11 == 'B')
    reason: 'Corona-Problem INVR-Bestand'
 - Filter:
    name: kein Bild  #there must always be a space between the key and the comparision operator and between the parentheses
    condition:
      Cross_Dataset_Filter_Adapter: enhance_articles_ost__filterNoPicture
    reason: 'kein Bild'
 - Filter:
    name: 'Artikeldeaktivierung Gesamtmengenfilter'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles
        Reason_Key: reason
        Mapping: #left is from current datapool, right from filter datapool
         suppliernumber: supplier_number
         supplier_ost: supplier_name
         supplier_tre: supplier_name
         ordernumber: ordernumber
         attr1: attr1
         attr2: attr2
         attr3: attr3
         attr4: attr4
         attr11: attr11
         attr12: attr12
         price_ost: price
         price_tre: price
         instock: stock
         stock_witten: stock_witten
         name_ost: name
         name_tre: name
         description_long_ost: description
         auslaufkennzeichen: auslauf
         bestellsperre: bestellsperre
         ahstat: AHSTAT
         swag_attr26: konsigniert
         textilkennzeichen_needed: textilkennzeichen_needed
         has_textilkennzeichen: has_textilkennzeichen
         pil_needed: pil_needed
         has_pil: has_pil
         enev_active: enev_active
         datenblatt_needed: datenblatt_needed
         has_datenblatt: has_datenblatt