ALTER TABLE VS4TPOSTransfer ADD
	TPTRWTAXBase money NULL,
	TPTRWTAXTotal money NULL,
	TPTRNOTAXTotal money NULL,
	TPTRTotal money NULL,
	TPTRTotalInRate money NULL,
	TPTRDiscountAll money NULL,
	TPTRRewardTotal money NULL,
	TPTRNetTotal money NULL
GO
UPDATE VS4TPOSTransfer Set TPTRWTAXBase=TPTRTaxBase ,TPTRTotal=TPTRFirstPayment, TPTRTotalInRate=TPTRFirstPayment, TPTRNetTotal=(TPTRSubTotal-TPTRDiscountTotal-TPTRPremiumTotal), TPTRNOTAXTotal=0, TPTRWTAXTotal=0
GO
UPDATE VS4TPOSTransfer Set TPTRDiscountAll=TPTRDiscountList+TPTRDiscountTotal
GO
ALTER TABLE VS4TPOSTransfer 
	DROP COLUMN TPTRIncoType, TPTRInsurance, TPTRFreightFee, TPTROtherFee, TPTRTransportFee, TPTRVATType
GO
