Legacy YAML / Detail

unitize / unitize_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
iwm_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.

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: ItemKey
Target_Primary_Key: ItemKey #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: iwm_articles_synesty
Datapool_Definition:
    ordernumber: VARCHAR(255) DEFAULT NULL
    ItemKey: VARCHAR(255) NOT NULL
    ItemFirm: VARCHAR(255) DEFAULT NULL
    ItemSpar: INT(11) DEFAULT NULL
    ItemNo: VARCHAR(40) DEFAULT NULL
    ItemAspr: VARCHAR(40) DEFAULT NULL
    Variation: VARCHAR(255) DEFAULT NULL
    VariationNo: VARCHAR(255) DEFAULT NULL
    ItemEAN: VARCHAR(255) DEFAULT NULL
    ItemProducer_ost: VARCHAR(255) DEFAULT NULL
    ItemProducer_tre: VARCHAR(255) DEFAULT NULL
    ItemProducer_oms: VARCHAR(255) DEFAULT NULL
    ItemProducer_bil: VARCHAR(255) DEFAULT NULL
    ItemTextName_ost: VARCHAR(255) DEFAULT NULL
    ItemTextName_tre: VARCHAR(255) DEFAULT NULL
    ItemTextName_oms: VARCHAR(255) DEFAULT NULL
    ItemTextName_bil: VARCHAR(255) DEFAULT NULL
    ItemTextDescription_ost: TEXT DEFAULT NULL
    ItemTextDescription_tre: TEXT DEFAULT NULL
    ItemTextDescription_oms: TEXT DEFAULT NULL
    ItemTextDescription_bil: TEXT DEFAULT NULL
    Price1_ost: VARCHAR(255) DEFAULT NULL
    Price2_ost: VARCHAR(255) DEFAULT NULL
    Price3_ost: VARCHAR(255) DEFAULT NULL
    ItemMRP_ost: VARCHAR(255) DEFAULT NULL
    Price1_tre: VARCHAR(255) DEFAULT NULL
    Price2_tre: VARCHAR(255) DEFAULT NULL
    Price3_tre: VARCHAR(255) DEFAULT NULL
    ItemMRP_tre: VARCHAR(255) DEFAULT NULL
    Price1_oms: VARCHAR(255) DEFAULT NULL
    Price2_oms: VARCHAR(255) DEFAULT NULL
    Price3_oms: VARCHAR(255) DEFAULT NULL
    ItemMRP_oms: VARCHAR(255) DEFAULT NULL
    Price1_bil: VARCHAR(255) DEFAULT NULL
    Price2_bil: VARCHAR(255) DEFAULT NULL
    Price3_bil: VARCHAR(255) DEFAULT NULL
    ItemMRP_bil: VARCHAR(255) DEFAULT NULL
    AttributName1: VARCHAR(255) DEFAULT NULL
    AttributeValue1: VARCHAR(255) DEFAULT NULL
    AttributName2: VARCHAR(255) DEFAULT NULL
    AttributeValue2: VARCHAR(255) DEFAULT NULL
    AttributName3: VARCHAR(255) DEFAULT NULL
    AttributeValue3: VARCHAR(255) DEFAULT NULL
    PriceWidth: VARCHAR(255) DEFAULT NULL
    PriceHeight: VARCHAR(255) DEFAULT NULL
    PriceLength: VARCHAR(255) DEFAULT NULL
    PriceWeight: VARCHAR(255) DEFAULT NULL
    PriceWeightNet: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebshop_ost: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebshop_tre: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebshop_oms: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebshop_bil: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebApi_ost: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebApi_tre: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebApi_oms: VARCHAR(255) DEFAULT NULL
    ItemVisibilityWebApi_bil: VARCHAR(255) DEFAULT NULL
    ItemStoreIDs_ost: VARCHAR(255) DEFAULT NULL
    ItemStoreIDs_tre: VARCHAR(255) DEFAULT NULL
    ItemStoreIDs_oms: VARCHAR(255) DEFAULT NULL
    ItemStoreIDs_bil: VARCHAR(255) DEFAULT NULL
    ItemLimitOrderByStock_ost: VARCHAR(255) DEFAULT NULL
    ItemLimitOrderByStock_tre: VARCHAR(255) DEFAULT NULL
    ItemLimitOrderByStock_oms: VARCHAR(255) DEFAULT NULL
    ItemLimitOrderByStock_bil: VARCHAR(255) DEFAULT NULL
    ItemPrimaryWarehouse_ost: VARCHAR(255) DEFAULT NULL
    ItemPrimaryWarehouse_tre: VARCHAR(255) DEFAULT NULL
    ItemPrimaryWarehouse_oms: VARCHAR(255) DEFAULT NULL
    ItemPrimaryWarehouse_bil: VARCHAR(255) DEFAULT NULL
    ItemCrossList_ost: VARCHAR(255) DEFAULT NULL
    ItemCrossList_tre: VARCHAR(255) DEFAULT NULL
    ItemCrossList_oms: VARCHAR(255) DEFAULT NULL
    ItemCrossList_bil: VARCHAR(255) DEFAULT NULL
    ItemInactive_ost: VARCHAR(255) DEFAULT NULL
    ItemInactive_tre: VARCHAR(255) DEFAULT NULL
    ItemInactive_oms: VARCHAR(255) DEFAULT NULL
    ItemInactive_bil: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField1: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField2: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField3: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField4: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField5: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField6: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField7: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField8: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField9: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField10: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField11: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField12: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField13: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField14: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField15: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField16: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField17: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField18: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField19: VARCHAR(255) DEFAULT NULL
    ItemFreeTextField20: VARCHAR(255) DEFAULT NULL
    ItemCategories_ost: TEXT DEFAULT NULL
    ItemCategories_tre: TEXT DEFAULT NULL
    ItemCategories_oms: TEXT DEFAULT NULL
    ItemCategories_bil: TEXT DEFAULT NULL
    ItemPropertiesID_ost: VARCHAR(255) DEFAULT NULL
    ItemPropertiesID_tre: VARCHAR(255) DEFAULT NULL
    ItemPropertiesID_oms: VARCHAR(255) DEFAULT NULL
    ItemPropertiesID_bil: VARCHAR(255) DEFAULT NULL
    ItemPropertiesValue_ost: VARCHAR(255) DEFAULT NULL
    ItemPropertiesValue_tre: VARCHAR(255) DEFAULT NULL
    ItemPropertiesValue_oms: VARCHAR(255) DEFAULT NULL
    ItemPropertiesValue_bil: VARCHAR(255) DEFAULT NULL
    ItemImageDate: VARCHAR(255) DEFAULT NULL
    ItemProducerID: VARCHAR(255) DEFAULT NULL
    LBNTEK: VARCHAR(255) DEFAULT NULL
    LBKALK: VARCHAR(255) DEFAULT NULL
    LBMARGE: VARCHAR(255) DEFAULT NULL
    LBWAEISA: VARCHAR(255) DEFAULT NULL
    AbsatzMenge3M: VARCHAR(255) DEFAULT NULL
    imageUrl: VARCHAR(255) DEFAULT NULL
    swag_attr24: VARCHAR(255) DEFAULT NULL
    swag_attr25: VARCHAR(255) DEFAULT NULL
    swag_attr22: VARCHAR(255) DEFAULT NULL
    shippingfree: VARCHAR(255) DEFAULT NULL


