--From PVD for conversion
-- Add/modify columns 
alter table I_TEMPORARYDELIVERYSTOP add STARTDATE date;
alter table I_TEMPORARYDELIVERYSTOP add ENDDATE date;

-- Add/modify columns 
alter table I_PRODUCTLISTPERCUSTOMER add SRCCHARGERENT number default 0 not null;

-- Add/modify columns 
alter table I_DELIVERYSTANDARDS add CONTRACTPERIOD number default 0 not null;
alter table I_DELIVERYSTANDARDS add PROLONGATIONPERIOD number default 0 not null;
alter table I_DELIVERYSTANDARDS add CANCELADVANCEPERIOD number default 0 not null;
-- Add comments to the columns 
comment on column I_DELIVERYSTANDARDS.CONTRACTPERIOD
  is 'Between 0 and 9999';
comment on column I_DELIVERYSTANDARDS.PROLONGATIONPERIOD
  is 'Between 0 and 9999';
comment on column I_DELIVERYSTANDARDS.CANCELADVANCEPERIOD
  is 'Between 0 and 9999';
-- Create/Recreate check constraints 
alter table I_DELIVERYSTANDARDS
  add constraint I_DELVAR_CONTRACTPERIOD
  check (CONTRACTPERIOD between 0 and 9999);
alter table I_DELIVERYSTANDARDS
  add constraint I_DELVAR_PROLONGATIONPERIOD
  check (PROLONGATIONPERIOD between 0 and 9999);
alter table I_DELIVERYSTANDARDS
  add constraint I_DELVAR_CANCELADVANCEPERIOD
  check (CANCELADVANCEPERIOD between 0 and 9999);

alter table I_DELIVERYSTANDARDS modify COUNTSEQUENCENUMBER null;