VOC

VOC SQL - Change Billing Status¶

Request: Change billing payment status from "Request to Approval" to "Non-Payment" for billing no. 758200

Status Code Mapping:¶

Step 1: Verify current status (SELECT)¶

-- Verify billing 758200 exists with current status VBS02
SELECT 
    INVOICE_SEQ,
    BILLING_STATUS_CODE,
    INVOICE_AMOUNT,
    BALANCE_AMOUNT,
    TRADER_COMP_CODE,
    CURRENCY_CODE,
    ISSUE_DATETIME
FROM PM_INVOICE_MASTER 
WHERE INVOICE_SEQ = 758200
  AND SALES_OR_VENDOR = 'V';

Step 2: Update billing status (UPDATE)¶

-- Change status from VBS02 (Request to Approval) to VBS01 (Non-Payment)
UPDATE PM_INVOICE_MASTER
SET BILLING_STATUS_CODE = 'VBS01',
    LAST_UPDATE_UNO = 90049,
    LAST_UPDATE_DATETIME = NOW()
WHERE INVOICE_SEQ = 758200
  AND SALES_OR_VENDOR = 'V'
  AND BILLING_STATUS_CODE = 'VBS02';

Step 3: Verify result (SELECT)¶

-- Confirm the update was successful
SELECT 
    INVOICE_SEQ,
    BILLING_STATUS_CODE,
    INVOICE_AMOUNT,
    BALANCE_AMOUNT,
    LAST_UPDATE_DATETIME
FROM PM_INVOICE_MASTER 
WHERE INVOICE_SEQ = 758200;

Note: Run Step 1 first to confirm the record exists with status VBS02 before executing the UPDATE.