Mapping:
    ordernumber:
     Source: iwm_articles_new.VariationNo
     Field_Adapter:
      - replace: ['-0', '']
    ItemKey:
     Source: iwm_articles_new.ItemKey
    ItemFirm:
     Source: iwm_articles_new.ItemFirm
    ItemSpar:
     Source: iwm_articles_new.ItemSpar
    ItemNo:
     Source: iwm_articles_new.ItemNo
    ItemAspr:
     Source: iwm_articles_new.ItemAspr
    Variation:
     Source: iwm_articles_new.Variation
    VariationNo:
     Source: iwm_articles_new.VariationNo
    ItemEAN:
     Source: iwm_articles_new.ItemEAN
    ItemProducer_ost:
     Source: iwm_articles_new.ItemProducer_ost
    ItemProducer_tre:
     Source: iwm_articles_new.ItemProducer_tre
    ItemProducer_oms:
     Source: iwm_articles_new.ItemProducer_oms
    ItemProducer_bil:
     Source: iwm_articles_new.ItemProducer_bil
    ItemTextName_ost:
     Source: iwm_articles_new.ItemTextName_ost
    ItemTextName_tre:
     Source: iwm_articles_new.ItemTextName_tre
    ItemTextName_oms:
     Source: iwm_articles_new.ItemTextName_oms
    ItemTextName_bil:
     Source: iwm_articles_new.ItemTextName_bil
    ItemTextDescription_ost:
     Source: iwm_articles_new.ItemTextDescription_ost
    ItemTextDescription_tre:
     Source: iwm_articles_new.ItemTextDescription_tre
    ItemTextDescription_oms:
     Source: iwm_articles_new.ItemTextDescription_oms
    ItemTextDescription_bil:
     Source: iwm_articles_new.ItemTextDescription_bil
    Price1_ost:
     Source: iwm_articles_new.Price1_ost
    Price2_ost:
     Source: iwm_articles_new.Price2_ost
    Price3_ost:
     Source: iwm_articles_new.Price3_ost
    ItemMRP_ost:
     Source: iwm_articles_new.ItemMRP_ost
    Price1_tre:
     Source: iwm_articles_new.Price1_tre
    Price2_tre:
     Source: iwm_articles_new.Price2_tre
    Price3_tre:
     Source: iwm_articles_new.Price3_tre
    ItemMRP_tre:
     Source: iwm_articles_new.ItemMRP_tre
    Price1_oms:
     Source: iwm_articles_new.Price1_oms
    Price2_oms:
     Source: iwm_articles_new.Price2_oms
    Price3_oms:
     Source: iwm_articles_new.Price3_oms
    ItemMRP_oms:
     Source: iwm_articles_new.ItemMRP_oms
    Price1_bil:
     Source: iwm_articles_new.Price1_bil
    Price2_bil:
     Source: iwm_articles_new.Price2_bil
    Price3_bil:
     Source: iwm_articles_new.Price3_bil
    ItemMRP_bil:
     Source: iwm_articles_new.ItemMRP_bil
    AttributName1:
     Source: iwm_articles_new.AttributName1
    AttributeValue1:
     Source: iwm_articles_new.AttributeValue1
    AttributName2:
     Source: iwm_articles_new.AttributName2
    AttributeValue2:
     Source: iwm_articles_new.AttributeValue2
    AttributName3:
     Source: iwm_articles_new.AttributName3
    AttributeValue3:
     Source: iwm_articles_new.AttributeValue3
    PriceWidth:
     Source: iwm_articles_new.PriceWidth
    PriceHeight:
     Source: iwm_articles_new.PriceHeight
    PriceLength:
     Source: iwm_articles_new.PriceLength
    PriceWeight:
     Source: iwm_articles_new.PriceWeight
    PriceWeightNet:
     Source: iwm_articles_new.PriceWeightNet
    ItemVisibilityWebshop_ost:
     Source: iwm_articles_new.ItemVisibilityWebshop_ost
    ItemVisibilityWebshop_tre:
     Source: iwm_articles_new.ItemVisibilityWebshop_tre
    ItemVisibilityWebshop_oms:
     Source: iwm_articles_new.ItemVisibilityWebshop_oms
    ItemVisibilityWebshop_bil:
     Source: iwm_articles_new.ItemVisibilityWebshop_bil
    ItemVisibilityWebApi_ost:
     Source: iwm_articles_new.ItemVisibilityWebApi_ost
    ItemVisibilityWebApi_tre:
     Source: iwm_articles_new.ItemVisibilityWebApi_tre
    ItemVisibilityWebApi_oms:
     Source: iwm_articles_new.ItemVisibilityWebApi_oms
    ItemVisibilityWebApi_bil:
     Source: iwm_articles_new.ItemVisibilityWebApi_bil
    ItemStoreIDs_ost:
     Source: iwm_articles_new.ItemStoreIDs_ost
    ItemStoreIDs_tre:
     Source: iwm_articles_new.ItemStoreIDs_tre
    ItemStoreIDs_oms:
     Source: iwm_articles_new.ItemStoreIDs_oms
    ItemStoreIDs_bil:
     Source: iwm_articles_new.ItemStoreIDs_bil
    ItemLimitOrderByStock_ost:
     Source: iwm_articles_new.ItemLimitOrderByStock_ost
    ItemLimitOrderByStock_tre:
     Source: iwm_articles_new.ItemLimitOrderByStock_tre
    ItemLimitOrderByStock_oms:
     Source: iwm_articles_new.ItemLimitOrderByStock_oms
    ItemLimitOrderByStock_bil:
     Source: iwm_articles_new.ItemLimitOrderByStock_bil
    ItemPrimaryWarehouse_ost:
     Source: iwm_articles_new.ItemPrimaryWarehouse_ost
    ItemPrimaryWarehouse_tre:
     Source: iwm_articles_new.ItemPrimaryWarehouse_tre
    ItemPrimaryWarehouse_oms:
     Source: iwm_articles_new.ItemPrimaryWarehouse_oms
    ItemPrimaryWarehouse_bil:
     Source: iwm_articles_new.ItemPrimaryWarehouse_bil
    ItemCrossList_ost:
     Source: iwm_articles_new.ItemCrossList_ost
    ItemCrossList_tre:
     Source: iwm_articles_new.ItemCrossList_tre
    ItemCrossList_oms:
     Source: iwm_articles_new.ItemCrossList_oms
    ItemCrossList_bil:
     Source: iwm_articles_new.ItemCrossList_bil
    ItemInactive_ost:
     Source: iwm_articles_new.ItemInactive_ost
    ItemInactive_tre:
     Source: iwm_articles_new.ItemInactive_tre
    ItemInactive_oms:
     Source: iwm_articles_new.ItemInactive_oms
    ItemInactive_bil:
     Source: iwm_articles_new.ItemInactive_bil
    ItemFreeTextField1:
     Source: iwm_articles_new.ItemFreeTextField1
    ItemFreeTextField2:
     Source: iwm_articles_new.ItemFreeTextField2
    ItemFreeTextField3:
     Source: iwm_articles_new.ItemFreeTextField3
    ItemFreeTextField4:
     Source: iwm_articles_new.ItemFreeTextField4
    ItemFreeTextField5:
     Source: iwm_articles_new.ItemFreeTextField5
    ItemFreeTextField6:
     Source: iwm_articles_new.ItemFreeTextField6
    ItemFreeTextField7:
     Source: iwm_articles_new.ItemFreeTextField7
    ItemFreeTextField8:
     Source: iwm_articles_new.ItemFreeTextField8
    ItemFreeTextField9:
     Source: iwm_articles_new.ItemFreeTextField9
    ItemFreeTextField10:
     Source: iwm_articles_new.ItemFreeTextField10
    ItemFreeTextField11:
     Source: iwm_articles_new.ItemFreeTextField11
    ItemFreeTextField12:
     Source: iwm_articles_new.ItemFreeTextField12
    ItemFreeTextField13:
     Source: iwm_articles_new.ItemFreeTextField13
    ItemFreeTextField14:
     Source: iwm_articles_new.ItemFreeTextField14
    ItemFreeTextField15:
     Source: iwm_articles_new.ItemFreeTextField15
    ItemFreeTextField16:
     Source: iwm_articles_new.ItemFreeTextField16
    ItemFreeTextField17:
     Source: iwm_articles_new.ItemFreeTextField17
    ItemFreeTextField18:
     Source: iwm_articles_new.ItemFreeTextField18
    ItemFreeTextField19:
     Source: iwm_articles_new.ItemFreeTextField19
    ItemFreeTextField20:
     Source: iwm_articles_new.ItemFreeTextField20
    ItemCategories_ost:
     Source: iwm_articles_new.ItemCategories_ost
    ItemCategories_tre:
     Source: iwm_articles_new.ItemCategories_tre
    ItemCategories_oms:
     Source: iwm_articles_new.ItemCategories_oms
    ItemCategories_bil:
     Source: iwm_articles_new.ItemCategories_bil
    ItemPropertiesID_ost:
     Source: iwm_articles_new.ItemPropertiesID_ost
    ItemPropertiesID_tre:
     Source: iwm_articles_new.ItemPropertiesID_tre
    ItemPropertiesID_oms:
     Source: iwm_articles_new.ItemPropertiesID_oms
    ItemPropertiesID_bil:
     Source: iwm_articles_new.ItemPropertiesID_bil
    ItemPropertiesValue_ost:
     Source: iwm_articles_new.ItemPropertiesValue_ost
    ItemPropertiesValue_tre:
     Source: iwm_articles_new.ItemPropertiesValue_tre
    ItemPropertiesValue_oms:
     Source: iwm_articles_new.ItemPropertiesValue_oms
    ItemPropertiesValue_bil:
     Source: iwm_articles_new.ItemPropertiesValue_bil
    ItemImageDate:
     Source: iwm_articles_new.ItemImageDate
    ItemProducerID:
     Source: iwm_articles_new.ItemProducerID
    LBNTEK:
     Source: iwm_articles_new.LBNTEK
    LBKALK:
     Source: iwm_articles_new.LBKALK
    LBMARGE:
     Source: iwm_articles_new.LBMARGE
    LBWAEISA:
     Source: iwm_articles_new.LBWAEISA
    AbsatzMenge3M:
     Source: iwm_articles_new.AbsatzMenge3M
    imageUrl:
     Source: iwm_articles_new.imageUrl
    swag_attr24:
     Source: iwm_articles_new.swag_attr24
    swag_attr25:
     Source: iwm_articles_new.swag_attr25
    swag_attr22:
     Source: iwm_articles_new.swag_attr22
    shippingfree:
     Source: iwm_articles_new.shippingfree

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 ItemKey
Target_Primary_Key ItemKey
Datapool iwm_articles_synesty
Datapool_Definition { "ordernumber": "VARCHAR(255) DEFAULT NULL", "ItemKey": "VARCHAR(255) NOT NULL", "ItemFirm": "VARCHAR(255) DEFAULT NULL", "ItemSpar": "INT(11) DEFAULT NULL", "ItemNo": "VARCHAR(40) DEFAULT NULL", "ItemAspr": "VARCHAR(40) DEFAULT NULL", "Variation": "VARCHAR(255) DEFAULT NULL", "VariationNo": "VARCHAR(255) DEFAULT NULL", "ItemEAN": "VARCHAR(255) DEFAULT NULL", "ItemProducer_ost": "VARCHAR(255) DEFAULT NULL", "ItemProducer_tre": "VARCHAR(255) DEFAULT NULL", "ItemProducer_oms": "VARCHAR(255) DEFAULT NULL", "ItemProducer_bil": "VARCHAR(255) DEFAULT NULL", "ItemTextName_ost": "VARCHAR(255) DEFAULT NULL", "ItemTextName_tre": "VARCHAR(255) DEFAULT NULL", "ItemTextName_oms": "VARCHAR(255) DEFAULT NULL", "ItemTextName_bil": "VARCHAR(255) DEFAULT NULL", "ItemTextDescription_ost": "TEXT DEFAULT NULL", "ItemTextDescription_tre": "TEXT DEFAULT NULL", "ItemTextDescription_oms": "TEXT DEFAULT NULL", "ItemTextDescription_bil": "TEXT DEFAULT NULL", "Price1_ost": "VARCHAR(255) DEFAULT NULL", "Price2_ost": "VARCHAR(255) DEFAULT NULL", "Price3_ost": "VARCHAR(255) DEFAULT NULL", "ItemMRP_ost": "VARCHAR(255) DEFAULT NULL", "Price1_tre": "VARCHAR(255) DEFAULT NULL", "Price2_tre": "VARCHAR(255) DEFAULT NULL", "Price3_tre": "VARCHAR(255) DEFAULT NULL", "ItemMRP_tre": "VARCHAR(255) DEFAULT NULL", "Price1_oms": "VARCHAR(255) DEFAULT NULL", "Price2_oms": "VARCHAR(255) DEFAULT NULL", "Price3_oms": "VARCHAR(255) DEFAULT NULL", "ItemMRP_oms": "VARCHAR(255) DEFAULT NULL", "Price1_bil": "VARCHAR(255) DEFAULT NULL", "Price2_bil": "VARCHAR(255) DEFAULT NULL", "Price3_bil": "VARCHAR(255) DEFAULT NULL", "ItemMRP_bil": "VARCHAR(255) DEFAULT NULL", "AttributName1": "VARCHAR(255) DEFAULT NULL", "AttributeValue1": "VARCHAR(255) DEFAULT NULL", "AttributName2": "VARCHAR(255) DEFAULT NULL", "AttributeValue2": "VARCHAR(255) DEFAULT NULL", "AttributName3": "VARCHAR(255) DEFAULT NULL", "AttributeValue3": "VARCHAR(255) DEFAULT NULL", "PriceWidth": "VARCHAR(255) DEFAULT NULL", "PriceHeight": "VARCHAR(255) DEFAULT NULL", "PriceLength": "VARCHAR(255) DEFAULT NULL", "PriceWeight": "VARCHAR(255) DEFAULT NULL", "PriceWeightNet": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebshop_ost": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebshop_tre": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebshop_oms": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebshop_bil": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebApi_ost": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebApi_tre": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebApi_oms": "VARCHAR(255) DEFAULT NULL", "ItemVisibilityWebApi_bil": "VARCHAR(255) DEFAULT NULL", "ItemStoreIDs_ost": "VARCHAR(255) DEFAULT NULL", "ItemStoreIDs_tre": "VARCHAR(255) DEFAULT NULL", "ItemStoreIDs_oms": "VARCHAR(255) DEFAULT NULL", "ItemStoreIDs_bil": "VARCHAR(255) DEFAULT NULL", "ItemLimitOrderByStock_ost": "VARCHAR(255) DEFAULT NULL", "ItemLimitOrderByStock_tre": "VARCHAR(255) DEFAULT NULL", "ItemLimitOrderByStock_oms": "VARCHAR(255) DEFAULT NULL", "ItemLimitOrderByStock_bil": "VARCHAR(255) DEFAULT NULL", "ItemPrimaryWarehouse_ost": "VARCHAR(255) DEFAULT NULL", "ItemPrimaryWarehouse_tre": "VARCHAR(255) DEFAULT NULL", "ItemPrimaryWarehouse_oms": "VARCHAR(255) DEFAULT NULL", "ItemPrimaryWarehouse_bil": "VARCHAR(255) DEFAULT NULL", "ItemCrossList_ost": "VARCHAR(255) DEFAULT NULL", "ItemCrossList_tre": "VARCHAR(255) DEFAULT NULL", "ItemCrossList_oms": "VARCHAR(255) DEFAULT NULL", "ItemCrossList_bil": "VARCHAR(255) DEFAULT NULL", "ItemInactive_ost": "VARCHAR(255) DEFAULT NULL", "ItemInactive_tre": "VARCHAR(255) DEFAULT NULL", "ItemInactive_oms": "VARCHAR(255) DEFAULT NULL", "ItemInactive_bil": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField1": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField2": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField3": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField4": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField5": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField6": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField7": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField8": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField9": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField10": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField11": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField12": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField13": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField14": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField15": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField16": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField17": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField18": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField19": "VARCHAR(255) DEFAULT NULL", "ItemFreeTextField20": "VARCHAR(255) DEFAULT NULL", "ItemCategories_ost": "TEXT DEFAULT NULL", "ItemCategories_tre": "TEXT DEFAULT NULL", "ItemCategories_oms": "TEXT DEFAULT NULL", "ItemCategories_bil": "TEXT DEFAULT NULL", "ItemPropertiesID_ost": "VARCHAR(255) DEFAULT NULL", "ItemPropertiesID_tre": "VARCHAR(255) DEFAULT NULL", "ItemPropertiesID_oms": "VARCHAR(255) DEFAULT NULL", "ItemPropertiesID_bil": "VARCHAR(255) DEFAULT NULL", "ItemPropertiesValue_ost": "VARCHAR(255) DEFAULT NULL", "ItemPropertiesValue_tre": "VARCHAR(255) DEFAULT NULL", "ItemPropertiesValue_oms": "VARCHAR(255) DEFAULT NULL", "ItemPropertiesValue_bil": "VARCHAR(255) DEFAULT NULL", "ItemImageDate": "VARCHAR(255) DEFAULT NULL", "ItemProducerID": "VARCHAR(255) DEFAULT NULL", "LBNTEK": "VARCHAR(255) DEFAULT NULL", "LBKALK": "VARCHAR(255) DEFAULT NULL", "LBMARGE": "VARCHAR(255) DEFAULT NULL", "LBWAEISA": "VARCHAR(255) DEFAULT NULL", "AbsatzMenge3M": "VARCHAR(255) DEFAULT NULL", "imageUrl": "VARCHAR(255) DEFAULT NULL", "swag_attr24": "VARCHAR(255) DEFAULT NULL", "swag_attr25": "VARCHAR(255) DEFAULT NULL", "swag_attr22": "VARCHAR(255) DEFAULT NULL", "shippingfree": "VARCHAR(255) DEFAULT NULL" }
Mapping { "ordernumber": { "Source": "iwm_articles_new.VariationNo", "Field_Adapter": [ { "replace": [ "-0", "" ] } ] }, "ItemKey": { "Source": "iwm_articles_new.ItemKey" }, "ItemFirm": { "Source": "iwm_articles_new.ItemFirm" }, "ItemSpar": { "Source": "iwm_articles_new.ItemSpar" }, "ItemNo": { "Source": "iwm_articles_new.ItemNo" }, "ItemAspr": { "Source": "iwm_articles_new.ItemAspr" }, "Variation": { "Source": "iwm_articles_new.Variation" }, "VariationNo": { "Source": "iwm_articles_new.VariationNo" }, "ItemEAN": { "Source": "iwm_articles_new.ItemEAN" }, "ItemProducer_ost": { "Source": "iwm_articles_new.ItemProducer_ost" }, "ItemProducer_tre": { "Source": "iwm_articles_new.ItemProducer_tre" }, "ItemProducer_oms": { "Source": "iwm_articles_new.ItemProducer_oms" }, "ItemProducer_bil": { "Source": "iwm_articles_new.ItemProducer_bil" }, "ItemTextName_ost": { "Source": "iwm_articles_new.ItemTextName_ost" }, "ItemTextName_tre": { "Source": "iwm_articles_new.ItemTextName_tre" }, "ItemTextName_oms": { "Source": "iwm_articles_new.ItemTextName_oms" }, "ItemTextName_bil": { "Source": "iwm_articles_new.ItemTextName_bil" }, "ItemTextDescription_ost": { "Source": "iwm_articles_new.ItemTextDescription_ost" }, "ItemTextDescription_tre": { "Source": "iwm_articles_new.ItemTextDescription_tre" }, "ItemTextDescription_oms": { "Source": "iwm_articles_new.ItemTextDescription_oms" }, "ItemTextDescription_bil": { "Source": "iwm_articles_new.ItemTextDescription_bil" }, "Price1_ost": { "Source": "iwm_articles_new.Price1_ost" }, "Price2_ost": { "Source": "iwm_articles_new.Price2_ost" }, "Price3_ost": { "Source": "iwm_articles_new.Price3_ost" }, "ItemMRP_ost": { "Source": "iwm_articles_new.ItemMRP_ost" }, "Price1_tre": { "Source": "iwm_articles_new.Price1_tre" }, "Price2_tre": { "Source": "iwm_articles_new.Price2_tre" }, "Price3_tre": { "Source": "iwm_articles_new.Price3_tre" }, "ItemMRP_tre": { "Source": "iwm_articles_new.ItemMRP_tre" }, "Price1_oms": { "Source": "iwm_articles_new.Price1_oms" }, "Price2_oms": { "Source": "iwm_articles_new.Price2_oms" }, "Price3_oms": { "Source": "iwm_articles_new.Price3_oms" }, "ItemMRP_oms": { "Source": "iwm_articles_new.ItemMRP_oms" }, "Price1_bil": { "Source": "iwm_articles_new.Price1_bil" }, "Price2_bil": { "Source": "iwm_articles_new.Price2_bil" }, "Price3_bil": { "Source": "iwm_articles_new.Price3_bil" }, "ItemMRP_bil": { "Source": "iwm_articles_new.ItemMRP_bil" }, "AttributName1": { "Source": "iwm_articles_new.AttributName1" }, "AttributeValue1": { "Source": "iwm_articles_new.AttributeValue1" }, "AttributName2": { "Source": "iwm_articles_new.AttributName2" }, "AttributeValue2": { "Source": "iwm_articles_new.AttributeValue2" }, "AttributName3": { "Source": "iwm_articles_new.AttributName3" }, "AttributeValue3": { "Source": "iwm_articles_new.AttributeValue3" }, "PriceWidth": { "Source": "iwm_articles_new.PriceWidth" }, "PriceHeight": { "Source": "iwm_articles_new.PriceHeight" }, "PriceLength": { "Source": "iwm_articles_new.PriceLength" }, "PriceWeight": { "Source": "iwm_articles_new.PriceWeight" }, "PriceWeightNet": { "Source": "iwm_articles_new.PriceWeightNet" }, "ItemVisibilityWebshop_ost": { "Source": "iwm_articles_new.ItemVisibilityWebshop_ost" }, "ItemVisibilityWebshop_tre": { "Source": "iwm_articles_new.ItemVisibilityWebshop_tre" }, "ItemVisibilityWebshop_oms": { "Source": "iwm_articles_new.ItemVisibilityWebshop_oms" }, "ItemVisibilityWebshop_bil": { "Source": "iwm_articles_new.ItemVisibilityWebshop_bil" }, "ItemVisibilityWebApi_ost": { "Source": "iwm_articles_new.ItemVisibilityWebApi_ost" }, "ItemVisibilityWebApi_tre": { "Source": "iwm_articles_new.ItemVisibilityWebApi_tre" }, "ItemVisibilityWebApi_oms": { "Source": "iwm_articles_new.ItemVisibilityWebApi_oms" }, "ItemVisibilityWebApi_bil": { "Source": "iwm_articles_new.ItemVisibilityWebApi_bil" }, "ItemStoreIDs_ost": { "Source": "iwm_articles_new.ItemStoreIDs_ost" }, "ItemStoreIDs_tre": { "Source": "iwm_articles_new.ItemStoreIDs_tre" }, "ItemStoreIDs_oms": { "Source": "iwm_articles_new.ItemStoreIDs_oms" }, "ItemStoreIDs_bil": { "Source": "iwm_articles_new.ItemStoreIDs_bil" }, "ItemLimitOrderByStock_ost": { "Source": "iwm_articles_new.ItemLimitOrderByStock_ost" }, "ItemLimitOrderByStock_tre": { "Source": "iwm_articles_new.ItemLimitOrderByStock_tre" }, "ItemLimitOrderByStock_oms": { "Source": "iwm_articles_new.ItemLimitOrderByStock_oms" }, "ItemLimitOrderByStock_bil": { "Source": "iwm_articles_new.ItemLimitOrderByStock_bil" }, "ItemPrimaryWarehouse_ost": { "Source": "iwm_articles_new.ItemPrimaryWarehouse_ost" }, "ItemPrimaryWarehouse_tre": { "Source": "iwm_articles_new.ItemPrimaryWarehouse_tre" }, "ItemPrimaryWarehouse_oms": { "Source": "iwm_articles_new.ItemPrimaryWarehouse_oms" }, "ItemPrimaryWarehouse_bil": { "Source": "iwm_articles_new.ItemPrimaryWarehouse_bil" }, "ItemCrossList_ost": { "Source": "iwm_articles_new.ItemCrossList_ost" }, "ItemCrossList_tre": { "Source": "iwm_articles_new.ItemCrossList_tre" }, "ItemCrossList_oms": { "Source": "iwm_articles_new.ItemCrossList_oms" }, "ItemCrossList_bil": { "Source": "iwm_articles_new.ItemCrossList_bil" }, "ItemInactive_ost": { "Source": "iwm_articles_new.ItemInactive_ost" }, "ItemInactive_tre": { "Source": "iwm_articles_new.ItemInactive_tre" }, "ItemInactive_oms": { "Source": "iwm_articles_new.ItemInactive_oms" }, "ItemInactive_bil": { "Source": "iwm_articles_new.ItemInactive_bil" }, "ItemFreeTextField1": { "Source": "iwm_articles_new.ItemFreeTextField1" }, "ItemFreeTextField2": { "Source": "iwm_articles_new.ItemFreeTextField2" }, "ItemFreeTextField3": { "Source": "iwm_articles_new.ItemFreeTextField3" }, "ItemFreeTextField4": { "Source": "iwm_articles_new.ItemFreeTextField4" }, "ItemFreeTextField5": { "Source": "iwm_articles_new.ItemFreeTextField5" }, "ItemFreeTextField6": { "Source": "iwm_articles_new.ItemFreeTextField6" }, "ItemFreeTextField7": { "Source": "iwm_articles_new.ItemFreeTextField7" }, "ItemFreeTextField8": { "Source": "iwm_articles_new.ItemFreeTextField8" }, "ItemFreeTextField9": { "Source": "iwm_articles_new.ItemFreeTextField9" }, "ItemFreeTextField10": { "Source": "iwm_articles_new.ItemFreeTextField10" }, "ItemFreeTextField11": { "Source": "iwm_articles_new.ItemFreeTextField11" }, "ItemFreeTextField12": { "Source": "iwm_articles_new.ItemFreeTextField12" }, "ItemFreeTextField13": { "Source": "iwm_articles_new.ItemFreeTextField13" }, "ItemFreeTextField14": { "Source": "iwm_articles_new.ItemFreeTextField14" }, "ItemFreeTextField15": { "Source": "iwm_articles_new.ItemFreeTextField15" }, "ItemFreeTextField16": { "Source": "iwm_articles_new.ItemFreeTextField16" }, "ItemFreeTextField17": { "Source": "iwm_articles_new.ItemFreeTextField17" }, "ItemFreeTextField18": { "Source": "iwm_articles_new.ItemFreeTextField18" }, "ItemFreeTextField19": { "Source": "iwm_articles_new.ItemFreeTextField19" }, "ItemFreeTextField20": { "Source": "iwm_articles_new.ItemFreeTextField20" }, "ItemCategories_ost": { "Source": "iwm_articles_new.ItemCategories_ost" }, "ItemCategories_tre": { "Source": "iwm_articles_new.ItemCategories_tre" }, "ItemCategories_oms": { "Source": "iwm_articles_new.ItemCategories_oms" }, "ItemCategories_bil": { "Source": "iwm_articles_new.ItemCategories_bil" }, "ItemPropertiesID_ost": { "Source": "iwm_articles_new.ItemPropertiesID_ost" }, "ItemPropertiesID_tre": { "Source": "iwm_articles_new.ItemPropertiesID_tre" }, "ItemPropertiesID_oms": { "Source": "iwm_articles_new.ItemPropertiesID_oms" }, "ItemPropertiesID_bil": { "Source": "iwm_articles_new.ItemPropertiesID_bil" }, "ItemPropertiesValue_ost": { "Source": "iwm_articles_new.ItemPropertiesValue_ost" }, "ItemPropertiesValue_tre": { "Source": "iwm_articles_new.ItemPropertiesValue_tre" }, "ItemPropertiesValue_oms": { "Source": "iwm_articles_new.ItemPropertiesValue_oms" }, "ItemPropertiesValue_bil": { "Source": "iwm_articles_new.ItemPropertiesValue_bil" }, "ItemImageDate": { "Source": "iwm_articles_new.ItemImageDate" }, "ItemProducerID": { "Source": "iwm_articles_new.ItemProducerID" }, "LBNTEK": { "Source": "iwm_articles_new.LBNTEK" }, "LBKALK": { "Source": "iwm_articles_new.LBKALK" }, "LBMARGE": { "Source": "iwm_articles_new.LBMARGE" }, "LBWAEISA": { "Source": "iwm_articles_new.LBWAEISA" }, "AbsatzMenge3M": { "Source": "iwm_articles_new.AbsatzMenge3M" }, "imageUrl": { "Source": "iwm_articles_new.imageUrl" }, "swag_attr24": { "Source": "iwm_articles_new.swag_attr24" }, "swag_attr25": { "Source": "iwm_articles_new.swag_attr25" }, "swag_attr22": { "Source": "iwm_articles_new.swag_attr22" }, "shippingfree": { "Source": "iwm_articles_new.shippingfree" } }