PERTALIFE

??USE [MinovaES_Pertalife_Prod]

GO

/****** Object:  StoredProcedure [dbo].[PFILOINSERTASSETID]    Script Date: 17/05/2023 14.15.51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[PFILOINSERTASSETID]

(

	@AssetCode VARCHAR(20)

	,@AssetID VARCHAR(20)

	,@AssetIDExt VARCHAR(20)

	,@AssetSerialNumber VARCHAR(20)

	,@AcquisitionValue DECIMAL(18,0)

	,@RemainingValue DECIMAL(22,0)

	,@Location VARCHAR(20)

	,@UserID VARCHAR(20) 

)

AS

--DECLARE @AssetCode VARCHAR(20) = '00000002'

--DECLARE @AssetID VARCHAR(20) ='00000070'

--DECLARE @AssetIDExt VARCHAR(20) = '00020070'

--DECLARE @AssetSerialNumber VARCHAR(20) = '00020070'

--DECLARE @AcquisitionValue DECIMAL(18,0) = '0'

--DECLARE @RemainingValue DECIMAL(22,0) = 0

--DECLARE @Location VARCHAR(20) = ''

--DECLARE @UserID VARCHAR(20) = 'Ade'

DECLARE @now VARCHAR(20) = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd')

DECLARE @now16 VARCHAR(20) = dbo.fn_formatdatetime(GETDATE(), 'yyyymmddhhmmss')

INSERT INTO dbo.PMDAST0002

SELECT DISTINCT @AssetID AS AssetID

				,'' AS ExternalID

				,@AssetSerialNumber AS SerialNumber

				,astcode.AssetName

				,@AssetCode AS AssetCode

				,'' AS GLAccount

				,@now AS StartDate

				,'99991231' AS EndDate

				,astcode.AssetType

				,astcode.CompanyID

				,astcode.BusinessUnit

				,@AcquisitionValue AS AcquisitionValue ----astcode.AcquisitionValue

				,astcode.AcquisitionDate

				,astcode.DepreciationPeriod

				,astcode.Depreciation AS DepreciationValue

				,astcode.DepreciationMethod

				,ISNULL(@RemainingValue,0) AS RemainingValue

				,@Location AS Location

				,astcode.PIC

				,astcode.VendorID AS Vendor

				,astcode.ContactSupport

				,@UserID AS CreatedBy

				,@now16 AS CreatedDate

				,@UserID AS ChangeBy

				,@now16 AS CreateDate

				,'' AS Rent

				,'' AS PoliceNumber

FROM PMDAST0001 AS astcode

WHERE astcode.AssetCode = @AssetCode

SELECT DISTINCT * FROM dbo.PMDAST0002