USP_DATAFORMTEMPLATE_EDIT_STOCKSALE

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	datetime	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
@SALEPOSTDATE	datetime	IN	GL post date
@SALEPOSTSTATUSCODE	tinyint	IN	GL post status

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_STOCKSALE
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @SALEDATE datetime,
                @SALEAMOUNT money,
                @FEE money,
                @NUMBEROFUNITS decimal(20,3),
                @LOWPRICE decimal(19,4),
                @MEDIANPRICE decimal(19,4),
                @HIGHPRICE decimal(19,4),
                @SALEPOSTDATE datetime,
                @SALEPOSTSTATUSCODE tinyint
            )
            as
            set nocount on;

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

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

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_STOCKSALE_2
                @ID,
                @CHANGEAGENTID,
                @SALEDATE,
                @SALEAMOUNT,
                @FEE,
                @NUMBEROFUNITS,
                @LOWPRICE,
                @MEDIANPRICE,
                @HIGHPRICE,
                @SALEPOSTDATE,
                @SALEPOSTSTATUSCODE,
                @BASEEXCHANGERATEID,
                @EXCHANGERATE;

            return 0;