GC_DWH/3_GC_DWH/OPTIMA/Verkauf.ktr

<transformation>
  <info>
    <name>Verkauf</name>
    <description/>
    <extended_description/>
    <trans_version/>
    <trans_type>Normal</trans_type>
    <trans_status>0</trans_status>
    <directory>/3_GC_DWH/OPTIMA</directory>
    <parameters>
    </parameters>
    <log>
      <trans-log-table>
        <connection/>
        <schema/>
        <table/>
        <size_limit_lines/>
        <interval/>
        <timeout_days/>
        <field>
          <id>ID_BATCH</id>
          <enabled>Y</enabled>
          <name>ID_BATCH</name>
        </field>
        <field>
          <id>CHANNEL_ID</id>
          <enabled>Y</enabled>
          <name>CHANNEL_ID</name>
        </field>
        <field>
          <id>TRANSNAME</id>
          <enabled>Y</enabled>
          <name>TRANSNAME</name>
        </field>
        <field>
          <id>STATUS</id>
          <enabled>Y</enabled>
          <name>STATUS</name>
        </field>
        <field>
          <id>LINES_READ</id>
          <enabled>Y</enabled>
          <name>LINES_READ</name>
          <subject/>
        </field>
        <field>
          <id>LINES_WRITTEN</id>
          <enabled>Y</enabled>
          <name>LINES_WRITTEN</name>
          <subject/>
        </field>
        <field>
          <id>LINES_UPDATED</id>
          <enabled>Y</enabled>
          <name>LINES_UPDATED</name>
          <subject/>
        </field>
        <field>
          <id>LINES_INPUT</id>
          <enabled>Y</enabled>
          <name>LINES_INPUT</name>
          <subject/>
        </field>
        <field>
          <id>LINES_OUTPUT</id>
          <enabled>Y</enabled>
          <name>LINES_OUTPUT</name>
          <subject/>
        </field>
        <field>
          <id>LINES_REJECTED</id>
          <enabled>Y</enabled>
          <name>LINES_REJECTED</name>
          <subject/>
        </field>
        <field>
          <id>ERRORS</id>
          <enabled>Y</enabled>
          <name>ERRORS</name>
        </field>
        <field>
          <id>STARTDATE</id>
          <enabled>Y</enabled>
          <name>STARTDATE</name>
        </field>
        <field>
          <id>ENDDATE</id>
          <enabled>Y</enabled>
          <name>ENDDATE</name>
        </field>
        <field>
          <id>LOGDATE</id>
          <enabled>Y</enabled>
          <name>LOGDATE</name>
        </field>
        <field>
          <id>DEPDATE</id>
          <enabled>Y</enabled>
          <name>DEPDATE</name>
        </field>
        <field>
          <id>REPLAYDATE</id>
          <enabled>Y</enabled>
          <name>REPLAYDATE</name>
        </field>
        <field>
          <id>LOG_FIELD</id>
          <enabled>Y</enabled>
          <name>LOG_FIELD</name>
        </field>
        <field>
          <id>EXECUTING_SERVER</id>
          <enabled>N</enabled>
          <name>EXECUTING_SERVER</name>
        </field>
        <field>
          <id>EXECUTING_USER</id>
          <enabled>N</enabled>
          <name>EXECUTING_USER</name>
        </field>
        <field>
          <id>CLIENT</id>
          <enabled>N</enabled>
          <name>CLIENT</name>
        </field>
      </trans-log-table>
      <perf-log-table>
        <connection/>
        <schema/>
        <table/>
        <interval/>
        <timeout_days/>
        <field>
          <id>ID_BATCH</id>
          <enabled>Y</enabled>
          <name>ID_BATCH</name>
        </field>
        <field>
          <id>SEQ_NR</id>
          <enabled>Y</enabled>
          <name>SEQ_NR</name>
        </field>
        <field>
          <id>LOGDATE</id>
          <enabled>Y</enabled>
          <name>LOGDATE</name>
        </field>
        <field>
          <id>TRANSNAME</id>
          <enabled>Y</enabled>
          <name>TRANSNAME</name>
        </field>
        <field>
          <id>STEPNAME</id>
          <enabled>Y</enabled>
          <name>STEPNAME</name>
        </field>
        <field>
          <id>STEP_COPY</id>
          <enabled>Y</enabled>
          <name>STEP_COPY</name>
        </field>
        <field>
          <id>LINES_READ</id>
          <enabled>Y</enabled>
          <name>LINES_READ</name>
        </field>
        <field>
          <id>LINES_WRITTEN</id>
          <enabled>Y</enabled>
          <name>LINES_WRITTEN</name>
        </field>
        <field>
          <id>LINES_UPDATED</id>
          <enabled>Y</enabled>
          <name>LINES_UPDATED</name>
        </field>
        <field>
          <id>LINES_INPUT</id>
          <enabled>Y</enabled>
          <name>LINES_INPUT</name>
        </field>
        <field>
          <id>LINES_OUTPUT</id>
          <enabled>Y</enabled>
          <name>LINES_OUTPUT</name>
        </field>
        <field>
          <id>LINES_REJECTED</id>
          <enabled>Y</enabled>
          <name>LINES_REJECTED</name>
        </field>
        <field>
          <id>ERRORS</id>
          <enabled>Y</enabled>
          <name>ERRORS</name>
        </field>
        <field>
          <id>INPUT_BUFFER_ROWS</id>
          <enabled>Y</enabled>
          <name>INPUT_BUFFER_ROWS</name>
        </field>
        <field>
          <id>OUTPUT_BUFFER_ROWS</id>
          <enabled>Y</enabled>
          <name>OUTPUT_BUFFER_ROWS</name>
        </field>
      </perf-log-table>
      <channel-log-table>
        <connection/>
        <schema/>
        <table/>
        <timeout_days/>
        <field>
          <id>ID_BATCH</id>
          <enabled>Y</enabled>
          <name>ID_BATCH</name>
        </field>
        <field>
          <id>CHANNEL_ID</id>
          <enabled>Y</enabled>
          <name>CHANNEL_ID</name>
        </field>
        <field>
          <id>LOG_DATE</id>
          <enabled>Y</enabled>
          <name>LOG_DATE</name>
        </field>
        <field>
          <id>LOGGING_OBJECT_TYPE</id>
          <enabled>Y</enabled>
          <name>LOGGING_OBJECT_TYPE</name>
        </field>
        <field>
          <id>OBJECT_NAME</id>
          <enabled>Y</enabled>
          <name>OBJECT_NAME</name>
        </field>
        <field>
          <id>OBJECT_COPY</id>
          <enabled>Y</enabled>
          <name>OBJECT_COPY</name>
        </field>
        <field>
          <id>REPOSITORY_DIRECTORY</id>
          <enabled>Y</enabled>
          <name>REPOSITORY_DIRECTORY</name>
        </field>
        <field>
          <id>FILENAME</id>
          <enabled>Y</enabled>
          <name>FILENAME</name>
        </field>
        <field>
          <id>OBJECT_ID</id>
          <enabled>Y</enabled>
          <name>OBJECT_ID</name>
        </field>
        <field>
          <id>OBJECT_REVISION</id>
          <enabled>Y</enabled>
          <name>OBJECT_REVISION</name>
        </field>
        <field>
          <id>PARENT_CHANNEL_ID</id>
          <enabled>Y</enabled>
          <name>PARENT_CHANNEL_ID</name>
        </field>
        <field>
          <id>ROOT_CHANNEL_ID</id>
          <enabled>Y</enabled>
          <name>ROOT_CHANNEL_ID</name>
        </field>
      </channel-log-table>
      <step-log-table>
        <connection/>
        <schema/>
        <table/>
        <timeout_days/>
        <field>
          <id>ID_BATCH</id>
          <enabled>Y</enabled>
          <name>ID_BATCH</name>
        </field>
        <field>
          <id>CHANNEL_ID</id>
          <enabled>Y</enabled>
          <name>CHANNEL_ID</name>
        </field>
        <field>
          <id>LOG_DATE</id>
          <enabled>Y</enabled>
          <name>LOG_DATE</name>
        </field>
        <field>
          <id>TRANSNAME</id>
          <enabled>Y</enabled>
          <name>TRANSNAME</name>
        </field>
        <field>
          <id>STEPNAME</id>
          <enabled>Y</enabled>
          <name>STEPNAME</name>
        </field>
        <field>
          <id>STEP_COPY</id>
          <enabled>Y</enabled>
          <name>STEP_COPY</name>
        </field>
        <field>
          <id>LINES_READ</id>
          <enabled>Y</enabled>
          <name>LINES_READ</name>
        </field>
        <field>
          <id>LINES_WRITTEN</id>
          <enabled>Y</enabled>
          <name>LINES_WRITTEN</name>
        </field>
        <field>
          <id>LINES_UPDATED</id>
          <enabled>Y</enabled>
          <name>LINES_UPDATED</name>
        </field>
        <field>
          <id>LINES_INPUT</id>
          <enabled>Y</enabled>
          <name>LINES_INPUT</name>
        </field>
        <field>
          <id>LINES_OUTPUT</id>
          <enabled>Y</enabled>
          <name>LINES_OUTPUT</name>
        </field>
        <field>
          <id>LINES_REJECTED</id>
          <enabled>Y</enabled>
          <name>LINES_REJECTED</name>
        </field>
        <field>
          <id>ERRORS</id>
          <enabled>Y</enabled>
          <name>ERRORS</name>
        </field>
        <field>
          <id>LOG_FIELD</id>
          <enabled>N</enabled>
          <name>LOG_FIELD</name>
        </field>
      </step-log-table>
      <metrics-log-table>
        <connection/>
        <schema/>
        <table/>
        <timeout_days/>
        <field>
          <id>ID_BATCH</id>
          <enabled>Y</enabled>
          <name>ID_BATCH</name>
        </field>
        <field>
          <id>CHANNEL_ID</id>
          <enabled>Y</enabled>
          <name>CHANNEL_ID</name>
        </field>
        <field>
          <id>LOG_DATE</id>
          <enabled>Y</enabled>
          <name>LOG_DATE</name>
        </field>
        <field>
          <id>METRICS_DATE</id>
          <enabled>Y</enabled>
          <name>METRICS_DATE</name>
        </field>
        <field>
          <id>METRICS_CODE</id>
          <enabled>Y</enabled>
          <name>METRICS_CODE</name>
        </field>
        <field>
          <id>METRICS_DESCRIPTION</id>
          <enabled>Y</enabled>
          <name>METRICS_DESCRIPTION</name>
        </field>
        <field>
          <id>METRICS_SUBJECT</id>
          <enabled>Y</enabled>
          <name>METRICS_SUBJECT</name>
        </field>
        <field>
          <id>METRICS_TYPE</id>
          <enabled>Y</enabled>
          <name>METRICS_TYPE</name>
        </field>
        <field>
          <id>METRICS_VALUE</id>
          <enabled>Y</enabled>
          <name>METRICS_VALUE</name>
        </field>
      </metrics-log-table>
    </log>
    <maxdate>
      <connection/>
      <table/>
      <field/>
      <offset>0.0</offset>
      <maxdiff>0.0</maxdiff>
    </maxdate>
    <size_rowset>5000</size_rowset>
    <sleep_time_empty>50</sleep_time_empty>
    <sleep_time_full>50</sleep_time_full>
    <unique_connections>N</unique_connections>
    <feedback_shown>Y</feedback_shown>
    <feedback_size>5000</feedback_size>
    <using_thread_priorities>Y</using_thread_priorities>
    <shared_objects_file/>
    <capture_step_performance>Y</capture_step_performance>
    <step_performance_capturing_delay>1000</step_performance_capturing_delay>
    <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>
    <dependencies>
    </dependencies>
    <partitionschemas>
    </partitionschemas>
    <slaveservers>
    </slaveservers>
    <clusterschemas>
    </clusterschemas>
    <created_user>-</created_user>
    <created_date>2024/07/17 12:24:15.448</created_date>
    <modified_user>-</modified_user>
    <modified_date>2024/10/10 14:14:15.819</modified_date>
    <key_for_session_key>H4sIAAAAAAAA/wMAAAAAAAAAAAA=</key_for_session_key>
    <is_key_private>N</is_key_private>
  </info>
  <notepads>
    <notepad>
      <note>Menge = 1 wird als zusätzliche Info 
