UFN_GLACCOUNT_GETIDFROMACCOUNTANDREVENUE
Get the account ID from the account number and revenue ID.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACCOUNTNUMBER | varchar(100) | IN | |
| @REVENUEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_GLACCOUNT_GETIDFROMACCOUNTANDREVENUE(@ACCOUNTNUMBER varchar(100), @REVENUEID uniqueidentifier)
returns uniqueidentifier
with execute as caller
as begin
declare @RETURN uniqueidentifier
select @RETURN = GLACCOUNT.ID
from dbo.FINANCIALTRANSACTION
inner join dbo.GLACCOUNT on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = GLACCOUNT.PDACCOUNTSYSTEMID
where
FINANCIALTRANSACTION.ID = @REVENUEID and
GLACCOUNT.ACCOUNTNUMBER = @ACCOUNTNUMBER
return @RETURN
end