UFN_FISCALPERIOD_STATUS_FORDATE
Returns a status code for the fiscal period which contains the date specified.
Return
| Return Type |
|---|
| tinyint |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATE | date | IN |
Definition
Copy
create function dbo.UFN_FISCALPERIOD_STATUS_FORDATE(@DATE date)
returns tinyint
with execute as caller
as begin
declare @ret tinyint;
declare @fpclosed bit;
declare @fystatus tinyint;
SELECT TOP 1 @fystatus=FY.STATUSCODE, @fpclosed=FP.CLOSED FROM dbo.GLFISCALPERIOD FP INNER JOIN dbo.GLFISCALYEAR FY ON FP.GLFISCALYEARID=FY.ID WHERE @DATE BETWEEN FP.STARTDATE AND FP.ENDDATE
SET @ret=coalesce(@fystatus,0);
if @ret=1 begin
if @fpclosed=1 SET @ret=6;
end
return @ret
end