IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'supplierLegalEntity')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [supplierLegalEntity] NVARCHAR(200) NULL
END

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
	TABLE_NAME = 'publ_PurchaseOrders' AND
	COLUMN_NAME = 'quoteNumber')
BEGIN
	ALTER TABLE	[dbo].[publ_PurchaseOrders]
		ADD [quoteNumber] NVARCHAR(32) NULL
END

