TR_GIFTINKINDSALE_EXT_VALIDATE_IU (Trigger)

                
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