calculate_margin_invoice_v2 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/10/03 11:59:36.021 - 2024/10/03 11:59:36.021 H4sIAAAAAAAAAAMAAAAAAAAAAAA= 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 penjualan Merge join Y hpp Merge join Y Merge join Select values Y Select values Add constants Y Calculator Select values 2 Y Add constants Calculator Y Select values 2 Filter rows Y Filter rows Insert / update Y Filter rows Write to log Y Add constants Constant Y 1 none zero Number 0 -1 -1 N one_hundred Number 100 -1 -1 N

624 224 Y Calculator Calculator Y 1 none Y new_penjualan SUBTRACT zero penjualan None -1 -1 N penjualan_sub_hpp SUBTRACT new_penjualan hpp None -1 -1 N margin DIVIDE penjualan_sub_hpp new_penjualan None -1 -1 N percent_margin MULTIPLY margin one_hundred None -1 -1 N

752 224 Y Filter rows FilterRows Y 1 none Insert / update Write to log N N hpp > constant BigNumber 0.0 -1 -1 N ######0.0###################;-######0.0################### N AND penjualan > constant Number 0.0 -1 -1 N ####0.0#########;-####0.0#########

688 336 Y Insert / update InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public margin_invoice_v2 id id = id id N sale_line_id sale_line_id Y date date Y date_order date_order Y so so Y customer customer Y lob lob Y brand brand Y item_code item_code Y product product Y salesperson salesperson Y vendor vendor Y quantity quantity Y price_unit price_unit Y account_id account_id Y account_name account_name Y price_subtotal price_subtotal Y price_total price_total Y hpp hpp Y penjualan penjualan Y margin margin Y percent_margin percent_margin Y

896 336 Y Merge join MergeJoin Y 1 none INNER penjualan hpp sale_line_id sale_line_id

368 224 Y Select values SelectValues Y 1 none id sale_line_id date date_order so customer lob brand item_code product salesperson vendor quantity price_unit account_id account_name price_subtotal price_total balance penjualan balance_1 hpp N

496 224 Y Select values 2 SelectValues Y 1 none id sale_line_id date date_order so customer lob brand item_code product salesperson vendor quantity price_unit account_id account_name price_subtotal price_total hpp new_penjualan penjualan penjualan_sub_hpp margin percent_margin N

896 224 Y Write to log WriteToLog Y 1 none log_level_basic Y N 0

544 336 Y hpp TableInput Y 1 none dw bi indoteknik (localhost) select aml.id, tsol.id as sale_line_id, aml.date, tso.date_order, tso.name as so, coalesce(gp.name, rp.name) as customer, rpi.name as lob, b."name" as brand, p.item_code, p."name" as product, rp2.name as salesperson, rp3.name as vendor, aml.quantity, aml.price_unit, aml.account_id, aa.name as account_name, aml.price_subtotal, aml.price_total, aml.balance from account_move_line aml join account_move am on am.id = aml.move_id join t_sale_order tso on tso.id = am.sale_id join t_sale_order_line tsol on (tsol.order_id = tso.id and tsol.product_id = aml.product_id) join product p on p.product_id = aml.product_id join account_account aa on aa.id = aml.account_id join res_partner rp on rp.id = am.partner_id join res_users ru on ru.id = tso.user_id join res_partner rp2 on rp2.id = ru.partner_id left join res_partner_industry rpi on rpi.id = rp.industry_id left join group_partner gp on gp.id = rp.group_partner_id left join brand b on b.id = p.brand_id left join res_partner rp3 on rp3.id = tsol.vendor_id where aml.account_id in (466) and am.state = 'posted' and tso.state in ('sale', 'done') --and aml.date >= '2024-06-01' and aml.write_date >= (now() - '3 days'::interval) order by tsol.id 0 N N N N Integer normal id 9 0 hpp id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sale_line_id 9 0 hpp sale_line_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Date normal date -1 -1 hpp date . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_order 6 -1 hpp date_order . , none N Y 0 N N N en_ID Asia/Bangkok N String normal so 2147483647 -1 hpp so . , none N Y 0 N N N en_ID Asia/Bangkok N String normal customer 2147483647 -1 hpp customer . , none N Y 0 N N N en_ID Asia/Bangkok N String normal lob 2147483647 -1 hpp lob . , none N Y 0 N N N en_ID Asia/Bangkok N String normal brand 2147483647 -1 hpp brand . , none N Y 0 N N N en_ID Asia/Bangkok N String normal item_code 2147483647 -1 hpp item_code . , none N Y 0 N N N en_ID Asia/Bangkok N String normal product 2147483647 -1 hpp product . , none N Y 0 N N N en_ID Asia/Bangkok N String normal salesperson 2147483647 -1 hpp salesperson . , none N Y 0 N N N en_ID Asia/Bangkok N String normal vendor 2147483647 -1 hpp vendor . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal quantity -1 -1 hpp quantity ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_unit -1 -1 hpp price_unit ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N Integer normal account_id 9 0 hpp account_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal account_name 2147483647 -1 hpp account_name . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_subtotal -1 -1 hpp price_subtotal ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_total -1 -1 hpp price_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal balance -1 -1 hpp balance ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N

