USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMREVENUESCHEDULE

The save procedure used by the edit dataform template "Sales Order Item Revenue Schedule Payment Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@AUTOPAY	bit	IN	Pay automatically by:
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@CARDHOLDERNAME	nvarchar(255)	IN	Name on card
@CREDITTYPECODEID	uniqueidentifier	IN	Card type
@CREDITCARDNUMBER	nvarchar(20)	IN	Card number
@EXPIRESON	UDT_FUZZYDATE	IN	Expires on
@CREDITCARDTOKEN	uniqueidentifier	IN	Card token
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@REFERENCENUMBER	nvarchar(20)	IN	Reference number
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMREVENUESCHEDULE (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @AUTOPAY bit,
    @PAYMENTMETHODCODE tinyint,
    @CARDHOLDERNAME nvarchar(255),
    @CREDITTYPECODEID uniqueidentifier,
    @CREDITCARDNUMBER nvarchar(20),
    @EXPIRESON dbo.UDT_FUZZYDATE,
    @CREDITCARDTOKEN uniqueidentifier,
    @REFERENCEDATE dbo.UDT_FUZZYDATE,
    @REFERENCENUMBER nvarchar(20),
    @CONSTITUENTACCOUNTID uniqueidentifier
)
as
    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        update dbo.SALESORDERITEMREVENUESCHEDULE set
            AUTOPAY = @AUTOPAY,
            PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
            CARDHOLDERNAME = @CARDHOLDERNAME,
            CREDITTYPECODEID = @CREDITTYPECODEID,
            CREDITCARDPARTIALNUMBER = @CREDITCARDNUMBER,
            EXPIRESON = @EXPIRESON,
            CREDITCARDTOKEN = @CREDITCARDTOKEN,
            REFERENCEDATE = @REFERENCEDATE,
            REFERENCENUMBER = @REFERENCENUMBER,
            CONSTITUENTACCOUNTID = @CONSTITUENTACCOUNTID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;