TR_UNREALIZEDGAINLOSSGLDISTRIBUTION_DELETE_GLTRANSACTION (Trigger)

                
                    CREATE trigger TR_UNREALIZEDGAINLOSSGLDISTRIBUTION_DELETE_GLTRANSACTION on dbo.UNREALIZEDGAINLOSSGLDISTRIBUTION after delete not for replication
                    as begin
                        set nocount on;
                        
                        delete from dbo.GLTRANSACTION with (rowlock) where GLTRANSACTION.ID in (select GLTRANSACTIONID from deleted) and GLTRANSACTION.POSTSTATUSCODE > 0;
                    end