SLG IT Support

When we receive a request from GT order management to set up or reset any SKU for Precapture, use the following 

select * from Attunity_RPro_Web.dbo.PIM_PRODUCT_INFO where product_id in 

('4016605702','4016605802','4016605902')

update Attunity_RPro_Web.dbo.PIM_PRODUCT_INFO set IsPrePaySku=1 where product_id in ('4016605702','4016605802','4016605902')

you can set or reset using the pre cap flag value as 1 or 0

qeury needs to be run in the 'Attunity_RPro_Web' DB