an den Unit-History-Datensatz 
mit der niedrigsten LINE_NO gehängt</note>
      <xloc>512</xloc>
      <yloc>1024</yloc>
      <width>208</width>
      <heigth>58</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Hilfstabelle Transaction_Code bestimmt 
die Zuordnung der Zeilen zu Kennzahlen</note>
      <xloc>896</xloc>
      <yloc>1088</yloc>
      <width>223</width>
      <heigth>42</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Datensätze mit Transaction_Code/Kennzahl = "Steuer" werden herausgefiltert, 
damit das Feld "Betrag" der Netto-Summe entspricht.</note>
      <xloc>1280</xloc>
      <yloc>896</yloc>
      <width>422</width>
      <heigth>42</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Unit_File &lt;==> Unit_History    1 : n</note>
      <xloc>1856</xloc>
      <yloc>640</yloc>
      <width>192</width>
      <heigth>26</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>ECC_Status enscheidet über
Status verkauft / Bestand / Vorlauf</note>
      <xloc>256</xloc>
      <yloc>256</yloc>
      <width>189</width>
      <heigth>42</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Vehicle_Type wird verwendet,
um Autohaus-fremde Fahrzeuge 
als Fremdmarke ausblenden zu können</note>
      <xloc>384</xloc>
      <yloc>384</yloc>
      <width>216</width>
      <heigth>58</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Falls das Department mit Null oder Leer überschrieben wurde,
wird der letzte nicht-leere Eintrag aus dem Archiv genommen</note>
      <xloc>448</xloc>
      <yloc>512</yloc>
      <width>335</width>
      <heigth>42</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Übersetzung von Department auf Hauptbetrieb und Standort,
unabhängig von verwendetem Kontenrahmen!</note>
      <xloc>960</xloc>
      <yloc>640</yloc>
      <width>333</width>
      <heigth>42</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Übersetzung der Optima-Felder 
auf den DWH-Standard</note>
      <xloc>1920</xloc>
      <yloc>128</yloc>
      <width>180</width>
      <heigth>42</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Kennzahlen * Betrag</note>
      <xloc>1856</xloc>
      <yloc>896</yloc>
      <width>117</width>
      <heigth>26</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Verknüpfung zu Acct_Doc_Key über Acct_Doc_Relations
Felder UNIQUE_IDENT und ACCT_NO für weitere Verarbeitung
auf DWH-Ebene</note>
      <xloc>1280</xloc>
      <yloc>1152</yloc>
      <width>335</width>
      <heigth>58</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Abweichung zu bisheriger Logik:

