Legacy YAML / Detail

export / export_articles_synesty

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
export_articles_synesty Kurzinfo

Raw YAML

Dateiinhalt

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

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

#Source
Source_Datapool: iwm_articles_synesty  #sql from

Joins:
- Join:
  Datapool: articles
  Join_Condition: iwm_articles_synesty.ordernumber = articles_new.ordernumber AND iwm_articles_synesty.ItemFreeTextField1 = articles_new.attr1 # One row per JOIN
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma # One row per JOIN


Read_Conditions:  #sql where - Read-Filter
  - articles_new.active_oms = 1 or articles_new.active_ost = 1 or articles_new.active_tre = 1

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
    ordernumber:
     Source: iwm_articles_synesty.ordernumber
     In_Export: no
    ItemKey:
     Source: iwm_articles_synesty.ItemKey
    ItemFirm:
     Source: iwm_articles_synesty.ItemFirm
    ItemSpar:
     Source: iwm_articles_synesty.ItemSpar
    ItemNo:
     Source: iwm_articles_synesty.ItemNo
    ItemAspr:
     Source: iwm_articles_synesty.ItemAspr
    Variation:
     Source: iwm_articles_synesty.Variation
    VariationNo:
     Source: iwm_articles_synesty.VariationNo
    ItemEAN:
     Source: iwm_articles_synesty.ItemEAN
    ItemProducer_ost:
     Source: iwm_articles_synesty.ItemProducer_ost
    ItemProducer_tre:
     Source: iwm_articles_synesty.ItemProducer_tre
    ItemProducer_oms:
     Source: iwm_articles_synesty.ItemProducer_oms
    ItemProducer_bil:
     Source: iwm_articles_synesty.ItemProducer_bil
    ItemTextName_ost:
     Source: iwm_articles_synesty.ItemTextName_ost
    ItemTextName_tre:
     Source: iwm_articles_synesty.ItemTextName_tre
    ItemTextName_oms:
     Source: iwm_articles_synesty.ItemTextName_oms
    ItemTextName_bil:
     Source: iwm_articles_synesty.ItemTextName_bil
    ItemTextDescription_ost:
     Source: articles_new.description_long_ost
    ItemTextDescription_tre:
     Source: articles_new.description_long_tre
    ItemTextDescription_oms:
     Source: articles_new.description_long_oms
    ItemTextDescription_bil:
     Source: articles_new.description_long_bil
    Price1_ost:
     Source: articles_new.price_ost
    Price2_ost:
     Source: iwm_articles_synesty.Price2_ost
    Price3_ost:
     Source: iwm_articles_synesty.Price3_ost
    ItemMRP_ost:
     Source: articles_new.pseudoprice_ost
    Price1_tre:
     Source: articles_new.price_tre
    Price2_tre:
     Source: iwm_articles_synesty.Price2_tre
    Price3_tre:
     Source: iwm_articles_synesty.Price3_tre
    ItemMRP_tre:
     Source: articles_new.pseudoprice_tre
    Price1_oms:
     Source: articles_new.price_oms
    Price2_oms:
     Source: iwm_articles_synesty.Price2_oms
    Price3_oms:
     Source: iwm_articles_synesty.Price3_oms
    ItemMRP_oms:
     Source: articles_new.pseudoprice_oms
    Price1_bil:
     Source: articles_new.price_bil
    Price2_bil:
     Source: iwm_articles_synesty.Price2_bil
    Price3_bil:
     Source: iwm_articles_synesty.Price3_bil
    ItemMRP_bil:
     Source: articles_new.pseudoprice_bil
    AttributName1:
     Source: iwm_articles_synesty.AttributName1
    AttributeValue1:
     Source: iwm_articles_synesty.AttributeValue1
    AttributName2:
     Source: iwm_articles_synesty.AttributName2
    AttributeValue2:
     Source: iwm_articles_synesty.AttributeValue2
    AttributName3:
     Source: iwm_articles_synesty.AttributName3
    AttributeValue3:
     Source: iwm_articles_synesty.AttributeValue3
    PriceWidth:
     Source: iwm_articles_synesty.PriceWidth
    PriceHeight:
     Source: iwm_articles_synesty.PriceHeight
    PriceLength:
     Source: iwm_articles_synesty.PriceLength
    PriceWeight:
     Source: iwm_articles_synesty.PriceWeight
    PriceWeightNet:
     Source: iwm_articles_synesty.PriceWeightNet
    ItemVisibilityWebshop_ost:
     Source: iwm_articles_synesty.ItemVisibilityWebshop_ost
    ItemVisibilityWebshop_tre:
     Source: iwm_articles_synesty.ItemVisibilityWebshop_tre
    ItemVisibilityWebshop_oms:
     Source: iwm_articles_synesty.ItemVisibilityWebshop_oms
    ItemVisibilityWebshop_bil:
     Source: iwm_articles_synesty.ItemVisibilityWebshop_bil
    ItemVisibilityWebApi_ost:
     Source: iwm_articles_synesty.ItemVisibilityWebApi_ost
    ItemVisibilityWebApi_tre:
     Source: iwm_articles_synesty.ItemVisibilityWebApi_tre
    ItemVisibilityWebApi_oms:
     Source: iwm_articles_synesty.ItemVisibilityWebApi_oms
    ItemVisibilityWebApi_bil:
     Source: iwm_articles_synesty.ItemVisibilityWebApi_bil
    ItemStoreIDs_ost:
     Source: iwm_articles_synesty.ItemStoreIDs_ost
    ItemStoreIDs_tre:
     Source: iwm_articles_synesty.ItemStoreIDs_tre
    ItemStoreIDs_oms:
     Source: iwm_articles_synesty.ItemStoreIDs_oms
    ItemStoreIDs_bil:
     Source: iwm_articles_synesty.ItemStoreIDs_bil
    ItemLimitOrderByStock_ost:
     Source: iwm_articles_synesty.ItemLimitOrderByStock_ost
    ItemLimitOrderByStock_tre:
     Source: iwm_articles_synesty.ItemLimitOrderByStock_tre
    ItemLimitOrderByStock_oms:
     Source: iwm_articles_synesty.ItemLimitOrderByStock_oms
    ItemLimitOrderByStock_bil:
     Source: iwm_articles_synesty.ItemLimitOrderByStock_bil
    ItemPrimaryWarehouse_ost:
     Source: iwm_articles_synesty.ItemPrimaryWarehouse_ost
    ItemPrimaryWarehouse_tre:
     Source: iwm_articles_synesty.ItemPrimaryWarehouse_tre
    ItemPrimaryWarehouse_oms:
     Source: iwm_articles_synesty.ItemPrimaryWarehouse_oms
    ItemPrimaryWarehouse_bil:
     Source: iwm_articles_synesty.ItemPrimaryWarehouse_bil
    ItemCrossList_ost:
     Source: iwm_articles_synesty.ItemCrossList_ost
    ItemCrossList_tre:
     Source: iwm_articles_synesty.ItemCrossList_tre
    ItemCrossList_oms:
     Source: iwm_articles_synesty.ItemCrossList_oms
    ItemCrossList_bil:
     Source: iwm_articles_synesty.ItemCrossList_bil
    ItemInactive_ost:
     Source: iwm_articles_synesty.ItemInactive_ost
    ItemInactive_tre:
     Source: iwm_articles_synesty.ItemInactive_tre
    ItemInactive_oms:
     Source: iwm_articles_synesty.ItemInactive_oms
    ItemInactive_bil:
     Source: iwm_articles_synesty.ItemInactive_bil
    ItemFreeTextField1:
     Source: iwm_articles_synesty.ItemFreeTextField1
    ItemFreeTextField2:
     Source: iwm_articles_synesty.ItemFreeTextField2
    ItemFreeTextField3:
     Source: iwm_articles_synesty.ItemFreeTextField3
    ItemFreeTextField4:
     Source: iwm_articles_synesty.ItemFreeTextField4
    ItemFreeTextField5:
     Source: iwm_articles_synesty.ItemFreeTextField5
    ItemFreeTextField6:
     Source: iwm_articles_synesty.ItemFreeTextField6
    ItemFreeTextField7:
     Source: iwm_articles_synesty.ItemFreeTextField7
    ItemFreeTextField8:
     Source: iwm_articles_synesty.ItemFreeTextField8
    ItemFreeTextField9:
     Source: iwm_articles_synesty.ItemFreeTextField9
    ItemFreeTextField10:
     Source: iwm_articles_synesty.ItemFreeTextField10
    ItemFreeTextField11:
     Source: iwm_articles_synesty.ItemFreeTextField11
    ItemFreeTextField12:
     Source: iwm_articles_synesty.ItemFreeTextField12
    ItemFreeTextField13:
     Source: iwm_articles_synesty.ItemFreeTextField13
    ItemFreeTextField14:
     Source: iwm_articles_synesty.ItemFreeTextField14
    ItemFreeTextField15:
     Source: iwm_articles_synesty.ItemFreeTextField15
    ItemFreeTextField16:
     Source: iwm_articles_synesty.ItemFreeTextField16
    ItemFreeTextField17:
     Source: iwm_articles_synesty.ItemFreeTextField17
    ItemFreeTextField18:
     Source: iwm_articles_synesty.ItemFreeTextField18
    ItemFreeTextField19:
     Source: iwm_articles_synesty.ItemFreeTextField19
    ItemFreeTextField20:
     Source: iwm_articles_synesty.ItemFreeTextField20
    ItemCategories_ost:
     Source: iwm_articles_synesty.ItemCategories_ost
    ItemCategories_tre:
     Source: iwm_articles_synesty.ItemCategories_tre
    ItemCategories_oms:
     Source: iwm_articles_synesty.ItemCategories_oms
    ItemCategories_bil:
     Source: iwm_articles_synesty.ItemCategories_bil
    ItemPropertiesID_ost:
     Source: iwm_articles_synesty.ItemPropertiesID_ost
    ItemPropertiesID_tre:
     Source: iwm_articles_synesty.ItemPropertiesID_tre
    ItemPropertiesID_oms:
     Source: iwm_articles_synesty.ItemPropertiesID_oms
    ItemPropertiesID_bil:
     Source: iwm_articles_synesty.ItemPropertiesID_bil
    ItemPropertiesValue_ost:
     Source: iwm_articles_synesty.ItemPropertiesValue_ost
    ItemPropertiesValue_tre:
     Source: iwm_articles_synesty.ItemPropertiesValue_tre
    ItemPropertiesValue_oms:
     Source: iwm_articles_synesty.ItemPropertiesValue_oms
    ItemPropertiesValue_bil:
     Source: iwm_articles_synesty.ItemPropertiesValue_bil
    ItemImageDate:
     Source: iwm_articles_synesty.ItemImageDate
    ItemProducerID:
     Source: iwm_articles_synesty.ItemProducerID
    LBNTEK:
     Source: iwm_articles_synesty.LBNTEK
    LBKALK:
     Source: iwm_articles_synesty.LBKALK
    LBMARGE:
     Source: iwm_articles_synesty.LBMARGE
    LBWAEISA:
     Source: iwm_articles_synesty.LBWAEISA
    AbsatzMenge3M:
     Source: iwm_articles_synesty.AbsatzMenge3M
    imageUrl:
     Source: iwm_articles_synesty.imageUrl
    swag_attr24:
     Source: iwm_articles_synesty.swag_attr24
    swag_attr25:
     Source: iwm_articles_synesty.swag_attr25
    swag_attr22:
     Source: iwm_articles_synesty.swag_attr22
    shippingfree:
     Source: iwm_articles_synesty.shippingfree
    stock_witten:
     Source: iwm_articles_stock.witten
     In_Export: no
    stock:
     Source: iwm_articles_stock.stock
     In_Export: no


Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: Mindestbestand  #there must always be a space between the key and the comparision operator
    condition: (Price1_ost < 6) AND (stock_witten < 10) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L')
    reason: 'Mindestbestand (price < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (Price1_ost < 25) AND (stock_witten < 3) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L')
    reason: 'Mindestbestand (price < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (Price1_ost < 100) AND (stock_witten < 1) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L')
    reason: 'Mindestbestand (price < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Preis ungueltig'
    condition: (Price1_ost == '0') or (Price1_ost == '') or (Price1_ost == '0.00')  or (Price1_ost == '0,00')  or (Price1_ost == '0,0')
    reason: 'alle Preise = 0'
 - Filter:
    name: 'Zu lange Lieferzeit'
    condition: (ItemFreeTextField11 == 'L') and (ItemFreeTextField12 > 6) and (stock == 0) and (ItemFreeTextField2 > 89)
    reason: 'Zu lange Lieferzeit'
 - Filter:
    name: 'Zu lange Lieferzeit Suppliernumber 782577'
    condition: (ItemFreeTextField11 == 'L') and (ItemFreeTextField12 > 4) and (stock == 0) and (ItemProducer_ost == 'Casa Nova')
    reason: 'Zu lange Lieferzeit Suppliernumber 782577'

