ALTER PROCEDURE [dbo].[PDSFILOPRODGENLOT]
(
	 @ProductionCode VARCHAR(50),
	 @MachineNumber VARCHAR(100),
	 @Shift VARCHAR(100),
	 @DocDate VARCHAR(50)
)
AS

--DECLARE @ProductionCode VARCHAR(50) = 'C'
--DECLARE @MachineNumber VARCHAR(100) = '02'
--DECLARE @Shift VARCHAR(100) = '3'
--DECLARE @DocDate VARCHAR(50) = '20240109'

DECLARE @Lot VARCHAR(100)

SET @Lot = @ProductionCode + RIGHT(@DocDate,2) + SUBSTRING(@DocDate,5,2) + SUBSTRING(@DocDate, 4,1) + @Shift + @MachineNumber

SELECT @Lot AS Lot