VOC

VOC SQL: Change Vendor Payment Status - K26013111532H01¶

-- [VOC #3031] Change Vendor Payment Status: Fully Paid -> Not Paid
-- Booking: K26013111532H01 / Muine Bay Resort
-- Reason: Wrong mapping, AGT agree to pay for different fee, VNOP need to change Buying rate by adding 800,000VND

UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS01'  -- Not Paid
  , LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K26013111532H01'
  AND VENDOR_PAYMENT_STATUS_CODE = 'VPS03' -- Fully Paid (safety check)
;

-- Rollback
-- UPDATE BK_BOOKING_HOTEL_ITEM
-- SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03'
--   , LAST_UPDATE_DATETIME = NOW()
-- WHERE BOOKING_ITEM_CODE = 'K26013111532H01';