#Target
Datapool: export_articles_synesty #sql table
Primary_Key: ItemKey

Metadata

Erkannte Konfiguration

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

Source_Config enhanceEngine
Target_Config exportEngine
Source_Datapool iwm_articles_synesty
Joins [ { "Join": null, "Datapool": "articles", "Join_Condition": "iwm_articles_synesty.ordernumber = articles_new.ordernumber AND iwm_articles_synesty.ItemFreeTextField1 = articles_new.attr1" }, { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma" } ]
Read_Conditions [ "articles_new.active_oms = 1 or articles_new.active_ost = 1 or articles_new.active_tre = 1" ]
Mapping { "ordernumber": { "Source": "iwm_articles_synesty.ordernumber", "In_Export": "no" }, "ItemKey": { "Source": "iwm_articles_synesty.ItemKey" }, "ItemFirm": { "Source": "iwm_articles_synesty.ItemFirm" }, "ItemSpar": { "Source": "iwm_articles_synesty.ItemSpar" }, "ItemNo": { "Source": "iwm_articles_synesty.ItemNo" }, "ItemAspr": { "Source": "iwm_articles_synesty.ItemAspr" }, "Variation": { "Source": "iwm_articles_synesty.Variation" }, "VariationNo": { "Source": "iwm_articles_synesty.VariationNo" }, "ItemEAN": { "Source": "iwm_articles_synesty.ItemEAN" }, "ItemProducer_ost": { "Source": "iwm_articles_synesty.ItemProducer_ost" }, "ItemProducer_tre": { "Source": "iwm_articles_synesty.ItemProducer_tre" }, "ItemProducer_oms": { "Source": "iwm_articles_synesty.ItemProducer_oms" }, "ItemProducer_bil": { "Source": "iwm_articles_synesty.ItemProducer_bil" }, "ItemTextName_ost": { "Source": "iwm_articles_synesty.ItemTextName_ost" }, "ItemTextName_tre": { "Source": "iwm_articles_synesty.ItemTextName_tre" }, "ItemTextName_oms": { "Source": "iwm_articles_synesty.ItemTextName_oms" }, "ItemTextName_bil": { "Source": "iwm_articles_synesty.ItemTextName_bil" }, "ItemTextDescription_ost": { "Source": "articles_new.description_long_ost" }, "ItemTextDescription_tre": { "Source": "articles_new.description_long_tre" }, "ItemTextDescription_oms": { "Source": "articles_new.description_long_oms" }, "ItemTextDescription_bil": { "Source": "articles_new.description_long_bil" }, "Price1_ost": { "Source": "articles_new.price_ost" }, "Price2_ost": { "Source": "iwm_articles_synesty.Price2_ost" }, "Price3_ost": { "Source": "iwm_articles_synesty.Price3_ost" }, "ItemMRP_ost": { "Source": "articles_new.pseudoprice_ost" }, "Price1_tre": { "Source": "articles_new.price_tre" }, "Price2_tre": { "Source": "iwm_articles_synesty.Price2_tre" }, "Price3_tre": { "Source": "iwm_articles_synesty.Price3_tre" }, "ItemMRP_tre": { "Source": "articles_new.pseudoprice_tre" }, "Price1_oms": { "Source": "articles_new.price_oms" }, "Price2_oms": { "Source": "iwm_articles_synesty.Price2_oms" }, "Price3_oms": { "Source": "iwm_articles_synesty.Price3_oms" }, "ItemMRP_oms": { "Source": "articles_new.pseudoprice_oms" }, "Price1_bil": { "Source": "articles_new.price_bil" }, "Price2_bil": { "Source": "iwm_articles_synesty.Price2_bil" }, "Price3_bil": { "Source": "iwm_articles_synesty.Price3_bil" }, "ItemMRP_bil": { "Source": "articles_new.pseudoprice_bil" }, "AttributName1": { "Source": "iwm_articles_synesty.AttributName1" }, "AttributeValue1": { "Source": "iwm_articles_synesty.AttributeValue1" }, "AttributName2": { "Source": "iwm_articles_synesty.AttributName2" }, "AttributeValue2": { "Source": "iwm_articles_synesty.AttributeValue2" }, "AttributName3": { "Source": "iwm_articles_synesty.AttributName3" }, "AttributeValue3": { "Source": "iwm_articles_synesty.AttributeValue3" }, "PriceWidth": { "Source": "iwm_articles_synesty.PriceWidth" }, "PriceHeight": { "Source": "iwm_articles_synesty.PriceHeight" }, "PriceLength": { "Source": "iwm_articles_synesty.PriceLength" }, "PriceWeight": { "Source": "iwm_articles_synesty.PriceWeight" }, "PriceWeightNet": { "Source": "iwm_articles_synesty.PriceWeightNet" }, "ItemVisibilityWebshop_ost": { "Source": "iwm_articles_synesty.ItemVisibilityWebshop_ost" }, "ItemVisibilityWebshop_tre": { "Source": "iwm_articles_synesty.ItemVisibilityWebshop_tre" }, "ItemVisibilityWebshop_oms": { "Source": "iwm_articles_synesty.ItemVisibilityWebshop_oms" }, "ItemVisibilityWebshop_bil": { "Source": "iwm_articles_synesty.ItemVisibilityWebshop_bil" }, "ItemVisibilityWebApi_ost": { "Source": "iwm_articles_synesty.ItemVisibilityWebApi_ost" }, "ItemVisibilityWebApi_tre": { "Source": "iwm_articles_synesty.ItemVisibilityWebApi_tre" }, "ItemVisibilityWebApi_oms": { "Source": "iwm_articles_synesty.ItemVisibilityWebApi_oms" }, "ItemVisibilityWebApi_bil": { "Source": "iwm_articles_synesty.ItemVisibilityWebApi_bil" }, "ItemStoreIDs_ost": { "Source": "iwm_articles_synesty.ItemStoreIDs_ost" }, "ItemStoreIDs_tre": { "Source": "iwm_articles_synesty.ItemStoreIDs_tre" }, "ItemStoreIDs_oms": { "Source": "iwm_articles_synesty.ItemStoreIDs_oms" }, "ItemStoreIDs_bil": { "Source": "iwm_articles_synesty.ItemStoreIDs_bil" }, "ItemLimitOrderByStock_ost": { "Source": "iwm_articles_synesty.ItemLimitOrderByStock_ost" }, "ItemLimitOrderByStock_tre": { "Source": "iwm_articles_synesty.ItemLimitOrderByStock_tre" }, "ItemLimitOrderByStock_oms": { "Source": "iwm_articles_synesty.ItemLimitOrderByStock_oms" }, "ItemLimitOrderByStock_bil": { "Source": "iwm_articles_synesty.ItemLimitOrderByStock_bil" }, "ItemPrimaryWarehouse_ost": { "Source": "iwm_articles_synesty.ItemPrimaryWarehouse_ost" }, "ItemPrimaryWarehouse_tre": { "Source": "iwm_articles_synesty.ItemPrimaryWarehouse_tre" }, "ItemPrimaryWarehouse_oms": { "Source": "iwm_articles_synesty.ItemPrimaryWarehouse_oms" }, "ItemPrimaryWarehouse_bil": { "Source": "iwm_articles_synesty.ItemPrimaryWarehouse_bil" }, "ItemCrossList_ost": { "Source": "iwm_articles_synesty.ItemCrossList_ost" }, "ItemCrossList_tre": { "Source": "iwm_articles_synesty.ItemCrossList_tre" }, "ItemCrossList_oms": { "Source": "iwm_articles_synesty.ItemCrossList_oms" }, "ItemCrossList_bil": { "Source": "iwm_articles_synesty.ItemCrossList_bil" }, "ItemInactive_ost": { "Source": "iwm_articles_synesty.ItemInactive_ost" }, "ItemInactive_tre": { "Source": "iwm_articles_synesty.ItemInactive_tre" }, "ItemInactive_oms": { "Source": "iwm_articles_synesty.ItemInactive_oms" }, "ItemInactive_bil": { "Source": "iwm_articles_synesty.ItemInactive_bil" }, "ItemFreeTextField1": { "Source": "iwm_articles_synesty.ItemFreeTextField1" }, "ItemFreeTextField2": { "Source": "iwm_articles_synesty.ItemFreeTextField2" }, "ItemFreeTextField3": { "Source": "iwm_articles_synesty.ItemFreeTextField3" }, "ItemFreeTextField4": { "Source": "iwm_articles_synesty.ItemFreeTextField4" }, "ItemFreeTextField5": { "Source": "iwm_articles_synesty.ItemFreeTextField5" }, "ItemFreeTextField6": { "Source": "iwm_articles_synesty.ItemFreeTextField6" }, "ItemFreeTextField7": { "Source": "iwm_articles_synesty.ItemFreeTextField7" }, "ItemFreeTextField8": { "Source": "iwm_articles_synesty.ItemFreeTextField8" }, "ItemFreeTextField9": { "Source": "iwm_articles_synesty.ItemFreeTextField9" }, "ItemFreeTextField10": { "Source": "iwm_articles_synesty.ItemFreeTextField10" }, "ItemFreeTextField11": { "Source": "iwm_articles_synesty.ItemFreeTextField11" }, "ItemFreeTextField12": { "Source": "iwm_articles_synesty.ItemFreeTextField12" }, "ItemFreeTextField13": { "Source": "iwm_articles_synesty.ItemFreeTextField13" }, "ItemFreeTextField14": { "Source": "iwm_articles_synesty.ItemFreeTextField14" }, "ItemFreeTextField15": { "Source": "iwm_articles_synesty.ItemFreeTextField15" }, "ItemFreeTextField16": { "Source": "iwm_articles_synesty.ItemFreeTextField16" }, "ItemFreeTextField17": { "Source": "iwm_articles_synesty.ItemFreeTextField17" }, "ItemFreeTextField18": { "Source": "iwm_articles_synesty.ItemFreeTextField18" }, "ItemFreeTextField19": { "Source": "iwm_articles_synesty.ItemFreeTextField19" }, "ItemFreeTextField20": { "Source": "iwm_articles_synesty.ItemFreeTextField20" }, "ItemCategories_ost": { "Source": "iwm_articles_synesty.ItemCategories_ost" }, "ItemCategories_tre": { "Source": "iwm_articles_synesty.ItemCategories_tre" }, "ItemCategories_oms": { "Source": "iwm_articles_synesty.ItemCategories_oms" }, "ItemCategories_bil": { "Source": "iwm_articles_synesty.ItemCategories_bil" }, "ItemPropertiesID_ost": { "Source": "iwm_articles_synesty.ItemPropertiesID_ost" }, "ItemPropertiesID_tre": { "Source": "iwm_articles_synesty.ItemPropertiesID_tre" }, "ItemPropertiesID_oms": { "Source": "iwm_articles_synesty.ItemPropertiesID_oms" }, "ItemPropertiesID_bil": { "Source": "iwm_articles_synesty.ItemPropertiesID_bil" }, "ItemPropertiesValue_ost": { "Source": "iwm_articles_synesty.ItemPropertiesValue_ost" }, "ItemPropertiesValue_tre": { "Source": "iwm_articles_synesty.ItemPropertiesValue_tre" }, "ItemPropertiesValue_oms": { "Source": "iwm_articles_synesty.ItemPropertiesValue_oms" }, "ItemPropertiesValue_bil": { "Source": "iwm_articles_synesty.ItemPropertiesValue_bil" }, "ItemImageDate": { "Source": "iwm_articles_synesty.ItemImageDate" }, "ItemProducerID": { "Source": "iwm_articles_synesty.ItemProducerID" }, "LBNTEK": { "Source": "iwm_articles_synesty.LBNTEK" }, "LBKALK": { "Source": "iwm_articles_synesty.LBKALK" }, "LBMARGE": { "Source": "iwm_articles_synesty.LBMARGE" }, "LBWAEISA": { "Source": "iwm_articles_synesty.LBWAEISA" }, "AbsatzMenge3M": { "Source": "iwm_articles_synesty.AbsatzMenge3M" }, "imageUrl": { "Source": "iwm_articles_synesty.imageUrl" }, "swag_attr24": { "Source": "iwm_articles_synesty.swag_attr24" }, "swag_attr25": { "Source": "iwm_articles_synesty.swag_attr25" }, "swag_attr22": { "Source": "iwm_articles_synesty.swag_attr22" }, "shippingfree": { "Source": "iwm_articles_synesty.shippingfree" }, "stock_witten": { "Source": "iwm_articles_stock.witten", "In_Export": "no" }, "stock": { "Source": "iwm_articles_stock.stock", "In_Export": "no" } }
Filters [ { "Filter": { "name": "Mindestbestand", "condition": "(Price1_ost < 6) AND (stock_witten < 10) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L')", "reason": "Mindestbestand (price < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)" } }, { "Filter": { "name": "Mindestbestand", "condition": "(Price1_ost < 25) AND (stock_witten < 3) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L')", "reason": "Mindestbestand (price < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)" } }, { "Filter": { "name": "Mindestbestand", "condition": "(Price1_ost < 100) AND (stock_witten < 1) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L')", "reason": "Mindestbestand (price < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)" } }, { "Filter": { "name": "Preis ungueltig", "condition": "(Price1_ost == '0') or (Price1_ost == '') or (Price1_ost == '0.00') or (Price1_ost == '0,00') or (Price1_ost == '0,0')", "reason": "alle Preise = 0" } }, { "Filter": { "name": "Zu lange Lieferzeit", "condition": "(ItemFreeTextField11 == 'L') and (ItemFreeTextField12 > 6) and (stock == 0) and (ItemFreeTextField2 > 89)", "reason": "Zu lange Lieferzeit" } }, { "Filter": { "name": "Zu lange Lieferzeit Suppliernumber 782577", "condition": "(ItemFreeTextField11 == 'L') and (ItemFreeTextField12 > 4) and (stock == 0) and (ItemProducer_ost == 'Casa Nova')", "reason": "Zu lange Lieferzeit Suppliernumber 782577" } } ]
Datapool export_articles_synesty
Primary_Key ItemKey