Verkauf Normal 0 /3_GC_DWH/OPTIMA ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 5000 50 50 N Y 5000 Y Y 1000 100 - 2024/07/17 12:24:15.448 - 2024/09/05 17:07:58.241 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N GC_CONFIG 192.168.2.43 MSSQL Native GC_CONFIG 1433 sa Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99 EXTRA_OPTION_MSSQL.instance GLOBALCUBE FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N MSSQL_DOUBLE_DECIMAL_SEPARATOR N PORT_NUMBER 1433 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N GC_DWH 192.168.2.43 MSSQL Native GC_DWH 1433 sa Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99 EXTRA_OPTION_MSSQL.instance GLOBALCUBE FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N MSSQL_DOUBLE_DECIMAL_SEPARATOR N PORT_NUMBER 1433 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N OPTIMA 192.168.2.43 MSSQL Native OPTIMA 1433 sa Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99 EXTRA_OPTION_MSSQL.instance GLOBALCUBE FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N MSSQL_DOUBLE_DECIMAL_SEPARATOR N PORT_NUMBER 1433 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N GC_CONFIG.optima.Transaction_Code TR_Code_Faktor2 Y TR_Code_Kennzahl1 Unit_History_Kennzahlen Y extract.UNIT_HISTORY Unit_History_Strings Y extract.UNIT_FILE Unit_File_Strings Y TR_Code_Faktor2 Select values Y Select values TR_Code_Kennzahl2 Y TR_Code_Kennzahl2 TR_Code_Kennzahl1 Y Unit_History_Kennzahlen Unit_History_Filter_Steuern Y Unit_History_Filter_Steuern Unit_History_Kennzahlen_faktorisiert Y GC_CONFIG.optima.ECC_Status ECC_Status Y Unit_File_Strings Unit_File_ECC_Status Y ECC_Status Unit_File_ECC_Status Y extract.UNIT_CHANGE_HIST_Department Unit_Change_Hist_Department_sortiert Y GC_CONFIG.optima.Vehicle_Type Vehicle_Type Y Unit_File_ECC_Status Unit_File_Vehicle_Type Y Vehicle_Type Unit_File_Vehicle_Type Y Unit_File_Vehicle_Type Unit_File_Department Y Unit_Change_Hist_Department_sortiert Unit_File_Department Y Unit_File_Department Department Y Unit_History_Kennzahlen_faktorisiert Unit_History_Rest Y GC_CONFIG.optima.Department Department_sortiert Y Department Department_Details Y Department_sortiert Department_Details Y Select values 2 GC_DWH.dbo.Verkauf Y Unit_History_Rest If field value is null Y GC_DWH.dbo.Verkauf Write to log Y Unit_File_Unit_History Select values 2 Y If field value is null Unit_History_Auswahl Y Unit_History_Strings Unit_History_Menge Y Unit_History_Menge Unit_History_Kennzahlen Y Unit_History_Auswahl Unit_File_Unit_History Y Department_Details Unit_File_Unit_History Y extract.UNIT_HISTORY_Menge Unit_History_Menge_bereinigt Y Unit_History_Menge_bereinigt Unit_History_Menge Y Department Formula Y 1 none Department IF ( OR( ISNA( [SALES_DEPARTMENT] ) ; [SALES_DEPARTMENT] = "" ) ; [DEPARTMENT_1]; [SALES_DEPARTMENT] ) String -1 -1

1024 64 Y Department_Details StreamLookup Y 1 none Department_sortiert N Y N N CLIENT_DB CLIENT_DB SALES_DEPARTMENT SALES_DEPARTMENT Hauptbetrieb_ID Hauptbetrieb_ID String Standort_ID Standort_ID String Marke_ID Marke_ID String Kostenstelle_ID Kostenstelle_ID String

1216 64 Y Department_sortiert Dummy Y 1 none

1216 576 Y ECC_Status Dummy Y 1 none

