VOC

VOC SQL - Vendor Payment Condition Update (Corrected)¶

Hotel: 982751 (the b sapporo)
VENDOR_COMP_CODE: 603970
PAYMENT_CONDITION_SEQ: 305917
Change: Set CHECK_IN_OR_OUT from NULL to 'O' (Check Out)
Reason: Error occurs when hotel attempts to charge

1. Verify current data (DONE ✓)¶

SELECT 
    PAYMENT_CONDITION_SEQ,
    VENDOR_COMP_CODE,
    CHECK_IN_OR_OUT,
    PAYMENT_TYPE_CODE,
    APPLIED_FROM_DATE,
    PAYMENT_PERIOD_CODE
FROM VD_VENDOR_PAYMENT_CONDITION
WHERE PAYMENT_CONDITION_SEQ = 305917;

Result: CHECK_IN_OR_OUT = NULL

2. Update CHECK_IN_OR_OUT to 'O' (Check Out)¶

UPDATE VD_VENDOR_PAYMENT_CONDITION
SET CHECK_IN_OR_OUT = 'O',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE PAYMENT_CONDITION_SEQ = 305917;

3. Verify update result¶

SELECT 
    PAYMENT_CONDITION_SEQ,
    VENDOR_COMP_CODE,
    CHECK_IN_OR_OUT,
    PAYMENT_TYPE_CODE,
    APPLIED_FROM_DATE,
    PAYMENT_PERIOD_CODE
FROM VD_VENDOR_PAYMENT_CONDITION
WHERE PAYMENT_CONDITION_SEQ = 305917;