UFN_MERCHANDISE_GETPRODUCTLABELSTOBULKPRINT

Returns inventory item label inventory information.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@MERCHANDISEQUERYID	uniqueidentifier	IN
@MERCHANDISEPRODUCTID	uniqueidentifier	IN
@INCLUDEINACTIVE	bit	IN
@INVLUDEZEROQUANTITY	bit	IN

Definition

Copy



CREATE function dbo.UFN_MERCHANDISE_GETPRODUCTLABELSTOBULKPRINT
(
    @MERCHANDISEQUERYID uniqueidentifier,
    @MERCHANDISEPRODUCTID uniqueidentifier,
    @INCLUDEINACTIVE bit,
    @INVLUDEZEROQUANTITY bit

)
returns table as
  return
    select
        MERCHANDISEPRODUCTINSTANCE.ID,
        MERCHANDISEPRODUCTINSTANCE.ITEMDETAILS,
        MERCHANDISEPRODUCTINSTANCE.BARCODE,
        MERCHANDISEPRODUCTINSTANCE.ONHANDQUANTITY,
        MERCHANDISEPRODUCTINSTANCE.SALEPRICE,
        0 QUANTITYTOPRINT
    from
        dbo.MERCHANDISEPRODUCTINSTANCE inner join dbo.MERCHANDISEPRODUCT on
            MERCHANDISEPRODUCTINSTANCE.MERCHANDISEPRODUCTID = MERCHANDISEPRODUCT.ID
    where
        (@MERCHANDISEQUERYID is null or MERCHANDISEPRODUCTINSTANCE.MERCHANDISEPRODUCTID in (select [ID] from dbo.UFN_IDSETREADER_GETRESULTS_GUID(@MERCHANDISEQUERYID))) and
        (@MERCHANDISEPRODUCTID is null or MERCHANDISEPRODUCTINSTANCE.MERCHANDISEPRODUCTID = @MERCHANDISEPRODUCTID) and
        (@INCLUDEINACTIVE = 1 or MERCHANDISEPRODUCTINSTANCE.ISACTIVE = 1) and
        (@INCLUDEINACTIVE = 1 or MERCHANDISEPRODUCT.ISACTIVE = 1) and
        (@INVLUDEZEROQUANTITY = 1 or MERCHANDISEPRODUCTINSTANCE.ONHANDQUANTITY > 0)