UPDATE salesanalysis
							SET amt=amt-312,
							cost=cost-0,
							qty=qty-20,
							disc=disc-0
							WHERE salesanalysis.area='123'
							AND salesanalysis.salesperson='fe'
							AND typeabbrev ='DE'
							AND periodno = '93'
							AND cust = 'TM050'
							AND custbranch = 'F019'
							AND stockid = 'CP'
							AND salesanalysis.stkcategory ='FOOD'
							AND budgetoractual=1