USP_DATAFORMTEMPLATE_ADD_MERCHANDISEINVENTORYBATCHROW

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@BATCHID	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	bit	IN
@LOOKUPITEMS	xml	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MERCHANDISEINVENTORYBATCHROW
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @BATCHID uniqueidentifier,    
    @SEQUENCE int,
    @ACTIONTYPECODE tinyint = 0,
    @MERCHANDISEPRODUCTID uniqueidentifier = null,
    @MERCHANDISEPRODUCTINSTANCEID uniqueidentifier = null,    
    @QUANTITY int = null,
    @COST money = null,
    @PRICE money = null,
    @VENDORID uniqueidentifier = null,
    @LOOKUPCODE nvarchar(25) = null,
    @MERCHANDISEADJUSTMENTREASONCODEID uniqueidentifier = null,
    @COMMENTS nvarchar(255) = null,
    @UPDATECURRENTCOST bit = 1,
    @LOOKUPITEMS xml = null
)
as

    set nocount on;
    if @ID is null
        set @ID = newid();

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime = getdate();
    declare @CURRENTQUANTITY int;

    begin try    

        -- handle inserting the data
        insert into dbo.BATCHMERCHANDISEINVENTORY
            (ID, BATCHID, SEQUENCE, ACTIONTYPECODE, MERCHANDISEPRODUCTID, MERCHANDISEPRODUCTINSTANCEID, QUANTITY, COST, PRICE, VENDORID, LOOKUPCODE, MERCHANDISEADJUSTMENTREASONCODEID, COMMENTS, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, UPDATECURRENTCOST)
        values
            (@ID, @BATCHID, @SEQUENCE, @ACTIONTYPECODE, @MERCHANDISEPRODUCTID, @MERCHANDISEPRODUCTINSTANCEID, @QUANTITY, @COST, @PRICE, @VENDORID, coalesce(@LOOKUPCODE, ''), @MERCHANDISEADJUSTMENTREASONCODEID, coalesce(@COMMENTS, ''), @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, @UPDATECURRENTCOST);

        exec dbo.USP_BATCHMERCHANDISEINVENTORY_GETLOOKUPITEMS_ADDFROMXML @ID, @LOOKUPITEMS, @CHANGEAGENTID

    end try

    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0