run_calculate_pricelist_odoo
/
-
2023/09/18 11:13:35.716
-
2023/09/18 11:13:35.716
ID_JOB
Y
ID_JOB
CHANNEL_ID
Y
CHANNEL_ID
JOBNAME
Y
JOBNAME
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
START_JOB_ENTRY
N
START_JOB_ENTRY
CLIENT
N
CLIENT
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
JOBNAME
Y
TRANSNAME
JOBENTRYNAME
Y
STEPNAME
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
RESULT
Y
RESULT
NR_RESULT_ROWS
Y
NR_RESULT_ROWS
NR_RESULT_FILES
Y
NR_RESULT_FILES
LOG_FIELD
N
LOG_FIELD
COPY_NR
N
COPY_NR
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
N
Start
SPECIAL
Y
N
N
0
0
60
12
0
1
1
N
Y
0
112
96
import brand
TRANS
filename
/home/stephan/transformation-job-bi/import_brand.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
224
96
import product
TRANS
filename
/home/stephan/transformation-job-bi/import_product_product.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
416
96
import purchase order
TRANS
filename
/home/stephan/transformation-job-bi/import_purchase_order.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
656
96
import purchase pricelist
TRANS
filename
/home/stephan/transformation-job-bi/import_purchase_pricelist.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
1056
96
import price group
TRANS
filename
/home/stephan/transformation-job-bi/import_price_group.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
1328
96
count product
TRANS
filename
/home/stephan/transformation-job-bi/update_count_trx_po_product.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
1168
192
count vendor
TRANS
filename
/home/stephan/transformation-job-bi/update_count_trx_po_vendor.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
1056
240
calculate pricelist
TRANS
filename
/home/stephan/transformation-job-bi/calculate_price_after_disc.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
752
288
insert update base pricelist
TRANS
filename
/home/stephan/transformation-job-bi/insert_update_pricelist.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
448
288
insert update pricelist1
TRANS
filename
/home/stephan/transformation-job-bi/insert_update_pricelist1.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
272
192
insert update pricelist2
TRANS
filename
/home/stephan/transformation-job-bi/insert_update_pricelist2.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
112
240
insert update pricelist3
TRANS
filename
/home/stephan/transformation-job-bi/insert_update_pricelist3.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
112
384
insert update pricelist4
TRANS
filename
/home/stephan/transformation-job-bi/insert_update_pricelist4.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
272
384
insert update pricelist5
TRANS
filename
/home/stephan/transformation-job-bi/insert_update_pricelist5.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
432
384
import qty
TRANS
filename
/home/stephan/transformation-job-bi/import_qty_available.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
528
96
update count trx odoo
TRANS
filename
/home/stephan/transformation-job-bi/update_count_trx_odoo.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
608
384
update brand purchase pricelist
TRANS
filename
/home/stephan/transformation-job-bi/update_brand_purchase_pricelist.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
864
96
update brand vendor purchase pricelist
TRANS
filename
/home/stephan/transformation-job-bi/update_brand_vendor_purchase_pricelist.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
1328
240
import category
TRANS
filename
/home/stephan/transformation-job-bi/import_product_category.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
320
48
update override vendor id
TRANS
filename
/home/stephan/transformation-job-bi/update_override_vendor_id.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
896
192
calculate pricelist override vendor
TRANS
filename
/home/stephan/transformation-job-bi/update_override_vendor_pricelist.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
624
192
update winner false
TRANS
filename
/home/stephan/transformation-job-bi/update_winner_false.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
784
384
update winner purchase pricelist
TRANS
filename
/home/stephan/transformation-job-bi/update_winner_purchase_pricelist.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
992
384
Start
import brand
0
0
Y
Y
Y
import purchase pricelist
import price group
0
0
Y
Y
N
count product
count vendor
0
0
Y
Y
N
insert update base pricelist
insert update pricelist1
0
0
Y
Y
N
insert update pricelist1
insert update pricelist2
0
0
Y
Y
N
insert update pricelist2
insert update pricelist3
0
0
Y
Y
N
insert update pricelist3
insert update pricelist4
0
0
Y
Y
N
insert update pricelist4
insert update pricelist5
0
0
Y
Y
N
import product
import qty
0
0
Y
Y
N
import qty
import purchase order
0
0
Y
Y
N
insert update pricelist5
update count trx odoo
0
0
Y
Y
N
update brand vendor purchase pricelist
count product
0
0
Y
Y
N
import purchase order
update brand purchase pricelist
0
0
Y
Y
N
update brand purchase pricelist
import purchase pricelist
0
0
Y
Y
N
import price group
update brand vendor purchase pricelist
0
0
Y
Y
N
import brand
import category
0
0
Y
Y
N
import category
import product
0
0
Y
Y
N
count vendor
update override vendor id
0
0
Y
Y
N
update override vendor id
calculate pricelist
0
0
Y
Y
N
calculate pricelist
calculate pricelist override vendor
0
0
Y
Y
N
calculate pricelist override vendor
insert update base pricelist
0
0
Y
Y
N
update count trx odoo
update winner false
0
0
Y
Y
N
update winner false
update winner purchase pricelist
0
0
Y
Y
N