USP_DATAFORMTEMPLATE_EDITLOAD_MERCHANDISEINVENTORYBATCHROW

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SEQUENCE	int	INOUT
@ACTIONTYPECODE	tinyint	INOUT
@MERCHANDISEPRODUCTID	uniqueidentifier	INOUT
@MERCHANDISEPRODUCTINSTANCEID	uniqueidentifier	INOUT
@SKU	nvarchar(24)	INOUT
@QUANTITY	int	INOUT
@COST	money	INOUT
@PRICE	money	INOUT
@VENDORID	uniqueidentifier	INOUT
@LOOKUPCODE	nvarchar(25)	INOUT
@MERCHANDISEADJUSTMENTREASONCODEID	uniqueidentifier	INOUT
@COMMENTS	nvarchar(255)	INOUT
@CURRENTQUANTITY	int	INOUT
@UPDATECURRENTCOST	bit	INOUT
@LOOKUPITEMS	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MERCHANDISEINVENTORYBATCHROW
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @SEQUENCE int = null output,
    @ACTIONTYPECODE tinyint = null output,
    @MERCHANDISEPRODUCTID uniqueidentifier = null output,
    @MERCHANDISEPRODUCTINSTANCEID uniqueidentifier = null output,    
    @SKU nvarchar(24) = null output,
    @QUANTITY int = null output,
    @COST money = null output,
    @PRICE money = null output,
    @VENDORID uniqueidentifier = null output,
    @LOOKUPCODE nvarchar(25) = null output,
    @MERCHANDISEADJUSTMENTREASONCODEID uniqueidentifier = null output,
    @COMMENTS nvarchar(255) = null output,
    @CURRENTQUANTITY integer = null output,
    @UPDATECURRENTCOST bit = null output,
    @LOOKUPITEMS xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = BATCHMERCHANDISEINVENTORY.TSLONG,
        @SEQUENCE = BATCHMERCHANDISEINVENTORY.SEQUENCE,
        @ACTIONTYPECODE = BATCHMERCHANDISEINVENTORY.ACTIONTYPECODE,
        @MERCHANDISEPRODUCTID = BATCHMERCHANDISEINVENTORY.MERCHANDISEPRODUCTID,
        @MERCHANDISEPRODUCTINSTANCEID = BATCHMERCHANDISEINVENTORY.MERCHANDISEPRODUCTINSTANCEID,
        @SKU = coalesce(MERCHANDISEPRODUCTINSTANCE.BARCODE, ''),
        @QUANTITY = BATCHMERCHANDISEINVENTORY.QUANTITY,
        @COST = BATCHMERCHANDISEINVENTORY.COST,
        @PRICE = BATCHMERCHANDISEINVENTORY.PRICE,
        @VENDORID = BATCHMERCHANDISEINVENTORY.VENDORID,
        @LOOKUPCODE = BATCHMERCHANDISEINVENTORY.LOOKUPCODE,
        @MERCHANDISEADJUSTMENTREASONCODEID = BATCHMERCHANDISEINVENTORY.MERCHANDISEADJUSTMENTREASONCODEID,
        @COMMENTS = BATCHMERCHANDISEINVENTORY.COMMENTS,
        @CURRENTQUANTITY = coalesce(MERCHANDISEPRODUCTINSTANCE.ONHANDQUANTITY, 0),
        @UPDATECURRENTCOST = BATCHMERCHANDISEINVENTORY.UPDATECURRENTCOST,
        @LOOKUPITEMS = dbo.UFN_BATCHMERCHANDISEINVENTORY_GETLOOKUPITEMS_TOITEMLISTXML(@ID)
    from dbo.BATCHMERCHANDISEINVENTORY
    left outer join dbo.MERCHANDISEPRODUCTINSTANCE
        on BATCHMERCHANDISEINVENTORY.MERCHANDISEPRODUCTINSTANCEID = MERCHANDISEPRODUCTINSTANCE.ID
    where BATCHMERCHANDISEINVENTORY.ID = @ID;

    return 0;