UPDATE purchase_orders
SET due_date = transaction_date
WHERE due_date IS NULL;

ALTER TABLE purchase_orders
    ALTER COLUMN due_date SET NOT NULL;