UPDATE VS4TAPVDocRef Set TPVRCurAmount=(TPVRTaxBase+TPVRVATTotal) WHERE TPVRCurAmount=0 or TPVRCurAmount IS NULL
GO
UPDATE VS4TAPVDocRef Set TPVRCurAmount=0 WHERE TPVRCurAmount=0 or TPVRCurAmount IS NULL
GO
UPDATE VS4TAPVDocRef Set TPVRCurRate=1 WHERE TPVRCurRate=0 or TPVRCurRate IS NULL
GO
UPDATE VS4TAPVDocRef Set TPVRAmountRate=(TPVRCurAmount*TPVRCurRate) WHERE TPVRAmountRate=0 or TPVRAmountRate IS NULL
GO
UPDATE VS4TAPVDocRef Set TPVRAmountRate=0 WHERE TPVRAmountRate=0 or TPVRAmountRate IS NULL
GO