MASTER_BarcodeSearchEx4
/** Object: StoredProcedure [dbo].[MASTER_Barcode_SearchEx4] Script Date: 20/03/2025 3:05:31 PM **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[MASTER_Barcode_SearchEx4]
(
@Barcode nvarchar(30) = ‘%’,
@BarcodeDescription nvarchar(100) = ‘%’,
@BranchId int
)
AS
SET NOCOUNT ON
SELECT TOP 500
BarcodeItemId,
BarcodeId,
Barcode,
BarcodeDescription,
BarcodeShortDescription,
BarcodeRetailPrice,
ISNULL(BIStockQty,0) BarcodeStockQty,
CASE BarcodeIsPrimary
WHEN ‘true’ THEN BUOM.UOMName
ELSE BUOM.UOMName + ‘ (‘ + CAST(CAST(BarcodeQuantity as float) as varchar) + ‘ ‘ + IUOM.UOMName + ‘)’
END AS Unit ,
BarcodeWholesalePrice
FROM
MASTER_Barcode
INNER JOIN MASTER_Item ON BarcodeItemId = ItemId
INNER JOIN MASTER_UnitOfMeasurement BUOM ON BarcodeUOMId = BUOM.UOMId
INNER JOIN MASTER_UnitOfMeasurement IUOM ON ItemPrimaryUOMId = IUOM.UOMId
LEFT OUTER JOIN MASTER_BranchItem ON BarcodeId = BIBarcodeId AND BIBranchId = @BranchId
WHERE
Barcode LIKE ‘%’ + @Barcode + ‘%’ AND
BarcodeDescription LIKE ‘%’ + @BarcodeDescription + ‘%’ AND
BarcodeIsActive = ‘true’ AND ItemIsActive = ‘true’ AND BarcodeIsScaleItem = ‘false’
GO
