calculate_price_after_disc 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 - 2023/08/22 11:11:06.045 - 2023/08/22 11:11:06.045 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N dw bi indoteknik 192.168.23.5 POSTGRESQL Native dw_bi_indoteknik 5432 odoo Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5 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 Y USE_POOLING N Table input Calculator Y Calculator Calculator 2 Y Calculator 2 Insert / update Y Calculator Calculator Y 1 none Y price_after_disc_1 PERCENT_3 purchase_price markup_std1 Number -1 -1 N price_after_disc_2 PERCENT_3 purchase_price markup_std2 Number -1 -1 N price_after_disc_3 PERCENT_3 purchase_price markup_std3 Number -1 -1 N price_after_disc_4 PERCENT_3 purchase_price markup_std4 Number -1 -1 N price_after_disc_5 PERCENT_3 purchase_price markup_std5 Number -1 -1 N 384 64 Y Calculator 2 Calculator Y 1 none Y price_before_disc1 PERCENT_3 price_after_disc_1 markup_group1 Number -1 -1 N price_before_disc2 PERCENT_3 price_after_disc_2 markup_group2 Number -1 -1 N price_before_disc3 PERCENT_3 price_after_disc_3 markup_group3 Number -1 -1 N price_before_disc4 PERCENT_3 price_after_disc_4 markup_group4 Number -1 -1 N price_before_disc5 PERCENT_3 price_after_disc_5 markup_group5 Number -1 -1 N price_tier2_1 PERCENT_3 purchase_price markup_tier2_1 Number -1 -1 N price_tier2_2 PERCENT_3 purchase_price markup_tier2_2 Number -1 -1 N price_tier2_3 PERCENT_3 purchase_price markup_tier2_3 Number -1 -1 N price_tier2_4 PERCENT_3 purchase_price markup_tier2_4 Number -1 -1 N price_tier2_5 PERCENT_3 purchase_price markup_tier2_5 Number -1 -1 N price_tier3_1 PERCENT_3 purchase_price markup_tier3_1 Number -1 -1 N price_tier3_2 PERCENT_3 purchase_price markup_tier3_2 Number -1 -1 N price_tier3_3 PERCENT_3 purchase_price markup_tier3_3 Number -1 -1 N price_tier3_4 PERCENT_3 purchase_price markup_tier3_4 Number -1 -1 N price_tier3_5 PERCENT_3 purchase_price markup_tier3_5 Number -1 -1 N price_tier4_1 PERCENT_3 purchase_price markup_tier4_1 Number -1 -1 N price_tier4_2 PERCENT_3 purchase_price markup_tier4_2 Number -1 -1 N price_tier4_3 PERCENT_3 purchase_price markup_tier4_3 Number -1 -1 N price_tier4_4 PERCENT_3 purchase_price markup_tier4_4 Number -1 -1 N price_tier4_5 PERCENT_3 purchase_price markup_tier4_5 Number -1 -1 N price_tier5_1 PERCENT_3 purchase_price markup_tier5_1 Number -1 -1 N price_tier5_2 PERCENT_3 purchase_price markup_tier5_2 Number -1 -1 N price_tier5_3 PERCENT_3 purchase_price markup_tier5_3 Number -1 -1 N price_tier5_4 PERCENT_3 purchase_price markup_tier5_4 Number -1 -1 N price_tier5_5 PERCENT_3 purchase_price markup_tier5_5 Number -1 -1 N 544 64 Y Insert / update InsertUpdate Y 1 none dw bi indoteknik 100 N public
pricelist_compute
product_id product_id = product_id product_id N item_code item_code Y name name Y purchase_price purchase_price Y pricing_group pricing_group Y markup_std1 markup_std1 Y markup_std2 markup_std2 Y markup_std3 markup_std3 Y markup_std4 markup_std4 Y markup_std5 markup_std5 Y markup_group1 markup_group1 Y markup_group2 markup_group2 Y markup_group3 markup_group3 Y markup_group4 markup_group4 Y markup_group5 markup_group5 Y markup_tier2_1 markup_tier2_1 Y markup_tier2_2 markup_tier2_2 Y markup_tier2_3 markup_tier2_3 Y markup_tier2_4 markup_tier2_4 Y markup_tier2_5 markup_tier2_5 Y markup_tier3_1 markup_tier3_1 Y markup_tier3_2 markup_tier3_2 Y markup_tier3_3 markup_tier3_3 Y markup_tier3_4 markup_tier3_4 Y markup_tier3_5 markup_tier3_5 Y price_after_disc_1 price_after_disc_1 Y price_after_disc_2 price_after_disc_2 Y price_after_disc_3 price_after_disc_3 Y price_after_disc_4 price_after_disc_4 Y price_after_disc_5 price_after_disc_5 Y price_before_disc1 price_before_disc1 Y price_before_disc2 price_before_disc2 Y price_before_disc3 price_before_disc3 Y price_before_disc4 price_before_disc4 Y price_before_disc5 price_before_disc5 Y price_tier2_1 price_tier2_1 Y price_tier2_2 price_tier2_2 Y price_tier2_3 price_tier2_3 Y price_tier2_4 price_tier2_4 Y price_tier2_5 price_tier2_5 Y price_tier3_1 price_tier3_1 Y price_tier3_2 price_tier3_2 Y price_tier3_3 price_tier3_3 Y price_tier3_4 price_tier3_4 Y price_tier3_5 price_tier3_5 Y price_tier4_1 price_tier4_1 Y price_tier4_2 price_tier4_2 Y price_tier4_3 price_tier4_3 Y price_tier4_4 price_tier4_4 Y price_tier4_5 price_tier4_5 Y price_tier5_1 price_tier5_1 Y price_tier5_2 price_tier5_2 Y price_tier5_3 price_tier5_3 Y price_tier5_4 price_tier5_4 Y price_tier5_5 price_tier5_5 Y 720 64 Y Table input TableInput Y 1 none dw bi indoteknik select mpp.product_id, p.item_code, p."name", mpp.purchase_price, b.pricing_group, (select group1 from price_group_dw pgd where id = 2) as markup_std1, (select group2 from price_group_dw pgd where id = 2) as markup_std2, (select group3 from price_group_dw pgd where id = 2) as markup_std3, (select group4 from price_group_dw pgd where id = 2) as markup_std4, (select group5 from price_group_dw pgd where id = 2) as markup_std5, (select group1 from price_group_dw pgd where id = 1) as markup_group1, (select group2 from price_group_dw pgd where id = 1) as markup_group2, (select group3 from price_group_dw pgd where id = 1) as markup_group3, (select group4 from price_group_dw pgd where id = 1) as markup_group4, (select group5 from price_group_dw pgd where id = 1) as markup_group5, (select group1 from price_group_dw pgd where id = 3) as markup_tier2_1, (select group2 from price_group_dw pgd where id = 3) as markup_tier2_2, (select group3 from price_group_dw pgd where id = 3) as markup_tier2_3, (select group4 from price_group_dw pgd where id = 3) as markup_tier2_4, (select group5 from price_group_dw pgd where id = 3) as markup_tier2_5, (select group1 from price_group_dw pgd where id = 4) as markup_tier3_1, (select group2 from price_group_dw pgd where id = 4) as markup_tier3_2, (select group3 from price_group_dw pgd where id = 4) as markup_tier3_3, (select group4 from price_group_dw pgd where id = 4) as markup_tier3_4, (select group5 from price_group_dw pgd where id = 4) as markup_tier3_5, (select group1 from price_group_dw pgd where id = 5) as markup_tier4_1, (select group2 from price_group_dw pgd where id = 5) as markup_tier4_2, (select group3 from price_group_dw pgd where id = 5) as markup_tier4_3, (select group4 from price_group_dw pgd where id = 5) as markup_tier4_4, (select group5 from price_group_dw pgd where id = 5) as markup_tier4_5, (select group1 from price_group_dw pgd where id = 6) as markup_tier5_1, (select group2 from price_group_dw pgd where id = 6) as markup_tier5_2, (select group3 from price_group_dw pgd where id = 6) as markup_tier5_3, (select group4 from price_group_dw pgd where id = 6) as markup_tier5_4, (select group5 from price_group_dw pgd where id = 6) as markup_tier5_5 from mv_purchase_pricelist mpp join product p on p.product_id = mpp.product_id left join brand b on b.id = p.brand_id where b.id in(10, 122, 89) 0 N N N N Integer normal product_id 9 0 Table input product_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal item_code 2147483647 -1 Table input item_code . , none N Y 0 N N N en_US Asia/Bangkok N String normal name 2147483647 -1 Table input name . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal purchase_price -1 -1 Table input purchase_price ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N String normal pricing_group 2147483647 -1 Table input pricing_group . , none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std1 -1 -1 Table input markup_std1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std2 -1 -1 Table input markup_std2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std3 -1 -1 Table input markup_std3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std4 -1 -1 Table input markup_std4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_std5 -1 -1 Table input markup_std5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group1 -1 -1 Table input markup_group1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group2 -1 -1 Table input markup_group2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group3 -1 -1 Table input markup_group3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group4 -1 -1 Table input markup_group4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_group5 -1 -1 Table input markup_group5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_1 -1 -1 Table input markup_tier2_1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_2 -1 -1 Table input markup_tier2_2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_3 -1 -1 Table input markup_tier2_3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_4 -1 -1 Table input markup_tier2_4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier2_5 -1 -1 Table input markup_tier2_5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_1 -1 -1 Table input markup_tier3_1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_2 -1 -1 Table input markup_tier3_2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_3 -1 -1 Table input markup_tier3_3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_4 -1 -1 Table input markup_tier3_4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N BigNumber normal markup_tier3_5 -1 -1 Table input markup_tier3_5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_US Asia/Bangkok N 240 64 Y N