ECC_Status Normal 0 /2_GC_CONFIG_system/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 100000000 50 50 N Y 500000000 Y N 1000 100 - 2024/08/07 10:15:09.490 - 2024/09/24 13:28:03.094 H4sIAAAAAAAA/wMAAAAAAAAAAAA= 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 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 OPTIMA.template.ECC_Status GC_CONFIG.optima.ECC_Status Y OPTIMA.template.GC_Department GC_CONFIG.optima.GC_Department Y OPTIMA.template.Global_Make GC_CONFIG.optima.Global_Make Y OPTIMA.template.Transaction_Code GC_CONFIG.optima.Transaction_Code Y OPTIMA.template.Vehicle_Type GC_CONFIG.optima.Vehicle_Type Y GC_CONFIG.optima.ECC_Status InsertUpdate Y 1 none GC_CONFIG 100 N optima
ECC_Status
CLIENT_DB CLIENT_DB = ECC_STATUS ECC_STATUS = SPECIFY SPECIFY Y Bereich Bereich N Auftragsstatus Auftragsstatus N Fahrzeugstatus Fahrzeugstatus N CLIENT_DB CLIENT_DB Y ECC_STATUS ECC_STATUS Y 320 128 Y GC_CONFIG.optima.GC_Department InsertUpdate Y 1 none GC_CONFIG 100 N optima GC_Department
Hauptbetrieb Hauptbetrieb = Standort Standort = Site Site = Hauptbetrieb Hauptbetrieb Y Standort Standort Y Site Site Y Hauptbetrieb_ID Hauptbetrieb_ID Y Hauptbetrieb_Name Hauptbetrieb_Name Y Standort_ID Standort_ID Y Standort_Name Standort_Name Y Gruppe_ID Gruppe_ID Y Gruppe_Name Gruppe_Name Y Marke_ID Marke_ID Y Marke_Name Marke_Name Y
320 208 Y
GC_CONFIG.optima.Global_Make InsertUpdate Y 1 none GC_CONFIG 100 N optima Global_Make
CLIENT_DB CLIENT_DB = GLOBAL_MAKE_CD GLOBAL_MAKE_CD = CLIENT_DB CLIENT_DB Y GLOBAL_MAKE_CD GLOBAL_MAKE_CD Y DESCRIPTION DESCRIPTION Y Fabrikat Fabrikat Y Marke Marke Y Rang Rang Y
320 288 Y
GC_CONFIG.optima.Transaction_Code InsertUpdate Y 1 none GC_CONFIG 100 N optima Transaction_Code
CLIENT_DB CLIENT_DB = TRANSACTION_CODE TRANSACTION_CODE = CLIENT_DB CLIENT_DB Y TRANSACTION_CODE TRANSACTION_CODE Y SPECIFY SPECIFY Y TRANSFER_CODE TRANSFER_CODE Y Umsatz_Einsatz Umsatz_Einsatz Y Kennzahl Kennzahl Y Kennzahl2 Kennzahl2 Y
320 368 Y
GC_CONFIG.optima.Vehicle_Type InsertUpdate Y 1 none GC_CONFIG 100 N optima Vehicle_Type
CLIENT_DB CLIENT_DB = VEHICLE_TYPE VEHICLE_TYPE = CLIENT_DB CLIENT_DB Y VEHICLE_TYPE VEHICLE_TYPE Y VEHICLE_TYPE_TEXT VEHICLE_TYPE_TEXT Y Fahrzeugart Fahrzeugart Y Fahrzeugtyp Fahrzeugtyp Y
320 448 Y
OPTIMA.template.ECC_Status TableInput Y 1 none OPTIMA SELECT * FROM [template].[ECC_Status] 0 N N N N String normal CLIENT_DB 20 -1 template.ECC_Status CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal ECC_STATUS 10 -1 template.ECC_Status ECC_STATUS , . none N Y 0 N N N en_US Europe/Berlin N String normal SPECIFY 50 -1 template.ECC_Status SPECIFY , . none N Y 0 N N N en_US Europe/Berlin N String normal Bereich 7 -1 template.ECC_Status Bereich , . none N Y 0 N N N en_US Europe/Berlin N String normal Auftragsstatus 20 -1 template.ECC_Status Auftragsstatus , . none N Y 0 N N N en_US Europe/Berlin N String normal Fahrzeugstatus 63 -1 template.ECC_Status Fahrzeugstatus , . none N Y 0 N N N en_US Europe/Berlin N 96 128 Y OPTIMA.template.GC_Department TableInput Y 1 none OPTIMA SELECT * FROM [template].[GC_Department] 0 N N N N String normal Hauptbetrieb 20 -1 OPTIMA.template.ECC_Status 2 Hauptbetrieb , . none N Y 0 N N N en_US Europe/Berlin N String normal Standort 2 -1 OPTIMA.template.ECC_Status 2 Standort , . none N Y 0 N N N en_US Europe/Berlin N String normal Site 2 -1 OPTIMA.template.ECC_Status 2 Site , . none N Y 0 N N N en_US Europe/Berlin N String normal Hauptbetrieb_ID 20 -1 OPTIMA.template.ECC_Status 2 Hauptbetrieb_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal Hauptbetrieb_Name 23 -1 OPTIMA.template.ECC_Status 2 Hauptbetrieb_Name , . none N Y 0 N N N en_US Europe/Berlin N String normal Standort_ID 2 -1 OPTIMA.template.ECC_Status 2 Standort_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal Standort_Name 11 -1 OPTIMA.template.ECC_Status 2 Standort_Name , . none N Y 0 N N N en_US Europe/Berlin N String normal Gruppe_ID 1 -1 OPTIMA.template.ECC_Status 2 Gruppe_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal Gruppe_Name 1 -1 OPTIMA.template.ECC_Status 2 Gruppe_Name , . none N Y 0 N N N en_US Europe/Berlin N String normal Marke_ID 1 -1 OPTIMA.template.ECC_Status 2 Marke_ID , . none N Y 0 N N N en_US Europe/Berlin N String normal Marke_Name 1 -1 OPTIMA.template.ECC_Status 2 Marke_Name , . none N Y 0 N N N en_US Europe/Berlin N 96 208 Y OPTIMA.template.Global_Make TableInput Y 1 none OPTIMA SELECT * FROM [template].[Global_Make] 0 N N N N String normal CLIENT_DB 20 -1 OPTIMA.template.GC_Marken 2 CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal GLOBAL_MAKE_CD 2 -1 OPTIMA.template.GC_Marken 2 GLOBAL_MAKE_CD , . none N Y 0 N N N en_US Europe/Berlin N String normal DESCRIPTION 30 -1 OPTIMA.template.GC_Marken 2 DESCRIPTION , . none N Y 0 N N N en_US Europe/Berlin N String normal Fabrikat 30 -1 OPTIMA.template.GC_Marken 2 Fabrikat , . none N Y 0 N N N en_US Europe/Berlin N String normal Marke 30 -1 OPTIMA.template.GC_Marken 2 Marke , . none N Y 0 N N N en_US Europe/Berlin N Integer normal Rang 15 0 OPTIMA.template.GC_Marken 2 Rang ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N 96 288 Y OPTIMA.template.Transaction_Code TableInput Y 1 none OPTIMA SELECT * FROM [template].[Transaction_Code] 0 N N N N String normal CLIENT_DB 20 -1 OPTIMA.template.Global_Make 2 CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal TRANSACTION_CODE 12 -1 OPTIMA.template.Global_Make 2 TRANSACTION_CODE , . none N Y 0 N N N en_US Europe/Berlin N String normal SPECIFY 50 -1 OPTIMA.template.Global_Make 2 SPECIFY , . none N Y 0 N N N en_US Europe/Berlin N String normal TRANSFER_CODE 2 -1 OPTIMA.template.Global_Make 2 TRANSFER_CODE , . none N Y 0 N N N en_US Europe/Berlin N String normal Umsatz_Einsatz 7 -1 OPTIMA.template.Global_Make 2 Umsatz_Einsatz , . none N Y 0 N N N en_US Europe/Berlin N String normal Kennzahl 13 -1 OPTIMA.template.Global_Make 2 Kennzahl , . none N Y 0 N N N en_US Europe/Berlin N String normal Kennzahl2 9 -1 OPTIMA.template.Global_Make 2 Kennzahl2 , . none N Y 0 N N N en_US Europe/Berlin N 96 368 Y OPTIMA.template.Vehicle_Type TableInput Y 1 none OPTIMA SELECT * FROM [template].[Vehicle_Type] 0 N N N N String normal CLIENT_DB 20 -1 OPTIMA.template.Transaction_Code 2 CLIENT_DB , . none N Y 0 N N N en_US Europe/Berlin N String normal VEHICLE_TYPE 2 -1 OPTIMA.template.Transaction_Code 2 VEHICLE_TYPE , . none N Y 0 N N N en_US Europe/Berlin N String normal VEHICLE_TYPE_TEXT 30 -1 OPTIMA.template.Transaction_Code 2 VEHICLE_TYPE_TEXT , . none N Y 0 N N N en_US Europe/Berlin N String normal Fahrzeugart 14 -1 OPTIMA.template.Transaction_Code 2 Fahrzeugart , . none N Y 0 N N N en_US Europe/Berlin N String normal Fahrzeugtyp 35 -1 OPTIMA.template.Transaction_Code 2 Fahrzeugtyp , . none N Y 0 N N N en_US Europe/Berlin N 96 448 Y N