--Order 20011171.80 - analysis change

ALTER TABLE PACKINGNOTECONTAINER
	ADD (FIXEDINTERNALCALCPRICE VARCHAR2(1)  DEFAULT 'N' NOT NULL CONSTRAINT YN_ValidationField60 CHECK (FIXEDINTERNALCALCPRICE IN ('Y', 'N')));

COMMENT ON COLUMN PACKINGNOTECONTAINER.FIXEDINTERNALCALCPRICE IS 'This attributes indicates whether internal calculation prices are fixed or not. Only relevant when module INTERNALCALC is active.';

CREATE  INDEX XIE8PACKINGNOTECONTAINER ON PACKINGNOTECONTAINER
(FIXEDINTERNALCALCPRICE   ASC);

CREATE  INDEX XIE13PACKINGNOTELINE ON PACKINGNOTELINE
(FIXEDINTERNALCALCPRICE   ASC);
