Greetings All, we are deep into the infrastructure work for the Payment feature for v14 and looking for some usage data around controlled batches and gift certificates. If you are willing to participate, please run the following SQL script on your test database and send the results (2 numeric values) to roadmap@tessituranetwork.com with a subject of Payment Data.
Thank you in advance for your assistance.
Anna
Select sum(CASE when p.pmt_amt > 0 then 1 else 0 end) as 'gift cert redemptions',
sum(CASE when p.pmt_amt < 0 then 1 else 0 end) as 'gift cert sales'
From dbo.T_PAYMENT p (NOLOCK)
join dbo.T_BATCH b (NOLOCK) on p.batch_no = b.batch_no
join dbo.TR_BATCH_TYPE bt (NOLOCK) on b.batch_type = bt.id
join dbo.TR_PAYMENT_METHOD (NOLOCK) pm on p.pmt_method = pm.id
Where bt.cntl_ind = 'Y'
and pm.pmt_type = 8
Never have so many nulls been so helpful. Thanks all for the quick response.
gift cert redemptions gift cert sales31 0