VOC

SQL Update for VOC #2678 - Change Booking Amounts

Booking: V25112610022H01

Verify Query (RUN FIRST):

-- Step 1: Verify BK_BOOKING_HOTEL_ITEM Current Data
SELECT 
    BOOKING_ITEM_CODE, BOOKING_CODE, VENDOR_CURRENCY_CODE,
    VENDOR_ADD_AMOUNT, VENDOR_SUM_AMOUNT, 
    VENDOR_REVENUE_AMOUNT, BILLING_REVENUE_AMOUNT,
    BOOKING_STATUS_CODE
FROM BK_BOOKING_HOTEL_ITEM
WHERE BOOKING_ITEM_CODE = 'V25112610022H01';

-- Step 2: Verify PM_PAYMENT_INFO Current Data (VCC)
SELECT 
    PAYMENT_SEQ, BOOKING_ITEM_CODE, DEPOSIT_TYPE_CODE,
    PAID_AMOUNT, FIRST_DEPOSIT_AMOUNT, CURRENCY_CODE, VCC_TYPE_CODE
FROM PM_PAYMENT_INFO
WHERE BOOKING_ITEM_CODE = 'V25112610022H01'
  AND SALES_OR_VENDOR = 'V'
  AND DELETE_YN = 'N';

Update Query (COPY TO EXECUTE):

-- Step 3: Update BK_BOOKING_HOTEL_ITEM
UPDATE BK_BOOKING_HOTEL_ITEM
SET 
    VENDOR_ADD_AMOUNT = -4220000,
    VENDOR_SUM_AMOUNT = 2110000,
    VENDOR_REVENUE_AMOUNT = 63300,
    BILLING_REVENUE_AMOUNT = 63300,
    LAST_UPDATE_DATETIME = NOW(),
    LAST_UPDATE_UNO = 10000
WHERE BOOKING_ITEM_CODE = 'V25112610022H01'
  AND BOOKING_STATUS_CODE != 'BKS03'
LIMIT 1;

-- Step 4: Update PM_PAYMENT_INFO (VCC Amount)
-- IMPORTANT: FIRST_DEPOSIT_AMOUNT must be included when updating PAID_AMOUNT
UPDATE PM_PAYMENT_INFO
SET 
    PAID_AMOUNT = 2110000,
    FIRST_DEPOSIT_AMOUNT = 2110000,
    LAST_UPDATE_DATETIME = NOW(),
    LAST_UPDATE_UNO = 10000
WHERE BOOKING_ITEM_CODE = 'V25112610022H01'
  AND SALES_OR_VENDOR = 'V'
  AND DELETE_YN = 'N'
  AND VCC_TYPE_CODE IS NOT NULL
LIMIT 1;

checked