Item Barcode Translation Script

DataCollection uses a custom SQL procedure/view to translate item barcodes into item numbers for handheld operations. DataCollection 3.1 and older uses a custom view (dccvItemBarcode) to translate item barcodes. Example:

GO
CREATE VIEW [dbo].[dccvItemBarcode] AS
SELECT Item_Number = i.ITEMNMBR
,Barcode = i.ITMSHNAM FROM IV00101 AS i(NOLOCK)
GO

DataCollection 4 uses a custom procedure (dccpItemBarcode_Update) to translate item barcodes. @Barcode parameter is passed in to the procedure in order to retrieve a matching item number. Example:

GO
CREATE PROCEDURE [dbo].[dccpItemBarcode_Update] @Barcode AS VARCHAR(100) = NULL
AS
SELECT TOP 1 Item_Number = im.ITEMNMBR
,Barcode = im.ITMSHNAM FROM IV00101 AS im
WHERE im.ITMSHNAM = @Barcode GO