
update pal_SurfaceField
set [sequence] = 5, gridSequence = 5
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_UnitPrice'

update pal_SurfaceField
set [sequence] = 6, gridSequence = 6, isGrid = 1, controlText = 'Shrink Qty', isHidden = 0
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_PromoShrinkQuantity'

update pal_SurfaceField
set [sequence] = 7, gridSequence = 7, isGrid = 1, controlText = 'Case Qty', isHidden = 0
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_PromoCaseQuantity'

update pal_SurfaceField
set [sequence] = 8, gridSequence = 8
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_WholesalerOrderQuantity'

update pal_SurfaceField
set [sequence] = 9, gridSequence = 9
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_ShrinkQuantity'

update pal_SurfaceField
set [sequence] = 10, gridSequence = 10
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_CaseQuantity'

update pal_SurfaceField
set [sequence] = 11, gridSequence = 11
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_WholesalerOrderAmount'

update pal_SurfaceField
set [sequence] = 12, gridSequence = 12
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_ExtraGPZARTotal'

update pal_SurfaceField
set [sequence] = 13, gridSequence = 13
where surfaceFieldName = 'ShoppingListSelections_ShoppingListSelections_WholesalerLogo'
