UPDATE VS4TPOSTrans Set	TPTANumberOfGuides=1 WHERE TPTANumberOfGuides is Null
GO
UPDATE VS4TPOSTrans Set	TPTAGrandTotalComG=TPTAGrandTotalCom WHERE TPTAGrandTotalComG is Null
GO
UPDATE VS4TPOSTrans Set	TPTAGrandTotalComT=TPTAGrandTotalCom WHERE TPTAGrandTotalComT is Null
GO
UPDATE VS4TPOSTrans Set	TPTADeliveryRateCD=9.5 WHERE TPTADeliveryRateCD is Null
GO
UPDATE VS4TPOSTrans Set	TPTAComBaseG=TPTACommissionBase WHERE TPTAComBaseG is Null
GO
UPDATE VS4TPOSTrans Set	TPTAComBaseT=TPTACommissionBase WHERE TPTAComBaseT is Null
GO
