--Order 20014166.40

----GENERALPRICELIST table----

ALTER TABLE GENERALPRICELIST ADD (CHAIN_ID NUMBER NULL);

ALTER TABLE GENERALPRICELIST ADD (PRICEUPDATELOCKDATE DATE NULL);

CREATE INDEX XIF4GENERALPRICELIST ON GENERALPRICELIST (CHAIN_ID);

ALTER TABLE GENERALPRICELIST
  ADD CONSTRAINT GENERALPRICELIST_CHAIN_ID FOREIGN KEY (CHAIN_ID)
  REFERENCES CHAIN (CHAIN_ID);


----CUSTOMER table----

ALTER TABLE CUSTOMER ADD (INFORMPRICEUPDATE VARCHAR2(1) DEFAULT 'N' NOT NULL
                                            CONSTRAINT YN_VALIDATIONFIELD112 CHECK (INFORMPRICEUPDATE IN ('Y', 'N')));


----PRICELISTPERCUSTOMER table----

ALTER TABLE PRICELISTPERCUSTOMER ADD (PRICEINDEXCODE VARCHAR2(6) NULL);
ALTER TABLE PRICELISTPERCUSTOMER ADD (PRICEUPDATELOCKDATE DATE NULL);


