TR_REVENUE_INSERT_PDACCOUNTSYSTEMID

                    CREATE trigger TR_REVENUE_INSERT_PDACCOUNTSYSTEMID on dbo.REVENUE after insert not for replication
                    as 
                    begin
                        set nocount on
                        declare @PDACCOUNTSYSTEMID uniqueidentifier = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B' -- default account system ID

                        --  add revenue id and default account system id to linking table


                        insert into dbo.PDACCOUNTSYSTEMFORREVENUE(ID,  PDACCOUNTSYSTEMID,  ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)                    
                            select inserted.ID, @PDACCOUNTSYSTEMID, inserted.ADDEDBYID, inserted.CHANGEDBYID, inserted.DATEADDED, inserted.DATECHANGED from inserted where inserted.TRANSACTIONTYPECODE != 2 and inserted.TRANSACTIONTYPECODE != 3 and inserted.TRANSACTIONTYPECODE != 8

                    end