USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEINVENTORYBATCHROW_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEQUENCE	int	IN
@ACTIONTYPECODE	tinyint	IN
@MERCHANDISEPRODUCTID	uniqueidentifier	IN
@MERCHANDISEPRODUCTINSTANCEID	uniqueidentifier	IN
@QUANTITY	int	IN
@COST	money	IN
@PRICE	money	IN
@VENDORID	uniqueidentifier	IN
@LOOKUPCODE	nvarchar(25)	IN
@MERCHANDISEADJUSTMENTREASONCODEID	uniqueidentifier	IN
@COMMENTS	nvarchar(255)	IN
@UPDATECURRENTCOST	money	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEINVENTORYBATCHROW_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEQUENCE int,
    @ACTIONTYPECODE tinyint,
    @MERCHANDISEPRODUCTID uniqueidentifier,
    @MERCHANDISEPRODUCTINSTANCEID uniqueidentifier,    
    @QUANTITY int,
    @COST money,
    @PRICE money,
    @VENDORID uniqueidentifier,
    @LOOKUPCODE nvarchar(25),
    @MERCHANDISEADJUSTMENTREASONCODEID uniqueidentifier,
    @COMMENTS nvarchar(255),
    @UPDATECURRENTCOST money
)
as
    set nocount on;

    declare @LOOKUPITEMS xml
    exec USP_DATAFORMTEMPLATE_EDITLOAD_MERCHANDISEINVENTORYBATCHROW
            @ID,
            @LOOKUPITEMS = @LOOKUPITEMS output

    exec USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEINVENTORYBATCHROW_3
            @ID,
            @CHANGEAGENTID,
            @SEQUENCE,
            @ACTIONTYPECODE,
            @MERCHANDISEPRODUCTID,
            @MERCHANDISEPRODUCTINSTANCEID,
            @QUANTITY,
            @COST,
            @PRICE,
            @VENDORID,
            @LOOKUPCODE,
            @MERCHANDISEADJUSTMENTREASONCODEID,
            @COMMENTS,
            @UPDATECURRENTCOST,
            @LOOKUPITEMS

    return 0;