Engine bearbeiten

Bestand öffnen Altbestand Zum Editor Run erst mit Status active

DRAFT Status

engine Typ

import Runner

1 Revisionen

Editor

Engine bearbeiten

Definitionstyp Runner-Typ

Name Titel

Status YAML-Inhalt

Engine: Import
Source_Config: oster400
Target_Config: importEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService

Queries:
 - Query:
     TargetDatapool: iwm_articles_new_eans_1
     GetQuery: SELECT
                 ARFIRM  AS firma,
                 ARARTE  AS mainnumber,
                 CASE ai.AIAPNR
                 WHEN 0
                   THEN CAST(ar.ARARTE AS VARCHAR(10))
                 ELSE CONCAT(CONCAT(CAST(ar.ARARTE AS VARCHAR(10)),'-'),ai.AIAPNR)
                 END       AS ordernumber,
                 ar.AREANR AS ean
               FROM IWMV2R1DTA.ARTS01 ar
                 LEFT JOIN IWMV2R1DTA.AIDN00 ai ON ar.ARFIRM = ai.AIFIRM AND ar.ARARTE = ai.AIARTE
               WHERE ARSTAT = 'A'
                     AND ai.aistat = 'A'
                     AND (ai.AIAPNR > 0 or ai.AIAPNR is null or ai.AIAPNR = 0)
                     AND (ai.AIAPNR < 300 or ai.AIAPNR is null or ai.AIAPNR = 0)
                     AND (ai.AISTAT = 'A' or ai.AISTAT is null or ai.AIAPNR = 0)
                     AND (ARFIRM = 1 or ARFIRM = 3) AND ar.AREANR != 0

Validation

Validierung

Keine Validierungsfehler gespeichert.

Metadata

Metadaten

mode	-
name	iwm_articles_new_eans_1
datapool	-
runner_type	import
feature_flags	Queries
source_config	oster400
target_config	importEngine
definition_kind	engine
source_datapool	-
target_datapool	-
source_files_count	0
mapping_entry_count	0
connection_references	oster400
source_connection_type	database
target_connection_type	-

History

Revisionen

Rev	Erstellt	Fehler
1	2026-03-17 13:42:16.766616+00	0