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/09/05 17:07:58.241</modified_date>
    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
    <is_key_private>N</is_key_private>
  </info>
  <notepads>
  </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_DWH</name>
    <server>192.168.2.43</server>
    <type>MSSQL</type>
    <access>Native</access>
    <database>GC_DWH</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>GC_CONFIG.optima.Transaction_Code</from>
      <to>TR_Code_Faktor2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>TR_Code_Kennzahl1</from>
      <to>Unit_History_Kennzahlen</to>
      <enabled>Y</enabled>
    </hop>
    <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>TR_Code_Faktor2</from>
      <to>Select values</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Select values</from>
      <to>TR_Code_Kennzahl2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>TR_Code_Kennzahl2</from>
      <to>TR_Code_Kennzahl1</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Kennzahlen</from>
      <to>Unit_History_Filter_Steuern</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Filter_Steuern</from>
      <to>Unit_History_Kennzahlen_faktorisiert</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_File_Department</from>
      <to>Department</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Kennzahlen_faktorisiert</from>
      <to>Unit_History_Rest</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>Select values 2</from>
      <to>GC_DWH.dbo.Verkauf</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Rest</from>
      <to>If field value is null</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>GC_DWH.dbo.Verkauf</from>
      <to>Write to log</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_File_Unit_History</from>
      <to>Select values 2</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>If field value is null</from>
      <to>Unit_History_Auswahl</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_Kennzahlen</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Unit_History_Auswahl</from>
      <to>Unit_File_Unit_History</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Department_Details</from>
      <to>Unit_File_Unit_History</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>
  </order>
  <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>64</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>64</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>576</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>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>64</xloc>
      <yloc>576</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>64</xloc>
      <yloc>192</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>64</xloc>
      <yloc>1088</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>64</xloc>
      <yloc>320</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_DWH</connection>
    <schema>dbo</schema>
    <table>Verkauf_Pentaho</table>
    <commit>5000</commit>
    <truncate>Y</truncate>
    <ignore_errors>N</ignore_errors>
    <use_batch>Y</use_batch>
    <specify_fields>N</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>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1792</xloc>
      <yloc>64</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>If field value is null</name>
    <type>IfNull</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <replaceAllByValue>0.0</replaceAllByValue>
    <replaceAllMask/>
    <selectFields>N</selectFields>
    <selectValuesType>Y</selectValuesType>
    <setEmptyStringAll>N</setEmptyStringAll>
    <valuetypes>
      <valuetype>
        <name>Number</name>
        <value>0</value>
        <mask/>
        <set_type_empty_string>N</set_type_empty_string>
      </valuetype>
    </valuetypes>
    <fields>
      </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1408</xloc>
      <yloc>640</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Select values</name>
    <type>SelectValues</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <name>CLIENT_DB</name>
      </field>
      <field>
        <name>TRANSACTION_CODE</name>
      </field>
      <field>
        <name>SPECIFY</name>
      </field>
      <field>
        <name>TRANSFER_CODE</name>
      </field>
      <field>
        <name>Umsatz_Einsatz</name>
      </field>
      <field>
        <name>Kennzahl2</name>
      </field>
      <field>
        <name>Kennzahl</name>
        <rename>Kennzahl1</rename>
      </field>
      <field>
        <name>Kennzahl</name>
      </field>
      <field>
        <name>Faktor</name>
        <rename>Faktor1</rename>
      </field>
      <field>
        <name>Faktor</name>
        <rename>Faktor2</rename>
      </field>
      <field>
        <name>Faktor</name>
      </field>
      <select_unspecified>N</select_unspecified>
      <meta>
        <name>Faktor1</name>
        <rename>Faktor1</rename>
        <type>Number</type>
        <length>1</length>
        <precision>1</precision>
        <conversion_mask>0.00</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>Faktor2</name>
        <rename>Faktor2</rename>
        <type>Number</type>
        <length>1</length>
        <precision>1</precision>
        <conversion_mask>0.00</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>Number</type>
        <length>1</length>
        <precision>1</precision>
        <conversion_mask>0.00</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>448</xloc>
      <yloc>1088</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Select values 2</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>UNIT_NUMBER</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>SALE_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>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>Fahrzeugart</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>Fahrzeugtyp</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>Kostenstelle_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>String</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>DOCUMENT_NR</name>
        <rename>DOCUMENT_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>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>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>Betrag</name>
        <rename>Betrag</rename>
        <type>Number</type>
        <length>18</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_Fahrzeug</rename>
        <type>Number</type>
        <length>18</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>Erloes</rename>
        <type>Number</type>
        <length>18</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>Number</type>
        <length>18</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>Number</type>
        <length>18</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>Number</type>
        <length>18</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_Erloese</rename>
        <type>Number</type>
        <length>18</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>Number</type>
        <length>18</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>Number</type>
        <length>18</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>Number</type>
        <length>18</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>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1600</xloc>
      <yloc>64</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>TR_Code_Faktor2</name>
    <type>ValueMapper</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <field_to_use>Umsatz_Einsatz</field_to_use>
    <target_field>Faktor</target_field>
    <non_match_default>1</non_match_default>
    <fields>
      <field>
        <source_value>Umsatz</source_value>
        <target_value>-1</target_value>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>256</xloc>
      <yloc>1088</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>TR_Code_Kennzahl1</name>
    <type>Denormaliser</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <key_field>Kennzahl1</key_field>
    <group>
      <field>
        <name>CLIENT_DB</name>
      </field>
      <field>
        <name>TRANSACTION_CODE</name>
      </field>
      <field>
        <name>SPECIFY</name>
      </field>
      <field>
        <name>TRANSFER_CODE</name>
      </field>
      <field>
        <name>Umsatz_Einsatz</name>
      </field>
      <field>
        <name>VK_Hilfen_1</name>
      </field>
      <field>
        <name>Kennzahl1</name>
      </field>
      <field>
        <name>Kennzahl</name>
      </field>
      <field>
        <name>Faktor1</name>
      </field>
      <field>
        <name>Faktor</name>
      </field>
    </group>
    <fields>
      <field>
        <field_name>Faktor1</field_name>
        <key_value>EK_Fahrzeug</key_value>
        <target_name>EK_Fahrzeug_1</target_name>
        <target_type>Number</target_type>
        <target_format/>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
      <field>
        <field_name>Faktor1</field_name>
        <key_value>Erloes</key_value>
        <target_name>Erloes_1</target_name>
        <target_type>Number</target_type>
        <target_format/>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
      <field>
        <field_name>Faktor1</field_name>
        <key_value>FZG_Kosten</key_value>
        <target_name>FZG_Kosten_1</target_name>
        <target_type>Number</target_type>
        <target_format/>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
      <field>
        <field_name>Faktor1</field_name>
        <key_value>Nachlass</key_value>
        <target_name>Nachlass_1</target_name>
        <target_type>Number</target_type>
        <target_format/>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
      <field>
        <field_name>Faktor1</field_name>
        <key_value>Provisionen</key_value>
        <target_name>Provisionen_1</target_name>
        <target_type>Number</target_type>
        <target_format/>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
      <field>
        <field_name>Faktor1</field_name>
        <key_value>Sonst_Erloese</key_value>
        <target_name>Sonst_Erloese_1</target_name>
        <target_type>Number</target_type>
        <target_format/>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
      <field>
        <field_name>Faktor1</field_name>
        <key_value>Ums_Fracht</key_value>
        <target_name>Ums_Fracht_1</target_name>
        <target_type>Number</target_type>
        <target_format/>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>832</xloc>
      <yloc>1088</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>TR_Code_Kennzahl2</name>
    <type>Denormaliser</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <key_field>Kennzahl2</key_field>
    <group>
      <field>
        <name>CLIENT_DB</name>
      </field>
      <field>
        <name>TRANSACTION_CODE</name>
      </field>
      <field>
        <name>SPECIFY</name>
      </field>
      <field>
        <name>TRANSFER_CODE</name>
      </field>
      <field>
        <name>Umsatz_Einsatz</name>
      </field>
      <field>
        <name>Kennzahl2</name>
      </field>
      <field>
        <name>Kennzahl1</name>
      </field>
      <field>
        <name>Kennzahl</name>
      </field>
      <field>
        <name>Faktor1</name>
      </field>
      <field>
        <name>Faktor2</name>
      </field>
      <field>
        <name>Faktor</name>
      </field>
    </group>
    <fields>
      <field>
        <field_name>Faktor2</field_name>
        <key_value>VK_Hilfen</key_value>
        <target_name>VK_Hilfen_1</target_name>
        <target_type>Number</target_type>
        <target_format>0.00</target_format>
        <target_length>1</target_length>
        <target_precision>1</target_precision>
        <target_decimal_symbol/>
        <target_grouping_symbol/>
        <target_currency_symbol/>
        <target_null_string/>
        <target_aggregation_type>-</target_aggregation_type>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>640</xloc>
      <yloc>1088</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>448</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_1</rename>
        <default/>
        <type>None</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>832</xloc>
      <yloc>64</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>64</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>64</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>64</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_faktorisiert</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>1024</xloc>
      <yloc>832</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Kennzahlen</name>
    <type>StreamLookup</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <from>TR_Code_Kennzahl1</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>Umsatz_Einsatz</name>
        <rename>Umsatz_Einsatz</rename>
        <default/>
        <type>String</type>
      </value>
      <value>
        <name>VK_Hilfen_1</name>
        <rename>VK_Hilfen_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>EK_Fahrzeug_1</name>
        <rename>EK_Fahrzeug_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>Erloes_1</name>
        <rename>Erloes_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>FZG_Kosten_1</name>
        <rename>FZG_Kosten_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>Nachlass_1</name>
        <rename>Nachlass_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>Provisionen_1</name>
        <rename>Provisionen_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>Sonst_Erloese_1</name>
        <rename>Sonst_Erloese_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>Ums_Fracht_1</name>
        <rename>Ums_Fracht_1</rename>
        <default/>
        <type>Number</type>
      </value>
      <value>
        <name>Kennzahl</name>
        <rename>Kennzahl</rename>
        <default>Rest</default>
        <type>String</type>
      </value>
      <value>
        <name>Faktor</name>
        <rename>Faktor</rename>
        <default/>
        <type>Number</type>
      </value>
    </lookup>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>832</xloc>
      <yloc>832</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Kennzahlen_faktorisiert</name>
    <type>Calculator</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <failIfNoFile>Y</failIfNoFile>
    <calculation>
      <field_name>Betrag</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>Faktor</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>EK_Fahrzeug</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>EK_Fahrzeug_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>Erloes</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>Erloes_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>FZG_Kosten</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>FZG_Kosten_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>Nachlass</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>Nachlass_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>Provisionen</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>Provisionen_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>Sonst_Erloese</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>Sonst_Erloese_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>Ums_Fracht</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>Ums_Fracht_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <calculation>
      <field_name>VK_Hilfen</field_name>
      <calc_type>MULTIPLY</calc_type>
      <field_a>VK_Hilfen_1</field_a>
      <field_b>ORDERS_GROSSVALUE</field_b>
      <field_c/>
      <value_type>Number</value_type>
      <value_length>18</value_length>
      <value_precision>2</value_precision>
      <remove>N</remove>
      <conversion_mask>0.00</conversion_mask>
      <decimal_symbol/>
      <grouping_symbol/>
      <currency_symbol/>
    </calculation>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1216</xloc>
      <yloc>832</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Rest</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>//Script here

