TR_REVENUEPOSTED_I

        CREATE trigger TR_REVENUEPOSTED_I on dbo.REVENUEPOSTED for insert not for replication
        as
        set nocount on

        update dbo.FINANCIALTRANSACTION
        set POSTSTATUSCODE = 2,
                    POSTDATE = isnull(POSTDATE, GETDATE()),
        DATECHANGED = inserted.DATECHANGED,
        CHANGEDBYID = inserted.CHANGEDBYID
        from inserted inner join dbo.FINANCIALTRANSACTION on inserted.ID = FINANCIALTRANSACTION.ID

        update dbo.FINANCIALTRANSACTION
        set POSTSTATUSCODE = 2,
                    POSTDATE = isnull(POSTDATE, GETDATE()),
        DATECHANGED = inserted.DATECHANGED,
        CHANGEDBYID = inserted.CHANGEDBYID
        from inserted inner join dbo.FINANCIALTRANSACTION on inserted.ID = FINANCIALTRANSACTION.PARENTID where typecode = 26    

        update dbo.FINANCIALTRANSACTIONLINEITEM
        set POSTSTATUSCODE = 2,
                    POSTDATE = isnull(FINANCIALTRANSACTIONLINEITEM.POSTDATE, GETDATE()),
        DATECHANGED = inserted.DATECHANGED,
        CHANGEDBYID = inserted.CHANGEDBYID
        from inserted inner join dbo.FINANCIALTRANSACTIONLINEITEM on inserted.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                      inner join dbo.JOURNALENTRY on FINANCIALTRANSACTIONLINEITEM.ID = JOURNALENTRY.FINANCIALTRANSACTIONLINEITEMID