Difference between revisions of "IDL TSM"

From InfiniteERP Wiki
Jump to: navigation, search
(Introduction)
(Note / Catatan)
 
(6 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
= Windows =
 
= Windows =
  
= Background Processes =
+
= Processes =
 +
== Standard Process ==
 +
 
 +
== Background Process ==
  
 
= Tables =
 
= Tables =
Line 30: Line 33:
 
</pre>
 
</pre>
  
 
+
{{BackTo |Category:Customer_Specific}}
 
[[Category:Client_Module]]
 
[[Category:Client_Module]]

Latest 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