var Rest = (Kennzahl == "Rest") ? Betrag : 0;
Rest = 0 + Rest;</jsScript_script>
      </jsScript>
    </jsScripts>
    <fields>
      <field>
        <name>Rest</name>
        <rename>Rest</rename>
        <type>Number</type>
        <length>18</length>
        <precision>2</precision>
        <replace>N</replace>
      </field>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1408</xloc>
      <yloc>832</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>832</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>320</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>1792</xloc>
      <yloc>192</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>64</xloc>
      <yloc>448</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>64</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>832</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>Department_Details</step1>
    <step2>Unit_History_Auswahl</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>1408</xloc>
      <yloc>64</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Unit_History_Auswahl</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>VK_Hilfen_1</name>
      </remove>
      <remove>
        <name>EK_Fahrzeug_1</name>
      </remove>
      <remove>
        <name>Erloes_1</name>
      </remove>
      <remove>
        <name>FZG_Kosten_1</name>
      </remove>
      <remove>
        <name>Nachlass_1</name>
      </remove>
      <remove>
        <name>Provisionen_1</name>
      </remove>
      <remove>
        <name>Sonst_Erloese_1</name>
      </remove>
      <remove>
        <name>Ums_Fracht_1</name>
      </remove>
      <remove>
        <name>Faktor</name>
      </remove>
    </fields>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>1408</xloc>
      <yloc>320</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>64</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>832</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>960</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>
  </step_error_handling>
  <slave-step-copy-partition-distribution>
  </slave-step-copy-partition-distribution>
  <slave_transformation>N</slave_transformation>
  <attributes/>
</transformation>