TR_FINANCIALTRANSACTIONLINEITEM_LOCKEDFIELDS_IUD (Trigger)

                
                    CREATE trigger TR_FINANCIALTRANSACTIONLINEITEM_LOCKEDFIELDS_IUD on dbo.FINANCIALTRANSACTIONLINEITEM for insert, update, delete not for replication as
                    begin
                        set nocount on;
                            if update(POSTSTATUSCODE) or update(POSTDATE) or update(AMOUNT)
                                if exists(
                                    select D.ID
                                    from INSERTED I
                                    inner join DELETED D ON I.ID = D.ID
                                    where
                                    ( /*it's posted*/
                                        D.POSTSTATUSCODE=2 and 
                                        (D.POSTSTATUSCODE <> I.POSTSTATUSCODE 
                                        or D.POSTDATE <> I.POSTDATE)
                                    )
                                )
                                raiserror('ERR_FINANCIALTRANSACTION_LOCKEDFIELDS', 13,1);  
                    end