VOC support #2892: REQUEST FOR ISSUE BILLING BOOKINGS - SEAESTA HOTEL NOV & DEC 2025 - VOC - Redmine

Custom queries

Issues assigned to me
Reported issues
Updated issues
Watched issues

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

History
Notes
Property changes

Actions

Copy link

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

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

Step 0: Run UPDATE to change payment method from VCC to Cash (this note)

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

Updated by Tom Dong about 2 months ago

Billings: 759581, 759582
Tracy Tran

Actions

Copy link

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

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

Project

General

Profile

VOC

Custom queries

VOC support #2892

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

Updated by Tom Dong about 2 months ago

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

Step 1: Clear temp table¶

Step 2: Insert data into temp table¶

Step 3: Insert PM_INVOICE_MASTER¶

Step 4: Update temp table with BillingNo¶

Step 5: Insert PM_INVOICE_BOOKING_ITEM¶

Step 6: Update invoice amounts¶

Step 7: Verify result¶

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

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¶

Verification Query¶

Execution Order

Step 0: Run UPDATE to change payment method from VCC to Cash (this note)

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)

Updated by Tom Dong about 2 months ago

Updated by Tom Dong about 2 months ago

Updated by Tracy Tran about 2 months ago

Project

General

Profile

VOC

Custom queries

VOC support #2892

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

Updated by Tom Dong about 2 months ago

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

Step 1: Clear temp table¶

Step 2: Insert data into temp table¶

Step 3: Insert PM_INVOICE_MASTER¶

Step 4: Update temp table with BillingNo¶

Step 5: Insert PM_INVOICE_BOOKING_ITEM¶

Step 6: Update invoice amounts¶

Step 7: Verify result¶

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

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¶

Verification Query¶

Execution Order Step 0: Run UPDATE to change payment method from VCC to Cash (this note) 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)

Updated by Tom Dong about 2 months ago

Updated by Tom Dong about 2 months ago

Updated by Tracy Tran about 2 months ago

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

Execution Order

Step 0: Run UPDATE to change payment method from VCC to Cash (this note)

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)