Engine / Editor
iwm_prices_direct
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
Datapool: iwm_prices Datapool_Definition: ordernumber: VARCHAR(255) DEFAULT NULL firma: VARCHAR(5) DEFAULT NULL Price1_ost: VARCHAR(40) DEFAULT NULL Price2_ost: VARCHAR(40) DEFAULT NULL Price3_ost: VARCHAR(40) DEFAULT NULL ItemMRP_ost: VARCHAR(40) DEFAULT NULL Price1_tre: VARCHAR(40) DEFAULT NULL Price2_tre: VARCHAR(40) DEFAULT NULL Price3_tre: VARCHAR(40) DEFAULT NULL ItemMRP_tre: VARCHAR(40) DEFAULT NULL Price1_oms: VARCHAR(40) DEFAULT NULL Price2_oms: VARCHAR(40) DEFAULT NULL Price3_oms: VARCHAR(40) DEFAULT NULL ItemMRP_oms: VARCHAR(40) DEFAULT NULL Primary_Key: [ordernumber, firma] Adapter_Name: iwm_prices Engine: Unitize Source_Config: importEngine Target_Config: unitizeEngine Mysql_Engine: InnoDB Default_Charset: latin1 Source_Connection_Type: database Source_Database_Connection_Service: IwmDatabaseConnectionService Sql: SELECT IF (iwm_prices_IWMV2R1DTA_PREI00.PRFIRM = 1 AND iwm_prices_IWMV2R1DTA_PREI00.PRPGRG1 = 1 AND iwm_prices_IWMV2R1DTA_PREI00.PRPGRG2 = 0 AND iwm_prices_IWMV2R1DTA_PREI00.PRPGRG3 = 0 AND iwm_prices_IWMV2R1DTA_ARTS00.ASPR == 0 OR iwm_prices_IWMV2R1DTA_ARTS01.ASPR != 0, iwm_prices_IWMV2R1DTA_PREI00.PRVKO1) PRVKO1 AS Price1_ost, IF (iwm_prices_IWMV2R1DTA_PREI00.PRFIRM = 3, iwm_prices_IWMV2R1DTA_PREI00.PRVKO1) PRVKO1 AS Price1_tre FROM iwm_prices_IWMV2R1DTA_PREI00 JOIN iwm_prices_IWMV2R1DTA_ARTS01 ON WHERE iwm_prices_IWMV2R1DTA_ARTS01 = 'A' AND iwm_prices_IWMV2R1DTA_PREI00 = 'A' IF(iwm_articles.LBKALK != '',iwm_articles.LBKALK,0) AS instock, $price_query = ' SELECT PRFIRM, PRVKHS, PRARTE, PRARTE AS PRARTETXT, PRPGR1, PRPGR2, PRPGR3, CONCAT(PRPGR1,PRPGR2,PRPGR3) AS PRPGRG, PRVKO1, PRVKO2, PRVKO3, PRVKO4, PRVKO5, PRVKO6, IIf([PRDAET]=0,Now(),PRDAET & "." & PRDAEM & "." & PRDAEJ & " " & Mid(Format(PRDAEZ,"0000"),1,2) & ":" & Mid(Format([PRDAEZ],"0000"),3,2) & ":00") AS PRDAE, IIf([PRDERT]=0,Now(),[PRDERT] & "." & [PRDERM] & "." & [PRDERJ] & " " & Mid(Format([PRDERZ],"0000"),1,2) & ":" & Mid(Format([PRDERZ],"0000"),3,2) & ":00") AS PRDER FROM IWMV2R1DTA.ARTS01 INNER JOIN IWMV2R1DTA.PREI00 ON (IWMV2R1DTA.ARTS01.ARFIRM = IWMV2R1DTA.PREI00.PRFIRM) AND (IWMV2R1DTA.ARTS01.ARARTE = IWMV2R1DTA.PREI00.PRARTE) WHERE (PRSTAT="A" AND ARSTAT="A") GROUP BY PRFIRM, PRVKHS, PRARTE, PRARTE, PRPGR1, PRPGR2, PRPGR3, CONCAT(PRPGR1,PRPGR2,PRPGR3), PRVKO1, PRVKO2, PRVKO3, PRVKO4, PRVKO5, PRVKO6, IIf([PRDAET]=0,Now(),[PRDAET] & "." & [PRDAEM] & "." & [PRDAEJ] & " " & Mid(Format([PRDAEZ],"0000"),1,2) & ":" & Mid(Format([PRDAEZ],"0000"),3,2) & ":00"), IIf([PRDERT]=0,Now(),[PRDERT] & "." & [PRDERM] & "." & [PRDERJ] & " " & Mid(Format([PRDERZ],"0000"),1,2) & ":" & Mid(Format([PRDERZ],"0000"),3,2) & ":00"), CDate([PRDGAT] & "." & [PRDGAM] & "." & [PRDGAJ]), CDate([PRDGBT] & "." & [PRDGBM] & "." & [PRDGBJ]), PRPROG, PRDGAJ, PRDGAM, PRDGAT, PRDGBJ, PRDGBM, PRDGBT HAVING ((PRFIRM=3) AND (PRVKHS=0 Or PRVKHS=97) AND ((CDate([PRDGAT] & "." & [PRDGAM] & "." & [PRDGAJ]))<=Date()) AND ((CDate([PRDGBT] & "." & [PRDGBM] & "." & [PRDGBJ]))>=Date())) ORDER BY PRDGAJ DESC , PRDGAM DESC , PRDGAT DESC, PRDGBJ, PRDGBM, PRDGBT; '; 'ordernumber' => 'varchar(255) DEFAULT NULL', 'mainnumber' => 'varchar(255) DEFAULT NULL', 'stock' => 'int(11) DEFAULT NULL', 'witten' => 'varchar(11) DEFAULT NULL', 'bottrop' => 'varchar(11) DEFAULT NULL', 'recklinghausen' => 'varchar(11) DEFAULT NULL', 'haan' => 'varchar(11) DEFAULT NULL', 'leverkusen' => 'varchar(11) DEFAULT NULL', 'firma' => 'varchar(11) DEFAULT NULL', 'ItemKey' => 'varchar(50) DEFAULT NULL',
Definition aktualisieren