USP_DATAFORMTEMPLATE_EDIT_TRANSACTIONSELLPROPERTYADJUST_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	datetime	IN	Date of sale
@SALEAMOUNT	money	IN	Sale amount
@BROKERFEE	money	IN	Fees
@ADJUSTMENTDATE	datetime	IN	Adjustment date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjustment post date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment details
@POSTSTATUSCODE	tinyint	IN	GL post status
@POSTDATE	datetime	IN	GL post date
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_TRANSACTIONSELLPROPERTYADJUST_2
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @SALEDATE datetime,
                @SALEAMOUNT money,
                @BROKERFEE money,
                @ADJUSTMENTDATE datetime,
                @ADJUSTMENTPOSTDATE datetime,
                @ADJUSTMENTREASON nvarchar(300),
                @POSTSTATUSCODE tinyint,
                @POSTDATE datetime,
                @ADJUSTMENTREASONCODEID uniqueidentifier
            )
            as
            set nocount on;

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

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_TRANSACTIONSELLPROPERTYADJUST_2 
                @ID = @ID, 
                @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                @EXCHANGERATE = @EXCHANGERATE output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_TRANSACTIONSELLPROPERTYADJUST_3                
                @ID,
                @CHANGEAGENTID,
                @SALEDATE,
                @SALEAMOUNT,
                @BROKERFEE,
                @ADJUSTMENTDATE,
                @ADJUSTMENTPOSTDATE,
                @ADJUSTMENTREASON,
                @POSTSTATUSCODE,
                @POSTDATE,
                @ADJUSTMENTREASONCODEID,
                @BASEEXCHANGERATEID,
                @EXCHANGERATE;

            return 0;