UPDATE VS4TPOSTrans Set TPTAVATRate=TPTAVATPercent,TPTAWTAXBase=TPTATaxBase ,TPTAVATType=2,TPTATotal=TPTAGrandTotalVAT, TPTATotalInRate=TPTAFirstPayment, TPTANetTotal=TPTAWTAXRate
GO

UPDATE VS4TPOSTrans SET TPTADepositText=''+replace(''+convert(char(20),round(TPTADepositRate,2)),' ','') where TPTADepositRate > 0
GO
UPDATE VS4TPOSTrans SET TPTADepositText='0.00' WHERE TPTADepositText='' or TPTADepositText is null
GO
UPDATE VS4TPOSTrans SET TPTADepositText=''+TPTADepositText+'%' WHERE TPTADepositText<>''
GO

UPDATE VS4TPOSTrans SET TPTADiscountText=''+replace(''+convert(char(20),round(TPTADiscountPC,2)),' ','') where TPTADiscountPC > 0
GO
UPDATE VS4TPOSTrans SET TPTADiscountText='0.00' WHERE TPTADiscountText='' or TPTADiscountText is null
GO
UPDATE VS4TPOSTrans SET TPTADiscountText=''+TPTADiscountText+'%' WHERE TPTADiscountText<>''
GO
UPDATE VS4TPOSTrans SET TPTADiscountText=''+TPTADiscountText+'+'+replace(''+convert(char(20),round(TPTADiscountFix,2)),' ','') where TPTADiscountFix > 0
GO