Berechnung der Standtage und "Tage seit Verkauf"
auf Basis des jüngsten SALE_DATE und nicht
nach dem heutigen Zeitstempel "current_date" oder "getdate()"
</note>
      <xloc>1344</xloc>
      <yloc>64</yloc>
      <width>345</width>
      <heigth>104</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>205</backgroundcolorgreen>
      <backgroundcolorblue>112</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
    <notepad>
      <note>Menge bei Storno soll 0 sein, nicht 1</note>
      <xloc>448</xloc>
      <yloc>896</yloc>
      <width>201</width>
      <heigth>26</heigth>
      <fontname>Segoe UI</fontname>
      <fontsize>9</fontsize>
      <fontbold>N</fontbold>
      <fontitalic>N</fontitalic>
      <fontcolorred>0</fontcolorred>
      <fontcolorgreen>0</fontcolorgreen>
      <fontcolorblue>0</fontcolorblue>
      <backgroundcolorred>255</backgroundcolorred>
      <backgroundcolorgreen>128</backgroundcolorgreen>
      <backgroundcolorblue>64</backgroundcolorblue>
      <bordercolorred>100</bordercolorred>
      <bordercolorgreen>100</bordercolorgreen>
      <bordercolorblue>100</bordercolorblue>
      <drawshadow>Y</drawshadow>
    </notepad>
  </notepads>
  <connection>
    <name>GC_CONFIG</name>
    <server>192.168.2.43</server>
    <type>MSSQL</type>
    <access>Native</access>
    <database>GC_CONFIG</database>
    <port>1433</port>
    <username>sa</username>
    <password>Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99</password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
      <attribute>
        <code>EXTRA_OPTION_MSSQL.instance</code>
        <attribute>GLOBALCUBE</attribute>
      </attribute>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>IS_CLUSTERED</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>PORT_NUMBER</code>
        <attribute>1433</attribute>
      </attribute>
      <attribute>
        <code>PRESERVE_RESERVED_WORD_CASE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>QUOTE_ALL_FIELDS</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>USE_POOLING</code>
        <attribute>N</attribute>
      </attribute>
    </attributes>
  </connection>
  <connection>
    <name>GC_STAGING_OPTIMA</name>
    <server>192.168.2.43</server>
    <type>MSSQL</type>
    <access>Native</access>
    <database>GC_STAGING_OPTIMA</database>
    <port>1433</port>
    <username>sa</username>
    <password>Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99</password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
      <attribute>
        <code>EXTRA_OPTION_MSSQL.instance</code>
        <attribute>GLOBALCUBE</attribute>
      </attribute>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>IS_CLUSTERED</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>PORT_NUMBER</code>
        <attribute>1433</attribute>
      </attribute>
      <attribute>
        <code>PRESERVE_RESERVED_WORD_CASE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>QUOTE_ALL_FIELDS</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>USE_POOLING</code>
        <attribute>N</attribute>
      </attribute>
    </attributes>
  </connection>
  <connection>
    <name>OPTIMA</name>
    <server>192.168.2.43</server>
    <type>MSSQL</type>
    <access>Native</access>
    <database>OPTIMA</database>
    <port>1433</port>
    <username>sa</username>
    <password>Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99</password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
      <attribute>
        <code>EXTRA_OPTION_MSSQL.instance</code>
        <attribute>GLOBALCUBE</attribute>
      </attribute>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>IS_CLUSTERED</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>PORT_NUMBER</code>
        <attribute>1433</attribute>
      </attribute>
      <attribute>
        <code>PRESERVE_RESERVED_WORD_CASE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>QUOTE_ALL_FIELDS</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>USE_POOLING</code>
        <attribute>N</attribute>
      </attribute>
    </attributes>
  </connection>
  <order>
    <hop>
      <from>extract.UNIT_HISTORY</from>
      <to>Unit_History_Strings</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>extract.UNIT_FILE</from>
      <to>Unit_File_Strings</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>GC_CONFIG.optima.ECC_Status</from>
      <to>ECC_Status</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_File_Strings</from>
      <to>Unit_File_ECC_Status</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>ECC_Status</from>
      <to>Unit_File_ECC_Status</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>extract.UNIT_CHANGE_HIST_Department</from>
      <to>Unit_Change_Hist_Department_sortiert</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>GC_CONFIG.optima.Vehicle_Type</from>
      <to>Vehicle_Type</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_File_ECC_Status</from>
      <to>Unit_File_Vehicle_Type</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Vehicle_Type</from>
      <to>Unit_File_Vehicle_Type</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_File_Vehicle_Type</from>
      <to>Unit_File_Department</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_Change_Hist_Department_sortiert</from>
      <to>Unit_File_Department</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_Change_Hist_Department_sortiert</from>
      <to>Unit_File_Department</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>GC_CONFIG.optima.Department</from>
      <to>Department_sortiert</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Department</from>
      <to>Department_Details</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Department_sortiert</from>
      <to>Department_Details</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Verkauf_Auswahl_Übersetzung</from>
      <to>GC_DWH.dbo.Verkauf</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>GC_DWH.dbo.Verkauf</from>
      <to>Write to log</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Strings</from>
      <to>Unit_History_Menge</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Menge</from>
      <to>Unit_History_Transaction_Code</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>extract.UNIT_HISTORY_Menge</from>
      <to>Unit_History_Menge_bereinigt</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Menge_bereinigt</from>
      <to>Unit_History_Menge</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>GC_CONFIG.optima.Transaction_Code</from>
      <to>Transaction_Code</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Transaction_Code</from>
      <to>Unit_History_Transaction_Code</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Filter_Steuern</from>
      <to>Unit_History_Kennzahlen</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Kennzahlen</from>
      <to>Unit_File_Unit_History</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Einkauf_Verkauf_Datum</from>
      <to>Unit_File_Unit_History</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_File_Unit_History</from>
      <to>Verkauf_Auswahl_Übersetzung</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Department_Details</from>
      <to>Get variables</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_File_max_Sale_Date</from>
      <to>Set variables</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Get variables</from>
      <to>Einkauf_Verkauf_Datum</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>extract.ACCT_DOC_UNIT_HISTORY</from>
      <to>Acct_Doc_Unit_History_bereinigt</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Transaction_Code</from>
      <to>Unit_History_Acct_Doc</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Acct_Doc</from>
      <to>Unit_History_Filter_Steuern</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Acct_Doc_Unit_History_bereinigt</from>
      <to>Unit_History_Acct_Doc</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_File_Department</from>
      <to>Department</to>
      <enabled>Y</enabled>
    </hop>
  </order>
  <step>
    <name>Acct_Doc_Unit_History_bereinigt</name>
    <type>StringOperations</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <in_stream_name>UNIT_NUMBER</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>upper</lower_upper>
        <padding_type/>
        <pad_char/>
        <pad_len/>
        <init_cap/>
        <mask_xml/>
        <digits/>
        <remove_special_characters/>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1216</xloc>
      <yloc>1344</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Department</name>
    <type>Formula</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <formula>
      <field_name>Department</field_name>
      <formula_string>IF ( OR( ISNA( [SALES_DEPARTMENT] ) ; [SALES_DEPARTMENT] = "" ) ; [DEPARTMENT_1]; [SALES_DEPARTMENT] )</formula_string>
      <value_type>String</value_type>
      <value_length>-1</value_length>
      <value_precision>-1</value_precision>
      <replace_field/>
    </formula>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1024</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Department_Details</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Department_sortiert</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>CLIENT_DB</name>
        <field>CLIENT_DB</field>
      </key>
      <key>
        <name>SALES_DEPARTMENT</name>
        <field>SALES_DEPARTMENT</field>
      </key>
      <value>
        <name>Hauptbetrieb_ID</name>
        <rename>Hauptbetrieb_ID</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Standort_ID</name>
        <rename>Standort_ID</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Marke_ID</name>
        <rename>Marke_ID</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Kostenstelle_ID</name>
        <rename>Kostenstelle_ID</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1216</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Department_sortiert</name>
    <type>Dummy</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1216</xloc>
      <yloc>704</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>ECC_Status</name>
    <type>Dummy</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>448</xloc>
      <yloc>320</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Einkauf_Verkauf_Datum</name>
    <type>ScriptValueMod</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <compatible>N</compatible>
    <optimizationLevel>9</optimizationLevel>
    <jsScripts>
      <jsScript>
        <jsScript_type>0</jsScript_type>
        <jsScript_name>Script 1</jsScript_name>
        <jsScript_script>