448 192 Y GC_CONFIG.optima.Department TableInput Y 1 none GC_CONFIG SELECT * FROM optima.Department 0 N N N N String normal CLIENT_DB 20 -1 Table input CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal SALES_DEPARTMENT 4 -1 Table input SALES_DEPARTMENT , . none N Y 0 N N N en_US Europe/Berlin N String normal NEW_DEPARTMENT 4 -1 Table input NEW_DEPARTMENT , . none N Y 0 N N N en_US Europe/Berlin N String normal DESCRIPTION 50 -1 Table input DESCRIPTION , . none N Y 0 N N N en_US Europe/Berlin N String normal DEPARTMENT_TYPE_ID 4 -1 Table input DEPARTMENT_TYPE_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal DEPARTMENT_DESC 50 -1 Table input DEPARTMENT_DESC , . none N Y 0 N N N en_US Europe/Berlin N Integer normal DEPARTMENT_GROUP 2 0 Table input DEPARTMENT_GROUP ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal SITE_ID 10 -1 Table input SITE_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal SITE_DESC 30 -1 Table input SITE_DESC , . none N Y 0 N N N en_US Europe/Berlin N String normal STRATEGIC_AREA_ID 10 -1 Table input STRATEGIC_AREA_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal STRATEGIC_AREA_DESC 30 -1 Table input STRATEGIC_AREA_DESC , . none N Y 0 N N N en_US Europe/Berlin N Integer normal SKR51 9 0 Table input SKR51 ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal Hauptbetrieb_ID 20 -1 Table input Hauptbetrieb_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal Standort_ID 10 -1 Table input Standort_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal Marke_ID 10 -1 Table input Marke_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal Kostenstelle_ID 4 -1 Table input Kostenstelle_ID , . none N Y 0 N N N en_US Europe/Berlin N

64 576 Y GC_CONFIG.optima.ECC_Status TableInput Y 1 none GC_CONFIG SELECT * FROM [optima].[ECC_Status] 0 N N N N String normal CLIENT_DB 20 -1 GC_CONFIG.optima.Vehicle_Type 2 CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal ECC_STATUS 10 -1 GC_CONFIG.optima.Vehicle_Type 2 ECC_STATUS , . none N Y 0 N N N en_US Europe/Berlin N String normal SPECIFY 50 -1 GC_CONFIG.optima.Vehicle_Type 2 SPECIFY , . none N Y 0 N N N en_US Europe/Berlin N String normal Bereich 10 -1 GC_CONFIG.optima.Vehicle_Type 2 Bereich , . none N Y 0 N N N en_US Europe/Berlin N String normal Auftragsstatus 20 -1 GC_CONFIG.optima.Vehicle_Type 2 Auftragsstatus , . none N Y 0 N N N en_US Europe/Berlin N String normal Fahrzeugstatus 100 -1 GC_CONFIG.optima.Vehicle_Type 2 Fahrzeugstatus , . none N Y 0 N N N en_US Europe/Berlin N Binary normal timestamp -1 0 GC_CONFIG.optima.Vehicle_Type 2 timestamp , . none N Y 0 N N N en_US Europe/Berlin N

64 192 Y GC_CONFIG.optima.Transaction_Code TableInput Y 1 none GC_CONFIG SELECT * FROM [optima].[Transaction_Code] 0 N N N N String normal CLIENT_DB 20 -1 GC_CONFIG.optima.Transaction_Code CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal TRANSACTION_CODE 12 -1 GC_CONFIG.optima.Transaction_Code TRANSACTION_CODE , . none N Y 0 N N N en_US Europe/Berlin N String normal SPECIFY 50 -1 GC_CONFIG.optima.Transaction_Code SPECIFY , . none N Y 0 N N N en_US Europe/Berlin N String normal TRANSFER_CODE 2 -1 GC_CONFIG.optima.Transaction_Code TRANSFER_CODE , . none N Y 0 N N N en_US Europe/Berlin N String normal Umsatz_Einsatz 7 -1 GC_CONFIG.optima.Transaction_Code Umsatz_Einsatz , . none N Y 0 N N N en_US Europe/Berlin N String normal Kennzahl 13 -1 GC_CONFIG.optima.Transaction_Code Kennzahl , . none N Y 0 N N N en_US Europe/Berlin N String normal Kennzahl2 9 -1 GC_CONFIG.optima.Transaction_Code Kennzahl2 , . none N Y 0 N N N en_US Europe/Berlin N

