UFN_PLEDGE_GETINSTALLMENTSPLITS_2
Returns all splits for a given installment record
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLEDGEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_PLEDGE_GETINSTALLMENTSPLITS_2
(
@PLEDGEID uniqueidentifier
)
returns table
AS
return
(
select
ID,
INSTALLMENTID,
AMOUNT,
DESIGNATIONID,
BASECURRENCYID,
ORGANIZATIONAMOUNT,
ORGANIZATIONEXCHANGERATEID,
TRANSACTIONAMOUNT,
TRANSACTIONCURRENCYID,
BASEEXCHANGERATEID,
REVENUESPLITID
from
dbo.INSTALLMENTSPLIT
where
PLEDGEID = @PLEDGEID
);