UFN_LEDGERACCOUNT_GETACCOUNTCODEID
Retrieves the account code ID for the given ledger account
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACCOUNTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_LEDGERACCOUNT_GETACCOUNTCODEID(@ACCOUNTID uniqueidentifier)
returns uniqueidentifier
with execute as caller
as begin
declare @DATAELEMENTID uniqueidentifier
select @DATAELEMENTID = DATAELEMENTID
from
dbo.UFN_LEDGERACCOUNT_DATAELEMENTS(@ACCOUNTID) f1
inner join dbo.PDACCOUNTSEGMENTVALUE on f1.DATAELEMENTID = PDACCOUNTSEGMENTVALUE.ID
where PDACCOUNTSEGMENTVALUE.TYPECODE = 1
return @DATAELEMENTID
end