USP_DATAFORMTEMPLATE_VIEW_VENDORPAYMENTTERM

The load procedure used by the view dataform template "Vendor Payment Term View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PAYMENTTERMID	uniqueidentifier	INOUT	Payment term ID
@INCLUDEDISCOUNT	bit	INOUT	Include discount
@DISCOUNTPERCENT	decimal(20, 4)	INOUT	Discount percent
@DISCOUNTDAYS	smallint	INOUT	Discount days
@PAYMENTDUECODE	tinyint	INOUT	Payment due
@DAYSDUE	smallint	INOUT	Number of days
@DAYOFMONTHDUE	smallint	INOUT	Day of month due
@MONTHDUECODE	smallint	INOUT	Month due

Definition

Copy



                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_VENDORPAYMENTTERM
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @PAYMENTTERMID uniqueidentifier = null output,
                    @INCLUDEDISCOUNT bit = null output,
                    @DISCOUNTPERCENT decimal(20,4) = null output,
                    @DISCOUNTDAYS smallint = null output,
                    @PAYMENTDUECODE tinyint = null output,
                    @DAYSDUE smallint = null output,
                    @DAYOFMONTHDUE smallint = null output,
                    @MONTHDUECODE smallint = null output
                )
                as
                    set nocount on;

                    -- Always setting this to 1 because it is possible this sql doesn't return

                    -- any rows.  In this case we will checkt to see if 

                    set @DATALOADED = 1;

                    select @DATALOADED = 1,
                           @PAYMENTTERMID = PAYMENTTERMID,
                           @INCLUDEDISCOUNT = INCLUDEDISCOUNT,
                           @DISCOUNTPERCENT = DISCOUNTPERCENT,
                           @DISCOUNTDAYS = DISCOUNTDAYS,
                           @PAYMENTDUECODE = PAYMENTDUECODE,
                           @DAYSDUE = DAYSDUE,
                           @DAYOFMONTHDUE = DAYOFMONTHDUE,
                           @MONTHDUECODE = MONTHDUECODE
                    from dbo.PAYMENTTERM pt
                    inner join dbo.VENDOR pv on pt.ID = pv.PAYMENTTERMID
                    where pv.ID = @ID 

                return 0;