UFN_REVENUESPLIT_VALIDAMOUNT
Checks that the split amount is equal to the total revenue amount
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPLITS | xml | IN | |
| @REVENUEAMOUNT | money | IN |
Definition
Copy
create function dbo.UFN_REVENUESPLIT_VALIDAMOUNT
(
@SPLITS xml,
@REVENUEAMOUNT money
)
returns bit
with execute as caller
as
begin
declare @ISVALID as bit
declare @SUMAMOUNT as money
set @SUMAMOUNT = (select SUM(AMOUNT) from dbo.UFN_REVENUE_GETSPLITS_FROMITEMLISTXML(@SPLITS))
if @SUMAMOUNT <> @REVENUEAMOUNT
begin
set @ISVALID = 0
end
else
begin
set @ISVALID = 1
end
return @ISVALID
end