var Einkauf_Datum = (RECEPTION_DATE == null) ? PURCH_DATE : RECEPTION_DATE;
var Verkauf_Datum = (SALE_DATE == null) ? Datum : SALE_DATE;


var Tage_seit_Verkauf = dateDiff(Verkauf_Datum, Datum, "d");
var Standtage = dateDiff(Einkauf_Datum, Verkauf_Datum, "d");</jsScript_script>
      </jsScript>
    </jsScripts>
    <fields>
      <field>
        <name>Tage_seit_Verkauf</name>
        <rename>Tage_seit_Verkauf</rename>
        <type>Integer</type>
        <length>16</length>
        <precision>-1</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Standtage</name>
        <rename>Standtage</rename>
        <type>Integer</type>
        <length>16</length>
        <precision>-1</precision>
        <replace>N</replace>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1600</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>GC_CONFIG.optima.Department</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>GC_CONFIG</connection>
    <sql>SELECT * FROM optima.Department</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>SALES_DEPARTMENT</name>
        <length>4</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>SALES_DEPARTMENT</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>NEW_DEPARTMENT</name>
        <length>4</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>NEW_DEPARTMENT</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>DESCRIPTION</name>
        <length>50</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>DESCRIPTION</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>DEPARTMENT_TYPE_ID</name>
        <length>4</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>DEPARTMENT_TYPE_ID</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>DEPARTMENT_DESC</name>
        <length>50</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>DEPARTMENT_DESC</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>DEPARTMENT_GROUP</name>
        <length>2</length>
        <precision>0</precision>
        <origin>Table input</origin>
        <comments>DEPARTMENT_GROUP</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>SITE_ID</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>SITE_ID</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>SITE_DESC</name>
        <length>30</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>SITE_DESC</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>STRATEGIC_AREA_ID</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>STRATEGIC_AREA_ID</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>STRATEGIC_AREA_DESC</name>
        <length>30</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>STRATEGIC_AREA_DESC</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>SKR51</name>
        <length>9</length>
        <precision>0</precision>
        <origin>Table input</origin>
        <comments>SKR51</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Hauptbetrieb_ID</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>Hauptbetrieb_ID</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Standort_ID</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>Standort_ID</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Marke_ID</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>Marke_ID</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Kostenstelle_ID</name>
        <length>4</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>Kostenstelle_ID</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>128</xloc>
      <yloc>704</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>GC_CONFIG.optima.ECC_Status</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>GC_CONFIG</connection>
    <sql>SELECT *
FROM [optima].[ECC_Status]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Vehicle_Type 2</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>ECC_STATUS</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Vehicle_Type 2</origin>
        <comments>ECC_STATUS</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>SPECIFY</name>
        <length>50</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Vehicle_Type 2</origin>
        <comments>SPECIFY</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Bereich</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Vehicle_Type 2</origin>
        <comments>Bereich</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Auftragsstatus</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Vehicle_Type 2</origin>
        <comments>Auftragsstatus</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Fahrzeugstatus</name>
        <length>100</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Vehicle_Type 2</origin>
        <comments>Fahrzeugstatus</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Binary</type>
        <storagetype>normal</storagetype>
        <name>timestamp</name>
        <length>-1</length>
        <precision>0</precision>
        <origin>GC_CONFIG.optima.Vehicle_Type 2</origin>
        <comments>timestamp</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>128</xloc>
      <yloc>320</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>GC_CONFIG.optima.Transaction_Code</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>GC_CONFIG</connection>
    <sql>SELECT *
FROM [optima].[Transaction_Code]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Transaction_Code</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>TRANSACTION_CODE</name>
        <length>12</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Transaction_Code</origin>
        <comments>TRANSACTION_CODE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>SPECIFY</name>
        <length>50</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Transaction_Code</origin>
        <comments>SPECIFY</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>TRANSFER_CODE</name>
        <length>2</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Transaction_Code</origin>
        <comments>TRANSFER_CODE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Umsatz_Einsatz</name>
        <length>7</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Transaction_Code</origin>
        <comments>Umsatz_Einsatz</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Kennzahl</name>
        <length>13</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Transaction_Code</origin>
        <comments>Kennzahl</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Kennzahl2</name>
        <length>9</length>
        <precision>-1</precision>
        <origin>GC_CONFIG.optima.Transaction_Code</origin>
        <comments>Kennzahl2</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>128</xloc>
      <yloc>1216</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>GC_CONFIG.optima.Vehicle_Type</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>GC_CONFIG</connection>
    <sql>SELECT *
