Project

General

Profile

Actions
Copy link

VOC support #2892

closed

REQUEST FOR ISSUE BILLING BOOKINGS - SEAESTA HOTEL NOV & DEC 2025

Added by Tracy Tran about 2 months ago. Updated about 2 months ago.

Status:
완료성공(Resolve)
Priority:
긴급(Emergency)
Assignee:
Tom Dong
Target version:
v1.0.0
Start date:
01/12/2026
Due date:
01/12/2026
% Done:

100%

Estimated time:
Part:
Build env.:
Prod

Description

Dear Tom,

We kindly request your assistance in changing the payment method for all bookings from Prepay/VCC to Prepay/Cash for the Seaesta Hotel in Nha Trang, as detailed in the attached file.

Additionally, please assist us in issuing a billing for these bookings.

Thank you for your support!

Files

Download all files
Seaesta 12.25.xlsx (14.8 KB) Seaesta 12.25.xlsx Tracy Tran, 01/12/2026 04:41 AM
Seaesta 11.25.xlsx (14.7 KB) Seaesta 11.25.xlsx Tracy Tran, 01/12/2026 04:41 AM
Actions
Copy link
 #1

Updated by Tom Dong about 2 months ago

SQL Script for Issue Billing - Seaesta Hotel Nov & Dec 2025

Step 1: Clear temp table

DELETE FROM temp_voc_issue_billing WHERE BillingNo IS NOT NULL OR BillingNo IS NULL;

Step 2: Insert data into temp table

