-- Order 20011171
-- Add/modify columns for Sales Notes
alter table WORKORDERLINE add INTERNALCALCPRICE NUMBER(15,6) default 0 not null;
alter table WORKORDERLINE add FIXEDINTERNALCALCPRICE VARCHAR2(1) default 'N' not null;
-- Add comments to the columns 
comment on column WORKORDERLINE.INTERNALCALCPRICE
  is 'Internal calculation price for delivered weights, only relevant when module INTERNALCALC is active.';
comment on column WORKORDERLINE.FIXEDINTERNALCALCPRICE
  is 'This attributes indicates whether internal calculation prices are fixed or not. Only relevant when module INTERNALCALC is active.';

-- Add/modify columns ERP_O_INTERNALCALCULATION
alter table ERP_O_INTERNALCALCULATION add WORKORDERLINE_ID number;
alter table ERP_O_INTERNALCALCULATION add DELIVERED_SALES_QTY number;
alter table ERP_O_INTERNALCALCULATION add SALES_AMOUNT NUMBER(15,6);
-- Add comments to the columns 
comment on column ERP_O_INTERNALCALCULATION.NOTENUMBER
  is 'Packing note number, or Workorder number';
