USP_DATAFORMTEMPLATE_ADD_RECEIVABLEPAYMENTINDIVIDUAL

The save procedure used by the add dataform template "Payment Add to Individual Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@STUDENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	IN	Paid by
@AMOUNT	money	IN	Amount
@PAYMENTDATE	datetime	IN	Payment date
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@CHECKDATE	UDT_FUZZYDATE	IN	Check date
@CHECKNUMBER	nvarchar(20)	IN	Check number
@REFERENCENUMBER	nvarchar(20)	IN	Reference number
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@CARDHOLDERNAME	nvarchar(255)	IN	Name on card
@CREDITCARDNUMBER	nvarchar(20)	IN	Card number
@CREDITTYPECODEID	uniqueidentifier	IN	Card type
@EXPIRESON	UDT_FUZZYDATE	IN	Expires on
@AUTHORIZATIONCODE	nvarchar(20)	IN	Authorization code
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN	Result code
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other method
@APPLICATIONS	xml	IN	Applications

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RECEIVABLEPAYMENTINDIVIDUAL
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @STUDENTID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier = null,
                        @AMOUNT money = 0,
                        @PAYMENTDATE datetime = null,
                        @POSTSTATUSCODE tinyint = 1,
                        @POSTDATE datetime = null,
                        @PAYMENTMETHODCODE tinyint = 1,
                        @CONSTITUENTACCOUNTID uniqueidentifier = null,
                        @CHECKDATE dbo.UDT_FUZZYDATE = '00000000',
                        @CHECKNUMBER nvarchar(20) = null,
                        @REFERENCENUMBER nvarchar(20) = null,
                        @REFERENCEDATE dbo.UDT_FUZZYDATE = '00000000',
                        @CARDHOLDERNAME nvarchar(255) = null,
                        @CREDITCARDNUMBER nvarchar(20) = null,
                        @CREDITTYPECODEID uniqueidentifier = null,
                        @EXPIRESON dbo.UDT_FUZZYDATE = '00000000',
                        @AUTHORIZATIONCODE nvarchar(20) = null,
                        @DIRECTDEBITRESULTCODE nvarchar(10) = null,
                        @OTHERPAYMENTMETHODCODEID uniqueidentifier = null,
                        @APPLICATIONS xml = null
                    )
                    as
                        set nocount on;

                        if @ID is null
                            set @ID = newid();

                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        begin try

                            declare @CREDITCARDPARTIALNUMBER nvarchar(4);

                            if (len(@CREDITCARDNUMBER) > 4)
                            begin
                                set @CREDITCARDPARTIALNUMBER = right(@CREDITCARDNUMBER, 4);
                            end
                            else
                            begin
                                set @CREDITCARDPARTIALNUMBER = @CREDITCARDNUMBER;
                            end

                            exec dbo.USP_RECEIVABLEPAYMENT_ADD
                                @ID,
                                @CHANGEAGENTID,
                                @CONSTITUENTID,
                                @AMOUNT,
                                @PAYMENTDATE,
                                @POSTSTATUSCODE,
                                @POSTDATE,
                                @PAYMENTMETHODCODE,
                                @CONSTITUENTACCOUNTID,
                                @CHECKDATE,
                                @CHECKNUMBER,
                                @REFERENCEDATE,
                                @REFERENCENUMBER,
                                @CARDHOLDERNAME,
                                @CREDITCARDPARTIALNUMBER,
                                @CREDITTYPECODEID,
                                @EXPIRESON,
                                @AUTHORIZATIONCODE,
                                @DIRECTDEBITRESULTCODE,
                                @OTHERPAYMENTMETHODCODEID,
                                null, -- RECEIVABLEPAYMENTID

                                @STUDENTID,
                                @APPLICATIONS;

                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;