UFN_PDACCOUNT_GETCAMPAIGN
Returns Campaign 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_GETCAMPAIGN
(@REVENUESPLITID as uniqueidentifier,
@REVENUETRANSACTIONTYPECODE as tinyint,
@APPLICATIONCODE tinyint,
@PAYMENTMETHODCODE as tinyint,
@DESIGNATIONID as uniqueidentifier) returns uniqueidentifier
As
begin
declare @RESULT as uniqueidentifier
select @RESULT = T1.CAMPAIGNID from DESIGNATIONCAMPAIGN T1
inner join REVENUESPLIT T2 on T1.DESIGNATIONID=T2.DESIGNATIONID
where T2.ID = @REVENUESPLITID
return @RESULT
end