Actions
VOC support #2542
closed[Urgent] Please amend the buying rate K25110410443H01 // Hotel Sirius
Start date:
12/05/2025
Due date:
12/05/2025
% Done:
100%
Estimated time:
Part:
Build env.:
Prod
Description
Dear Tom,
K25110410443H01 // Hotel Sirius
please support to change data as below:
V Payment: change to Not Paid
VCC Status: change to Fully Cancelled
Vendor Balance: change to 134,385
Reason: A rate difference occurred on this booking due to an agent issue. Hotel cancelled old charge for us to change rate then re-charge again.
Files
Updated by Tracy Tran 3 months ago
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Tran to Tom Dong
Checked
Updated by Tom Dong 2 months ago
-- ============================================================
-- VOC #2542: Amend buying rate K25110410443H01 // Hotel Sirius
-- Reason: Rate difference occurred - hotel cancelled old charge
-- ============================================================
-- Step 1: Verify current data
SELECT 'BK_BOOKING_HOTEL_ITEM' AS TBL, BOOKING_ITEM_CODE,
VENDOR_PAYMENT_STATUS_CODE, VENDOR_BALANCE_AMOUNT, VENDOR_SUM_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM
WHERE BOOKING_ITEM_CODE = 'K25110410443H01';
SELECT 'PM_PAYMENT_INFO' AS TBL, PAYMENT_SEQ, CARD_PAYMENT_STATUS_CODE,
PAID_AMOUNT, DEPOSIT_TYPE_CODE
FROM PM_PAYMENT_INFO
WHERE BOOKING_ITEM_CODE = 'K25110410443H01' AND DELETE_YN = 'N';
-- Step 2: Update VCC Status to Fully Cancelled (CCS04)
UPDATE PM_PAYMENT_INFO
SET CARD_PAYMENT_STATUS_CODE = 'CCS04',
LAST_UPDATE_UNO = 10000,
LAST_UPDATE_DATETIME = NOW()
WHERE PAYMENT_SEQ = 3543844
AND BOOKING_ITEM_CODE = 'K25110410443H01'
AND CARD_PAYMENT_STATUS_CODE = 'CCS02';
-- Step 3: Update V Payment to Not Paid (VPS01) and Vendor Balance to 134,385
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS01',
VENDOR_BALANCE_AMOUNT = 134385.00,
LAST_UPDATE_UNO = 10000,
LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K25110410443H01'
AND VENDOR_PAYMENT_STATUS_CODE = 'VPS03';
-- Step 4: Verify after update
SELECT 'BK_BOOKING_HOTEL_ITEM' AS TBL, BOOKING_ITEM_CODE,
VENDOR_PAYMENT_STATUS_CODE, VENDOR_BALANCE_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM
WHERE BOOKING_ITEM_CODE = 'K25110410443H01';
SELECT 'PM_PAYMENT_INFO' AS TBL, PAYMENT_SEQ, CARD_PAYMENT_STATUS_CODE, PAID_AMOUNT
FROM PM_PAYMENT_INFO
WHERE BOOKING_ITEM_CODE = 'K25110410443H01' AND DELETE_YN = 'N';
-- ============================================================
-- ROLLBACK (if needed)
-- ============================================================
/*
UPDATE PM_PAYMENT_INFO
SET CARD_PAYMENT_STATUS_CODE = 'CCS02',
LAST_UPDATE_UNO = 10000,
LAST_UPDATE_DATETIME = NOW()
WHERE PAYMENT_SEQ = 3543844;
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
VENDOR_BALANCE_AMOUNT = 0.00,
LAST_UPDATE_UNO = 10000,
LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K25110410443H01';
*/
| Table | Field | Before | After |
|---|---|---|---|
| PM_PAYMENT_INFO (3543844) | CARD_PAYMENT_STATUS_CODE | CCS02 | CCS04 |
| BK_BOOKING_HOTEL_ITEM | VENDOR_PAYMENT_STATUS_CODE | VPS03 | VPS01 |
| BK_BOOKING_HOTEL_ITEM | VENDOR_BALANCE_AMOUNT | 0.00 | 134,385.00 |
Actions
