TR_BANKACCOUNTTRANSACTION_UPDATE

CREATE trigger [dbo].[TR_BANKACCOUNTTRANSACTION_UPDATE] ON [dbo].[BANKACCOUNTTRANSACTION] AFTER UPDATE NOT FOR REPLICATION AS
    BEGIN
        SET NOCOUNT ON

        Begin Try
            if update(POSTDATE) or update(POSTSTATUSCODE)
                update dbo.GLTRANSACTION set POSTDATE = I.POSTDATE, POSTSTATUSCODE = I.POSTSTATUSCODE, CHANGEDBYID = I.CHANGEDBYID, DATECHANGED = I.DATECHANGED
                from INSERTED as I
                inner join dbo.BANKACCOUNTTRANSACTIONGLDISTRIBUTION as D on D.BANKACCOUNTTRANSACTIONID = I.ID
                inner join dbo.GLTRANSACTION as T on T.ID = D.GLTRANSACTIONID
                where T.POSTSTATUSCODE = 1;
        End Try
        Begin Catch
            exec dbo.USP_RAISE_ERROR
        End Catch
    END