VOC

VOC Analysis¶

SQL Script¶

-- ============================================================
-- VOC #3063: Change Vendor Payment Status
-- Booking: K26012712905H01
-- Change: VPS03 (Fully Paid) -> VPS01 (Not Paid)
-- ============================================================

-- 1. VERIFY (Before)
SELECT BOOKING_ITEM_CODE, BOOKING_CODE, VENDOR_PAYMENT_STATUS_CODE, 
       BOOKING_STATUS_CODE, VENDOR_CURRENCY_CODE, VENDOR_SUM_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM 
WHERE BOOKING_ITEM_CODE = 'K26012712905H01';

-- 2. EXECUTE
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS01',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K26012712905H01'
  AND VENDOR_PAYMENT_STATUS_CODE = 'VPS03';

-- 3. VERIFY (After)
SELECT BOOKING_ITEM_CODE, BOOKING_CODE, VENDOR_PAYMENT_STATUS_CODE, 
       BOOKING_STATUS_CODE, VENDOR_CURRENCY_CODE, VENDOR_SUM_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM 
WHERE BOOKING_ITEM_CODE = 'K26012712905H01';

-- 4. ROLLBACK (if needed)
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K26012712905H01';

Status Codes Reference

• VPS01 = Not Paid
• VPS02 = VCC Payment
• VPS03 = Fully Paid