TR_GIFTINKINDSALE_EXT_VALIDATE_IU
Definition
Copy
CREATE trigger TR_GIFTINKINDSALE_EXT_VALIDATE_IU on dbo.GIFTINKINDSALE_EXT for insert, update not for replication
as
begin
set nocount on
if exists(select 1 from FINANCIALTRANSACTION FT inner join dbo.GIFTINKINDSALE_EXT X on FT.ID = X.ID where (FT.POSTSTATUSCODE != 3 and FT.POSTDATE is null) and X.ID in (select ID from inserted))
raiserror('CK_GIFTINKINDSALE_POSTDATE_REQUIRED', 13, 1);
if exists(select 1 from FINANCIALTRANSACTION FT inner join dbo.GIFTINKINDSALE_EXT X on FT.ID = X.ID where FT.BASEAMOUNT < 0 and X.ID in (select ID from inserted))
raiserror('CK_GIFTINKINDSALE_SALEAMOUNTPOSITIVE', 13, 1);
end