USP_FENXT_ADDACCOUNTCLASS

            create procedure dbo.USP_FENXT_ADDACCOUNTCLASS
                (
                @PDACCOUNTSYSTEMID uniqueidentifier
                )
                as
                    declare @START int;
                    declare @LENGTH int;

                    declare @CHANGEAGENTID uniqueidentifier;
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                    select @START = SEGMENTSTART, @LENGTH = SEGMENTLENGTH 
                        from dbo.FENXTACCOUNTSTRUCTURE 
                    where SEGMENTTYPE = 'Account code'
                        and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID; 

                    update dbo.FENXTACCOUNT 
                        set CATEGORY = FENXTACCOUNTCODE.CATEGORY,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                    from dbo.FENXTACCOUNT inner join dbo.FENXTACCOUNTCODE
                        on SUBSTRING(FENXTACCOUNT.ACCOUNTNUMBER, @START, @LENGTH) = FENXTACCOUNTCODE.VALUE
                    where FENXTACCOUNT.CATEGORY = ''
                        and FENXTACCOUNT.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID;