import_account_account
Normal
/
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
10000
50
50
N
Y
50000
Y
N
1000
100
-
2024/05/10 11:10:53.905
-
2024/05/10 11:10:53.905
N
dw bi indoteknik (localhost)
localhost
POSTGRESQL
Native
dw_bi_indoteknik
5432
pdi
Encrypted 2be989bb20084ca95810197629d9ea18e
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
5432
PRESERVE_RESERVED_WORD_CASE
Y
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
N
USE_POOLING
N
erp indoteknik production (localhost)
10.148.0.3
POSTGRESQL
Native
erp_indoteknik
5432
pdi
Encrypted 2be989bb20084ca95810197629d9ea18e
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
5432
PRESERVE_RESERVED_WORD_CASE
Y
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
N
USE_POOLING
N
Table input
Insert / update
Y
Table input
TableInput
Y
1
none
erp indoteknik production (localhost)
select * from account_account am where am.write_date >= (now() - '3 days'::interval)
0
N
N
N
N
Integer
normal
id
9
0
Table input
id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
String
normal
name
2147483647
-1
Table input
name
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
currency_id
9
0
Table input
currency_id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
String
normal
code
64
-1
Table input
code
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Boolean
normal
deprecated
-1
-1
Table input
deprecated
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
user_type_id
9
0
Table input
user_type_id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
String
normal
internal_type
2147483647
-1
Table input
internal_type
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
String
normal
internal_group
2147483647
-1
Table input
internal_group
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Boolean
normal
reconcile
-1
-1
Table input
reconcile
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
String
normal
note
2147483647
-1
Table input
note
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
company_id
9
0
Table input
company_id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
group_id
9
0
Table input
group_id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
root_id
9
0
Table input
root_id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Boolean
normal
is_off_balance
-1
-1
Table input
is_off_balance
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
create_uid
9
0
Table input
create_uid
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Timestamp
normal
create_date
6
-1
Table input
create_date
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
write_uid
9
0
Table input
write_uid
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Timestamp
normal
write_date
6
-1
Table input
write_date
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
cash_flow_type
9
0
Table input
cash_flow_type
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
Integer
normal
cost_centre_id
9
0
Table input
cost_centre_id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_ID
Asia/Bangkok
N
128
96
Y
Insert / update
InsertUpdate
Y
1
none
dw bi indoteknik (localhost)
100
N
public
id
id
=
id
id
N
name
name
Y
currency_id
currency_id
Y
code
code
Y
deprecated
deprecated
Y
user_type_id
user_type_id
Y
internal_type
internal_type
Y
internal_group
internal_group
Y
reconcile
reconcile
Y
note
note
Y
company_id
company_id
Y
group_id
group_id
Y
root_id
root_id
Y
is_off_balance
is_off_balance
Y
create_uid
create_uid
Y
create_date
create_date
Y
write_uid
write_uid
Y
write_date
write_date
Y
cash_flow_type
cash_flow_type
Y
cost_centre_id
cost_centre_id
Y
304
96
Y
N