UFN_PDACCOUNT_GETREVENUECATEGORY
Returns Revenue Category ID for transaction being generated.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUESPLITID | uniqueidentifier | IN | |
| @REVENUETRANSACTIONTYPECODE | tinyint | IN | |
| @APPLICATIONCODE | tinyint | IN | |
| @PAYMENTMETHODCODE | tinyint | IN | |
| @DESIGNATIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PDACCOUNT_GETREVENUECATEGORY
(@REVENUESPLITID as uniqueidentifier,
@REVENUETRANSACTIONTYPECODE as tinyint,
@APPLICATIONCODE tinyint,
@PAYMENTMETHODCODE as tinyint,
@DESIGNATIONID as uniqueidentifier) returns uniqueidentifier
As
begin
declare @RESULT as uniqueidentifier
select @RESULT = GLREVENUECATEGORYMAPPINGID
from REVENUECATEGORY
where ID = @REVENUESPLITID
RETURN @RESULT
end