USP_DATAFORMTEMPLATE_ADD_DISCOUNTADJUSTABLE_PRELOAD

The load procedure used by the edit dataform template "Discount Adjustable Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SALESORDERADJUSTABLEDISCOUNTID	uniqueidentifier	INOUT	Sales order adjustable discount ID
@CALCULATIONTYPECODE	int	INOUT	Calculation type
@PERCENT	decimal(5, 2)	INOUT	Value
@AMOUNT	money	INOUT	Value
@DISCOUNTREASONCODEID	uniqueidentifier	INOUT	Reason
@ADJUSTABLEDISCOUNTALREADYONORDER	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DISCOUNTADJUSTABLE_PRELOAD
                (
                    @SALESORDERID uniqueidentifier,                    
                    @SALESORDERADJUSTABLEDISCOUNTID uniqueidentifier = null output,
                    @CALCULATIONTYPECODE integer = null output,
                    @PERCENT decimal(5,2) = null output,
                    @AMOUNT money = null output,
                    @DISCOUNTREASONCODEID uniqueidentifier = null output,
                    @ADJUSTABLEDISCOUNTALREADYONORDER bit = null output

                )
                as
                    set nocount on;

                    select
                        @SALESORDERADJUSTABLEDISCOUNTID = ID,
                        @CALCULATIONTYPECODE = CALCULATIONTYPECODE,
                        @PERCENT = [PERCENT],
                        @AMOUNT = AMOUNT,
                        @DISCOUNTREASONCODEID = DISCOUNTREASONCODEID,
                        @ADJUSTABLEDISCOUNTALREADYONORDER = 1
                    from
                        dbo.SALESORDERADJUSTABLEDISCOUNT
                    where
                        SALESORDERID = @SALESORDERID

                    if @SALESORDERADJUSTABLEDISCOUNTID is null
                        begin
                            set @ADJUSTABLEDISCOUNTALREADYONORDER = 0
                            set @SALESORDERADJUSTABLEDISCOUNTID = newid()
                        end

                    return 0;