
UPDATE [Framework_REAP-1].[dbo].[pal_SurfaceField]
SET surfaceFieldTypeId = 3, lookupCategory = 0, relationalFields = '', relationalValues = '', relationalOrderBy = '', 
relationalSurface = '', relationalObject = 'oSurafece', action = 0, actionSource = 0
WHERE surfaceFieldName like '%PromotionItems_PromotionItem_Variant%';