USP_DATAFORMTEMPLATE_ADD_INVOICE_VENDOR

The save procedure used by the add dataform template "Specific Vendor Invoice Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@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.
@VENDORID	uniqueidentifier	IN	Vendor
@NUMBER	nvarchar(60)	IN	Invoice number
@DATEDUE	datetime	IN	Due date
@PURCHASEORDERID	nvarchar(20)	IN	PO number
@AMOUNT	money	IN	Invoice amount
@DATE	datetime	IN	Invoice date
@REMITADDRESSID	uniqueidentifier	IN	Remit to address
@DISCOUNTPERCENT	numeric(20, 4)	IN	Discount percent
@DISCOUNTAMOUNT	money	IN	Discount amount
@DISCOUNTEXPIRATIONDATE	datetime	IN	Discount expiration date
@SEPARATEPAYMENT	bit	IN	Create a separate disbursement for this invoice
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@POSTDATE	datetime	IN	Post date
@POSTSTATUSCODE	tinyint	IN	Post status
@BANKACCOUNTID	nvarchar(60)	IN	Bank account
@FINANCIALTRANSACTION1099DISTRIBUTIONS	xml	IN	1099 distribution
@DESCRIPTION	nvarchar(100)	IN	Invoice description
@LINEITEMS	xml	IN	Line items

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_INVOICE_VENDOR
(
  @CONTEXTID uniqueidentifier,
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
    @VENDORID uniqueidentifier = null,
    @NUMBER nvarchar(60) = '',
  @DATEDUE datetime = null,
  @PURCHASEORDERID nvarchar(20) = '',
  @AMOUNT money = 0,
    @DATE datetime = null,
  @REMITADDRESSID uniqueidentifier = null,
  @DISCOUNTPERCENT numeric(20,4) = 0,
  @DISCOUNTAMOUNT money = 0,
  @DISCOUNTEXPIRATIONDATE datetime = null,
  @SEPARATEPAYMENT bit = 0,
  @PAYMENTMETHODCODE tinyint = 1,
  @POSTDATE datetime = null,
  @POSTSTATUSCODE tinyint = 1,
  @BANKACCOUNTID nvarchar(60) = '',
  @FINANCIALTRANSACTION1099DISTRIBUTIONS xml = null,
  @DESCRIPTION nvarchar(100) = ''
    ,@LINEITEMS xml = null
)
as

  set nocount on;
  set @CONTEXTID = @VENDORID;

  exec USP_DATAFORMTEMPLATE_ADD_INVOICE 
    @ID
    ,@CHANGEAGENTID
    ,@VENDORID
    ,@NUMBER
    ,@DATEDUE
    ,@PURCHASEORDERID
    ,@AMOUNT
    ,@DATE
    ,@REMITADDRESSID
    ,@DISCOUNTPERCENT
    ,@DISCOUNTAMOUNT
    ,@DISCOUNTEXPIRATIONDATE
    ,@SEPARATEPAYMENT
    ,@PAYMENTMETHODCODE
    ,@POSTDATE
    ,@POSTSTATUSCODE
    ,@BANKACCOUNTID
    ,@FINANCIALTRANSACTION1099DISTRIBUTIONS
    ,@DESCRIPTION
        ,@LINEITEMS;

return 0;