TR_FINANCIALTRANSACTIONLINEITEM_POSTDATE_REQUIRED_IUD (Trigger)

                
                    CREATE trigger TR_FINANCIALTRANSACTIONLINEITEM_POSTDATE_REQUIRED_IUD on dbo.FINANCIALTRANSACTIONLINEITEM for insert, update, delete not for replication as
                    begin
                        set nocount on;
                            if exists(
                                select FT.ID
                                from INSERTED I
                                inner join dbo.FINANCIALTRANSACTION FT on I.FINANCIALTRANSACTIONID = FT.ID
                                where (I.POSTDATE is null) and (FT.TYPECODE <> 103) and ((I.POSTSTATUSCODE = 1) or (I.POSTSTATUSCODE = 2))
                                )
                                    raiserror('CK_FINANCIALTRANSACTIONLINEITEM_POSTDATE_REQUIRED', 13,1);    
                    end