0.00.0100005050NY50000YN1000100-2024/09/10 16:33:08.253-2024/09/10 16:33:08.253H4sIAAAAAAAAAAMAAAAAAAAAAAA=Ndw bi indotekniklocalhostPOSTGRESQLNativedw_bi_indoteknik5703metabaseEncrypted 2be98dfba28d7bf86853c9f58cfc4f889FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER5703PRESERVE_RESERVED_WORD_CASEYQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYUSE_POOLINGNCalculatorSelect values 2YSelect valuesCalculatorYaccacc_horeYacc_fyaccYacc_horehoreYacc_lyoffice_accYagriagri_cleanYagri_cleancleanYagri_fyagriYagri_lymachine_agriYchemicchemic_measYchemic_fychemicYchemic_lyclean_chemicYchemic_measmeasYcleanclean_chemicYclean_chemicchemicYclean_fycleanYclean_lyagri_cleanYelecelec_logYelec_fyelecYelec_loglogYelec_lymeas_elecYhoreSelect valuesYhore_fyhoreYhore_lyacc_horeYloglog_officeYlog_fylogYlog_lyelec_logYlog_officeofficeYmachinemachine_agriYmachine_agriagriYmachine_fymachineYmachine_lytools_machineYmeasmeas_elecYmeas_elecelecYmeas_fymeasYmeas_lychemic_measYofficeoffice_accYoffice_accaccYoffice_fyofficeYoffice_lylog_officeYsafetysafety_toolsYsafety_fysafetyYsafety_lysafetyYsafety_toolstoolsYtoolstools_machineYtools_fytoolsYtools_lysafety_toolsYtools_machinemachineYSelect values 2Insert / updateYBlock this step until steps finishExecute SQL scriptYInsert / updateDelay rowYDelay rowmarkerYDummy (do nothing)Block this step until steps finishYBlock this step until steps finishBlockUntilStepsFinishY1nonemarker01104432YCalculatorCalculatorY1noneYsafety_gPERCENT_1safety_fysafety_lyNone-1-1Ntools_gPERCENT_1tools_fytools_lyNone-1-1Nmachine_gPERCENT_1machine_fymachine_lyNone-1-1Nagri_gPERCENT_1agri_fyagri_lyNone-1-1Nclean_gPERCENT_1clean_fyclean_lyNone-1-1Nchemic_gPERCENT_1chemic_fychemic_lyNone-1-1Nmeas_gPERCENT_1meas_fymeas_lyNone-1-1Nelec_gPERCENT_1elec_fyelec_lyNone-1-1Nlog_gPERCENT_1log_fylog_lyNone-1-1Noffice_gPERCENT_1office_fyoffice_lyNone-1-1Nacc_gPERCENT_1acc_fyacc_lyNone-1-1Nhore_gPERCENT_1hore_fyhore_lyNone-1-1N224432YExecute SQL scriptExecSQLY1nonedw bi indoteknikYNNNupdate t_lob_category_value_v2 set safety_ly = 0 where safety_ly is null;
update t_lob_category_value_v2 set safety_fy = 0 where safety_fy is null;
update t_lob_category_value_v2 set safety_g = 0 where safety_g is null;
update t_lob_category_value_v2 set tools_ly = 0 where tools_ly is null;
update t_lob_category_value_v2 set tools_fy = 0 where tools_fy is null;
update t_lob_category_value_v2 set tools_g = 0 where tools_g is null;
update t_lob_category_value_v2 set machine_ly = 0 where machine_ly is null;
update t_lob_category_value_v2 set machine_fy = 0 where machine_fy is null;
update t_lob_category_value_v2 set machine_g = 0 where machine_g is null;
update t_lob_category_value_v2 set agri_ly = 0 where agri_ly is null;
update t_lob_category_value_v2 set agri_fy = 0 where agri_fy is null;
update t_lob_category_value_v2 set agri_g = 0 where agri_g is null;
update t_lob_category_value_v2 set clean_ly = 0 where clean_ly is null;
update t_lob_category_value_v2 set clean_fy = 0 where clean_fy is null;
update t_lob_category_value_v2 set clean_g = 0 where clean_g is null;
update t_lob_category_value_v2 set chemic_ly = 0 where chemic_ly is null;
update t_lob_category_value_v2 set chemic_fy = 0 where chemic_fy is null;
update t_lob_category_value_v2 set chemic_g = 0 where chemic_g is null;
update t_lob_category_value_v2 set meas_ly = 0 where meas_ly is null;
update t_lob_category_value_v2 set meas_fy = 0 where meas_fy is null;
update t_lob_category_value_v2 set meas_g = 0 where meas_g is null;
update t_lob_category_value_v2 set elec_ly = 0 where elec_ly is null;
update t_lob_category_value_v2 set elec_fy = 0 where elec_fy is null;
update t_lob_category_value_v2 set elec_g = 0 where elec_g is null;
update t_lob_category_value_v2 set log_ly = 0 where log_ly is null;
update t_lob_category_value_v2 set log_fy = 0 where log_fy is null;
update t_lob_category_value_v2 set log_g = 0 where log_g is null;
update t_lob_category_value_v2 set office_ly = 0 where office_ly is null;
update t_lob_category_value_v2 set office_fy = 0 where office_fy is null;
update t_lob_category_value_v2 set office_g = 0 where office_g is null;
update t_lob_category_value_v2 set acc_ly = 0 where acc_ly is null;
update t_lob_category_value_v2 set acc_fy = 0 where acc_fy is null;
update t_lob_category_value_v2 set acc_g = 0 where acc_g is null;
update t_lob_category_value_v2 set hore_ly = 0 where hore_ly is null;
update t_lob_category_value_v2 set hore_fy = 0 where hore_fy is null;
update t_lob_category_value_v2 set hore_g = 0 where hore_g is null;
N912432YInsert / updateInsertUpdateY1nonedw bi indoteknik100Npublic
t_lob_category_value_v2
idid=ididNindustryindustryYsafety_lysafety_lyYsafety_fysafety_fyYtools_lytools_lyYtools_fytools_fyYmachine_lymachine_lyYmachine_fymachine_fyYagri_lyagri_lyYagri_fyagri_fyYclean_lyclean_lyYclean_fyclean_fyYchemic_lychemic_lyYchemic_fychemic_fyYmeas_lymeas_lyYmeas_fymeas_fyYelec_lyelec_lyYelec_fyelec_fyYlog_lylog_lyYlog_fylog_fyYoffice_lyoffice_lyYoffice_fyoffice_fyYacc_lyacc_lyYacc_fyacc_fyYhore_lyhore_lyYhore_fyhore_fyYsafety_gsafety_gYtools_gtools_gYmachine_gmachine_gYagri_gagri_gYclean_gclean_gYchemic_gchemic_gYmeas_gmeas_gYelec_gelec_gYlog_glog_gYoffice_goffice_gYacc_gacc_gYhore_ghore_gY496432YSelect valuesSelectValuesY1noneidindustrysafety_lysafety_fytools_lytools_fymachine_lymachine_fyagri_lyagri_fyclean_lyclean_fychemic_lychemic_fymeas_lymeas_fyelec_lyelec_fylog_lylog_fyoffice_lyoffice_fyacc_lyacc_fyhore_lyhore_fyN112432YSelect values 2SelectValuesY1noneidindustrysafety_lysafety_fytools_lytools_fymachine_lymachine_fyagri_lyagri_fyclean_lyclean_fychemic_lychemic_fymeas_lymeas_fyelec_lyelec_fylog_lylog_fyoffice_lyoffice_fyacc_lyacc_fyhore_lyhore_fysafety_gtools_gmachine_gagri_gclean_gchemic_gmeas_gelec_glog_goffice_gacc_ghore_gN336432YaccMergeJoinY1noneLEFT OUTERoffice_accacc_fyidid320240Yacc_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2445 and rpi2.id = rpi.id) as acc_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90acc_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1acc_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalacc_fy-1-1acc_fyacc_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN320336Yacc_horeMergeJoinY1noneLEFT OUTERacchore_lyidid224240Yacc_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2445 and rpi2.id = rpi.id) as acc_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90acc_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1acc_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalacc_ly-1-1acc_lyacc_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN416336YagriMergeJoinY1noneLEFT OUTERmachine_agriagri_fyidid816160Yagri_cleanMergeJoinY1noneLEFT OUTERagriclean_lyidid912160Yagri_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2222 and rpi2.id = rpi.id) as agri_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90agri_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1agri_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalagri_fy-1-1agri_fyagri_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN91264Yagri_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2222 and rpi2.id = rpi.id) as agri_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90agri_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1agri_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalagri_ly-1-1agri_lyagri_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN81664YchemicMergeJoinY1noneLEFT OUTERclean_chemicchemic_fyidid1200160Ychemic_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2273 and rpi2.id = rpi.id) as chemic_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90chemic_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1chemic_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalchemic_fy-1-1chemic_fychemic_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN129664Ychemic_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2273 and rpi2.id = rpi.id) as chemic_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90chemic_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1chemic_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalchemic_ly-1-1chemic_lychemic_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN120064Ychemic_measMergeJoinY1noneLEFT OUTERchemicmeas_lyidid1200240YcleanMergeJoinY1noneLEFT OUTERagri_cleanclean_fyidid1008160Yclean_chemicMergeJoinY1noneLEFT OUTERcleanchemic_lyidid1104160Yclean_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2246 and rpi2.id = rpi.id) as clean_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90clean_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1clean_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalclean_fy-1-1clean_fyclean_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN110464Yclean_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2246 and rpi2.id = rpi.id) as clean_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90clean_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1clean_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalclean_ly-1-1clean_lyclean_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN100864YelecMergeJoinY1noneLEFT OUTERmeas_elecelec_fyidid896240Yelec_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2354 and rpi2.id = rpi.id) as elec_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90elec_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1elec_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalelec_fy-1-1elec_fyelec_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN896336Yelec_logMergeJoinY1noneLEFT OUTEReleclog_lyidid800240Yelec_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2354 and rpi2.id = rpi.id) as elec_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90elec_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1elec_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalelec_ly-1-1elec_lyelec_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN992336YhoreMergeJoinY1noneLEFT OUTERacc_horehore_fyidid112336Yhore_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2477 and rpi2.id = rpi.id) as hore_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90hore_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1hore_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalhore_fy-1-1hore_fyhore_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN112240Yhore_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2477 and rpi2.id = rpi.id) as hore_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90hore_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1hore_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalhore_ly-1-1hore_lyhore_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN224336YlogMergeJoinY1noneLEFT OUTERelec_loglog_fyidid704240Ylog_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2394 and rpi2.id = rpi.id) as log_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90log_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1log_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormallog_fy-1-1log_fylog_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN704336Ylog_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2394 and rpi2.id = rpi.id) as log_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90log_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1log_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormallog_ly-1-1log_lylog_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN800336Ylog_officeMergeJoinY1noneLEFT OUTERlogoffice_lyidid608240YmachineMergeJoinY1noneLEFT OUTERtools_machinemachine_fyidid576160Ymachine_agriMergeJoinY1noneLEFT OUTERmachineagri_lyidid704160Ymachine_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2161 and rpi2.id = rpi.id) as machine_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90machine_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1machine_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalmachine_fy-1-1machine_fymachine_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN70464Ymachine_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2161 and rpi2.id = rpi.id) as machine_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90machine_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1machine_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalmachine_ly-1-1machine_lymachine_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN57664YmeasMergeJoinY1noneLEFT OUTERchemic_measmeas_fyidid1104240Ymeas_elecMergeJoinY1noneLEFT OUTERmeaselec_lyidid992240Ymeas_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2315 and rpi2.id = rpi.id) as meas_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90meas_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1meas_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalmeas_fy-1-1meas_fymeas_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN1104336Ymeas_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2315 and rpi2.id = rpi.id) as meas_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90meas_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1meas_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalmeas_ly-1-1meas_lymeas_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN1200336YofficeMergeJoinY1noneLEFT OUTERlog_officeoffice_fyidid512240Yoffice_accMergeJoinY1noneLEFT OUTERofficeacc_lyidid416240Yoffice_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2420 and rpi2.id = rpi.id) as office_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90office_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1office_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormaloffice_fy-1-1office_fyoffice_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN512336Yoffice_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2420 and rpi2.id = rpi.id) as office_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90office_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1office_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormaloffice_ly-1-1office_lyoffice_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN608336YsafetyMergeJoinY1noneLEFT OUTERsafety_lysafety_fyidid96160Ysafety_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2040 and rpi2.id = rpi.id) as safety_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90safety_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1safety_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalsafety_fy-1-1safety_fysafety_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN22464Ysafety_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2040 and rpi2.id = rpi.id) as safety_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90safety_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1safety_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormalsafety_ly-1-1safety_lysafety_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN9664Ysafety_toolsMergeJoinY1noneLEFT OUTERsafetytools_lyidid224160YtoolsMergeJoinY1noneLEFT OUTERsafety_toolstools_fyidid352160Ytools_fyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_current_year()::date and get_now()::date
and ppc.id = 2097 and rpi2.id = rpi.id) as tools_fy
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90tools_fyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1tools_fyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormaltools_fy-1-1tools_fytools_fy######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN46464Ytools_lyTableInputY1nonedw bi indoteknikselect rpi.id, coalesce(rpi.name, 'Unknown') as industry,
(select sum(aml.price_subtotal)
from account_move am
join res_partner rp on rp.id = am.partner_id
join account_move_line aml on aml.move_id = am.id
join product p on p.product_id = aml.product_id
left join res_partner_industry rpi2 on rpi2.id = rp.industry_id
left join product_public_category ppc on ppc.id = p.parent_category_id
where am.move_type = 'out_invoice'
and am.state = 'posted'
and am."date" between get_first_day_last_year()::date and get_now_last_year()::date
and ppc.id = 2097 and rpi2.id = rpi.id) as tools_ly
from res_partner_industry rpi
order by rpi.id0NNNNIntegernormalid90tools_lyid####0;-####0.,noneNY0NNNen_IDAsia/BangkokNStringnormalindustry2147483647-1tools_lyindustry.,noneNY0NNNen_IDAsia/BangkokNBigNumbernormaltools_ly-1-1tools_lytools_ly######0.0###################;-######0.0###################.noneNY0NNNen_IDAsia/BangkokN35264Ytools_machineMergeJoinY1noneLEFT OUTERtoolsmachine_lyidid464160YmarkerDummyY1none784432YDelay rowDelayY1none10milliseconds640432YDummy (do nothing)DummyY1none1280432YN