UFN_BBNC_GETPLEDGEACCOUNTSYSTEMID
Returns the account system associated with a Pledge ID
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLEDGEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BBNC_GETPLEDGEACCOUNTSYSTEMID(
@PLEDGEID uniqueidentifier
)
returns uniqueidentifier
with execute as caller
as begin
return (select PDACCOUNTSYSTEMID from dbo.PDACCOUNTSYSTEMFORREVENUE where ID = @PLEDGEID)
end