TR_GIFTINKINDSALEGLDISTRIBUTION_DELETE_GLTRANSACTION

                    create trigger TR_GIFTINKINDSALEGLDISTRIBUTION_DELETE_GLTRANSACTION on dbo.GIFTINKINDSALEGLDISTRIBUTION after delete not for replication
                    as begin
                        set nocount on;

                        delete from dbo.GLTRANSACTION where GLTRANSACTION.ID in (select GLTRANSACTIONID from deleted) and GLTRANSACTION.POSTSTATUSCODE = 1;
                    end