Difference between revisions of "IDL TSM"

From InfiniteERP Wiki
Jump to: navigation, search
(Note / Catatan)
Line 34: Line 34:
  
 
{{BackTo | Category:Customer_Specific}}
 
{{BackTo | Category:Customer_Specific}}
[[Category:Customer_Specific]]
 
 
[[Category:Client_Module]]
 
[[Category:Client_Module]]

Revision as of 12:12, 3 January 2022

Introduction

Windows

Processes

Standard Process

Background Process

Tables

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'
Back button.png   Back to