UFN_FINANCIALTRANSACTION_GETAMOUNT
Returns the Amount for a given financial transaction
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_FINANCIALTRANSACTION_GETAMOUNT
(
@ID uniqueidentifier
)
returns money
as
begin
declare @RETURNMONEY money
select
@RETURNMONEY = TRANSACTIONAMOUNT
from
dbo.FINANCIALTRANSACTION
where
FINANCIALTRANSACTION.ID = @ID
return @RETURNMONEY
end