USP_VENDOR_INFO_ADD

Adds additional information for a vendor

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@REMITADDRESSID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@CUSTOMERNUMBER	nvarchar(20)	IN
@PAYMENTTERMID	uniqueidentifier	IN
@PAYMENTMETHODCODE	tinyint	IN
@PAYMENTBANKACCOUNTID	uniqueidentifier	IN
@INCLUDEIN1099	bit	IN

Definition

Copy



CREATE procedure dbo.USP_VENDOR_INFO_ADD
(
  @ID uniqueidentifier
  ,@REMITADDRESSID uniqueidentifier = null
  ,@CHANGEAGENTID uniqueidentifier
  ,@CURRENTDATE datetime
  ,@CUSTOMERNUMBER nvarchar(20) = ''
  ,@PAYMENTTERMID uniqueidentifier = null
  ,@PAYMENTMETHODCODE tinyint = 0
  ,@PAYMENTBANKACCOUNTID uniqueidentifier = null
  ,@INCLUDEIN1099 bit = 0
)
as
begin
    insert into dbo.VENDOR
    (
    ID
    ,CUSTOMERNUMBER
    ,PAYMENTTERMID
    ,PAYMENTMETHODCODE
    ,INCLUDEIN1099
    ,TAXIDNUMBER
    ,REMITADDRESSID
    ,PAYMENTBANKACCOUNTID
    ,ADDEDBYID
    ,CHANGEDBYID
    ,DATEADDED
    ,DATECHANGED
  )
  values
  (
    @ID
    ,@CUSTOMERNUMBER
    ,@PAYMENTTERMID
    ,@PAYMENTMETHODCODE
    ,@INCLUDEIN1099
    ,''
    ,@REMITADDRESSID
    ,@PAYMENTBANKACCOUNTID
    ,@CHANGEAGENTID
    ,@CHANGEAGENTID
    ,@CURRENTDATE
    ,@CURRENTDATE
  );

  if @INCLUDEIN1099 = 1
    begin
      insert into dbo.VENDOR1099SETTING
      (
        ID
        ,CHECK1099BOX9
        ,CHECK10992TIN
        ,ADDEDBYID
        ,CHANGEDBYID
        ,DATEADDED
        ,DATECHANGED
      )
      values
      (
        @ID
        ,0
        ,0
        ,@CHANGEAGENTID
        ,@CHANGEAGENTID
        ,@CURRENTDATE
        ,@CURRENTDATE
      );
    end
end