368 112 Y penjualan TableInput Y 1 none dw bi indoteknik (localhost) select aml.id, tsol.id as sale_line_id, aml.date, tso.date_order, tso.name as so, coalesce(gp.name, rp.name) as customer, rpi.name as lob, b."name" as brand, p.item_code, p."name" as product, rp2.name as salesperson, rp3.name as vendor, aml.quantity, aml.price_unit, aml.account_id, aa.name as account_name, aml.price_subtotal, aml.price_total, aml.balance from account_move_line aml join account_move am on am.id = aml.move_id join t_sale_order tso on tso.id = am.sale_id join t_sale_order_line tsol on (tsol.order_id = tso.id and tsol.product_id = aml.product_id) join product p on p.product_id = aml.product_id join account_account aa on aa.id = aml.account_id join res_partner rp on rp.id = am.partner_id join res_users ru on ru.id = tso.user_id join res_partner rp2 on rp2.id = ru.partner_id left join res_partner_industry rpi on rpi.id = rp.industry_id left join group_partner gp on gp.id = rp.group_partner_id left join brand b on b.id = p.brand_id left join res_partner rp3 on rp3.id = tsol.vendor_id where aml.account_id in (462) and am.state = 'posted' and tso.state in ('sale', 'done') --and aml.date >= '2024-06-01' and aml.write_date >= (now() - '3 days'::interval) order by tsol.id 0 N N N N Integer normal id 9 0 penjualan id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Integer normal sale_line_id 9 0 penjualan sale_line_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N Date normal date -1 -1 penjualan date . , none N Y 0 N N N en_ID Asia/Bangkok N Timestamp normal date_order 6 -1 penjualan date_order . , none N Y 0 N N N en_ID Asia/Bangkok N String normal so 2147483647 -1 penjualan so . , none N Y 0 N N N en_ID Asia/Bangkok N String normal customer 2147483647 -1 penjualan customer . , none N Y 0 N N N en_ID Asia/Bangkok N String normal lob 2147483647 -1 penjualan lob . , none N Y 0 N N N en_ID Asia/Bangkok N String normal brand 2147483647 -1 penjualan brand . , none N Y 0 N N N en_ID Asia/Bangkok N String normal item_code 2147483647 -1 penjualan item_code . , none N Y 0 N N N en_ID Asia/Bangkok N String normal product 2147483647 -1 penjualan product . , none N Y 0 N N N en_ID Asia/Bangkok N String normal salesperson 2147483647 -1 penjualan salesperson . , none N Y 0 N N N en_ID Asia/Bangkok N String normal vendor 2147483647 -1 penjualan vendor . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal quantity -1 -1 penjualan quantity ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_unit -1 -1 penjualan price_unit ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N Integer normal account_id 9 0 penjualan account_id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal account_name 2147483647 -1 penjualan account_name . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_subtotal -1 -1 penjualan price_subtotal ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal price_total -1 -1 penjualan price_total ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal balance -1 -1 penjualan balance ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N

240 224 Y N