--Order 20013619.90

ALTER TABLE WASHINGPROCESS ADD (BATCHCARDPIECES NUMBER(4) DEFAULT 0 NOT NULL CONSTRAINT BATCHCARDPIECES_VALID1
                                                CHECK (BATCHCARDPIECES BETWEEN 0 AND 9999));

----BATCH table----

ALTER TABLE BATCH ADD (DELIVERYDATE DATE NULL);
ALTER TABLE BATCH ADD (SEQUENCENUMBER NUMBER(4) DEFAULT 0 NOT NULL CONSTRAINT SEQUENCENUMBER_VALID4
                                      CHECK (SEQUENCENUMBER BETWEEN 0 AND 9999));
ALTER TABLE BATCH ADD (REMARK VARCHAR2(30) NULL);
ALTER TABLE BATCH ADD (INFECTION VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT YN_VALIDATIONFIELD99
                                      CHECK (INFECTION IN ('Y', 'N')));

CREATE INDEX XIE4BATCH ON BATCH (BUSINESSUNIT_ID, DELIVERYDATE, SEQUENCENUMBER);