UFN_BILLINGBALANCEINDIVIDUAL
Returns the balance of a given individual.
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @STARTDATE | datetime | IN | |
| @ENDDATE | datetime | IN |
Definition
Copy
CREATE function dbo.UFN_BILLINGBALANCEINDIVIDUAL
(
@CONSTITUENTID uniqueidentifier,
@STARTDATE datetime = null,
@ENDDATE datetime = null
)
returns money
with execute as caller
as begin
return dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(104, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 0, 0) - (dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(105, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 0, 0) + dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(106, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 0, 0));
end