USE [Viewpoint]
GO

ALTER TABLE [dbo].[vSMAgreementService]  WITH CHECK ADD  CONSTRAINT [CK_vSMAgreementService_Pricing]
CHECK  ((([PricingMethod]='T' OR [PricingMethod]='P' OR [PricingMethod]='I')
AND CASE [PricingMethod]
        WHEN 'I' THEN checksum((0),(0),(0),(0))
        WHEN 'P' THEN checksum(~[dbo].[vfEqualsNull]([PricingFrequency]),(1),(0),(1))
        WHEN 'T' THEN checksum((0),~[dbo].[vfEqualsNull]([PricingTermPrice]),
            CASE WHEN [PricingRateTemplate] IS NULL THEN [dbo].[vfEqualsNull]([PricingTermPrice]) ELSE ~[dbo].[vfEqualsNull]([PricingRateTemplate]) END,(0))
    END
    =checksum(~[dbo].[vfEqualsNull]([PricingFrequency]),~[dbo].[vfEqualsNull]([PricingTermPrice]),~[dbo].[vfEqualsNull]([PricingRateTemplate]),~[dbo].[vfEqualsNull]([BilledSeparately]))))
GO

ALTER TABLE [dbo].[vSMAgreementService] CHECK CONSTRAINT [CK_vSMAgreementService_Pricing]
GO