FROM [optima].[Vehicle_Type]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE 2</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>VEHICLE_TYPE</name>
        <length>2</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE 2</origin>
        <comments>VEHICLE_TYPE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>VEHICLE_TYPE_TEXT</name>
        <length>30</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE 2</origin>
        <comments>VEHICLE_TYPE_TEXT</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Fahrzeugart</name>
        <length>14</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE 2</origin>
        <comments>Fahrzeugart</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>Fahrzeugtyp</name>
        <length>35</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE 2</origin>
        <comments>Fahrzeugtyp</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>128</xloc>
      <yloc>448</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>GC_DWH.dbo.Verkauf</name>
    <type>TableOutput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>GC_STAGING_OPTIMA</connection>
    <schema>dbo</schema>
    <table>tbl_Verkauf</table>
    <commit>5000</commit>
    <truncate>Y</truncate>
    <ignore_errors>N</ignore_errors>
    <use_batch>Y</use_batch>
    <specify_fields>Y</specify_fields>
    <partitioning_enabled>N</partitioning_enabled>
    <partitioning_field/>
    <partitioning_daily>N</partitioning_daily>
    <partitioning_monthly>Y</partitioning_monthly>
    <tablename_in_field>N</tablename_in_field>
    <tablename_field/>
    <tablename_in_table>Y</tablename_in_table>
    <return_keys>N</return_keys>
    <return_field/>
    <fields>
      <field>
        <column_name>CLIENT_DB</column_name>
        <stream_name>CLIENT_DB</stream_name>
      </field>
      <field>
        <column_name>FZG-Nr</column_name>
        <stream_name>FZG-Nr</stream_name>
      </field>
      <field>
        <column_name>BASIS_NUMBER</column_name>
        <stream_name>BASIS_NUMBER</stream_name>
      </field>
      <field>
        <column_name>ECC_STATUS</column_name>
        <stream_name>ECC_STATUS</stream_name>
      </field>
      <field>
        <column_name>VEHICLE_TYPE</column_name>
        <stream_name>VEHICLE_TYPE</stream_name>
      </field>
      <field>
        <column_name>Rg.-Datum</column_name>
        <stream_name>Rg.-Datum</stream_name>
      </field>
      <field>
        <column_name>RECEPTION_DATE</column_name>
        <stream_name>RECEPTION_DATE</stream_name>
      </field>
      <field>
        <column_name>PURCH_DATE</column_name>
        <stream_name>PURCH_DATE</stream_name>
      </field>
      <field>
        <column_name>PREV_OWNER</column_name>
        <stream_name>PREV_OWNER</stream_name>
      </field>
      <field>
        <column_name>ACCOUNT_SALES</column_name>
        <stream_name>ACCOUNT_SALES</stream_name>
      </field>
      <field>
        <column_name>SALES_DEPARTMENT</column_name>
        <stream_name>SALES_DEPARTMENT</stream_name>
      </field>
      <field>
        <column_name>SALE_SALESMAN</column_name>
        <stream_name>SALE_SALESMAN</stream_name>
      </field>
      <field>
        <column_name>PURCH_SALSMAN_CODE</column_name>
        <stream_name>PURCH_SALSMAN_CODE</stream_name>
      </field>
      <field>
        <column_name>SPECIFY</column_name>
        <stream_name>SPECIFY</stream_name>
      </field>
      <field>
        <column_name>Bereich</column_name>
        <stream_name>Bereich</stream_name>
      </field>
      <field>
        <column_name>Auftragsstatus</column_name>
        <stream_name>Auftragsstatus</stream_name>
      </field>
      <field>
        <column_name>Fahrzeugstatus</column_name>
        <stream_name>Fahrzeugstatus</stream_name>
      </field>
      <field>
        <column_name>timestamp</column_name>
        <stream_name>timestamp</stream_name>
      </field>
      <field>
        <column_name>VEHICLE_TYPE_TEXT</column_name>
        <stream_name>VEHICLE_TYPE_TEXT</stream_name>
      </field>
      <field>
        <column_name>FZG-Art</column_name>
        <stream_name>FZG-Art</stream_name>
      </field>
      <field>
        <column_name>FZG-Typ</column_name>
        <stream_name>FZG-Typ</stream_name>
      </field>
      <field>
        <column_name>Department</column_name>
        <stream_name>Department</stream_name>
      </field>
      <field>
        <column_name>Hauptbetrieb_ID</column_name>
        <stream_name>Hauptbetrieb_ID</stream_name>
      </field>
      <field>
        <column_name>Standort_ID</column_name>
        <stream_name>Standort_ID</stream_name>
      </field>
      <field>
        <column_name>Marke_ID</column_name>
        <stream_name>Marke_ID</stream_name>
      </field>
      <field>
        <column_name>KST-ID</column_name>
        <stream_name>KST-ID</stream_name>
      </field>
      <field>
        <column_name>Datum</column_name>
        <stream_name>Datum</stream_name>
      </field>
      <field>
        <column_name>Tage_seit_Verkauf</column_name>
        <stream_name>Tage_seit_Verkauf</stream_name>
      </field>
      <field>
        <column_name>Standtage</column_name>
        <stream_name>Standtage</stream_name>
      </field>
      <field>
        <column_name>LINE_NO</column_name>
        <stream_name>LINE_NO</stream_name>
      </field>
      <field>
        <column_name>Rg.-Nr</column_name>
        <stream_name>Rg.-Nr</stream_name>
      </field>
      <field>
        <column_name>LINE_TYPE</column_name>
        <stream_name>LINE_TYPE</stream_name>
      </field>
      <field>
        <column_name>TRANSACTION_CODE</column_name>
        <stream_name>TRANSACTION_CODE</stream_name>
      </field>
      <field>
        <column_name>REFERENCE</column_name>
        <stream_name>REFERENCE</stream_name>
      </field>
      <field>
        <column_name>ORDERS_GROSSVALUE</column_name>
        <stream_name>ORDERS_GROSSVALUE</stream_name>
      </field>
      <field>
        <column_name>UNIQUE_IDENT</column_name>
        <stream_name>UNIQUE_IDENT</stream_name>
      </field>
      <field>
        <column_name>Menge</column_name>
        <stream_name>Menge</stream_name>
      </field>
      <field>
        <column_name>SPECIFY_1</column_name>
        <stream_name>SPECIFY_1</stream_name>
      </field>
      <field>
        <column_name>TRANSFER_CODE</column_name>
        <stream_name>TRANSFER_CODE</stream_name>
      </field>
      <field>
        <column_name>Umsatz_Einsatz</column_name>
        <stream_name>Umsatz_Einsatz</stream_name>
      </field>
      <field>
        <column_name>Kennzahl</column_name>
        <stream_name>Kennzahl</stream_name>
      </field>
      <field>
        <column_name>Kennzahl2</column_name>
        <stream_name>Kennzahl2</stream_name>
      </field>
      <field>
        <column_name>UNIQUE_IDENT_ACCT_DOC_KEY</column_name>
        <stream_name>UNIQUE_IDENT_ACCT_DOC_KEY</stream_name>
      </field>
      <field>
        <column_name>ACCT_NO</column_name>
        <stream_name>ACCT_NO</stream_name>
      </field>
      <field>
        <column_name>Faktor</column_name>
        <stream_name>Faktor</stream_name>
      </field>
      <field>
        <column_name>Betrag</column_name>
        <stream_name>Betrag</stream_name>
      </field>
      <field>
        <column_name>EK-FZG</column_name>
        <stream_name>EK-FZG</stream_name>
      </field>
      <field>
        <column_name>Erlös</column_name>
        <stream_name>Erlös</stream_name>
      </field>
      <field>
        <column_name>FZG-Kosten</column_name>
        <stream_name>FZG-Kosten</stream_name>
      </field>
      <field>
        <column_name>Nachlass</column_name>
        <stream_name>Nachlass</stream_name>
      </field>
      <field>
        <column_name>Provisionen</column_name>
        <stream_name>Provisionen</stream_name>
      </field>
      <field>
        <column_name>Sonst. Erlöse</column_name>
        <stream_name>Sonst. Erlöse</stream_name>
      </field>
      <field>
        <column_name>Ums. Fracht</column_name>
        <stream_name>Ums. Fracht</stream_name>
      </field>
      <field>
        <column_name>VK-Hilfen</column_name>
        <stream_name>VK-Hilfen</stream_name>
      </field>
      <field>
        <column_name>Rest</column_name>
        <stream_name>Rest</stream_name>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>2176</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Get variables</name>
    <type>GetVariable</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <name>Datum</name>
        <variable>${DATUM}</variable>
        <type>Timestamp</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <trim_type>none</trim_type>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1408</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Set variables</name>
    <type>SetVariable</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <field_name>Datum</field_name>
        <variable_name>DATUM</variable_name>
        <variable_type>ROOT_JOB</variable_type>
        <default_value/>
      </field>
    </fields>
    <use_formatting>Y</use_formatting>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>256</xloc>
      <yloc>64</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Transaction_Code</name>
    <type>Dummy</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>832</xloc>
      <yloc>1216</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_Change_Hist_Department_sortiert</name>
    <type>Dummy</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>832</xloc>
      <yloc>576</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_File_Department</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Unit_Change_Hist_Department_sortiert</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>CLIENT_DB</name>
        <field>CLIENT_DB</field>
      </key>
      <key>
        <name>UNIT_NUMBER</name>
        <field>UNIT_NUMBER</field>
      </key>
      <value>
        <name>DEPARTMENT</name>
        <rename>DEPARTMENT</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>832</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_File_ECC_Status</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>ECC_Status</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>CLIENT_DB</name>
        <field>CLIENT_DB</field>
      </key>
      <key>
        <name>ECC_STATUS</name>
        <field>ECC_STATUS</field>
      </key>
      <value>
        <name>SPECIFY</name>
        <rename>SPECIFY</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Bereich</name>
        <rename>Bereich</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Auftragsstatus</name>
        <rename>Auftragsstatus</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Fahrzeugstatus</name>
        <rename>Fahrzeugstatus</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>timestamp</name>
        <rename>timestamp</rename>
        <default/>
        <type>Binary</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>448</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_File_Strings</name>
    <type>StringOperations</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <in_stream_name>UNIT_NUMBER</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>upper</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>BASIS_NUMBER</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>ECC_STATUS</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>VEHICLE_TYPE</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>PREV_OWNER</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>ACCOUNT_SALES</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>SALES_DEPARTMENT</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>SALE_SALESMAN</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>PURCH_SALSMAN_CODE</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>256</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_File_Unit_History</name>
    <type>MergeJoin</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <join_type>LEFT OUTER</join_type>
    <step1>Einkauf_Verkauf_Datum</step1>
    <step2>Unit_History_Kennzahlen</step2>
    <keys_1>
      <key>CLIENT_DB</key>
      <key>UNIT_NUMBER</key>
    </keys_1>
    <keys_2>
      <key>CLIENT_DB</key>
      <key>UNIT_NUMBER</key>
    </keys_2>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1792</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_File_Vehicle_Type</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Vehicle_Type</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>CLIENT_DB</name>
        <field>CLIENT_DB</field>
      </key>
      <key>
        <name>VEHICLE_TYPE</name>
        <field>VEHICLE_TYPE</field>
      </key>
      <value>
        <name>VEHICLE_TYPE_TEXT</name>
        <rename>VEHICLE_TYPE_TEXT</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Fahrzeugart</name>
        <rename>Fahrzeugart</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Fahrzeugtyp</name>
        <rename>Fahrzeugtyp</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>640</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_File_max_Sale_Date</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>OPTIMA</connection>
    <sql>SELECT max([SALE_DATE]) AS [Datum]
