VOC

VOC #3138: Change Payment Status & Buying Rate - K25122910632H01¶

Current Data:

Field	Current Value
VENDOR_PAYMENT_STATUS_CODE	VPS03 (Fully Paid)
VENDOR_SUM_AMOUNT	6,720,000
VENDOR_ADD_AMOUNT	0
BILLING_REVENUE_AMOUNT	20.62

Required Changes:

Field	New Value
V Payment	VPS01 (Not Paid)
Vendor Sum Amt	0
Vendor Add Amt	-6,720,000
Billing Revenue	275.97

-- =====================================================
-- VOC #3138: Change Payment Status & Buying Rate
-- Booking: K25122910632H01
-- =====================================================

-- Step 1: Verify current data
SELECT BOOKING_ITEM_CODE, VENDOR_PAYMENT_STATUS_CODE, VENDOR_SUM_AMOUNT, 
       VENDOR_ADD_AMOUNT, BILLING_REVENUE_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM 
WHERE BOOKING_ITEM_CODE = 'K25122910632H01';

-- Step 2: Execute UPDATE
UPDATE BK_BOOKING_HOTEL_ITEM
SET 
    VENDOR_PAYMENT_STATUS_CODE = 'VPS01',  -- Not Paid
    VENDOR_SUM_AMOUNT = 0,
    VENDOR_ADD_AMOUNT = -6720000,
    BILLING_REVENUE_AMOUNT = 275.97,
    LAST_UPDATE_DATETIME = NOW(),
    LAST_UPDATE_UNO = 10000
WHERE BOOKING_ITEM_CODE = 'K25122910632H01'
LIMIT 1;

-- Step 3: Verify after update
SELECT BOOKING_ITEM_CODE, VENDOR_PAYMENT_STATUS_CODE, VENDOR_SUM_AMOUNT, 
       VENDOR_ADD_AMOUNT, BILLING_REVENUE_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM 
WHERE BOOKING_ITEM_CODE = 'K25122910632H01';

-- =====================================================
-- ROLLBACK (if needed)
-- =====================================================
/*
UPDATE BK_BOOKING_HOTEL_ITEM
SET 
    VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
    VENDOR_SUM_AMOUNT = 6720000,
    VENDOR_ADD_AMOUNT = 0,
    BILLING_REVENUE_AMOUNT = 20.62,
    LAST_UPDATE_DATETIME = NOW(),
    LAST_UPDATE_UNO = 10000
WHERE BOOKING_ITEM_CODE = 'K25122910632H01'
LIMIT 1;
*/