USP_DATALIST_MERCHANDISEPRODUCTBULKLABEL

Provides inventory items for bulk printing and exporting of SKUs..

Parameters

Parameter	Parameter Type	Mode	Description
@MERCHANDISEQUERYID	uniqueidentifier	INOUT	Merchandise query ID
@MERCHANDISEPRODUCTID	uniqueidentifier	INOUT	Merchandise product ID
@INCLUDEINACTIVE	bit	INOUT	Include inactive
@INCLUDEZEROQUANTITY	bit	INOUT	Include zero quantity

Definition

Copy



CREATE procedure dbo.USP_DATALIST_MERCHANDISEPRODUCTBULKLABEL(
    @MERCHANDISEQUERYID uniqueidentifier = null output,
    @MERCHANDISEPRODUCTID uniqueidentifier = null output,
    @INCLUDEINACTIVE bit = null output,
    @INCLUDEZEROQUANTITY bit = null output
)
as
    set nocount on;

    select
        ID,
        ITEMDETAILS,
        BARCODE,
        ONHANDQUANTITY,
        QUANTITYTOPRINT,
        SALEPRICE
    from    
    dbo.UFN_MERCHANDISE_GETPRODUCTLABELSTOBULKPRINT(@MERCHANDISEQUERYID, @MERCHANDISEPRODUCTID, @INCLUDEINACTIVE, @INCLUDEZEROQUANTITY)
    order by
        ITEMDETAILS