FROM [import].[UNIT_FILE]
WHERE [SALE_DATE] &lt;= getdate()</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>Timestamp</type>
        <storagetype>normal</storagetype>
        <name>Datum</name>
        <length>3</length>
        <precision>-1</precision>
        <origin>Max_Sale_Date</origin>
        <comments>Datum</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>64</xloc>
      <yloc>64</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Acct_Doc</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Acct_Doc_Unit_History_bereinigt</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>CLIENT_DB</name>
        <field>CLIENT_DB</field>
      </key>
      <key>
        <name>UNIT_NUMBER</name>
        <field>UNIT_NUMBER</field>
      </key>
      <key>
        <name>LINE_NO</name>
        <field>LINE_NO</field>
      </key>
      <key>
        <name>UNIQUE_IDENT</name>
        <field>UNIQUE_IDENT_UNIT_HISTORY</field>
      </key>
      <value>
        <name>UNIQUE_IDENT_ACCT_DOC_KEY</name>
        <rename>UNIQUE_IDENT_ACCT_DOC_KEY</rename>
        <default/>
        <type>Integer</type>
      </value>
      <value>
        <name>ACCT_NO</name>
        <rename>ACCT_NO</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1216</xloc>
      <yloc>960</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Filter_Steuern</name>
    <type>FilterRows</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <send_true_to>Unit_History_Kennzahlen</send_true_to>
    <send_false_to/>
    <compare>
      <condition>
        <negated>N</negated>
        <leftvalue>Umsatz_Einsatz</leftvalue>
        <function>&lt;></function>
        <rightvalue/>
        <value>
          <name>constant</name>
          <type>String</type>
          <text>Steuer</text>
          <length>-1</length>
          <precision>-1</precision>
          <isnull>N</isnull>
          <mask/>
        </value>
      </condition>
    </compare>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1600</xloc>
      <yloc>960</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Kennzahlen</name>
    <type>ScriptValueMod</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <compatible>N</compatible>
    <optimizationLevel>9</optimizationLevel>
    <jsScripts>
      <jsScript>
        <jsScript_type>0</jsScript_type>
        <jsScript_name>Script 1</jsScript_name>
        <jsScript_script>// Vorzeichen bei Umsätzen drehen
var Faktor = (Umsatz_Einsatz == "Umsatz") ? -1 : 1;
var Betrag = ORDERS_GROSSVALUE * Faktor;

// Kennzahl eindeutige Zuordnung über Transaction_Code
var EK_Fahrzeug   = (Kennzahl == "EK_Fahrzeug")   ? Betrag : 0;
var Erloes        = (Kennzahl == "Erloes")        ? Betrag : 0;
var FZG_Kosten    = (Kennzahl == "FZG_Kosten")    ? Betrag : 0;
var Nachlass      = (Kennzahl == "Nachlass")      ? Betrag : 0;
var Provisionen   = (Kennzahl == "Provisionen")   ? Betrag : 0;
var Sonst_Erloese = (Kennzahl == "Sonst_Erloese") ? Betrag : 0;
var Ums_Fracht    = (Kennzahl == "Ums_Fracht")    ? Betrag : 0;

// Kennzahl2 - bisher nur VK-Hilfen
var VK_Hilfen = (Kennzahl2 == "VK_Hilfen") ? Betrag : 0;

