VOC

SQL Generated:

-- =====================================================
-- VOC Issue #3052: Update Vendor Payment Condition
-- Hotel: 604207 (Best Western Plus Nagoya Sakae)
-- Request: Change Payment Condition from "Check In/Out" to "Check Out" 
-- =====================================================

-- Step 1: Verify current data
SELECT 
    PAYMENT_CONDITION_SEQ,
    VENDOR_COMP_CODE,
    APPLIED_FROM_DATE,
    APPLIED_TO_DATE,
    CHECK_IN_OR_OUT,
    PAYMENT_TYPE_CODE,
    PAYMENT_METHOD_CODE
FROM VD_VENDOR_PAYMENT_CONDITION 
WHERE VENDOR_COMP_CODE = 604207 
ORDER BY APPLIED_FROM_DATE DESC;

-- Step 2: Update CHECK_IN_OR_OUT to 'O' (Check Out) for records with NULL
UPDATE VD_VENDOR_PAYMENT_CONDITION
SET 
    CHECK_IN_OR_OUT = 'O',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE VENDOR_COMP_CODE = 604207
  AND CHECK_IN_OR_OUT IS NULL;

-- Step 3: Verify update
SELECT 
    PAYMENT_CONDITION_SEQ,
    VENDOR_COMP_CODE,
    APPLIED_FROM_DATE,
    APPLIED_TO_DATE,
    CHECK_IN_OR_OUT,
    PAYMENT_TYPE_CODE,
    PAYMENT_METHOD_CODE
FROM VD_VENDOR_PAYMENT_CONDITION 
WHERE VENDOR_COMP_CODE = 604207 
ORDER BY APPLIED_FROM_DATE DESC;

-- Rollback (if needed)
-- UPDATE VD_VENDOR_PAYMENT_CONDITION
-- SET CHECK_IN_OR_OUT = NULL
-- WHERE VENDOR_COMP_CODE = 604207
--   AND PAYMENT_CONDITION_SEQ IN (306230, 306231);

Summary:

Affected rows: 2