64 1088 Y GC_CONFIG.optima.Vehicle_Type TableInput Y 1 none GC_CONFIG SELECT * FROM [optima].[Vehicle_Type] 0 N N N N String normal CLIENT_DB 20 -1 extract.UNIT_FILE 2 CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal VEHICLE_TYPE 2 -1 extract.UNIT_FILE 2 VEHICLE_TYPE , . none N Y 0 N N N en_US Europe/Berlin N String normal VEHICLE_TYPE_TEXT 30 -1 extract.UNIT_FILE 2 VEHICLE_TYPE_TEXT , . none N Y 0 N N N en_US Europe/Berlin N String normal Fahrzeugart 14 -1 extract.UNIT_FILE 2 Fahrzeugart , . none N Y 0 N N N en_US Europe/Berlin N String normal Fahrzeugtyp 35 -1 extract.UNIT_FILE 2 Fahrzeugtyp , . none N Y 0 N N N en_US Europe/Berlin N

64 320 Y GC_DWH.dbo.Verkauf TableOutput Y 1 none GC_DWH dbo Verkauf_Pentaho 5000 Y N Y N N N Y N Y N

1792 64 Y If field value is null IfNull Y 1 none 0.0 N Y N Number 0 N

1408 640 Y Select values SelectValues Y 1 none CLIENT_DB TRANSACTION_CODE SPECIFY TRANSFER_CODE Umsatz_Einsatz Kennzahl2 Kennzahl Kennzahl1 Kennzahl Faktor Faktor1 Faktor Faktor2 Faktor N Faktor1 Faktor1 Number 1 1 0.00 false false Faktor2 Faktor2 Number 1 1 0.00 false false Faktor Faktor Number 1 1 0.00 false false

448 1088 Y Select values 2 SelectValues Y 1 none N DEPARTMENT_1 CLIENT_DB_1 UNIT_NUMBER_1 CLIENT_DB CLIENT_DB None 20 -2 false false UNIT_NUMBER UNIT_NUMBER None 10 -2 false false BASIS_NUMBER BASIS_NUMBER None 20 -2 false false ECC_STATUS ECC_STATUS None 2 -2 false false VEHICLE_TYPE VEHICLE_TYPE None 1 -2 false false SALE_DATE SALE_DATE None 3 -2 false false RECEPTION_DATE RECEPTION_DATE None 3 -2 false false PURCH_DATE PURCH_DATE None 3 -2 false false PREV_OWNER PREV_OWNER None 60 -2 false false ACCOUNT_SALES ACCOUNT_SALES None 10 -2 false false SALES_DEPARTMENT SALES_DEPARTMENT None 4 -2 false false SALE_SALESMAN SALE_SALESMAN None 20 -2 false false PURCH_SALSMAN_CODE PURCH_SALSMAN_CODE None 20 -2 false false SPECIFY SPECIFY None 50 -2 false false Bereich Bereich None 10 -2 false false Auftragsstatus Auftragsstatus None 20 -2 false false Fahrzeugstatus Fahrzeugstatus None 100 -2 false false timestamp timestamp None -2 0 false false VEHICLE_TYPE_TEXT VEHICLE_TYPE_TEXT None 30 -2 false false Fahrzeugart Fahrzeugart None 14 -2 false false Fahrzeugtyp Fahrzeugtyp None 35 -2 false false Department Department None -2 -2 false false Hauptbetrieb_ID Hauptbetrieb_ID None 20 -2 false false Standort_ID Standort_ID None 10 -2 false false Marke_ID Marke_ID None 10 -2 false false Kostenstelle_ID Kostenstelle_ID None 4 -2 false false LINE_NO LINE_NO String 10 -2 false false DOCUMENT_NR DOCUMENT_NR None 20 -2 false false LINE_TYPE LINE_TYPE None 2 -2 false false TRANSACTION_CODE TRANSACTION_CODE None 3 -2 false false REFERENCE REFERENCE None 255 -2 false false ORDERS_GROSSVALUE ORDERS_GROSSVALUE None 15 2 false false SPECIFY_1 SPECIFY_1 None 50 -2 false false Umsatz_Einsatz Umsatz_Einsatz None 7 -2 false false Kennzahl Kennzahl None 13 -2 false false Betrag Betrag Number 18 2 false false EK_Fahrzeug EK_Fahrzeug Number 18 2 false false Erloes Erloes Number 18 2 false false FZG_Kosten FZG_Kosten Number 18 2 false false Nachlass Nachlass Number 18 2 false false Provisionen Provisionen Number 18 2 false false Sonst_Erloese Sonst_Erloese Number 18 2 false false Ums_Fracht Ums_Fracht Number 18 2 false false VK_Hilfen VK_Hilfen Number 18 2 false false Rest Rest Number 18 2 false false UNIQUE_IDENT UNIQUE_IDENT None 12 0 false false

