기능(Feature) #486
Updated by Dante Le 9 months ago
Update COUPON_APPLIED_VALUE, COUPON_SHARE_APPLIED_VALUE1, COUPON_SHARE_APPLIED_VALUE2 to Zero in PM_USED_COUPON table for cancellation booking purpose
Endpoint: /booking/hotel/hana/cancel-coupon
[SQL]
<pre><code class="sql">
INSERT INTO OMH_SUITE.BS_API_SERVICE_CODE (API_SERVICE_URL, METHOD_NAME, OWNER_COMP_CODE, API_SERVICE_NAME_EN,
API_SERVICE_NAME_KO, SCHEMA_FILE_NAME_RQ, SCHEMA_FILE_NAME_RS,
VENDOR_SERVICE_NAME, API_SERVICE_DESC, SAMPLE_REQUEST_MESSAGE,
SAMPLE_RESPONSE_MESSAGE, OPEN_API_YN, OUTSIDE_INTERFACE_YN, LOG_SAVE_YN,
IGNORE_SCHEMA_YN, CONTROL_REMARK, USE_YN, FIRST_INSERT_UNO,
FIRST_INSERT_DATETIME, LAST_UPDATE_UNO, LAST_UPDATE_DATETIME)
VALUES ('/booking/hotel/hana/cancel-coupon', 'POST', 110000, 'cancel coupon', 'canel coupon',
'/booking/hotel/hana/cancel_coupon/cancel_coupon_schema_rq.json',
'/booking/hotel/hana/cancel_coupon/cancel_coupon_schema_rs.json', '', '', '', '', 'N', 'N', 'N', 'N', '', 'Y',
10000, '2025-06-03 18:36:35', 10000, '2025-06-03 18:36:35')
</code></pre>