IDL TSM

From InfiniteERP Wiki
Revision as of 08:04, 2 January 2022 by Wikiadmin (talk | contribs)
Jump to: navigation, search

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'