USP_DATAFORMTEMPLATE_EDIT_TRANSACTIONSELLPROPERTY

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
@BROKERFEE	money	IN	Fees
@POSTSTATUSCODE	tinyint	IN	GL post status
@POSTDATE	datetime	IN	GL post date

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_TRANSACTIONSELLPROPERTY
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @SALEDATE datetime,
                @SALEAMOUNT money,
                @BROKERFEE money,
                @POSTSTATUSCODE tinyint,
                @POSTDATE datetime
            )
            as
            set nocount on;

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

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

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_TRANSACTIONSELLPROPERTY_2
                @ID,
                @CHANGEAGENTID,
                @SALEDATE,
                @SALEAMOUNT,
                @BROKERFEE,
                @POSTSTATUSCODE,
                @POSTDATE,
                @BASEEXCHANGERATEID,
                @EXCHANGERATE;

            return 0;