UFN_PDACCOUNT_GETCHANNELCODE
Returns Channel 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_GETCHANNELCODE
(@REVENUESPLITID as uniqueidentifier,
@REVENUETRANSACTIONTYPECODE as tinyint,
@APPLICATIONCODE tinyint,
@PAYMENTMETHODCODE as tinyint,
@DESIGNATIONID as uniqueidentifier) returns uniqueidentifier
As
begin
declare @RESULT as uniqueidentifier
select @RESULT = CHANNELCODEID from REVENUE T1
inner join REVENUESPLIT T2 on T1.ID = T2.REVENUEID
where T2.ID = @REVENUESPLITID
return @RESULT
end