Actions
VOC support #3063
closedChange payment status - K26012712905H01
Start date:
02/09/2026
Due date:
02/09/2026
% Done:
100%
Estimated time:
Part:
Build env.:
Prod
Description
Dear team,
Kindly help to change Vendor Payment status from Fully Paid - > Not Paid for booking: K26012712905H01.
Other is unchanged.
Reason: Due to wrong mapping, hotel provided OMH guest voucher, VNOP need to change Buying rate by adding 1,200,000 VND for this booking - approved by PIC: Mr. Mike
Updated by Tom Dong 29 days ago
VOC Analysis¶
| Field | Value |
|---|---|
| Booking Item | K26012712905H01 |
| Current Status | VPS03 (Fully Paid) |
| Target Status | VPS01 (Not Paid) |
| Reason | Wrong mapping, hotel provided OMH guest voucher, VNOP needs to change Buying rate |
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 PaidVPS02 = VCC PaymentVPS03 = Fully Paid
VPS01 = Not PaidVPS02 = VCC PaymentVPS03 = Fully Paid
Actions
