UFN_MKTREVENUERECEIPT_NEXTAVAILABLERECEIPTNUMBER
Returns the next available receipt number for a specified record source.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDSOURCEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTREVENUERECEIPT_NEXTAVAILABLERECEIPTNUMBER]
(
@RECORDSOURCEID uniqueidentifier
)
returns int
as begin
declare @SQL nvarchar(max);
declare @NEXT int;
if dbo.[UFN_MKTRECORDSOURCE_VALIDFORBBEC](@RECORDSOURCEID) = 1
set @NEXT = dbo.[UFN_REVENUE_NEXTAVAILABLERECEIPTNUMBER]();
else
select @NEXT = max([RECEIPTNUMBER]) + 1
from dbo.[V_MKTREVENUERECEIPT]
where [RECORDSOURCEID] = @RECORDSOURCEID;
if @NEXT is null
set @NEXT = 1;
return @NEXT;
end