ALTER TABLE dbo.VS4TJobProdMat
	DROP CONSTRAINT IF EXISTS TMteTJPdNo
GO
ALTER TABLE dbo.VS4TJobProdMat ADD CONSTRAINT
	PK_VS4TJobProdMat PRIMARY KEY CLUSTERED 
	(
	TMteTJPdNo,
	TMteLn,
	TMteStep
	) ON [PRIMARY]
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteMaterialCode', N'TMteProductCode', 'COLUMN'
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteMaterialName', N'TMteProductName', 'COLUMN'
GO
ALTER TABLE VS4TJobProdMat
	DROP COLUMN TMteQtyEngine,TMteQtyEngine2,TMteQtyEngine3,TMteSerialNo,TMteStatusUsed,TMteRevision
GO
ALTER TABLE VS4TJobProdMat ADD
	TMteUseStock float(53) NULL,
	TMteUseStock2 float(53) NULL,
	TMteUseStock3 float(53) NULL,
	TMteUseOrder float(53) NULL,
	TMteUseOrder2 float(53) NULL,
	TMteUseOrder3 float(53) NULL
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteQuantityTrans', N'TMteTotalUsed', 'COLUMN'
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteQuantityNet ', N'TMteTotalDif', 'COLUMN'
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteQuantityTrans2', N'TMteTotalUsed2', 'COLUMN'
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteQuantityNet2 ', N'TMteTotalDif2', 'COLUMN'
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteQuantityTrans3', N'TMteTotalUsed3', 'COLUMN'
GO
EXECUTE sp_rename N'VS4TJobProdMat.TMteQuantityNet3', N'TMteTotalDif3', 'COLUMN'
GO

