USP_DATAFORMTEMPLATE_EDIT_PAYABLES_VENDOR

The save procedure used by the edit dataform template "Payables Vendor Edit 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.
@CUSTOMERNUMBER	nvarchar(20)	IN	Customer number
@PAYMENTTERMID	uniqueidentifier	IN	Payment terms
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@INCLUDEIN1099	bit	IN	Include in 1099 reporting

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAYABLES_VENDOR
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CUSTOMERNUMBER nvarchar(20),
    @PAYMENTTERMID uniqueidentifier,
    @PAYMENTMETHODCODE tinyint,
    @INCLUDEIN1099 bit
)
as

    set nocount on;

  declare @CURRENTDATE datetime;

    begin try

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

    set @CURRENTDATE = getdate();

        -- handle updating the data

        update dbo.VENDOR set
            CUSTOMERNUMBER = @CUSTOMERNUMBER,
            PAYMENTTERMID = @PAYMENTTERMID,
            PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
            INCLUDEIN1099 = @INCLUDEIN1099,
            CHANGEDBYID = @CHANGEAGENTID,
                  DATECHANGED = @CURRENTDATE
        where ID = @ID;

    if @INCLUDEIN1099 = 1
    begin
      if not EXISTS(SELECT ID FROM dbo.VENDOR1099SETTING where ID = @ID)
        insert into dbo.VENDOR1099SETTING
          (ID, CHECK1099BOX9, CHECK10992TIN, NAMEFIRSTLINEALIASTYPECODEID, NAMESECONDLINEALIASTYPECODEID, ADDRESSID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values
          (@ID, 0, 0, null, null, null, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
    end
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

return 0;