UFN_LEDGERACCOUNT_GETACCOUNTSEGMENTS
Retrieves all segments associated with a given account.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @LEDGERACCOUNTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_LEDGERACCOUNT_GETACCOUNTSEGMENTS(@LEDGERACCOUNTID uniqueidentifier)
returns @DATAELEMENTS table
(ID uniqueidentifier,
DATAELEMENTID uniqueidentifier,
ACCOUNTSTRUCTUREID uniqueidentifier)
as
begin
insert into @DATAELEMENTS (ID, DATAELEMENTID, ACCOUNTSTRUCTUREID)
select
@LEDGERACCOUNTID as ID,
f1.DATAELEMENTID,
PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID as ACCOUNTSTRUCTUREID
from
dbo.UFN_LEDGERACCOUNT_DATAELEMENTS(@LEDGERACCOUNTID) f1
inner join dbo.PDACCOUNTSEGMENTVALUE on f1.DATAELEMENTID = PDACCOUNTSEGMENTVALUE.ID
return;
end