USP_EVENT_ADDPAYMENT
Adds a payment for an event registration.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @APPLICATIONID | uniqueidentifier | IN | |
| @APPLIEDAMOUNT | money | IN | |
| @CREATIONDATE | datetime | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @APPLIEDBASEAMOUNT | money | IN | |
| @APPLIEDORGANIZATIONAMOUNT | money | IN | |
| @CATEGORYCODEID | uniqueidentifier | IN | |
| @BUSINESSUNITSAPPLIED | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_EVENT_ADDPAYMENT
(
@REVENUEID uniqueidentifier,
@APPLICATIONID uniqueidentifier,
@APPLIEDAMOUNT money,
@CREATIONDATE datetime = null,
@CHANGEAGENTID uniqueidentifier = null,
@APPLIEDBASEAMOUNT money = null,
@APPLIEDORGANIZATIONAMOUNT money = null,
@CATEGORYCODEID uniqueidentifier = null,
@BUSINESSUNITSAPPLIED bit = 0
)
as
set nocount on
declare @CMAPAIGNXML as xml =null
exec dbo.USP_EVENT_ADDPAYMENT_1_1 @REVENUEID,
@APPLICATIONID,
@APPLIEDAMOUNT,
@CREATIONDATE,
@CHANGEAGENTID ,
@APPLIEDBASEAMOUNT,
@APPLIEDORGANIZATIONAMOUNT,
@CATEGORYCODEID,
@BUSINESSUNITSAPPLIED,
@CMAPAIGNXML