USP_ADD_INVOICE_VENDOR_PRELOAD

The load procedure used by the edit 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.
@VENDORID	uniqueidentifier	INOUT	Vendor
@DISCOUNTTOTAL	money	INOUT	Amount after discount
@DISCOUNTPERCENT	numeric(20, 4)	INOUT	Discount percent
@REMITADDRESSID	uniqueidentifier	INOUT	Remit to address

Definition

Copy



CREATE procedure dbo.USP_ADD_INVOICE_VENDOR_PRELOAD
(
    @CONTEXTID uniqueidentifier
    ,@VENDORID uniqueidentifier = null output
  ,@DISCOUNTTOTAL money = null output -- Because the platform complains since this is a readonly.

  ,@DISCOUNTPERCENT numeric(20,4) = null output
  ,@REMITADDRESSID uniqueidentifier = null output
)
as
    set nocount on;
    set @VENDORID = @CONTEXTID;    

  select
    @DISCOUNTPERCENT = DISCOUNTPERCENT
    ,@REMITADDRESSID = v.REMITADDRESSID
  from dbo.PAYMENTTERM pt
       inner join dbo.VENDOR v on pt.ID = v.PAYMENTTERMID
     where v.ID = @CONTEXTID;