Difference between revisions of "IDL TSM"

From InfiniteERP Wiki
Jump to: navigation, search
(Created page with "= Introduction = = Note / Catatan = Copy target growth code snippet: <pre> update ret_gen_tsm_targetomzetgrow set target_growth_percentage = v1.target_growth_percentage fro...")
 
Line 23: Line 23:
 
-- and ret_gen_tsm_targetomzetgrow.sku = '8010024570'
 
-- and ret_gen_tsm_targetomzetgrow.sku = '8010024570'
 
</pre>
 
</pre>
 +
 +
 +
[[Category:Client_Module]]

Revision as of 08:04, 2 January 2022

Introduction

Note / Catatan

Copy target growth code snippet:

update ret_gen_tsm_targetomzetgrow 
set target_growth_percentage = v1.target_growth_percentage
from (
	select 
	l.m_product_id 
	,l.sku 
	,l.target_growth_percentage 
	,h.version_name 
		from ret_gen_tsm_targetomzetgrow l
		inner join ret_gen_tsm_targetomzet h on l.ret_gen_tsm_targetomzet_id = h.ret_gen_tsm_targetomzet_id 
		where l.ret_gen_tsm_targetomzet_id ='097B93C8C064436BB032659DD62F0DF8'	-- source version
	--	and l.sku = '8010012659'
		and l.target_growth_percentage <> 0
	) v1
where ret_gen_tsm_targetomzetgrow.m_product_id = v1.m_product_id
	and ret_gen_tsm_targetomzetgrow.ret_gen_tsm_targetomzet_id = 'B026088A88F1498AA832572BFBB3D075'		-- destination version
--	and ret_gen_tsm_targetomzetgrow.sku = '8010024570'