ALTER TABLE PARAMPLANEJA ADD IDPEREFETFATMPLA VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_IDPEREFETFATMPLA CHECK (IDPEREFETFATMPLA IN ('S', 'N'))
/
ALTER TABLE CLIENFILIAL ADD IDAPURAPEDMYORDER VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE CLIENFILIAL ADD
CONSTRAINT CKC_IDAPURAPEDMYORDER CHECK (IDAPURAPEDMYORDER IN ('S', 'N'))
/
ALTER TABLE ITEMPEDIDOSERV ADD NRREQUEXTR VARCHAR2(10) NULL
/
ALTER TABLE PEDIDOSERV ADD HRFIMEVENTO VARCHAR2(4) NULL
/
ALTER TABLE PEDIDOSERV DROP CONSTRAINT FKMYO00005NOTAFISCAL
/
ALTER TABLE PEDIDOSERV
	ADD CONSTRAINT FKMYO00005NOTAFISCAL FOREIGN KEY(CDFILIAL, NRLANCTONF)
		REFERENCES NOTAFISCAL (CDFILIAL, NRLANCTONF) ON DELETE SET NULL