1600 64 Y TR_Code_Faktor2 ValueMapper Y 1 none Umsatz_Einsatz Faktor 1 Umsatz -1

256 1088 Y TR_Code_Kennzahl1 Denormaliser Y 1 none Kennzahl1 CLIENT_DB TRANSACTION_CODE SPECIFY TRANSFER_CODE Umsatz_Einsatz VK_Hilfen_1 Kennzahl1 Kennzahl Faktor1 Faktor Faktor1 EK_Fahrzeug EK_Fahrzeug_1 Number 1 1 - Faktor1 Erloes Erloes_1 Number 1 1 - Faktor1 FZG_Kosten FZG_Kosten_1 Number 1 1 - Faktor1 Nachlass Nachlass_1 Number 1 1 - Faktor1 Provisionen Provisionen_1 Number 1 1 - Faktor1 Sonst_Erloese Sonst_Erloese_1 Number 1 1 - Faktor1 Ums_Fracht Ums_Fracht_1 Number 1 1 -

832 1088 Y TR_Code_Kennzahl2 Denormaliser Y 1 none Kennzahl2 CLIENT_DB TRANSACTION_CODE SPECIFY TRANSFER_CODE Umsatz_Einsatz Kennzahl2 Kennzahl1 Kennzahl Faktor1 Faktor2 Faktor Faktor2 VK_Hilfen VK_Hilfen_1 Number 0.00 1 1 -

640 1088 Y Unit_Change_Hist_Department_sortiert Dummy Y 1 none

832 448 Y Unit_File_Department StreamLookup Y 1 none Unit_Change_Hist_Department_sortiert N Y N N CLIENT_DB CLIENT_DB UNIT_NUMBER UNIT_NUMBER DEPARTMENT DEPARTMENT_1 None

832 64 Y Unit_File_ECC_Status StreamLookup Y 1 none ECC_Status N Y N N CLIENT_DB CLIENT_DB ECC_STATUS ECC_STATUS SPECIFY SPECIFY String Bereich Bereich String Auftragsstatus Auftragsstatus String Fahrzeugstatus Fahrzeugstatus String timestamp timestamp Binary

448 64 Y Unit_File_Strings StringOperations Y 1 none UNIT_NUMBER both upper none N None none none BASIS_NUMBER both none none N None none none ECC_STATUS both none none N None none none VEHICLE_TYPE both none none N None none none PREV_OWNER both none none N None none none ACCOUNT_SALES both none none N None none none SALES_DEPARTMENT both none none N None none none SALE_SALESMAN both none none N None none none PURCH_SALSMAN_CODE both none none N None none none

256 64 Y Unit_File_Vehicle_Type StreamLookup Y 1 none Vehicle_Type N Y N N CLIENT_DB CLIENT_DB VEHICLE_TYPE VEHICLE_TYPE VEHICLE_TYPE_TEXT VEHICLE_TYPE_TEXT String Fahrzeugart Fahrzeugart String Fahrzeugtyp Fahrzeugtyp String

640 64 Y Unit_History_Filter_Steuern FilterRows Y 1 none Unit_History_Kennzahlen_faktorisiert N Umsatz_Einsatz <> constant String Steuer -1 -1 N

1024 832 Y Unit_History_Kennzahlen StreamLookup Y 1 none TR_Code_Kennzahl1 N Y N N CLIENT_DB CLIENT_DB TRANSACTION_CODE TRANSACTION_CODE SPECIFY SPECIFY String Umsatz_Einsatz Umsatz_Einsatz String VK_Hilfen_1 VK_Hilfen_1 Number EK_Fahrzeug_1 EK_Fahrzeug_1 Number Erloes_1 Erloes_1 Number FZG_Kosten_1 FZG_Kosten_1 Number Nachlass_1 Nachlass_1 Number Provisionen_1 Provisionen_1 Number Sonst_Erloese_1 Sonst_Erloese_1 Number Ums_Fracht_1 Ums_Fracht_1 Number Kennzahl Kennzahl Rest String Faktor Faktor Number