// falls kein Transaction_Code definiert ist.
var Rest = (Kennzahl == "Rest") ? Betrag : 0;
</jsScript_script>
      </jsScript>
    </jsScripts>
    <fields>
      <field>
        <name>Faktor</name>
        <rename>Faktor</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Betrag</name>
        <rename>Betrag</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>EK_Fahrzeug</name>
        <rename>EK_Fahrzeug</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Erloes</name>
        <rename>Erloes</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>FZG_Kosten</name>
        <rename>FZG_Kosten</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Nachlass</name>
        <rename>Nachlass</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Provisionen</name>
        <rename>Provisionen</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Sonst_Erloese</name>
        <rename>Sonst_Erloese</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Ums_Fracht</name>
        <rename>Ums_Fracht</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>VK_Hilfen</name>
        <rename>VK_Hilfen</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
      <field>
        <name>Rest</name>
        <rename>Rest</rename>
        <type>Number</type>
        <length>16</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1792</xloc>
      <yloc>960</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Menge</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Unit_History_Menge_bereinigt</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>CLIENT_DB</name>
        <field>CLIENT_DB</field>
      </key>
      <key>
        <name>UNIT_NUMBER</name>
        <field>UNIT_NUMBER</field>
      </key>
      <key>
        <name>UNIQUE_IDENT</name>
        <field>UNIQUE_IDENT</field>
      </key>
      <value>
        <name>Menge</name>
        <rename>Menge</rename>
        <default>0</default>
        <type>Number</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>448</xloc>
      <yloc>960</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Menge_bereinigt</name>
    <type>StringOperations</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <in_stream_name>UNIT_NUMBER</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>upper</lower_upper>
        <padding_type/>
        <pad_char/>
        <pad_len/>
        <init_cap/>
        <mask_xml/>
        <digits/>
        <remove_special_characters/>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>448</xloc>
      <yloc>1088</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Strings</name>
    <type>StringOperations</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <in_stream_name>UNIT_NUMBER</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>upper</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>DOCUMENT_NR</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>LINE_TYPE</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>TRANSACTION_CODE</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
      <field>
        <in_stream_name>REFERENCE</in_stream_name>
        <out_stream_name/>
        <trim_type>both</trim_type>
        <lower_upper>none</lower_upper>
        <padding_type>none</padding_type>
        <pad_char/>
        <pad_len/>
        <init_cap>N</init_cap>
        <mask_xml>None</mask_xml>
        <digits>none</digits>
        <remove_special_characters>none</remove_special_characters>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>256</xloc>
      <yloc>960</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Transaction_Code</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>Transaction_Code</from>
    <input_sorted>N</input_sorted>
    <preserve_memory>Y</preserve_memory>
    <sorted_list>N</sorted_list>
    <integer_pair>N</integer_pair>
    <lookup>
      <key>
        <name>CLIENT_DB</name>
        <field>CLIENT_DB</field>
      </key>
      <key>
        <name>TRANSACTION_CODE</name>
        <field>TRANSACTION_CODE</field>
      </key>
      <value>
        <name>SPECIFY</name>
        <rename>SPECIFY</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>TRANSFER_CODE</name>
        <rename>TRANSFER_CODE</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Umsatz_Einsatz</name>
        <rename>Umsatz_Einsatz</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Kennzahl</name>
        <rename>Kennzahl</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>Kennzahl2</name>
        <rename>Kennzahl2</rename>
        <default/>
        <type>String</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>832</xloc>
      <yloc>960</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Vehicle_Type</name>
    <type>Dummy</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>640</xloc>
      <yloc>448</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Verkauf_Auswahl_Übersetzung</name>
    <type>SelectValues</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <select_unspecified>N</select_unspecified>
      <remove>
        <name>DEPARTMENT_1</name>
      </remove>
      <remove>
        <name>CLIENT_DB_1</name>
      </remove>
      <remove>
        <name>UNIT_NUMBER_1</name>
      </remove>
      <meta>
        <name>CLIENT_DB</name>
        <rename>CLIENT_DB</rename>
        <type>None</type>
        <length>20</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>UNIT_NUMBER</name>
        <rename>FZG-Nr</rename>
        <type>None</type>
        <length>10</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>BASIS_NUMBER</name>
        <rename>BASIS_NUMBER</rename>
        <type>None</type>
        <length>20</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>ECC_STATUS</name>
        <rename>ECC_STATUS</rename>
        <type>None</type>
        <length>2</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>VEHICLE_TYPE</name>
        <rename>VEHICLE_TYPE</rename>
        <type>None</type>
        <length>1</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>SALE_DATE</name>
        <rename>Rg.-Datum</rename>
        <type>None</type>
        <length>3</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>RECEPTION_DATE</name>
        <rename>RECEPTION_DATE</rename>
        <type>None</type>
        <length>3</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>PURCH_DATE</name>
        <rename>PURCH_DATE</rename>
        <type>None</type>
        <length>3</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>PREV_OWNER</name>
        <rename>PREV_OWNER</rename>
        <type>None</type>
        <length>60</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>ACCOUNT_SALES</name>
        <rename>ACCOUNT_SALES</rename>
        <type>None</type>
        <length>10</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>SALES_DEPARTMENT</name>
        <rename>SALES_DEPARTMENT</rename>
        <type>None</type>
        <length>4</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>SALE_SALESMAN</name>
        <rename>SALE_SALESMAN</rename>
        <type>None</type>
        <length>20</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>PURCH_SALSMAN_CODE</name>
        <rename>PURCH_SALSMAN_CODE</rename>
        <type>None</type>
        <length>20</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>SPECIFY</name>
        <rename>SPECIFY</rename>
        <type>None</type>
        <length>50</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Bereich</name>
        <rename>Bereich</rename>
        <type>None</type>
        <length>10</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Auftragsstatus</name>
        <rename>Auftragsstatus</rename>
        <type>None</type>
        <length>20</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Fahrzeugstatus</name>
        <rename>Fahrzeugstatus</rename>
        <type>None</type>
        <length>100</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>timestamp</name>
        <rename>timestamp</rename>
        <type>None</type>
        <length>-2</length>
        <precision>0</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>VEHICLE_TYPE_TEXT</name>
        <rename>VEHICLE_TYPE_TEXT</rename>
        <type>None</type>
        <length>30</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Fahrzeugart</name>
        <rename>FZG-Art</rename>
        <type>None</type>
        <length>14</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Fahrzeugtyp</name>
        <rename>FZG-Typ</rename>
        <type>None</type>
        <length>35</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Department</name>
        <rename>Department</rename>
        <type>None</type>
        <length>-2</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Hauptbetrieb_ID</name>
        <rename>Hauptbetrieb_ID</rename>
        <type>None</type>
        <length>20</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Standort_ID</name>
        <rename>Standort_ID</rename>
        <type>None</type>
        <length>10</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Marke_ID</name>
        <rename>Marke_ID</rename>
        <type>None</type>
        <length>10</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Kostenstelle_ID</name>
        <rename>KST-ID</rename>
        <type>None</type>
        <length>4</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>LINE_NO</name>
        <rename>LINE_NO</rename>
        <type>None</type>
        <length>4</length>
        <precision>0</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>DOCUMENT_NR</name>
        <rename>Rg.-Nr</rename>
        <type>None</type>
        <length>20</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>LINE_TYPE</name>
        <rename>LINE_TYPE</rename>
        <type>None</type>
        <length>2</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>TRANSACTION_CODE</name>
        <rename>TRANSACTION_CODE</rename>
        <type>None</type>
        <length>3</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>REFERENCE</name>
        <rename>REFERENCE</rename>
        <type>None</type>
        <length>255</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>ORDERS_GROSSVALUE</name>
        <rename>ORDERS_GROSSVALUE</rename>
        <type>None</type>
        <length>15</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>UNIQUE_IDENT</name>
        <rename>UNIQUE_IDENT</rename>
        <type>None</type>
        <length>12</length>
        <precision>0</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Menge</name>
        <rename>Menge</rename>
        <type>None</type>
        <length>2</length>
        <precision>1</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>SPECIFY_1</name>
        <rename>SPECIFY_1</rename>
        <type>None</type>
        <length>50</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>TRANSFER_CODE</name>
        <rename>TRANSFER_CODE</rename>
        <type>None</type>
        <length>2</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Umsatz_Einsatz</name>
        <rename>Umsatz_Einsatz</rename>
        <type>None</type>
        <length>7</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Kennzahl</name>
        <rename>Kennzahl</rename>
        <type>None</type>
        <length>13</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Kennzahl2</name>
        <rename>Kennzahl2</rename>
        <type>None</type>
        <length>9</length>
        <precision>-2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Faktor</name>
        <rename>Faktor</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Betrag</name>
        <rename>Betrag</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>EK_Fahrzeug</name>
        <rename>EK-FZG</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Erloes</name>
        <rename>Erlös</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>FZG_Kosten</name>
        <rename>FZG-Kosten</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Nachlass</name>
        <rename>Nachlass</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Provisionen</name>
        <rename>Provisionen</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Sonst_Erloese</name>
        <rename>Sonst. Erlöse</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Ums_Fracht</name>
        <rename>Ums. Fracht</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>VK_Hilfen</name>
        <rename>VK-Hilfen</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
      <meta>
        <name>Rest</name>
        <rename>Rest</rename>
        <type>None</type>
        <length>16</length>
        <precision>2</precision>
        <conversion_mask/>
        <date_format_lenient>false</date_format_lenient>
        <date_format_locale/>
        <date_format_timezone/>
        <lenient_string_to_number>false</lenient_string_to_number>
        <encoding/>
        <decimal_symbol/>
        <grouping_symbol/>
        <currency_symbol/>
        <storage_type/>
      </meta>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1984</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Write to log</name>
    <type>WriteToLog</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <loglevel>log_level_error</loglevel>
    <displayHeader>Y</displayHeader>
    <limitRows>Y</limitRows>
    <limitRowsNumber>100</limitRowsNumber>
    <logmessage/>
    <fields>
      </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>2176</xloc>
      <yloc>320</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>extract.ACCT_DOC_UNIT_HISTORY</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>OPTIMA</connection>
    <sql>SELECT [CLIENT_DB]
     , [UNIT_NUMBER]
     , [LINE_NO]
     , [UNIQUE_IDENT_UNIT_HISTORY]
     , [UNIQUE_IDENT_ACCT_DOC_KEY]
     , [ACCT_NO]
     , [BOOKKEEP_DATE]
