drop table customer_orders;
create table customer_orders (

  order_ref          number primary key,
  vendor_id          number,
  scu                number,
  quantity           number,
  order_date         date,

  status             varchar2(80),
  err_msg            varchar2(4000) );