TR_REVENUEGLDISTRIBUTIONREVENUESPLITMAP_INSERT

CREATE trigger TR_REVENUEGLDISTRIBUTIONREVENUESPLITMAP_INSERT on dbo.REVENUEGLDISTRIBUTIONREVENUESPLITMAP after insert not for replication
                    as 
                    begin
                        set nocount on
                        declare @temp table (ID uniqueidentifier,cnt integer, REVENUESPLITID uniqueidentifier, DATECHANGED datetime, CHANGEDBYID uniqueidentifier) 

                        insert into @temp (
                          ID
                          ,cnt
                          ,REVENUESPLITID
                          -- Boilerplate

                          ,DATECHANGED
                          ,CHANGEDBYID
                        )
                        select 
                          T1.ID
                          ,ROW_NUMBER() over (partition by T1.REVENUESPLITID order by JE.TRANSACTIONTYPECODE)
                          ,I.REVENUESPLITID
                          -- Boilerplate

                          ,T1.DATECHANGED
                          ,T1.CHANGEDBYID                        
                        from dbo.REVENUEGLDISTRIBUTIONREVENUESPLITMAP T1
                        join dbo.JOURNALENTRY JE on T1.ID = JE.ID
                        join inserted I on T1.ID = I.ID

                        update dbo.JOURNALENTRY set 
                          FINANCIALTRANSACTIONLINEITEMID = T1.REVENUESPLITID
                          ,SEQUENCE = T1.cnt
                          -- Boilerplate

                          ,DATECHANGED = T1.DATECHANGED
                          ,CHANGEDBYID = T1.CHANGEDBYID
                        from @temp T1 join dbo.JOURNALENTRY JE on JE.ID = T1.ID                            

                    end