UFN_GLACCOUNT_SEGMENTVALUES_3

Returns the individual segments from the account number.

Return

Return Type
varchar(100)

Parameters

Parameter	Parameter Type	Mode
@AccountNumber	nvarchar(100)	IN
@SegNum	int	IN
@AcctSysID	uniqueidentifier	IN

Definition

Copy



CREATE function [dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3](@AccountNumber nvarchar(100), @SegNum int, @AcctSysID uniqueidentifier )
      returns varchar(100)
      as
      begin

      declare @SegStart int
      declare @SegLength int
      declare @SegValue nvarchar(100)

      select @SegLength = LENGTH, @SegStart = isnull((select sum(LENGTH+case SEPARATORCODE when 6 then 0 else 1 end) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @AcctSysID and SEQUENCE < @SegNum),0) + 1
      from dbo.PDACCOUNTSTRUCTURE
      where SEQUENCE = @SegNum and PDACCOUNTSYSTEMID = @AcctSysID

      if @SegLength is null
          set @SegValue = ''
      else
          set @SegValue = substring(@AccountNumber,@SegStart,@SegLength)

      return (@SegValue)
      end