-- December 2025 (150 bookings)
INSERT INTO temp_voc_issue_billing (AppliedFromDate, AppliedToDate, BookingItemCode, HotelCode, VendorCode, BankAccountNumber, Currency, DepositDueDate) 
VALUES
('2025-12-01', '2025-12-31', 'K25110511016H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111311637H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112010486H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111212388H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25102712499H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112910523H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120210701H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25120410032H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112011711H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112811242H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112711737H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25120410033H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111711490H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25113011495H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25113011496H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25113010369H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120210933H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25120510085H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112810209H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120211323H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25120210064H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121510071H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121510072H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112411234H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110911982H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120311564H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121510073H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111111881H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111412764H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121510075H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25102011627H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25101312187H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120110433H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121510076H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111610550H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111010020H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25102911354H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120112172H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111211881H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25113010482H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120811008H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120212398H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25120410088H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25120410089H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120611426H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111310338H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120111124H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120111166H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120311695H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120611443H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121010950H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121510077H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120811504H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120311266H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121110636H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110410138H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110811633H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111410841H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111410852H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111113732H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111011615H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111311377H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111911726H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112411132H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112810100H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112711013H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121210026H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121310971H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121710058H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112611374H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112611399H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111910792H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112910596H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121611102H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121710059H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121710060H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112411383H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120910689H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121211747H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121512022H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112810766H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120911007H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120911585H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112611651H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120411019H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121211777H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121512039H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121710029H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111011682H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111611531H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111710806H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121611017H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112511239H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111111665H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120110403H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110210596H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110210602H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111011871H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112711787H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111111965H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121711909H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121712263H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121010085H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121910676H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122011039H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111810779H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121512270H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120611170H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122010837H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111711353H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112811426H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120110899H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121411169H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122011655H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122012157H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25102911080H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111012675H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111012679H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25122410087H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25121710902H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120210275H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25121210101H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122210714H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122410596H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25100811054H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25100811055H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110913414H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120111061H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25120512038H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110611487H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25103110889H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110212153H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122610117H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25111810932H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112010984H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25102610477H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122210427H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122211027H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25102211435H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25112110881H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25092510843H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25101312438H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25110111961H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25101212251H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25113011665H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122310506H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'V25122610082H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25113010022H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122210953H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-12-01', '2025-12-31', 'K25122610679H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31');

-- November 2025 (145 bookings)
INSERT INTO temp_voc_issue_billing (AppliedFromDate, AppliedToDate, BookingItemCode, HotelCode, VendorCode, BankAccountNumber, Currency, DepositDueDate) 
VALUES
('2025-11-01', '2025-11-30', 'K25091011810H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25091012422H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25091712010H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102210308H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25090910739H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101312508H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102710060H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25092911695H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102011745H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102110882H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102212875H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102310678H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25103011146H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110210876H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110312583H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101911312H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102911115H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25103011147H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110310695H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25110510062H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102711898H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102210696H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102412333H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102510308H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102112838H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102411788H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102511609H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110411320H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25111710023H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25111710024H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110110429H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110210546H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25100611735H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101012295H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101212019H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25111710026H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25082911577H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25100912431H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101412677H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101512045H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25091711100H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25091111031H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101012326H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101410054H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25100810989H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101411535H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102111800H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111010502H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25111710027H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25111710028H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102210020H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25100610748H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101012184H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102812080H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25100912254H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101411804H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101410588H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110111860H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25111710035H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101810729H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102311473H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101211351H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111311341H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111311369H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102911207H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110111125H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110911007H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110911166H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111313796H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102911213H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101110815H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102711724H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110312285H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102111600H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25091211842H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101010545H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110611736H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110610703H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25103111115H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102611730H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110311254H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110910782H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101110513H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110810349H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101210051H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101710073H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101710109H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25103011693H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25103011709H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101110821H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102911328H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25092311853H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25112010831H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25112011488H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25112410036H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102811164H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101210576H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101512247H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111511226H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111610803H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111612208H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25092211304H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110112027H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110612378H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25112110675H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25112111893H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25112210008H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25100611293H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102912116H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25092911436H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102911417H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25090312574H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25092310763H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102910083H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25120110045H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25092911390H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110111763H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111711054H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25120110046H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25120110047H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25120110048H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25120110049H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101411558H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25100910959H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25101211884H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102610636H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110510882H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110610900H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110510070H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102211108H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102712786H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25120110050H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'V25120110051H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110714034H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111311845H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110912960H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111011581H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110510648H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111111775H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111612174H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110510970H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25110611475H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111610078H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25102910942H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31'),
('2025-11-01', '2025-11-30', 'K25111310637H01', 886622, 603451, '8021100038168', 'VND', '2025-12-31');

Step 3: Insert PM_INVOICE_MASTER

INSERT INTO PM_INVOICE_MASTER (
    SALES_OR_VENDOR, ISSUE_COMP_CODE, TRADER_COMP_CODE, CHECK_IN_OR_OUT,
    APPLIED_FROM_DATE, APPLIED_TO_DATE, CURRENCY_CODE,
    INVOICE_AMOUNT, PAID_AMOUNT, BALANCE_AMOUNT, BANK_ACCOUNT_SEQ,
    ISSUE_DATETIME, DEPOSIT_DUE_DATE, REMIT_DATE, BILLING_STATUS_CODE,
    CONTROL_REMARK, FIRST_INSERT_UNO, FIRST_INSERT_DATETIME, LAST_UPDATE_UNO, LAST_UPDATE_DATETIME, ADJUSTMENT_AMOUNT
)
SELECT DISTINCT
    'V' AS SaleOrVendor,
    tvib.VendorCode,
    tvib.VendorCode,
    'I' AS CheckInOrOut,
    tvib.AppliedFromDate,
    tvib.AppliedToDate,
    tvib.Currency,
    0 AS invocieAmount,
    0 AS PaidAmount,
    0 AS BalanceAmount,
    ucba.BANK_ACCOUNT_SEQ AS BankAccountSeq,
    NOW(),
    tvib.DepositDueDate,
    NULL AS RemitDate,
    'VBS01',
    NULL AS ControlRemark,
    90049 AS FirstInsertUno,
    NOW(),
    90049 AS LastUpdateUno,
    NOW(),
    NULL AS AdjustmentAmount
FROM temp_voc_issue_billing tvib
JOIN US_COMP_BANK_ACCOUNT ucba ON tvib.BankAccountNumber = CAST(AES_DECRYPT(UNHEX(ucba.BANK_ACCOUNT_NO),'b3d0a62f-a5ba-406d-b150-cb3eb62268bc') AS char)
                               AND tvib.VendorCode = ucba.COMP_CODE 
                               AND ucba.USE_YN = 'Y'
WHERE tvib.BillingNo IS NULL;

Step 4: Update temp table with BillingNo

UPDATE temp_voc_issue_billing tvib
JOIN PM_INVOICE_MASTER pim ON tvib.VendorCode = pim.TRADER_COMP_CODE
                           AND tvib.AppliedFromDate = pim.APPLIED_FROM_DATE
                           AND tvib.AppliedToDate = pim.APPLIED_TO_DATE
                           AND pim.FIRST_INSERT_UNO = 90049
                           AND pim.SALES_OR_VENDOR = 'V'
                           AND pim.BILLING_STATUS_CODE = 'VBS01'
SET tvib.BillingNo = pim.INVOICE_SEQ
WHERE tvib.BillingNo IS NULL;

Step 5: Insert PM_INVOICE_BOOKING_ITEM

INSERT INTO PM_INVOICE_BOOKING_ITEM (INVOICE_SEQ, BOOKING_ITEM_CODE, FIRST_INSERT_UNO, LAST_UPDATE_UNO)
SELECT 
    tvib.BillingNo,
    tvib.BookingItemCode,
    90049 AS FirstInsertUno,
    90049 AS LastUpdateUno
FROM temp_voc_issue_billing tvib 
WHERE tvib.BillingNo IS NOT NULL
ON DUPLICATE KEY UPDATE LAST_UPDATE_DATETIME = NOW();

Step 6: Update invoice amounts

UPDATE PM_INVOICE_MASTER
SET INVOICE_AMOUNT = IFNULL((
        SELECT SUM(VENDOR_SUM_AMOUNT) 
        FROM BK_BOOKING_HOTEL_ITEM
        JOIN PM_INVOICE_BOOKING_ITEM ON BK_BOOKING_HOTEL_ITEM.BOOKING_ITEM_CODE = PM_INVOICE_BOOKING_ITEM.BOOKING_ITEM_CODE
        WHERE PM_INVOICE_BOOKING_ITEM.INVOICE_SEQ = PM_INVOICE_MASTER.INVOICE_SEQ
    ), 0),
    BALANCE_AMOUNT = IFNULL((
        SELECT SUM(VENDOR_SUM_AMOUNT) 
        FROM BK_BOOKING_HOTEL_ITEM
        JOIN PM_INVOICE_BOOKING_ITEM ON BK_BOOKING_HOTEL_ITEM.BOOKING_ITEM_CODE = PM_INVOICE_BOOKING_ITEM.BOOKING_ITEM_CODE
        WHERE PM_INVOICE_BOOKING_ITEM.INVOICE_SEQ = PM_INVOICE_MASTER.INVOICE_SEQ
    ), 0),
    LAST_UPDATE_UNO = 90049,
    LAST_UPDATE_DATETIME = NOW()
WHERE PM_INVOICE_MASTER.SALES_OR_VENDOR = 'V'
  AND PM_INVOICE_MASTER.INVOICE_SEQ IN (SELECT tvib.BillingNo FROM temp_voc_issue_billing tvib WHERE tvib.BillingNo IS NOT NULL);

Step 7: Verify result

SELECT * FROM temp_voc_issue_billing tvib;

Summary
  • Hotel: Seaesta Hotel (Code: 886622)
  • Vendor: 603451
  • Total bookings: 295 (150 Dec + 145 Nov)
  • Currency: VND
  • Bank Account: 8021100038168
  • Deposit Due Date: 2025-12-31

Actions
Copy link
 #2

Updated by Tom Dong about 2 months ago

SQL Script for Payment Method Change - Prepay/VCC to Prepay/Cash

Step 0: Update Payment Method for all 295 bookings

Before billing, change payment method from Prepay/VCC to Prepay/Cash:
  • VENDOR_PAYMENT_TYPE_CODE: Prepay (unchanged)
  • VENDOR_PAYMENT_METHOD_CODE: VCC → Cash
-- Change payment method from VCC to Cash for all Seaesta Hotel bookings
UPDATE BK_BOOKING_HOTEL_ITEM 
SET VENDOR_PAYMENT_METHOD_CODE = 'Cash',
    VENDOR_PAYMENT_TYPE_CODE = 'Prepay',
    LAST_UPDATE_UNO = 90049,
    LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE IN (
    -- December 2025 (150 bookings)
    'K25110511016H01', 'K25111311637H01', 'K25112010486H01', 'K25111212388H01', 'K25102712499H01',
    'K25112910523H01', 'K25120210701H01', 'V25120410032H01', 'K25112011711H01', 'K25112811242H01',
    'K25112711737H01', 'V25120410033H01', 'K25111711490H01', 'K25113011495H01', 'K25113011496H01',
    'K25113010369H01', 'K25120210933H01', 'V25120510085H01', 'K25112810209H01', 'K25120211323H01',
    'V25120210064H01', 'V25121510071H01', 'V25121510072H01', 'K25112411234H01', 'K25110911982H01',
    'K25120311564H01', 'V25121510073H01', 'K25111111881H01', 'K25111412764H01', 'V25121510075H01',
    'K25102011627H01', 'K25101312187H01', 'K25120110433H01', 'V25121510076H01', 'K25111610550H01',
    'K25111010020H01', 'K25102911354H01', 'K25120112172H01', 'K25111211881H01', 'K25113010482H01',
    'K25120811008H01', 'K25120212398H01', 'V25120410088H01', 'V25120410089H01', 'K25120611426H01',
    'K25111310338H01', 'K25120111124H01', 'K25120111166H01', 'K25120311695H01', 'K25120611443H01',
    'K25121010950H01', 'V25121510077H01', 'K25120811504H01', 'K25120311266H01', 'K25121110636H01',
    'K25110410138H01', 'K25110811633H01', 'K25111410841H01', 'K25111410852H01', 'K25111113732H01',
    'K25111011615H01', 'K25111311377H01', 'K25111911726H01', 'K25112411132H01', 'K25112810100H01',
    'K25112711013H01', 'K25121210026H01', 'K25121310971H01', 'V25121710058H01', 'K25112611374H01',
    'K25112611399H01', 'K25111910792H01', 'K25112910596H01', 'K25121611102H01', 'V25121710059H01',
    'V25121710060H01', 'K25112411383H01', 'K25120910689H01', 'K25121211747H01', 'K25121512022H01',
    'K25112810766H01', 'K25120911007H01', 'K25120911585H01', 'K25112611651H01', 'K25120411019H01',
    'K25121211777H01', 'K25121512039H01', 'K25121710029H01', 'K25111011682H01', 'K25111611531H01',
    'K25111710806H01', 'K25121611017H01', 'K25112511239H01', 'K25111111665H01', 'K25120110403H01',
    'K25110210596H01', 'K25110210602H01', 'K25111011871H01', 'K25112711787H01', 'K25111111965H01',
    'K25121711909H01', 'K25121712263H01', 'V25121010085H01', 'K25121910676H01', 'K25122011039H01',
    'K25111810779H01', 'K25121512270H01', 'K25120611170H01', 'K25122010837H01', 'K25111711353H01',
    'K25112811426H01', 'K25120110899H01', 'K25121411169H01', 'K25122011655H01', 'K25122012157H01',
    'K25102911080H01', 'K25111012675H01', 'K25111012679H01', 'V25122410087H01', 'K25121710902H01',
    'K25120210275H01', 'V25121210101H01', 'K25122210714H01', 'K25122410596H01', 'K25100811054H01',
    'K25100811055H01', 'K25110913414H01', 'K25120111061H01', 'K25120512038H01', 'K25110611487H01',
    'K25103110889H01', 'K25110212153H01', 'K25122610117H01', 'K25111810932H01', 'K25112010984H01',
    'K25102610477H01', 'K25122210427H01', 'K25122211027H01', 'K25102211435H01', 'K25112110881H01',
    'K25092510843H01', 'K25101312438H01', 'K25110111961H01', 'K25101212251H01', 'K25113011665H01',
    'K25122310506H01', 'V25122610082H01', 'K25113010022H01', 'K25122210953H01', 'K25122610679H01',
    -- November 2025 (145 bookings)
    'K25091011810H01', 'K25091012422H01', 'K25091712010H01', 'K25102210308H01', 'K25090910739H01',
    'K25101312508H01', 'K25102710060H01', 'K25092911695H01', 'K25102011745H01', 'K25102110882H01',
    'K25102212875H01', 'K25102310678H01', 'K25103011146H01', 'K25110210876H01', 'K25110312583H01',
    'K25101911312H01', 'K25102911115H01', 'K25103011147H01', 'K25110310695H01', 'V25110510062H01',
    'K25102711898H01', 'K25102210696H01', 'K25102412333H01', 'K25102510308H01', 'K25102112838H01',
    'K25102411788H01', 'K25102511609H01', 'K25110411320H01', 'V25111710023H01', 'V25111710024H01',
    'K25110110429H01', 'K25110210546H01', 'K25100611735H01', 'K25101012295H01', 'K25101212019H01',
    'V25111710026H01', 'K25082911577H01', 'K25100912431H01', 'K25101412677H01', 'K25101512045H01',
    'K25091711100H01', 'K25091111031H01', 'K25101012326H01', 'K25101410054H01', 'K25100810989H01',
    'K25101411535H01', 'K25102111800H01', 'K25111010502H01', 'V25111710027H01', 'V25111710028H01',
    'K25102210020H01', 'K25100610748H01', 'K25101012184H01', 'K25102812080H01', 'K25100912254H01',
    'K25101411804H01', 'K25101410588H01', 'K25110111860H01', 'V25111710035H01', 'K25101810729H01',
    'K25102311473H01', 'K25101211351H01', 'K25111311341H01', 'K25111311369H01', 'K25102911207H01',
    'K25110111125H01', 'K25110911007H01', 'K25110911166H01', 'K25111313796H01', 'K25102911213H01',
    'K25101110815H01', 'K25102711724H01', 'K25110312285H01', 'K25102111600H01', 'K25091211842H01',
    'K25101010545H01', 'K25110611736H01', 'K25110610703H01', 'K25103111115H01', 'K25102611730H01',
    'K25110311254H01', 'K25110910782H01', 'K25101110513H01', 'K25110810349H01', 'K25101210051H01',
    'K25101710073H01', 'K25101710109H01', 'K25103011693H01', 'K25103011709H01', 'K25101110821H01',
    'K25102911328H01', 'K25092311853H01', 'K25112010831H01', 'K25112011488H01', 'V25112410036H01',
    'K25102811164H01', 'K25101210576H01', 'K25101512247H01', 'K25111511226H01', 'K25111610803H01',
    'K25111612208H01', 'K25092211304H01', 'K25110112027H01', 'K25110612378H01', 'K25112110675H01',
    'K25112111893H01', 'K25112210008H01', 'K25100611293H01', 'K25102912116H01', 'K25092911436H01',
    'K25102911417H01', 'K25090312574H01', 'K25092310763H01', 'K25102910083H01', 'V25120110045H01',
    'K25092911390H01', 'K25110111763H01', 'K25111711054H01', 'V25120110046H01', 'V25120110047H01',
    'V25120110048H01', 'V25120110049H01', 'K25101411558H01', 'K25100910959H01', 'K25101211884H01',
    'K25102610636H01', 'K25110510882H01', 'K25110610900H01', 'K25110510070H01', 'K25102211108H01',
    'K25102712786H01', 'V25120110050H01', 'V25120110051H01', 'K25110714034H01', 'K25111311845H01',
    'K25110912960H01', 'K25111011581H01', 'K25110510648H01', 'K25111111775H01', 'K25111612174H01',
    'K25110510970H01', 'K25110611475H01', 'K25111610078H01', 'K25102910942H01', 'K25111310637H01'
);

Verification Query

-- Verify payment method change
SELECT BOOKING_ITEM_CODE, VENDOR_PAYMENT_TYPE_CODE, VENDOR_PAYMENT_METHOD_CODE, LAST_UPDATE_DATETIME
FROM BK_BOOKING_HOTEL_ITEM
WHERE BOOKING_ITEM_CODE IN ('K25110511016H01', 'K25091011810H01')
  AND VENDOR_PAYMENT_METHOD_CODE = 'Cash';

Execution Order
  1. Step 0: Run UPDATE to change payment method from VCC to Cash (this note)
  2. Step 1-7: Run billing SQL from previous note

Summary
  • Change: VENDOR_PAYMENT_METHOD_CODE from VCC to Cash
  • Keep: VENDOR_PAYMENT_TYPE_CODE = Prepay
  • Total bookings: 295 (150 Dec + 145 Nov)

Actions
Copy link
 #3

Updated by Tom Dong about 2 months ago

Billings: 759581, 759582
Tracy Tran

Actions
Copy link
 #4

Updated by Tom Dong about 2 months ago

  • Due date set to 01/12/2026
  • Status changed from 신규(New) to QA test
  • Assignee changed from Tom Dong to Tracy Tran
  • Start date set to 01/12/2026
  • % Done changed from 0 to 100
  • Build env. set to Prod
Actions
Copy link
 #5

Updated by Tracy Tran about 2 months ago

  • Status changed from QA test to 완료성공(Resolve)
  • Assignee changed from Tracy Tran to Tom Dong

checked

Actions
Copy link

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)