UFN_GLACCOUNT_SEGMENTVALUES
Returns the individual segments from the account number.
Return
| Return Type |
|---|
| varchar(30) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @AccountNumber | nvarchar(100) | IN | |
| @SegNum | int | IN |
Definition
Copy
CREATE function [dbo].[UFN_GLACCOUNT_SEGMENTVALUES](@AccountNumber nvarchar(100), @SegNum int)
returns varchar(30)
as
begin
declare @SegValue nvarchar(30) = (select dbo.UFN_GLACCOUNT_SEGMENTVALUES2(@AccountNumber, @SegNum, '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'))
return (@SegValue)
end