Actions
VOC support #2586
closedRe: Booking Rejection and Next Booking Deduction// Booking K25112711373H01
Start date:
12/09/2025
Due date:
12/09/2025
% Done:
100%
Estimated time:
Part:
Build env.:
Description
Dear Tom,
As per VNAC team, Please support to change the data as below:
Booking K25112711373H01
V Payment: change to Fully Paid
Vendor Balance: change to 0
Files
Updated by Tom Dong 3 months ago
- SQL Update for VOC #2586
Request: Change V Payment to Fully Paid, Vendor Balance to 0
Current Status:| Field | Before |
| ------- | -------- |
| V Payment | VPS01 (Not Paid) |
| Vendor Balance | 0.00 |
SQL:
```sql
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
LAST_UPDATE_UNO = 10000,
LAST_UPDATE_DATETIME = NOW
WHERE BOOKING_ITEM_CODE = 'K25112711373H01'
AND VENDOR_PAYMENT_STATUS_CODE = 'VPS01';
```
| Field | After |
| ------- | ------- |
| V Payment | VPS03 (Fully Paid) |
| Vendor Balance | 0.00 (no change needed) |
Updated by Tracy Tran 3 months ago
- File Screenshot 2025-12-09 154846.png Screenshot 2025-12-09 154846.png added
- Status changed from QA test to 피드백(Feedback)
- Assignee changed from Tracy Tran to Tom Dong
Dear Tom,
Sorry, it was my mistake when give you the booking number.
Please support to tp revert the data for booking K25112711373H01 as original .
And change the data for this booking K25092311042H01 as below image.
V Payment: change to Fully Paid
Vendor Balance: change to 0
Updated by Tracy Tran 3 months ago
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Tran to Tom Dong
Checked
Thank you
Actions