FROM [extract].[ACCT_DOC_UNIT_HISTORY]
ORDER BY [CLIENT_DB], [UNIT_NUMBER], [LINE_NO], [UNIQUE_IDENT_UNIT_HISTORY]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>UNIT_NUMBER</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>UNIT_NUMBER</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>LINE_NO</name>
        <length>4</length>
        <precision>0</precision>
        <origin>Table input</origin>
        <comments>LINE_NO</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>UNIQUE_IDENT_UNIT_HISTORY</name>
        <length>12</length>
        <precision>0</precision>
        <origin>Table input</origin>
        <comments>UNIQUE_IDENT_UNIT_HISTORY</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>UNIQUE_IDENT_ACCT_DOC_KEY</name>
        <length>12</length>
        <precision>0</precision>
        <origin>Table input</origin>
        <comments>UNIQUE_IDENT_ACCT_DOC_KEY</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>ACCT_NO</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>ACCT_NO</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Timestamp</type>
        <storagetype>normal</storagetype>
        <name>BOOKKEEP_DATE</name>
        <length>3</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>BOOKKEEP_DATE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>128</xloc>
      <yloc>1344</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>extract.UNIT_CHANGE_HIST_Department</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>OPTIMA</connection>
    <sql>SELECT *
FROM [extract].[UNIT_CHANGE_HIST_Department]
ORDER BY [CLIENT_DB], [UNIT_NUMBER]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_CHANGE_HIST_Department</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>UNIT_NUMBER</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>extract.UNIT_CHANGE_HIST_Department</origin>
        <comments>UNIT_NUMBER</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>DEPARTMENT</name>
        <length>4</length>
        <precision>-1</precision>
        <origin>extract.UNIT_CHANGE_HIST_Department</origin>
        <comments>DEPARTMENT</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>128</xloc>
      <yloc>576</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>extract.UNIT_FILE</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>OPTIMA</connection>
    <sql>SELECT *
FROM [extract].[UNIT_FILE]
ORDER BY [CLIENT_DB], [UNIT_NUMBER]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>UNIT_NUMBER</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>UNIT_NUMBER</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>BASIS_NUMBER</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>BASIS_NUMBER</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>ECC_STATUS</name>
        <length>2</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>ECC_STATUS</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>VEHICLE_TYPE</name>
        <length>1</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>VEHICLE_TYPE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Timestamp</type>
        <storagetype>normal</storagetype>
        <name>SALE_DATE</name>
        <length>3</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>SALE_DATE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Timestamp</type>
        <storagetype>normal</storagetype>
        <name>RECEPTION_DATE</name>
        <length>3</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>RECEPTION_DATE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Timestamp</type>
        <storagetype>normal</storagetype>
        <name>PURCH_DATE</name>
        <length>3</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>PURCH_DATE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>PREV_OWNER</name>
        <length>60</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>PREV_OWNER</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>ACCOUNT_SALES</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>ACCOUNT_SALES</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>SALES_DEPARTMENT</name>
        <length>4</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>SALES_DEPARTMENT</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>SALE_SALESMAN</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>SALE_SALESMAN</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>PURCH_SALSMAN_CODE</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_FILE</origin>
        <comments>PURCH_SALSMAN_CODE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>64</xloc>
      <yloc>192</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>extract.UNIT_HISTORY</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>OPTIMA</connection>
    <sql>SELECT *

FROM [extract].[UNIT_HISTORY]
ORDER BY [CLIENT_DB], [UNIT_NUMBER], [LINE_NO], [UNIQUE_IDENT]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>UNIT_NUMBER</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>UNIT_NUMBER</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>LINE_NO</name>
        <length>4</length>
        <precision>0</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>LINE_NO</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>DOCUMENT_NR</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>DOCUMENT_NR</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>LINE_TYPE</name>
        <length>2</length>
        <precision>-1</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>LINE_TYPE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>TRANSACTION_CODE</name>
        <length>3</length>
        <precision>-1</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>TRANSACTION_CODE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>REFERENCE</name>
        <length>255</length>
        <precision>-1</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>REFERENCE</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Number</type>
        <storagetype>normal</storagetype>
        <name>ORDERS_GROSSVALUE</name>
        <length>15</length>
        <precision>2</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>ORDERS_GROSSVALUE</comments>
        <conversion_Mask>####0.0#########;-####0.0#########</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>UNIQUE_IDENT</name>
        <length>12</length>
        <precision>0</precision>
        <origin>extract.UNIT_HISTORY</origin>
        <comments>UNIQUE_IDENT</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>64</xloc>
      <yloc>960</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>extract.UNIT_HISTORY_Menge</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>OPTIMA</connection>
    <sql>SELECT *

FROM [extract].[UNIT_HISTORY_Menge]
ORDER BY [CLIENT_DB], [UNIT_NUMBER], [UNIQUE_IDENT]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <cached_row_meta_active>N</cached_row_meta_active>
    <row-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>CLIENT_DB</name>
        <length>20</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>CLIENT_DB</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>String</type>
        <storagetype>normal</storagetype>
        <name>UNIT_NUMBER</name>
        <length>10</length>
        <precision>-1</precision>
        <origin>Table input</origin>
        <comments>UNIT_NUMBER</comments>
        <conversion_Mask/>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Integer</type>
        <storagetype>normal</storagetype>
        <name>UNIQUE_IDENT</name>
        <length>12</length>
        <precision>0</precision>
        <origin>Table input</origin>
        <comments>UNIQUE_IDENT</comments>
        <conversion_Mask>####0;-####0</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
      <value-meta>
        <type>Number</type>
        <storagetype>normal</storagetype>
        <name>Menge</name>
        <length>2</length>
        <precision>1</precision>
        <origin>Table input</origin>
        <comments>Menge</comments>
        <conversion_Mask>####0.0#########;-####0.0#########</conversion_Mask>
        <decimal_symbol>,</decimal_symbol>
        <grouping_symbol>.</grouping_symbol>
        <currency_symbol/>
        <trim_type>none</trim_type>
        <case_insensitive>N</case_insensitive>
        <collator_disabled>Y</collator_disabled>
        <collator_strength>0</collator_strength>
        <sort_descending>N</sort_descending>
        <output_padding>N</output_padding>
        <date_format_lenient>N</date_format_lenient>
        <date_format_locale>en_US</date_format_locale>
        <date_format_timezone>Europe/Berlin</date_format_timezone>
        <lenient_string_to_number>N</lenient_string_to_number>
      </value-meta>
    </row-meta>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>128</xloc>
      <yloc>1088</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step_error_handling>
    <error>
      <source_step>GC_DWH.dbo.Verkauf</source_step>
      <target_step>Write to log</target_step>
      <is_enabled>Y</is_enabled>
      <nr_valuename/>
      <descriptions_valuename/>
      <fields_valuename/>
      <codes_valuename/>
      <max_errors/>
      <max_pct_errors/>
      <min_pct_rows/>
    </error>
    <error>
      <source_step>Verkauf_Auswahl_Übersetzung</source_step>
      <target_step/>
      <is_enabled>N</is_enabled>
      <nr_valuename/>
      <descriptions_valuename/>
      <fields_valuename/>
      <codes_valuename/>
      <max_errors/>
      <max_pct_errors/>
      <min_pct_rows/>
    </error>
  </step_error_handling>
  <slave-step-copy-partition-distribution>
  </slave-step-copy-partition-distribution>
  <slave_transformation>N</slave_transformation>
  <attributes/>
</transformation>