832 832 Y Unit_History_Kennzahlen_faktorisiert Calculator Y 1 none Y Betrag MULTIPLY Faktor ORDERS_GROSSVALUE Number 18 2 N 0.00 EK_Fahrzeug MULTIPLY EK_Fahrzeug_1 ORDERS_GROSSVALUE Number 18 2 N 0.00 Erloes MULTIPLY Erloes_1 ORDERS_GROSSVALUE Number 18 2 N 0.00 FZG_Kosten MULTIPLY FZG_Kosten_1 ORDERS_GROSSVALUE Number 18 2 N 0.00 Nachlass MULTIPLY Nachlass_1 ORDERS_GROSSVALUE Number 18 2 N 0.00 Provisionen MULTIPLY Provisionen_1 ORDERS_GROSSVALUE Number 18 2 N 0.00 Sonst_Erloese MULTIPLY Sonst_Erloese_1 ORDERS_GROSSVALUE Number 18 2 N 0.00 Ums_Fracht MULTIPLY Ums_Fracht_1 ORDERS_GROSSVALUE Number 18 2 N 0.00 VK_Hilfen MULTIPLY VK_Hilfen_1 ORDERS_GROSSVALUE Number 18 2 N 0.00

1216 832 Y Unit_History_Rest ScriptValueMod Y 1 none N 9 0 Script 1 //Script here var Rest = (Kennzahl == "Rest") ? Betrag : 0; Rest = 0 + Rest; Rest Rest Number 18 2 N

1408 832 Y Unit_History_Strings StringOperations Y 1 none UNIT_NUMBER both upper none N None none none DOCUMENT_NR both none none N None none none LINE_TYPE both none none N None none none TRANSACTION_CODE both none none N None none none REFERENCE both none none N None none none

256 832 Y Vehicle_Type Dummy Y 1 none

640 320 Y Write to log WriteToLog Y 1 none log_level_error Y Y 100

1792 192 Y extract.UNIT_CHANGE_HIST_Department TableInput Y 1 none OPTIMA SELECT * FROM [extract].[UNIT_CHANGE_HIST_Department] ORDER BY [CLIENT_DB], [UNIT_NUMBER] 0 N N N N String normal CLIENT_DB 20 -1 extract.UNIT_CHANGE_HIST_Department CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal UNIT_NUMBER 10 -1 extract.UNIT_CHANGE_HIST_Department UNIT_NUMBER , . none N Y 0 N N N en_US Europe/Berlin N String normal DEPARTMENT 4 -1 extract.UNIT_CHANGE_HIST_Department DEPARTMENT , . none N Y 0 N N N en_US Europe/Berlin N

64 448 Y extract.UNIT_FILE TableInput Y 1 none OPTIMA SELECT * FROM [extract].[UNIT_FILE] ORDER BY [CLIENT_DB], [UNIT_NUMBER] 0 N N N N String normal CLIENT_DB 20 -1 extract.UNIT_FILE CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal UNIT_NUMBER 10 -1 extract.UNIT_FILE UNIT_NUMBER , . none N Y 0 N N N en_US Europe/Berlin N String normal BASIS_NUMBER 20 -1 extract.UNIT_FILE BASIS_NUMBER , . none N Y 0 N N N en_US Europe/Berlin N String normal ECC_STATUS 2 -1 extract.UNIT_FILE ECC_STATUS , . none N Y 0 N N N en_US Europe/Berlin N String normal VEHICLE_TYPE 1 -1 extract.UNIT_FILE VEHICLE_TYPE , . none N Y 0 N N N en_US Europe/Berlin N Timestamp normal SALE_DATE 3 -1 extract.UNIT_FILE SALE_DATE , . none N Y 0 N N N en_US Europe/Berlin N Timestamp normal RECEPTION_DATE 3 -1 extract.UNIT_FILE RECEPTION_DATE , . none N Y 0 N N N en_US Europe/Berlin N Timestamp normal PURCH_DATE 3 -1 extract.UNIT_FILE PURCH_DATE , . none N Y 0 N N N en_US Europe/Berlin N String normal PREV_OWNER 60 -1 extract.UNIT_FILE PREV_OWNER , . none N Y 0 N N N en_US Europe/Berlin N String normal ACCOUNT_SALES 10 -1 extract.UNIT_FILE ACCOUNT_SALES , . none N Y 0 N N N en_US Europe/Berlin N String normal SALES_DEPARTMENT 4 -1 extract.UNIT_FILE SALES_DEPARTMENT , . none N Y 0 N N N en_US Europe/Berlin N String normal SALE_SALESMAN 20 -1 extract.UNIT_FILE SALE_SALESMAN , . none N Y 0 N N N en_US Europe/Berlin N String normal PURCH_SALSMAN_CODE 20 -1 extract.UNIT_FILE PURCH_SALSMAN_CODE , . none N Y 0 N N N en_US Europe/Berlin N

