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
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
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
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
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
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