--ABS-90508
ALTER TABLE ERP_I_CUSTOMER ADD 
(AUTOSOILPERCENTAGE          NUMBER DEFAULT 0 NOT NULL
   CONSTRAINT CHK_ERP_I_CUST_AUTOSOILPERC CHECK (AUTOSOILPERCENTAGE BETWEEN 0.0 AND 100.0),
 GARMENTEMBLEM               VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CHK_ERP_I_CUST_GARMEMB CHECK (GARMENTEMBLEM IN ('Y','N')),
 USEPRODSIZESURCHARGEPRICING VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CHK_ERP_I_CUST_USPRDSZSRCHRGPC CHECK (USEPRODSIZESURCHARGEPRICING IN ('Y','N'))
);

ALTER TABLE ERP_I_CONTRACTCOMPONENT ADD 
(AUTOSOILPERCENTAGE           NUMBER DEFAULT 0 NOT NULL
   CONSTRAINT CHK_ERP_I_CONC_AUTOSOILPC CHECK (AUTOSOILPERCENTAGE BETWEEN 0.0 AND 100.0)
);

ALTER TABLE ERP_I_CONTRACTPRODUCT ADD
(AUTOSOILPERCENTAGE           NUMBER DEFAULT 0 NOT NULL
   CONSTRAINT CHK_ERP_I_CONTPROD_AUTOSOILPC CHECK (AUTOSOILPERCENTAGE BETWEEN 0.0 AND 100.0),
 GARMENTEMBLEM                VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CHK_ERP_I_CONTPROD_GARMEMB CHECK (GARMENTEMBLEM IN ('Y','N')),
 LOSSCHARGEPERCENTAGE         NUMBER(5,2) NULL
   CONSTRAINT CHK_ERP_I_CONTPROD_LOSSCHRG CHECK (LOSSCHARGEPERCENTAGE BETWEEN 0.0 AND 100.0),
 SRCHARGEPERCENTAGE           NUMBER(5,2) NULL
   CONSTRAINT CHK_ERP_I_CONTPROD_CHRGPERC CHECK (SRCHARGEPERCENTAGE BETWEEN 0.0 AND 100.0),
 RELEASED                     VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CHK_ERP_I_CONTPROD_RELEASED CHECK (RELEASED IN ('Y','N'))
);

ALTER TABLE ERP_I_CONTRACTPRICELIST ADD 
(PRICELISTDESCRIPTION VARCHAR2(50) DEFAULT NULL);
