USP_DATAFORMTEMPLATE_ADJUST_STOCKSALE_2

Stored procedure used to save on the payment add form.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SALEDATE	date	IN	Date of sale
@SALEAMOUNT	money	IN	Sale amount
@FEE	money	IN	Fees
@NUMBEROFUNITS	decimal(20, 3)	IN	Units sold
@LOWPRICE	decimal(19, 4)	IN	Low
@MEDIANPRICE	decimal(19, 4)	IN	Median
@HIGHPRICE	decimal(19, 4)	IN	High
@ADJUSTMENTPOSTDATE	datetime	IN	Adjustment post date
@ADJUSTMENTDATE	datetime	IN	Adjustment date
@ADJUSTMENTREASON	nvarchar(100)	IN	Adjustment details
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADJUST_STOCKSALE_2
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @SALEDATE date,
                @SALEAMOUNT money,
                @FEE money,
                @NUMBEROFUNITS decimal(20,3),
                @LOWPRICE decimal(19,4),
                @MEDIANPRICE decimal(19,4),
                @HIGHPRICE decimal(19,4),
                @ADJUSTMENTPOSTDATE datetime,
                @ADJUSTMENTDATE datetime,
                @ADJUSTMENTREASON nvarchar(100),
                @ADJUSTMENTREASONCODEID uniqueidentifier
            )
            as
            set nocount on;

            declare @BASEEXCHANGERATEID uniqueidentifier;
            declare @EXCHANGERATE decimal(20,8);

            exec dbo.USP_DATAFORMTEMPLATE_ADJUSTLOAD_STOCKSALE_2 
                @ID, 
                @BASEEXCHANGERATEID output,
                @EXCHANGERATE output;

            exec dbo.USP_DATAFORMTEMPLATE_ADJUST_STOCKSALE_3
                @ID,
                @CHANGEAGENTID,
                @SALEDATE,
                @SALEAMOUNT,
                @FEE,
                @NUMBEROFUNITS,
                @LOWPRICE,
                @MEDIANPRICE,
                @HIGHPRICE,
                @ADJUSTMENTPOSTDATE,
                @ADJUSTMENTDATE,
                @ADJUSTMENTREASON,
                @ADJUSTMENTREASONCODEID,
                @BASEEXCHANGERATEID,
                @EXCHANGERATE;

            return 0;