UFN_POSTSUMMARYTYPE
Returns the value used to summarize transactions in the pre-post report.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ISREVERSAL | tinyint | IN | |
| @TRANSACTIONTYPECODE | tinyint | IN | |
| @REVENUETRANSACTIONTYPECODE | tinyint | IN | |
| @APPLICATIONCODE | int | IN | |
| @PAYMENTMETHODCODE | int | IN |
Definition
Copy
CREATE function [dbo].[UFN_POSTSUMMARYTYPE](@ISREVERSAL tinyint, @TRANSACTIONTYPECODE tinyint, @REVENUETRANSACTIONTYPECODE tinyint, @APPLICATIONCODE int, @PAYMENTMETHODCODE int)
returns integer
as
begin
declare @RETURNVALUE Integer;
SET @RETURNVALUE = 0
if (@ISREVERSAL = 0 and @TRANSACTIONTYPECODE = 1
and ((@REVENUETRANSACTIONTYPECODE = 0 and @APPLICATIONCODE in (0,1,3,4,5,6,7,11,13,19))
or (@REVENUETRANSACTIONTYPECODE = 1 and @APPLICATIONCODE = 0)
or (@REVENUETRANSACTIONTYPECODE = 15 and @APPLICATIONCODE in (0,5,18))
or (@REVENUETRANSACTIONTYPECODE = 4 and @APPLICATIONCODE = 0)
or (@REVENUETRANSACTIONTYPECODE = 201 and @APPLICATIONCODE = 201)
or (@REVENUETRANSACTIONTYPECODE = 5 and @APPLICATIONCODE in (0,1,9,5, 16))))
set @RETURNVALUE = 1; -- 'REVENUE'
else
if (@ISREVERSAL = 0
and ((@REVENUETRANSACTIONTYPECODE = 0 and @APPLICATIONCODE in (0,1,2,3,4,5,6,7,8,10,11,13,19,203) and @TRANSACTIONTYPECODE = 0)
or (@REVENUETRANSACTIONTYPECODE = 200 and @APPLICATIONCODE = 200)
or (@REVENUETRANSACTIONTYPECODE = 201 and @APPLICATIONCODE = 201 and @TRANSACTIONTYPECODE = 0)))
set @RETURNVALUE = 2; -- 'CASH'
else
if (@ISREVERSAL = 0
and ((@REVENUETRANSACTIONTYPECODE = 1 and @APPLICATIONCODE = 0 and @TRANSACTIONTYPECODE = 0)
or (@REVENUETRANSACTIONTYPECODE = 15 and @APPLICATIONCODE in (0,5,18) and @TRANSACTIONTYPECODE = 0)
or (@REVENUETRANSACTIONTYPECODE = 4 and @APPLICATIONCODE = 0 and @TRANSACTIONTYPECODE = 0 )
or (@REVENUETRANSACTIONTYPECODE = 5 and @APPLICATIONCODE in (0,1,9,5,16) and @TRANSACTIONTYPECODE = 0)
or (@REVENUETRANSACTIONTYPECODE = 0 and @APPLICATIONCODE in (2,8,10,203) and @TRANSACTIONTYPECODE = 1)
or (@REVENUETRANSACTIONTYPECODE = 1 and @APPLICATIONCODE = 0 and @TRANSACTIONTYPECODE = 1 and @PAYMENTMETHODCODE = 205)))
set @RETURNVALUE = 3; --'AR'
else
if (@ISREVERSAL = 0 and @REVENUETRANSACTIONTYPECODE = 255 and @APPLICATIONCODE = 255 and @PAYMENTMETHODCODE = 255)
set @RETURNVALUE = 4; --'REVALUATION COMMITMENT GAIN/LOSS'
RETURN @RETURNVALUE
end