UFN_CLOSINGREQUIREMENT_GETREQUIREDBYIDANDACCOUNTCODE
Returns a table containing all required elements for the given closing accounting element value and account code value.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATAELEMENTID | uniqueidentifier | IN | |
| @ACCOUNTCODEID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_CLOSINGREQUIREMENT_GETREQUIREDBYIDANDACCOUNTCODE](@DATAELEMENTID uniqueidentifier, @ACCOUNTCODEID uniqueidentifier)
returns @ACCOUNTSTRUCTURES table (ACCOUNTSTRUCTUREID uniqueidentifier)
as begin
declare @INCOMESTATEMENT bit=0;
declare @CATEGORY integer;
SELECT @CATEGORY=dbo.[UFN_GLGETCATEGORYFROMACCTCODE](@ACCOUNTCODEID);
if @CATEGORY IS NOT NULL if @CATEGORY=4 or @CATEGORY=5 SET @INCOMESTATEMENT=1;
INSERT @ACCOUNTSTRUCTURES SELECT ACCOUNTSTRUCTUREID FROM dbo.[UFN_CLOSINGREQUIREMENT_GETREQUIREDELEMENTS](@DATAELEMENTID, @INCOMESTATEMENT);
return;
end