64 64 Y extract.UNIT_HISTORY TableInput Y 1 none OPTIMA SELECT * FROM [extract].[UNIT_HISTORY] ORDER BY [CLIENT_DB], [UNIT_NUMBER], [LINE_NO], [UNIQUE_IDENT] 0 N N N N String normal CLIENT_DB 20 -1 extract.UNIT_HISTORY CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal UNIT_NUMBER 10 -1 extract.UNIT_HISTORY UNIT_NUMBER , . none N Y 0 N N N en_US Europe/Berlin N Integer normal LINE_NO 4 0 extract.UNIT_HISTORY LINE_NO ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal DOCUMENT_NR 20 -1 extract.UNIT_HISTORY DOCUMENT_NR , . none N Y 0 N N N en_US Europe/Berlin N String normal LINE_TYPE 2 -1 extract.UNIT_HISTORY LINE_TYPE , . none N Y 0 N N N en_US Europe/Berlin N String normal TRANSACTION_CODE 3 -1 extract.UNIT_HISTORY TRANSACTION_CODE , . none N Y 0 N N N en_US Europe/Berlin N String normal REFERENCE 255 -1 extract.UNIT_HISTORY REFERENCE , . none N Y 0 N N N en_US Europe/Berlin N Number normal ORDERS_GROSSVALUE 15 2 extract.UNIT_HISTORY ORDERS_GROSSVALUE ####0.0#########;-####0.0######### , . none N Y 0 N N N en_US Europe/Berlin N Integer normal UNIQUE_IDENT 12 0 extract.UNIT_HISTORY UNIQUE_IDENT ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N

64 832 Y Unit_File_Unit_History MergeJoin Y 1 none LEFT OUTER Department_Details Unit_History_Auswahl CLIENT_DB UNIT_NUMBER CLIENT_DB UNIT_NUMBER

1408 64 Y Unit_History_Auswahl SelectValues Y 1 none N VK_Hilfen_1 EK_Fahrzeug_1 Erloes_1 FZG_Kosten_1 Nachlass_1 Provisionen_1 Sonst_Erloese_1 Ums_Fracht_1 Faktor

1408 320 Y extract.UNIT_HISTORY_Menge TableInput Y 1 none OPTIMA SELECT * FROM [extract].[UNIT_HISTORY_Menge] ORDER BY [CLIENT_DB], [UNIT_NUMBER], [UNIQUE_IDENT] 0 N N N N String normal CLIENT_DB 20 -1 Table input CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal UNIT_NUMBER 10 -1 Table input UNIT_NUMBER , . none N Y 0 N N N en_US Europe/Berlin N Integer normal UNIQUE_IDENT 12 0 Table input UNIQUE_IDENT ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Number normal Menge 2 1 Table input Menge ####0.0#########;-####0.0######### , . none N Y 0 N N N en_US Europe/Berlin N

64 960 Y Unit_History_Menge StreamLookup Y 1 none Unit_History_Menge_bereinigt N Y N N CLIENT_DB CLIENT_DB UNIT_NUMBER UNIT_NUMBER UNIQUE_IDENT UNIQUE_IDENT Menge Menge 0 Number

448 832 Y Unit_History_Menge_bereinigt StringOperations Y 1 none UNIT_NUMBER both upper

448 960 Y GC_DWH.dbo.Verkauf Write to log Y N